Order entry: a check of MOQ, multiples, the delivery window and payment
Checks an order to a supplier before entry: the minimum lots by SKU, the multiple of the size run or box, the minimum order amount, whether the delivery falls into the window before the sales start and the payment schedule (prepayment and the balance). Suggests corrected quantities.
At a glance
- What question does it answer?
- Is the supplier order right before entry: lots, multiples, the minimum amount, timing and payment.
- What data is needed?
- Supplier terms: the minimum order amount, prepayment, credit, the delivery window, the sales start, your buffer in days.
- How to read the result?
- On the example of 4 lines worth 3.33m two have breaches (150 against a minimum lot of 200 and 250, not a multiple of 12). After correction the amount is 3,476,400 (+143,400). The buffer between the latest delivery (day 90) and the sales start (day 100) is 10 days against the 10 needed. The 30% prepayment is 999,900 paid 100 days before the sales start, the balance 2.33m on day 105–135. Example on the default values: Order lines: 4; Lines with a breach: 2; Below the minimum lot: 1; Not a multiple of the pack: 1. The figures are illustrative: enter your own to see your result.
Why and how to reason
A mistake in a supplier order is expensive to fix after production: you cannot pay extra for missing pairs and cannot return the surplus. So the order is checked before entry against four rules. Minimum batch per item: the supplier does not sew less. Size-run or carton multiple: the quantity must divide by the pack. Minimum order value overall. And the delivery window: the batch must arrive before sales start with a reserve. Corrected quantity = max (order, minimum batch), rounded up to the multiple. In the example “Midi dress”: ordered 150, minimum 200, pack 6, so 204. “Jacket”: 250 with a pack of 12 gives 252. Order value rises from 3,333,000 to 3,476,400. Delivery no later than day 90, sales from day 100: a 10-day reserve. Payment: prepayment 30% = 999,900 at order, the remaining 2,333,100 after delivery with a 45-day term.
When to use it
Reach for it before every order to a factory or supplier, especially with a new factory. It suits a brand and a retailer. It does not replace the contract: fix minimum batches, penalties and deadlines in writing. Assumptions: minimum batch and multiple are known per item; production times are confirmed by the supplier; for money, prepayment and credit are entered as a share and days, excluding VAT.
How to read the result
First “lines with a violation”: each must be fixed or agreed with the supplier. The value after correction shows how much money is really needed: it is higher than the original and must be built into the budget. Assess the reserve between delivery and sales start for the worst case: ten days is little if transport can slip. Prepayment and balance give a cash schedule: compare it with the cash plan. If the corrected quantity exceeds your demand, consider whether it is better to drop the item or merge it with another color than to take surplus. Agree the corrected order with the factory in writing before entry: a verbal agreement on multiples is worth nothing.
Common mistakes
Entering the minimum batch per color when the supplier counts it per model, and the other way round. Not noticing that the corrected quantity changes the amount and payment terms. Forgetting days for customs, marking and receiving: delivery “on time” does not yet mean “on sale”. Entering the order in the system without written confirmation of the changes.
What data is needed?
- Supplier terms: the minimum order amount, prepayment, credit, the delivery window, the sales start, your buffer in days.
- Lines: quantity, minimum lot, multiple, price excl. VAT.
Inputs
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Minimum order amount | ₽ | 1,000,000 | Per the supplier’s contract or price list. Amount excl. VAT: the general rate is 22% from 01.01.2026. The rate follows the shipment date; confirm your regime and rate with an accountant. |
| Prepayment | % | 30 | The share of the order amount that you pay at the order. |
| Credit on the balance | days | 45 | The payment credit for the remainder in days after delivery: from the order terms; the cash gap is checked against it. |
| Delivery: not before, days from the order | days | 60 | The earliest date per the supplier’s confirmation. |
| Delivery: not later than, days from the order | days | 90 | The latest date. Not earlier than the earliest. |
| Sales start, days from the order | days | 100 | The date from which the goods must be on the shelf. |
| Buffer between delivery and the sales start | days | 10 | Days for receiving, labeling and display. You set it; there is no single standard. |
How it is calculated
| Step | Formula |
|---|---|
| Corrected quantity | the larger of (order, minimum lot), rounded up to the multiple |
| Buffer to the sales start | sales start − the latest delivery |
| Payment | prepayment = amount × share; the balance is paid after the credit period following delivery |
Worked numbers
Default values from the app; in the interactive version you enter your own.
- Order lines
- 4
- Lines with a breach
- 2
- Below the minimum lot
- 1
- Not a multiple of the pack
- 1
- Order amount
- 3.33 m ₽ · minimum reached
- Amount after correcting the quantities
- 3.48 m ₽ · +143,400 ₽
- Buffer between delivery and the sales start
- 10 days · need 10
- Prepayment at the order
- 999,900 ₽ · 100 days before the sales start
- Balance payable after delivery
- 2.33 m ₽ · on day 105–135 from the order
Check of the lines
| Article | Ordering | Minimum lot | Multiple | Check | Suggestion | Amount |
|---|---|---|---|---|---|---|
| Wool coat | 300 | 200 | 12 | ok | — | 1.8 m ₽ |
| Midi dress | 150 | 200 | 6 | below the minimum | 204 | 375,000 ₽ |
| Quilted jacket | 250 | 100 | 12 | not a multiple | 252 | 1.05 m ₽ |
| Scarf | 120 | 100 | 6 | ok | — | 108,000 ₽ |
Take the terms (MOQ, multiple, timing, payment) from the contract and the order confirmation. The amount after correction is a hint: decide with the supplier whether to round up or down. Check the contract terms with a lawyer.
Nuances and limits
- Rounding the quantity down without checking the minimum lot: the order will not go through.
- Leaving no buffer for receiving and display: a late delivery burns the start of the season.
- Check the contract terms with a lawyer.