SeanHoppe.com > CLEO Tips > Cleo EDI Integrator EXTOL EDI Integrator - Setting up Duplicate Value Checking (Multiple Values)
EXTOL EDI Integrator - Setting up Duplicate Value Checking (Multiple Values)
22nd June 2012
In a earlier post we discussed how we can check for duplicate values in the EXTOL EDI map. In this post we will discuss how to set-up our EXTOL map to check for multiple, duplicate values.
A perfect scenario would be for inbound purchase orders. A purchase order contains a PO #. However the 850 also includes the BEG01 which describes the purchase order. We might receive two purchase orders with the same PO # but they might not be duplicates the 1st PO is the original PO and the 2nd PO might be the cancellation.
Unless we use EXTOL multiple duplicate checking, we would consider the 2nd PO a duplicate.
In our EXTOL 850 map, we will use the special code ‘DM’, instead of using the special code 'DA’. In the 850 we will apply 'DM’ to the BEG01 and BEG03 elements. In both instances, we will use the same 'Dup name’ value.
Copyright 2012 @ www.seanhoppe.com
By: Sean Hoppe on
