| ReceivePaymentLine Missing Records |
| Author |
Message |
| Gary |
| |
| Group | : Members |
| Posts | : 3 |
| Joined | : 2007-10-18 |
|
| Profile |
|
| Posted : 2007-10-18 04:04:35 |
I am interfacing to Quickbooks 2005 using QODBC. The VB demo is not pulling back all rows for ReceivePaymentLine. I have tried optimizing using sp_optimizefullsync the data but I still get the same results. For example one customer has only has 1 record getting returned by VB demo and there are 2 records in Quickbooks.
Payments on 9/30 and 10/10 are in Quickbooks. But VB demo only returns 9/30 record.
Other payments are returned by VB demo for the same 10/10 date and greater. Nothing about the payments looks different in QuickBooks.
Is there something about interfacing qodbc to quickbooks 2005 that would cause this problem. Some way to enter a payment in Quickbooks without generating a receivepaymentline record?
|
|
|
|
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2007-10-18 07:40:54 |
| The Intuit qbXML SDK bug that causes a SELECT * only to show the incorrect number of ReceivePaymentLine lines (used by the Optimizer), while other lines are missing altogether was fixed by Intuit in the R7 update for QuickBooks 2006, you will need to upgrade to a later version of QuickBooks. |
|
|
|
| Gary |
| |
| Group | : Members |
| Posts | : 3 |
| Joined | : 2007-10-18 |
|
| Profile |
|
| Posted : 2007-10-18 07:55:50 |
Thanks for the reply. I did find the forum report about Select * having problems in earlier version so I am not using Select *. I am using this query: Select TxnId, TxnNumber, TimeCreated,CustomerRefFullName, DepositToAccountRefFullName from ReceivePaymentLine Unoptimized. According to what I read this should work. Is that not the case? It is for a client of mine and I don't think they want to upgrade QB. Everything else works fine. Is there anything else that can be done?
|
|
|
|
| Tom |
| |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2007-10-18 08:02:05 |
| You can try seeing if the R10 update for QuickBooks 2005 fixes it, but all of us are on 2007 and 2008 now. |
|
|
|
| Gary |
| |
| Group | : Members |
| Posts | : 3 |
| Joined | : 2007-10-18 |
|
| Profile |
|
| Posted : 2007-10-18 08:27:26 |
OK - I will test this on a 2007 copy of QB that I have.
My user will have to buy QB 2008 - Are there any compatiblity issues betwwen QODBC 7 and Quickbooks 2008? |
|
|
|
| Tom |
| |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2007-10-18 16:42:26 |
| Yes, you need to use QODBC v8 to get the benefits of the faster Customer and Vendor lists in QuickBooks 2008. |
|
|
|
