CODEWITHSUNDEEP
quickbooksintuit-partner-platformqbxmlqbfc
Louis van Tonder
Louis van Tonder

Reputation: 3710

QBSDK: Access all transactions of all clients (date period)

I need to look at the "audit" log for quickbooks using the SDK. I am basically looking to sync quickbooks transactions to a 3rd party platform (for reference purposes)

I cant find a reference to the audit log in the OSR, but I do see "TransactionsQuery". What is not clear to me is if this will be "all" transactions, or if you need to specify a specific customer?

Any ideas?

Upvotes: 0

Views: 304

Answers (2)

Keith Palmer Jr.
Keith Palmer Jr.

Reputation: 27982

As William indicated in his answer, the audit log is accessible via a GeneralDetailReport.

As far as actual transactions goes, TransactionQuery will get you all transactions. You do not need to specify a customer.

However, it will only get you summary details of all transactions (e.g. no line items on the invoices, etc.) so if you need detailed information for each transaction, it won't work for you.

If you need details for each transaction, you have to do individual queries for each transaction type (e.g. InvoiceQuery, ReceivePaymentQuery, BillQuery, etc. etc. etc.) so that you get back the details/lines for each.

Upvotes: 1

William Lorfing
William Lorfing

Reputation: 2656

Look at the GeneralDetailReport, with the GeneralDetailReportType set to AuditTrail.

Upvotes: 1

Related Questions