Stock valuation

Use the Valuation report to see your stock item levels and their value. You can produce the report in two ways:

• Current stock valuation report.

  This displays your stock item levels and their value at the time the report is generated.

• Retrospective stock valuation report.

  This displays your stock item levels and their value at the end of a specified date in the past.

Note: Stock items with a zero stock level are excluded from both reports.

How the stock levels are calculated

The stock levels are calculated for both confirmed and unconfirmed stock items.

Confirmed stock items are where the cost of an item is already known and recorded. This occurs when:

• Stock items have been bought and the supplier's invoice recorded in Sage 200.
• Stock items have been returned to a supplier and the credit note processed in Sage 200.
• Stock items have been added in Sage 200 at a specified cost.
• Bill of Materials items have been built and added to stock.
• A works order has been entered (using Sage 200 Manufacturing) and the manufacturing cost is known as all the stock issued to the works order was confirmed.

Unconfirmed stock items are where goods have been received, but the actual cost is not known. This occurs when:

• Stock items from purchase orders have been entered as received, but the supplier's invoice has not been processed in Sage 200.
• Stock items from purchase returns have been entered as despatched, but the credit note has not been processed in Sage 200.
• Where the manufacturing process is finished (using Sage 200 Manufacturing) but not all the costs are known, as some unconfirmed stock has been issued to the works order.