Vendor pricing based on quantity of 100 or 1000

  • 5 October 2021
  • 2 replies


We have vendors which are are issuing price lists based on a quantity 100 or 1000.

Base, sales and purchase UOM is MTR.

For example: The vendor price is $ 30.65 for 1000 MTR

The purchase order is for 1250 MTR with no specific packing size

If you divide $ 30.65 by 1000 you get a MTR price of $ 0.03065 per MTR which gives you 

5 digits after the comma. Since the unit price has only 4 digits after the comma you can  

only enter $ 0.0306 or $ 0.0307.

It would ideal to have a vendor price worksheet were you could specify prices per 100 or 

per 1000. Would be interesting to hear if anybody has a solution for this problem.





Best answer by NAWRES 7 October 2021, 20:13

View original

2 replies

Userlevel 6
Badge +5

Couldn’t you just make a unit that represents 100 or 1000 of the base unit and set the vendor price for that unit?

Userlevel 2



Did you try changing the Price/cost Decimal to 5 digits in the company settings (CS101500)? 


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved