Skip to main content
Answer

Vendor pricing based on quantity of 100 or 1000

  • October 5, 2021
  • 2 replies
  • 85 views

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.

 

 

 

Best answer by NAWRES

Hello 

 

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

2 replies

Forum|alt.badge.img+5
  • Jr Varsity II
  • October 7, 2021

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


Forum|alt.badge.img
  • Jr Varsity II
  • Answer
  • October 7, 2021

Hello 

 

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