QBO Invoice number dupliction
Quickbooks Online syncing on invoice numbers breaks. If both systems are used, QBO takes the last sync and updates its numbering to count up from there. But if both systems create invoices over the next 24 hours, it creates number duplication issues. One fix to look at is having Invoiced do a query or ping of QBO prior to assigning a number to an invoice to see if that number is already in use. Then after creating the invoice, syncing this automatically to QBO instead of waiting for the next 24 hour sync to roll around.
Comments: 2
-
04 Aug, '20
BryanNote that it does appear that Invoiced keeps track of invoice numbers that have been used by QBO. However, if there is only a daily sync, duplication issues can arise.
Also note that QBO uses a transaction number that it applies across multiple transaction types including credit memos, sales receipts, refund receipts, invoices, etc. However, Invoiced does not appear to consider those when determining whether the number has been used. -
10 Aug, '20
Jared King AdminOne workaround is to change the invoice # prefix on Invoiced to prevent collisions. Hope this helps!