Easy OnBoarding Enhanced Controls Set up Easy OnBoarding

Easy On-Boarding Enhanced Controls Set up

Easy On-Boarding Course Overview • • • Audit Trail Process Overview E-Signature Process Overview Enhanced Controls Set Up Process Flow Audit Trail Set Ups E-Signature Set Ups 2

Easy On-Boarding Benefits • Meet exacting compliance requirements • Support validation “QAD’s compliance capabilities are one of the biggest factors that swayed us to QAD has everything covered: CFR part 11, lot trace through the engineering change module and audit trails. In fact, the application can even do lot trace through work-in-process, which helped make our decision easier. Most other ERP systems do not have that ability” Cliff Oman, Chief Information Officer, Alpine Biomed

Easy On-Boarding Audit Trail Process Overview 4

Easy On-Boarding Main Components to QAD’s Auditing 5 Identifying who/what made the change 5 Integrated audit authentication and application context 5 Easy for Ch. UI, harder for. Net UI and Financials etc 5 Uses the new Progress Client Principal 5 Configuration 5 Provide easy to use interface to configure table level auditing 5 Reporting 5 Provide a reporting tool with export to XML 5

Easy On-Boarding App DB Audit Policy Tools Application Code Audit Core Service Policy Data Audit Data Application Data ABL Client Auditing in Open. Edge Archive Commands Archive DB Audit Report Tool Audit Data

Easy On-Boarding Configuration options • Volume of auditing data will grow over time - Depends on what tables are audited and how often they are changes • Options with where to store the auditing data - In the main source database - In a separate database - In a central database with multiple source databases 7

Easy On-Boarding In the main source database • Initially all auditing data is stored in the same database as the auditing is enabled • Has own storage areas (data & index) QAD 2011 EE • Archive out old data with proutil • Good for low volumes • Simple Audit Tables 8

Easy On-Boarding In a separate database • Separate database where data is archived out of the source db and loaded • E. g. Archive out data each night to load in reporting db QAD 2011 EE proutil –C auditarchive Audit db proutil –C auditload 9

Easy On-Boarding In a central database with multiple source databases • Multiple QAD 2011 EE being loaded in to central reporting db QAD 2011 EE Central Auditing db 10

Easy On-Boarding E-Signature Process Overview 11

Easy On-Boarding E-Signature • Electronic signature process for critical processes that rely on tight quality control - Subject are typically auditing product-related information – master files, product structures/formulas, routings/processes, quality, inventory, shop floor control. • Complete accountability as to the specific changes made • Support requirement of the United States Food and Drug Administration (FDA), in 21 CFR Part 11 • See Example of Inventory Detail change

Easy On-Boarding E-signature enabled functions • Enabled in QAD-provided default signature profiles • Each profile is associated with a specific category of data • Categories are defined by QAD and delivered with the electronic signature functionality. Adding new categories requires custom development.