Functionality of Average Cost in Microsoft Great Plains Inventory

TechKnowledge Content
SUMMARY

This article describes some of the Average Cost functions in Microsoft Business Solutions - Great Plains Inventory.

MORE INFORMATION
  • The following calculation will be used to calculate the average cost of an item:
    (Average Cost x Quantity On hand) + (New Receipt x New Receipt Quantity)/(Quantity On Hand + new receipt quantity)
  • The Average Cost field will be locked in the Item Maintenance dialog box for Average Perpetual items. To open the Item Maintenance dialog box, click Cards, click Inventory, and then click Item.
  • The Change Average Cost Utility dialog box lets you enter the correct average cost for each item using the new formula listed in this section. To open the Change Average Cost Utility dialog box, click Utilities, click Inventory, and then click Change Average Cost.

    This will print a report that suggests changes that can be made to the General Ledger. This report will display an entry for each item or site, and it will display the Inventory account and the Variance account of the Inventory item. The amounts that are on the report are based on the following quantities for the item:
    • On Hand
    • Damaged
    • In Service
    • In Use
    • Returned
References
This article was TechKnowledge Document ID: 20320

The issue that is described in the Summary section does not apply to Microsoft Dynamics GP 10.0.
Properties

Article ID: 851042 - Last Review: 04/11/2016 22:27:00 - Revision: 5.0

Microsoft Dynamics GP 2010, Microsoft Dynamics GP 10.0, Inventory, Inventory Control

  • kbnosurvey kbmbsmigrate KB851042
Feedback