On hand stock not equal to transactions sum.

Finance and Operations/AX User Forum
1

Hi,

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.’’

4670.On Hand Error.jpg
4670.On Hand Error.jpg1364×768 216 KB

any solution for that?

2

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 InventSumRecalcItem;

InventSumRecalcItem = new InventSumRecalcItem(“ITEMNUMBER”, true, checkfix::fix);

InventSumRecalcItem.updatenow();

}

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.

Irum