SeanHoppe.com > CLEO Tips > CLEO JDE Tips > 4 EXTOL/JDE - Duplicate value checking in F47011 in EDI Integrator

EXTOL/JDE - Duplicate value checking in F47011 in EDI Integrator

7th November 2013

At times we need to use EXTOL functionality to help apply business logic in the translator. In the example below we will use an EXTOL formula and a logical file, over F47011, to determine if an inbound PO is a duplicate order.

V:= C || D,
if a > b then [ADDMSGTXT MSG(‘Duplicate PO# in F47011. Purchase Order #
:&E DOCO:&F’) TOMSGQ(&V)]
ELSE
ENDIF

Click here to see more information on the formula above





Copyright 2013 @ www.seanhoppe.com


By: on
load('http://www.seanhoppe.com/EXTOL-Blog-Feed2/'); $feed2 = array(); foreach ($rss2->getElementsByTagName('item') as $node2) { $item2 = array ( 'title' => $node2->getElementsByTagName('title')->item(0)->nodeValue, 'desc' => $node2->getElementsByTagName('description')->item(0)->nodeValue, 'link' => $node2->getElementsByTagName('link')->item(0)->nodeValue, 'date' => $node2->getElementsByTagName('pubDate')->item(0)->nodeValue, ); array_push($feed2, $item2); } $limit2 = 5; $rss3 = new DOMDocument(); $rss3->load('http://www.ebithree.com/EBIThree-RSS/'); $feed3 = array(); foreach ($rss3->getElementsByTagName('item') as $node3) { $item3 = array ( 'title' => $node3->getElementsByTagName('title')->item(0)->nodeValue, 'link' => $node3->getElementsByTagName('link')->item(0)->nodeValue, ); array_push($feed3, $item3); } $limit3 = 5; $rss4 = new DOMDocument(); //$rss4->load('http://www.ebithree.com/EBIThree-RSS/'); $rss4->load('http://www.ebiworld.com/EBI-Feed/'); $feed4 = array(); foreach ($rss4->getElementsByTagName('item') as $node4) { $item4 = array ( 'title' => $node4->getElementsByTagName('title')->item(0)->nodeValue, 'link' => $node4->getElementsByTagName('link')->item(0)->nodeValue, ); array_push($feed4, $item4); } $limit4 = 5; echo ' '; ?>