thats how i loaded the price list to start with. The problems with
sales orders are entered and the automatic pricing kicks in ( the
discounts are calculated * the number or pieces ordered) it goes to
down the tubes.
I could just rewrite the pricing stored procedures to call a rounding
procedure that would make the results agree with stupid excel :-\
Not the preferred way but it would make data entry people leave me
alone. Thanks for the idea.
Christophe wrote:
> Rather than try to recreate Excel's rounding algorithm, perhaps use
> Excel to create a table of input values and results, and load that
> into the database? It might be easier than trying to back-engineer
> Excel's broken math.