Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Answered

FIFO costing method but COGS will apply specific when selling lot tracked items

Posted on by 28
Hi Community.
 
I just need to verify how the FIFO costing method works in BC. 
 
I have my items setup as FIFO and is lot tracked.
 
With typical FIFO the cost of your items sold will always be the cost of the first batch purchased even if you sold the 2nd batch first.
Ex.
batch 1 = Lot 1 purchased 100 units @50/unit = 5000 total value
Batch 2 = Lot 2 purchased 200 units @ 40/unit = 8000 total value
 
When I sell 150 units 
 
100 units of lot 2 + 50 units of lot 1 = total
System should cost you
100 units @50/unit +50 units @ 40 = total
5000 + 2000 = 7000
This is how typical FIFO will work
 
But in BC if it is lot tracked and even if you are using FIFO it will "change" the costing method to Specific Costing after you apply cost adjustments.
 
Soo BC scenario will be
100 units@40 + 50 units@50 = total
4000 + 2500 = 6500
 
I can't find documentation on lots and costing method but I did test and this is what I saw the system doing in the Value Entries.
 
If anyone can chime in and verify if this is how their system acts to please do mention it.
 
  • Verified answer
    Ben Baxter Profile Picture
    Ben Baxter 4,559 Super User 2024 Season 2 on at
    FIFO costing method but COGS will apply specific when selling lot tracked items
    Just a point of clarification, this is due to the "Lot Specific Tracking" being enabled within your Item Tracking Code.  If this was disabled it would apply the normal FIFO costing.
     
    The reason you NEED "Lot Specific Tracking" turned on is the system tracks the quantity per Lot.  In your example, using FIFO (non-Lot Specific) the system would consume 100 of Lot 1, even though you actually only consumed 50.  Just as it would have only consumed 50 of Lot 2, even though you consumed 100.  So if I go and do a count of my inventory, I won't have the correct quantity of either Lot in my inventory.
     
    The "Lot Specific Tracking" corrects for this and applies the correct consumption entries to the appropriate Lot Quantities, which the costing follows.  So "Lot Specific Tracking" really converts the FIFO costing into "Specific" costing.
     
    Hope this helps shed light on why this is happening, and give you peace of mind that it is a good thing for Lot Tracked inventory.
     
    Best Regards,
    Ben Baxter
    Accent Software Inc
  • gdrenteria Profile Picture
    gdrenteria 9,472 Most Valuable Professional on at
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 69,639 Super User 2024 Season 2 on at
    FIFO costing method but COGS will apply specific when selling lot tracked items
    Hi, I hope the following video can also give you some help
    Costing Part 17, Lot Specific Costing
     
    Thanks.
    ZHU
  • Suggested answer
    Jun Wang Profile Picture
    Jun Wang 7,146 Super User 2024 Season 2 on at
    FIFO costing method but COGS will apply specific when selling lot tracked items
    this is the normal behavior. When selling lot tracking items, user needs to specify which lot the user needs to sell. By doing so, it, in effect, specifies the costing of the items lot being sold.
     
    for your reference
     

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,532 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,501 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans