2. Item Model Group Setup

Item model groups are a core configuration in Microsoft Dynamics 365 Finance that directly impact how your organization manages inventory, controls stock movements, and posts financial transactions. Understanding how item model groups work in D365 Finance is essential for a successful implementation.


What Are Item Model Groups in D365 Finance?

Item model groups define how products behave across inventory, warehouse operations, and accounting. They control how items are received, issued, valued, and posted to the general ledger.

In simple terms, they answer critical business questions like:

  • Should this product be stocked or Non Stocked (Service)?
  • How should inventory be valued (FIFO, LIFO, etc.)?
  • Can negative inventory be allowed?
  • When should transactions hit the ledger?

Where to Find Item Model Groups in D365 Finance

You can configure item model groups by navigating to:

Inventory management → Setup → Inventory → Item model groups

at least one item model group is mandatory per legal entity.


Item Model Groups Fields Details

  • Stocked Product: Yes / No means Product is stocked System tracks on-hand inventory Product.
  • Inventory Model: (FIFO, LIFO, Standard) etc means Costing model for Prodocts

Key Features of Item Model Groups

1. Stocked vs. Non-Stocked Products

One of the most important settings is the Stocked product checkbox:

  • ✅ Enabled → Inventory is tracked (on-hand quantities maintained)
  • ❌ Disabled → Treated as an expense (no inventory tracking)

For example:

  • Office supplies → Non-stocked
  • Finished goods → Stocked

When disabled, many advanced configurations (reservation, warehouse, ledger integration) become unavailable.


2. Inventory Valuation Methods (Cost Models)

Costing is controlled in the Inventory model section. Common methods include:

  • FIFO (First In, First Out)
  • LIFO (Last In, First Out)
  • Weighted Average
  • Moving Average
  • Standard Cost

For example, if you select FIFO:

  • Inventory is valued based on the oldest available stock
  • Final cost is calculated during inventory close

This is critical for financial accuracy and compliance.


3. Negative Inventory Control

Two important settings control negative inventory:

Physical Negative Inventory

  • Allows stock levels to go below zero
  • ⚠️ Not recommended in most industries
  • Useful in retail scenarios where sales must continue even if stock isn’t updated

Financial Negative Inventory

  • Allows invoicing before financial updates (e.g., before vendor invoice is posted)
  • Commonly used depending on business needs

Example scenario:

  • You receive goods but haven’t invoiced them yet
  • You try to sell them → system may block depending on this setting

4. Ledger Integration & Posting

Item model groups determine how transactions integrate with finance:

  • Post Physical Inventory
    • Enables accrual postings during product receipt/shipment
  • Post Financial Inventory
    • Posts finalized financial transactions

If disabled:

  • No accruals for purchase or sales orders
  • Reduced financial visibility

Additional options include:

  • Deferred revenue on sales
  • Accrued liability on product receipt

5. Warehouse & Operational Controls

Item model groups also influence warehouse processes:

  • Quarantine management
  • Consolidated picking
  • Reservation rules

These settings help optimize:

  • Picking efficiency
  • Stock allocation
  • Order fulfillment

6. Process Flow Controls

Some settings enforce business process discipline:

  • Receiving requirements
    • Product receipt must be posted before invoice

This ensures:

  • Better audit control
  • Accurate inventory tracking

Real-Life Example: FIFO Item Model Group

A typical FIFO item model group setup includes:

  • Stocked product = Enabled
  • Cost model = FIFO
  • Physical negative inventory = Disabled
  • Financial negative inventory = Enabled
  • Post physical & financial = Enabled

This setup is widely used in:

  • Retail
  • Manufacturing
  • Distribution businesses

Best Practices for D365 Finance

  • Avoid physical negative inventory unless absolutely required
  • Choose costing method based on compliance (e.g., FIFO for IFRS)
  • Always enable ledger posting for financial transparency
  • Use non-stocked items for services and consumables
  • Test configurations in a sandbox before production

Final Thoughts

Item model groups in Microsoft Dynamics 365 Finance are not just a setup step—they are a foundation for inventory accuracy, financial integrity, and operational efficiency.

If configured correctly, they:

  • Improve stock visibility
  • Ensure accurate costing
  • Streamline financial postings
  • Support business compliance

If configured poorly, they can lead to:

  • Inventory mismatches
  • Financial discrepancies
  • Operational delays

Leave a Reply

Your email address will not be published. Required fields are marked *