Rounding discounted prices

Sep 08, 2006 5 Replies

Rate this thread:

dwilli 19 years ago

QB2004 Premier: I have a standard pricelist. Several customers get a flat

5%, 10% etc. discount but it won't let me round an individual price to the nearest penny, consequently it sometimes shows a price out to 5 DECIMAL PLACES!!

My customers are complaining and to be honest it really looks stupid seeing $25.056835 for a price. It rounds it for the extended amount but not the each amount. QB tells me there's nothing I can do. Exporting the price list to excel to import it back in creates another price list which I don't want.

Any suggestions? (My next move is to Microsoft Access).

Thx in advance.

Vote

HeyBub 19 years ago

Your customers are complaining over a discount ?

Well, tell them there's an easy fix for that!

Vote

Gary E 19 years ago

You can manually edit the price, and force it to two decimal places. You could also create a custom template for those customers that complain that only shows info they need.

Gary

Vote

Allan Martin 19 years ago

Do tell, where in the customize invoice feature can one find the switch to reduce the amount of decimals shown?

Vote

Gary E 19 years ago

I didn't say that, I meant he could remove certain columns if necessary

Vote

dwilli 19 years ago

It's not about removing columns...its about not being able to round a price to the nearest cent. I don't want to "hide" a customers' cost; I want it to say $9.57, not $9.573952. Intuit's ONLY way to round is to show $9.47 as $9.00 (rounding to the nearest dollar). How stupid is that? They round to the nearest DOLLAR?????

Yes, I could manually override every price that extends beyond the penny...kinda defeats the purpose of computerizing. I could go back to hand writing invoices, too.

Microsoft Excel lets you show any number of places beyond a decimal point...why not Intuit?

Vote

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required