I've encountered a funny issue where my query seems to be missing a transaction!
I'm using Celigo to pull data QuickBooks Online.
When I run the following query, it returns no results
select * from Purchase Where PaymentType = 'CreditCard' And TxnDate >= '2019-01-01' And TxnDate <= '2019-12-31' OrderBy TxnDate ASC maxresults 1000
However, I know there is a matching result. In fact, the following query fetches it:
select * from Purchase Where Id = '135' And TxnDate >= '2019-01-01' And TxnDate <= '2019-12-31' OrderBy TxnDate ASC maxresults 1000
Here's what the data looks like (attached as a screenshot to preserve formatting):
}
Why is my query not finding the transaction. I also tried the PaymentType in ('CreditCard') format but same issue.
Thanks!
Let me route you to the right support, CEAdECostRat.
We can contact the third-party technical support for Celigo for further assistance with the integration to QuickBooks Online (QBO). The program is only dependent on what information they share with us. They can also help you to find the missing transaction and match them when importing the date to QBO.
Also, I'd suggest posting this question to our Intuit Developer Community. It's a place where different developers and coders help each other with app development, integrations, and programming. Here's how to get in touch with them:
To stay current on all QuickBooks news and latest updates, please visit the QuickBooks Blog site. The page provides articles depending on which topics you've selected.
Also, you may consider checking this article attached in case you have questions concerning QuickBooks and its functions: Getting started with QuickBooks Online.
Make the most of QuickBooks exploration. If you have any debrief about the process, feel free to share them with us in this post. I welcome the opportunity to respond immediately. You have a good one.
File your business taxes with confidence thanks to our 100% accurate guarantee.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here
These cookies are strictly necessary to provide you with the services and features available through our site. Because these cookies are strictly necessary to deliver the site, you cannot refuse them without impacting how the site functions.
These cookies are used to make advertising messages more relevant to you and your interests. They also perform functions like preventing the same ad from continuously reappearing, ensuring that ads are properly displayed, and in some cases selecting advertisements that are based on your interests.