How can we adjust item cost with zero quantity.
I post item through inventory adjustment journal. as a result item quantiry become zero where as item showing cost in inventory value report with zero quantity.
How can we adjust item cost with zero quantity.
I post item through inventory adjustment journal. as a result item quantiry become zero where as item showing cost in inventory value report with zero quantity.
Is that item still somewhere used in partly completed transactions such as sales orders where the final invoice is missing or purchase orders where the vendor invoice has not been posted?
If this is the case then the report output (0 qty but financial amount) could be explained.
If this is not the case then there must be something wrong with the valuation of that item.
In this case you have to run an inventory close and adjust the value for that item.
Before doing that test this carefully in a demo/test environment and note that you won't be able to backdate transactions to a date before the inventory close.
Best regards,
Ludwig
After recalculation I check the amount of an item in inventory value report .Amount still showing with zero quantity
Hi Mohammad,
The inventory recalculation will adjust the issue costs based on the inventory model selected.
If your quantity is zero but a value is there then the issue costs must be wrong and the inventory recalculation should fix that.
Best regards,
Ludwig
Using average method
open without any filter
Open for all items
Hi,
What filter is checked when you click on the select?
Because I post inventory throgh adjustment journal.
But in closing and adjustment only purchase order transactions are showing . How can we see all transaction there.
Hi Mohammad,
Please try to run an inventory recalculation. If you see a financial amount in the inventory value report then the inventory recalculation should take care of that and bring also the value back to zero.
Best regards,
Ludwig
Hello,
Do you mean that now the item has cost but the quantity is zero?
What is cost model of the item?
Please try to change the cost in the path Inventory management > closing and adjustment > adjustment > transaction > select. Refer to Doc: docs.microsoft.com/.../adjust-transactions-form-inventory
Moved to AX forum.
André Arnaud de Cal...
293,245
Super User 2025 Season 1
Martin Dráb
231,925
Most Valuable Professional
nmaenpaa
101,156
Moderator