Solved

# Vendor pricing based on quantity of 100 or 1000

• 2 replies
• 64 views

• Freshman I

Hi,

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.

icon

Best answer by NAWRES 7 October 2021, 20:13

View original

### 2 replies

Userlevel 6
+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

Hello

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