Member Login

Username
Password
Forget Password
New Sign Up
Search Forum

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

Forum : Incomplete ReceivePaymentLine DataSearch Forum

Forum Home > QODBC - ODBC Driver for QuickBooks > QODBC v6 Forum

 New Topic 
 
 Post Reply 
[1]  
 Incomplete ReceivePaymentLine Data 
 Author   Message 
  Althea 
  
 Group: Members 
 Posts: 2 
 Joined: 2007-09-12 
 Profile
 Posted : 2007-09-12 00:57:20
I am using QB2005.  When I pull a query from MSQuery to Excel using the ReceivePaymentLine table all payments received do not show nor is there an error message saying why this may have happened.  What is the reason why I am not able to pull all information from this table? 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2007-09-12 09:53:15

There was an Intuit qbXML SDK bug that caused a SELECT * only to show the incorrect number of ReceivePaymentLine lines (used by the Optimizer), while other lines were missing altogether. This was fixed by Intuit in the R7 update for QuickBooks 2006. Make sure you are using QuickBooks 2006 release R7 or later, see: http://support.quickbooks.intuit.com/support/ProductUpdates.aspx to obtain the latest updates for your version of QuickBooks.

You should also be using QODBC v7.10.00.231 or later (see: How can I get the latest version of QODBC? ) and do a:

sp_optimizefullsync ReceivePaymentLine

to resync your optimized ReceivedPaymentLine table. Once that's done:

Select * From ReceivePaymentLine

Select * From ReceivePaymentLine Unoptimized

Select TxnId, TxnNumber, CustomerRefFullName, DepositToAccountRefFullName
From ReceivePaymentLine

Select TxnId, TxnNumber, CustomerRefFullName, DepositToAccountRefFullName
From ReceivePaymentLine Unoptimized

should all match.

 

  Top 
  Althea 
  
 Group: Members 
 Posts: 2 
 Joined: 2007-09-12 
 Profile
 Posted : 2007-09-15 07:29:05
Thanks for replying.  That fix didn't help me.  I only have the read only version of QODBC.  When I updated everything as you listed it still gave me the same results omitting the same items that were omitted before the updates. 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2007-09-16 18:10:04
Sorry, you will need to upgrade to QuickBooks 2006, 2007 or 2008. 

  Top 
 New Topic 
 
 Post Reply 
[1]  

Jump to