The biggest control risk with consignment is simple: goods leave your warehouse and no longer sit on your Stock List. Reyuko keeps a book figure for each Delivery Order, but it does not count goods where they actually are. This lesson shows how to check the book figure against a count at the agent, and how to use statements to check the money.
Key takeaways
- Stock Opname counts a warehouse location. Goods at an agent have no location, so Reyuko cannot count them there.
- The book figure for agent stock is Remaining in Inventory > Consignment > Outbound Return.
- Count the agent's stock each month and compare it with Remaining.
- Reyuko does not currently flag a Delivery Order that is already invoiced, so invoice each sale once.
- If the agent is a customer contact, use its Statement… button to check what the agent owes.
Why Stock Opname cannot count agent stock
Stock Opname works per location. It counts the physical stock at a location and posts the differences. Consigned goods are not in a location, and Reyuko does not create a store for the agent, so there is nothing to count in that screen. Keep using Stock Opname for the goods in your own warehouses.
A monthly check
Illustration: Harbor Wholesale is a fictional business; numbers are examples.
Harbor Wholesale checks one product at one agent:
| Item | Units |
|---|---|
| Sent (Delivery Order) | 50 |
| Sold (invoiced) | 30 |
| Returned | 12 |
| Remaining (book) | 8 |
| Counted at the agent | 6 |
| Difference | -2 |
The shortfall is 2 units (6 − 8). Either the agent sold 2 units that you have not invoiced, or 2 units are lost. If the agent confirms the sale, invoice it from the Delivery Order. If units are lost, Reyuko does not currently have a loss adjustment for goods held by agents. Do not post it as a warehouse adjustment, because those goods are not in your warehouse. Decide the treatment with your accountant.
- Open Inventory > Consignment > Outbound Return (Advanced level, with the Consignment module on), select the Delivery Order, and note Remaining for each product.
- Count the agent's stock, or get the agent's stock sheet, and compare it with Remaining.
- For a sale the agent confirms, go to Sales > Invoice and click + Add from Delivery Order.
- For goods the agent returns, use Return Consignment on the same tab.
- Count your own warehouses with Inventory > Stock Opname as normal.
Agent statements
If the agent is set up as a customer contact, open the contact and click Statement…. Choose the date range, then choose Unpaid invoices or All transactions. You can also pick a tone for the letter: None, Friendly, Firm or Final notice. Check your version for how the statement is sent.
Invoicing the same Delivery Order twice books the same sales twice, and Remaining drops too far. This is a process control. Check the Sold figure for the Delivery Order before every invoice, and keep a simple log of which agent report each invoice came from.
Check yourself: a count above the book
The book Remaining is 8 and the agent counts 9. What do you check first? Answer: a return that was not recorded, or a count error. Check the agent's report and the Return History before you change anything.
Reyuko