Check purchase orders for reconciliation
Overview
Find and fix purchase orders causing discrepancies between Cin7 Omni and Xero or QuickBooks Online.
Sales orders must have the following information to sync to Xero or QuickBooks Online:
A Fully Received date
An Invoice Date
A Supplier Inv No
If a sales order has one or two but not all three of these data, Cin7 Omni and Xero or QuickBooks Online won’t reconcile. You must find these purchase orders and add the missing information for reconciliation.
Find purchase orders to fix
First, find purchase orders with a Fully Received date and no Invoice Date:
From the Purchases menu in the navigation, open Purchase Orders.
Set Purchase Orders Status to Received But Not Invoiced. The purchase orders in the results have a Fully Received date but no Invoice Date.
Then find purchase orders with an Invoice Date and no Fully Received date:
From the Purchases menu in the navigation, open Purchase Orders.
Set Purchase Orders Status to Invoiced. In the results, any purchase order without a Received date has an Invoice Date and no Fully Received date.
Finally, find purchase orders with an Invoice Date or Fully Received date but no Supplier Inv No:
From the Purchases menu in the navigation, open Purchase Orders.
Set Purchase Orders Status to Search All.
Order the results by Supplier Inv No (click Supplier Inv No column header). In the results, any purchase order without a Supplier Inv No but with a Received or Invoiced value is a purchase order with an Invoice Date or Fully Received date but no Supplier Inv No.
Fix purchase orders
For each of these purchase orders missing either a Fully Received date, an Invoice Date, or a Supplier Inv No, open the transaction and add the missing data and save. Then sync your purchase orders to Xero or sync your purchase order to QuickBooks Online.