Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

Wanted to change the costing method from Weighted Average to FIFO

Posted on by 9
Please direct me to the right forum channel if this is not correct. We are using Dynamic 365 F&O [Installed product version : 10.0.36 (10.0.1695.78)]
 
The organization would like to change the existing setting of the costing method from Weighted Average to FIFO with effective from next financial year which is Jan2024. I am seeking advice for the proper procedures to implement the change. Thanks.
  • Andrew T Profile Picture
    Andrew T 9 on at
    Wanted to change the costing method from Weighted Average to FIFO
    I done some study knowing that if we are changing from FIFO to Weighted Average, need to run the closing because system will recalculate the unit cost for each issuing transaction. We are practicing this in every month end closing for another entity which using FIFO as the current costing method.
     
    However, for this entity which using Weighted Average as the current costing method, there is no month end closing has been carried out since day 1 because D365 standard process is using the average costing method for every single issuing transaction. With this, I am wondering what is the purpose to run the month end closing and zero all the quantity, then to re-enter the quantity after changing to FIFO costing method? Can't we just switch the costing method overnight?
     
    Thanks for your review and feedback.
     
     
  • Suggested answer
    BillurSamdancioglu Profile Picture
    BillurSamdancioglu 15,784 Most Valuable Professional on at
    Wanted to change the costing method from Weighted Average to FIFO
    TO be able to change an inventory method, then the balance of that inventory needs to be zero and the need to run closing.
     
  • Suggested answer
    Kevin Xia Profile Picture
    Kevin Xia Microsoft Employee on at
    Wanted to change the costing method from Weighted Average to FIFO
    Hi,
    You can refer to this official document: FIFO with physical value and marking - Supply Chain Management | Dynamics 365 | Microsoft LearnFirst in, first out (FIFO) is an inventory management and valuation method where inventory that is produced or acquired first is sold, used, or disposed of first. During the inventory close process in Microsoft Dynamics 365 Supply Chain Management, the system will create settlements where the first receipt is matched against the first issue, and so on.
    Best regards,
    Kevin
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,151 Super User 2024 Season 2 on at
    Wanted to change the costing method from Weighted Average to FIFO
    Moved the question to the Dynamics 365 Finance forum.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,151 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,963 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans