How Do I Resolve the "There was an error adding, modifying or deleting XXXXXX-XXXXXXXXXXX because it is already in use." Error when Exporting to ERP
Answer
You may encounter this error when trying to export Commitment Change Orders (CCOs) to QuickBooks®. When this error is triggered, you may also see an error in QuickBooks® stating "The transaction could not be locked". This export failed because the Purchase Order (PO) is currently open in QuickBooks®. The X's in this article represent the unique ID of the PO that will be displayed on your error message. Follow the instructions below to remedy the issue.
Steps
- In QuickBooks, close the window where the Purchase Order is displayed.
- Reject the commitment change order from the ERP Integrations, Commitment Change Orders, Failed to Export filter.
- On the Commitment Change Order page, click Re-send to ERP
- On the ERP Integrations, Commitment Change Orders, Ready to Export filter, Accept and Export to QuickBooks.
Note
Occasionally, closing the PO in QuickBooks® does not resolve this issue. In that case, have everyone exit QuickBooks®, then repeat steps 2-4.If these steps do not resolve your issues, please contact us at erpsupport@procore.com with details of which error you have been receiving and which steps you have already tried along with the exact outcome.