2262021 QAD Output Control and the Need For

2/26/2021 QAD Output Control and the Need For Standardized Form Development By David Langschied, Inergy Mark Harrington, Minisoft breakthrough solutions for the automotive world

2/26/2021 ABOUT INERGY AUTOMOTIVE SYSTEMS q. Founded in 2000 as a joint venture between Solvay & Plastic Omnium. q 2010 Plastic Omnium purchased the Solvay stake. q. Inergy operates 20 facilities on 6 continents. q. Computing environment: QAD version e. B 2. 1 SP 4 Running RHEL 5. 4 2

2/26/2021 Background Inergy had been using pdf_inc to create its shipper forms. This process worked well with the standard shipping format. KIA Motors required an additional Delivery Confirmation Receipt or DCR page with significant amounts of extra data. This data also included a 2 D PDF 417 barcode. üExisting solution would work but required much time & effort. üKIA form compliance was required in a couple of months. üInergy decided to search for a third party forms development tool. 3

2/26/2021 Background Challenge – Find a forms generation tool designed for QAD to handle the diverse forms requirements of Inergy and its customers. Forms Tool Evaluation Criteria Must operate with all versions of QAD Ease of use form design and modification Support 1 D and 2 D barcodes Ability to use standard QAD print output as input Progress database support Conditional logic within a form Support for PDF emailing and Fax Archiving of forms 4

2/26/2021 Selected e. FORMz There were many form generation solutions available in a wide price and capability range. After an extensive evaluation Inergy selected Minisoft’s e. FORMz. The product was easy to use, priced competitively and operated in both Linux and Windows environments. e. FORMz allowed Inergy to meet the requirements of the KIA project within the project’s timeline. 5

2/26/2021 Selected e. FORMz 6

2/26/2021 Kia Motors Project Description – Generate Kia Motors Delivery Confirmation Receipt (DCR) and Shipper Report (SID) from print output created from Inergy’s QAD system. Also add a PDF 417 barcode to the DCR form. Use e. FORMz’s Text to XML preprocessor to parse the file, converting it to XML input. 7

2/26/2021 Inergy QAD Output The original spool file output from QAD containing both DCR and Shipper information. 8

2/26/2021 Inergy Kia Motors Delivery Confirmation Form Delivery Confirmation Report (DCR) created by e. FORMz with the first project. 9

2/26/2021 Inergy Kia Motors Shipping Report The Shipper report created with the second e. FORMz project. 10

2/26/2021 Hyundai America Project Description – Like KIA, Hyundai America had a requirement for a specialized Shipper Report (SID). Prior to e. FORMz, the creation of this form required many manual steps. üHyundai America SID form required a PDF 417 barcode. üThe number of pallets needed to be totaled with summaries. üProduct descriptions for every item listed. 11

2/26/2021 Hyundai America SID form with pallet count, summaries and product descriptions. 12

2/26/2021 QUESTIONS 13

2/26/2021 e. FORMz Feature List ØWritten in JAVA supports ALL QAD versions – HP/UX, AIX, Linux or Windows. ØSupport for PCL, Postscript, XML printers. ØRicoh, Toshiba, Lexmark, HP, Xerox, Canon, Kyocera, Zebra, Datamax. ØProduce forms directly from standard QAD print output. ØPopulate forms directly from corporate databases, including Progress, Oracle and SQL. ØRead and write capability. ØText to XML Preprocessor – converts QAD print output to XML file format. 14

2/26/2021 e. FORMz Feature List ØNo complex programming or need to learn a proprietary design tool to create a form. ØEasy forms design with publishing tools like Microsoft Word, Adobe, Open Office or MS Publisher. ØCreate “intelligent” forms with built-in conditional logic. ØQAD forms library available to shorten implementation times. ØPacking lists, shipping labels, invoices, purchase order acknowledgements, checks, bills of lading, customs documentation. Øe. FORMz Print Director for advanced print management. ØSelective printing, form reprints, and print scheduling. 15

2/26/2021 e. FORMz Feature List ØFax or e. MAIL in PDF or HTML file formats directly from QAD. ØSupport for 1 D, 2 D, QR barcodes ØMaxicode, PDF 417, Data. Matrix, USPS Intelligent Mail ØMICR for checks, secure signatures for AP and payroll checks. ØDigital File Cabinet - Archiving, Retrieval, Indexing ØCreate revisable PDF’s for “Forms Fill-In” ØMulti-Byte Character Support ØChinese, Japanese, Korean, Eastern European, Arabic 16