Functions

This paragraph details the functions and parameters as used in the Excel Add-in. The functions are ordered alphabetically. For a report on all parameters, see [Alphabetical overview of parameters].

! In the examples no quotation marks are included, because these are added automatically when you use the function wizard.

! You need to use quotation marks when you enter an account number that starts with a zero.

• ACC_BAL
• ACC_DATA
• BDG_LCC
• BDG_LCCR
• BDG_LCU
• BDG_LED
• CC_BAL
• CC_DATA
• CC_MAIN_CLASS
• CC_SUB_CLASS
• CO_DATA
• COMM_BAL
• CRD_DATA
• CRD_OUTSTAN_ALL
• CRD_OUTSTANDING
• CU_BAL
• CU_DATA
• CU_MAIN_CLASS
• CU_SUB_CLASS
• CURR_CODE_DATA
• DEB_DATA
• DEB_OUTSTAN_ALL
• DEB_OUTSTANDING
• EXCHANGE_RATE
• GL_BAL
• GL_TRANS
• MAIN_CLASS_BAL
• MAIN_CLASS_DATA
• SUB_CLASS_BAL
• SUB_CLASS_DATA

See also:

[Alphabetical overview of parameters]