Skip to main content
Solved

Vendor pricing based on quantity of 100 or 1000


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)? 

View original
Did this topic help you find an answer to your question?

2 replies

Forum|alt.badge.img+5
  • Jr Varsity II
  • 237 replies
  • 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
  • 32 replies
  • Answer
  • October 7, 2021

Hello 

 

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


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings