I want to find out all transactions of a job and make sure the data synced with my application. I use CustomDetailReportQuery to get the data I need. The problem is that the data is in flat hierarchy and the txnID only returns the ID for the transaction. If there are two items in one transaction, they have the same ID.
Is there anyway to find the txnLineID for each item in the transaction?
I tried to use TransactionQuery, but when I input txnID of the transaction as the search criteria. No items of the transaction are returned.
Thanks.
The
CustomDetailReportQuery
does not allow retrieving thetxnLineId
.I think you are looking for
InvoiceQuery
andSalesReceiptQuery
. This will retrieve the data from Invoices and Sales Receipts that you specify using multiple filters.