Originally posted by: SystemAdmin

We are currently using Commerce Manager 6.5.2 and we are looking to put into place a better tool for reconciliation. We would like to trigger an EDI text message back to our customers if they have not acknowledged our documents within 24 hours. If they still have not acknowledged their documents within 48 hours, we would like to have an internal e-mail generated, so we can contact them via phone.

I was curious if anyone else has put something like this into place? If so, was it complicated to integrate with Commerce Manager or did it have to be done outside the software?

Thanks!
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

Look at the Commerce Manager tables, X12FGStatus & X12TSStatus. You can create a map which examines these tables and generates a suitable Text message if the an entry has not been acknowledged and the ack window is expired.
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

We are no longer using that version, but in CM 7, there is a place where there is a place to generate a report off of acknowledgments not recieved within X number of hours.

To answer your question about if it is challenging to integrate it, is is very easy, all you have to do is create a query that looks at the ts_ack_statuscd in the x12tsstatus table where direction is 'i'
If you need some help, feel free to email me @ [url]eric@stottcreations.com[/url]

Eric
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender