SeanHoppe.com > CLEO Tips > CLEO JDE Tips > 4 How to Convert UOM for Inbound Orders

How to Convert UOM for Inbound Orders

31st March 2015

QUESTION:

Is there a way to have E1 change the transaction UOM that is received by the customer via EDI. Currently the customer sends a transaction UOM of ‘EA’ and we currently ship the product by 'BX’ and we expect that the R47011 use the UOM conversion for the item to create the sales order by Boxes and not Each, is this possible within E1 when using EDI?


ANSWERS:

FROM JDE Knowldgebase

E1 currently does not offer the ability to convert UOM by customer nor by data sent from the customer in an EDI transaction. Some translators may have the ability to create a conversion table where the user can set up a conversion by customer, so when customer A sends the value EA in the Item segment of the mapping, then the translator will convert EA to BX and map to the F47012. This is outside the scope of E1 but most translators can handle this functionality. If you aren’t using a translator then you may need to create a program to update the F47012 with the correct UOM that should be used by the R47011 in order to create the Sales order with the correct transaction UOM.

Possible workaround is to leave the transaction UOM in the F47012 blank and allow the primary UOM to default in from the item master. This will work only if the primary UOM of the item is in BX not in EA. Otherwise this workaround will only provide the same information the customer has provided.

EXTOL Solution:

The EXTOL Data Integrator provides the tools that shows users how to implement and utilize the JDE item master conversion table F41002.

To see more about EXTOL Data Integrator, Click Here >

Sean Hoppe Consulting Group Solution:

We can show users how to capture ordering UOM and retain it for returning it in outbound documents, ie outbound x12 856/855/810 transactions. In addition to retaining the ordering UOM we will also walk users thru the process of converting the ordering UOM to the sales UOM

For more information on JDE Hacks and Tips:


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