Cash receipts
Requirement
For the effective management and allocation of customer payments that are related to open invoices, a file from the bank or an electronic bank statement can be used.
M3 solution
The Automatic Bank Statement functionality in M3 is used to manage bank statements based on the received bank statement file. The bank statement lines can then be automatically allocated to customer invoices and supplier invoices.
The camt.053 and camt.054 formats, in accordance with the ISO 20022 standards, and the NETS LS format are supported.
The electronic messages for feedback of paid invoices are delivered with this country version. For this country version, these messages have been adapted, as made available in Infor Localization Services GEMS, ‘Bank Statement Messaging - 100010’:
- 'XC – Bank Statement camt.053.001.02'
- 'DK - Bank Statement Danske camt.054.001.02'
- 'DK – Bank Statement NETS LS'
Configuration guidelines
| Program ID | Program name | Description or comment |
|---|---|---|
| CRS395 | Accounting Rule. Set | Configure the accounting rules for events AB10, AR30, and AP20. |
| CRS405 | FAM Function. Open | Configure functions AB10, GL01, AR30, and AP20. |
| CRS108 | Field Group. Open | To generate the standard field groups, select . |
| CRS109 | Field Group. Display Permitted Fields | To generate the standard fields, select for the ABUS1 field group. |
| CMS016 |
Available Object Ctrl Parameters. Open |
To generate the standard object control parameters, select . |
| CMS017 | Generic Object Control Table. Open |
Set the fields to be used for defining payment variances. To open (CMS017), you must first select the relevant ABS records. For example, select ABS920 or ABS910, then . |
| ABS920 | Payment Variance Limit. Define | Based on the fields set in (CMS017), set the prioritization of the business transaction codes. |
| CRS692 | Bank Account. Open |
A record for type 1-Company bank account must exist. If the Cust bank acc field (customer bank account) is set to 2-Yes, manual update in (ABS900), then records for type 2-Customer bank account must exist. If the Suppl bnk acc field (supplier bank account) is set to 2-Yes, manual update in (ABS900), then records for type 3-Supplier bank account must exist. |
| ABS010 | Transaction Type. Open | For settings that are specific to the message 'DK - Bank Statement NETS LS', see the Infor M3 Core Configuration Guide for Infor Localization Services GEMS. |
| ABS911 | Scenario Number. Open |
Create the scenarios for the bank transaction that a statement line refers to, for example a scenario in which an invoice is searched. For settings that are specific to the message 'DK - Bank Statement NETS LS', see the Infor M3 Core Configuration Guide for Infor Localization Services GEMS. |
| ABS910 | Scenario Number. Prioritize | Set the prioritization of the scenario numbers. |
| ABS930 | Additional Information. Structure | This program is used to improve the efficiency of the search for the appropriate invoices. This program can be set at a high level for all invoices or for specific ranges of invoices. |
| ABS920 | Payment Variance Limit. Define | You can prioritize the business transaction codes. |
| ABS900 | Bank Account Identifier. Open |
See the Infor M3 Core Configuration Guide for Infor Localization Services GEMS at https://docs.infor.com/m3core/latest/en-us/integrationlib_cloud/default.html?helpcontent=m3cecorelclgemscg/cover.html for the detailed configuration guidelines required for the upload of the electronic message. |
| ABS100 | Bank Statement. Open | Set the Release manually allocated
invoices (Rel man all inv) field on the
settings in (ABS100) as required. To change this, select
. Validate the received statement. |
See the Infor M3 Core Configuration Guide for Infor Localization Services GEMS for the detailed configuration guidelines for the applicable message.