1. Home
  2. QuickBooks Discussions
  3. Rounding discounted prices

Rounding discounted prices

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.

Reply to
dwilli
Loading thread data ...

Your customers are complaining over a discount ?

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

Reply to
HeyBub

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

Reply to
Gary E

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

Reply to
Allan Martin

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

Reply to
Gary E

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?

Reply to
dwilli

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.