Home Page link  

Rounding discounted prices

  
Groups | Search | About
User Password
Register Now! Lost Password?

QuickBooks Discussion board - Discussions about the popular financial software by Intuit

 Post an article  get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
Rounding discounted prices dwilli 09-08-2006
Posted by dwilli on September 8, 2006, 8:49 am
Please log in for more thread options
 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.



Posted by HeyBub on September 8, 2006, 9:17 am
Please log in for more thread options
 dwilli wrote:
> 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).

Your customers are complaining over a discount ?

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



Posted by Gary E on September 8, 2006, 10:07 am
Please log in for more thread options
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

> 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.
>



Posted by Allan Martin on September 8, 2006, 1:07 pm
Please log in for more thread options

> 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.

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



>
> Gary
>
>> 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.
>>
>
>



Posted by Gary E on September 8, 2006, 10:15 pm
Please log in for more thread options

>
>> 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.
>
> Do tell, where in the customize invoice feature can one find the switch
> to reduce the amount of decimals shown?

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

>
>
>
>>
>> Gary
>>
>>> 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.
>>>
>>
>>
>
>



Similar ThreadsPosted
Rounding off in Invoice Qty column August 21, 2006, 11:59 pm
entering discounts AND DISCOUNTED TOTALS on invoices June 5, 2008, 8:52 am
Trading and Financial Software and Literature, KNOCKOUT Prices, DO NOT GET SCAMMED!! January 4, 2007, 4:36 pm
Trading and Financial Software and Literature, KNOCKOUT Prices, DO NOT GET SCAMMED!! January 4, 2007, 4:47 pm
Does changing price for an Item change prices/amounts in past invoices? January 26, 2007, 1:26 pm

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software
XML SitemapXML Sitemap