Suppliers change their prices. When they do, your cost changes, and your margin changes with it unless you adjust your selling price. Reyuko does not update your product master from purchases, so you need to understand how each new price moves through the system. This lesson explains how the purchase price, stock cost, and margin reports work together. If goods from the old price must go back, see Purchase Returns.
Key takeaways
- The default price on a purchase line is the product's Purchase Price in the master. It is not the last price paid.
- Purchases do not update the product master. You update it yourself.
- Each Purchase Delivery creates a new stock batch at its own net cost. Old batches keep their old cost.
- Average and FIFO costing handle the change differently. Neither changes past sales.
- Check margin in the sales reports, because Reyuko has no margin column on each invoice.
Where the price comes from
When you add a product to a purchase document, the price on the line is the Purchase Price on the product. You can edit the price on any line. Reyuko does not save that edited price back to the product. If the supplier raised the price, change the Purchase Price on the product, or the next purchase will still use the old price.
If you duplicate a document after the master price changed, Reyuko shows a notice. It does not change the price.
How the new cost reaches stock
Each Purchase Delivery creates a new batch of stock at its own net price. Stock that came in earlier keeps its old cost. What happens next depends on your costing method:
- Average: the average cost moves when new stock arrives, and the next sale uses the new average.
- FIFO: the oldest batch is used first. The higher-cost batch is used only after the older one is gone.
Reyuko does not restate past sales or stock values. The methods are compared in Costing: Average vs FIFO for Distributors.
Illustration: Harbor Wholesale is a fictional business; numbers are examples.
Harbor has 100 units of Item A at $10 each. It receives 100 more at $12. Harbor then sells 50 units at $15.
| Method | Cost per unit used | Cost of 50 units sold | Margin on the sale |
|---|---|---|---|
| FIFO | 10 | 500 | 33.3% |
| Average | 11 | 550 | 26.7% |
The average is (100 x 10 + 100 x 12) / 200 = 11. Margin is (15 - cost) / 15.
Bill and delivery prices
A Purchase Delivery posts the goods at the delivery price, against the goods-received-not-invoiced account. The Purchase Bill then moves the amount to Accounts Payable, using the Bill's goods value. If the Bill price differs from the delivery price, a balance can remain in the goods-received-not-invoiced account. Reyuko does not show a separate purchase price variance account. Check your version and reconcile the difference before you close the month.
Margin
Reyuko does not show margin for each invoice. Use these reports instead:
- Sales > Reports > Sales by product: quantity, amount, gross profit, and margin for each product.
- Contacts > Reports > Gross profit by customer: revenue, cost of goods, gross profit, and margin for each customer. See Gross Margin and Customer Profitability for how to read it.
- Go to Products > Products, open the product, and change Purchase Price to the new supplier price.
- Create the next Purchase Delivery and check that the line price is the new price.
- After you post the delivery, check the Unit Cost on Inventory > Stock List in the detail panel.
- Go to Sales > Reports, open Sales by product, and check the Margin for the product.
Updating the Purchase Price does not change stock already on hand. It only affects the lines you create after the change. Stock cost changes when new deliveries are posted.
Check yourself: which cost is used?
You use FIFO. The first batch cost $10 and the second cost $12. You sell 50 units. Which cost is used?
The $10 cost. FIFO uses the oldest batch first.
Reyuko