Hello All,
I need your help to know what is a good and efficient way to complete the integration of Purchase Order processing in M3 using Database connection Point.
Development scenario: I am fetching data from a database using anySQLmodeler in database connection point to Process a Purchase Order in M3 using Process_In BOD and getting Acknowledgement BOD back from M3. The DB connection point is set to trigger once a day, Once the Data is fetched from the database the PO is processed in M3 through MEC and return back the Acknowledgement BOD whether the PO is processed or not. Another DB connection point is set to update the Database that the particular record is processed in M3 using stored procedure(one record in a database is considered as one PO data & I need to omit that particular record for the next trigger if that is processed on the previous day trigger).
My thoughts:
1.Using the Acknowledge BOD from M3 in dataflow and check if flag is enabled and send it to Database to update that the record is processed( using Stored procedure)?
or
2. Triggering a Sync BOD separately from M3 to send it to database to Update the record(Using stored Procedure)?(Event Analytics rule filtering: when the PO status is changed to 12 or 15).
if there is any other good & efficient way to complete this development, please suggest.
Any suggestions is appreciated.
Thanks