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.
