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
|
|
SalesOrderLine Table |
Author |
Message |
Matt |
|
Group | : Members |
Posts | : 25 |
Joined | : 2006-04-25 |
|
Profile |
|
Posted : 2006-05-03 07:33:51 |
I am running a report based on the SalesOrderLineTable. In the report, I don't want sales orders to show up that are closed or invoiced. This works for the most part, but sometimes when I invoice the sales orders, it shows in Quickbooks as being "Fully Invoiced", but that doesn't translate over ODBC to Access, and that sales order still shows up. Any ideas? Thanks! |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-05-03 10:12:04 |
Please update to QODBC v6.00.00.155 (or later) and use the unoptimized tag in your queries.. Try running the following query using VB Demo to re-check your "IsFullyInvoiced" values.
SELECT TxnDate, CustomerRefFullName, RefNumber, IsFullyInvoiced, SalesOrderLineDesc FROM SalesOrderLine unoptimized
See: How do I setup the QODBC Optimizer? Where are the Optimizer options? for more. |
|
|
|
Matt |
|
Group | : Members |
Posts | : 25 |
Joined | : 2006-04-25 |
|
Profile |
|
Posted : 2006-05-04 00:34:36 |
Wil this work in a normal query or do I have to be running a Pass-Through? I tried it in my select query and it doesn't work. It does work in VB Demo. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-05-04 07:33:55 |
|
|
|
|