Most wholesale questions start with sales: who bought the most, and which products move. Reyuko answers those with its operational reports, but has no report for sales by agent. This lesson shows what each report counts, its limits, and how to read agent sales.
Key takeaways
- Sales reports count only finalized invoices (status Posted) dated in the range you pick.
- Reyuko does not currently have a sales report by consignment agent.
- Agent sales are read from the consignment Delivery Order and the invoices linked to it.
- Reports have no customer, sales rep or category filter inside the report itself.
- Sales returns are not subtracted in these reports.
The reports that exist
Reyuko keeps its sales reports in two menus, with the same controls: a Report choice, From and To dates, and Compare previous period.
| Menu | Report | Columns |
|---|---|---|
| Contacts > Reports (Basic) | Sales by customer | Amount, Transactions, Average, Share |
| Contacts > Reports (Basic) | Gross profit by customer | Revenue, COGS, Gross profit, Margin |
| Sales > Reports (Intermediate) | Sales by product | Qty, Amount, Gross profit, Margin |
| Sales > Reports (Intermediate) | Sales by category | Qty, Amount, Gross profit, Share |
| Sales > Reports (Intermediate) | Sales by sales rep | Amount, Transactions, Average, Share |
Sales by sales rep groups by the Staff field on the invoice. It is for your own salespeople, not for consignment agents.
Four reading rules apply to every report:
- Only finalized invoices count. An invoice at Posted (reversible) does not appear.
- Delivery Orders are not counted. Goods that left on a DO but were never invoiced are missing from the totals.
- Rows are capped at 500. Extra rows are grouped into a line called Others.
- Sales returns are not subtracted. Check Sales > Sales Return separately. See Sales Returns and Credit Notes.
Agent sales: what Reyuko does not do
Reyuko does not currently have a sales report by agent. The sales rep report reads the Staff field, not the agent.
You can still track agent sales. Reyuko shows the quantity an agent sold on each consignment DO, because each invoice created from that DO is linked to it. You read that figure per DO and add up the agents yourself. For the monthly routine, see Tracking Consignment Stock per Agent. For the commission side, see Agent Sales Reports and Commission Calculation.
- Go to Inventory > Consignment (Advanced) and open the Outbound Return tab.
- On the Consignment DOs sub-tab, select the consignment Delivery Order. The list shows DO No., Agent and Date.
- Read Sent, Sold, Returned and Remaining for each product. Remaining equals Sent minus Sold minus Returned.
- Go to Sales > Reports, choose Sales by product, set the month, and click Export to keep a copy.
Sold counts only the invoices you created from that DO. If an agent sells goods and you do not invoice them, Sold stays low and Remaining stays high. If one invoice combines several DOs, Reyuko links it to the first DO only, so Sold for the others stays low. A DO is not marked as invoiced, so you cannot filter the list by invoice status. Compare Sold with the agent's own report before you pay the agent.
Reading the month correctly
The report uses the invoice date and the invoice status. The Delivery Order date does not matter.
Illustration: Harbor Wholesale is a fictional business; numbers are examples.
Harbor ships 50 units to an agent on 28 March. The agent sells 30 units by 31 March. Harbor creates the invoice for those 30 units on 2 April, at 250,000 each. The March report shows nothing for that DO. The April report shows 30 × 250,000 = 7,500,000.
Status matters as much as the date:
| Invoice dated 15 March, status | In the March report? |
|---|---|
| Draft | No |
| Posted (reversible) | No |
| Posted (finalized) | Yes |
To use Compare previous period, pick ranges of the same length. The report then adds Previous and Change % columns.
Check yourself: which invoice counts
An invoice dated 20 March is still Posted (reversible). Another invoice dated 22 March is finalized. Which one appears in the March Sales by product report? Answer: Only the 22 March invoice. Both dates are in the range, but only the finalized invoice counts.
Reyuko