Move the closing date back, then perform a sync with QuickBooks Online. Change the closing date back to the original.
If you have a set closing date in QuickBooks Online, you may receive the following error stating that a bill, invoice, payment, or journal failed to sync due to the transaction having a date prior to the QuickBooks closing date:
Error Invoice Error updating QB invoice with ID 9265 to match Acctivate 17a966d7-8c34-4a64-834e-ccaad64a5df1 (2UFU14EK): BadRequest. Details: The account period has closed and the account books cannot be updated through through the QBO Services API. Please use the QBO website to make these changes.
This type of error occurs when a user updates or creates a transaction in Acctivate with a date prior to the closing date in QuickBooks. QuickBooks does not allow these transactions to sync until the closing date is changed or removed. A common reason for this is that Acctivate is not aware of the closing date until a QuickBooks sync is performed. If the closing date is set and you have not synced yet, Acctivate still allows changes to be made in the closed period. However, once it has been synced, QuickBooks will not accept those changes. To avoid this, it is important to run a sync immediately after editing the closing date within QuickBooks.
To resolve this error, make sure to follow the steps below:
-
To resolve this error, follow these steps:
1. Log in to your primary admin or company admin account in QuickBooks Online.
2. Go to Settings and select Account and settings.
3. Click on the Advanced tab.
4. Choose the Edit option in the Accounting section.
5. Modify the Closing date to match the corresponding accounting period, and then click Save.
If you are unable to locate the date of the transaction, you have the option to utilize the Inventory Detail Journal report in Acctivate. This report will allow you to retrieve the necessary information.
- Go to File > Inventory > Inventory Reports, then click Transactions > Inventory Detail Journal.
- Enter the journal number from the sync log in the Journal ID field, then click Preview.
- The original journal date will appear next to the Transaction Type field. The closing date in QuickBooks will need to be changed to one day prior to this date to clear the sync error.
It is important to correct closing date-related sync errors for a number of reasons. Until the affected transactions are updated in QuickBooks, your Acctivate and QuickBooks company accounts be out of balance, which will cause issues during audits.
Another reason to resolve these sync errors is to reduce the time it takes to completely synchronize Acctivate with QuickBooks Online. If it has been a while since your synchronization log was free of errors, the sync will take longer to complete until the errors are resolved.
If you are having any difficulty with any of the steps above, contact Acctivate Support for further assistance.