How is the division information added when creating invoices with the online version? What is the name of the field?

Thanks

I think you mean CLASS. See: Using ClassRefListID when inserting invoice lines 

Note: QuickBooks will use the default date if no date is specified in transaction inserts, but the Online Edition requires a date! So you must include a transaction date like this :-

INSERT INTO "InvoiceLine" ("CustomerRefListID", "ClassRefListID",  "TxnDate",
"RefNumber", "InvoiceLineItemRefListID", "InvoiceLineDesc", "InvoiceLineRate",
"InvoiceLineAmount", "FQSaveToCache")
VALUES ('2','4', {d '2007-08-13'} ,'QBOE1', '1', 'test 1',
100.00000, 100.00, 0)

There is no DIVISION field. Try looking at:

Select * from InvoiceLines where TxnDate > {d'2006-06-30'}

using QODBC to see if there are any differences between your DIVISION invoices and let me know. Thanks.

I'll try that Tom and let you know if I see anything. I have included a screen shot of the preference screen that shows the setup for both division and class. I also included an invoice screen showing the division in use.

Again thanks for the help.

Neal

hi there

have you find the solution on this matter ?

where teh field DIVISION is memorized on QB on line ?

Thanks & regards.

paolo