List of ER functions in the business domain–specific category

Electronic reporting (ER) domain-specific functions can be used to perform calculations and data access requests that are specific to the implementation of Microsoft Dynamics 365 Finance. This article provides a summary of these functions.

List of supported functions

Function	Description
CH_Bank_Mod_10	This function returns a String value that represents a creditor reference as an MOD10 expression, based on the digits of the specified invoice number.
CN_GBT_AdditionalDimensionID	This function returns a String value that represents a single financial dimension ID that is taken from the specified string. The specified string presents all dimensions as a comma-separated list of IDs.
ConvertCurrency	This function returns a Real value that represents the result of converting the specified monetary amount from the specified source currency to the specified target currency by using the settings of the specified company on the specified date.
CurCredRef	This function returns a String value that represents a creditor reference, based on the digits of the specified invoice number.
FA_Balance	This function returns a Container (record) value that consists of data for the fixed asset balance for the specified fixed asset item, value model code, reporting year, and reporting date.
FA_Sum	This function returns a Container (record) value that consists of data for the fixed asset amounts for the specified fixed asset item, value model code, and period of dates.
GetCurrentCompany	This function returns a String value that represents the code for the legal entity (company) that a user is currently signed in to.
ISOCredRef	This function returns a String value that represents an International Organization for Standardization (ISO) creditor reference, based on the digits and alphabetic symbols of the specified invoice number.
IsValidCharacterISO7064	This function returns a Boolean value of TRUE if the specified string represents a valid international bank account number (IBAN). Otherwise, it returns a Boolean value of FALSE.
Mod_97	This function returns a String value that represents a creditor reference as a MOD97 expression, based on the digits of the specified invoice number.
NumSeqValue	This function returns a String value that represents the new generated value of a number sequence, based on the specified number sequence, scope, and scope ID. The scope ID equals the company code that is supplied by the context that the ER format is run under.
RoundAmount	This function returns a Real value that represents the result of rounding the specified amount to the specified number of decimal places according to the specified rounding rule.
TableName2ID	This function returns a numeric representation of the table ID for the specified table name as an Integer value.
TaxUnitConversion	This function returns a Real value that represents the quantity result of converting the specified unit from a transaction to the specified unit in a tax configuration. This function requires context that's from an original sourcing system. The method ConverUnit in interface IExternalAPIProvider must be implemented in a sourcing ERP environment.

Additional resources

Electronic Reporting overview

Formula designer in Electronic reporting

Electronic reporting formula language