Study guide

12.2 Costing Methods (FIFO, LIFO, Average, Standard) & Ledger Architecture

Microsoft Dynamics 365 Business Central Functional Consultant MB-800

Track your progress as you read

Finished sections get a check mark.

1 Chapter 1: Company Creation & Data Migration

1.1 Creating Companies & Assisted Setup Wizards 1.2 Configuration Packages & RapidStart Worksheets 1.3 Opening Balances & Data Migration Strategies

2 Chapter 2: Security, Profiles & Auditing

2.1 Users, User Setup & Role Center Profiles 2.2 Permission Sets & Security Group Management 2.3 Security Filters, Change Log & Security Auditing

3 Chapter 3: Core System Configuration, Number Series & Copilot

3.1 Company Information, Number Series & Job Queues 3.2 Report Layout Management & Copilot AI Capabilities

4 Chapter 4: Dimensions Architecture & Governance

4.1 Dimension Concepts & Dimension Values 4.2 Global Dimensions vs Shortcut Dimensions 4.3 Default Dimensions, Combinations & Priorities

5 Chapter 5: Workflows & Approvals

5.1 Native Workflow Templates & Approval Hierarchy 5.2 Workflow User Groups & Notification Configuration

6 Chapter 6: Financial Setup, Periods & Currencies

6.1 General Ledger Setup & Accounting Periods 6.2 Payment Terms, Payment Methods & Deferrals 6.3 Multi-Currency Setup & Exchange Rates

7 Chapter 7: Chart of Accounts, Categories & Allocations

7.1 Chart of Accounts Structure & G/L Account Cards 7.2 Account Categories, Subcategories & Financial Reporting 7.3 General Ledger Allocation Accounts & Sharing

8 Chapter 8: Posting Groups & Posting Setup

8.1 Specific Posting Groups: Customer, Vendor, Bank & Inventory 8.2 General Posting Groups & General Posting Setup Matrix 8.3 Inventory Posting Setup & Alternative Posting Groups

9 Chapter 9: General Journals & Recurring Methods

9.1 Bank Account Cards & Posting Setup 9.2 General Journal Templates, Batches & Number Series 9.3 Recurring General Journals & Allocation Methods

10 Chapter 10: Accounts Payable & Accounts Receivable Setup

10.1 Purchases & Payables Setup & Vendor Master 10.2 Sales & Receivables Setup & Customer Master 10.3 Payment Journals, Cash Receipts & Payment Registration Setup

11 Chapter 11: Fixed Assets Setup & Depreciation Books

11.1 Fixed Asset Setup, Classes & Depreciation Books 11.2 Fixed Asset Cards, Main/Component Assets & Depreciation Methods

12 Chapter 12: Inventory Setup, Costing & Locations

12.1 Inventory Setup, Item Types, Categories & Variants 12.2 Costing Methods (FIFO, LIFO, Average, Standard) & Ledger Architecture 12.3 Locations, Transfer Routes & Stockkeeping Units (SKUs)

13 Chapter 13: Logistics Master Data, Pricing & Discounts

13.1 Shipping Agents, Locations & Vendor Lead Times 13.2 Sales Prices, Purchase Prices & Price Lists 13.3 Line Discounts, Invoice Discounts & Thresholds

14 Chapter 14: User Interface, Views, Inspection & Excel

14.1 Personalization, Profile Customization & Designer 14.2 Searching, Advanced Filters, Saved Views & Page Inspection 14.3 Edit in Excel, OneDrive & Data Analysis Mode

15 Chapter 15: Purchase & Sales Order Execution

15.1 Purchase Orders, Receiving, Over-Receipt & Undo 15.2 Purchase Invoicing, Recurring Lines & Blanket Orders 15.3 Sales Quotes, Availability Checks & Order Conversion 15.4 Sales Shipping, Invoicing, Undo & Blanket Orders

16 Chapter 16: Invoices, Credit Memos & Document Corrections

16.1 Direct Invoices, Credit Memos & Document Reopening 16.2 Correct, Cancel & Corrective Credit Memo Procedures 16.3 Combined Shipments/Receipts & Prepayment Workflows

17 Chapter 17: Cash Management, Bank Reconciliation & Ledger Applications

17.1 Processing Payment Journals & Cash Receipt Registrations 17.2 Applying, Unapplying & Reversing Customer/Vendor Entries 17.3 Bank Account Reconciliation & Statement Matching Rules

18 Chapter 18: Operational Adjustments, Inventory & Asset Accounting

18.1 Exchange Rate Adjustments & Dimension Corrections 18.2 Inventory Adjustments, Transfers & Physical Counting 18.3 Fixed Asset Acquisitions, Depreciation Runs & Disposals

12.2 Costing Methods (FIFO, LIFO, Average, Standard) & Ledger Architecture

Key Takeaways Explain This Topic AI

Business Central supports five valuation costing methods (FIFO, LIFO, Specific, Average, Standard) that determine how inbound inventory acquisition costs are allocated to outbound sales and consumption.

Under Standard costing, inventory is valued at a predetermined fixed cost; all purchase price or manufacturing variances are immediately recognized in dedicated General Ledger variance accounts.

The inventory ledger architecture operates on a strict three-tier hierarchy: Item Master (Table 27) -> Item Ledger Entries (Table 32, physical quantities) -> Value Entries (Table 5802, financial valuation).

The Adjust Cost - Item Entries batch job (Report 795) traverses forward application chains to propagate cost modifications (e.g., late vendor invoices, landed cost freight charges) from receipts to outbound sales.

Value Entries integrate into the General Ledger (Table 17) through Inventory Posting Setup (Balance Sheet accounts) and General Posting Setup (Income Statement accounts) either automatically or via the Post Inventory Cost to G/L batch job.

Last updated: September 2026

12.2 Costing Methods (FIFO, LIFO, Average, Standard) & Ledger Architecture

Quick Summary: Dynamics 365 Business Central enforces a strict separation between physical inventory tracking and financial inventory valuation. Physical quantities are recorded in Item Ledger Entries (Table 32), while financial values reside exclusively in Value Entries (Table 5802), which in turn post to General Ledger Entries (Table 17). Organizations select from five distinct Costing Methods : FIFO , LIFO , Specific , Average , and Standard . The Cost Adjustment Engine ( Adjust Cost - Item Entries , Report 795) dynamically recalculates and cascades cost adjustments from inbound receipts to outbound consumption entries, ensuring accurate Cost of Goods Sold (COGS) and inventory valuation.

The Five Core Costing Methods in Business Central

The Costing Method selected on the Item Card dictates how the system values inventory on the balance sheet and how cost is relieved when inventory is shipped or consumed. Costing Method Cost-Flow Principles:

  • FIFO: [First In: $10] ──► Sold First (COGS = $10) | Ending Inventory = Latest Purchases
  • LIFO: [Last In: $15] ──► Sold First (COGS = $15) | Ending Inventory = Oldest Purchases
  • Specific: [SN #1001: $12] ──► Sold Specifically | Matched directly to serial/lot unit cost
  • Average: [Pool: Total Cost / Total Qty] | Weighted average recalculated across period
  • Standard: [Fixed Baseline: $11] | Variances posted to G/L; Unit Cost remains fixed
  • Detailed Analysis of Costing Methods

Costing Method Inbound Cost Flow Outbound Cost Relief (COGS) Ending Inventory Valuation Recommended Industry / Use Case

FIFO (First-In, First-Out) Actual purchase or production cost recorded upon receipt. Oldest open inbound cost applied to outbound sales first. Reflects the most recent purchase and manufacturing costs. Retail, distribution, and perishables where inventory moves chronologically. Standard international practice.

LIFO (Last-In, First-Out) Actual purchase or production cost recorded upon receipt. Newest open inbound cost applied to outbound sales first. Reflects older, historical purchase costs. Permitted under US GAAP for specific tax environments; strictly prohibited under IFRS .

Specific Actual cost tied directly to an individual serial or lot number. Exact cost of the specifically tracked serial/lot number is relieved. Exact physical valuation of the specific units remaining on hand. High-value, uniquely tracked items (e.g., luxury watches, heavy machinery, specialized vehicles). Requires Item Tracking.

Average Inbound costs are pooled into a weighted average calculation. Valued at the weighted average unit cost across the designated period. Weighted average of remaining quantities across the average cost period. Commodities, liquids, bulk grains, chemicals, or fuels where individual units cannot be physically distinguished.

Standard Received at actual invoice cost; immediately adjusted to Standard Cost. Outbound movements always relieved at the predetermined Standard Cost . Inventory balance is strictly carried at fixed Standard Cost . Repetitive manufacturing and high-volume assembly with predictable bills of materials and labor routings.

The Standard Costing Architecture & Variance Accounts

When an item uses the Standard costing method:

The Standard Cost field on the Item Card defines the static target cost.

Outbound transactions (sales, consumption) are always valued at Standard Cost.

Discrepancies between the actual purchase price on vendor invoices and the Standard Cost are posted directly to Purchase Variance G/L accounts defined in General Posting Setup: Purchase Variance = ( Actual Direct Unit Cost − Standard Cost ) × Invoiced Quantity \text{Purchase Variance} = (\text{Actual Direct Unit Cost} - \text{Standard Cost}) \times \text{Invoiced Quantity} Purchase Variance = ( Actual Direct Unit Cost − Standard Cost ) × Invoiced Quantity

The Standard Cost Worksheet ( Alt+Q -> type Standard Cost Worksheet , Page 5841) is used periodically (e.g., annually) to model, roll up, and execute bulk standard cost updates across manufacturing routings, BOMs, and purchased items.

Average Cost Calculation Settings

For items using Average costing, calculations are governed by two fields in Inventory Setup :

Average Cost Calc. Type:

Item : Calculates a single weighted average cost across the entire company.

Item & Location & Variant : Calculates distinct weighted average costs per location and variant combination.

Average Cost Period: Defines the rolling calculation window ( Day , Week , Month , or Accounting Period ). A shorter period (e.g., Day ) recalculates average costs dynamically on daily receipts, while Month calculates an aggregated monthly rate.

The Cost Adjustment Engine & Periodic Jobs

In modern supply chains, final purchase costs are rarely known at the moment physical goods are received. Factors such as retroactive discounts, freight item charges, customs tariffs, and late vendor invoices arrive weeks after items have already been sold and shipped. Business Central handles this reality through the Cost Adjustment Engine . Cost Adjustment Propagation Pipeline:

  • [Purchase Receipt: 10 units @ $100] ──► [Sales Shipment: 10 units sold, COGS recorded @ $100]
  • │
  • ▼ (Late Vendor Freight Invoice adds $200 Item Charge)
  • [Value Entry: Direct Cost Adj. +$200]
  • │
  • ▼ (Adjust Cost - Item Entries executed)
  • [Value Entry: Adjustment to Sales COGS +$200] ──► [G/L: Debit COGS $200 / Credit Invt. $200]
  • The Two Essential Periodic Inventory Batch Jobs

Adjust Cost - Item Entries (Report 795):

Traverses the forward application chain from inbound Item Ledger Entries to outbound Item Ledger Entries.

Compares actual invoiced costs against initial estimated costs.

Generates new adjustment Value Entries (Table 5802) to reconcile cost differences on both remaining inventory and closed sales shipments.

Automatically triggered if Automatic Cost Adjustment is set to Always in Inventory Setup, or scheduled via Job Queue if set to Never .

Post Inventory Cost to G/L (Report 1002):

Scans Table 5802 ( Value Entry ) for any records where Cost Posted to G/L is zero.

Creates balanced General Ledger Entries (Table 17) mapped to the Chart of Accounts via Inventory Posting Setup and General Posting Setup.

Updates the Cost Posted to G/L field on the Value Entry to prevent duplicate posting.

Triggered synchronously upon invoice posting if Automatic Cost Posting is enabled in Inventory Setup, or executed periodically via Job Queue.

The Fundamental Ledger Architecture: Triad & G/L Integration

Understanding the relationship between master data, physical quantities, financial valuation, and general ledger accounts is a foundational skill measured on the MB-800 exam. Business Central Inventory Ledger Triad:

  • ┌────────────────────────────────────────────────────────┐
  • │ Table 27: ITEM │
  • │ Master Record: No., Description, Costing Method, UOM │
  • │ FlowFields: Inventory, Quantity on Purchase Order │
  • └───────────────────────────┬────────────────────────────┘
  • │
  • Physical Stock Movements
  • ▼
  • ┌────────────────────────────────────────────────────────┐
  • │ Table 32: ITEM LEDGER ENTRY (ILE) │
  • │ Tracks Physical Quantities & Lot/Serial Tracking │
  • │ Fields: Entry No., Item No., Quantity, Remaining Qty │
  • │ Entry Types: Purchase, Sale, Pos/Neg Adjmt, Transfer │
  • └───────────────────────────┬────────────────────────────┘
  • │ 1 to Many
  • Financial Valuation Entries
  • ▼
  • ┌────────────────────────────────────────────────────────┐
  • │ Table 5802: VALUE ENTRY (VE) │
  • │ Financial Quantification of Inventory Movements │
  • │ Fields: Cost Amount (Actual), Cost Amount (Expected) │
  • │ Cost Posted to G/L, Item Ledger Entry No. │
  • └───────────────────────────┬────────────────────────────┘
  • │
  • Accounting Matrix Mapping
  • ▼
  • ┌────────────────────────────────────────────────────────┐
  • │ Table 17: GENERAL LEDGER ENTRY (GLE) │
  • │ Debits & Credits in Balance Sheet and P&L Accounts │
  • │ Mapped via Inventory Posting Setup & Gen Posting Setup│
  • └────────────────────────────────────────────────────────┘
  • Detailed Breakdown of the Ledger Tables

Item (Table 27): The master record. Does not store quantity as a static column; fields like Inventory and Net Change are FlowFields that dynamically calculate sums from Table 32 filtered by dates, locations, and variants.

Item Ledger Entry (Table 32): The physical quantity ledger. Every movement of goods (Purchase Receipt, Sales Shipment, Positive Adjustment, Negative Adjustment, Transfer, Consumption, Output) inserts an immutable Item Ledger Entry. Crucial fields include Quantity , Invoiced Quantity , Remaining Quantity , and the Open boolean flag (which indicates whether unapplied inbound stock remains).

Value Entry (Table 5802): The financial valuation ledger. One Item Ledger Entry can have multiple Value Entries. For example, when an item is received and invoiced, received-not-invoiced creates an expected cost Value Entry, invoicing creates an actual cost Value Entry, a freight Item Charge creates a third Value Entry, and a cost adjustment batch creates a fourth Value Entry.

General Ledger Entry (Table 17): The corporate financial ledger. Posts debits and credits to Balance Sheet and Income Statement accounts using the posting group configuration.

The Posting Group Accounting Matrix

Transaction Event Inventory Posting Setup (Location + Invt. Posting Group) General Posting Setup (Gen. Bus. + Gen. Prod. Posting Group)

Purchase Receipt (Expected) Debit: Inventory Account (Interim) Credit: Invt. Accrual Acc. (Interim)

Purchase Invoice (Actual) Credit: Inventory Account (Interim) ; Debit: Inventory Account Debit: Invt. Accrual Acc. (Interim) ; Credit: Accounts Payable (Vendor Posting Group)

Sales Shipment (Expected) Credit: Inventory Account (Interim) Debit: COGS Account (Interim)

Sales Invoice (Actual) Debit: Inventory Account (Interim) ; Credit: Inventory Account Credit: COGS Account (Interim) ; Debit: COGS Account ; Credit: Sales Account / Debit: AR

Purchase Variance (Standard) N/A (Standard Cost debits Inventory Account) Debit/Credit: Purchase Variance Account

  • Inventory Adjustment Debit/Credit: Inventory Account Credit/Debit: Inventory Adjustment Account
  • Step-by-Step UI Execution & Reconciliation
  • Executing Periodic Inventory Cost Adjustment and G/L Posting

Press Alt+Q , type Adjust Cost - Item Entries , and select the related link (Report 795).

Specify filter criteria (or leave blank to process all items). Click OK to execute.

Press Alt+Q , type Post Inventory Cost to G/L , and select the related link (Report 1002).

Select the Posting Method ( Per Entry or Per Posting Group ), set the posting date filter, and click Post .

Reconciling Inventory Valuation to the General Ledger

To verify that the subledger matches the balance sheet:

Press Alt+Q , type Inventory Valuation , and run Report 1001 to obtain total inventory asset value by item.

Press Alt+Q , type Inventory to G/L Reconciliation , and run Report 10138 (or 5845).

Compare the Inventory Value column against the Inventory G/L Amount column. Any difference highlights unposted Value Entries or direct postings made manually to G/L inventory accounts.

Common Pitfalls & Exam Traps

Pitfall 1: Changing Costing Method on an Active Item. Once an Item Ledger Entry exists for an item, the Costing Method field is permanently locked. Business Central blocks editing to protect ledger consistency. Changing the costing method requires adjusting inventory to zero, applying all open entries, blocking the item, and creating a new item card.

Pitfall 2: Direct Posting Allowed on Inventory G/L Accounts. If the Direct Posting checkbox is enabled on the Inventory Balance Sheet G/L account (Table 15), users can post manual General Journal lines directly to the asset account. This causes catastrophic reconciliation discrepancies between Table 5802 (Value Entries) and Table 17 (G/L Entries). Direct Posting must always be No on inventory control accounts.

Pitfall 3: Failing to Run Cost Adjustment Prior to Month-End Close. If Automatic Cost Adjustment is disabled and accountants close the accounting period without running Adjust Cost - Item Entries , Cost of Goods Sold and Gross Profit figures will be severely distorted by unallocated price variances and landed costs.

Pitfall 4: Misunderstanding Value Entries vs Item Ledger Entries. An Item Ledger Entry's quantity never changes when price adjustments occur; the financial adjustment is recorded strictly as a new line in the Value Entry table.

Loading diagram... Business Central Inventory Ledger Architecture and Posting Pipeline