I am successfully generating all different size invoices from ASP.NET. The issue I am experiencing is that the price level discount for a specified customer is not being applied to invoices generated from code. I have tried grabbing the percentage (lookup the client price level and pull the percent from the Pricelevel table) and inserting the adjusted InvoiceLineRate to the InvoiceLine table but it just takes the default rate for that item code.
This is the sql:
InvoiceLineSalesTaxCodeRefListID, FQSaveToCache) VALUES ('8F0000-979074821', ' - Network Service Hour(s)', 'October 2007', 0.5, 147.89775, 89.635, 82.5, '10000-1012335098', 1)
It produces the following line item:
Item Code Description Quantity Price Per Amount Tax
NET - Network Service Hour(s) .25 165 41.25 Tax
Is there any way to send an adjusted rate to Quickbooks? |