Skip to main content

Why is the suggested quantity more than my maximum?

The reorder report rounds up to whole cases, so an order can take you a little past your maximum. That's by design.

You set a maximum of 100 candles, and the reorder report suggests buying enough to end up with 104. That's not a mistake. Your vendor sells candles by the case, and you can't buy two thirds of a case.

​

What's happening

The report works out how many you need in your own unit, then converts that into the vendor's unit and rounds up to a whole unit.

​

Example

​

Beeswax Pillar Candle: MAX 100, Available 8. Kiln & Loom Goods sells them in cases of 12.

  • You need 100 minus 8 = 92 candles to reach your maximum.

  • 92 divided by 12 is 7.67 cases.

  • The report rounds up to 8 cases, which is 96 candles.

  • 8 plus 96 leaves you with 104: 4 over your maximum.

​

The candle row: 8 cs, 1 cs = 12 ea, = 96 ea

​

Rounding down to 7 cases (84 candles) would leave you at 92, short of your maximum, so the report rounds up instead. The bigger the case, the further over you can land.

​

Reading the row

Order qty shows the number of cases, with the conversion underneath ([1 cs = 12 ea]) and the total in your own unit (= 96 ea). Unit cost is the price of one case, so Line total is cases times the case price: 8 times 54.00 is 432.00.

​

If you'd rather stay under your maximum

Order qty is a suggestion. Click it and type the number of cases you want, for example 7. The line underneath changes to = 84 ea, and 7 cases is what goes onto the purchase order when you click Generate PO.

​

If there's no conversion line

When the vendor's unit is different from yours, the report shows the conversion it used under Order qty, like [1 cs = 12 ea]. If you see a vendor unit with no conversion line underneath, for example 48 bg on an item you count in each, the item doesn't have that unit set up, and the report is counting one of the vendor's units as one of yours.

​

48 bg with no conversion underneath

​

Add the unit to the item first (Add a case or pallet unit to an item), then check the vendor's UOM on the item's Pricing & Vendors tab. Don't generate an order from that row until the conversion shows.

​

Related articles

Did this answer your question?