Print
QUESTION: Can I get a sales history report of an inventory item?
ANSWER: Yes.
On the Manager Console is a Report Center button in the lower right corner.
Choosing Sales History on the left and Inventory on the right you will get a Sales Report. You can choose to report on all inventory items or select just one SKU for reporting purposes.
Inventory - Sales Report All Inventory
Using a date range, this reports sales of all inventory items and includes invoice number, date of invoice, customer name, account number and customer lookup code, quantity of items purchased, cost, selling price, average cost and average price, profit amount, and margin per line item. The report can be sorted by SKU or description. It can include detail or summary information and can include line notes added to the invoice listed below the inventory item or in place of the customer information.
Alternatively, you could run a Department Category Sales Report which allows you to focus on items belonging to a specific category.
Dept / Category - Sales Report By Department
This report includes invoice number, invoice date, customer name, SKU, description, quantity sold, cost, selling price, discount amount, net price, average cost, average price, profit and margin per item and subtotals.
Related Articles