Announcements
No record found.
Does anyone know how to clean up zero quantity on-hand inventory with offsetting financial costs? See below:
Hi Jet,
This can be done by Inventory management>Periodic tasks> Warehouse management on-hand entries cleanup.
Related information about warehouse management on-hand entries cleanup can be viewed in the following links:
Improve performance by running the Warehouse management on-hand entries cleanup job – for New AX and for AX2012 R3 CU10 - Microsoft Dynamics 365 Blog
Looking at your screenshot, there are open orders in the environment. This is not a zero on-hand entry for the application. To get rid of these entries, check the open entries.
Hi Charlotte,
We tried that but it did not work.
Hi Andre,
We checked all open entries (e.g., sales orders, production orders, and purchase order) but nothing is open. This seem about the time we upgraded to D365 from AX2012. These items are old in our system that have not been used in quite some time. We tried everything, but think it may be a corruption of some sort...unless we are looking at the wrong area when you say to check the open entries.
You can have a look at all the inventory transactions for this item. Are you able to find transactions without a physical date? In that case, these transactions should be open and the form will then give information about the origin. Have you also checked unposted transfer journals or transfer orders? Or maybe open warehouse work? Looking at the location, it could be related to a transfer from one location to another.
Hi André Arnaud de Calavon,
I was also getting same issue in AX2012.
- Item using Waited AVG, financial value is calculated at Site level
- There is no Open transaction
- Already run Recalculation & Closing
- I already run all the Clean-up functions:
But the Financial Value is still exist with Zero Qty:
Is there anyway to remove this?
Hi Hang,
Your scenario is different, and you are using another product. Please next time, create your question in the Dynamics AX forum. You can try to run a consistency check for the inventory module. Set the mode to "Fix" to have the on-hand recalculated. You can set a range for a specific item number.
See also the next blog: Consistency check for a single item in Dynamics 365 for Operations (and AX 2012 and AX 2009). | timsaxblog (wordpress.com)
Thank you, André Arnaud de Calavon.
I tried to run consistency check & fix already, but the value still there.
I am sorry, next time I will create separate question for different product.
Hi all
I'm facing a similar thing, and was hoping onf of you could help.. See screen shot below:
How do i remove these 'financial cost' values?
Thanks!
Hi James,
Usually, the inventory closing will settle this, but not if the warehouses are different and warehouse dimension is enabled for financial tracking. When you look at the storage dimension group settings for this item, is the Financial option enabled for the warehouse dimension?
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Giorgio Bonacorsi 653
André Arnaud de Cal... 493 Super User 2026 Season 1
Syed Haris Shah 317 Super User 2026 Season 1
