Duplicate Value Checking in F4201<

Formula - Duplicate Value Checking in F4201

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

The key fields are:
  • 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:

EXTOL EDI Integrator Formula Duplicate value checking F4201



By: on
EXTOL Business Partner Logo

More EXTOL Examples

We have over 300+ examples of how EXTOL can be customized to meet your organization's needs

Each of our exmaples are free to review and use.