How to find orders not linked to QBO
If you are posting all of your orders to QBO the system will return a link to the QBO invoice and add it to your order in Naviteer. Open an order and the Accounting tab as shown below to see the QB Invoice ID.
.png)
To search to reveal orders that have not been posted to QBO (due to an error etc). Create a query with quick search or a reusable query with query wizard.
Open Quick search from right task bar under Search/Tag.
.png)
Scroll down to QBO Invoice ID on the Field to Search drop down. Leave the Value to Look for blank. The search should show all invoices that were not posted to QBO.
.png)
To create a reusable search use Query Wizard. Open Query Wizard from the right task bar.
.png)
Select New to create a new query.
.png)
Scroll down to and highlight the QBO Invoice ID field and press Next. Select Is Blank Query Operation and press Next. Press Finish and say Yes to Would you like to save this query? and enter a description for the query (for example - QBO ID Not Blank) press OK to save. This query is now available at any time by opening Query Wizard from the right task bar or from the query wizard drop down at the top of the Orders table.
.png)
Quickbooks Online Processing Log
The processing log under the QB tab on the top menu can be used to see all QBO postings. A query for this table can be created like the order query.
.png)
Select description and query operation Contains and add the word failed. Save with new name as shown above.
.png)
|