Here is an example insert that illustrates my problem.
insert into InvoiceLine (InvoiceLineItemRefListID,InvoiceLineDesc, InvoiceLineRate,InvoiceLineQuantity,InvoiceLineAmount,FQSaveToCache) values ('800001C8-1208967791','VASSOR, WILFRED 9/19/2008 1600 2345',13.85,7.75,107.34,1)
When the header is inserted, the value of InvoiceLineRate becomes 13.85032
Needs to be 13.85.
This only occurs when InvoiceLineQuantity is fractional (i.e. 7.75).....
Thanks for a great product and your help. |