‘Setting up Infor 2.0 to meet the changing needs of Government’

1. ‘Setting up Infor 2.0 to meet the changing needs of Government’ Presented By: Mark Chin, Manager Financial Systems Colin Huggett, Technical Support Consultant DEPARTMENT OF CORPORATE AND INFORMATION SERVICES

5. Croc Photo

6. Never Smile At One

7. Background to NT Government Accounting System (GAS) History, Set up, Applications, Mandate, Infrastructure Department of Corporate and Information Services (DCIS) History, Drivers Infor FM 2.0 Set Up Support Technical Environment Common Services - Enterprise Structure, Agency Parameters Common Vendor / Customer File Standard Processing – GAS Wizards Chart of Accounts Data Warehouse – Reporting Agent for Change Future Plans Invoice Portal, Purchase Request System Questions ? Session Outline

8. Based on Masterpiece / FM 2.0 since the mid 1980’s. Used by all Government Agencies throughout the NT. Centralised Support provided by Financial Systems Unit. GAS Modules include PO, AP, GL, AR, FA, JC. Use of AP and GL is Mandated. GAS runs on Centralised IT infrastructure. Background to GAS

9. DCIS was established in 1998/99 to provide Shared Services to the NT Public Service. Drivers were: Reduction in back office expenses Agencies competing for the same resources NTPS already had centralised IT infrastructure and HR and Finance systems Additional $$ for Nurses, Teachers and Police Background to Shared Services

10. Support - Provided Centrally by Financial Systems Unit Support GAS, PO, AP, AR, FA, GL, JC GAS Wizards for Streamlined Data Entry Reporting Data Repositories Currently 15 staff and 4 contractors Other systems - OBIPS, ECMS, TRIPS, EIMS Key interfaces - NAB, PIPS, Treasury Infor FM 2.0 Set Up

11. Technical Environment IBM Z Series mainframe – Z/OS operating system CA Datacom release 11 (release 12 in test environment) Single AP (310) & Common Services (390) data bases 5 x GL, AR, PO, JC, FA data bases – multiple org’s per data base, load sharing, optimise back-ups, etc… Multiple CICS regions – web interface, wizards, green screens, data query Midrange Servers – web server, data base host, application server Infor FM 2.0 Set Up

12. Infor FM 2.0 Set Up • Automated Batch Schedule • Control/M Automated Batch Schedule • Cobol programs automatically create all the necessary NGT records and other batch parameters, including the AP payment run, at the start of the batch schedule • No (or very little) manual scheduling of overnight masterpiece batch processing • Batch schedule kicks off at 8pm each night (mon-fri) • 100’s of batch jobs running in multiple streams (per data base) • Normal end time is approx 11:30 pm • Triggers nightly data warehouse extracts

13. AP Run Parms

14. AP Run Parms

15. Common Services – Enterprise Structure, Agency Parameters 1 Enterprise Structure 3 Tiers - NTGOVT, Dummy Level, Agency Business Orgs Vendor and Customer Clusters held at NTGOVT Level Application Parameters controlled centrally Standard Tax Codes, Bank Codes and Agency Numbers Mastersecurity controlled centrally Infor FM 2.0 Set Up

16. Common Vendor / Customer File AP Vendors – Payments made at Agency level AR Customers – Invoices issued at Agency level Infor FM 2.0 Set Up

17. Standard Processing – GAS Wizards - Overview Customised user front end for Masterpiece application Windows Forms applications (Windows standard use) Built on the Microsoft .net framework (common programming language) Use Infor’s Masterpiece SDK (plug in’s, sample applications) Deployed on a web server (“no touch”/auto deployment) Do not directly process transactions (use standard Masterpiece programs) Allow integration with non-Masterpiece data (i.e. GAS data warehouse) Infor FM 2.0 Set Up

18. Standard Processing – GAS Wizards - Applications Accounts Payable Vendor Enquiry Voucher Enquiry AP/PO Payment Processing Vendor Creation and Maintenance Purchase Order PO Maintenance Accounts Receivable Invoice Requisitioning Receipts Processing System Fixed Assets Maintenance, Costing & Retirement LTF and APeS Infor FM 2.0 Set Up

19. Standard Processing – GAS Wizards - Benefits User friendly and easy to learn for new users Single entry screen replaces multiple screens Integrated user guide and help system Additional functionality such as: - Tax Compliancy check for invoices - Calculation of payment due date to meet 30 day NTG Payment Policy - Ability to search for Vendors by ABN, Full Name or BSB and Bank Account No - Ability to attach electronic supporting documentation - Use of Workflow and system generated reminder emails Infor FM 2.0 Set Up

20. Chart of Accounts Central Ledger Maintenance Unit Use of APT’s and Chartgen Mandated use of Agency Number and Standard Classification Infor FM 2.0 Set Up

21. Data Warehouse - Reporting Central Corporate Reporting Unit Use of Crystal Reporting and Business Objects Enterprise Mandated use of Treasury Source/Destination Codes Reporting to Treasury provided centrally at transaction level Data Warehouse

22. Data Warehouse Infrastructure IBM Mainframe Windows Server SSA FM 2.0 MSSQL 2008 SQL Server DTS Datacom AD 11 BO Enterprise xi ENF Crystal Reports Datacom Server

23. Populating the Data Warehouse END USER REPORTING TOOLS OLTP STAGING AREA DATA MARTS SQL Server SQL Server Mainframe MSSQL/DTS DECISION BASE VOUCHER DETAILS THS GL DATA SDC GL DATA PAYMENT STATS BAS CRYSTAL ETL Tool ETL Tool AR FA PO GL PO FA GL AR AP AP AGENCY INTERFACES THS CS CS XL OTHERS

24. Our Set Up has assisted with the Implementation of: Y2K, GST, Accrual Accounting Procurement Policy changes Purchase methods (CCC) ICT Infrastructure changes Range of Reporting to Government Agent for Change

25. Machinery of Government Changes made Easier: Central Ledger creation – copied existing ledgers No new Vendors / Customers for new Orgs Efficient replicating of system parameters for new Orgs Business system interfaces centrally coordinated Central Mastersecurity updates Central creation of new reports Agent for Change

26. Invoice Portal Vendor tracking of invoices submitted Template for entry/submission of invoices by Vendors Vendor self service for Vendor File changes Future Plans

27. Purchase Request System Online Requisition system for Tier 1 purchases Workflow for Approval Payment by Credit Card or Interface to GAS PO Future Plans

28. ? Questions