Clausion DR Functions
Inserting Clausion DR functions
In the Formulas menu, click Insert Function (in desktop version, click Insert DR Function). An Insert Function dialogue box similar to the Excel function dialogue box opens. The following functions are available:
CLAUSION.DRACCOUNTDCCODE (in desktop version DRAccountDCCode): Retrieves the debit/credit code of an account from the Clausion database. The debit value is 1 and credit value -1.
CLAUSION.DRACCOUNTNAME (in desktop version DRAccountName): Retrieves the name of an account in the selected language from the Clausion database.
CLAUSION.DRCURRENCYRATE (in desktop version DRCurrencyRate): Retrieves the currency rate for the selected combination (currency, rate type, data type, year, period).
CLAUSION.DRDATA (in desktop version DRData): Retrieves data for the selected combination (datatype, document series, account, year, period, periodic/cumulative, currency, unit(D0_unit-Dxx_unit), counter unit(D0_CoUnit- DXX_CoUnit), hierarchy(D0_Hier-Dxx_Hier), dimension extra field (D0EF- DXEF)) from the Clausion database. If something is incorrect in the entered argument values (for example, the value cannot be found from the database or you do not have sufficient rights to retrieve the data), the result of the function will be 0. You can also filter data using dimension extra field values.
CLAUSION.DRDATATYPENAME (in desktop version DRDatatypeName): Retrieves the name of a valid data type in the selected language from the Clausion database.
CLAUSION.DREXTRADATA (in desktop version DRExtraData): Returns data type's extra field value for the selected combination (data type, document series, year, account, extra field). If this results in several values for a text type extra field, the values are combined into one cell as consecutive values, separated by a delimiter.
CLAUSION.DRUNITCURRENCY (in desktop version DRUnitCurrency): Returns the currency code of a unit from the Clausion database.
CLAUSION.DRUNITNAME (in desktop version DRUnitName): Returns the unit name in the selected language from the Clausion database.
More information about the functions and their arguments is shown in the Insert Function dialogue box.
The following sections include lists of DR functions based on their arguments.
Note: ID and string must be written in quotes ("300000P").
Note: Arguments in DR functions can be cell references but cannot be other functions or contain concatenations ("&" character).
Note: To get fastest results use as little DR functions as possible by using cell references.
Note: An empty cell cannot be referenced as an optional argument. This will produce an error.
Note: To get default balances as positive (Show DK: No) you may use product of CLAUSION.DRACCOUNTDCCODE and CLAUSION.DRDATA (example below).
Examples
To make the example work in Excel, delete the apostrophe (') from the beginning of the cell.
Note: Use correct separator for function arguments (',' or ';')
=CLAUSION.DRDATA("ACT";"10000;20000";"979989P";"2019";"12";TRUE;"EUR";"UNIT1";;;;;;;;;;;;;;;;;;"E01=Europe")
=CLAUSION.DRACCOUNTDCDODE("994989P")
=CLAUSION.DRACCOUNTNAME("994989P";"EN")
=CLAUSION.DRCURRENCYRATE("USD";"OPENING";"ACT";"2024";"0")
=CLAUSION.DRDATATYPENAME("ACT";"EN")
=CLAUSION.DREXTRADATA("ACT";"10000;20000";"979989P";"2024";"E02";"UNIT1")
=CLAUSION.DRUNITCURRENCY("DIM00";"UNIT1";"2024")
=CLAUSION.DRACCOUNTDCCODE("979989P")
*CLAUSION.DRDATA("ACT";"10000;20000";"979989P";"2023";"12";TRUE;"EUR";"UNIT1")
Note: The operation of the functions also depends on the environment. For example, if the account is not found in the customer's system, the query returns value zero.