Skip to main content
Duplicate Purchase Order Numbers

How to resolve duplicate purchase order number warnings with QuickBooks

Teddy Widom avatar
Written by Teddy Widom
Updated over a year ago

If you are connected to QuickBooks and syncing purchase orders, you might see the following warning message in your Materio purchase order list:

This purchase order number was already taken in QuickBooks. Synced with a modified number instead.

This article will help you to understand and resolve this issue.

Why the Issue Occurs

When certain QuickBooks settings are enabled, QuickBooks incorrectly tries to learn from and mimic Materio's purchase order numbering format. QuickBooks then generates new purchase order numbers that should instead have been reserved for Materio, resulting in duplicates.

How to Resolve the Issue

To resolve the issue, set up QuickBooks to use its own, separate purchase order number format. This way, purchase order numbers generated directly by QuickBooks will never overlap with those generated by Materio. The following steps should all be done in your QuickBooks account, not in Materio.

TIP You may find an incognito browser is needed for the following steps to work

1. Log into your QuickBooks account.

2. Go to Gear Icon / Your Company / Account and Settings / Expenses / Purchase orders.

3. Ensure the Custom transaction numbers setting is toggled ON and saved.

4. Create a new QuickBooks purchase order.

5. In the PO no. field, enter 10001 (or choose your own format).

Entering 10001 will set up a new numbering sequence specifically for purchase orders created directly in QuickBooks: 10001, 10002, 10003, ..., etc.

You can choose whatever format you want. For example, entering ABC001 would set up the new numbering sequence: ABC001, ABC002, ABC003, ..., etc.

Whatever format you choose, just make sure it is different from Materio's format.

6. Save and close the purchase order, filling in zero-dollar dummy data as necessary.

7. Return to Gear Icon / Your Company / Account and Settings / Expenses / Purchase orders.

8. Now toggle OFF the Custom transaction numbers setting, and save.

Toggling OFF the Customer transaction numbers setting locks in your new numbering format for all new purchase orders you create directly in QuickBooks.

9. Clean up by deleting the dummy purchase order you created in the previous steps.

Did this answer your question?