Hi, looking for some recommendations or best practise around writing off stock. Below is a scenario.
I have an item “A” with an average costing method, and the current unit cost is 210.66. The product is available in 2 locations. (Sales and Warranty).
A sales credit note is generated on 22/01/2025 at a unit cost of 167.88 to the warranty location with no previous ledger/value entry for this item in this location. A negative item journal is posted on 21/11/2025 at a unit cost of 210.66 (current unit cost). We have an "adjust Cost - Item Entries" job running daily with a setup of “Item&Location&Variant” under the inventory setup.
When I run Inventory Valuation report, it indicates there is a value of -42.78 however there is no stock obviously due the difference in Unit cost in the value entry table. I have a couple questions.
How do I clear the remaining stock value on all items in this location where there is no physical inventory left.
What is the recommendation when it comes to this scenario so that we do not have a value left behind when there is no inventory.
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.