SeanHoppe.com > CLEO Tips > CLEO JDE Tips > 4 Update JDE Field:EDSP After Document Processed in EBI

Update JDE Field:EDSP After Document Processed in EBI

20th June 2014

Scenario:

  • Source: F47 Tables
  • Target: EDI x12 ASN (856)

In JDEdwards/EBI rulesets where we are sending outbound EDI data from the F47 tables, we need to perform a couple steps to have EXTOL update the respective header record. In the example below, we will update F47036.EDSP to be ‘Y’ once a successful outbound ASN (856) is created.

STEP 1: Update outbound ruleset to create a new record. In this case the F47036 record is selected in the middle tree of ruleset. In the example below we map F47046.EDOC, F47046.EKCO, F47046.DCTO from the source schema field -> middle tree schema field.

image

STEP 2: We will find the respective EXTOL Binding for the outbound transaction. Once the EXTOL Binding is open we will <RIGHT CLICK> on the header record; in this case it is F47036. We will select Column Update Actions.

In Column Update Actions we will select the fields that we identified in the ruleset to map data to in the update action.image

STEP 3: In the Outbound Collaboration Business Process Script, we will add an UPDATE SQL Action that will correspond to the EXTOL Binding (Above). In the SQL Update Action Task we will map a Storage Node that will reference the the Update Storage Node in the Single Transformation Task.

More information on JDE Best Practices and How-To’s


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 ' '; ?>