I need a total cost when running an inventory report

AlieskeMcLellan

I am running a report called Purchases by Item Detail, has been filtered to Inventory type and supplier. I can get a column for Qty, Cost Price, Amount and Tax Amount, but not a total column which shows the amount and tax amount added. Any ideas?

Datarec

Hi @AlieskeMcLellan

The Reckon Accounts reports do not have a function to create user-defined calculations.

We'd recommend exporting the report to Excel and there adding the new column.

Use a formula to add the values from the other columns to be the contents of the new column.

AlieskeMcLellan

No problems, thanks.