Field help (CSTCOD1) 

Leave as Primary issue method, the default valuation method, to run this report based on the valuation method defined on each product-site record selected for this report.

Alternatively, select from the following:

You must leave the accounting reference dates as today's date, the default date, to apply the following valuation methods: Last cost, LIFO cost, Budget cost, Simulated cost.

Sage advises that the valuation method defined on each product-site record must match the Costing mode you set for this report, if this report is based on an average costing method such as Moving average cost, Average lot cost, FIFO cost or LIFO cost.

Limitations: FIFO cost

The FIFO value of stock calculated for this report might be slightly different from the actual FIFO value of the stock for the selected reference dates. The results can differ when transactions such as customer returns are entered in date order which changes their position in the FIFO queue.

Example

Transactions are entered in the following order:

On 01/10 the FIFO basis comprised Receipt 2, however the valuation report only considered 1 returns unit and 9 units from Receipt 1.

All receipt transactions are taken into account for the valuation, whether they are receipts, change receipts, or deleted receipts.

Receipt adjustments are linked to the valuation method defined for the product-site record. The valuation method defined on each product-site record must therefore have a FIFO valuation method otherwise receipt adjustments are omitted from the report.