financials user group meeting june 2014 · 2015. 5. 1. · tangoe system. target date will be end...
TRANSCRIPT
![Page 1: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/1.jpg)
Spring 2015
![Page 2: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/2.jpg)
Training/UPKs/Website
Daily Mails ◦ Future changes discussed here are announced ◦ http://www.core-ct.state.ct.us/listserv/dailymail.html
FYE ◦ Changes in personnel ◦ CO512 updates ◦ Agency contacts
Upgrade to 9.2
![Page 3: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/3.jpg)
Core-CT “Refresher” Training (In addition to regular training classes) ◦ Different approach: • Agency specific • Lab-like • Small group
Contact your Training Liaison to sign up for regular classes.
Contact Core-CT Financials Training if you are adding
new users or implementing a project (e.g. expanding eProcurement use)
[email protected] (860) 622-2164
![Page 4: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/4.jpg)
General Ledger
EPM
Security
DAS Catalog Management
eProcurement
Purchasing Accounts Payable
OSC- Accounts Payable Division
![Page 6: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/6.jpg)
Planned for FY2017 Budget reference for budgeted funds will be
blank. Bud Ref will also be blank for Agencies/Funds
that currently consolidate budget reference. Those that use Bud Ref will carry forward
each year, same as now. All agencies are strongly encouraged to use
Budget Reference as a method of controlling/reporting on grants and continuing funds.
![Page 7: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/7.jpg)
![Page 8: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/8.jpg)
Available due to upgrade
For budgeted Funds and consolidating funds, Budget Ref is always the same as Fiscal Year and carries no additional value.
Agencies/Funds that still need to track/control by Bud Ref still can
![Page 9: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/9.jpg)
Thousands of HR positions need to be re-coded every year.
Hundreds of SpeedCharts re-coded every year
Hundreds of SpeedTypes re-coded every year
PO Roll must update thousands of lines each year
Queries and Report Run Controls updated every year
![Page 10: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/10.jpg)
![Page 11: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/11.jpg)
Budgets will either be posted with a Bud Ref or Bud Ref will be blank
Transactions such as Purchase Orders and Vouchers will also have a blank Bud Ref for Budgeted/Consolidated Funds.
Job Aid with list of Funds by Agency will be provided
![Page 12: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/12.jpg)
![Page 13: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/13.jpg)
Sample Budgets
KK_ALLOT
Fund SID Agency Bud Ref
Budgeted Fund 11000 10020 SDR63500
Agency opts to use Budget Reference for continuing funds
12060 20703 SDR63500 2015
12060 20703 SDR63500 2016
12060 20703 SDR63500 2017
![Page 14: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/14.jpg)
![Page 15: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/15.jpg)
Sample Budgets
KK_ALLOT
Fund SID Agency Bud Ref
Budgeted Fund 12001 10020 DOT57000
Agency opts to consolidate Bud Ref for all funds.
12011 40010 DOT57000
12062 22507 DOT57000
12062 29102 DOT57000
![Page 16: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/16.jpg)
![Page 17: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/17.jpg)
![Page 18: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/18.jpg)
![Page 19: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/19.jpg)
New Purchasing Reporting Table
Purchasing and Inventory Queries
Security Reporting in EPM
![Page 20: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/20.jpg)
CTW_PO_WRKF - PO Workflow Rpt Tbl
Queries: ◦ CT_CORE_FIN_DAYS_PEND_BY_PO
◦ CT_CORE_FIN_PO_DAYS_PEND_DATE
![Page 21: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/21.jpg)
Approval Workflow is re-initiated whenever the value of the PO changes or when any chartfield information is changed.
Includes PO Qty, Price, Merchandise Amount, Fund, Dept, SID, Program, Account, Chartfied 1, Chartfield 2, Bud Ref, PC Bus Unit, Project, Activity, Source Type & Category
![Page 22: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/22.jpg)
Interpreting PO Workflow Query Results
EPM job aid ◦ http://www.core-
ct.state.ct.us/epm/docs/epm_workflow.doc
![Page 23: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/23.jpg)
Reporting Table enhancement: ◦ Added EMPLID to CTW_IN_DEMND -
Inventory Demand Reporting Table
DOC uniform distribution management queries: ◦ CT_DOC_UNIFORMS_BY_EE_NAME
◦ CT_DOC_UNIFORMS_ISSUED
◦ CT_DOC_UNIFORMS_ISSUED_BY_DATE
![Page 24: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/24.jpg)
FIN/HRMS/EPM (3) versions of Security Reporting now in EPM ◦ Job Aid: SECURITY EPM SUBJECT MODEL AND
REPORTING TABLES http://www.core-ct.state.ct.us/epm/pdf/sec_reporting_table_summary.pdf
![Page 25: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/25.jpg)
Security Tables contain different info in each environment: ◦ Financials – loaded nightly
◦ HRMS – loaded nightly
◦ Portal – loaded nightly
◦ EPM – native to EPM
![Page 26: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/26.jpg)
FIN Security Reporting Tables ◦ CTW_PSROLEUSERFN- User Roles in FIN
◦ CTW_PSOPRDEFNDFN_ User Profile in FIN
![Page 27: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/27.jpg)
HRMS Security Reporting Tables ◦ CTW_PSROLEUSERHR- User Roles in HR
◦ CTW_PSOPRDEFNHR- User Profile in HR
![Page 28: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/28.jpg)
Portal Security Reporting Table ◦ CTW_USERPROF_VW – System Profile
◦ Audit System Profile information for Password Reset Liaisons
![Page 29: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/29.jpg)
EPM Security Reporting Tables ◦ PSROLEUSER –Roles in EPM
◦ PSOPRDEFN- User Profile in EPM
![Page 30: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/30.jpg)
Example of FIN Security Public Query: ◦ CT_CORE_SEC_FNUSERID_BY_ROLE
◦ Roles by User Id and Agency
Locate all Security Queries in the EPM Query Folder: CORE_SEC
![Page 31: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/31.jpg)
Locate all EPM Public Queries in the Core-CT Catalog of Reports and Queries
◦ http://www.core-ct.state.ct.us/reports/
![Page 32: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/32.jpg)
![Page 34: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/34.jpg)
CO1092 Updates Automation of User Inactivation Security Liaison Training Reminders
![Page 35: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/35.jpg)
CO1092 Updates • New Roles/Approvers
• Fixes
![Page 36: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/36.jpg)
New Roles / Approvers
◦ CT_F_TSR_REQUESTER
◦ CT_F_TSR_APPROVER
FIN Appendix form updated
Segregation of duties configuration
DAS Approver level added to CO1092 Workflow
![Page 37: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/37.jpg)
![Page 38: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/38.jpg)
![Page 39: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/39.jpg)
![Page 40: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/40.jpg)
![Page 41: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/41.jpg)
CO1092 Fixes ◦ Duplicate Transaction Number resolved (both HR
and FIN)
![Page 42: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/42.jpg)
Automation of User Inactivation ◦ Run new process to Identify all employees that:
Terminate
Retire
Transfer out of Agency
![Page 43: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/43.jpg)
Automation of User Inactivation ◦ Security Team validates results
◦ Run process to delete: Roles
Business Unit Security
Process Profile
Lock Account
![Page 44: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/44.jpg)
Security Liaison Training ◦ Understanding Security ◦ Security Liaison Roles & Responsibilities ◦ New Hires ◦ Password Reset (Employee) ◦ Distributed User Profile ◦ Application Security Request (CO-1092)
Processing ◦ Running EPM Audit Queries
![Page 45: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/45.jpg)
Security Liaison Training ◦ Session: SEC101 ◦ Dates: May 15, 27, June 11 ◦ Course Time: 9a – 3p ◦ Location: DOT Training Room 2780 Berlin Turnpike
Newington, CT
![Page 46: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/46.jpg)
Reminders ◦ Use Core-CT Security Mailbox:
◦ User Security Liaison Guide: http://www.core-ct.state.ct.us/security/pdf/liaison_guide9_1.pdf
◦ All Security Job Aids: http://www.core-ct.state.ct.us/security/
![Page 47: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/47.jpg)
![Page 49: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/49.jpg)
Market Basket Philosophy
Items identified by volume / usage DAS will pursue deeper discounts Only those items loaded into the catalog Pilot results: 150% - 183% lower cost than in 2010
![Page 50: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/50.jpg)
May 2015
466,809 items 403,236 inactive
63,573 active
Jan 2015 Lean Event Catalog “load” process Backlog of 50+ contracts MOVING FORWARD Catalog “cleanse” Rolling archive process Market Basket Price Sheet Reduction of items
![Page 51: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/51.jpg)
![Page 52: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/52.jpg)
![Page 53: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/53.jpg)
Core-10
Telecom
eProcurement Roles
Fiscal Year End
Training
Questions
![Page 54: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/54.jpg)
All ePro Requisitions have a Core-10 value.
![Page 56: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/56.jpg)
Telecom services and equipment purchases will be entered into eProcurement with a target date of May 26, 2015.
eProcurement
TSR – Telecom Requisitioning
New!
![Page 57: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/57.jpg)
New Requisition Types as of May 26, 2015
5. TSR-EQUIP – End result is a Purchase Order • Use this value when purchasing Telecom
Equipment. • Req. Obligation Link
6. TSR-MACR– End result is a Purchase Order • Use this value when purchasing
Telecom Services. • Req. Obligation Link
![Page 58: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/58.jpg)
TSR – Equipment Workflow
Push
back
TSR-EQUIP Requisition
Req Amount Approval
Req Budget
Approval
Req Purchasing Approval
2,500
10,000
1 Mil.
Over 1 Mil.
TSR Approval
Budget Check
Exceptions
Sourcing Workbench OSC
Over 1 Mil.
![Page 59: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/59.jpg)
TSR – Service Workflow
eProcurement
OSC Over 1 Mil.
![Page 60: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/60.jpg)
eProcurement
- Communications Management Platform - (CMP)
![Page 61: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/61.jpg)
Cell phones/services, circuits and network requests will be entered into the Tangoe system. Target date will be end of May 2015.
The defined workflow for the various types of requests (IDSN, T1, Wireless services [hotspots, iPads, smartphones, blackberries, etc.]) consists of the
following: 1. Agency user enter request info into Tangoe (type of service, device, plans,
contact info, etc.) 2. Upon request completion agency users submits request to vendor with CC
to appropriate DAS Telecom business office rep. 3. Upon service order fulfillment vendor responds to agency user and DAS
telecom rep with finalization details of the order (circuit #, phone #, ESN, serial number, etc…)
4. DAS telecom rep will update Tangoe inventory and closeout order.
eProcurement Tangoe - Communications Management Platform (CMP)
![Page 62: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/62.jpg)
eProcurement Tangoe – CMP Workflow
![Page 64: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/64.jpg)
Equipment Vendors • Altura • Business Electronics • Unify • Valley Communications • Voice New England
(Sonitrol) Cabling Vendors • Comnet • Mercury
Core-CT TSR Vendors Tangoe TSR Vendors
Network & Cell Vendors • AT&T • AT&T Mobility • Frontier • Sprint • Verizon • Verizon Wireless • Windstream
![Page 66: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/66.jpg)
ePro Requester Roles • CT Requester • Multi Requester • TSR Requester
eProcurement
Security Liaisons -Please reference the Core-CT Role Handbook for specific role requirements at: http://www.core-ct.state.ct.us/security/fin_sec.html
![Page 67: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/67.jpg)
eProcurement
Fiscal Year End Agencies are responsible for closing or completing Requisitions before Year End that are in the following statuses:
Open Pending Approval Denied Canceled Budget Error
![Page 68: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/68.jpg)
eProcurement
Fiscal Year End
• Access to eProcurement • Sourcing Deadline • Requisitions that must be recreated. • Requisitions that will qualify to roll forward.
![Page 69: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/69.jpg)
eProcurement Roles Affected
• Access will be removed for the following roles on Monday, June 29, 2015 @ 4:00 pm:
CT Requesters Requisition Amount Approvers 1, 2, 3, 4 and 5 Requisition Budget Approvers Requisition Purchasing Approvers CT Multi-Requester CT TSR Requester CT F A TSR Approver CT ITD Approvers 1- 2 CT Req Bid Contract Creator CT DAS Approver 1 CT F A Adhoc Approver CT WF Req Adhoc Approver
![Page 70: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/70.jpg)
eProcurement
Training 1. Contact your Agency Training Liaison to sign up for
eProcurement Training. http://www.core-ct.state.ct.us/training/registration/training_reg.asp
2. Specific Agency Training will be provided upon request.
3. Telecom Training was provided to TSR users in April & May 2015. Additional training will be provided upon request.
![Page 71: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/71.jpg)
![Page 73: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/73.jpg)
Fiscal Year End Review
Fully Vouchered Purchase Orders
Over Expended Purchase Orders
Closing a Line on a Purchase Order
PO Roll Reminders
UPKs
![Page 74: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/74.jpg)
Purchasing Year End Dates
This year Purchasing access will not be removed by CORE-CT until June 29th at 4:00PM
Access to Purchasing will be returned on Monday July 6th*
As usual, check with your individual agency for their year end procedures and cutoff dates
![Page 75: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/75.jpg)
POs that are:
•Open
•Pending Approval
•Denied
•Pending Cancel
•Canceled
POs in
Budget Error
Fully Vouchered or
Zero Lines
Over Expended
Lines
Agencies are responsible for
cleaning up Purchase Orders before Year
End
![Page 76: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/76.jpg)
Do not Future date PO’s
Make sure to take PO’s off Hold before canceling or closing
Remember Canceled PO’s must still be closed
Create change orders to bring PO’s down to their expended amount if no further payments are necessary
![Page 77: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/77.jpg)
Purchase Orders that are fully vouchered should qualify to close through the Buyer’s Workbench and should be closed on a regular basis.
If there are multiple lines on a PO, some of the lines may be fully vouchered and need to be closed.
A zero line that has not been received must always be forced closed.
![Page 78: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/78.jpg)
The PO shows a $500.00
encumbrance left so the
PO is not fully Vouchered
![Page 79: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/79.jpg)
How can I tell if a line is fully expended?
Review the:
PO Activity Summary
Navigation: Purchasing / Purchase Orders / Review Purchasing Information / Activity Summary
![Page 80: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/80.jpg)
Line 1 is fully Expended
Line 2 has no activity (Zero Line)
Line 3 is partially paid and will qualify to roll
![Page 81: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/81.jpg)
How can I tell if a line is fully expended?
Review the:
Expense to Date
Navigation: Purchasing / Purchase Orders / Add/Update POs – Click Schedule / Click Distributions/Chartfields
![Page 82: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/82.jpg)
Click the Budget Information Tab
![Page 83: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/83.jpg)
How can I tell if a line is fully expended?
Run and Review the:
PO Balance Report
Navigation: Purchasing/Purchase Orders/Reports/PO Balance Report
![Page 84: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/84.jpg)
Line 1 is fully Expended
Line 2 has no activity (Zero Line)
Line 3 is partially paid and will qualify to roll
![Page 85: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/85.jpg)
How can I tell if a line is fully expended?
Review the:
PO/AP Interface
Navigation: Accounts Payable/Review Accounts Payable Information/ Interfaces/Purchase Order
![Page 86: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/86.jpg)
Line 1 is fully Expended
![Page 87: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/87.jpg)
Line 2 has no activity (Zero Line)
Line 3 is partially paid and will qualify to roll
![Page 88: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/88.jpg)
Do a change order to your PO prior to creating a voucher so that encumbrances will be properly reflected
Never add funds to an over expended line
Over Expending a line takes funds directly from the unencumbered funds WITHOUT creating PO accounting entries
Once a line is over expended, it cannot be fixed – IT MUST BE CLOSED
![Page 89: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/89.jpg)
This PO shows a $250.00
Encumbrance Left
![Page 90: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/90.jpg)
However, the Activity Summary shows the entire PO amount has been expended.
![Page 91: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/91.jpg)
The Purchase Order Distributions show that
different amounts were paid causing the first
distribution to be over expended and leaving a
balance on the second that cannot be cleared.
![Page 92: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/92.jpg)
You can also see Over Expended POs on the PO Balance Report
![Page 93: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/93.jpg)
How does this happen?
Purchasing – Receipts – Vouchers look at the Line Amount
As long as the sum of the distributions is less than the line amount, the values can be changed to any
amount and the system will allow it
![Page 94: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/94.jpg)
If you try to close the PO
through the Buyer’s Workbench,
it will not qualify.
![Page 95: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/95.jpg)
Instead click the Lines
to the right of the PO
![Page 96: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/96.jpg)
Deselect the Line that does not qualify – We
want that to roll
![Page 97: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/97.jpg)
Line 1 is qualified to close
Line 2 for zero must be forced closed
The Line has not been received
![Page 98: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/98.jpg)
Select the PO and click the override button to force close it
Now both lines will close
![Page 99: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/99.jpg)
Purchase Orders that are canceled, fully vouchered, on hold, or have not been successfully budget checked are not qualified to roll
PO lines that are for an amount of zero or that are fully vouchered must have funds added or need to be closed
PO lines that are over expended must be closed
![Page 100: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/100.jpg)
![Page 101: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/101.jpg)
![Page 102: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/102.jpg)
![Page 103: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/103.jpg)
![Page 104: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/104.jpg)
![Page 105: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/105.jpg)
BI Publisher to replace Crystal
Running AP Reports
Interfacing Vouchers
AP Reminders
FYE 2015
![Page 108: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/108.jpg)
Example – Match Exception Report
Process Instance: 1878
![Page 113: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/113.jpg)
Remember Report Etiquette:
1. Know the size of your report
2. Monitor the progress of all started reports
3. Schedule any reports with large results
4. Contact Footprints with questions
![Page 114: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/114.jpg)
Consider an Interface for High Volume Vouchers New Guidelines Job Aid on Core-CT Website
http://www.core-ct.state.ct.us/financials/ap/pdf/intfc_vchr_guide.pdf
For Existing Interface Users Troubleshooting Job Aid on Core-CT Website
http://www.core-ct.state.ct.us/financials/ap/doc/interface_voucher.doc
![Page 115: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/115.jpg)
1. Vendor Contacts need email addresses
2. Typos on Vendor Change Forms
3. From the HelpDesk – if you are unsure, call us FIRST!
4. AP Month-End and closing the period
5. Metropolitan District Commission (MDC) payment requirements
6. Pay special attention to cancelling ACH payments
7. Contract Payment Terms vs. Voucher Payment Terms
8. Voucher Approver Role Change
9. UPKs are now accessible
![Page 116: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/116.jpg)
1st. Submit Voucher Processor or Approver can submit voucher for approval on the approval framework page.
2nd. Approve Only the Voucher Approver can approve.
![Page 121: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/121.jpg)
Last Day to pay Inter-Agency bills: 6/05/15
Payment Cancellations: 6/18/15
AP Interface files received: 6/26/15
Last STATE pay cycle: 9am 6/29/15
Delete unpaid/unprocessed vchrs: 6/29/15
Last ZERO pay cycle: 6/30/15
AP Module Closes: Noon 6/30/15
![Page 122: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/122.jpg)
![Page 123: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/123.jpg)
Pay cycle processing
Cancellation of ACH payments
Imposter Fraud
Open Connecticut – Expenditures
![Page 124: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/124.jpg)
A STATE pay cycle is run manually by OSC-APD each workday morning beginning at 9:30am to select all vouchers in CORE-CT that qualify for payment.
OSC – Accounts Payable Division
Pay Cycle Processing
![Page 125: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/125.jpg)
• Vouchers must be matched, approved, and budget checked in order to be selected for payment.
OSC – Accounts Payable Division
Pay Cycle Processing
![Page 126: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/126.jpg)
Pay Cycle Processing
OSC – Accounts Payable Division
![Page 127: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/127.jpg)
OSC-Accounts Payable Division
*Pay cycle run on Monday 5/4 will select vouchers through Tuesday 5/5 with a payment date of Tuesday 5/5.
Pay Cycle Run
Select vouchers through
Payment Date
Pay Cycle Processing
![Page 128: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/128.jpg)
OSC – Accounts Payable Division
*Pay cycle run on Friday 5/1 will select vouchers through Monday 5/4 with a payment date of Saturday 5/2.
Pay Cycle Run
Select vouchers through
Payment Date
Pay Cycle Processing
![Page 129: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/129.jpg)
OSC-Accounts Payable Division
*Pay cycle run on Friday 5/22 will select vouchers through Tuesday 5/26 with a Payment date of Saturday 5/23. (5/25 is a holiday)
Pay Cycle Run
Select vouchers through
Payment Date
Pay Cycle Processing
![Page 130: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/130.jpg)
OSC – Accounts Payable Division Pay Cycle Processing
![Page 131: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/131.jpg)
OSC – Accounts Payable Division
• ACH payments become ‘Reconciled’ after 6 months. • Checks payments become ‘Reconciled’ when the check
has been cashed. • Payments that have been cancelled will display as
‘Reconciled’
Pay Cycle Processing
![Page 132: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/132.jpg)
OSC – Accounts Payable Division
Pay Cycle Processing
![Page 133: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/133.jpg)
An incorrect ACH payment must be retracted within 5 days.
Be sure to notify APD immediately. Also submit a CO-790. An ACH payment returned by the bank will require a
CO-790 from the agency to cancel/reissue. APD will notify agencies when this occurs.
Cancellation of ACH Payments
OSC – Accounts Payable Division
![Page 134: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/134.jpg)
ACH Vendor Payments
http://www.osc.ct.gov/vendor/directdeposit.html
OSC – Accounts Payable Division
![Page 135: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/135.jpg)
Notify [email protected] if you become aware of suspicious activity regarding vendor address changes or payment method changes.
Imposter Fraud
OSC – Accounts Payable Division
![Page 136: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/136.jpg)
Open Connecticut now includes current expenditure data for a rolling five year period. Data is
provided daily by OSC Accounts Payable
Open Connecticut - Payments
OSC – Accounts Payable Division
![Page 137: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/137.jpg)
![Page 138: Financials User Group Meeting June 2014 · 2015. 5. 1. · Tangoe system. Target date will be end of May 2015. The defined workflow for the various types of requests (IDSN, T1, Wireless](https://reader034.vdocuments.us/reader034/viewer/2022051903/5ff4dbbaae31fb293e51423b/html5/thumbnails/138.jpg)
Thank You for your participation today
We hope this information proved helpful.
Look for this presentation on the Core-CT website at www.core-ct.state.ct.us