web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Supply chain | Supply Chain Management, Commerce
Unanswered

How to handle FIFO/Non-FIFO physical flow with Standard Cost valuation in D365 F&O?

(1) ShareShare
ReportReport
Posted on by 2

Hi everyone,

I’m working on a requirement where the business always wants to value inventory using Standard Cost, but their physical inventory handling method (like FIFO or Non-FIFO) may change over time.

In their current ERP system, this is possible because:


  • All financial postings are always based on Standard Cost, and

  • The physical flow logic (FIFO, LIFO, etc.) can be changed anytime, without impacting valuation.

However, in Dynamics 365 Finance and Operations, I’ve noticed:


  • Once you assign an Item Model Group, it controls both financial valuation and physical flow.

  • D365 doesn’t allow changing the model group if there are existing transactions.

  • This makes it difficult to mimic the same flexibility they currently have.

Example:


  • Item: ITEM-1001

  • Current setup: Model group = Non-FIFO, valuation = Standard cost

  • After a few months, business wants to change only the physical handling to FIFO — but still keep financial valuation as Standard cost

Is there any standard way or recommended approach in D365 F&O to achieve this?

Or perhaps a setup that allows physical flow (FIFO/FEFO) to be handled through WMS or location directives, while keeping financial valuation fixed to Standard Cost?

Would appreciate any suggestions, experiences, or best practices for this kind of scenario.

Thanks in advance!

— Hitesh

I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 861

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287 Super User 2025 Season 2

#3
Sagar Suman Profile Picture

Sagar Suman 230 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans