SeanHoppe.com > CLEO Tips > CLEO JDE Tips > 4 JDE/EXTOL Business Integrator - Summerizing detail lines

JDE/EXTOL Business Integrator - Summerizing detail lines

27th February 2014

EXTOL/JDE users that are looking to send outbound 855 and 810s with consolidated lines will have issues if JDE remits multiple detail lines of the same item. This is a common occurrence in the food industry when there are lots involved.

BACKGROUND

Bug 12477797: R42565 DOESNT SUMMARIZE FOR EDI - SAR: 4787218 in December 2000 and was closed at status 84 -not feasible to fix and enhancement Bug 10963108 : ITEM SUMMARIZATION WITH EDI IN - SAR: 8523391 and enhancement bug: 10761599: ITEM SUMMARIZE IN OUTBOUND 810 - SAR: 5478329

When Item Summarize Processing Option is activated, the items are summarized in the Invoice paper copy only. The EDI Invoice Detail (Sales) - Outbound table (F47047) is designed to reflect a mirror image of Sales Order Detail (F4211) so it can be compared and audited against the F4211 records later

JDE Suggested Workaround:

If the customer is using a translator, the issue can be fixed within the Translator to extract the information and map the same line number if the line numbers are the same. Or modify the system (JDE) to update the F47047 tables per the summary of the item. Either way at this time Oracle does not have the functionality requested at this time.

EXTOL/JDE Workaround

Step ONE:

Outbound 810 Ruleset - IN the ruleset below:

  • On line 124 we divide F47047.LNID by 1000 to get the Remainder. We place the resultant into varSZLNID-Remainder_int
  • We found that if there are multiple lines of a single item then the first line will be a whole number while the other detail lines will contain a decimal.
  • For more information on EXTOL Remainder rule

image

Outbound EXTOL/JDE 810 Ruleset Full Image

STEP TWO:

Rule #125 below:

  • With the result on line 124, we use a composite rule on line 125, to determine if there is a remainder. If there is NOT a remainder then we go into Composite Rule 125 to create the IT1 group/segment.

image

Outbound EXTOL/JDE 810 Check Remainder Full Image

STEP THREE:

image

image


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