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.

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.

M3 has functionality to process customer debit notes as required in this country. When a customer sends their own debit note with a part payment, if disputing a debt, then this debit note reference must be reflected in their M3 customer statements. This customer dispute must also be managed, until it is resolved with a credit note, billback, and credit memo.

Enterprise Collaborator configuration guidelines


Program ID	Program name	Description or comment
CRS116	Document Media. Open	Create the settings for media category 06-MBM initiator. Connection with ‘Output Service Type. Connect Media’ (MNS214).
MNS214	Output Service Type. Connect Media
MNS218	Output Server. Open	Specify the correct server details. Connection with Output Service.
MNS217	Output Service Type. Open	Create a record for interface XMLOUT. Connection with Output Service.
MNS216	Output Service. Open

Configuration guidelines


Program ID	Program name	Description or comment
CRS395	Accounting Rule. Set	Configure 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. Note: 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	Records for these bank account types must exist: Company bank account, of type 1 Customer bank account, of type 2 Supplier bank account, of type 3
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.