Finance | Project Operations, Human Resources, ...

Total available is not correct

(0) Share

Report

Posted on by Community Member

We have a situation where I have a serialized item where the Physical Inventory = 1, the Available physical on exact dimension = 1 but total available = 0. There is only one transaction for this item and it was the initial inventory adjustment to put the item into inventory (this was a data conversion transaction). There are no pending orders/reservations. So is there a way to recalculate the total available based on detail transactions? It just looks like the On hand list is out of sync with the transactions and I was hoping there is a job that would "fix" the integrity between the on hand list and the detail transactions. Thanks

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Muthusamy 4 on at

Like (0)

Report

Hi Mikeev,

Inventory Total is the calculated field with the consideration of in/out inventory physical transactions.

Go to Transactions form from Inventory Onhand, you can get the details as like below screen shot.

Check this blog https://readerman1.wordpress.com/2017/02/07/dynamics-ax-2012-on-hand-inventory-form/ ..

Thanks

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 301,088 Super User 2025 Season 2 on at

Like (1)

Report

Hi Mikeev,

If you have only one item transaction and the on-hand is incorrect, I wonder if this could be caused by a customization or the method how you created the inventory adjustment.

You can run a consistency check for the item and recalculate the on-hand: Consistency check for a single item in Dynamics 365 for Operations (and AX 2012 and AX 2009). | timsaxblog (wordpress.com)

You can run it with the fix option to get the on-hand recalculated.

Was this reply helpful? Yes No