AX2012R2 : Inventory Qty is 0 but there is a Financial cost amount and Physical cost amount

Finance and Operations/AX User Forum
1

Hi All,

This is similar to the issue I reported earlier. I.E The Inventory Qty is 0 but there still exists a Financial and Physcial cost amount. However the issue is now in AX 2012 R2. The solution provided for AX04 unfortunately did not work.

The Inventory recalucualtion was run for the period but there was no settlements for the 0 Qty Items Physical and Financial cost.

Searched the web for a solution and found the following links which were somewhat useful but did not solve my issue

  1. dynamicsuser.net/…/229056.aspx :

Advised to run the Database consitency check which I did. The result did not produce any errors for the inventory module. Hence nothing to fix

  1. mvpdynamicsax.blogspot.sg/…/recalculate-inventsum.html

Advised to pass the Item code as a parameter to the InventSumRecalcItem class to manually check for errros. I placed the code snippet into a Job . compiled and ran it .,but no visual output was seen.

I guess the last resort would be to adjust the value in the Inventrans table but I 'm reluctant to go there as this is a complex table as adviced in method (1).

If you have any idea’s on how to tacle this one,please do share.

Regards,

Adrian.V

2

Is every in and out of the transactions related to the item financially closed?