ALERT: Datto Drive Cloud service will no longer be available as of July 1, 2019. For more information, see our end-of-life article. If you'd like to migrate your data to Datto Workplace, see our migration guide.
To learn how to download your Datto Drive Cloud data, please visit this article.

Datto Autotask PSA: QuickBooks Online: Error '400 Duplicate Document Number'

Follow

Issue

The sync of an invoice from Autotask to QuickBooks Online is failing, and 'ERROR' is appearing within the Autotask Invoice Number field. You see the following output in AppConnect:

"Error creating the QuickBooks invoice for Autotask invoice ID _____ and account _____. Reason: There was an error. 400 Duplicate Document Number Error Duplicate Document Number Error : You must specify a different number. This number has already been used. The invoice number for Autotask invoice id _____ and account _____', was set to 'ERROR' in Autotask."

Environment

  • Datto Autotask PSA

Cause

The custom transaction numbering option is enabled in QuickBooks Online, and the application is having difficulty assigning the 'next' invoice number because it's colliding with a number that is already in use.

Resolution

To correct this behavior, turn off custom transaction numbering in QuickBooks Online by performing the following steps:

  1. In QuickBooks Online, select the tools icon in the top right-hand corner.
  2. Select Accounts and Settings.
  3. Select Sales from the left-hand menu.
  4. Edit the Sales form content section.
  5. Disable the Custom transaction numbers setting.
  6. Attempt the sync operation again.

Was this article helpful?

0 out of 0 found this helpful

You must sign in before voting on this article.

Want to talk about it? Have a feature request?

Head on over to our Community Forum or get live help.