Balance Export - Implementation
Prerequisite
Control accounts must be defined over a maximum of nine characters.
If the option Sum of individual balances is used, the interface creates two lines:
- the first line contains the total of the creditor balances on an account composed of the control account number followed by a C,
- the second line contains the total of the debtor balances on an account composed of the control account number followed by a D.
Activity codes
The following activity codes (sorted by type) may have an impact on the way the function operates :
LIA :
Report
General parameters
The following general parameters may change the way the function is working :
Accounting
EXPBAL (defined at level Folder) : Balance export
Authorizations
An authorization can be granted for this function to limit the processes to a company or a site.
Tables used
No table is used by this function.
Technical appendices
Some formatting parameters are hard-coded in the processing; They correspond to local variables.
The INIT entry point is included in the EXPBAL script: it can be used to reassign the relevant variables.
Variable |
Usage |
Default values |
Signification |
SEPCH |
Separator between the exported fields |
chr$(9) |
TAB character |
SEPENR |
Line separator |
chr$(13)+chr$(10) |
Carriage Return, Line Feed characters |
NAM |
Expression calculated from the name of the created file |
"[F :CPY]CPY”+num(year([M:DIA]DATDEB))” |
The company code followed by the year of the extraction start |
EXT |
Extension of the created file |
"bal" |
the bal characters. |
POINT |
Decimal separator used in the amounts |
"." |
The dot |