Quickbooks Sync Advanced Troubleshooting

Clear ID

QBO Invalid Grant 

3170 Dividing Date

Clear ID

1. If you have created these invoice in QB or they have been unlinked from the SingleOps version you may want to delete them in QB before syncing new ones over. 
2. Select Clear ID.
3. This action will clear the list ID and generate a new, functioning list ID. Clicking this button will send NEW data to Quickbooks.

QuickBooks Desktop Clear ID

Quickbooks Online Clear ID 

QBO Invalid Grant 

Brief Description

The invalid grant error comes from a bad Authorization token from your Quickbooks company account. These are normally seen when Quickbooks makes an update or does something that requires other software (SingleOps) to renew the token.

How to Fix 

1. Locate your Account Settings page from the Setup gear icon on the left hand side of your SingleOps account. From there select QuickBooks on the blue side menu.
2. Scroll to the bottom of the page and find QuickBooks Online.
3. You will most likely need to disconnect your QBO account before reconnecting.
4. Now you will need to reconnect you QB Online account. This will force the system to retrieve a new Auth token so you can begin syncing again. You will need you QB Online admin credentials to complete this step.
5. Once this complete you can view any remaining errors from you Reports tab --> Quickbooks sync report. Any errors with the "Invalid Grant" Message can be "resynced." After you resync the errors you should refresh the page to confirm they are resolved. 

3170 Dividing Date

"Unable to update: QBWC ERROR: 3170 - There was an error when modifying an Invoice. QuickBooks error message: You may not create or edit a transaction dated on or before the dividing date."

From time to time, you may have noticed that when you attempted to sync data between SingleOps and QuickBooks, the item would not sync, and checking the QuickBooks sync error list reveals the following error:  'You may not create or edit a transaction dated on or before the dividing date.'

Solution: 

The dividing date is the date you gave a copy of your QuickBooks to your accountant.
No invoices or estimates dated earlier than the dividing date can be updated by SingleOps because your accountant is working on your invoices and estimates in this time period.

Once your accountant merges his/her changes back into your QuickBooks, then the sync will be able to update these invoices/estimates, and the error will go away.

If you cannot wait for the merge to occur, SingleOps can alter the transaction date (TxnDate) in the SingleOps database to allow you to attempt a re-sync.  You will need to provide to SingleOps an explicit list of the job numbers and the new transaction date to which you'd like it changed.