SeanHoppe.com > CLEO Tips > CLEO JDE Tips > 4 Using JD Edwards: F0116 (Who's who) for storing ship-to location

Using JD Edwards: F0116 (Who's who) for storing ship-to location

15th June 2012

When an inbound purchase order is received, we might need to take the N104 value and resolve to a JDE address book number. There are multiple ways to look up the address book #, in EXTOL.

One such way is to chain-out to the F0101 (address book) and look at the ABALKY field. This can be a headache to maintain when we have multiple customers with the same address location value. Another option is to maintain a table in EXTOL. This can be easy to set-up but back-breaking to maintain. Non-IT users would not have access to the EXTOL tools to perform updates.

Am optimal EXTOL solution that might give us the most flexibility and allow non-IT users to maintain a customer location list, is utilizing the JDE Who’s Who table (F0116).

This table is keyed with the address book value (WWAN8) and can be maintained by customer service reps.



Copyright 2012 @ 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 ' '; ?>