Change Average Cost

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

Aaron Donat Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Thanks, the window is still there in GP9 though.

Was this reply helpful? Yes No
Aaron Donat Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No