Skip to main content

Posts

Showing posts from October, 2013

reRead( ) in AX 2009 - Best Advantage

Hi Friends, I hope all of you may already know about this, but I am forced to post it here. To avoid most of the UpdateConflicts / DeadLock errors while update a record in a table, just use the "reRead( )" method of the table before making any changes to the selected record of the table. Ex : ; ttsbegin; select forUpdate tSalesLine where tSalesLine.SalesId = = 'SO-1234567'; tSalesLine.reRead( ); tSalesLine.Feild1 = XXXXX; tSalesLine.Feild2 = XXXXX; tSalesLine.update( ); ttscommit; Happy Daxing.. AX Dude.

How to Cancel a Sales Order in AX using X++

Hi All, To cancel a sales order using X++ I tried the below code, I hope it will be helpful for you. ttsBegin;     while select forupdate salesLine         where salesLine.SalesId == salesTable.SalesId     {         salesLine.RemainInventPhysical = 0;         salesLine.RemainSalesPhysical  = 0;         salesLine.update();     } ttscommit; Happy Daxing, AX Dude

Finding out which tables were updated by an operation in AX

Hi All, At times when troubleshooting Microsoft Dynamics AX you need to know which tables were updated by a particular operation, for example after performing a posting. This could be if you want to be sure that all the right tables are updated correctly after an upgrade, if you have unexpected results on one customer/vendor etc or if you have made an update the system and you want to be sure that everything is ok. Click Here  to continue to the post. Happy Daxing, AX Dude