Product Monthly Transaction Ranking
The same as the Product Transaction Ranking, for a chosen month range instead of a date range.
Menu: Reports › Ranking Reports › Product Monthly Transaction Ranking
What it's for
Use it for monthly reviews of one transaction type, for example the products most received or most returned each month.
For the monthly supplier meeting, the buyer ranks Purchase Inbound for the last month to show which products were bought the most.
Options on the screen
- In the filters: Branch, Transaction (the transaction type to rank by) and the dates.
- At the bottom, Click to Show Summary: Total Qty, Overall Avg Price, Total Amount, Total Profit and Total Inventory.
Filters
Click Filters to narrow the report. You can filter by:
Branch, Transaction, Date, Barcode, Stock No., Product Name, Chinese Name, Brand, Parent Category, Category, Supplier, Inventory Status.
Columns
| Column | What it shows |
|---|---|
| Product Name | The product name. |
| Parent Category | The category one level above the product's category. |
| Supplier | The product's default supplier. |
| Qty | Quantity on transactions of the chosen type. |
| Average Price | Average price on those transactions. |
| Amount | Amount on those transactions. |
| Profit | Profit on those transactions (for sales). |
| Inventory | Current stock, in the product's default unit. |
Also shows: Barcode, Stock No., Chinese Name, Brand, Category.
For searching, express filters, sorting, column settings, exporting and printing, see About reports.