Cost vs Sales

Report item sales, price, average cost, purchases, cost by month.

Columns:

Month

Report month in format YYYY-MM

SKU

Article SKU / Search Code

Category

Article Category

Item

Article Name

Sales

The number of the item sold in the month for the host company, an accumulation of the quantity from debtor invoice lines.

AvgPrice

The total amount from debtor invoice lines for this item/month/host company divided by Sales.

AvgCost

The average cost from the last stock audit log entry for this item/month/host company (Article form, Movements/Audit tab, Log tab).

Purchases

The number of the item purchased in the month for the host company, an accumulation of the quantity from creditor invoice lines.

Cost

the total amount from creditor invoice lines for this item/month/host company divided by Purchases.