Financials > Interfaces > Balance export > 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.

SEEINFO 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