Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
If you can't
login and post questions or you are having trouble viewing forum posts:
Click Here
|
Callback
Support |
If you live in USA, UK, Canada, Australia or New
Zealand, you can leave us details on your question and request us to call you back and discuss
them with you personally (charges apply). |
Click Here
|
Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
|
What tables can be modified when using QODBC with the QuickBooks Online Edition (QBOE)? |
Author |
Message |
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-02-21 12:14:37 |
Using QODBC with the QuickBooks Online Edition (QBOE), Insert, Query and Update operations are supported for the following "list" tables:-
• Account • Class • Customer • Employee • ItemService • PaymentMethod • Vendor
Insert and Query operations are only supported for the following "transaction" tables:-
• Bill, BillExpenseLine • Check, CheckExpenseLine • CreditCardCharge, CreditCardChargeExpenseLine • CreditCardCredit, CreditCardCreditExpenseLine • CreditMemo, CreditMemoLine • Invoice, InvoiceLine • JournalEntry, JournalEntryCreditLine, JournalEntryDebitLine • ReceivePayment, ReceivePaymentLine • SalesReceipt, SalesReceiptLine • TimeTracking • VendorCredit, VendorCreditExpenseLine
TxnDeleted is also supported for the transactions that were created by QODBC.
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", "TxnDate", "RefNumber", "InvoiceLineItemRefListID", "InvoiceLineDesc", "InvoiceLineRate", "InvoiceLineAmount", "FQSaveToCache") VALUES ('2', {d '2006-04-13'} ,'QBOE1', '1', 'test 1', 100.00000, 100.00, 0)
The Header for Invoice in QBOE has four extra fields for Tax. SalesTaxLineAmount, SalesTaxLineRatePercent, SalesTaxLineAccountRefListID and SalesTaxLineAccountRefFullName. For transactions with Tax you will need to do an additional insert into Invoice. |
|
|
|
|
Posted : 2006-05-02 05:20:27 |
Tom,
I have noticed that some fields within these tables can't be inserted/updated/etc. I get the following message when trying to run the following statements:
INSERT INTO InvoiceLine (InvoiceLineItemRefListID, InvoiceLineDesc, InvoiceLineRate, InvoiceLineAmount, FQSaveToCache) VALUES ('2', 'THIS IS A TEST BY NOAH', 100.00000, 100.00, 1)
INSERT INTO Invoice (CustomerRefListID, TxnDate, RefNumber, DueDate, SalesRepRefFullName) VALUES ('2', {d'2006-05-01'}, 'TestRefNum_1', {d'2006-06-01'}, 'NK')
ERROR [42S00] [QODBC] Column not found: SalesRepRefFullName
I can't figure out why I am getting this. When I remove the field 'SalesRepRefFullName', everything works great. Any ideas? And if certain fields can't be inserted to, is there a master list anywhere?
Thanks, Noah |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-05-02 08:23:13 |
The QuickBooks Online Edition (QBOE) doesn't have all the functionality as the desktop version of QuickBooks so all operations using QODBC are limited.
The "ERROR [42S00] [QODBC] Column not found: SalesRepRefFullName" is because there's no SalesRep list table.
|
|
|
|
|
Posted : 2006-05-02 10:33:56 |
Is there any way to insert to the Sales Rep field. The field exists because it shows up on the QBOnline interface. Is my only option to go and enter a Sales Rep manually? When you save it this way, where is the data saved if there is no Sales Rep field?
Thanks, Noah |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-05-02 10:59:06 |
Sorry, the qbXML SDK limitations using the QuickBooks Online Edition are Intuit's, not ours. Check the Invoice table as extra columns appear in the Invoice table when using QBOE. |
|
|
|
|