SUBRAB script: Bank statement reconciliation @ L.V. Expertise X3

BEFWRIRBK: Before write to the RELBANK table

This entry point is used to insert additional logic just before the write to the RELBANK table in order to modify the value of certain fields in the table or to initialize specific/custom fields that have been added.

Context and operating mode

Transaction

There is one transaction in progress.

Log file

There is no open log file.

Different call cases

This entry point is called immediately before writing to the RELBANK [RBK] table. Two ‘Rewrite [RBK]’ are made in the bank reconciliation program.

One rewrite is used to manage a reconciled line where the CHK, DATCHK and VALDAT fields are updated in strandard.

- CHK: calculated reconciliation code

- DATCHK: date$ instruction

- VALDAT: information entered in the mask.

The second rewrite is used on lines where VALDAT and/or BANDAT have been modified. In standard, only the VALDAT field is updated.

Available variables and masks

The RAPBAN1 mask is available and the ‘i’ variable includes the index of the relevant table line.

The reconciled line is identified by the condition applying to the field [M]CHK(i) (first Rewrite context) and the modified line (modified VALDAT and/or BANDAT fields) is identified by the [M]CHGDAT(i) =1 condition (second Rewrite context).

Open tables

Table	Significant content	Table title
COMPANY	X	Companies
BANK	X	Bank accounts
RELBANK	X	Bank account statements
GACCENTRY		Accounting entry headers
GACCENTRYD		Accounting documents lines

BEFWRIDAE: Before write to the GACCENTRYD table

This entry point is used to insert additional logic just before the write to the GACCENTRYD table in order to modify the value of certain fields in the table or to initialize specific/custom fields that have been added.