How to identify customer orders that have recent related activity?

justin

We have a requirement to identify customer orders that have changes associated with them, or changes/created documents in their flow, in order to identify any orders with any recent activity. 

For example: if order was invoiced -> we want to send that order number to an external system.  If an order was partially shipped -> we want to send that order number to an external system.  

I'm wondering if the best way to design something like this is through queries against the DataLake, or if a flow should be created using the M3 EventHub, or if there is some other tool that I'm not even aware of yet .  New to the system and would be appreciative of any advice.

Thank you!

unknown

Hi,

Maybe It's based on the requirement.

I. You can use BOD XML and process the same in external applications. M3 has a standard SalesOrder BOD.

All of the standard MEC functionality is already available so you don't have to create any custom BOD. Just check if you have all the information you need is available else you might have to do some modifications and go for Custom BOD.

1. Activate the SalesOrder BOD rule in Event Analytics.
2. Enable Company Division for SyncSalesOrder BOD in BOD processor admin and reload.
3. Activate the agreement in the IEC agreement section.
4. Receive the BOD in the M3 connection point in ION.
5. Build a Dataflow to send it to an external application.
a. Can send the XML BOD file to a file location.
b. Can send it to any web service using IONAPI gateway.

II. In Case if you have to update a database, there is an option you can create a Database connection point, where you can send your XML BOD to the database stored procedure and insert it into a table.

III. I don't know if there is an option to get JSON OOHEAD/OOLINE file M3 EventHub connection point(the one used by Data lake) and update the external application. Someone can advise on this.