Study guide

3.2 Item Model Groups, Inventory Models, and Physical/Financial Posting

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

3.2 Item Model Groups, Inventory Models, and Physical/Financial Posting

Key Takeaways Explain This Topic AI

The 'Stocked product' parameter in the Item Model Group dictates whether an item creates physical and financial inventory transactions in InventTrans or is expensed immediately to the general ledger upon receipt.

D365 SCM supports periodic inventory models (FIFO, LIFO, Weighted average) requiring Inventory Close for final settlement, perpetual models (Moving average) that revalue perpetually at invoice, and Standard cost which generates real-time purchase price and production variances.

Physical negative inventory permits packing slip and picking operations below zero on-hand quantity, but introduces running cost distortions and is strictly incompatible with Standard cost and Moving average models.

Post physical inventory records provisional balance sheet assets and accrued liabilities at product receipt and packing slip, which are subsequently reversed and settled when the final financial invoice posts.

The 'Accrue liability on product receipt' parameter ensures compliance with accounting matching principles by posting un-invoiced receipts to a ledger liability accrual account before vendor invoices arrive.

Last updated: September 2026

3.2 Item Model Groups, Inventory Models, and Physical/Financial Posting

Note

While dimension groups define where and how items are stored and tracked, Item Model Groups (IMG) define how inventory is accounted for, valued, and integrated with the General Ledger . Located under Cost management > Inventory accounting setup policies > Item model groups (or Inventory management > Setup > Inventory > Item model groups ), every released product must be linked to an Item Model Group.

The Stocked Product Parameter: Stocked vs. Non-Stocked Items

The most foundational toggle on the Item Model Group is Stocked product : +---------------------------------------------------------------------------------+

  • | STOCKED PRODUCT PARAMETER |
  • +---------------------------------------+-----------------------------------------+
  • | Stocked Product = YES | Stocked Product = NO |
  • | - Physical & financial inventory in | - Non-stocked / Expense / Service items |
  • | InventTrans and InventSum. | - No InventTrans or InventSum records. |
  • | - Balance sheet asset accounting. | - Direct P&L expense on receipt/invoice.|
  • | - Participates in Inventory Close. | - Bypassed by Inventory Close. |
  • | - Can be reserved, picked, counted. | - Cannot be counted or reserved in WMS. |
  • +---------------------------------------+-----------------------------------------+

Stocked Product = Yes : Used for tangible raw materials, sub-assemblies, and finished goods. The item maintains continuous physical on-hand quantity balances in InventSum and creates transactional records in InventTrans . It participates in inventory counting, cycle counting, safety stock planning, and Inventory Close.

Stocked Product = No : Used for service items, consulting hours, subcontracted labor, freight fees, and indirect consumables (office supplies). The system does not create InventTrans records or track on-hand balances. When a purchase order line for a non-stocked item is received and invoiced, the acquisition cost posts directly to a Profit & Loss expense account or WIP account, completely bypassing the inventory subledger.

Inventory Valuation Models: Periodic, Perpetual, and Standard Cost

Dynamics 365 Supply Chain Management supports seven distinct inventory valuation models on the Item Model Group:

Inventory Model Valuation Type Settlement Method Inventory Close Required? Negative Inventory Supported? Production Supported?

  • FIFO (First In, First Out) Periodic Chronological settlement of oldest receipts to oldest issues Yes Yes Yes
  • LIFO (Last In, First Out) Periodic Chronological settlement of newest receipts to oldest issues Yes Yes Yes
  • LIFO Date Periodic Settles newest receipts on transaction date to issues Yes Yes Yes
  • Weighted Average Periodic Pools receipts during period into a single average unit cost Yes Yes Yes
  • Weighted Average Date Periodic Calculates a daily weighted average cost price Yes Yes Yes
  • Standard Cost Predetermined Fixed cost from Costing Version; variances post to P&L No (Settlement) No Yes
  • Moving Average Perpetual Perpetual recalculation upon each purchase invoice No No No
  • 1. Periodic Valuation Models (FIFO, LIFO, Weighted Average)

Periodic models record issue transactions (e.g., sales order packing slips) at a provisional running average cost price . At month-end, the cost accounting team executes Inventory Closing ( Cost management > Inventory accounting > Closing and adjustment ). During Inventory Close, the system:

Evaluates all closed receipts and issues during the period.

Settles receipt costs against issue costs according to the selected model (e.g., matching the oldest purchase receipts to the oldest sales shipments under FIFO).

Generates adjustment vouchers in the General Ledger to adjust the provisional Cost of Goods Sold (COGS) to the true settled acquisition cost.

2. Standard Cost

Under Standard Cost, items transact at a predetermined, fixed cost price configured in a Costing Version ( Cost management > Predetermined cost policy setup > Costing versions ).

Differences between the actual purchase order price and the standard cost post immediately to Purchase price variance (PPV) accounts upon invoice.

Differences in manufacturing consumption post to production variance accounts (lot size, quantity, substitution variances).

Inventory Close does not settle standard cost transactions; it only verifies that transactions are mathematically closed.

3. Moving Average

Moving Average is a perpetual costing model. The unit cost of on-hand inventory is recalculated dynamically in real time whenever a purchase invoice is posted: New Moving Average Cost = ( Current On-Hand Value + Invoiced Purchase Value ) ( Current On-Hand Quantity + Invoiced Purchase Quantity ) \text{New Moving Average Cost} = \frac{(\text{Current On-Hand Value} + \text{Invoiced Purchase Value})}{(\text{Current On-Hand Quantity} + \text{Invoiced Purchase Quantity})} New Moving Average Cost = ( Current On-Hand Quantity + Invoiced Purchase Quantity ) ( Current On-Hand Value + Invoiced Purchase Value ) ​

If purchase invoices arrive at a price different from the product receipt, the system immediately posts price differences to a Cost difference for moving average account if on-hand inventory has already been issued. Inventory Close does not adjust or settle moving average transactions .

Negative Inventory Dynamics and System Risks

The Item Model Group controls whether inventory quantities and values can drop below zero: +---------------------------------------------------------------------------------+

  • | NEGATIVE INVENTORY CONTROLS |
  • +---------------------------------------+-----------------------------------------+
  • | Physical Negative Inventory | Financial Negative Inventory |
  • | - Allows packing slip/picking below 0.| - Allows sales invoice before PO invoice|
  • | - Accommodates fast dock-to-floor flow| - Prevents invoicing blockages. |
  • | - Distorts provisional running costs. | - Carries risk of retroactive COGS |
  • | - FORBIDDEN for Standard/Moving Avg. | adjustments upon PO invoicing. |
  • +---------------------------------------+-----------------------------------------+
  • 1. Physical Negative Inventory

When enabled, workers can post physical deductions (sales order packing slips, warehouse mobile device picks, production material consumption) even if available physical on-hand is zero or negative.

Operational Benefit : In rapid distribution environments, physical goods often arrive at the receiving dock and are placed into picking bins before warehouse clerks have keyed the inbound product receipt into the system. Physical negative inventory prevents warehouse operations from grinding to a halt.

Financial Hazard : Deducting items at zero on-hand forces D365 SCM to invent a provisional running cost (often the active cost price or base item price). When the actual receipt is posted later, substantial settlements and rounding variances must be calculated. Standard Cost and Moving Average models strictly prohibit physical negative inventory .

2. Financial Negative Inventory

When enabled, an organization can post financial deductions (customer sales invoices) when the inventory is physically available (product receipt posted), even if the corresponding purchase orders have not yet been financially invoiced by the vendor.

If Financial negative inventory is disabled , a sales order cannot be invoiced to a customer until the underlying purchase order has been fully vendor-invoiced. For companies with high vendor invoice processing lag, disabling this parameter causes significant billing delays.

General Ledger Integration: Physical and Financial Postings

The Ledger integration FastTab on the Item Model Group governs when and how subledger inventory events write journal entries to the General Ledger: +---------------------------------------------------------------------------------+

  • | LEDGER POSTING PARAMETERS |
  • +---------------------------------------------------------------------------------+
  • | [X] Post physical inventory |
  • | -> Posts estimated accruals at Product Receipt & Packing Slip. |
  • | [X] Post financial inventory |
  • | -> Posts definitive assets, COGS, and revenue at Invoicing. |
  • | [X] Accrue liability on product receipt |
  • | -> Complies with matching principle: accrues un-invoiced PO liability. |
  • | [X] Post to deferred revenue account on sales delivery |
  • | -> Defers revenue recognition at sales packing slip stage. |
  • +---------------------------------------------------------------------------------+
  • Comprehensive Inbound Ledger Accounting Flow (Procurement)

Purchase Order Product Receipt (Physical Posting):

  • Debit : Inventory - product receipt (Materials received un-invoiced) [Asset]
  • Credit : Purchase accrual (Accrued liabilities un-invoiced) [Liability]

Requirement : Both Post physical inventory and Accrue liability on product receipt must be checked.

Purchase Order Vendor Invoice (Financial Posting):

Step A (Reverse Physical) :

  • Debit : Purchase accrual (Reversal of estimated liability)
  • Credit : Inventory - product receipt (Reversal of estimated asset)

Step B (Post Definitive Financial) :

  • Debit : Inventory - receipt (Actual inventory balance sheet asset)
  • Credit : Vendor balance (Accounts Payable liability)
  • Comprehensive Outbound Ledger Accounting Flow (Sales Fulfillment)

Sales Order Packing Slip (Physical Posting):

  • Debit : Deferred COGS (Delivered cost of goods sold) [Asset / P&L]
  • Credit : Inventory - packing slip (Materials delivered un-invoiced) [Asset]

Optional : If Post to deferred revenue account on sales delivery is enabled:

  • Debit : Customer un-invoiced (Accrued receivable)
  • Credit : Deferred revenue (Unearned revenue liability)

Sales Order Customer Invoice (Financial Posting):

Step A (Reverse Physical) :

  • Debit : Inventory - packing slip (Reversal)
  • Credit : Deferred COGS (Reversal)

Step B (Post Definitive Financial) :

  • Debit : Cost of goods sold (COGS) [P&L Expense]
  • Credit : Inventory - issue (Balance sheet asset reduction)
  • Debit : Customer balance (Accounts Receivable) [Asset]
  • Credit : Sales revenue [P&L Income]
  • Fixed Receipt Price Model

The Fixed receipt price parameter on the Item Model Group emulates standard costing behavior for receipts within a periodic inventory model (such as FIFO or Weighted Average):

All inventory receipts are posted to the balance sheet at a fixed receipt price defined on the item master.

The difference between the actual purchase order invoice price and the fixed receipt price is posted to a Fixed receipt price offset account in the General Ledger.

During Inventory Close, the system adjusts issues to the fixed receipt price rather than actual fluctuating procurement prices.

Exam Watch: Critical Traps and Configuration Tips

Warning

Trap 1 : Omitting Accrue liability on product receipt . Enabling Post physical inventory without checking Accrue liability on product receipt results in physical subledger tracking without creating General Ledger accrual vouchers for un-invoiced receipts!

Trap 2 : Expecting Inventory Close to settle Moving Average items. Moving average calculates real-time perpetual costs at invoice time; executing Inventory Close will never create settlements or cost adjustments for moving average products.

Trap 3 : Enabling physical negative inventory on Standard Cost items. The D365 SCM validation engine will block or invalidate transactions if physical negative inventory is enabled for Standard Cost or Moving Average items.

Trap 4 : Confusing Stocked Product = No with physical service items. If a service item requires a pick/pack slip or must be scheduled via WMS mobile devices, it cannot be modeled with Stocked Product = No.