The reconciliation report indicates unreconciled transaction lines (i.e. transactions that could not be linked to your dimension data), unmatched transactions (i.e. transactions that could not be linked to your trading partner data), plus any duplicate transactions that exist.
Once the reconciliation process has been completed, a reconciliation report will automatically be generated.
The Reconciliation report page displays a list of reconciliation jobs completed within the last month.
Run type: Displays as Scheduled when the reconciliation process has been run automatically at a pre-determined time of day - this provides a full reconciliation report showing all unreconciled lines in the channel. Addition of lines displays when the reconciliation process has been triggered by the upload or import of new transactions - this provides a reconciliation report for a single import only.
Tip: Addition of lines run types are useful to investigate if an issue can be isolated to a specific import, whereas Scheduled run types are usefulto investigate any broad issues regarding missing transactions that cannot be isolated to specific import.
Completed: The date and time the reconciliation process completed.
Run by user: The user who generated the reconciliation process if reconciliation was triggered manually or by the manual upload of transactions. Automated Turnover Import will be displayed if the reconciliation was triggered by the automated import of transactions. This column will be left blank for scheduled transactions reconciliation.
Trading partners: Displays All if reconciliation has been run for transactions across all trading partners, or trading partner names if reconciliation has only been run for transactions attached to specified trading partners.
Duplicates allowed: Displays Yes if duplicate transactions were allowed to be reconciled and added to the transactional data or No if duplicate transactions were not allowed.
Click on a row within the report to display high-level details of the reconciliation report on the right of the page:
Trading partner: The name of the trading partner attached to transaction lines.
Reconciled transactions: The number of transaction lines which were reconciled and matched to dimension data.
Unreconciled transactions: The number of transaction lines which were unreconciled and not matched to dimension data.
Click on CSV download and click on an option below to download:
Unreconciled turnover lines: This CSV file will provide a list of transaction lines that could not be linked to dimension references in your dimension data (e.g. could not be linked to any existing product references). The file will follow the format of the transaction template, with an additional columns indicating the Unmatched columns (i.e. the columns for the transaction line which could not be matched to data within the channel), Duplicate turnover line (i.e. Yes if the transaction line is a duplicate transaction), and if the transaction line was from a Manual import.
Unmatched to a trading partner: This CSV file will provide a list of transaction lines that could not be linked to trading partner references in your trading partner data.
Note: Unreconciled transactions will not generate earnings for trading programs or support for special pricing agreements until reconciled.
Resolving unreconciled transactions
When reviewing unreconciled transactions, we recommend that you check the relevant data within your channel (e.g. search for a product where a product reference has been unreconciled).
Consider the following:
Has an error been made in the transaction file? If so, make the relevant amendments to the transaction line(s) and import the new transaction line(s). Then, delete the unreconciled transactions.
Does the channel data need to be updated to include unmatched data (e.g. trading partners or dimension items such as products)? If so, make the relevant amendments to your source data, either via import or the UI. Tip: If your organization uses automated imports, consider if amendments are required to your master data as well as the data imported within Enable.
The platform will then automatically attempt to reconcile these transactions next time the reconciliation process runs. For example, if you add missing items to your dimensions such as products which related to unreconciled transactions, these transactions would attempt to reconcile during the next reconciliation job.