i am using ax 2012. i have checked that my on hand stock is not equal to transaction sum. when i run consistency check system show me following error as many line which is exactly equal to difference
‘‘For dimension SLM-015595, posted quantity should be 1.00, but 0.00 have been incorrectly updated.’’
any solution for that?
Dynamics AX 2012 RTM has an issue with InventSum table that does not calcualte items on-hand inventory correctly.
Please check if your AX version is AX 2012 RTM then below solution will work for sure.
static void UpdateInventSumJob(Args _args)
InventSumRecalcItem = new InventSumRecalcItem(“ITEMNUMBER”, true, checkfix::fix);
Note: Replace ITEMNUMBER with your target ITEMID before executing above query.
To try this code, open Dynamics AX workspace (Ctrl+D), locate Jobs node under AOT. Create a new job and copy paste the above code, and it will correct the on-hand inventory based on transaction sum.