Method Community

Using the following method we're only getting partial results. The table result should only consist roughly 100 entries. 

Suggestions?

wbsMethodAPI.MethodAPISelect_DataSetV2(Me.CompanyName, Me.Username, Me.Password, "", dsItem, "SalesOrder", "TxnDate, RefNumber, TotalAmount", "TxnDate >= '05/01/2012' AND TxnDate < '05/22/2012'", "", "", "")

 Warren_nickus

How are you formatting the dates? Try formatting them as 'yyyy/MMM/dd' or 'yyyy/MMM/dd hh:mm:ss tt'

So for example 'April 12, 2012' would be formatted as '2012/Apr/12'

And 'April 12, 2012, 10am' would be formatted as '2012/Apr/12 10:00:00 AM'

The way you are formatting them....'05/01/2012'....what date is that? May 1, 2012 or Jan 5, 2012? It's ambigous so sql server tries to interpret it in a way that may not be what you mean.

Dave

Formatting the query using your suggested format didn't help. I used, 2012/Apr/01 and 2012/Apr/23 and still getting partial results. 3 Transactions out of 30 or so.

 Warren_nickus,

Do the transactions show up in regular method? The api queries your method account, it does not query quickbooks. If the transactions are not in your method account then the api cannot return them.

If the transactions do not show up in regular method. Take a look at your synchronization settings under Quickbooks-->Synchronize in method. You may have it set to maintain transactions for a shorter time range than you are querying. Be careful when changing these settings since best practice is to pull only the necessary transactions, as pulling more than necessary can have quite the drag on the performance of QuickBooks (limitation of the QuickBooks SDK).