Functionality of Average Cost in Microsoft Great Plains Inventory

TechKnowledge Content


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

  • The following calculation will be used to calculate the average cost ofan item:
    (Average Cost x Quantity On hand) + (New Receipt x New ReceiptQuantity)/(Quantity On Hand + new receipt quantity)
  • The Average Cost field will be locked in the
    Item Maintenancedialog box for Average Perpetual items. To open the Item Maintenance dialog box, click Cards, click Inventory, and then click Item.
  • The
    Change Average Cost Utilitydialog 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 theInventory item. The amounts that are on the report are based on the following quantities for the item:
    • On Hand
    • Damaged
    • In Service
    • InUse
    • Returned


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.

ID d'article : 851042 - Dernière mise à jour : 11 avr. 2016 - Révision : 1