Hi,

In Sage 50 Canadian, the Inventory List and Summary reports will tell you the average cost of inventory as of the latest transaction or 'as of' a particular date (Summary) and / or in particular 'Location' (Warehouse), which will include all purchases, adjustments, cost of sales, assembly, and bill-of-materials transaction.

To get the average cost that you paid over a period of time, you need the Vendor Purchases report or use the Inventory Transaction report, and uncheck everything except 'Expenses'. (Quantum has a vendor comparison report, but it's not an average, just the last transaction)

I haven't seen the term 'Raw Cost' in the Canadian Sage 50 software. It's as different from Sage 50 US as Lotus 1-2-3 is from MultiPlan, but most of the general concepts are the same even if the terminology and features are different.

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).

Hi Randy - I'm using Sage 50 Canadian version. This is what I mean:

The Raw cost is the bottom one in blue on the select price lists.

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.

:)

And the Vendor Purchases report ended up being the one that we wanted to use as we were able to click the box to show foreign amounts as some of our vendors are from the States, so being able to see the cost in the currency that we bought the items in was what we needed.

Thanks for your help!

Yes, that report works as well if you are looking for average cost per vendor.