CODEWITHSUNDEEP
quickbooksintuit-partner-platform
Sequenzia
Sequenzia

Reputation: 2381

QuickBooks Inovice txnID changing

I have an integration running that pulls invoices from QB via the web connector and stores them in SQL. It was always my understanding that the txnID was unique and would not change. I have recently ran into some issues where somehow a long the way some of the txnIDs are changing but it's the same invoice. The invoice number is the same but I end up with duplicates because we use txnID as the unique identifier.

I am not sure if there is just a bug in the code or if there is a case where the txnID will change but it's not actually a new invoice?

Any help on this would be great.

Thanks

Upvotes: 1

Views: 384

Answers (1)

Keith Palmer Jr.
Keith Palmer Jr.

Reputation: 27962

TxnIDs do not change.

More than likely, what happened was an end-user deleted the invoice, and then re-created it with the same invoice number.

Did you try querying for the deleted transactions using TxnDeletedQuery to see if they were deleted?

Upvotes: 3

Related Questions