Query for Disconnected Sales
I have an open LS Retail Support trouble ticket for an issue where our integrated Vantiv payment terminal is successfully processing a transaction, the payment hits from our accounting folks' perspective, but the success code isn't being successfully seen back in LS Retail. So we have a growing handful of pending/incomplete sales in LS Retail.
Until I can hear something back from LS Retail Support, I'm trying to query daily sales using the API. In order to pull any transactions that are Completed = No, Cancelled = No, Voided = No but have money in the Totals field (from the web client front end's POV). Here is what I have for my API GET request:
If I exclude the calcPayments=0.00 &calcTotal=>,0.00 query parameters I get a good response back. But when I attempt to employ these query parameters I get back an error response:
An error has occurred and we've been notified.
Please try again and if this problem persists please contact support.
Is there a way to easily pull off this query, or do I always need to pull all sales, iterate through each transaction, and then parse things out?