How to bind the field with data type as Enum in Electronic Reporting in D365FO

-

How to bind the field with data type as Enum in Electronic Reporting in D365FO

Step 1: Add Enumeration from Data Source Type >> Dynamics 365 for Operations


Step 2: Then use the formula of CASE to get the values from Enum.



Happy Learning
By Neeraj Kumar

Comments

  1. AnonymousFebruary 18, 2023 at 4:35 PM

    how to bind enumeration to the model say for example ( inventtransorigin.reference category )

    ReplyDelete

Post a Comment

You might love these

Calculate Preposted tax document on Purchases order confirmation in D365FO using Electronic reporting

-
Image
What's the Problem : Some of the customers demand printing the tax amount in the Purchases order print at line level. As we know, there is no table in the standard D365 to save the line-level tax amount in any posted tables. To get the tax amount at line level, the tax document needs to be calculated at run-time with available information on the Purchases Order line. Presently we use the customized class to calculate the tax amount at line level using the below code : static void GSTTotal (Args _args) { vendPurchOrderJour vendPurchOrderJour; ITaxDocument taxDocument; ITaxDocumentComponentLineEnumerator componentLineEnumerator; ITaxDocumentComponentLine componentLineObject; ITaxDocumentMeasureEnumerator measureEnumerator; TaxAmount taxAmount,taxValue; TaxComponent_IN taxComponent; ; vendPurchOrderJour = vendPurchOrderJour::findRecId( 5637291565 );      /Need to pass Confirmation journal recid taxDocument = TaxBusinessService::getT...
Read more

ER - Use horizontally expandable ranges to dynamically add columns in Excel reports- D365FO

-
Image
  What's the Problem : Customer requests for different GL-related reports in which we will surely have Financial dimensions in different columns. For example, one customer asks for financial dimensions like Business Unit, Department, Cost center, etc, others can ask for other financial dimensions to be reflected in the report. Since the financial dimensions are dynamic in nature based on the requirement of customers. As a consultant, you might require to make changes in the report to show different financial dimensions as per the customer's request. It takes a lot of effort in making changes in the report format, model mapping [I assume you are familiar with  Electronic Reporting   - Data model, Model mapping, and Format designer] Here is the solution: Create horizontally expandable ranges to dynamically add columns in Excel reports in the Electronic reporting.  Steps to create the report:  Create a data model that looks like the below screenshot: 2. Click on Ma...
Read more