Bank statement import - Implementation
Prerequisites
Set up the Coded Statement of Account (CODA) statement format
To import CODA statements, the format of the CODA statement must be set up:
Setup>A/P-A/R Accounting>Bank files.
Name of the format provided as standard: BERLVCODA.
The bank code must be blank in the BERLVCODA bank file definition (unique format for all banks).
Set up the Belgian bank statement sequence number counter
For the bank statement to use sequential numbers upon creation or import of the Belgian statement, the BERBK counter must be set up:
Setup>General parameters>Sequence number counters>Assignment.
For each Belgian BP/Company module pair
- Line 6 - bank statement must be set up with the BERBK sequence number counter.
Note:The definition of the BERBK sequence number must not be modified. It guarantees consistent controls when importing a CODA statement regarding its opening amount/date versus the previous statement.
Settings required to determine remittance notes automatically
During the import, the reconciliation of remittances in an intermediate posting, such as a SEPA payment or FOREX customer payment, can be performed automatically.
To determine the remittance note number, the internal reference defined in record 22 must be read. This internal reference is subdivided into two blocks of 13 characters containing the payment numbers associated with the remittance note. It is mandatory, therefore, that sequence numbers of Belgian payment transactions are limited to 13 characters:
Setup>General parameters>Sequence number counters>Assignment.
For each Belgian BP/Company module pair:
- Line 1 - Expenditure payment must be set up with a sequence number counter with a maximum length of 13 characters.
- Line 2 - Revenue payment must be set up with a sequence number counter with a maximum length of 13 characters.
Settings required to automatically determine the VCS sales/customer BP invoices
During the import it is possible to automatically determine the sales and customer BP invoices using the VCS no. provided in record 21 when the communication type is 101. The VCS number (Structured-communication Transfer) is unique.
For the VCS number to be generated on sales/customer BP invoices in Sage X3, the value of the BELVCS - VCS management parameter must be activated at the Belgian legislation level.
Settings required to automatically determine the business partner
During the import, the CODA statement transfers the bank ID number or IBAN of the supplier or customer to record 23.
The bank ID number of supplier or customer records must be set up to enable this automatic transfer.
Settings required to generate debtor/creditor type payments of the bank charges type
The debtor/creditor are payments with no BP allocated to a general account of charge or commission type.
For these payments to be generated, an address must be set up in the general accounts that can be allocated via the management function of Belgian bank statements (the Address field is mandatory upon payment creation).
These accounts are, for example, those that are set up in the CODA sections.
Settings required to view structured communications
To view the structured communication, communication types must be defined. (The main communication types are provided as standard.)
Settings required to automatically determine the accounting destinations and account allocation
Coda sections must be defined.
Activity codes
The following activity codes (sorted by type) may have an impact on the way the function operates :
KBE :
Belgian localization