1.17k likes | 1.26k Views
September 2007. Financials User Group Meeting. AR/BI/GL. Agenda. Welcome John Harnick EPM Barb Jacius Help Desk Lynn Sheldon GL Donna Braga Joan Skripol Billing Deb Carta Chris Marchese AR Deb Carta. Training.
E N D
September 2007 Financials User Group Meeting AR/BI/GL
Agenda • Welcome John Harnick • EPM Barb Jacius • Help Desk Lynn Sheldon • GL Donna Braga Joan Skripol • Billing Deb Carta Chris Marchese • AR Deb Carta
Training • Introduction to BillingOctober 2nd and 16th • Advanced BillingSeptember 27th • Announced in Daily Mails • More classes to be released in the future • Seating is Limited • Classes Fill Quickly • Schedule available athttp://www.core-ct.state.ct.us/training
Core-CT Website Go to the CORE website at : http://www.core-ct.state.ct.us/ Click on Financials User
Core-CT Website Go to the Section titled, “Financials Job Aids” You can choose to go to the Master List or the List by Module. If you link to the Master List, you will get a list of 9 pages of Job Aids for all Modules. If you link to By Module, you will get the next slide.
Agenda • Welcome John Harnick • EPM Barb Jacius • Help Desk Lynn Sheldon • GL Donna Braga Joan Skripol • Billing Deb Carta Chris Marchese • AR Deb Carta
EPM-FAQ’s How can I find a query to meet my needs? • All queries deployed by CORE-CT are organized in folders. • Access the folder name that correlates to the module (i.e. AP, PO, AM, AR, GL, etc.)
EPM-FAQ’s Help, my Query doesn’t work! • Check your criteria • Verify the validity of the table joins • Log a Help Desk Ticket
EPM-FAQ’s How can I see only totals on my report? • Only display the fields you need to see. • Set up all criteria in the background.
EPM Questions?
Agenda • Welcome John Harnick • EPM Barb Jacius • Help Desk Lynn Sheldon • GL Donna Braga Joan Skripol • Billing Deb Carta Chris Marchese • AR Deb Carta
Level II HelpDesk Ticket Counts from 7/1/07-9/14/07 • New Tickets - 555 • Closed Tickets - 553 • SIR Tickets - 15
HD Reminders • Do not try to make up your own work-arounds! This will cause issues in other modules, even though you may think you have solved your problem. • If you cannot get a transaction to work after you have read the Job Aids and the WLA, then call the Helpdesk for more information. • When you call the Helpdesk, be sure that you give them all theinformation, such as your business unit, your name and phone number, the module that you are having trouble in, the specific Deposit ID, Journal ID, Bill, Item ID or Report that you are having issues with. If you are getting errors, please email the screenshots with the errors to the Helpdesk. Give us the specific steps you went through to receive the error.
Answers to Common HD Questions • You need to take steps to analyze your error before calling the Helpdesk. Your job aids and WLAs will help you to do this. • If you are having problems with reports not matching, you need to reconcile, to see what transactions are causing the problem. • If you are having problems with Deposits not falling off your screen, you need to check for Payment Worksheets that haven’t been completed, aren’t balanced, haven’t had accounting entries created, or haven’t been set to Batch Standard. • If your reports are not coming out, you need to check your parameters to be sure you are using correct budget references and the correct budget ledgers. Check your process schedule request to be sure you are asking for web and .PDF files. If the request asks for “none,” you will get none.
Creating & Saving a Screenshot • Have the screen you want to copy on your monitor • Push the Print Screen button on your keyboard • Minimize the application you are in • Open a new Word document • Right click with your mouse • Click on “Paste” • Save your document to a file on one of your drives • Open a new e-mail to the addressee • Attach the screenshot document and Send The Helpdesk person assisting you now has the documentation to use while resolving the problem
Agenda • Welcome John Harnick • EPM Barb Jacius • Help Desk Lynn Sheldon • GL Donna Braga Joan Skripol • Billing Deb Carta Chris Marchese • AR Deb Carta
GL Agenda • Hot Topics and GL Reminders • The Life of a Transaction in GL/KK – Billing/AR • GL Mini Training: Peoplesoft Trees • The Life of a Transaction in GL/KK – Req and PO
Hot Topics and GL Reminders • Hot Topics • Effective Dated Reporting • On-Line Catalog Additions • Available Cash Trial Bal • Trial Balance of Approp • Federal Program Approp • GL Reminders • Process Monitor • Monthly Closing Dates
GL Agenda • Hot Topics and GL Reminders • The Life of a Transaction in GL/KK – Billing/AR • GL Mini Training: Peoplesoft Trees • The Life of a Transaction in GL/KK – Req and PO
Billing Impact on Expenditures Navigation: Commitment Control > Review Budget Activities > Budget Details
Billing Impact on Revenue Navigation: Commitment Control > Review Budget Activities > Budget Details
Bill Creation Navigation: Billing > Maintain Bills > Standard Billing (Tab 1)
Accounting Distribution Navigation: Billing > Maintain Bills > Standard Billing (Tab 3)
Billing Impact on Expenditures Navigation: Commitment Control > Review Budget Activities > Budget Details
Billing Impact on Revenue Drill Down to the Ledger Navigation: Commitment Control > Review Budget Activities > Budget Details
Ledger Drill Down Billing Impact on Revenue Drill down into the Activity Log
Activity Log Drill Down Activity Log Drill Down
Billing Impact on Expenditures Impact on the Expenditure Budget Drill down into the Ledger Navigation: Commitment Control > Review Budget Activities > Budget Details
Ledger Drill Down Ledger Drill Down Drill Down into the Activity Log
Activity Log Drill Down Activity Log Drill Down
Collected Revenue Drill Down into The Ledger Navigation: Commitment Control > Review Budget Activities > Budget Details
Ledger Drill Down Drill Down into the Activity Log
Accounting Entries Navigation: Billing > Review Billing Information > Review Entries by Invoice
General Ledger Activity • Billing and AR impact to General Ledger • Detail Ledger information available in reporting Navigation: General Ledger > General Ledger Reports > Ledger Activity
GL Agenda • Hot Topics and GL Reminders • The Life of a Transaction in GL/KK – Billing/AR • GL Mini Training: Peoplesoft Trees • The Life of a Transaction in GL/KK – Req and PO
GL Mini Training Core-CT Trees • Hierarchical organization of values • Defines the State’s reporting structures • Effective Dated Trees in reporting
GL Mini Training Core-CT Tree Levels Level 1 – Entire State Level 2 – Entire Agency Navigation: Fin Tree Manager> Tree Viewer
GL Mini Training Core-CT Tree Levels Level 3 – Agency Summary Level 4 – Agency Detail Values
GL Mini Training Navigation: General Ledger > General Reports > Flexible Ledger Analysis
GL Agenda • Hot Topics and GL Reminders • The Life of a Transaction in GL/KK – Billing/AR • GL Mini Training: Peoplesoft Trees • The Life of a Transaction in GL/KK – Req and PO
Purchasing Impact onCommitment Control Purchasing Impact on Commitment Control Navigation: Commitment Control > Review Budget Activities > Budget Details
Requisition Requisition Navigation: eProcurement > Create Requisition
Req Accounting Distribution Req Accounting Distribution Navigation: eProcurement > Manage Requisitions
Pre-Encumbrance Report Pre-Encumbrance Report Navigation: Commitment Control> Budget Reports> Pre-Enc/Enc Report