Process to add fields in the Data Entity and Updating the methods in Data Entity Property




Process to add fields in the Data Entity and Updating the methods in Data Entity Property:

We can create a new data entity by duplicating the standard data entity or you can create the  extension of the standard Data Entity.

Please find the below example:

Step(1) Duplicate the standard Data Entity SalesOpenSalesPriceJournalLineEntity.

Say Test_SalesOpenSalesPriceJournalLineEntity and regenerate the  staging table.

Add a new field  say Test_ItemPriceGroupCode.


Step(2) Go to the property of the field-Test_ItemPriceGroupCode and add the new method say Test_SalesOpenSalesPriceJournalLineEntiy_Extension in the Data Entity View Method as  Test_SalesOpenSalesPriceJournalLineEntiy_Extension::ItemPriceGroupCode.


Thanks
Dynamics 365 Learner

Comments

Post a Comment

Popular posts from this blog

Identifying the Database Synchronization Issue in D 365 FO

Image
Identifying the Database Synchronization Issue in D365FO I came across a scenario where I was able to build the environment (Did full build of the environment i.e all the models) but was getting the synchronization error everytime. You can refer to the below screenshot for error list. Error List: (1) System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation,---> System.InvalidOperationException: An exception was encountered while initializing chain of command initializer,see event viewer for the detailed information. (2) Syncengine.exe exited with code -1. Solution to recreate the issue : After doing the full build of the environment also I was getting the synchronization issue. So to identify this error I checked into the event viewer. In event viewer I followed the following steps to come across the issue. Step(1) Open the event viewer and right click and run as  administrator. In the event viewer go to the Microsoft folder
Read more

Steps to create new cheque layout in D365 FO

Image
Step1. Extend the Standard BaseEnum as ChequeFormType with proper naming convention say (ChequeFormType.SAGlobalExtension) Step(2) - Duplicate the standard menu item Cheque_US as SAGCheque_TEPL_SCB and set the property of the menu item as given in the screenshot. Step(3) - Now duplicate the report Cheque_US as SAGCheque_TEPL_SCB and call this report in the controller class extension. Step(4). Following classes need to be modified to support the new Cheque layout in Extension. (1)add extension class for existing BankChequePrint class and add below logic.   [ ExtensionOf ( classStr ( BankChequePrint ))] final class SAGBankChequePrint_Extension {     protected str determineReportMenuOutput( ChequeFormType _chequeFormType)     {         str menuOutput = next determineReportMenuOutput(_chequeFormType);               switch (_chequeFormType)         {             case ChequeFormType ::SAGStyle :                 menuOutput =
Read more

SSRS Reports using the QueryInsertRecordSet in D 365 FO

                                               Logic for Report Using QueryInsertRecordSet: I used QueryInsertRecordSet that will insert the data in one trip and it is faster than insert recordset  and also we are not using the contract class and it works fine. The Key point here is that we have to make the Report Data Set Property(Dynamics Filters to True) to make the logic working. This is required to access the DP class query in the controller class. Printing the report for selected record in the SalesQuotationJournal. [ SRSReportQueryAttribute(queryStr(SalesQuotationQuery)) ] class gbSalesQuotationDP extends SrsReportDataProviderPreProcessTempDB { SalesQuotationTmpTable  salesQuotationTmpTable; CustQuotationJour  custQuotationJour; CustQuotationTrans  custQuotationTrans; /// <summary> /// /// </summary> private void addInsertFieldMapping(QueryBuildFieldList _fieldList, Map _fieldMapping, int _sourceTableUniqueId, FieldId _sourceFieldId, FieldName _sourc
Read more