SUBRAB script: Bank statement reconciliation
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.
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 GACCENTRYD [DAE] table.
When the line is reconciled, in standard, the CHK and CHKDAT fields are updated.
- CHK: calculated reconciliation code
- CHKDAT: date$ instruction
Available variables and masks
The RAPBAN1 mask is available and the ‘i’ variable includes the index of the relevant table line.
Open tables
Table |
Significant content |
Table title |
COMPANY |
X |
Companies |
BANK |
X |
Bank accounts |
RELBANK |
|
Bank account statements |
GACCENTRY |
|
Accounting entry headers |
GACCENTRYD |
X |
Accounting documents lines |