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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / How to set the remaini...
Small and medium business | Business Central, N...
Suggested Answer

How to set the remaining inventory to 0 on the SKU inventory?

(4) ShareShare
ReportReport
Posted on by MB-22070538-0 8
Goodmorning to you all,
 
I've got a customer who has 0 physical inventory in all locations and also on the item card.
But the SKU inventory says that it has 3 left.
 
When i look at the item ledger entries. I see that there is a purchase order with some remaining quantity.
 
But if i look at the specific order, that order has allready been recieved?
How can i correct this situation, so that the reorder mechanism will work again for this item?
 
Thanks in advance,
 
Marcel
Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Suggested answer
    Jeffrey Bulanadi Profile Picture
    Jeffrey Bulanadi 9,112 Super User 2026 Season 1 on at

    Hi Marcel,

    When the item card and physical inventory show zero but the SKU still insists there are 3 units left, it’s usually due to a lingering Remaining Quantity on the item ledger entry that hasn’t been consumed or adjusted. Even if the purchase order is marked as fully received, BC still considers those units available for planning until they’re explicitly cleared.

    From your screenshot, it looks like the original receipt posted 4 units, but only 1 has been consumed — leaving 3 units with Remaining Quantity = 3. That’s why the SKU record doesn’t zero out, and the reorder engine stalls.

    Here’s how you can cleanly resolve it:

    • Post a Negative Adjustment journal for the same item, location, and variant. Set quantity to -3 and optionally use the Applies-to Entry field to link it directly to the original purchase ledger entry. This will remove the phantom inventory and update the SKU totals.
    • Alternatively, use the Physical Inventory Journal, calculate expected inventory, set Qty. (Phys. Inventory) to 0, and post. This is especially useful if you're reconciling across multiple locations or want to reset values cleanly at month-end.


    Once posted, revisit the SKU record — it should now reflect zero, and planning worksheets will resume generating reorder proposals as expected.

    Helpful Reference
    Count, adjust, and reclassify inventory – Microsoft Learn
    Inventory Adjustment – BC Guide
    Inventory Management in BC – Microsoft Learn


    If you find this helpful, feel free to mark this as the suggested or verified answer.

    Cheers
    Jeffrey

  • Suggested answer
    Sohail Ahmed Profile Picture
    Sohail Ahmed 11,169 Super User 2026 Season 1 on at
    1. Run the “Adjust Cost – Item Entries” batch job to ensure all entries are fully updated.
    2. Then run "Recalculate Inventory" from the Item Card or SKU Page (Actions > Functions).
    3. If the problem remains, open the Reservation Entries or Supply Planning Entries to see if any old reservations or expected receipts are still affecting the SKU.
    4. If needed, create a negative item journal entry at that location to zero out the remaining inventory and post it.
     

    This should reset the quantity and allow the planning engine to suggest new purchases correctly.

     

    ✅ Mark this answer as verified if it helps you.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,926 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,158 Super User 2026 Season 1

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 533 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans