Summarizing Payment Lines and General Journal Lines

Business Central summarizes payment lines and journal line across the following types of payments:

  • Domestic payments
  • International payments
  • SEPA payments
  • Non-euro SEPA payments

How Payment Journal Lines are Transferred to the General Journal

When you export the payment journal lines to a file, Business Central transfers the payment journal lines to the specified general journal. By default, a general journal line is created for each payment journal line.

The following two fields on the Electronic Banking Setup page affect how the payment lines are summarized:

  • Summarize Gen. Jnl. Lines
  • Cut off Payment Message Texts

If you have selected the Summarize Gen. Jnl. Lines check box on the Electronic Banking Setup page, Business Central summarizes all payment journal lines for a specific vendor into one general journal line. The general description "Payment %1," where %1 is the vendor number, is used for the summarized journal line description. A separate payment line and a separate general journal line are created to handle:

  • Payment journal lines that contain partial payments, with both the Partial Payment and the Separate Line fields selected.

  • Payment journal lines that contain a standard format message (passes the MOD97 test), which sets Standard Format Message to True in the electronic banking journal.

Example 1

In this example, you export payment lines, and the Summarize Gen. Jnl. Lines check box is selected. Business Central creates:

  • One combined payment line in an XML file that has a concatenated payment message. White space is the delimiter.
  • One payment line in the general journal with a generic description that includes the vendor name.

Example 2

In this example, you export payment lines, and the Summarize Gen. Jnl. Lines check box is selected. The Cut off Payment Message Texts check box is cleared, and the combined SEPA and non-euro SEPA payment lines exceed 140 characters in the payment message. Business Central creates:

  • Two combined payment lines in an XML file. The first payment line contains the first concatenated payment messages. The second payment line contains the payment message from the third line.

  • One payment line in the general journal with a generic description that includes the vendor name.

Example 3

In this example, you export payment lines, and the Summarize Gen. Jnl. Lines check box is selected. The Cut off Payment Message Texts check box is also selected, and the combined SEPA and non-SEPA payment lines exceed 140 characters in the payment message. Business Central creates:

  • One combined payment line in an XML file that has two concatenated payment messages. An ellipsis (…) is used to indicate that the message is truncated.

  • One payment line in the general journal with a generic description that includes the vendor name.

Based on the XML structure, the payments are summarized per account number, beneficiary bank account number, and bank account number. The bank account filter can be empty.

The EndToEndId in the SEPA message is taken from the payment message and can be truncated to the maximum length of 45 characters.

See Also

Set Up Electronic Banking
Setting Up Finance
Record Purchases