Skip to main content
All CollectionsBusiness System IntegrationsQuickBooks OnlineSetup & Configuration
QuickBooks Online - Configuring Duplicate Document Checking
QuickBooks Online - Configuring Duplicate Document Checking
Micah A. Parker avatar
Written by Micah A. Parker
Updated over 6 months ago

Product: QuickBooks Online

Setting: Duplicate Doc Num


You can prevent duplicate documents within QuickBooks Online from showing up whenever exporting a Purchase Order (850) by enabling the Error on Duplicate Document Number option or configuring it to Update on Duplicate Document Number if you prefer it to update the existing matching document

Transaction Manager will check QuickBooks Online 'Custom 1' field for the EDI Purchase Order # for the specific Trading Partner you're exporting - if this is found an error/update will occur.


Enabling Duplicate Document Checking


You can enable Duplicate Errors within Transaction Manager that will prevent the Purchase Order from creating any new Estimates / Sales Receipt if the Purchase Order Number has already been received previously into QuickBooks Online.

This functionality does not check against Invoices - if you have Transaction Manager configured to Export Invoices rather than Estimates or Sales Receipts.

Navigate: Business System → Company Configuration → Integration Options

Locate: Duplicate Doc Num

Set: Error on Duplicate Document Number

Errored Transactions

If a Duplicate Purchase Order # was detected - Transaction Manager will throw an error and prevent the Purchase Order from leaving the Inbox or moving into QuickBooks Online


Enabling Update on Duplicate Document Number


If you would rather have existing Estimates or Sales Receipts updated rather than having a hard error, you can set the Duplicate Doc Num setting to Update on Duplicate Document Number instead.

This will update the Estimate/Sales Receipt upon export - and send the Purchase Order into the received folder within Transaction Manager.


Partner Specific Settings


If you wish to have these settings configured at a per-Partner level you can do so under the Integration Preferences for your Trading Partner settings.

Navigate: Trading Partners → (Partner) → Preferences → Integration

Integration Type: Purchase Order (Export)

Check: Use Partner Level Settings

Set: Duplicate Doc Num

When enabling 'Use Partner Level Settings' ALL settings will override the Global Business System settings - be sure to mimic any settings from the global settings that you wish to carry over

rev 6/3/2024

Did this answer your question?