Just as we can check for duplicate records in F4201, we can check for duplicate records in F47011 before EXTOL translates inbound data.
In addition to using an EXTOL Formula we will use an EXTOL EFL (External File Lookup) with a customized logical file of F47011.
DDS source:Logical File: F47011_3
Formula Set-upV:= C || D,
if a > b then [ADDMSGTXT MSG('Duplicate PO# in F47011. Purchase Order #
:&E DOCO:&F') TOMSGQ(&V)]
By: Sean Hoppe on