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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)
Unanswered

Dynamics GP 2010 Change Valuation Method

(0) ShareShare
ReportReport
Posted on by 75,850 Moderator

We have a client who has been using GP since 2007. They want to change the valuation method from FIFO Perpetual to Average Perpetual. How will GP treat all the existing inventory after this change is made? Let's say I have 100 widget's in stock that came is as FIFO at $1.00 and I cut a PO for another 100 after making the change  but these now come in at $0.50 and I sell 50 of them. Will the cost on the sale per $1.00 per widget or $0.75. What if I were to tell 150 of them. Will 100 go out at $100 and then the other 50 at $0.75. I need to explain the ramifications of this change to existing inventory before they push the button to change.

*This post is locked for comments

I have the same question (0)
  • Dan Liebl Profile Picture
    7,320 on at

    Richard, I would suggest doing it in a test company first, although I am sure you already have that planned.  I shy away from average as it creates many trx/recalculations which have been confusing (my experience is from users from 10 yrs ago that were using when GP 9 came out with the enhancements).   I have found this article handy when dealing with it.   I did a Google to find it, as I was not sure an attachment would work on community.  Anyway, my guess to the question is I would bet it will recalculate the average based on all those layers.  Good luck!

    www.pinncorp.com/LinkClick.aspx

    Dan Liebl, CMA CPIM | Senior Consultant | OTT,Inc | DLiebl@OTT-inc.com

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans