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
|
|
Incomplete ReceivePaymentLine Data |
Author |
Message |
|
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? |
|
|
|
Tom |
|
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. |
|
|
|
|
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. |
|
|
|
Tom |
|
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. |
|
|
|
|