संपादित करें

इसके माध्यम से साझा किया गया


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