Resolved:How to do recalculation for InventSum table in Microsoft Dynamics Axapta
Views (109)
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.
This job will recalculate InventSum for specific item.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 was originally posted here.
*This post is locked for comments