Product Module

Product Module

I am new to this so please bear with me.  This post involves, Products, Price Books and Quotes.   I am in an industry that supplies a variety of different goods.  The prices of the goods well depend on quantities ordered.  

Usually something like this:

Qty:  12 – 24       Cost:  $32.20

Qty:  25 – 50       Cost:  $31.85

Qty: 51 – 100      Cost: $30.80

I entered the item into products and then added it to price books.  I selected the Pricing Model: Flat, which then gave me the options to enter the pricing by range.

Here are my problems so far:

- The Discount % automatically rounds the numbers.  The correct Discount % should be 0.98913 for Quantity 25 to give the correct price.  Since it rounds the number, it gives me a price of $31.88 a unit.

- When I produce the quote it doesn’t change the Unit Price from 32.20 to the new number which should be 31.85 a unit.  However, it does calculate the correct total; it just doesn’t show the new unit price. 

If someone could help me resolve these issue’s then I would be very grateful.