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 :
Small and medium business | Business Central, N...
Suggested Answer

Business Scenario: Which Costing Method to use in business central?

(1) ShareShare
ReportReport
Posted on by 5,035
Hi Community,
I would like to find out regarding Costing Method, specifically FIFO and Standard.

My client can't decide which of this 2 costing method to use .

The scenario is like this:

His company purchase medicine from supplier by batches. The medicine all have expiration dates.

1st batch - $20 per bot, 2nd batch $23 per bot.

Now there will be times whereby, the business will have charity events while they are selling the medicines.

The goods for the charity goods can be using the 2nd batch before the first batch is used up.

In this scenario, especially considering the 2nd batch will be used before the first batch, which Costing methods between FIFO or Standard should we use?

Hope this makes sense.

Thank you!
I have the same question (0)
  • Suggested answer
    Ben Baxter Profile Picture
    7,008 Super User 2026 Season 1 on at
    When dealing with Medicine, you are generally tracking a Lot No.  Item Tracking will also come into play with the expiration date tracking.  If you have Lot Specific Tracking turned on, your cost will flow from the Lot Used in the Sale.  So even using FIFO as the Costing Method, the Lot Specific Tracking would apply the specific cost from the Lot to the transaction, which sounds like what you need.
     
    In a Sandbox environment, I would suggest you run some test transactions through and verify the cost is being applied how you want it.  Be sure you either run Adjust Cost automatically, or manually after the transaction, to ensure it applies the costs correctly.
     
    Best Regards,
    Ben Baxter
    Accent Software Inc
  • Jun Wang Profile Picture
    8,212 Moderator on at
    the answer is actually quite straightforward. BC will auto assign item for transactions using FIFO. BUT user can also manually use apply to item entry to choose which item to sell. In your case, you could pick batch 2 items even there are batch 1 on inventory.
    standard doesn't apply to your case. hope it helps. follow me on linkedin for more sharing. Jun Wang
     

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!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March 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,796 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 965 Super User 2026 Season 1

#3
Teagen Boll Profile Picture

Teagen Boll 664 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans