Discounts can come from the product, the category, the customer and the quantity bought. Reyuko applies some of them automatically when you add a line. It has no discount field for the whole invoice.
Key takeaways
- The Discount column on a sales line is an amount per unit, not a percentage.
- Reyuko has no discount field on the whole invoice. Put the discount on the lines.
- Three automatic layers can apply: product, category and customer. They compound, not add up.
- The customer discount is Customer Classification Discount (%) on each customer. The Discount % on the Classification master is display only.
How the Discount column works
Each sales line has Qty, Price, Discount and Amount. The Discount is an amount per unit: Amount = (Price − Discount) × Qty. The Value Summary shows the sum as Total Discount.
The three automatic layers
When you choose a product, or change the customer, date or quantity, Reyuko recalculates the line from three layers:
- L1, product discount: the Discount % on the product, with optional From and To dates.
- L2, category discount: the Discount % on the product category.
- L3, customer discount: the Customer Classification Discount (%) on the customer.
The layers compound: final price = base price × (1 − L1) × (1 − L2) × (1 − L3).
Illustration: Harbor Wholesale is a fictional business; numbers are examples. A product sells at 200. L1 is 10% and the customer's L3 is 5%. Final price = 200 × 0.90 × 0.95 = 171. The discount is 29 per unit, so 116 on 4 units and an amount of 684. Added together, the percentages would give 170 per unit, which Reyuko does not charge.
The discount per unit is rounded to a whole currency unit, so a currency with decimals can differ from the exact formula. A line whose price you typed by hand is not recalculated, and neither is a Custom line. Check each Amount before you post.
Customer tier: one field per customer
Reyuko has no price list per customer class. Open Contacts > Customers, open the customer, and enter Customer Classification Discount (%) on the Contact Data tab. It applies to every sales document for that customer.
The Classification master's Discount % is only shown on the customer page in the version we checked, so enter the percentage on each customer. See Customer Classification and Automatic Discount Tiers.
A term such as "2/10 Net 30" discounts early payment. It is set on the payment term, not on the sales line. See Setting Customer Payment Terms.
Quantity pricing tiers
The Quantity Pricing card on a product sets tiers: From qty, then a Price or a Discount %. The highest tier at or below the ordered quantity wins. A price tier replaces the base price, and a Discount % tier replaces the product's L1 discount. L2 and L3 still apply on top. For example, base 500, tier from 100 at 480, L3 5%: 100 units cost 480 × 0.95 = 456 each, an amount of 45,600.
No invoice-level discount: a workaround
If an agreement says "5% off the invoice", Reyuko does not do that in one step. Spread the discount onto each line as a per-unit Discount.
Illustration: Harbor gives 5% off an invoice of three lines worth 200,000. The discount is 10,000.
| Line | Qty | Price | Gross | Discount per unit | Discount total | Amount |
|---|---|---|---|---|---|---|
| A | 100 | 500 | 50,000 | 25 | 2,500 | 47,500 |
| B | 50 | 1,000 | 50,000 | 50 | 2,500 | 47,500 |
| C | 100 | 1,000 | 100,000 | 50 | 5,000 | 95,000 |
| Total | 200,000 | 10,000 | 190,000 |
Each per-unit figure is typed by hand, so check that Total Discount equals 10,000 before you post.
- Go to Contacts > Customers, open the customer, and enter Customer Classification Discount (%) on the Contact Data tab. Save.
- Go to Sales > Invoice, click New Invoice, and choose the customer.
- Add a product. Price and Discount fill in from the layers.
- Use Columns to show or hide the Discount column.
- Check Total Discount in the Value Summary.
Check yourself: the compound price
A product has a base price of 100. L1 is 20% and the customer's L3 is 10%. What is the final price, and what is the total discount on 5 units?
Final price = 100 × 0.80 × 0.90 = 72. Discount per unit = 28. For 5 units the discount is 140 and the amount is 360.
Reyuko