In the example below we will use an EXTOL formula, in a map, will review F4201 to determine if the inbound EDI PO is a duplicate.
Note: We also check for duplicate records in F47011.
In addition to using an EXTOL Formula we will use an EXTOL EFL (External File Lookup) with a customized logical file of F4201.
DDS source:Logical File: F4201_3
Formula Set-upV:= C || D,
if a > b then [ADDMSGTXT MSG('Duplicate PO# in F4201. Purchase Order #
:&E DOCO:&F') TOMSGQ(&V)]
By: Sean Hoppe on