What you'll do: follow items from the purchase they came in on to the sale they went out on, with the cost and the price on each side.
Before you start:
- Your role needs View purchase & sell report.
- Filters, print and export work as in How reports work.
Open Reports & Analytics → Reports → Items Report.
Press Filter (Filter Items): All Suppliers, All Customers, All Locations, the Purchase date range and the Sale date range.
1 Filter · 2 Purchase Price · 3 Selling Price Read the report:
- purchase side: Purchase Date, Purchase (reference), Lot No., Supplier and Purchase Price;
- sale side: Sell Date, Sale, Customer, Location, Sell Qty, Selling Price and Subtotal;
- the gap between Purchase Price and Selling Price is your margin on that item.
Use Export CSV, Export Excel (XLSX) or Print above the table (Current Page Only or All Records). See How reports work.