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
|
|
Invoice Line Insert doesn't seem to work |
Author |
Message |
|
Posted : 2006-09-28 12:23:48 |
I ran the following insert using the VB Demo tool.
INSERT INTO "InvoiceLine" ("CustomerRefFullName", "RefNumber", "TxnDate", "PONumber", "InvoiceLineItemRefFullName", "InvoiceLineDesc", "InvoiceLineRate", "InvoiceLineQuantity", "InvoiceLineAmount", "InvoiceLineSalesTaxCodeRefFullName","FQSaveToCache") VALUES ('DOVE DATA PRODUCTS','1000000',{d '2006-08-18'},'','THIRD PARTY FLAT RATE CHARGE','FLAT RATE CHARGE FOR THIRD PARTY LABOR',0,1,100,'N/A',1)
It runs without any errors but does not seem to work (i.e. when I query for that invoice # or invoices in that date range it returns nothing).
The actual message from the VB Demo is "Query Executed. No results returned".
When I check the ODBC messages there are none and there appear to be none in the SDK Messages.
I turned on detail trace to see if that would show anything but from what I can tell it is reading the correct data and committing it okay.
Any ideas on how to find out why this isn't being saved in QuickBooks?
Thanks,
Sherry
|
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-09-28 14:08:01 |
If you are creating only a one line invoice, then you need to have the FQSaveToCache set to False (0).
INSERT INTO "InvoiceLine" ("CustomerRefFullName", "RefNumber", "TxnDate", "PONumber", "InvoiceLineItemRefFullName", "InvoiceLineDesc", "InvoiceLineRate", "InvoiceLineQuantity", "InvoiceLineAmount", "InvoiceLineSalesTaxCodeRefFullName","FQSaveToCache") VALUES ('DOVE DATA PRODUCTS','1000000',{d '2006-08-18'},'','THIRD PARTY FLAT RATE CHARGE','FLAT RATE CHARGE FOR THIRD PARTY LABOR',0,1,100,'N/A',0)
See: How do I create Invoices? for more information. |
|
|
|
|