1 / 92

STATE OF CONNECTICUT Core-CT

STATE OF CONNECTICUT Core-CT. GL / AR / BI. Financials User Group Meeting. Winter 2008. Agenda. Welcome John Harnick EPM Barbara Jacius Training Steve Perkins GL Donna Braga Joan Skripol Billing Chris Marchese AR Lynn Sheldon.

derrickjames
Download Presentation

STATE OF CONNECTICUT Core-CT

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. STATE OF CONNECTICUT Core-CT GL / AR / BI Financials User Group Meeting Winter 2008

  2. Agenda • Welcome John Harnick • EPM Barbara Jacius • Training Steve Perkins • GL Donna Braga Joan Skripol • Billing Chris Marchese • AR Lynn Sheldon

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

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

  5. Agenda • Welcome John Harnick • EPM Barbara Jacius • Training Steve Perkins • GL Donna Braga Joan Skripol • Billing Chris Marchese • AR Lynn Sheldon

  6. EPM EnhancementsAccounts Receivable/Billing Projects/Costing Module Fields Added • ACTIVITY_ID • ANALYSIS_TYPE • BUSINESS_UNIT_PC • PC_DISTRIB_STATUS • RESOURCE_CATEGORY • RESOURCE_SUB_CAT • RESOURCE_TYPE • PC_DISTRIB_STATUS

  7. EPM EnhancementsAccounts Receivable/Billing Projects/Costing Fields Added to EPM Reporting Tables: • CT_POSTED_ITEM • CT_DIR_JRNL_PAY • CT_BI_ACCTENTRY • CT_BI_AR_PNDITN • CT_BI_INVOICE

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

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

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

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

  12. EPM Job Aids UpdatedReporting Table to Role Mapping

  13. Questions?

  14. Agenda • Welcome John Harnick • EPM Barbara Jacius • Training Steve Perkins • GL Donna Braga Joan Skripol • Billing Chris Marchese • AR Lynn Sheldon

  15. 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

  16. 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

  17. Agenda • Welcome John Harnick • EPM Barbara Jacius • Training Steve Perkins • GL Donna Braga Joan Skripol • Billing Chris Marchese • AR Lynn Sheldon

  18. GL Agenda • Reminders / Hot Topics • Budget Ledger Review • GL Mini-Training • Detail and Summary Revenue Report

  19. GL Reminders & Hot Topics Reminders • MP8 Upgrade • FIN Reporting Tools vs. EPM/HR Reporting Tools • CFSR Navigation in Report Manager Hot Topics • Reports for Multiple Ledgers • Updated Ledger Job Aid

  20. CFSR Report Manager Navigation Navigation: FIN Reporting Tools > Report Manager: Administration Tab

  21. GL Reminders & Hot Topics Reminders • MP8 Upgrade • FIN Reporting Tools vs. EPM/HR Reporting Tools • CFSR Navigation in Report Manager Hot Topics • Reports for Multiple Ledgers • Updated Ledger Job Aid

  22. Reports for Multiple Ledgers • General Ledger>… • Flexible Ledger Analysis • Ledger Activity • Trial Balance • Expenditure Report by Object • Detail and Summary Revenue • Cash Ledger

  23. Ledger Job Aid Financials User Support > General Ledger/Chart of Accounts > General Ledger Job Aids > Ledgers

  24. GL Agenda • Reminders / Hot Topics • Budget Ledger Review • GL Mini-Training • Detail and Summary Revenue Report

  25. Control vs. Track Budgets • Control: Agencies post budget journals. Transactions must fall within the available budget to pass budget check. • Track: Agencies do not post budget journals. All transactions pass budget check for this ledger, and are recorded/tracked for reporting purposes. • Track w/Budget: Agencies can post budget journals. All transactions pass budget check for this ledger, and are recorded/tracked against the budgeted amount for reporting purposes only.

  26. Agency Budgets Agency Budgets break down Allotment budgets into lower, Department and/or Account levels of detail for controlling spending and/or reporting. Agency Budgets may differ from appropriated. However, budget control will ultimately always reside at Appropriation/Allotment.

  27. Agency Budgets Agency 1 (KK_AGY1): • Agencies can control and/or report on funds based on agency defined departments, usually higher levels such as divisions, bureaus, facilities, etc. • May be established as control or track. • Agency Fiscal Administrative Reviewers must create and maintain agency budgets. • Non-Lapsing Funds carried forward at FYE

  28. Agency Budgets Agency 2 (KK_AGY2): • Agencies can report on funds based on agency defined departments, usually lower levels, such units, cost center, etc. • Agencies can also report on expenditures at the detail account level, just as they are posted in GL. • Established as track budget. It is used for reporting purposes only. • FYE balances are not carried forward

  29. Project Budgets Project Budgets (KK_PRJ) are based on agency defined Project ID values. Budgets may differ from the Appropriation. However, budget control will ultimately always reside at Appropriation/Allotment. Project IDs ending in NONPROJECT are NOT RECORDED here. They are tracked on the Agency 1 and/or Agency 2 budget structures.

  30. Project Budgets Project 1 (KK_PRJ1): • Agencies can control and/or report on funds based on agency defined Project IDs. • May be established as control or track. • Agency Fiscal Administrative Reviewers must create and maintain project budgets. • Non-Lapsing Funds carried forward at FYE

  31. Project Budgets Project 2 (KK_PRJ2): • Agencies can control and/or report on funds based on agency defined Project IDs, along with the detail account level, just as they are posted in GL. • May be established as control or track. • Agency Fiscal Administrative Reviewers must create and maintain project budgets. • FYE balances are not carried forward

  32. Project Budgets Project 3 (KK_PRJ3): • Agencies can control and/or report on funds based on agency defined Project IDs, along with agency defined Chartfield1 values. • May be established as control or track. • Agency Fiscal Administrative Reviewers must create and maintain project budgets. • FYE balances are not carried forward

  33. Project Costing Budgets Project Costing module (KK_PC) budgets are ONLY used by those Agencies that participate in Core-CT Project Costing. Project Budgets may differ from the Appropriation. However, budget control will ultimately always reside at Appropriation/Allotment. Project IDs that are not used in the Project Costing module are NOT RECORDED here. They are tracked on the AGY or PRJ budget structures.

  34. GL Agenda • Reminders / Hot Topics • Budget Ledger Review • GL Mini-Training • Detail and Summary Revenue Report

  35. GL Mini-Training Detail and Summary Revenue Report Navigation: General Ledger > General Reports> Detail and Summary Revenue

  36. GL Mini-Training Detail and Summary Revenue Report Multiple ledger config!

  37. GL Mini-Training Detail and Summary Revenue Report MOD_ACCRL + MOD_CASH = collected revenues and collected refunds of expenditure.

  38. GL Mini-Training Detail and Summary Revenue Report

  39. Questions?

  40. Coffee Break

  41. Agenda • Welcome John Harnick • EPM Barbara Jacius • Training Steve Perkins • GL Donna Braga Joan Skripol • Billing Chris Marchese • AR Lynn Sheldon

  42. Billing Agenda • Reminders / Hot Topics • ET/ST Bill Type Distribution Coding • Billing BATCH Processing Schedule • Mini-Training • Adjust Entire Bill vs. Adjust Selected Bill Lines • Online Inquiries

  43. ET/ST Distribution Coding

  44. ET/ST Distribution Coding Option 1: Change your account code Option 2: Change your Bill Type

  45. BIJOB01 Finalize and Print Invoice BICURCNV Convert Currency Amounts BIPRELD Pre-Load Process BILDAR01 Load Invoices to AR FS_BP Request Budget Check BILDGL01 Create Accounting Entries ARUPDATE PS/AR Receivables Update CTARB272 AR Revenue Reversal FS_JGEN Generate Journals Billing BATCH Processes Run Anytime 10AM, 12Noon, 2PM, Nightly 10AM, 12Noon, 2PM, Nightly 10AM, 12Noon, 2PM, Nightly 10AM, 12Noon, 2PM, Nightly 10AM, 12Noon, 2PM, Nightly 12Noon, Nightly 12Noon, Nightly 3PM, Nightly

  46. Billing Summary • NAVIGATION: Billing  Review Billing Information  Summary  Bill Summary Info 2 tab

  47. MINI-TRAINING: Adjustments • NAVIGATION: Billing  Maintain Bills  Adjust Entire BillORAdjust Selected Bill Lines • Prerequisites • Adjust Entire Bill • Bill must be Invoiced • Bill must not have been previously adjusted • Adjust Selected Bill Lines • Bill must be Invoiced • Bill must not have been previously adjusted • Bill should contain multiple Bill Lines

  48. MINI-TRAINING:Adjust Entire Bill • Credit Entire Bill

  49. MINI-TRAINING:Adjust Entire Bill • Credit Entire Bill

  50. MINI-TRAINING:Adjust Entire Bill • Credit Entire Bill

More Related