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. |