Transcript GL Reporting Lab, April 2007

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
CatalogofofOn-Line
On-Line Reports
Catalog
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 vs.
Commitment Control
Commitment Control (KK)
General Ledger (GL)
•
Ledgers: KK_%
•
MOD_ACCRL / MOD_CASH
•
Encumbrances
•
No Encumbrance
•
Roll-up Account and DeptIDs
•
Detail Account and DeptIDs
•
Budget Journals
•
SSJs, ONLs, DCs, PCs
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
1. Ledger Group
2. Budget Period
3. Fully range DeptIDs
4. Fund
5. SID
Report Parameters
This will provide the appropriate parameters for your reports.
Canceling a Report
•
Fin PeopleTools> Process Scheduler> Process Monitor
Canceling a Report
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
Questions ??
Customer Support
Users can call the
HelpDesk
@ 860-622-2300,
Ext. 1
For complex issues, send
email to
[email protected].
ct.us
Closing
Thank You for your participation today.
We hope this information proved helpful…