Manage Fields in MI Strings

Background

If the parameters for 'Payment information', 'End-to-end ID', or 'Instruction ID' are enabled in 'AP Payment Method. Open' (CRS071) or in 'AR Payment Method. Open' (CRS076), the configuration for these parameters are set up in 'Manage Fields in MI Strings. Open' (CRS485).

You can use 'Payment information', 'End-to-end ID', and 'Instruction ID' when payment messages are created using 'Global electronic messages' as described in the configuration guide. For payment messages created using Financial Business Messages (FBM), the usage of the fields depends on the messages and is described in the country configuration guide for the applicable country.

In (CRS485), the string contents for the different types of payment information are defined based on which fields and format to use.

The payment information that is saved is available in the MI programs APS130MI, ARS300MI, and ARS413MI (program related to ARS410MI).

In (CRS485), you can use different settings depending on the MI program.

Program names

  • Program APS130MI – Supplier payment
    For the APS130MI program, you can use different types of information for payment methods with payment class 3='Bank transfer':
    • Payment information
    • End-to-end ID – External ID for payment transactions
    • Instruction ID – Internal ID for payment transactions

    There are also parameters in (CRS071) related to the different types of information.

    The payment information is saved per payee and payment document number in the table (FPSUGI).

  • Program ARS300MI – Bank remittance for direct debiting

    For the ARS300MI program, you can use this type of information for payment methods with payment class 5='Direct debiting': Payment information.

    The payment information is saved per payer and direct debiting number in the table (FARREI).

  • Program ARS410MI – Remittance of direct debiting and factoring
    For the ARS410MI program, you can use different types of information for payment methods with payment class 5='Direct debiting' and 6='Factoring':
    • Payment information
    • End-to-end ID – External ID for payment transactions
    • Instruction ID – Internal ID for payment transactions

    (CRS076) also contains parameters related to the different types of information.

    The payment information is saved per payer and payment document number in the table (FARRPP).

Type of information

  • Payment information

    The setup can be done based on 'Payment method', 'Account' (bank account), 'Language', and 'Number of payments'. The 'Payment method' field is the only required field.

    The 'Number of payments' field indicates the maximum number of invoices per payee and payment document for which the setup for payment information is applicable. The setup with 'Number of payments' set to 0 is used when no setup applicable to the number of invoices in a payment document is found. You must include this setup for each combination of other fields. Otherwise, the payment information is created using the default value 'Supplier invoice number' or 'Customer invoice number' only.

    On (CRS485/E), the decimal format, the string separator, and the field separator are defined. You can also use 'Add blank' for 'String separator' and 'Field separator', which means that a blank space is added after the separator.

    The 'Message exceeded' field indicates a message added in the payment information string when the payment information exceeds. If no message is specified, the payment information string is blank when the number of characters is exceeded.

    Several fields can be added as content of the information string. The description is automatically retrieved from the field when the field is added. A 'Header text' can be added for each field, and the header text is then added to the string. The 'One-time use' field indicates whether to use this field in the first string only, and not in the following strings within the same payment. The field 'Edit code' indicates how the values are presented.

  • End-to-end ID – External ID for payment transactions

    'End-to-end ID' indicates a unique identification for a payment transaction. If possible, depending on the bank format, the ID is sent to the supplier to identify the payment. If supported by the bank format, the ID is sent back to the company through the bank statement.

    You must define 'End-to-end ID' in (CRS485) for payment method (required) with 'bank account ID' and 'language' as optional fields.

    Depending on the setting in (CRS071) or (CRS076) for 'End-to-end ID', the information is created differently:

    • If alternative 1 is used, a standard value containing payment proposal number, order number, and document number is used.
    • If alternative 2 is used, the user-defined value is configured in (CRS485).
    • If a configuration is missing in (CRS485), the default values are used.

    The information is updated as additional information number 466 in Accounts Payable (the FPLEDX table) and in Accounts Receivable (the FSLEDX table) as additional info number 266. The information can later be used for allocation in the Automatic Bank Statement (ABS) functionality.

  • Instruction ID for payment transactions

    'Instruction ID' indicates an identifier for a payment transaction and can be used for reconciliation on the company side. It is normally not sent to the supplier. If supported by the bank format, the ID is sent back to the company through the bank statement.

    You must define 'Instruction ID' in (CRS485) per payment method (required) with a 'bank account ID' and 'language' as optional fields.

    Depending on the setting in (CRS071) or (CRS076) for 'Instruction ID', the information is created differently:

    • If alternative 1 is used, a standard value containing payment proposal number, order number, document number, and payee or payer ID is used.
    • If alternative 2 is used, the user-defined value is configured in (CRS485).
    • If configuration is missing in (CRS485), the default values are used.

    The information is updated as additional information number 467 in Accounts Payable (the FPLEDX table) and in Accounts Receivable (the FSLEDX table) as additional info number 267. The information can later be used for allocation in the Automatic Bank Statement (ABS) functionality.

  • Common settings for End-to-end ID and Instruction ID

    On (CRS485/E), the 'Field length' is set. The field indicates the maximum number of positions that can be used for the selected field. The number of positions depends on the payment message, but the overall maximum number of positions is limited to 45 since the information is stored as additional information in Accounts Payable or Accounts Receivable. On the same panel, the 'string separator' and the 'field separator' are defined. You can also use 'Add blank' for the 'string separator' and the 'field separator', which means that a blank space is added after the separator.

    The 'Only first' field indicates that information from the first invoice is included only.

    If the 'Truncate info' is selected, the information selected for the payment ID should be truncated in case the maximum field length is exceeded.

    Several fields can be added as content of the information string. The description is automatically retrieved from the field when the field is added. A header text can be added for each field, and the header text is then also added to the string.

    The 'And/or' field is used to create a condition to retrieve one and/or another value to be included in the information.

    The 'Exclude non-numeric characters' field indicates whether non-numeric characters should be excluded. An example of this is an invoice number that contains letters.

    The field 'Trim zeroes' can be enabled to remove leading zeroes for numeric values.

    The 'Left' or 'right' field indicates if the characters should be counted from the left or from the right.

    The 'No. of characters' field indicates how many characters are allowed, up to 99.

    'Default if zero/blank' indicates a default value used if the found value is zero or blank or if the object &DFLT is selected. The field is not used when the condition 'And/or' is set to 'Or'.

    The permitted fields for 'End-to-end ID' and 'Instruction ID' are retrieved from the field group 'CRAP2' for APS130MI and 'CRAR3' for ARS410MI in 'Field Group. Display Permitted Fields' (CRS109).

    If a user-defined configuration is set up in (CRS485), but no information is found for the selected field, for example invoice reference field 1, no 'End-to-end ID' or 'Instruction ID' is created.

Details per function

  • Handling in 'Suppl Payment Proposal. Open' (APS130)

    The 'Payment information', 'End-to-end ID', and 'Instruction ID' are created when the related option 8='Preliminary/copy' or 9='Confirm' is used in (APS130). The information is updated in the field 'Text' (P2TEXT) in the table (FPSUGI).

    If the setup in (CRS485) is changed and the payment proposal is still in status 1, the payment information can be recreated using related option 8 in (APS130). If a payment proposal is deleted, the payment information is also deleted.

    If the parameter for 'Payment information', 'End-to-end ID' or 'Instruction ID' is disabled in (CRS071), this does not affect an existing payment proposal. This means the information in the FPSUGI table is not deleted or updated because of the change.

    The information is not displayed in M3, but can be retrieved using the MI program APS130MI, transaction 'LstInvByPayDoc' with the input field 'TAGG' set to these values:

    • Blank for the 'Payment information'
    • EndToEndID (the value ENDTOENDID is also accepted) for the 'End-to-end ID'
    • InstructID (the values INSTRUCTID, InstructionID, and INSTRUCTIONID are also accepted) 'Instruction ID'.
  • Handling in 'Bank Remittance. Open' (ARS300)

    The 'Payment information' is created when the related option 8='Preliminary/copy' or 9='Confirm' is used in (ARS300). The information is updated in the field 'Text' (R3TEXT) in the table (FARREI).

    If the setup in (CRS485) is changed and the remittance proposal is still in status 1, the payment information can be recreated using the related option 8 in (ARS300). If a remittance proposal is deleted, the payment information is also deleted.

    If the parameter 'Payment information' is disabled in (CRS076), this does not affect an existing remittance proposal, which means that the information in the table (FARREI) is not deleted or updated due to the change.

    The payment information is not displayed in M3, but can be retrieved using the MI program ARS300MI, transaction 'LstPayInfByDir', with the input field 'TAGG' left blank.

  • Handling in 'Remit Direct Debit and Factoring. Open' (ARS410)

    The 'Payment information', 'End-to-end ID', and 'Instruction ID' are created when the remittance proposal is created in (ARS410). The information is recreated when the related option 8='Preliminary/copy' or 9='Confirm' is used in (ARS410) for a remittance proposal with status 20-'New'. The information is updated in the field 'Text' (R3TEXT) in the table (FARRPP).

    If the setup in (CRS485) is changed and the remittance proposal is still in status 20, the information can be recreated using related option 8 in (ARS410) or action F14-'Re-create payment information' for a single document in 'Remit Dir Deb and Factr. Upd Pmt Info' (ARS413). If a remittance proposal is deleted, the payment information is also deleted.

    If the parameter for 'Payment information', 'End-to-end ID', or 'Instruction ID' is disabled in (CRS076), this does not affect an existing remittance proposal, which means that the information in the table (FARRPP) is not deleted or updated due to the change.

    The information is displayed in (ARS413) and can also be retrieved using the MI program ARS413MI, transaction 'Get' or 'Lst' with the input field 'TAGG' set to these values:

    • Blank for the 'Payment information'
    • EndToEndID for the 'End-to-end ID'
    • InstructID for the 'Instruction ID'

Limitations

The usage of 'Payment information', 'End-to-end ID', or 'Instruction ID' depends on the format for the electronic message. See the country configuration guide for the applicable country.

Before you start

Set up the parameters for 'Payment information', 'End-to-end ID' and 'Instruction ID' in (CRS071) or (CRS076) depending on the payment message used.

Follow these steps

  1. Select the 'Type of information' for 'Payment information', 'End-to-end ID', or 'Instruction ID' to create new records in 'Manage Fields in MI Strings. Open' (CRS485).
  2. On panel E of (CRS485), select the fields to include in the information string. Then, select the formats to use, such as the string separator, field separator, and so on.
  3. Create and process a proposal in (APS130), (ARS300), or (ARS410) to validate the 'Payment information', 'End-to-end ID', or 'Instruction ID' as described for the applicable function in this document.
Related topics