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 table issues with QODBC Driver |
Author |
Message |
Andy |
|
Group | : Members |
Posts | : 5 |
Joined | : 2006-04-10 |
|
Profile |
|
Posted : 2006-04-18 23:56:44 |
I am using the QODBC driver to extract all tables from QuickBooks into a SQL Server database in order to use a 3rd party tool (Cognos) to create reports and analytical cubes from the data. I recently built an AR Aging report from the SQL Server DB and noticed that an invoice that shows as paid in QuickBooks is showing with a remaining balance equal to the original invoice amount (ie not paid). I used the VB app that came with the driver and confirmed that it is also showing up this way in the invoice table using the VB app to directly connect to QB. However, when I look in QuickBooks itself, the invoice is clearly paid with a 0 balance.
I have a snapshot but am not sure on how to attach it.
Do you know why this would be happening?
|
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-04-19 08:16:40 |
By the sounds of things you haven't updated to QODBC v6.00.00.155 yet, see: How can I get the latest version of QODBC?
When you do the extraction updates you should use the unoptimized tag to by-pass the optimizer like this:
select * from invoice unoptimized
or you can resync the optimized table by doing:-
sp_optimizefullsync Invoice
|
|
|
|
Andy |
|
Group | : Members |
Posts | : 5 |
Joined | : 2006-04-10 |
|
Profile |
|
Posted : 2006-04-24 13:33:35 |
The updated driver works great. Thank you for the quick response and resolution! |
|
|
|
|