Re: [Emerald] calculating termed-discount values

PowerNet ( (no email) )
Fri, 21 May 1999 15:40:16 -0400

At this point, I am not really worried about how the invoice itemizes=
things for the customer. I can always edit the report later. I am=
primarily concerned with the Item total on the invoice.

*********** REPLY SEPARATOR ***********

On 5/21/99, at 10:36 AM, Dale E. Reed Jr. wrote:

>Josh Hillman wrote:
>> This may sound like a stupid question, but is there a real reason to=
>> the monthly amount (in the case above, 16.66 or 16.67) be restricted to=
>> decimal places (obviously corresponding with pennies)? If there's a=
>> discount involved with an account, then the customer isn't going to be
>> paying $16.67 (or 16.6666667)--they're going to be paying the full term
>> amount of 200.0x.
>Yes, I sorta covered this earlier, but I'll show detail. On the invoice
>you have something like this:
>Login Description Cost Quantity Item Total
>------ ----------- ----- -------- ----------
>daler PPP Dialup 16.67 12 200.04
>Now, if we careied out the decimals in the background (like 278 did) and
>then calc the total, you would get something like:
>Login Description Cost Quantity Item Total
>------ ----------- ----- -------- ----------
>daler PPP Dialup 16.66 12 200.00
>Which, while the item total is more appealing, is NOT correct.
>> So in the case above, the normal monthly rate could really be $20.000000=
>> the annual discounted rate could be $16.666667 (which is quite a bit
>> different from 16.67 when calculating an annual total). Nothing at all
>> would ever come out different with non-termed-discounts, but those that=
>> affected by termed discounts have a lot more room to allow the admin to
>> tweak the totals, so the customer woulnd't see "Amount Due: $200.04"=
>> $199.92) -- it'd be $200.00 (currently not possible because of the=
>> rate rounding).
>> I'm just bouncing ideas around. Maybe I've been in the realm of
>> science/engineering too long and am used to deeper precission...
>I suppose an alternate display it this way:
>Login Description Cost Quantity Discount Item Total
>------ ----------- ----- -------- -------- ----------
>daler PPP Dialup 25.00 12 33.3333 200.00
>Although the discount isn't appealing in that format. :( I
>just have to make sure that the numbers on the invoice actual
>come out when your customer is doing the math.
>Dale E. Reed Jr. Emerald and RadiusNT
>IEA Software, Inc.