Rounding issues on vendor invoices

[Charley Tiggs <..hidden..>]

I think I have rounding issues.  Either that, or I'm not understanding 
how rounding is supposed to work on vendor invoices where a percentage 
is being taking off of each line item.

example:

SELECT (30.75 * 10) - ((30.75 * 10) * 0.05);

 ?column?
----------
   292.1250

As you can see, even if I use the floor() function, it would still be 
292.12.

Yet, when creating a vendor invoice within LSMB, it states that the 
total should be 292.10.  The greater the number, the larger the discrepancy.

Is this a bug or am I just not understanding how rounding should work?

Charley