STATE OF CONNECTICUT CoreCT APPOAM User Group Winter

STATE OF CONNECTICUT Core-CT AP/PO/AM User Group Winter 2008

Agenda õ Welcome John Harnick õ EPM Barbara Jacius õ Training õ Steve Perkins CM John Winschel õ Inventory Steve Beaulieu õ e. Pro õ PO Amanda Starbala õ AP Cynthia Babbitt õ Assets Kathleen M. Anderson Dave Bonola õ Integration Presentation

Welcome • Maintenance Packs – Need volunteers for testing in March – Go live is scheduled for April 5 th weekend • Core-10 Coming Soon • Fiscal Year End • Catalog Management Changes

Customer Service í Users can call the Help. Desk @ 860 -622 -2300, ext 1 í For complex issues, send email to: Core. Support@po. state. ct. us

Agenda õ Welcome õ EPM õ Training õ John Harnick Barbara Jacius Steve Perkins CM John Winschel õ Inventory Steve Beaulieu õ e. Pro õ PO Amanda Starbala õ AP Cynthia Babbitt õ Assets Kathleen M. Anderson Dave Bonola õ Integration Presentation

EPM Enhancements Purchasing Projects/Costing Module Fields Added: T T T T ACTIVITY_ID ANALYSIS_TYPE BUSINESS_UNIT_PC PC_DISTRIB_STATUS RESOURCE_CATEGORY RESOURCE_SUB_CAT RESOURCE_TYPE PC_DISTRIB_STATUS

EPM Enhancements Purchasing Projects/Costing Fields Added to EPM Reporting Tables: T T T CT_PO_TRANS_TBL CT_RECEIVER_TRN CT_REQ_TRNS_TBL CT_VCNTRCT_DEF CT_VCNTRCT_MIL

EPM Enhancements Accounts Payable New EPM Table: T CT_VCHR_LN_WTHD T CT_CORE_FIN_AP_VENDOR_CREDIT T CT_CORE_FIN_AP_VCHR_DT_COMPARE T CT_CORE_FIN_AP_TELECOMM_EXPS T CT_CORE_FIN_AP_VCHR_CNT_USERID

EPM Enhancements Asset Management New EPM Table: LOCATION_TBL õ Join to EPM Asset Management tables by location õ Sample Fields õ õ õ Building Floor Sector Jurisdiction Address

EPM Job Aids Updated EPM Reporting Table Indexes & Join Criteria TRevised to include additional reporting tables. TAll accurate table joins identified. http: //www. core-ct. state. ct. us/epm/docs/rptng_tbl_ndxs_in_crtr. doc

EPM Job Aids Updated EPM Reporting Table Indexes & Join Criteria Acceptable Join Criteria

EPM Job Aids Updated EPM Reporting Table Indexes & Join Criteria Inaccurate Join Criteria Spreadsheet

EPM Job Aids Updated Reporting Table to Role Mapping T Updated to include all projects/costing module roles. http: //www. core-ct. state. ct. us/epm/

EPM Job Aids Updated Reporting Table to Role Mapping EPM REPORTING TABLE or SECURITY ACCESS NODE ROLENAME CT_VCHR_LN_WTHD CT ADJ VOUCHER PROCESSOR CT_VCHR_LN_WTHD CT AGY AP SYS TECH RESOURCE CT_VCHR_LN_WTHD CT AGY ONETIME VENDOR APPROVER CT_VCHR_LN_WTHD CT AGY ONETIME VENDOR PROCR CT_VCHR_LN_WTHD CT AGY VENDOR VIEWER CT_VCHR_LN_WTHD CT AP REPORT MAKER CT_VCHR_LN_WTHD CT AP REVIEWER CT_VCHR_LN_WTHD CT BUDGET CHECK PROCESSOR CT_VCHR_LN_WTHD CT CNTRL 1099 PROCESSOR CT_VCHR_LN_WTHD CT CNTRL AP CONFIGURATOR CT_VCHR_LN_WTHD CT CNTRL AP SYS TECH RESOURCE CT_VCHR_LN_WTHD CT CNTRL AP VIEWER

Questions?

Agenda õ Welcome õ EPM Barbara Jacius õ Training Steve Perkins õ CM John Winschel õ Inventory Steve Beaulieu John Harnick õ e. Pro õ PO Amanda Starbala õ AP Cynthia Babbitt õ Assets Kathleen M. Anderson Dave Bonola õ Integration Presentation

Core-CT Training – Manager Guides • Summarizes knowledge a supervisor or manager should have – – – Accounts Payable, Supply Chain, Inventory Asset Management Accounts Receivable / Billing Project Costing / Customer Contracts Help Desk, EPM General Ledger / Commitment Control

Core-CT Training – Manager Guides • Sections of the Guide – – Overview High level graphic view Bulleted information Links to more detailed information – Reports associated with the module – Other sections as needed

Agenda õ Welcome õ EPM õ Training õ CM õ Inventory John Harnick Barbara Jacius Steve Perkins John Winschel Steve Beaulieu õ e. Pro õ PO Amanda Starbala õ AP Cynthia Babbitt õ Assets Kathleen M. Anderson Dave Bonola õ Integration Presentation

CM Hot Topics õ Effective February 6, 2008 the responsibility of loading and maintaining the catalog items will be performed at CORE-CT in East Hartford. All questions related to pricing or items in the catalog should be sent to the CORE-CT Help Desk for resolution.

Questions?

Agenda õ Welcome õ EPM õ Training õ CM õ Inventory John Harnick Barbara Jacius Steve Perkins John Winschel Steve Beaulieu õ e. Pro õ PO Amanda Starbala õ AP Cynthia Babbitt õ Assets Kathleen M. Anderson Dave Bonola õ Integration Presentation

Inventory Reminders T The Inventory module is used by 23 business units and in 2007 we recorded over 110, 000 transactions. T Please remember to communicate your agencies Inventory business requirements on all future SP-10. (Soon to be CORE-10). T The Inventory module is highly integrated with the Catalog Management, e. Pro, PO and A/P modules T Inventory items are interfaced during the PO Receipt process and PO receivers will be alerted to that fact when adjusting saved receipts.

Questions?

Agenda õ Welcome õ EPM õ Training õ John Harnick Barbara Jacius Steve Perkins CM John Winschel õ Inventory Steve Beaulieu õ e. Pro õ PO Amanda Starbala õ AP Cynthia Babbitt õ Assets Kathleen M. Anderson Dave Bonola õ Integration Presentation

e. Pro Hot Topics õ A Catalog Viewer Role has been created. õ Introducing the CORE-10

e. Pro Hot Topics Catalog Viewer Role õ The Catalog Viewer role will allow e. Procurement Approvers the ability to view items in the catalog, validate pricing and ensure that the most cost effective items are selected. õ This role would allow users access to the catalog search screen in the e. Procurement module but would not allow the user the “Save and Submit” the requisition.

e. Pro Hot Topics CORE-10 õ The Core-10 will be replacing the DOIT-10 system that agencies currently use for IT Procurements, the DAS paper SP 10 and the Standardization Transaction paper process. õ These processes will all start as e. Procurement requisitions. õ A new role has been created named CT Multi Requestor which will allow the user access to the CORE-10 drop-down box and CORE-10 Attribute links on the Create Requisition page. õ For those Agencies that do not currently use the e. Procurement Module, the IT Managers will be coordinating security, roles & workflow to provide access to the new functionality. õ Those Agencies that do use e. Procurement will have the new role assigned to specific users as identified by the IT Managers.

e. Pro Hot Topics CORE-10 The Approval Workflow is configured based on the value that is chosen. There will be 5 values: • BLANK (existing functionality). • DAS-BID • DAS-ST • ITD-10 • ITD-BID • ITD-ST

Questions?

Agenda õ Welcome õ EPM õ Training õ John Harnick Barbara Jacius Steve Perkins CM John Winschel õ Inventory Steve Beaulieu õ e. Pro õ PO Amanda Starbala õ AP Cynthia Babbitt õ Assets Kathleen M. Anderson Dave Bonola õ Integration Presentation

PO Reminders Batch processes now run at 10 am, 12 pm, 3 pm and overnight. If a PO is opened but not changed, click Cancel to close the document – not Save. Cannot reduce and cancel a PO in one step. First reduce to the amount expended. Wait for Budget Check to complete - then Cancel. When doing a change order to a PO sourced from a requisition, always answer “No” when asked if you want to re-source, return open quantity or re-open the requisition. If a PO does not show up when trying to receive or invoice, check the status of the PO. It must be in Dispatched status. If a PO does not show up on the approval worklist.

PO HOT TOPICS Creating separate run controls for Dispatch, Pending Cancel and Print purchase orders will ensure proper processing. PO Obligation should be equal to the net amount due on open POs IF there has been more than one PO issued per contract.

Pending Cancel and Dispatch Run Control Navigation: Purchasing > Purchase Orders > Dispatch Purchase Orders

Print PO Run Control Navigation: Purchasing > Purchase Orders > Review PO Information > Print POs

PO Obligation should be equal to the net amount due on open POs IF there has been more than one PO issued per contract. Example: DOC issues a two year PSN contract for religious services. The contract is copied into PO 70403 which is to be used for the life of the contract. The PO Obligation page would be represented as follows:

PO Obligation should be equal to the net amount due on open POs IF there has been more than one PO issued per contract. After only $5000 was expended on PO 70403, the PO was inadvertently closed. A new PO was issued for the balance. The PO Obligation on the new PO must reflect only the amount due on the open PO, not the entire amount of the contract:

Questions?

Agenda õ Welcome õ EPM õ Training õ John Harnick Barbara Jacius Steve Perkins CM John Winschel õ Inventory Steve Beaulieu õ e. Pro õ PO õ AP õ Assets Kathleen M. Anderson Amanda Starbala Cynthia Babbitt Dave Bonola õ Integration Presentation

AP Reminders and Hot Topics Critical Reminders New Column on PO Inquiry Results DO NOT Run Voucher Listing by Chartfield AP Interfaces - Duplicate Files loaded, and invalid Chart. Fields on records Overriding contract pay terms Hot Topics April 08 Bundles Incorrect GIRO vouchers

PO Inquiry õ Accounts Payable>Review Accounts Payable Info>Interfaces>Purchase Order A ‘Close Status’ Column has been added to the PO Inquiry Page to show the status of the vouchers

Incorrect GIRO Payments 1. Enter GIRO payment ID here 2. Enter Additional Details about the error here 3. Identify error here 4. Add same coding as that on the Direct Journal

Questions?

Agenda õ Welcome õ EPM õ Training õ John Harnick Barbara Jacius Steve Perkins CM John Winschel õ Inventory Steve Beaulieu õ e. Pro õ PO Amanda Starbala õ AP Cynthia Babbitt õ Assets Kathleen M. Anderson Dave Bonola õ Integration Presentation

Asset Hot Topics T Scanner Software Update T Asset Location Codes T EPM Reporting Timetable

Assets Scanner Software Update A required software upgrade is now available for the Intermec CK 31 Asset Scanner. This important upgrade is not downloadable and must be installed by Core-CT staff located at 101 East River Drive, East Hartford.

Assets Asset Location Codes õ New Buyer/Requestor Default õ ACORE õ Temporary Work Around for Receiving

Assets

Assets

Assets • EPM Reporting Timetable Assets Transactions Entered Today are not available for EPM Reporting for 48 hours

Questions?

Closing Thank You for your participation today. We hope this information proved helpful… í Look for this presentation and meeting Q & A’s on the Core-CT Website www. core-ct. state. ct. us í AP/PO User Group Meeting on Jan. 31 st & Feb. 5 th, Feb. 7 th

Coffee Break