Technical Tutorials on MS Dynamics Axapta 2012,D365 FnO

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 workflowTra...

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...

If you are facing Error-One or more pending invoices cannot be displayed because they are in use like below screen. Then you can try following solution. Solution: go to /Accounts payable/Common/Vendor invoices/Pending vendor invoices > selected the invoice number and then>> delete then try to delete again. You can get Invoice from below path also. Accounts Payable / Inquiries/History / Invoices