Additional payment reference

The rules for setting up a rule for 'Parallel invoice number' that you can create for customer invoices are defined in 'Additional Payment Reference. Open' (CMS090). The available reference number type that you can maintain in (CMS090) is 1='Parallel invoice number'. You can only add the parallel invoice number to the XML when an invoice document is created. The parallel invoice number is saved in the FSAPRN table with the invoice number.

These are the limitations for adding a payment reference:

If the invoice number (CINO) is used as the object in the parallel invoice number, and if a check digit is to be calculated, then you cannot use an invoice prefix that contains letters.
Invoices created from a payment plan in 'Payment Plan. Open' (ARS390) does not have this functionality.
The parallel invoice number is only created when you create an invoice document, and is only then included in the XML.
You can only use numeric fields in the parallel invoice number setup in (CMS090) if a check digit is to be calculated.
This function is only available for payment classes 0 (cash), 3 (bank transfer), 5 (direct debiting), and 6 (factoring).
You cannot carry out partial payments for a split AP or AR invoice in ABS when using parallel invoice numbers to allocate the payments.
If customer number (CUNO) or payer number (PYNO) contains alpha or alphanumeric characters, these are converted to zeros (0). If PYNO has a different setup in (CMS090) to CUNO, then the PYNO setup overrides the CUNO setup.

Parameters to set


Program ID/Panel	Field	Description
CMS090/B	Reference number type	The field indicates the reference number type. These are the reference number types of 'Parallel invoice number': 1 = The parallel invoice number is created for customer invoices using a combination defined in (CMS090). 2 = The parallel invoice number is issued by a government or authority. It is maintained in 'Invoice Header. Open' (CMS500) and in the parallel invoice number table (FSAPRN). The government number series and government invoice number in (CMS500) are combined to form the parallel invoice number (PAIN). 3 = The parallel invoice number is the external invoice number approved by the authority and displayed in 'Inv Number Alloc After Approval. Open' (CMS550), if the invoice number approval functionality is activated on 'Settings – Invoice Numbering Rule' (MFS167/E). The external invoice number is set based on the setup in (MFS167), 'Invoice Number Series. Define Fixed Prfx' (MFS169), and 'Internal Invoice Series. Open' (MFS165), and can be used as a parallel invoice number for payment processing in 'Payment Received. Record' (ARS110) and 'Bank Statement. Open' (ABS100).
CMS090/B	Payment method AR	The field indicates the payment method used as a general sorting key for similar routines when handling customer payments. Payment methods for Accounts Receivable are defined in (CRS076). Each payment method is connected to a payment type, an ID used to classify different payment methods. The payment type is, in turn, connected to a payment class, which is a general designation for a category of payments, for example, Cash or Draft. For 'Parallel invoice number' only payment class 0 (Cash), 3 (Bank Transfer), 5 (Direct Debiting), and 6 (Factoring) are valid. This field is mandatory.
CMS090/B	Country	The field indicates the country code of the payer as defined in 'Customer. Open' (CRS610). This field is optional.
CMS090/E	Reference number rule	The field indicates a short description used for identification of a rule, for example, OCR, and KID.
CMS090/E	Description	The field indicates a description of the rule.
CMS090/E	Name	The field indicates a short description of the rule.
CMS090E	Reference object	The field indicates objects that are used to build the reference number, for example, a customer invoice number or a numeric division number. You can also add numeric values manually. This value is then added as a hard-coded value in the 'Parallel invoice number' every time the reference is created using this rule. These are the valid reference objects: &CHKD – Check digit: The check digit is placed last in the parallel invoice number. Several different methods are available for check digit calculation. &FXNUM - Fixed numeric constant: A numeric constant used in any order in the reference number. The constant is defined in the 'Description' field. &FXTXT – Fixed text string: An alphanumeric string used in any order in the reference number. The string is defined in the 'Description' field. You cannot use this reference object with check digit calculation. CSCONO – Company: The company number. CSNUDI – Numeric division: A numeric division is used if the current division number is alphanumeric. ESCINO – Invoice number: Invoice number of the invoice created. ESINYR – Invoice year: Invoice year of the invoice created. ESPYNO – Payer: If the payer number is alphanumeric, then the payer number is converted to numbers.
CMS090/E	Field length	The field indicates the length of the reference object field. The field's length is automatically retrieved, but can be manually overruled. If the value is set manually, the length is calculated from right to left. An example could be the company number. If the company number is '001', then you can set the field length to '1', and then the zeroes are skipped, and the retrieved company number is '1' in the reference number.
CMS090/E	Numeric division	The field indicates a numeric division number that is used if the current division number contains letters. A numeric division number is required to calculate a check digit in the 'Parallel invoice number'. The numeric division is mandatory if it is included as a reference object in the reference rule.
CMS090/E	Check digit method	The field indicates which check digit method to use when calculating the check digit in a reference number such as a 'Parallel invoice number'. An example of this is the Modulus 10 method which is used in Sweden and Norway and the 7-3-1 method which is used in Finland. If a check digit is to be calculated, then no letters can be used in the fields that the 'Parallel invoice number' consists of (invoice prefix for instance). The check digit methods are predefined in the field group CRNU2.
CMS090/E	Reference number length	The field indicates which length the reference number should have, up to a maximum length is 60 characters. The length is also controlled when the reference number objects are added to the reference number. An error message appears if the total length of the objects does not match the reference number length.

Follow these steps

Optionally, set up the additional payment reference in (CMS090) for the actual payment method and the payer country.
Create a customer invoice, for example, in 'Customer Invoice. Enter Manual' (ARS120) with the setup used in step 1.
The parallel invoice number is updated in 'Customer Invoice. Change' (ARS201).
If the parallel invoice number is included in the XML of the invoice, it must be updated there as well.