SeanHoppe.com Cleo Code Samples Duplicate Value Checking in F4201
Cleo Formula - Duplicate Value Checking in F4201
In the Cleo EDI Integrator 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 Cleo Formula we will use an Cleo/EXTOL EFL (External File Lookup) with a customized logical file of F4201.
DDS source:Logical File: F4201_3
- SHKCOO
- SHSHAN
- SHVR01
Formula Set-up
V:= C || D,if a > b then [ADDMSGTXT MSG('Duplicate PO# in F4201. Purchase Order #
:&E DOCO:&F') TOMSGQ(&V)]
ELSE
ENDIF
Parameters:
By: Sean Hoppe on
