Customer payment processing

Requirement

To efficiently manage and allocate customer payments associated with outstanding invoices, you can utilize a bank file or an electronic bank statement. These sources of information can provide the necessary data for effectively tracking and reconciling customer payments with their respective invoices.

M3 solution

A BOD is created, based on the received bank statement file, by Infor Localization Services GEMS. Infor Enterprise Collaborator (IEC) and the ABS100MI program are then used by the BOD to update the main M3 files for managing bank statements. The bank statement lines can then be automatically allocated to customer and supplier invoices

For this country version, these messages have been adapted, as made available in Infor Localization Services GEMS, ‘Bank Statement Posting & Automatic Reconciliation -100010’: XC - Bank Statement MT940.

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	See Infor M3 Core Configuration Guide for Infor Localization Services GEMS 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 Actions > Settings. Validate the received statement.

See the Infor M3 Core Configuration Guide for Infor Localization Services GEMS for the detailed configuration guidelines for the applicable messages.