How to set very small unit prices with minimum order quantity and purchase step size restrictions

ERPNext
1

Hi everyone,

I am facing the following challenge in ERPNext and would appreciate your advice.

Use Case:

I want to create an item with these price and ordering rules:

  • 10,000 pieces cost 15 EUR total , which equals a unit price of 0.0015 EUR
  • 20,000 pieces cost 20 EUR total , which equals a unit price of 0.001 EUR
Problems:
  1. Extremely small unit price: When I enter a unit price of 0.0015 EUR, ERPNext rounds it down to 0.00 EUR.➔ How can I store prices with more than 4 decimal places to handle these low values correctly?
  2. Minimum order quantity and allowed increments:
  • The minimum order quantity should be 10,000 pieces .
  • Customers should only be able to order in steps of 1,000 pieces (e.g. 10,000 / 11,000 / 12,000 …).Not allowed are:
  • Quantities below 10,000
  • Quantities not divisible by 1,000 (e.g. 10,700 or 13,245).
My questions:
  • How can I store such low unit prices correctly in ERPNext? Is there a setting in Global Defaults or a configuration for higher floating point precision?
  • How can I enforce minimum order quantities with specific step sizes? Should this be configured in “UoM Conversion Details” or is there a standard method for this use case?

Any hints, experiences, or workarounds are highly appreciated to implement this requirement cleanly in the system.

Thank you in advance!

2

You can create unique Units of Measure. For example, I’ve used X10, and X100. If you create price for each UOM, you should not run into rounding issues.

20,000 pieces cost 20 EUR total , which equals a unit price of 0.001 EUR or for 20 EUR you can purchase QTY = 20 of x1000 @ 2 EUR each.