SeanHoppe.com > CLEO Tips > Cleo EDI Integrator > Sample Subtraction Formula in EXTOL EDI Integrator

Sample Subtraction Formula in EXTOL EDI Integrator

27th June 2014

IN EXTOL EDI Integrator users have the ability to create formulas to perform various data logic and operations. Here are details on what specific functions EXTOL Formulas can be used for in EEI.

In the example below, we are going to create a simple subtraction formula named: SMPL_SUB. From the Mapping Menu we will take option #63 (Work with Formulas). Once here we will choose function [F9] to create a new formula.

image

Below is the new formula we created. Once we add the parameters we will fill in the Description.

  • a-b

image

Once the formula is created, we will navigate to the element mappings of an outbound 810 (invoice) map. Here is the TDS segment we need to subtract the discount amount from the invoice gross total. The resultant will be placed in TDS03 element.

To apply the

image

image

For more information on EXTOL EDI Integrator Tips and Hints


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