Skip to main content

Posts

Showing posts from May, 2015

Display IP address of System by code in Ax 2012

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

Get Modified Object in User Layer ax 2012

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

Error "1:N Fetch Mode is not allowed on Datasource having join condition with node other than its immediate parent" in Ax 2012

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.

Query to get workflow last comment in Ax 2012

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

Which one better Oracle or Axapta ERP

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