SeanHoppe.com › Code Samples › Call EXENOTE in Formula from EXTOL Map
Formula: Call EXENOTE in Formula from EXTOL Map
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(EXTOL@xxxxxx.com) 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')]
ELSE
ENDIF
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
