Thanks folks - I'm not being clear here...

my point is that there is no way to get the [exteneded sum] by using only 2

decimals for the inputs (volume & [unit price]) ...the rounding that a

custom agent's calculator would do would make that impossible.

Here is an example:

volume: 108.88 kg

unit price: 16.4569 ===>> round up to 16.46

invoice [extended price]: 1791.83

value #1 (16.46) yields = [extended price]: (108.88)(16.46) =

- above true price

value #2 (16.45) yields = [extended price]: (108.88)(16.45) =

- below true price

I cannot change the true [extended price]...it must match the accounting

dept's value.

My only choice seem to be extending the precision of [unit price] to 4

decimal places...this yields: (16.4569)(108.88) = 1791.83

Of course this will only work for results below a certain threshold (50k

maybe) ...at which point I would need more decimals to get the exact

[extended price].

What I want to know is this: is there an industry standard for handling

this situation - one standard might be that on shipping invoices the [unit

price] * [quantity] does not have to exactly match the [extended price]...

which is of course not the line i'm getting from my client...

Or maybe shipping invoices with large $$ on them display 6 decimal places to

insure an exact match.....

I don't know -- haven't been here before...wondering if anyone else has

dealt with this before...

Thanks

"astro" <as*********@mn.rr.com> wrote in message

news:_n*********************@twister.rdc-kc.rr.com...

I have a report/invoice that lists volume, price per unit, and extended

price.

My problem is being able to get the extended price by multiplying the

[volume] x [price per unit]. With just 2 decimal places on both volume
and [unit price] I've discovered there is not way to get the exact [extened

price] on invoices with extended price values greater then 50k due to

rounding errors. This customer wants only 2 decimal places on the
invoice.

Is there an industry standard for this? The [extended price] must match
the companies internal accounting system so it can't be fiddled with.

What do other companies do in this scenario?