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.