[Reply]
At 14:36 on 6/04/2001 you wrote
>To :
>CC :
>From: Mark Howard, [EMAIL PROTECTED]
>Hi all
>
>I'm sure this must ba a basic question
>
>In a Quick Report I have line items in an invoice that go
> quantity price Amount (quantity*price)
>
>The total amount at the end of the line items however does not always equal the sum
>of the line item amounts. This is because
the Amounts being totalled will have more decimal places than are being displayed.
>
>What is the simplest way around this problem please?
Pursue a career elsewhere!!! <g>
Seriously though, you need to look at rounding the figures at some point and storing
what is displayed. So if you are totalling line
item amounts, then what is displayed for each line item must be that. ie your code for
extending (amount * quantity) should do
the rounding (to 2 decimal places), and the document total should be the sum of these
rounded line item amounts.
Kind Regards
Gary
PS: It gets worse when you have GST in there as well......
========================================================
Gary Benner - Software Developer [EMAIL PROTECTED]
Corporate Software New Zealand Limited Auckland - New Zealand
tel: +64-9 846-6067 (24hr) fax: +64-9 846-6152 mob: (021)-966-992
Software System Design - Consulting - Mentoring - Data Modelling
Client Server - Delphi - Interbase - Oracle - Web-based Technologies
Electronic Automation and Systems - Microcontroller Design & Software
http://www.corporate.co.nz
Ref#: 41006
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
