7.3 Inventory Closing, Recalculation, Settlement, and ABC Classification

7.3 Inventory Closing, Recalculation, Settlement, and ABC Classification

Quick Answer: In actual-cost inventory valuation models (FIFO, LIFO, Weighted average, Date-weighted average), Dynamics 365 Supply Chain Management posts daily operational inventory issues at an estimated running average cost. The periodic Inventory close executes the formal settlement process, matching closed receipt transactions to issue transactions according to the item's Item model group valuation model, calculating cost variances, and posting adjusting General Ledger vouchers. Inventory recalculation provides an interim, non-permanent cost true-up without locking periods. Concurrently, ABC classification groups released products into categories (A, B, C) based on Pareto value models (Revenue, Margin, Carrying value, Count frequency) to optimize cycle counting frequencies.

---

1. Periodic Inventory Close and Settlement Principles

Dynamics 365 Supply Chain Management distinguishes between Standard cost inventory models (where items carry a fixed cost and variances post at transaction time) and Actual cost inventory models (FIFO, LIFO, LIFO date, Weighted average, Weighted average date).

Daily Operations: Sales Order Shipped/Invoiced ──> Deducted/Sold at Running Average Cost
                                                           │
Periodic Inventory Close: Receipts matched to Issues ──────┴──> Settled to Exact Model Cost (FIFO/LIFO/Wtd Avg)
                                                           │
General Ledger Adjustment: Variance Voucher Posted ────────┘    (Dr/Cr COGS vs. Dr/Cr Physical Inventory Asset)

Running Average vs. Settled Cost

• Daily Real-Time Operations: When sales orders, transfer orders, or production picking lists post physical issues (Deducted) or financial invoices (Sold), D365 SCM does not immediately match those issues to specific historical purchase receipts. Instead, it issues inventory at the current running average cost (calculated as Total inventory value / Total physical on-hand quantity).
• Periodic Inventory Close: Executed at Inventory management > Periodic tasks > Closing and adjustment > Close inventory.
• The Settlement Engine: The closing process matches open receipt transactions (Purchased) to open issue transactions (Sold):
  • FIFO (First-In, First-Out): Settles the earliest open receipts against the earliest issues.
  • LIFO (Last-In, First-Out): Settles the latest open receipts against the earliest issues.
  • Weighted Average: Calculates a uniform weighted average cost for all receipts in the closing period and settles all issues at that unified rate.
• Period Lock: Running an inventory close permanently locks the inventory subledger up to the specified Close inventory up to date. Users cannot post any inventory transaction with a financial date on or prior to the closing date.

---

2. Principle of Inventory Settlement and Financial Cost Adjustments

When the inventory close engine calculates a discrepancy between the running average cost applied at the time of issue and the true cost of the settled receipt, it generates an Inventory settlement record in the InventSettlement table.

$\text{Settlement Adjustment} = \text{Settled Acquisition Cost} - \text{Running Average Issue Cost}$

Transaction Status Transitions

• Issues (InventTrans): Transactions that were financially invoiced with status Sold are updated with an adjusted cost amount. The transaction field ValueOpen changes from Yes to No (closed).
• Receipts (InventTrans): Transactions with status Purchased that are fully consumed by settled issues have their ValueOpen field set to No. Partial settlements leave the receipt partially open for subsequent periods.

General Ledger Accounting Entries

To synchronize the inventory subledger with the General Ledger, inventory closing posts adjusting vouchers:

Scenario: Running average cost was $10.00; true settled FIFO cost is $12.00 (+ $2.00 variance):
  Debit:  Cost of units, invoiced (COGS)           $2.00
  Credit: Inventory, issue (Inventory Asset)       $2.00

Scenario: Running average cost was $10.00; true settled FIFO cost is $8.50 (- $1.50 variance):
  Debit:  Inventory, issue (Inventory Asset)       $1.50
  Credit: Cost of units, invoiced (COGS)           $1.50

[!IMPORTANT] Exam Tip — Physical vs. Financial Cost: Settlement only applies to financially closed transactions (Sold and Purchased). Transactions that are only physically updated (Deducted or Received) cannot be settled by inventory closing until they are financially invoiced.

---

3. Inventory Recalculation vs. Inventory Closing

Because inventory closing permanently locks the period, enterprises typically execute it once per fiscal month. However, waiting 30 days for cost adjustments can distort interim management reporting. D365 SCM provides Inventory recalculation (Inventory management > Periodic tasks > Closing and adjustment > Recalculation).

---

4. Reversing Closed Inventory and Cancelling Recalculations

If an inventory close or recalculation was posted using an incorrect date, incorrect item model parameters, or prior to posting critical vendor invoices, the transactions can be unraveled via Inventory management > Periodic tasks > Closing and adjustment > Cancellation.

Inventory management
└── Periodic tasks
    └── Closing and adjustment
        └── Cancellation
            ├── Calculation (Reverses Inventory Recalculation)
            └── Close inventory (Reverses Inventory Close - Strict Reverse Chronological Order)

Cancellation Rules and Mechanics

1. Cancelling Recalculation: Selecting Cancellation > Calculation allows reversing a specific recalculation run. D365 SCM posts reversing General Ledger vouchers and resets issue transaction valuations back to their running average state.
2. Cancelling Inventory Close:
   • Selecting Cancellation > Close inventory reverses a finalized inventory close.
   • Strict Reverse Chronological Sequence: An inventory close can only be reversed if it is the most recent close executed. If a company closed inventory on January 31, February 28, and March 31, an accountant cannot cancel January without first reversing March, then February.
   • Subledger and Ledger Impact: Reversing the close deletes the InventSettlement records, resets ValueOpen back to Yes, removes the period lock on that date, and posts exact reversing vouchers to the General Ledger.

---

5. Ledger Integration and Subledger Reconciliation

Inventory closing and recalculation derive General Ledger posting accounts from the centralized Inventory posting profile (Inventory management > Setup > Posting > Posting > Inventory tab).

• Cost of units, invoiced: The Cost of Goods Sold (COGS) profit and loss account.
• Inventory, issue: The balance sheet asset account credited when inventory is issued.
• Inventory, receipt: The balance sheet asset account debited when inventory is received.
• Inventory rounding: Dedicated P&L account capturing micro-fractional penny rounding variances resulting from currency conversions or division across large unit quantities.

Subledger-to-Ledger Reconciliation Tools

• Inventory Value Report (Inventory management > Inquiries and reports > Costing analysis reports > Inventory value): The primary audit artifact reconciling physical inventory quantity and financial inventory valuation in InventTrans against General Ledger balance sheet control accounts.
• Potential Conflicts Report (Inventory management > Periodic tasks > Clean up > Potential conflicts - Inventory and General Ledger): Analyzes discrepancies caused by manual journal entries made directly to inventory control accounts or transactions bypassing the posting profile.

---

6. ABC Classification Architecture and Valuation Models

ABC classification categorizes released products based on the Pareto principle (the 80/20 rule), establishing that a minority of inventory items typically represents the majority of financial value, turnover, or margin. D365 SCM provides four distinct ABC classification models:

ABC Classification Models:
├── 1. Revenue Model: Categorizes by top gross sales revenue
├── 2. Margin Model: Categorizes by gross profit contribution (Revenue - Cost)
├── 3. Carrying Value Model: Categorizes by capital tied up in physical on-hand stock
└── 4. Count Frequency (Internal Interest): Categorizes by transaction velocity to drive cycle counting

ABC Category Definitions

• Category A (High Value / High Velocity): Represents approximately 70–80% of total financial value, but only 10–20% of SKU count. Requires tight inventory control, frequent cycle counts, and low safety stocks.
• Category B (Medium Value / Moderate Velocity): Represents approximately 15–20% of total financial value and 30% of SKU count. Moderately managed with quarterly counts.
• Category C (Low Value / High Volume / Slow Moving): Represents 5–10% of total financial value, but 50% of SKU count. Managed with bulk re-order points and semi-annual or annual counts.

The Four Calculation Models

1. Revenues: Evaluates historical or projected sales revenue generated by each item over a specified date range.
2. Margin: Evaluates gross margin contribution (Total Revenue minus Total Cost of Goods Sold), isolating items that deliver the highest net profitability.
3. Carrying Value (Value): Evaluates the total financial capital tied up in inventory based on current on-hand quantities multiplied by cost price.
4. Count Frequency (Internal Interest / Turnover): Evaluates transaction movement frequency (number of inventory issues/picks), identifying high-turnover SKUs regardless of unit dollar cost.

---

7. Configuring and Running ABC Classification Periodic Jobs

ABC classification is configured and executed via periodic batch jobs:

Inventory management
└── Periodic tasks
    └── ABC classification
        ├── Classification model: Revenues, Margin, Value, or Count frequency
        ├── Date range: Historical transaction lookback period
        ├── Threshold percentages: A = 80%, B = 15%, C = 5%
        └── Updates Released Products > Manage inventory FastTab > ABC classification

Operational Steps

1. Setup ABC Parameters: Navigate to Inventory management > Setup > Inventory > ABC codes. Configure the code groups for Value, Margin, Revenue, and Carrying value.
2. Execute Periodic Job: Navigate to Inventory management > Periodic tasks > ABC classification.
3. Define Classification Criteria:
   • ABC code: Select which dimension to calculate (Revenues, Margin, Value, or Link / Count frequency).
   • From date / To date: The historical analysis period (e.g., preceding 12 months).
   • Percentages: Specify cumulative cutoff thresholds (e.g., Category A = 80%, Category B = 15%, Category C = 5%).
4. Batch Execution & Item Master Updates:
   • The job evaluates all inventory transactions meeting the criteria, sorts items by descending value, applies the percentage cutoffs, and automatically updates the corresponding fields on the Released product record (Product information management > Released products > Manage inventory FastTab > ABC classification):
     • ABC revenue
     • ABC margin
     • ABC value (Carrying value)
     • ABC count frequency

Integration with Cycle Counting Groups

Once ABC codes are assigned to released products, they directly automate warehouse cycle counting schedules. An enterprise creates three Counting groups (Inventory management > Setup > Inventory > Counting groups):

• Group A: Counting code = Period, Counting period = 30 days.
• Group B: Counting code = Period, Counting period = 90 days.
• Group C: Counting code = Period, Counting period = 360 days.

Warehouse supervisors run Create > Counting groups in the Counting journal, ensuring that high-value Class A items are physically audited twelve times per year, while low-value Class C items are counted annually.