160 likes | 342 Views
Smart Solutions for JD Edwards EnterpriseOne Welcome. “We Make JDE Configurable”. • Application Builder Module (QIS ABM ™ ) - Spreadsheets for JD Edwards • Flexible Calculation Module (QIS FCM ™ ). Extended Modules for JDE. Application Builder Module ™. Adds Spreadsheet Power & More
E N D
Smart Solutionsfor JD Edwards EnterpriseOneWelcome “We Make JDE Configurable”
• Application Builder Module (QIS ABM™)- Spreadsheets for JD Edwards• Flexible Calculation Module (QIS FCM™) ExtendedModules for JDE
Application Builder Module™ Adds Spreadsheet Power & More (Completely Inside JDE)
Application Builder for JD Edwards Create Unlimited Grids and Versions Perform Calculations and Formulas with Access to All JDE Modules & Data (More Accurate Data) REAL TIME Complete Integration with QI Systems’ FCM An Application Builder with Limited or No Involvement from IT Eliminates Flat File Imports or Integration Points to Outside Processes Collection of Standard JDE Toolset Functions, Grouped Together - Creates a User Definable and Flexible User Application Completely Inside JDE: Security Enabled, Same Look and Feel, Built with the JDE Toolset
Application Builder Module™ • Use it to store data that has no home anywhere else in JDE • Import all your old Excel spreadsheets and keep them secure and backed up in JDE • Import data from JDE Databrowser • Complete JDE Security over your critical spreadsheets and sensitive data • Data is now accessible by other JDE modules or JDE Reporting • All in one central location, safe inside JDE
What is the Flexible Calculation Module™? • FCM is a Comprehensive and Paradigm Shifting Module that Enables Power Users to Create, Manage and Execute Basic to Complex Scripted Formulas
Flexible Calculation Module • FCM Functions are Similar to Spreadsheet Macros and SQL Scripts • Formulas are created at the User Interface Level • FCM Formulas are Available to ANY Module in EnterpriseOne
Flexible Calculation Module Any Source of Data Data Flows Into FCM FCM FCM Calculates & Returns Results
Flexible Calculation Module Benefits: • User/Developer Controls How a Calculation is Processed (on-the-fly adjustments) • Provides an Existing Application Expanded Calculation Capabilities • Eliminates Hard Coded Calculations • Drastic Reduction of IT/Development Resources • Makes JDE Configurable • Unlimited JDE Calculation Possibilities • Small Footprint (Stand-a-lone Module) • Same Look and Feel as Existing JDE Screens • Completely Inside JDE • Developed with JDE Toolset • Upgrade Safe
Flexible Calculation Module • Unique Scripting Code Variables Pass Data Between Apps & FCM Functions • IF/THEN/ELSELogic Processing • Reference Tables and Field Alias in Formula (F0101.AC01) • Reference Formulas within Formulas • Reference a UBE (Batch Program) in Formulas and Use Results in Calculations • Group (Stack) Multiple Formulas Together • Reference Specific SPREADSHEET.VERSION.COLROW from QIS’ Spreadsheets for JDE
SMART Development Strategy • Oracle Validated Integration (OVI) - 9.0 & 9.1 • JD Edwards Development Standards • System Code Q60 • Developed withJD Edwards Toolset • Implementation Project Promotion • - OMW Similar to Adding an ESU
Q&A Mike Dolder Vice President mike.dolder@qisystems.net (714)337-9643 Donnie Law President donnie.law@qisystems.net (870)335-5939