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

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

(1) ShareShare
ReportReport
Posted on by 4,979
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
    6,616 Super User 2025 Season 2 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,202 Super User 2025 Season 2 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

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 2,917

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,161 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,025 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans