Fix discrepancies
Overview
Discrepancies between Cin7 Omni and your Accounting software arise after a transaction has been synced into your Accounting software, but then later modified in one system and not the other.
These discrepancies can take one of the following forms:
The Invoice date is different between Cin7 Omni and the Accounting software.
The item quantities, or item cost/price are different between Cin7 Omni and the Accounting software.
The transaction is voided in one system but not the other.
This only applies to V2 of the Xero and QuickBooks Online Dashboards
Review discrepancies
From the left navigation panel in Cin7 Omni, select Accounting, then your installed Accounting dashboard.
In the first row of tabs, select “Discrepancies”.
Two sub-tabs are shown, one for Sales Order Discrepancies and the other for Purchase Order Discrepancies.
Select either sub-tab.
All rows displayed here have been raised due to a discrepancy between the two systems.
Review the “Difference” and “Discrepancy” columns to check why the discrepancy has been raised.
You can click on the “Reference” hyperlink which will take you to the original Cin7 Omni transaction.
Fix discrepancies
To fix the discrepancies you will need to manually update one of the transactions to match the other. This can be done in either Cin7 Omni or your Accounting software, depending on which version of the transaction you deem correct.
For discrepancies due to a difference between the Invoice Date, item quantities or item cost/price you will need to decide which system needs to be corrected before doing so.
If you find the transaction is locked in Cin7 Omni, you will need to log in using your administrator account.
If you cannot edit the transaction in the Accounting software, you may need to unlock the period and/or un-apply any payments before making any changes. After completing the changes, re-apply any payments that you removed.
Once you have done the necessary changes, refresh your Accounting Dashboard, using the “Refresh” icon (located at the top right of the dashboard beneath your user name and company name)
If the transaction is voided in one system, and not the other, you need to decide if this is correct or not.
If correct, you need to void the transaction if the other system.
If incorrect you need to re-create the transaction in the system it was voided in. Please note - it is best practice to create a new version of the original transaction in Cin7 Omni and then sync the new version into your Accounting software, and then void the remaining “not voided” old version in either system. This allows Cin7 Omni to track any changes made to this new transaction in either system. Please follow the steps below to do so: -
Open the original transaction in Cin7 Omni and click ‘Go to Admin’.
Hover over “Actions” and then click “Create New Version A,B,C”.
Once this new version has been created, sync it into your Accounting software.
Void the original transaction in either Cin7 Omni or your Accounting software.