Compare Snapshots (Reconciliation)
Snapshot comparison is the process of comparing a business's inventory records or counts with the actual physical inventory present in its warehouses or stores. The objective of inventory reconciliation or snapshot comparison is to identify any discrepancies between the recorded inventory within OneTruth and the inventory data stored in external systems, such as warehouse management systems. After these discrepancies are identified, they must be rectified within either OneTruth or the external system, based on which system contains inaccurate data.
For example, supply feeds received from external systems, such as SAP systems or Point of Sales (POS) systems, are recorded in OneTruth. These supply feeds are also used by the SAVR service for audits. During an audit, it may be found that the supply records in the external system do not match the supply records in OneTruth. This may be due to an error in the external system or in OneTruth. In such cases, the supply records between the 2 systems are compared to determine in which system the error lies and how it should be rectified.
Snapshot Comparison Process
Snapshot comparison in OneTruth can be done at the following 3 levels:
Supply Comparison: The inventory snapshots are retrieved from external systems, such as SAP systems or POS systems.
Demand Comparison: The inventory snapshots are retrieved from order management systems (OMS).
Availability Comparison: The inventory snapshots are retrieved from the system where the enterprise is keeping track of the availability. This may be the OMS or any other system.
To compare the inventory snapshots between the external system and OneTruth, enterprises must download the source CSV file from the external system and upload the file into OneTruth using the Compare Snapshot UI. OneTruth compares the data in the source CSV file with the data in OneTruth SAVR audits and provides the match or mismatch report in the form of a comparison CSV file.
Additional Capabilities
The following are some additional capabilities to help with the snapshot comparison process:
Comparing the records in the source CSV file with all the items across all the nodes in OneTruth.
Comparing the records in OneTruth with only the item and node combinations found in the source CSV file.
Comparing the records in the source CSV file with all the items from input nodes in OneTruth.
Comparing the records in the source CSV file with input items from all the nodes in OneTruth.
OneTruth uses the snapshot date and time available in the uploaded comparison source CSV file for snapshot comparison by default. However, enterprises can also compare the data at a header level. This is known as the override mechanism, where OneTruth provides enterprises the ability to override the default snapshot date and time in the source CSV file by providing a snapshot date and time of the enterprise’s choice.
If a direct match for the requested date and time is not found in OneTruth, then the most recent inventory record that is available in OneTruth is used for snapshot comparison with the external system’s data.
Types of Discrepancies
During the inventory snapshot comparison between the external system and OneTruth, the following 3 types of discrepancies may be found:
Record is found in the source file from the external system, but is not found in OneTruth. This means that for the given snapshot comparison date and time, OneTruth has not received any transaction for the item-node or item-network.
Record is found in OneTruth, but is not found in the source file from the external system. This usually happens during an All Items, All Nodes comparison where the source file may not have accounted for the item-node transaction, but for the given snapshot comparison date and time, a transaction was found in OneTruth.
Record is found in both the source file from the external system as well as OneTruth, but there is a quantity mismatch.
Snapshot Comparison Results
After the snapshot comparison is performed within OneTruth, a comparison CSV file is generated to provide a report on data matches or mismatches. This comparison file shows whether there was a match or mismatch between the two systems for items across nodes. Since the comparison CSV file is a large file in terms of number of records, the Comparison UI also provides a high-level report for a quick first look at the results. This report or summary has the following information:
Total records in the source file.
Total discrepant records.
Total discrepancy percentage.
Total discrepancy value, that is the sum of all discrepancy values.
Last updated
Was this helpful?