In GP8 and GP9, there was a Change Average Cost Utility and to open the Change Average Cost Utility dialog box, click Utilities, click Inventory, and then click Change Average Cost - in GP`10 and GP2010 this is no longer an option - why? How can customers change the average cost? Our customer used this option all the time.
*This post is locked for comments
Andrea,
There are a couple of great white papers available that explain the costing changes in a great bit of detail. You might find them interesting to gain a more in-depth understanding of what's going on under the covers.
The change in costing was really quite remarkable.
Kind regards
Leslie
Yes it is...but it isn't functional. We missed the removal of the form on the v9 RTM release and it took a bit just to hide it. We did finally get around to removing the form however.
Aaron
Thanks, the window is still there in GP9 though.
Andrea,
this tool was removed from the application becuase of the changes that were introduced in v9 regarding Average Costing. In previous versions, that tool simlpy went to the Item Card and updated the Current Cost field. We no longer use that field to determine the cost for an Average Perpetual Item. The cost is now pulled from the Inventory Purchase receipts table (IV10200) based on several factors.
Because of this change in functionality, this window was no longer functional. Chaning the Average Cost for an item is no longer a simple process and there are many factors that come into play here. The best and most accurate method of wanting to change an items Average Cost is to perform an IV Decrease adjustment to take out all of the quantity and then do an increase adjustment bring those items back into on hand. This may or may not be simple as it depending on the number of locations and quantity available at each location.
In addition, the biggest change with Average Cost is now it is date sensitive. So even if you performed the action above by decreasing and increase the item quantity, if an IV or SOP transaction is posted using a date prior to the decrease/increase, the average cost will more than likely be updated as a "costing ripple" will occur.
If you need more assistance on this topic, please open a support case. Here is also a KB that discusses those changes more in detail: mbs2.microsoft.com/.../kbdisplay.aspx
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,321
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
