How the inventory value on the Stock Status report is calculated in Microsoft Dynamics GP

This article discusses how the Stock Status report calculates the inventory value for each item in Microsoft Dynamics GP or in Microsoft Business Solutions - Great Plains.

Applies to:   Microsoft Dynamics GP
Original KB number:   850168

The inventory value on the Stock Status report is calculated based on the following item valuation methods.

• FIFO or LIFO Perpetual valuation methods

  The on-hand quantity is multiplied by the cost at which the item was received.

• Average Perpetual valuation methods

  The on-hand quantity is multiplied by the current cost of the item.

• FIFO or LIFO Periodic valuation methods

  The on-hand quantity is multiplied by the standard cost of the item.