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.

The limitations for adding payment reference are:

  • 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) do 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) contain 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 The field indicates …
CMS090/B Reference number type … the reference number type. There are two reference number types of 'Parallel invoice number' available:

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).

CMS090/B Payment method AR …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 country code of the payer as defined in 'Customer. Open' (CRS610). This field is optional.
CMS090/E Reference number rule … a short description used for identification of a rule, for example, OCR, and KID.
CMS090/E Description … a description of the rule.
CMS090/E Name … a short description of the rule.
CMS090E Reference object … objects that is 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.
The valid reference objects are:
  • &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 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 … 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 … 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 which 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 … 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

  1. Set up the additional payment reference in (CMS090) for the actual payment method and the payer country (optional).

  2. Create a customer invoice, for example, in 'Customer Invoice. Enter Manual' (ARS120) with the setup used in step 1.

  3. The parallel invoice number is updated in 'Customer Invoice. Change' (ARS201).

  4. If the parallel invoice number is included in the XML of the invoice, it should be updated there as well.