I'm creating a bill and the first entry it adds the tax code but not for other subsiquent entries.

First create bill (there are no problems with this and creates fine including tax code)
INSERT INTO BillExpenseLine (VendorReflistid, APAccountreffullname, txndate,RefNumber, ExpenseLineAccountRefFullname,  ExpenseLineAmount, ExpenseLinememo,  ExpenseLineCustomerRefListID,  ExpenseLineTaxCodeReffullname, FQSaveToCache ) 
VALUES (SuppID ,'Accounts Payable', TxnDate , SuppNo , Acc, ActualPrice , ItemDesc , CustID ,"NCG",0 )

Then with the txnid I add all other lines (it also creates fine, but without the tax code)
INSERT INTO BillExpenseLine (txnid, ExpenseLineAccountRefFullname,  ExpenseLineAmount, ExpenseLinememo,  ExpenseLineCustomerRefListID,  ExpenseLineTaxCodeReffullname, FQSaveToCache ) 
VALUES (TxnID , Acc , ActualPrice , ItemDesc , CustID ,"NCG" ,0)

This mean I have to manually go into QB and add the taxcode for each line after the first one.

QBi 2009/10 QODBC V9.

Any Ideas.

Tom,

That didn't work, still the same first line includes the taxcode, others don't.

Any more Idea's?

Thanks

DA.

INSERT INTO InvoiceLine (CustomerRefListID, InvoiceLineItemRefListID, InvoiceLineDesc,
InvoiceLineRate, InvoiceLineTaxAmount, InvoiceLineTaxCodeRefListID, FQSaveToCache)
VALUES ('1840000-1112685502', '1B0000-1151902315', '23007',
96, 9.6,'8000000A-1224053897', 0)

Sorry, that doesn't make any sense to me. I just want to add a bill. As stated before, the first line adds the tax code, subsiquent lines don't. In the first line, when adding the taxcode it automatically creates the tax amount. Just as it would when Ido it manually by selecting the appropiate tax code.

Can I get any support on this issue?

We are getting large bills from exporters with lists of hundreds of products imported per bill. We have to manually add the tax codes for each line.

It was always done like that, I'm suspecting because there are potentially thousands of lines per importer bill (as it is more cost effective to import many vs few items) and also a performance issue. The last bill contained 300 odd lines. These lines include landing, shipping per item and other costs etc, so we can determine an individual price of an item to sell.

Well try creating multi-line Bills and updating them afterwards anyway instead.

The other reason why it is done this way is that the import will split portions of their bill eg part ticular item gets held in customs but the rest is released.

So writing multilines first is ok but when adding the next set of data no tax code will show.
Because remember (which I would hope this simple thing would get fixed) the first line writes the tax code fine then next lines do not, writing multilines will work but when adding items after the last multiline statements, inserting just 1 extra line will not add the tax code (back to the original problem) and customs can sometimes hold a major portion of the shipment.

I also tried     update BillExpenseLine set ExpenseLineTaxCodeReffullname = 'NCG', ExpenseLineSalesTaxCodeReffullname = 'NCG', ExpenseLineSalesTaxCodeRefListID ='8000000C-1246790341', ExpenseLineTaxCodeRefListID = '8000000C-1246790341' where  refnumber = 'xx'
it correctly counted the number of records but did not update the tax code.