Product Monthly Sales Order Ranking
Ranks products by how much customers ordered on sales orders (the Sales module) in each month of a chosen range, in quantity, amount and profit.
Menu: Reports › Ranking Reports › Product Monthly Sales Order Ranking
What it's for
Use it to see demand from orders, including orders not delivered yet, for example to plan purchasing for wholesale customers. Compare it with the Product Monthly Sales Ranking, which counts what was actually sold.
In June, Rice 25 kg is first with 1,800 sacks ordered, but only 1,500 were delivered according to the sales ranking: 300 sacks are still owed to customers, so the buyer orders more.
Filters
Click Filters to narrow the report. You can filter by:
Branch, Date.
Columns
| Column | What it shows |
|---|---|
| Product Name | The product name. |
| Supplier | The product's default supplier. |
| POS Qty | Quantity sold at the POS. |
| POS Amount | Amount sold at the POS. |
| POS Profit | Profit on POS sales (amount − cost). |
| Backend Qty | Quantity sold through back-office sales outbounds. |
| Backend Amount | Amount of back-office sales outbounds. |
| Backend Profit | Profit on back-office sales outbounds. |
| Total Qty | POS Qty + Backend Qty. |
| Total Amount | POS Amount + Backend Amount. |
| Total Profit | POS Profit + Backend Profit. |
| Total Profit Percentage | Total Profit as a percentage of Total Amount. |
Also shows: Stock No., Chinese Name, Description, Brand, Category.
For searching, express filters, sorting, column settings, exporting and printing, see About reports.