Accounting

Inventory costing methods in Business Central: FIFO, Average or Standard

The costing method is chosen once and almost permanently. Here are the options Business Central gives you, the local constraints that narrow them, and the trap that catches most implementations.

Short answer

Business Central supports five inventory costing methods: FIFO, LIFO, Average, Specific and Standard. The method is set on the item card in the Costing Method field — and once entries exist for that item, changing it through standard functionality is effectively impossible.

For Ukrainian statutory accounting the choice narrows immediately: LIFO cannot be used. National accounting standard 9 "Inventories" lists the permitted methods for measuring inventory on disposal — specific identification, weighted average, FIFO, standard cost and retail price. LIFO is not among them.

Mapping BC methods to Ukrainian standards

Business CentralNational standard 9Usable in Ukraine
FIFOcost of earliest receiptsyes, the most common choice
Averageweighted average costyes
Specificspecific identificationyes, for unique items
Standardstandard costyes, with mandatory variance analysis
LIFOno equivalentno

The retail price method from the national standard is not implemented as a separate costing method in standard Business Central — it is covered through retail accounting configuration or an industry extension.

Worth noting: the standard requires one method for all inventory items with the same purpose and conditions of use. Business Central lets you set the method per item, so the technical freedom is wider than the accounting rule. The policy belongs in your accounting policy document, not in the judgement of whoever creates the item card.

FIFO or Average: how the choice is made in practice

FIFO is the default choice for most trading and manufacturing companies. Cost of sales is tied to specific receipt batches and the balance sheet carries inventory at the most recent prices. In a rising-price environment FIFO produces a lower cost of sales and therefore higher reported profit.

Average smooths fluctuations. It makes sense when batches are homogeneous and indistinguishable to the business: bulk materials, fuel, small components. Two settings matter and are often overlooked:

  • Average Cost Calc. Type — calculate the average per item, or separately per item, location and variant. The second is more accurate when prices differ materially between locations.
  • Average Cost Period — the averaging window: day, week, month, quarter or year. Shorter periods mean more precise costs and more computation.

Specific is for cases where each unit has its own value: vehicles, equipment, jewellery. It requires serial or lot tracking.

Standard suits manufacturing with an established technology. Cost is fixed at a standard, and the gap between standard and actual accumulates as variances to be analysed separately. It is a powerful management tool but demands discipline: standards must be recalculated, or variances grow until the reporting becomes meaningless.

The main trap: cost adjustment

The most common complaint after go-live is "the cost in the report is not what it should be". Nine times out of ten the cause is not the method but a missing adjustment.

Here is the mechanism: at the moment of shipment the system does not always know the final cost of the batch — freight, customs charges or a late vendor invoice may still be added. So Business Central first posts an expected cost and then recalculates the chain through the Adjust Cost — Item Entries batch job.

Until the adjustment runs, reports show an intermediate picture. The fix is not to run it manually but to automate it: Inventory Setup has an Automatic Cost Adjustment parameter ranging from "never" to "always". Daily recalculation is a workable compromise for most companies; at high volumes it is moved to an overnight window.

Next to it sits Automatic Cost Posting — whether results flow straight into the general ledger. With it switched off, inventory and finance drift apart and the difference has to be hunted down by hand.

-->

Why nobody changes the method after go-live

The Costing Method field is technically editable as long as the item has no entries. After the first transaction, changing it would mean recalculating the entire movement and costing history — which is not a setting change but a project of its own, with reposting and balance reconciliation.

The practical workaround, when the method really must change: create a new item card with the required method, transfer the balance as of a cut-off date and block the old card. The history then splits into two parts, and you live with that in reporting.

The conclusion is straightforward: the costing method is decided before data migration, together with the dimension structure and the chart of accounts. It is one of those parameters where the cost of a mistake is measured in months, not hours.

For everything else that has to be settled before moving data, see our data preparation checklist.

A short decision guide

  • Trading, batches matter, prices rising → FIFO.
  • Homogeneous materials, batches indistinguishable → Average with a daily or monthly averaging period.
  • Unique high-value units → Specific with serial or lot tracking.
  • Repetitive manufacturing with stable technology and a need for variance analysis → Standard.
  • Any scenario under Ukrainian standards → not LIFO.

FAQ

Can the costing method be changed after go-live?
Not through standard functionality once the item has entries. The workaround is to create a new item card with the required method, transfer the balance and block the old card — which splits the history into two periods.
Is LIFO allowed under Ukrainian accounting standards?
No. National accounting standard 9 "Inventories" lists the permitted disposal measurement methods: specific identification, weighted average, FIFO, standard cost and retail price. LIFO is not included, even though Business Central technically supports it.
Why does the reported cost differ from what we expect?
Usually because cost adjustment has not run. Business Central posts an expected cost first and recalculates the final figure through the Adjust Cost — Item Entries batch job. Enable automatic cost adjustment in Inventory Setup.
Can different items use different costing methods?
Business Central allows it technically — the method is per item card. But accounting standards require a single method for inventories of the same purpose and conditions of use, so the policy has to be fixed in the accounting policy and followed when items are created.
What should a manufacturer choose?
If the technology is stable and variance analysis is valuable, Standard. If raw material lines change often and nobody has time to maintain standards, FIFO is safer because it needs no ongoing upkeep.
N
Автор NBCS

Microsoft Dynamics 365 Business Central consultant at NBCS. Explores and documents BC mechanics on a dedicated sandbox.

← All articles

Read next

Ready to modernize your business?

Leave your details and we'll send the details of a free process audit. We reply within one business day.

or write directly: nbcs365@zohomail.eu · +380 98 107 5878