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

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

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:

$\text{Purchase Variance} = (\text{Actual Direct Unit Cost} - \text{Standard Cost}) \times \text{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:

1. 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.
2. 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

1. 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.

2. 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

---

Step-by-Step UI Execution & Reconciliation

Executing Periodic Inventory Cost Adjustment and G/L Posting

1. Press Alt+Q, type Adjust Cost - Item Entries, and select the related link (Report 795).
2. Specify filter criteria (or leave blank to process all items). Click OK to execute.
3. Press Alt+Q, type Post Inventory Cost to G/L, and select the related link (Report 1002).
4. 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:

1. Press Alt+Q, type Inventory Valuation, and run Report 1001 to obtain total inventory asset value by item.
2. Press Alt+Q, type Inventory to G/L Reconciliation, and run Report 10138 (or 5845).
3. 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.