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

Announcements

No record found.

Community site session details

Community site session details

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

Inventory Valuation by lot number

(1) ShareShare
ReportReport
Posted on by 11

I am implementing BC and we track inventory by lot code. We manufacture sports nutrition supplements and need to be able to track every raw material by lot number. 

An inventory upload was done with zero as the unit cost for all items/lot numbers. 

is there a way to update the unit cost for every lot code by item? 

I have the same question (0)
  • Suggested answer
    JAngle Profile Picture
    150 on at

    Use item revaluation journal. Lot no. isn’t shown but it is part of the data. You may want to have it added to the page with a page extension

  • DB2022 Profile Picture
    11 on at

    I have several lots for one item. For example, I have 15 different lots for a raw material item purchased at 5 different prices. I need each lot to reflect the correct cost so I can analyze production orders profitability. I also need to be able to assign specific lot to specific customer orders based on the unit cost of a lot as a lower cost lot number might have been used in pricing a finished good to a customer. So that  specific lot needs to be consumed in that customers order.

    What is a page extension? How do I do that?

  • Damiano Zaniboni Profile Picture
    262 on at

    Hi, I think there is no other way than to implement a customization. Some time ago a customer asked me for a similar thing and we had developed an ad hoc solution because the inventory valuation report and the Italian localization(fiscal inventory valuation) did not meet the request to have a cost per lot.

  • Guy McKenzie Profile Picture
    1,340 on at

    With lot tracking set up properly, your inventory valuation report should reflect the sum of actual qty at each specific unit cost receipt.

    The inventory valuation is the sum of the value entries. Even with FIFO costing, if your lot tracking is correctly setup, the fifo cost is not actually used, the specific cost of the the specific lot is taken as COGS which leaves the inventory valuation correct.

    Open up the item tracking code page that you have assigned to the item. If you are tracking inbound, outbound and internal transactions, your costing should be correct.

    If it isn’t, what is your inventory setup? If cost posting isn’t automatic, you may have a slight delay in costs being updated but they will be correct when adjust cost item entries and post costs to g/l are run.

  • DB2022 Profile Picture
    11 on at

    The issue here is inventory was upload with a unit cost for each lot. I was told by the consulting firm assisting with the implementation that  we could book a revaluation adjustment to update the unit cost, but now I am realizing that isn't possible if I wanted to do it by lot. We're in the middle of trying to go live. The only solution I see at this point is to reverse the inventory upload, populate the unit cost for every item/lot number, and re-upload inventory. A customization would take too long.

  • Guy McKenzie Profile Picture
    1,340 on at

    Apologies, I hadn’t properly appreciated where your issue lay.

    Yes, I would reverse your opening balance inventory journal and re-import. Each different cost for the same item should be a separate line in the same item journal.

    That is the simple solution to the problem. 

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!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,140 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,009 Super User 2026 Season 1

#3
Dhiren Nagar Profile Picture

Dhiren Nagar 960 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans