Technical Tutorials on MS Dynamics Axapta 2012,D365 FnO

Error Description Workflow stopped working. This exception is coming in event log  X++ Exception: Workflow work item escalation failed! Please contact your system administrator.  at WorkflowTrackingTable-saveTracking SysWorkflowWorkItem-escalate X++ Exception: (S)\Jobs\  at  X++ Exception: Cannot edit a record in Workflow tracking status table (WorkflowTrackingStatusTable). Update must be performed inside a transaction. second is this Update must be performed inside a transaction. Workaround for solution: I did following things to resolve this error. 1. Synchronization of Data dictionary. 2. Run Full Compile  3. Stop Ax service. 4. Restart Ax server. 5. Restart Ax services.

To Enable Database Log for Table in Ax 2012 you can follow below steps. Go to system Administration ->setup ->Database->Database Log Setup After clicking Database Log setup you need to select your table if you are not getting your table then click on show all tables then you can get your table too. Then Complete wizard as per requirement of  enabling log for insert,update,delete on fields or table. I want to suggest do not take all tables its will effect performance of ERP. If log are not getting generated after setting all steps then you need to check table property and savedatapercompany should yes to work that. But you can user savedatapercompany property only if your table is empty.

To Display IP address of System by code in Ax 2012 you can try below code.

To Get Modified Object in User Layer ax 2012 you can try below code in Job in AOT.

Error: If you are facing following error on reservation of item in Sales Line in Sales order or any other order. "1:N Fetch Mode is not allowed on Datasource having join condition with node other than its immediate parent." "Field 'Dimension No.' must be filled in." Then you can try following solution: Solution: You can install  this hot fix: KB Article Number(s): 2922779. For Axapta 2012  R2 CU 7 You can download hotfix from Microsoft partner source site.

I want to highlight Query to get workflow last comment in Ax 2012. You can use ,WorkflowTrackingTable,WorkflowTrackingStatusTable  and WorkflowTrackingCommentTable   to get Last comment entered by used on submitting or approving workflow for module WorkflowTrackingTable workflowTrackingTable; WorkflowTrackingStatusTable workflowTrackingStatusTable; WorkflowTrackingCommentTable workflowTrackingCommentTable; PurchTable PurchTable; select PurchTable where PurchTable.PurchId ="PO13000003"; select ContextCompanyId, ContextTableId, ContextRecId from workflowTrackingStatusTable where workflowTrackingStatusTable.ContextCompanyId == curext() && workflowTrackingStatusTable.ContextTableId == PurchTable.TableId && workflowTrackingStatusTable.ContextRecId == PurchTable.RecId join firstonly TrackingId, CreatedDateTime from workflowTrackingTable order by CreatedDateTime desc where workflowTrackin

Comparison of Oracle Vs Axapta ERP 1.Dynamics AX is much better than oracle because Microsoft is a complete package in itself, and you can connect any Microsoft product without any problem. Compatibility is very high. Easy implementation./ 2.Apart from compatibility, easy and built-in connections strings between different products of Microsoft i.e. MS office, operating system, SharePoint, SQL server and above all SSRS etc are other thing we can quote in favor of AX. 3.If Dynamics AX fits you why go to another costly ERP , then the budget and your long term plan as the support also matter after this and the consultant price differ and if you will hire a consultant in house or hire a company. 4.Microsoft dynamics AX everything that oracle can give and plus easy integration with other MS products and on top of it providing the functionality cheaper that ORACLE can dream of 5.Easy customization, drag and drop kind of GUI menus. Faster and easy to use. No need to have thicker cli