Supply chain financial orchestration system
A system that processes trade events is provided. The system receives events associated with a supply chain financial orchestration flow, where a supply chain financial orchestration flow defines a trade relationship between a first entity and a second entity. The system further determines whether at least one event indicates an ownership change of an item between a first entity and a second entity. The system further generates trade events where at least one event indicates an ownership change. The system further sends the trade events to a cost accounting system. The cost accounting system further performs accounting based on the trade events and generates trade accounting events.
1. A non-transitory computer-readable medium having instructions stored thereon that, when executed by one or more processors of a supply chain financial orchestration system, cause the processors to track transactions of an item within an enterprise that comprises a plurality of entities, the transactions of the item comprising a supply chain financial orchestration flow, the tracking comprising:
defining for the supply chain financial orchestration flow one or more ownership events, each ownership event comprising an ownership change of the item between first entities of the plurality of entities, wherein a completion of the transaction comprises an ownership path where ownership moves among the first entities;
defining for the supply chain financial orchestration flow one or more physical execution events, each physical execution event comprising a physical movement of the item between second entities of the plurality of entities, wherein the completion of the transaction comprises a physical movement path among the second entities;
wherein the ownership path is different than the physical movement path; receiving a first event associated with the supply chain financial orchestration flow;
determining whether the first event indicates an ownership change between two of the plurality of entities;
when the first event indicates an ownership change, generating one or more corresponding trade events and corresponding accounting attributes and sending the trade events and accounting attributes to a cost accounting system that generates one or more corresponding trade accounting events;
receiving a physical execution event associated with the supply chain financial orchestration flow, wherein the physical execution event indicates a physical movement between two of the plurality of entities; and
sending the physical execution event to the cost accounting system that performs accounting based on the physical execution event;
the sending the trade events and the sending the physical execution event comprising:
listening for events generated by the transactions by an event mediator;
in response to the listening, for each new event that is of interest to the supply chain financial orchestration system, the event mediator calling a source document enrichment web service to enrich the new event;
creating a task layer service payload by a task layer service for the new event; and
transforming the task layer service payload into a format that is understandable by the cost accounting system;
wherein the accounting that is performed based on the trade events is independent of the accounting that is performed based on the physical execution event, wherein the transforming comprising:
selecting a connector service for an external target system based on a task type of the task;
transforming the task layer service payload into an external target system format; and
calling a web service of the external target system to interface with the external target system to execute the task.
2. The non-transitory computer-readable medium of claim 1 , the tracking further comprising:
defining a plurality of documentation and accounting rules that are associated supply chain financial orchestration flows;
receiving a supply chain event involving a specific movement of the item from an external source system;
retrieving source document information associated with a source document referenced by the supply chain event;
retrieving the supply chain financial orchestration flow assigned to the source document;
selecting a documentation and accounting rule from the plurality of documentation and accounting rules;
selecting a task defined for the selected documentation and accounting rule that is associated with the supply chain financial orchestration flow; and
initiating execution of the task, where the task is executed at an external target system;
invoking a web service of the external source system;
retrieving supply chain event information associated with the supply chain event from the external source system using the invoked web service;
validating the retrieved supply chain event information of the supply chain event; and
storing the supply chain event in an external source system format.
3. The non-transitory computer-readable medium of claim 2 , the tracking further comprising:
transforming the source document information into an internal format.
4. The non-transitory computer-readable medium of claim 1 , the tracking further comprising:
calculating a revenue amount and a cost of goods sold (“COGS”) amount of the item based on the one or more trade accounting events;
storing the revenue amount and the COGS amount of the item as revenue data and COGS data;
calculating a gross margin amount and a gross margin percentage based on the revenue data and the COGS data; and
displaying the gross margin amount and the gross margin percentage within a user interface.
5. The non-transitory computer-readable medium of claim 2 , the tracking further comprising:
defining a transfer pricing rule that is associated with the supply chain financial orchestration flow, wherein the transfer pricing rule defines a rule to calculate a transfer price;
defining an agreement that is associated with the supply chain financial orchestration flow, wherein the documentation and accounting rule and the transfer pricing rule are defined for the agreement; and
defining the supply chain financial orchestration flow, wherein the supply chain financial orchestration flow comprises a business process type, a financial route, a primary route, and a supplier ownership change event.
6. The non-transitory computer-readable medium of claim 1 , wherein the accounting attributes comprises at least one of: a pricing attribute that defines a transfer price; an accounting template attribute that defines an accounting template comprising one or more documentation and accounting rules and one or more transfer pricing rules; or a profit tracking attribute that defines whether to track a profit for the supply chain financial orchestration flow.
7. The non-transitory computer-readable medium of claim 2 , wherein the initiating the execution of the task further comprises:
invoking the task layer service based on a task type of the task;
generating the task layer service payload for the task layer service;
selecting the external target system based on the task type of the task; and
interfacing with the external target system to execute the task.
8. The non-transitory computer-readable medium of claim 7 , wherein the initiating the execution of the task further comprises:
calling a transfer price service to calculate a transfer price for the task; and
retrieving the transfer price.
9. The non-transitory computer-readable medium of claim 1 , the transforming the task layer service payload comprising:
retrieving an extensible stylesheet language transformation (XSLT) from a setup table stored within the connector service;
using the XSLT to transforming the task layer service payload from a first extensible markup language (XML) format to a second XML format that is different from the first XML format.
10. The non-transitory computer-readable medium of claim 8 , wherein the initiating the execution of the task further comprises:
updating a status of the task after the task is executed.
11. The non-transitory computer-readable medium of claim 2 , the tracking further comprising:
defining a transfer pricing rule that is associated with the supply chain financial orchestration flow, wherein the transfer pricing rule defines a rule to calculate a transfer price;
generating a series of financial movement of goods resulting in an equitable distribution of a product margin between a first and a second tax jurisdiction;
defining an agreement that is associated with the supply chain financial orchestration flow, wherein the documentation and accounting rule and the transfer pricing rule are defined for the agreement;
identifying the supply chain financial orchestration flow based on a qualifier, a source document type, a physical route, a plurality of parties involved in an internal trade, and a priority of the supply chain financial orchestration flow;
defining the qualifier that is associated with the supply chain financial orchestration flow, wherein the qualifier comprises an attribute that determines an applicability of the supply chain financial orchestration flow;
modifying a date associated with the supply chain financial orchestration flow wherein a transaction pertaining to a source document created before an effective date of the modification is associated with an original supply chain financial orchestration flow and a transaction pertaining to a source document created after the effective date of the modification is associated with a modified supply chain financial orchestration flow; and
monitoring an execution of the supply chain orchestration flow comprising:
displaying details of a monitored supply chain financial orchestration flow in a user interface, wherein the user interface includes a supply chain financial orchestration flow detail window and a supply chain financial orchestration task detail window;
displaying an exception raised during execution of a task associated with the supply chain financial orchestration flow in the supply chain financial orchestration flow detail window;
displaying a received supply chain event for a selected financial route in the supply chain financial orchestration flow details window;
displaying a task being orchestrated based on an agreement of a financial route referenced in the supply chain financial orchestration flow in the supply chain financial orchestration task detail window; and
displaying an exception message window that contains a message category and a message detail for the exception raised during execution of a supply chain financial orchestration flow, wherein the message category categorizes the exception if the exception is due to an application error, a setup error, or a submission error, wherein the application error arises whenever any component of a supply chain financial orchestration system is not available, wherein the setup error arises due to a functional issue, and wherein the submission error arises if an event is not raised on a user action due to a technical reason; and
recovering a failed supply chain financial orchestration flow by re-performing one or more supply chain financial orchestration tasks.
12. A computer-implemented method for tracking transactions of an item within an enterprise that comprises a plurality of entities, the transactions of the item comprising a supply chain financial orchestration flow for a supply chain financial orchestration system, the computer-implemented method comprising:
defining for the supply chain financial orchestration flow one or more ownership events, each ownership event comprising an ownership change of the item between first entities of the plurality of entities, wherein a completion of the transaction comprises an ownership path where ownership moves among the first entities;
defining for the supply chain financial orchestration flow one or more physical execution events, each physical execution event comprising a physical movement of the item between second entities of the plurality of entities, wherein the completion of the transaction comprises a physical movement path among the second entities;
wherein the ownership path is different than the physical movement path;
receiving a first event associated with the supply chain financial orchestration flow;
determining whether the first event indicates an ownership change between two of the plurality of entities;
when the first event indicates an ownership change, generating one or more corresponding trade events and corresponding accounting attributes and sending the trade events and accounting attributes to a cost accounting system that generates one or more corresponding trade accounting events;
receiving a physical execution event associated with the supply chain financial orchestration flow, wherein the physical execution event indicates a physical movement between two of the plurality of entities; and
sending the physical execution event to the cost accounting system that performs accounting based on the physical execution event;
the sending the trade events and the sending the physical execution event comprising:
listening for events generated by the transactions by an event mediator;
in response to the listening, for each new event that is of interest to the supply chain financial orchestration system, the event mediator calling a source document enrichment web service to enrich the new event;
creating a task layer service payload for the new event; and
transforming the task layer service payload into a format that is understandable by the cost accounting system;
wherein the accounting that is performed based on the trade events is independent of the accounting that is performed based on the physical execution event, wherein the transforming comprising:
selecting a connector service for an external target system based on a task type of the task;
transforming the task layer service payload into an external target system format; and
calling a web service of the external target system to interface with the external target system to execute the task.
13. The computer-implemented method of claim 12 , further comprising:
defining a plurality of documentation and accounting rules that are associated supply chain financial orchestration flows;
receiving a supply chain event involving a specific movement of the item from an external source system;
retrieving source document information associated with a source document referenced by the supply chain event;
retrieving the supply chain financial orchestration flow assigned to the source document;
selecting a documentation and accounting rule from the plurality of documentation and accounting rules;
selecting a task defined for the selected documentation and accounting rule that is associated with the supply chain financial orchestration flow; and
initiating execution of the task, where the task is executed at an external target system;
invoking a web service of the external source system;
retrieving supply chain event information associated with the supply chain event from the external source system using the invoked web service;
validating the retrieved supply chain event information of the supply chain event; and
storing the supply chain event in an external source system format.
14. The computer-implemented method of claim 13 , further comprising:
transforming the source document information into an internal format.
15. The computer-implemented method of claim 12 , further comprising:
calculating a revenue amount and a cost of goods sold (“COGS”) amount of the item based on the one or more trade accounting events;
storing the revenue amount and the COGS amount of the item as revenue data and COGS data;
calculating a gross margin amount and a gross margin percentage based on the revenue data and the COGS data; and
displaying the gross margin amount and the gross margin percentage within a user interface.
16. The computer-implemented method of claim 13 , further comprising:
defining a transfer pricing rule that is associated with the supply chain financial orchestration flow, wherein the transfer pricing rule defines a rule to calculate a transfer price;
defining an agreement that is associated with the supply chain financial orchestration flow, wherein the documentation and accounting rule and the transfer pricing rule are defined for the agreement; and
defining the supply chain financial orchestration flow, wherein the supply chain financial orchestration flow comprises a business process type, a financial route, a primary route, and a supplier ownership change event.
17. A supply chain financial orchestration system for tracking transactions of an item within an enterprise that comprises a plurality of entities, the transactions of the item comprising a supply chain financial orchestration flow, the system comprising:
one or more processors executing instructions to perform the tracking, the tracking comprising:
defining for the supply chain financial orchestration flow one or more ownership events, each ownership event comprising an ownership change of the item between first entities of the plurality of entities, wherein a completion of the transaction comprises an ownership path where ownership moves among the first entities;
defining for the supply chain financial orchestration flow one or more physical execution events, each physical execution event comprising a physical movement of the item between second entities of the plurality of entities, wherein the completion of the transaction comprises a physical movement path among the second entities;
wherein the ownership path is different than the physical movement path;
receiving a first event associated with the supply chain financial orchestration flow;
determining whether the first event indicates an ownership change between two of the plurality of entities;
when the first event indicates an ownership change, generating one or more corresponding trade events and corresponding accounting attributes and sending the trade events and accounting attributes to a cost accounting system that generates one or more corresponding trade accounting events;
receiving a physical execution event associated with the supply chain financial orchestration flow, wherein the physical execution event indicates a physical movement between two of the plurality of entities; and
sending the physical execution event to the cost accounting system that performs accounting based on the physical execution event;
the sending the trade events and the sending the physical execution event comprising:
listening for events generated by the transactions by an event mediator;
in response to the listening, for each new event that is of interest to the supply chain financial orchestration system, the event mediator calling a source document enrichment web service to enrich the new event;
creating a task layer service payload by a task layer service for the new event; and
transforming the task layer service payload into a format that is understandable by the cost accounting system;
wherein the accounting that is performed based on the trade events is independent of the accounting that is performed based on the physical execution event, wherein the transforming comprising:
selecting a connector service for an external target system based on a task type of the task;
transforming the task layer service payload into an external target system format; and
calling a web service of the external target system to interface with the external target system to execute the task.
18. The system of claim 17 , the tracking further comprising:
defining a plurality of documentation and accounting rules that are associated supply chain financial orchestration flows;
receiving a supply chain event involving a specific movement of the item from an external source system;
retrieving source document information associated with a source document referenced by the supply chain event;
retrieving the supply chain financial orchestration flow assigned to the source document;
selecting a documentation and accounting rule from the plurality of documentation and accounting rules;
selecting a task defined for the selected documentation and accounting rule that is associated with the supply chain financial orchestration flow; and
initiating execution of the task, where the task is executed at an external target system;
invoking a web service of the external source system;
retrieving supply chain event information associated with the supply chain event from the external source system using the invoked web service;
validating the retrieved supply chain event information of the supply chain event; and
storing the supply chain event in an external source system format.
19. The system of claim 17 , the tracking further comprising:
calculating a revenue amount and a cost of goods sold (“COGS”) amount of the item based on the one or more trade accounting events;
storing the revenue amount and the COGS amount of the item as revenue data and COGS data;
calculating a gross margin amount and a gross margin percentage based on the revenue data and the COGS data; and
displaying the gross margin amount and the gross margin percentage within a user interface.
20. The system of claim 18 , further comprising:
a transfer price definition module configured to define a transfer pricing rule that is associated with the supply chain financial orchestration flow, wherein the transfer pricing rule defines a rule to calculate a transfer price;
an agreement definition module configured to define an agreement that is associated with the supply chain financial orchestration flow, wherein the documentation and accounting rule and the transfer pricing rule are defined for the agreement; and
a supply chain financial orchestration flow definition module configured to define the supply chain financial orchestration flow, wherein the supply chain financial orchestration flow comprises a business process type, a financial route, a primary route, and a supplier ownership change event.