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 :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / "Testing" In...
Finance | Project Operations, Human Resources, ...
Suggested Answer

"Testing" Inventory Valuation Method Change

(0) ShareShare
ReportReport
Posted on by john.ellis 3,518

Hi:

In a test company, we have conducted a valuation method change from FIFO Periodic to FIFO Perpetual.  

I know that the Purchase Receipts Inquiry window and its report is the best way to determine true inventory valuation layer cost.

Would the best way to determine if the "Cost" field is correct be to review this Cost for both purchase receivings and sales invoicing?

Thanks!

John

Categories:
Microsoft Dynamics GP
I have the same question (0)
  • Suggested answer
    Angela Eckman Ebensteiner Profile Picture
    Angela Eckman Ebens... 1,218 on at

    Hi John,

    So with Periodic valuation the cost that comes in is actual regardless and updates the current cost with the last actual cost that was brought in and it goes out at standard cost.   And when I look at the layers in inventory they are all at actual in the IV10200 table when my inventory item is at Standard cost (FIFO periodic).   So really the current cost should be the last actual cost that came in and you shouldn't have to adjust it.  But if you want to confirm you could look at the items incoming receipts that should give you a good idea.   That is the IV10200 table.  However, regardless, once you move to Perpetual, the system will start to automatically pull the layers Actual cost (unit cost) when those layers are sold so you shouldn't have to worry about that.  As far as the actual cost or current cost on the Item card, the system will automatically update that as well when transactions are posted.

    I just walked through setting up a periodic item, posting a whole bunch of new transactions with different dates and values to see what the tables would show and how it would update the current cost field and then did a valuation method change and I didn't have to adjust my current cost.  It was the last actual receipt cost that came in when it was periodic.  So it was actual regardless.

    Hope this helps.  

    Warmest Regards,

    Angela Ebensteiner

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 > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 689

#2
André Arnaud de Calavon Profile Picture

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

#3
Syed Haris Shah Profile Picture

Syed Haris Shah 258 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP
License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans