CPC G06Q 10/087 (2013.01) | 28 Claims |
1. A computer implemented method to support at least a first system and a second system being used to manage an inventory of an organization, wherein the first system and the second system respectively use first and second categorization schemes, which are orthogonal to each other, to categorize the inventory of the organization in different ways, the method comprising:
receiving an event from the first system that reflects a change made to the inventory relative to the first categorization scheme;
generating a first entry that is based on the event, that is for the first categorization scheme, that identifies a type of item in the inventory, and that identifies a first quantity of the type of item, the first quantity is to be used a first way to perform an update to a first balance for a combination of the type of item and a first category of the first categorization scheme, and the first quantity is to be used a second way to perform a second update to a second balance that is for the type of item and that is irrespective of the first categorization scheme, wherein the first way is opposite to the second way;
automatically determining a reconciliation is required between the first and second systems because no entry was generated based on the event for the second categorization scheme;
responsive to the determining, automatically generating as part of the reconciliation a second entry that is based on the event, that is for the second categorization scheme, and that identifies the type of item in the inventory, the first quantity of the type of item, the first quantity is to be used the second way to perform a third update to a third balance that is for the type of item and that is irrespective of the second categorization scheme, and the first quantity is to be used the first way to perform a fourth update to a fourth balance that is for a combination of the type of item and a default category of the second categorization scheme, wherein the second entry aligns the balances between the first and second systems without requiring categorization according to the second categorization scheme as part of the reconciliation between the first and second systems caused at least in part by the event; and
generating, based on a non-zero balance for the combination of the type of item and the default category of the second categorization scheme, a report that indicates categorization is needed to complete the reconciliation between the first and second systems caused at least in part by the event.
|