Retrospective stock valuation report

In the following examples, the following stock item and stock transactions are used to explain how the stock is valued retrospectively.

• You have a stock level of 10 items on 30/07.
• You run a retrospective stock valuation report for the 10/07.

• The following stock transactions are dated between the 10/07 and 30/07:

  Date	Transaction Type	Quantity	Cost price	Value
  15/07	In -POP	2	8	16
  13/07	Out - SOP	5	12	60

Quantity

This starts with the confirmed stock itemConfirmed stock items are where the cost of an item is already known and recorded. This occurs in the following circumstances: stock items have been bought and the supplier's invoice had been recorded in Sage 200; stock items have been returned to a supplier and the credit note has been processed in Sage 200; stock items have been added in Sage 200 at a specified cost; a work order has been entered (using Sage 200 Manufacturing) and the manufacturing cost is known. level. The retrospective quantity is calculated by reversing the transactions entered for the stock item from the current date back to the specified valuation date. 

Note: Unconfirmed stock itemUnconfirmed 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, or where the manufacturing process is finished (using Sage 200 Manufacturing) but not all the costs are known. levels and value (where the stock item has been recorded as received but not the purchase invoice) are not included on a retrospective stock valuation report.

Value

 This is the value of the confirmedItems from purchase orders or returns where the purchase invoice or credit note has been entered in Sage 200. Or items that have been added at a specified cost. Or items that have been manufactured (using Sage 200 Manufacturing) where the manufacturing cost is known. stock level (Quantity). The retrospective stock value is calculated differently depending on the Costing Method used for each stock item.

• Standard costing method.

  (Quantity) x (Standard cost price of the item on the Valuation date specified for the report)

  The standard cost price is displayed on the report as the Valuation price.

  Each time the standard cost price of the item is changed on the stock record, the new price and the date of the change are recorded by Sage 200 using the current date on your PC.

  Example

  For this example, the standard cost of the item on 10/07 was £8. This was changed on 15/07 to £10. When running the report with a valuation date of 10/07, the retrospective value is the retrospective quantity x the standard cost on the 10/07.

  Date	Transaction Type	Stock Movement	Retrospective calculation	Stock Level	Stock value
  30/07				10
  15/07	In -POP	2	-2	8
  13/07	Out - SOP	5	+5	13	13 x 8

• Average costing method.

  (Retrospective Quantity) x (Average buying price of the item on the Valuation date specified for the report).

  Each time a purchase invoice or an addition of stock is recorded for an item, the average buying price is updated and recorded by Sage 200 using the current system date on your PC.

  The Average buying price is displayed on the report as the Valuation price.

  Example

  For the example item above, the average buying price on 10/07 was £10. On 15/07 this was changed when 2 new items were received for £11.

  When running the report with a valuation date of 10/07, the retrospective value is the retrospective quantity (13) x the average buying price on the 10/07 (£10). The stock valuation is £130.

  Date	Transaction Type	Stock Movement	Retrospective calculation	Stock Level	Stock value
  30/07				10
  15/07	In -POP	2	-2	8
  13/07	Out - SOP	5	+5	13	13 x 10

• FIFO costing method.

  The retrospective value by taking the starting value of the stock and reversing the transactions entered for the stock item since the specified Valuation dateup to the current date.

  Example

  In this example, the following transactions are used to explain how the stock value is calculated retrospectively:

  • You have a stock level of 10 items on 30/07, the stock value is £100.

  • The following stock transactions are dated between the 10/07 and 30/07:

    Date	Transaction Type	Quantity	Cost price	Value
    15/07	In -POP	2	8	16
    13/07	Out - SOP	5	12	60

  • You run a retrospective stock valuation report for the 10/07.

  • The retrospective value is calculated in the following way:

    Date	Transaction Type	Stock Movement	Cost price	Retrospective calculation quantity	Retrospective calculation value	Stock Level	Stock value
    30/07						10	100
    15/07	In -POP	2	8	-2	-16	8	84 (100 - 16)
    13/07	Out - SOP	5	12	+5	+ 60	13	144 (84 + 60)

• Actual costing method.

  The retrospective value by taking the starting value of the stock and reversing the transactions entered for the stock item since the specified Valuation date up to the current date.

  Example

  In this example, the following transactions are used to explain how the stock value is calculated retrospectively:

  • On 30/07, you have stock level of 10 items, the stock value is £100.

  • The fallowing stock transactions are dated between 10/07 and 30/07.

    Date	Transaction Type	Quantity	Cost price	Value
    15/07	In -POP	2	8	16
    13/07	Out - SOP	5	12	60

  • You run a retrospective stock valuation report for the 10/07.

  • The retrospective value is calculated in the following way:

    Date	Transaction Type	Stock Movement	Cost price	Retrospective calculation quantity	Retrospective calculation value	Stock Level	Stock value
    30/07						10	100
    15/07	In -POP	2	8	-2	-16	8	84 (100 - 16)
    13/07	Out - SOP	5	12	+5	+ 60	13	144 (84 +60)

• You must have selected Keep movement history on the Product Group Details tab for all the stock items you want to include on the report.
• You must make sure your have not deleted your stock transaction history for the date you want to run the report.