web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Blogs / Technical Tutorials for MS Dynamics Ax 2012 / Resolved:How to do recalcul...

Resolved:How to do recalculation for InventSum table in Microsoft Dynamics Axapta

Views (241)
SANTOSH KUMAR SINGH Profile Picture SANTOSH KUMAR SINGH 1,224
Sometimes you may see some discrepancy in InventSum table for any item then you may need to recalculate inventsum for particular item. You can try below code to do it.
 static void InventSum_Recalculate(Args _args)  
 {  
   InventSumRecalcItem           InventSumRecalcItem;  
   InventTable               _InventTable;  
   while select * from _InventTable where _InventTable.ItemId == '61142A'  
   {  
     ttsBegin;  
     InventSumRecalcItem = new InventSumRecalcItem(_InventTable.ItemId, true, checkfix::fix);  
     InventSumRecalcItem.updatenow();  
     ttsCommit;  
   }  
   info("Done");  
 }
This job will recalculate InventSum for specific item.


This was originally posted here.

Comments

*This post is locked for comments