Error
INVOICE # cannot be created because there already exists an AR Credit Memo with the document number of "#" in QuickBooks Online.
Alternate error:
INVOICE # cannot be created because there already exists an invoice with the document number of "#" in QuickBooks Online.
Cause
A document in QuickBooks Online already has the document number assigned.
Resolution
Do a search in QuickBooks Online for the document number you are trying to batch. If an invoice or credit memo already has the same number, cross reference the 2 invoices, If this is a duplicate, you can clear the transaction from ConnectWise PSA. If the invoice or credit memo you are trying to batch is different you will need to change the invoice number in ConnectWise to successfully batch over to QuickBooks Online.
In ConnectWise, navigate to Finance > Invoice Search > Invoice/Credit Memo Number > Open the invoice/credit memo > update the number > Close the invoice
Note: You will want to make sure you are using the next number in the sequence of numbers. If you last invoice that successfully created was 601, then you will want to use number 602. ConnectWise will then number the following invoice 603 and so on.
Resources
Please review the following articles to resolve the issue.
- How do I prevent specific invoices/expenses/POs from being batched? How do I clear old transactions in ConnectWise PSA?
- Invoice Creation in QuickBooks Online - Best Practice