Marc Durham - Older Entries

569 Older Entries

Years: 2012 2011 2010 2009 2008 2007 2006 2005 2004
Months: 12 11 10 9 8 7 6 5 3 2 1
Days: 29 14 13 8 3 2
1 Entries

2007-08-29 Wednesday 17:07

SQL, Rounding, QuickBooks, Accounting

I feel like I have learned something today. And I don't want to forget it. When a quantity is multiplied by a price, or hours by a rate, they should be rounded before added. When doing a query go like this

SELECT SUM(ROUND(quantity*price,2)) AS price_total 
FROM invoice_item WHERE invoice_id = 1234

And that is how it should be done, and that's how quickbooks and probably other accounting systems do it. Rounding to the second decimal prevents values to the right of the second decimal being added to your totals which will make your totals too high by cents and dollars. This can also be done in spreadsheets using the same named ROUND function.

(edit 225) Permalink

Taipei Weather:
63 F (17 C) Scattered Clouds
Bellingham Weather:
63 F (17 C) Clear
Seattle Weather:
53 F (12 C) Clear

Marc's Facebook Page

validator.w3.org
Taiwan Blogs

The Google Map Location where I slept in Taiwan. 台北市同安街53

You can subscribe to the RSS feed of this blog so you don't have to check to see if I wrote a new one. Click here to subscribe to the RSS feed.

New Twitter thing. In case I can't access the Internet I can put little twitter right here. See. I'm still young and hip with the kids these days.

Taipei Pictures
Taipei Videos
Pictures not posted often

Temporary E-Mail: 8925@markdurham.com
(Just spell the name right!)
That's my other anti-spam trick, first is that this e-mail will expire, so don't put it in your address book, I'll e-mail you a permanent one.

Old Recorded Videos
Funny Kid
My Taipei Apartment
Taipei 101 - Worlds Tallest Building

Web 2.0 Junk
spaces.live.com<
youtube.com
twitter.com
picasa.com someday...
My Quick Links
J-Dude Linux
youtube.com
katiedurham.com
slashdot.org
wikipedia.org
osnews.com
BetaMax-HD-DVD Converter

Chinese Language
Animation of the Chinese character for my surname showing stroke order

Animation of the Chinese character for my surname showing stroke order

My Chinese name (Du)
ZhongWen.com
nciku.com Chinese Dictionary You can draw characters!
Adsotrans.com Translation
PinYin Keyboard

As of 2008-10-20 this page is W3C XHTML 1.0 Compliant. Click to recheck it for me.

This page has been hand coded using Notepad++ by Marc Durham under the consultation of James Yates.

Twitter Updates

Sites of Usefulness