220 likes | 326 Views
General Ledger Reporting Lab. April and May 2007. STATE OF CONNECTICUT Core-CT Project. GL Reporting Agenda. Objectives for Today Catalog of On-Line Reports General Ledger vs. Commitment Control Tips for Troubleshooting Featured Reports Questions Open Lab. Objectives.
E N D
General Ledger Reporting Lab April and May 2007 STATE OF CONNECTICUT Core-CT Project
GL Reporting Agenda • Objectives for Today • Catalog of On-Line Reports • General Ledger vs. Commitment Control • Tips for Troubleshooting • Featured Reports • Questions • Open Lab
Objectives • Review Key GL and KK Reports • Tips for Troubleshooting Reports • Set up Run Controls
GL Reporting Agenda • Objectives for Today • Catalog of On-Line Reports
Catalog of On-Line Reports Catalog of On-Line Reports Catalog of General Ledger Reports • Select a report entry
GL Reporting Agenda • Objectives for Today • Catalog of On-Line Reports • General Ledger vs. Commitment Control
General Ledger (GL) MOD_ACCRL / MOD_CASH No Encumbrance Detail Account and DeptIDs SSJs, ONLs, DCs, PCs General Ledger vs. Commitment Control Commitment Control (KK) • Ledgers: KK_% • Encumbrances • Roll-up Account and DeptIDs • Budget Journals
KK to GL Reconciliation Items • Documents Budget Checked but not Posted. • Timing – EPM vs. Financials • Preferable if GL Period is Closed. • Budget Structures (i.e. DeptID roll-up) • MOD_CASH Ledger Balances
GL Reporting Agenda • Objectives for Today • Catalog of On-Line Reports • General Ledger vs. Commitment Control • Tips for Troubleshooting
Run Controls • User ID specific (except CFSRs) • Use Report Titles vs. Initials for IDs • Include Ledger for KK Run Control IDs • More detail = More Efficient Processing • Language – English • Flexible Ledger Analysis (Tree Levels)
Report Parameters • Use the Budgets Overview Inquiry to confirm Budget Report Parameters such as DeptID and Account. Navigation: Commitment Control> Review Budget Activities> Budgets Overview
Report Parameters • Ledger Group • Budget Period • Fully range DeptIDs • Fund • SID
Report Parameters This will provide the appropriate parameters for your reports.
Canceling a Report • Fin PeopleTools> Process Scheduler> Process Monitor
GL Reporting Agenda • Objectives for Today • Catalog of On-Line Reports • General Ledger vs. Commitment Control • Tips for Troubleshooting • Featured Reports
Featured Commitment Control Reports Commitment Control>Budget Reports • Budget Status Report • Budget Transaction Details • Trial Balance of Appropriation • Negative Balance Report Reporting Tools> PS/nVision> Define Report Request • CFSR: A through D
Featured General Ledger Reports General Ledger> General Reports • Flexible Ledger Analysis • Ledger Activity
GL Reporting Agenda • Objectives for Today • Catalog of On-Line Reports • General Ledger vs. Commitment Control • Tips for Troubleshooting • Featured Reports • Questions and Open Lab
CustomerSupport Users can call the HelpDesk@ 860-622-2300, Ext. 1 For complex issues, send email toCore.Support@po.state.ct.us
Closing Thank You for your participation today. We hope this information proved helpful…