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

Applies to: Dynamics GP 2010

INTRODUCTION


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.

More Information


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.