In this document, the Excel Add-in functions have been grouped as follows: General, General ledger/Financial, Accounts receivable/Accounts payable, Order and Invoice, Inventory, Human resources, and Project. Using Ctrl-F, you can find the name of a function or another key word. The hyperlinks link to further explanation about the selected function.
General
Function
Result
CO_DATA
Content of the fields in the administration information file
FILE_FIELD
Retrieving fields from the database
FILE_FIRST
The first record from a file
FILE_NEXT
The next record from a file
IS_HIDDEN
Value = 'TRUE': the cell is hidden; value = 'FALSE': the cell is visible < /FONT >
HR_DATA
Include the field value of a Resource (Personnel).
General ledger/Financial
ACC_BAL
Balance of an account or a series of accounts
ACC_BAL_DATE
Balance of an account or a series of accounts based on date
ACC_DATA
Content of the fields in the general ledger account file
BUDGET_CC
Budget balance of a cost center per general ledger account, sub-classification or classification
BUDGET_CU
Budget balance of a cost unit per general ledger account, sub-classification or classification
BUDGET_BAL
Budget balance of a budget per general ledger account, cost center or cost unit
CC_BAL
Balance of a cost center per account or series of accounts
CC_BAL_DATE
Balance of a cost center on date per account or series of accounts
CC_DATA
Content of the fields in the cost units file
CC_MAIN_CLASS
Balance of a cost center per classification or series of classifications
CC_MAIN_CLASS_DATE
Balance of a cost center on date per classification or series of classifications
CC_SUB_CLASS
balance of a cost center per sub-classification or series of sub-classifications
CC_SUB_CLASS_DATE
Balance of a cost center on date per sub-classification or series of sub-classifications
CU_BAL
Balance of a cost unit per account or series of accounts
CU_BAL_DATE
Balance of a cost unit on date per account or series of accounts
CU_DATA
CU_MAIN_CLASS
Balance of the cost unit per classification or series of classifications
CU_MAIN_CLASS_DATE
Balance of a cost unit on date per classification or series of classifications
CU_SUB_CLASS
Balance of a cost unit per sub-classification or series of sub-classifications
CU_SUB_CLASS_DATE
Balance of a cost unit on date per sub-classification or series of sub-classifications
CURR_CODE_DATA
Content of the fields in the currency code file
CURR_INFO
Standard or secondary currency code
EXCHANGE_RATE
Exchange rate that corresponds to a currency code
GL_BAL
Balance of a cost center and cost unit per general ledger account or series of general ledger accounts
GL_BAL_DATE
Balance of a cost center and cost unit on date per general ledger account or series of general ledger accounts
GL_TRANS
Balance of all the transactions on a general ledger account
GL_TRANS_DATE
Balance of all the transactions on a general ledger account by date
MAIN_CLASS_BAL
Balance of a classification or a series of classifications
MAIN_CLASS_BAL_DATE
Balance of a classification or a series of classifications on date
MAIN_CLASS_DATA
The content of the fields in the classifications file
SUB_CLASS_BAL
Balance of a sub-classification or a series of sub-classifications
SUB_CLASS_BAL_DATE
Balance of a sub-classification or a series of sub-classifications by date
SUB_CLASS_DATA
The content of the fields in the sub-classifications file
Accounts receivable/Accounts payable
CRD_DATA
Content of the fields in the creditors file
CRD_OUTSTAN_ALL
Information about all the outstanding items that are less than a specified number of days old
CRD_OUTSTANDING
Information about one outstanding item
DEB_DATA
Content of the fields in the debtors file
DEB_OUTSTAN_ALL
DEB_OUTSTANDING
Order and Invoice
ITEM_DATA
Include the field value of an item in the worksheet
ITEM_DELIVERY
Include the delivery time for an item in the worksheet
ITEM_GROUP_DATA
Include the field value of an item group in the worksheet
STOCK_INFO
Include stock positions of an item in the worksheet
REV_DEBTOR
Revenue statistics per debtor and/or representative
REV_DEBTOR_FY
Revenue statistics per debtor and/or representative, whereby a selection can be made on financial year
REV_GROUP
Information about revenue statistics from the administration
REV_GROUP_FY
Information about revenue statistics from the administration, whereby a selection can be made on financial year
REV_ITEM
Revenue statistics per item and/or debtor
REV_ITEM_FY
Revenue statistics per item and/or debtor, whereby a selection can be made on financial year
Project
PROJ_DATA
Include the field value of a project in the worksheet
PROJ_FIN_DATA
Include financial information about a project in the worksheet
PROJ_LEDGER
Include transactions per project general ledger account in the worksheet
PROJ_TOTAL_EMP
Include transaction totals per employee in the worksheet
PROJ_TOTAL_MACH
Include transaction totals per material unit in the worksheet