Customer payment processing

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.

In this country, this file takes the format of an electronic bank statement.

M3 solution

ABS100MI is used by Infor Enterprise Collaborator to update the main M3 files for managing bank statements based on the received bank statement file. The bank statement lines can then be automatically allocated to customer and supplier invoices.

In the future, the electronic bank statement messages will be delivered for this country version.

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 Actions > Gen data.
CRS109	Field Group. Display Permitted Fields	To generate the standard fields, select Actions > Standard for the ABUS1 field group.
CMS016	Available Object Ctrl Parameters. Open	To generate the standard object control parameters, select Actions > Gen data.
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 Related > Ob tbl det lin.
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.
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.
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
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 Actions > Settings. Validate the received statement.