Link to home
Start Free TrialLog in
Avatar of Titlevest
Titlevest

asked on

Quickbooks - QODBC - Crystal Reports 2008 Issues

We currently are experiencing some difficulties with using QODBC to connect CR2008 and QB8. All tables besides the Invoice and Invoiceline tables work perfectly. One of the reports created accesses all invoices not paid, QOBDC only returns one entry from 2006.

I moved the QB file on my personal computer (at first attributed the issue to insufficent resources on the server) and received the same results. I ran the verify and rebuild utility using my computer (Windows XP) and was able to run the report perfectly once complete.

After moving the company file back to the server, the next morning the issue reoccured. At this point I am not sure what is causing this issue. Any help with this matter would be greatly appreciated. Thanks!
Avatar of John
John
Flag of Canada image

Once you know it is working locally and properly, the only difference appears to be the server connection. Make sure you have properly installed the QB Server Manager on the server and that you have scanned for the ledger file and make sure the ledger lives on the same physical drive as the server manager. Make sure you are using the same version of server manager as QuickBooks. Then make sure you are mapping to the ledger folder properly (Tools -> Map Network Drive; or NET USE commands). ... Thinkpads_User
ASKER CERTIFIED SOLUTION
Avatar of stlinae
stlinae
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Titlevest
Titlevest

ASKER

Thinkpads_User and stilnae,  Thank you so much for your replies.

Thinkpads_User, I am sorry, I should have clarified the situation.  Although the quickbooks company filed is stored on the server and our accounting group uses a network connection, the QOBDC process is iniated locally (on the server).  The users connection doesn't play into the process (unless RDP is an issue?)

stlinae, I will try your approach later this afternoon.

Thanks again!
I deleted the optimization file and changed the setting for updating the file to "update with every new connection (load updated data first)".  The process is working but of we are missing roughly $140,000 in invoices.  We did a comparison with a QB export and see most of the missing invoices are from 2008 and back.  I change the setting to reload the data with each new connection to see if this takes care of this issue.  I also found this error yesterday in the QODBC log, any thoughts?:

2010-02-01 10:05:02 QODBC Ver:  10.00.00.265 *********************************************************************************************************************
IsAService: False
SQL Statement: SELECT * FROM "Invoice" CALLDIRECT
Error Getting XML in StopIterator
Input XML:
<?xml version="1.0" encoding="ISO-8859-1"?>
<?qbxml version="7.0"?>
<QBXML>
    <QBXMLMsgsRq onError="continueOnError">
        <InvoiceQueryRq requestID="1" iterator="Stop" iteratorID="{08592217-4231-48a9-8d17-83aa70f09e27}">
            <MaxReturned>00001000</MaxReturned>
            <IncludeLineItems>1</IncludeLineItems>
            <IncludeLinkedTxns>1</IncludeLinkedTxns>
            <OwnerID>0</OwnerID>
        </InvoiceQueryRq>
    </QBXMLMsgsRq>
</QBXML>
I cannot help with this particular error. Have you called Crystal Reports Support?
... Thinkpads_User
I think theres a setting you can adjust, but for the life of me I can't remember where. While I look into it, try changing your selection critera to only include Invoices with TxnDate <=12/31/08 and see what happens. It might just be that you have to much data thus the <MaxReturned>00001000</MaxReturned> line.
It took quite a bit of time for the process to complete (a little over 2 hours), but configuring QODBC to reload the data with every new connection worked.  All of the data exported with the pervious criteria, so I guess it was a corrupt optimization file as stilnae suspected.  Thanks guys!
Also configure QODBC to reload data at the start of a new connection.