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

Announcements

News and Announcements icon
Community site session details

Community site session details

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

Production Consumption Posted Against Opening Stock Instead of Purchased Stock

(2) ShareShare
ReportReport
Posted on by 16,989 Super User 2026 Season 1

Hello Experts,

For the two specific items, both Opening Stock and Purchased Stock are available in Business Central. However, during the production process, the user consumed the Opening Stock lot instead of the Purchased Stock lot.

Since we are using a custom production process and the production order has already been finished and cost-adjusted, please advise on the best approach to:

  • Restore/increase the quantity of the Opening Stock that was incorrectly consumed.

  • Consume the corresponding quantity from the Purchased Stock lot instead.

  • Ensure that lot tracking, FIFO costing, and inventory valuation remain accurate after the correction.

As the consumption entries have already been posted against the Opening Stock lot, we would like to understand whether this can be handled through inventory adjustments/reclassification or if a reversal and reposting of the consumption transaction is required.

I have the same question (0)
  • Suggested answer
    Mansi Soni Profile Picture
    10,086 Super User 2026 Season 1 on at
     
    In Business Central, since the production order has already been finished and cost-adjusted, the posted consumption entries cannot be changed directly. To correct the situation where the Opening Stock lot was consumed instead of the Purchased Stock lot, the recommended approach is to first reverse the incorrect consumption using a negative item journal adjustment, which will bring the quantity back into the correct Opening Stock lot while maintaining proper lot tracking.
     
    Once this is done, you can repost the consumption correctly against the Purchased Stock lot. After making these corrections, run Adjust Cost - Item Entries to ensure FIFO valuation and inventory costing are properly updated. This approach keeps both inventory accuracy and audit trail integrity intact without impacting historical production postings.
     
    Hope this answer helps you!
     
    Regards,
    Mansi Soni
  • Alfredo-I-D365T Profile Picture
    11 on at
    Do not try to fix your inventory with a journal or your costs will make no sense.
     
    Use the item application worksheet and filter by Entry Type Consumption, then chage the application to the batch you want.
     
    The problem with BC picking the wrong stock is either item tracking (if you use lot or serial numbers with FEFO) or the posting dates of the purchase receipt and the opening stock as BC will always apply Fist-In-First-Out.
     
     

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,250 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,799 Super User 2026 Season 1

#3
AndrewThomas81 Profile Picture

AndrewThomas81 1,390

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans