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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Supply chain | Supply Chain Management, Commerce
Suggested Answer

Inventory Costing issues - Fifo

(0) ShareShare
ReportReport
Posted on by 10

hi Team 

We have a situation where PO was created in lower price and of which half of the products are sold off. later Vendor billed us at correct price. We are in FIFO model. 

we need input on how to handle this scenario and cost change, adjust the cost of remaining products on hand the process the invoice for the price change for the vendor

regards,  

I have the same question (0)
  • MATTGUO Profile Picture
    22,351 Moderator on at

    Hi,

    You do not need to manually process this scenario. After invoicing the PO, go to Inventory management > Periodic tasks > Closing and adjustment > Recalculation, select the item number and date, click ok, it will recalculate the item cost of on-hand and sold.

    This Doc is about the cost adjustment of on-hand item: docs.microsoft.com/.../adjust-hand-inventory-cost-values

  • LalitSharma Profile Picture
    10 on at

    Thank you So much,

    I will review the steps advised by you and will update.

    regards,

  • Suggested answer
    Anders Even Girke Profile Picture
    Microsoft Employee on at

    FIFO is a settlement based costing method in D365 SCM and it requires an Inventory close in order to settle the cost according to the FIFO principle. Untill the Inventory close job is run the COGS is estimated at a running average. It is therefore a requirement that Inventory close is executed end of month before you create the Financial reports so the Inventory Asset and COGS is represented correctly in GL. 

    Executing inventory close also blocks the period for additional transactions and should therefore always be executed as part of the Fiscal period end process at all customers

    As mention in above comment during a fiscal month the Recalculation job can be executed as an "As of now Calculation" is will settle transactions according to FIFO principle BUT NOT close the period meaning that you can still post in the period also backdated transactions. A Recalculation also post to Inventory Asset and COGS so GL is updated. When Inventory close job is executed the entire period will be reassessed according to FIFO principle.

    Microsoft highly encourage all customers to run Inventory close by end of each period. We have introduced newly warnings about this in the application as many customers forget

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
Laurens vd Tang Profile Picture

Laurens vd Tang 140 Super User 2026 Season 1

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 123 Super User 2026 Season 1

#3
Mallesh Deshapaga Profile Picture

Mallesh Deshapaga 108

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans