In the example below we will use an EXTOL formula, in a map, to use EXTOL's Command EXENOTE.
The formula will send an email, via EXTOL's CMD: EXENOTE when an inbound 850 (purchase order) is received and it is not an original order. We look at element BEG02 to determine if the order is original.
Formula Set-up:if x!= y then [EXENOTE TOADR(&A) FROMADR([email protected]) FROMNAME(
EXTOL) SUBJECT('&B EDI ORDER RECEIVED -- NOT Original Order') MESSAGE(
'Order received from: &B Connection Log #: &F PO#: &C. Order was NOT
an original order')]
Formula Parameters:Parm SD Data source/dest
@ - FS OHFAP (random field - acts as trigger)
A - C0 ADD2 (constant - email address)
B - TP Trading partner code (Alpha 6)
C - D0 Purchase Order Number (BEG03 -- PO Number)
F - S1 Session (comm) log number S1 (Session Log number / Zoned 7)
X - D0 Transaction Set Purpose Code (BEG01 -- PO Type)
Y - C2 00 Constant (Alpha: length 2)
By: Sean Hoppe on