Study guide

7.3 Inventory Closing, Recalculation, Settlement, and ABC Classification

Microsoft Dynamics 365 Supply Chain Management Functional Consultant MB-330

Track your progress as you read

Finished sections get a check mark.

1 Chapter 1: Product Master and Released Products

1.1 Product Masters, Variants, and Configuration Technologies 1.2 Product Templates, Category Hierarchies, and Product Lifecycle States 1.3 Product Attributes, Attribute Types, and Attribute Groups

2 Chapter 2: Bills of Materials (BOM) and Formulas

2.1 BOM Lines, Line Types, and Component Configurations 2.2 BOM Versions, Activation, Approvals, and Circularity Checks 2.3 BOM Calculations, Cost Group Types, Flushing Principles, and Scrap Handling

3 Chapter 3: Product Prerequisites and Dimension Groups

3.1 Product, Storage, and Tracking Dimension Groups 3.2 Item Model Groups, Inventory Models, and Physical/Financial Posting 3.3 Reservation Hierarchies and Unit Sequence Groups

4 Chapter 4: Additional Product Details and Warehouse Fit

4.1 Bar Codes, GTINs, and Product Unit Conversions 4.2 Default Order Settings and Site-Specific Order Settings 4.3 Product Filter Codes and Physical Warehouse Dimensions

5 Chapter 5: Inventory Costing and Pricing

5.1 Costing Versions, Costing Sheets, and Standard Costing 5.2 Base Item Prices, Price Groups, and Price Tolerances 5.3 Trade Agreements, Price/Discount Journals, and Smart Rounding

6 Chapter 6: Inventory Journals and Core Transactions

6.1 Movement, Adjustment, and Transfer Journals 6.2 Counting Journals, Tag Counting, and Cycle Count Adjustments 6.3 Item Arrival Journals, Output Orders, and BOM Journals

7 Chapter 7: Inventory Operations, Blocking, and Closing

7.1 Transfer Orders, In-Transit Warehouses, and Delivery Schedules 7.2 Inventory Blocking Mechanisms, Batch Disposition Codes, and Inventory Status 7.3 Inventory Closing, Recalculation, Settlement, and ABC Classification

8 Chapter 8: Quality Management and Nonconformance

8.1 Quality Control Setup: Tests, Test Groups, and Item Sampling 8.2 Quality Associations, Automatic Generation, and Quality Orders Processing 8.3 Nonconformances, Corrections, Corrective Operations, and Quarantine Orders

9 Chapter 9: Asset Management: Setup and Maintenance

9.1 Assets, Asset Types, and Functional Locations Setup 9.2 Asset Lifecycle Models, Lifecycle States, and Asset Loans 9.3 Work Orders Configuration, Work Order Settings, and Maintenance Capacity Management 9.4 Maintenance Plans, Maintenance Requests, Work Order Scheduling, and Journal Consumption

10 Chapter 10: Procurement and Sourcing Configuration

10.1 Vendors, Vendor Groups, and Procurement Category Hierarchies 10.2 Purchasing Policies, Spending Limits, Procurement Workflows, and Charge Codes 10.3 Purchase Agreements, Vendor Rebates, and Vendor Collaboration Portal

11 Chapter 11: Purchase Order Lifecycle and Consignment

11.1 Purchase Requisitions, Requests for Quotation (RFQs), and Bidding Processes 11.2 Purchase Orders Creation, Over/Under-Delivery Tolerances, Delivery Schedules, and Product Receipt 11.3 Consignment Inventory Replenishment/Ownership Change and Vendor Return Orders

12 Chapter 12: Landed Cost and Inbound Logistics

12.1 Landed Cost Architecture: Voyages, Shipping Containers, Folios, and Journey Templates 12.2 Cost Type Codes, Auto-Costs, and Allocation Methods 12.3 Tracking Control Center, Goods in Transit Orders, and Over/Under Tolerances

13 Chapter 13: Sales Management and Order Processing

13.1 Customers, Customer Groups, Sales Agreements, and Sales Quotations 13.2 Sales Order Processing, Manual and Automatic Reservation, and Sales Returns 13.3 Order Promising: ATP, CTP, Delivery Schedules, and Product Bundles 13.4 Intercompany Trading Chains, Sales Commissions, and Customer Rebates

14 Chapter 14: Warehouse Setup and Core Infrastructure

14.1 Warehouse Topology: Sites, Warehouses, Locations, Profiles, Formats, and Zones 14.2 Work Policies, Work Breaks, and Packing Dimensions 14.3 Wave Templates, Work Templates, and Location Directives Configuration 14.4 Label Layouts, Document Routing, Wave Label Printing, and GS1 Number Sequences

15 Chapter 15: Warehouse Execution Processes

15.1 Inbound Receiving Processes, Planned Cross-Docking, and Putaway 15.2 Outbound Waves, Wave Processing, Picking (Order, Cluster, Batch), and Manual Packing 15.3 Replenishment Strategies (Wave vs. Min/Max) and Inventory Movements via Warehouse Work 15.4 Cycle Counting Plans, Thresholds, Blind Counting, and Automated Containerization

16 Chapter 16: Transportation Management and Logistics

16.1 Shipping Carriers, Carrier Groups, Carrier Services, and Rate/Route Engines 16.2 Route Plans, Route Guides, Inbound/Outbound Loads, and Dock Appointment Scheduling 16.3 Freight Bills, Freight Invoicing, and Manual/Automatic Freight Reconciliation

17 Chapter 17: Warehouse Management Mobile App

17.1 Mobile App Installation, Display Settings, Connection Profiles, and Warehouse Worker Setup 17.2 Mobile Device Menus, Work-Based and Indirect Menu Items, and Inventory Inquiries 17.3 Step Detours Configuration and GS1 Barcode Scanning Implementation

18 Chapter 18: Master Planning and Planning Optimization

18.1 Master Planning Parameters, Coverage Groups, and Planning Optimization Cloud Service Architecture 18.2 Item Coverage Settings, Positive/Negative Days, Time Fences, and Action Messages 18.3 Running Master Planning, Analyzing Results, Planned Orders Firming, and Supply Schedule 18.4 Safety Stock Journals, Safety Margins, and Copilot in Dynamics 365 Supply Chain Management

7.3 Inventory Closing, Recalculation, Settlement, and ABC Classification

Key Takeaways Explain This Topic AI

Periodic inventory closing settles inventory issue transactions against receipt transactions according to actual-cost valuation models (FIFO, LIFO, Weighted average), updating running average costs to true financial acquisition costs.

Inventory recalculation performs intermediate cost adjustments and updates running average valuations without permanently closing the period or locking past transaction dates.

Inventory closing and recalculation runs can be cancelled via the Cancellation menu; however, inventory closes must be reversed in strict reverse chronological sequence.

Inventory closing adjustments generate General Ledger vouchers that post to Cost of units, invoiced, Inventory issue, and Inventory receipt accounts to ensure subledger-to-GL reconciliation.

ABC classification categorizes items across Revenue, Margin, Carrying value, and Count frequency models, enabling automated cycle count scheduling based on Pareto inventory value principles.

Last updated: September 2026

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. Settlement Adjustment = Settled Acquisition Cost − Running Average Issue Cost \text{Settlement Adjustment} = \text{Settled Acquisition Cost} - \text{Running Average Issue Cost} Settlement Adjustment = Settled Acquisition Cost − 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 ).

Functional Characteristic Inventory Recalculation Periodic Inventory Close

Execution Frequency Daily, weekly, or bi-weekly. Monthly, quarterly, or annually at fiscal period close.

Period Locking Does not lock the period. Users can continue posting back-dated transactions. Permanently locks the period. Prevents posting inventory transactions on or before the close date.

Settlement Permanence Non-permanent (temporary). Adjustments are intermediate; subsequent recalculations or closes overwrite them. Permanent settlement. Issues and receipts are permanently linked and settled in InventSettlement .

Transaction Status Leaves ValueOpen = Yes on inventory transactions. Updates ValueOpen = No on fully settled transactions.

General Ledger Impact Posts adjusting vouchers to GL. When a future recalculation or close runs, previous recalculation vouchers are reversed. Posts permanent adjusting vouchers to the General Ledger.

Primary Objective Provides accurate mid-month COGS and balance sheet valuations for operational management reporting. Ensures formal statutory financial compliance and final balance sheet sign-off.

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

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.

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

Revenues : Evaluates historical or projected sales revenue generated by each item over a specified date range.

Margin : Evaluates gross margin contribution (Total Revenue minus Total Cost of Goods Sold), isolating items that deliver the highest net profitability.

Carrying Value (Value) : Evaluates the total financial capital tied up in inventory based on current on-hand quantities multiplied by cost price.

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

Setup ABC Parameters : Navigate to Inventory management > Setup > Inventory > ABC codes . Configure the code groups for Value, Margin, Revenue, and Carrying value.

Execute Periodic Job : Navigate to Inventory management > Periodic tasks > ABC classification .

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%).

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.