SeanHoppe.com > CLEO Tips > CLEO JDE Tips > 4 JD Edwards - Check to see if pricing exists for each item.

JD Edwards - Check to see if pricing exists for each item.

16th June 2012

When we receive an inbound purchase order and we we need to ensure pricing exists for each item based on the address book number, item, ordering UOM, PO date then we might need to perform several queries of the JDE files: F4104_14 -> F4101_2 -> F03012_3 -> F4094LC -> F4106LC.

The gist of the RPGLE program is to run each time with the short item number, ordering UOM, and PO date to determine pricing exists. We even look at the F4106 records to ensure the PO date falls between the effective date and expiration date.

If pricing does not exist, then we will force an error by populating ‘P0RTN’ and then using an EXTOL formula to populate the EXTOL Connection MSGQ with the error notification.

Here is the program to check for pricing. If you need assistance with implementing this logic in EXTOL Business Integrator, contact me.



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