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...
Suggested Answer

Inventory Valuation by lot number

(0) ShareShare
ReportReport
Posted on by 5

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
    133 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
    5 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
    260 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,336 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
    5 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,336 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

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