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

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:

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:

1. Evaluates all closed receipts and issues during the period.
2. 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).
3. 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:

$\text{New Moving Average Cost} = \frac{(\text{Current On-Hand Value} + \text{Invoiced Purchase Value})}{(\text{Current On-Hand Quantity} + \text{Invoiced Purchase Quantity})}$

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)

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

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

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

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