web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Unanswered

Inventory adjustment and Costing

(1) ShareShare
ReportReport
Posted on by 10
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.
  1. How do I clear the remaining stock value on all items in this location where there is no physical inventory left.
  2. 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.
I have the same question (0)

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.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,010

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,270 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,085 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans