D365 FO -Composite Data Entity

 Problem Statement: 

        Create basic composite data entity. while creating the composite data entity, we need to do the following steps.

  1. First we needs to analysis the what are all the relevant tables needed for your requirement.  
  2. After that needs to find out what is the relation between them.
  3. In Visual studio >> create individual entity for each tables.
  4. Make sure all the mandatory fields are selected in the data entity.
  5. If you want you to expose the entity to the outside word you needs to enter the "Public Collection Name and Public Entity Name".
  6. Configure the relations between newly created data entity and needs to configure the staging table relations also.
  7. Export the relevant table data via DMF, export option.

Comments

Post a Comment

Popular posts from this blog

DMF (1073676279) - Issue Fix

 Problem Statement:      When  I tried to Import the data via DMF I got the following error message. <?xml version="1.0"?><Errors><Error><ErrorCode>-2146233088</ErrorCode><SubComponent>Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelper</SubComponent><Description>DMF2060 -    at Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelper.DMFXmlPackageImport.AddDataFlowComponent(Package _Package)    at Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelper.DMFPackageControllerImport.CreateAndExecutePackage()    at DMFExecutePackage.PackageCreator.processEntity()    at DMFExecutePackage.Program.Main(String[] args)</Description></Error><Error><ErrorCode>-1073676279</ErrorCode><SubComponent>Microsoft.SqlServer.DTSPipelineWrap</SubComponent><Description>Exception from HRESULT: 0xC0010009 -    at Microsoft.SqlServer.Dts.Pipeline.Wra...
Read more

Read the JSON data via REST API (X++)

  Problem Statement:           Read the data from outside Application. Here I am fetch the JSON data from Shopify Integration and push it in to the D365FO System.   Development steps:       Step 1 : Create Runnable Class.      Step 2 : After create the Runnable class, use the following Library in your solution.                               using System.Net.HttpWebRequest;                               using System.Net.HttpWebResponse;                               using System.Text.Json;                               using System.Text.Json.Serialization;  ...
Read more

Activate Financial Dimension in Dynamics 365 FO. (On- Premises)

  If you want to activate the financial dimension in Dynamics 365 on on-premises, you need to do a following step. 1.      Open SQL and go to D365FO Database. 2.     Execute the following Query                   select * from SQLSYSTEMVARIABLES         update SQLSYSTEMVARIABLES SET VALUE = 1 WHERE PARM =                     'CONFIGURATIONMODE' 3.      Execute IIS Restart. 4.     Refresh the Page. 5.     After activating the financial dimension, you need to revert the option.              update SQLSYSTEMVARIABLES SET VALUE = 0 WHERE PARM                     =   'CONFIGURATIONMODE' 6.    Execute IIS Restart. 7.    Refresh the Page.
Read more