You probably only have a Raw Cost column because you have a price list called Raw Cost. Please remember Sage 50 uses the term Price to indicate what your customers pay and Cost for what you pay. So the Price List report is customer-centric, and has nothing to do with your costs.

The Inventory Summary report shows the average costs even if you are on FIFO. You can also calculate it on each item ledger from the Quantities tab using Value/Quantity. Of course if you are using FIFO, you can find the Average Cost on the FIFO Costing report (only two decimal places).

You probably only have a Raw Cost column because you have a price list called Raw Cost. Please remember Sage 50 uses the term Price to indicate what your customers pay and Cost for what you pay. So the Price List report is customer-centric, and has nothing to do with your costs.

The Inventory Summary report shows the average costs even if you are on FIFO. You can also calculate it on each item ledger from the Quantities tab using Value/Quantity. Of course if you are using FIFO, you can find the Average Cost on the FIFO Costing report (only two decimal places).

Thanks Richard,

I'm going to have a go and start doing some fooling around and see what I can figure out. I'll come back and update when I get somewhere.

:)