Reyuko does not show a single stock balance for each agent. It shows the consignment stock per Delivery Order. For each order you can see how many units were sent, sold, returned, and remain with the agent. To know what one agent holds, you add up the remaining quantity across that agent's orders. This lesson shows how to read the figures and where the gaps are.
Key takeaways
- Reyuko tracks outbound consignment per Delivery Order. The Stock List does not show goods held by agents.
- Remaining = Sent minus Sold minus Returned, for each product on each order.
- The Sold quantity only updates when you create an Invoice from the consignment Delivery Order.
- To get one agent's total, add the remaining quantities of that agent's orders.
- If you do not invoice the agent's sales, Remaining will be too high. Keep invoices current.
Where the numbers are
Illustration: Harbor Wholesale is a fictional business; numbers are examples.
Harbor Wholesale has three agents. Each has one or more consignment Delivery Orders. The Outbound Return tab lists these orders with the columns DO No., Agent and Date. Select an order, and the panel on the right shows each product with four figures: Sent, Sold, Returned and Remaining.
Take one order for Nusantara Agent, Item A:
| Sent | Sold | Returned | Remaining |
|---|---|---|---|
| 50 | 30 | 5 | 15 |
Remaining is 50 minus 30 minus 5, which is 15 units still with the agent.
How Sold gets updated
The Sold figure is not typed in. It comes from invoices. When you create an Invoice and choose Add from Delivery Order, you select the consignment order. The invoice lines then count toward Sold for that order.
Harbor's agent reports 30 units sold in the month. Harbor creates one invoice to the agent for those 30 units, from the consignment Delivery Order. The Sold column changes from 0 to 30, and Remaining drops by 30.
The invoice records revenue, receivable and tax as for any invoice. It also moves the cost of the 30 units from the consignment account to cost of goods sold. No stock moves, because the goods left the warehouse at shipment.
Total one agent's stock
Reyuko does not add up the agent for you. Do it this way:
- Open Inventory > Consignment, tab Outbound Return.
- Look at the Agent column and find all of that agent's Delivery Orders.
- For each order, read Remaining for each product.
- Add the figures for each product across the orders.
For Harbor's Nusantara Agent, the list might show two orders. Order one has 15 units of Item A remaining, and order two has 20. The agent holds 35 units of Item A. Compare that total with a count at the agent's location, as the controls lesson shows.
- Inventory > Consignment > Outbound Return > Consignment DOs.
- Select an order to see Sent, Sold, Returned and Remaining per product.
- Sales > Invoice > Add from Delivery Order, and choose the consignment order to record the agent's sales.
- Check Remaining again after the invoice is posted.
If the agent reports sales and you do not invoice them, Sold stays low and Remaining stays high. Your books will show more stock with the agent than there really is. Invoice the agent's reported sales on the same schedule as the reports.
The Wholesale sample records agent sales with a manual journal, so Sold shows 0 there. Use the invoice flow with your own data.
What Reyuko does not track
There is no agent stock screen and no report of agent sales. Reyuko does not give a per-agent total. The consignment order is the record you have. Add up each agent's orders in the same routine each month, and compare the totals with a count at the agent.
Check yourself: what is the Remaining quantity?
An order shows Sent 40, Sold 25 and Returned 0 for Item B. What is Remaining, and what must happen before it is correct?
Remaining is 15. Before it is correct, the agent's 25 sold units must be invoiced from that Delivery Order.
Reyuko