Post a question

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... LIFO Cost Rollup

Small and medium business | Business Central, N...

Suggested answer

LIFO Cost Rollup

Like (0) Share

Report

Report

Posted on 3 Nov 2023 20:22:50 by Carol Perry

20

How do you update costs in Business Central when set items are set as LIFO?

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

YUN ZHU 80,364 Super User 2025 Season 1 on 06 Nov 2023 at 03:51:02

Like (0)

Report

LIFO Cost Rollup

Hi, here is a detailed explanation that I hope will give you some tips.

https://www.businesscentralsolutiondesign.com/post/inventory-costing-methods-what-they-do-and-how-to-choose-them

Thanks

ZHU
Suggested answer

Inge M. Bruvik 1,005 Moderator on 04 Nov 2023 at 16:49:25

Like (0)

Report

LIFO Cost Rollup

Simply speaking it will allocate the cost for the last purchased unit that is avalible in your inventory.

You can read more about the design details here.

https://learn.microsoft.com/en-ca/dynamics365/business-central/design-details-costing-methods?WT.mc_id=email&sharingId=DX-MVP-5005315

Date Qty Price

1 november 2023 1 10,00

2 november 2023 1 15,00

3 november 2023 1 17,00

So if you have these inventory movement and you sell them on 3 different sales ordre.

The first order will have a cost of 17, the secound a cost of 15 and the 3de one a cost of 10.

Hope this helps.

Please follow up with more detailed questions if you have any.

Helpful resources

News and Announcements

🌸 Community Spring Festival 2025 Challenge 🌸

Quick Links

Leaderboard

#1

André Arnaud de Cal... 293,531 Super User 2025 Season 1

#2

Martin Dráb 232,597 Most Valuable Professional

#3

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans