|
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 Numbering |
| Author |
Message |
|
|
| Posted : 2008-01-09 08:37:32 |
Whenever I insert a linked invoice line in Quickbooks, it ignores the reference number I put in for the invoice and numbers it something else. The line inserts okay - the invoice is just given a different number than what I gave it. Any ideas? Can you insert an invoice with QODBC or can you only insert invoice lines? I tried to insert an invoice with the right number and then retreive that number but the insert wouldn't work. I kept getting a "Not Supported" error message. Any ideas? |
|
|
|
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2008-01-09 09:48:17 |
A insert to the Invoice table will only work if there are already cached (FQSaveToCache set to 1) InvoiceLine inserts. If you are creating linked Invoices from the Sales Orders, make sure that the RefNumber is short like this:
INSERT INTO "InvoiceLine" ("CustomerRefListID", "RefNumber",
"InvoiceLineLinkToTxnTxnID", "InvoiceLineLinkToTxnTxnLineID",
"FQSaveToCache")
Select "CustomerRefListID", {fn CONCAT('S', "RefNumber")},
"TxnID", "SalesOrderLineTxnLineID",
0 as "FQSaveToCache" from SalesOrderLine
where "CustomerRefFullName" ='Lamb, Brad:Room Addition' and "RefNumber"='201'
and "SalesOrderLineSeqNo"=1 |
|
|
|
|