Hr finance c p r come practice reporting budget operating statement detail expenditures listing
Download
1 / 64

BOS Detailed Expense Tracking materials - PowerPoint PPT Presentation


  • 239 Views
  • Uploaded on

HR-Finance C.P.R. Come Practice Reporting Budget Operating Statement - Detail Expenditures listing October 2006 Goals: By the end of today’s session, you should be able to: Be familiar with the set up for the HRFIN BOS Expenses Universe Create a report in the HRFIN BOS Expenses Universe

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'BOS Detailed Expense Tracking materials' - JasminFlorian


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Hr finance c p r come practice reporting budget operating statement detail expenditures listing l.jpg

HR-Finance C.P.R.Come Practice ReportingBudget Operating Statement -Detail Expenditures listing

October 2006


Goals l.jpg
Goals:

By the end of today’s session, you should be able to:

  • Be familiar with the set up for the HRFIN BOS Expenses Universe

  • Create a report in the HRFIN BOS Expenses Universe

  • Be familiar with why and which conditions you will need for most queries in the HRFIN BOS Universe

  • Be better prepared to track your expenses



Slide4 l.jpg

BOS 3 Data Overview

  • Contains ALL Finance expenses at the detail level including Payroll transactions. Similar to OL detail, but with the ability to augment payroll transactions with person, position and job information from HR/Pay data.

  • Contains expense data from the current and previous fiscal year. Older fiscal year data will be deleted on September 1.

  • Current load schedule is once per week during the weekend. If load times allow, we may increase the frequency to daily in the future.


Slide5 l.jpg

BOS 3 Data Overview

  • The data is shown to you when the expenditure hits your CFOAPAL.

    • When you make a payroll adjustment today, it can be applied to a previous period.

    • That expense hits your CFOAPAL today, even though it may apply to a previous month or year.

    • You will see the expense, in this Universe and associated tables, in the current month based on the OL transaction date.


Consider your conditions state fiscal year fiscal period l.jpg
Consider your Conditions: State Fiscal Year & Fiscal Period

  • State Fiscal Year:

    • 2006: four-digit year(s)

  • State Fiscal Periods:

    • 00: “trail-in”, such as rollover balances from previous year

    • 01-12: the twelve monthly periods - where 01= July and 12= June

    • 14: a period open after period 12 closes (to regular activity) that will hold the final adjustments to a fiscal year.


Consider your conditions time l.jpg
Consider your Conditions: Time

For BOS Expense detail transactions, remember:

Transaction date (ex: July 1 -31)

Posted Period (ex: 01 – 12)

Fiscal Year ( ex: 2007)


Consider your conditions cfoapal l.jpg
Consider your Conditions: CFOAPAL

What Campus? – Urbana, Chicago, Springfield, UA

What kind of $ - State, ICR, Grant, Gift, etc

Who am I? – the College of XYZ

What am I receiving or buying? – Office supplies, Travel, Cash (Designates whether this is a revenue, expense, asset, etc transaction)

What NACUBO function? What long term activity? (over 1 year)

What short term activity am I tracking? – example: concert at the Assembly Hall

Where is this item physically located? – primarily for Fixed Assets



Slide10 l.jpg

You will access Business Objects normally

You can go directly to EDDIE.DS.UILLINOIS.EDU or select ‘To EDDIE’ from the DS Main Menu








Slide17 l.jpg

The BOS Expenses Universe

  • The new Universe is called EDW – HRFIN BOS Expenses

Then Click on Finish



Slide19 l.jpg

The BOS Universe is set up similarly to the Financial Ledgers OL GL Universe

Make sure all three buttons are pressed. The first button allows the Classes and Objects window to be seen (usually depressed).The second button allows you to see the definitions for the objects that are selected.The third button will have your selected objects wrap in the “Result Objects” window.



Slide21 l.jpg

The BOS Expenses Universe Ledgers OL GL Universe

Operating Ledger Detail Expenses are found here

The HR Detail, for the Payroll Expenses, found in the OL Summary, are found here


Slide22 l.jpg

The BOS Expenses Universe Ledgers OL GL Universe

CFOAPAL Codes and Titles are in the next two Classes


Slide23 l.jpg

The BOS Expenses Universe Ledgers OL GL Universe

The CFOAPAL Hierarchies are in the next Class


Slide24 l.jpg

The BOS Expenses Universe Ledgers OL GL Universe

For the BOS Expense Universe, we created a “Report Quick Start” class.This class contains the most common objects that users will use when reporting in this Universe.All the of the objects in this class are duplicated from the classes above.


Slide25 l.jpg

The BOS Expenses Universe Ledgers OL GL Universe

For the BOS Expense Universe, we created several predefined prompts to use in your conditions:Select State Fiscal Year – Prompts users for four digit state fiscal year.Select State Fiscal Period – Prompts users for a two digit Fiscal PeriodSelect Chart of Accounts Code – Prompts users for a 1 digit Chart of Accounts CodeSelect College Level 3 Code – Prompts users for a two character College CodeSelect Department Level 5 Code – Prompts users for a 3 digit organization codeSelect Organization Code – Prompts users for a 6 digit organization code


Slide26 l.jpg

BOS 3 Reporting Example Ledgers OL GL Universe


Consider your question l.jpg
Consider your Question: Ledgers OL GL Universe

‘I’ is most likely defined with a Chart and an Organization

When you describe what you spend money on, you will want to see all of the details.

How much did I spend last month on what and whom?

When you use the phrase ‘last month’, you will most likely need a condition on year and month.

By asking on what AND on whom, the BOS Expense Universe is the only Universe that contains both detail level data.


Slide28 l.jpg

The BOS Expenses Universe – Report 1 Ledgers OL GL Universe

Click on the Basic Report Quick Start Folder and drag it into the Results Object window. All of the objects, in this folder, will appear in the Results Object window. The contents of this folder are listed in the left hand window pane.


Slide29 l.jpg

The BOS Expenses Universe – Report 1 Ledgers OL GL Universe

By pulling over the Basic Report Quick Start folder, you get all of the objects that are in that folder


Slide30 l.jpg

The BOS Expenses Universe – Report 1 Ledgers OL GL Universe

We are going to use four of the predefined prompts. Usage Note:You may substitute Department code or College code for the Organization code. Please chooseonly 1of the three available organization prompts.


Slide31 l.jpg

The BOS Expenses Universe – Report 1 Ledgers OL GL Universe

Click Run once you have your conditions finalized.


Slide32 l.jpg

The BOS Expenses Universe – Report 1 Ledgers OL GL Universe

Enter the one digit Chart Codetwo digit State Fiscal Periodfour digit State Fiscal Yearand Organization code. Then press OK.


Slide33 l.jpg

The BOS Expenses Universe – Report 1 Ledgers OL GL Universe

You will then get your basic report that you can format any way you want to.


Slide34 l.jpg

The BOS Expenses Universe – Report 1 Ledgers OL GL Universe

Use the Slice and Dice button to open the slice and dice panel.


The bos expenses universe basic formatting l.jpg
The BOS Expenses Universe – Ledgers OL GL Universe basic formatting

Use the slice & dice panel apply sorts, breaks, and sums. Once you have selected your format, you must click the Apply button!

A to Z sort

Sum or Calculator

Section Break

USAGE NOTE:Be sure you apply section breaks BEFORE you apply the sum/calculator. If you don’t, you may get strange format results.



3 options for saving your document l.jpg
3 Options for Saving your document Ledgers OL GL Universe

Option 1: File > Save

  • This is the Business Objects default. This saves the document to your hard drive. The location is under: My Documents > My Business Objects Documents > User Docs

    Option 2: File > Save As

  • This allows you to choose the location to save the document. This location could be on your hard drive, on a CD or USB drive or on a network share, for example. This is also the option used to save to a different file format – like an Excel .xls file.

    Option 3: File > Send To > Personal Documents

  • This sends the document to be stored on the Decision Support server. You can then retrieve the document from any location or computer.

  • This option is very useful when you have created the document at a workstation that is not your own and you want to be able to retrieve it back at your desk or you create the document at your desk and want to be able to retrieve it in a lab setting.


Slide38 l.jpg

Option 3: Send to Personal Documents Ledgers OL GL Universe

Select ‘File’

Select ‘Send To’

Select ‘Personal Documents’

You will then be able to retrieve this document from any desk.


Slide39 l.jpg

To send to Personal Documents Ledgers OL GL Universe

Give it a name and click on Save.


Slide40 l.jpg

Retrieving your Document Ledgers OL GL Universe


Slide41 l.jpg

To retrieve a Personal Document Ledgers OL GL Universe

Select ‘File’

Select ‘Retrieve From’

Select ‘Personal Documents’

You will then be able to retrieve a saved document.


Slide42 l.jpg

To Retrieve a Personal Document Ledgers OL GL Universe

Select the report you want then Click on “Open,”


Slide43 l.jpg

Custom Practice Lab Evaluation Ledgers OL GL Universe

  • Please go to the web and complete the course evaluation form at the below URL

    • http://www.ds.uillinois.edu/training/evaluations/custom_lab.asp

    • Please ask your instructor for the course id


Thank you l.jpg

Questions? Discussion? Ledgers OL GL Universe

Thank You!



What is solution library l.jpg
What is Solution Library? Ledgers OL GL Universe

DS Solution Library

  • DS Authored step by step instructions and sample Business Objects reports designed to meet specific reporting needs

    Solution Library link: http://www.ds.uillinois.edu/web/Home/SolLib.aspx


Slide47 l.jpg

Accessing Solution Library Ledgers OL GL Universe


Slide48 l.jpg

Available Solutions Ledgers OL GL Universe


What is qch l.jpg
What is QCH? Ledgers OL GL Universe

DS Query Clearinghouse

  • A place to share report templates

  • Any EDW user can post Business Objects files for others to use as a starting point

  • Share and work together!

  • Query Clearinghouse link: https://www.ds.uillinois.edu/Reports/Authentication/Login.aspx?ReturnUrl=%2freports%2fQCH%2fQCHBrowser.aspx



Query clearinghouse l.jpg
Query Clearinghouse Ledgers OL GL Universe


Slide52 l.jpg

Query Clearinghouse – Finance or HR Ledgers OL GL Universe

Want to play with these sample reports?

Want something similar for your use?

Then go visit Query Clearinghouse and get a sample report with which to begin!



Bos 3 tables views and universes l.jpg

Tables Ledgers OL GL Universe

New (1)

T_OL_EXPS_SRC_DETL

Modified (3)

T_JOB_LBR_DISTR_AUD_DETL

T_PAYR_ACCTG_DETL

T_JOB_LBR_DISTR

Views

Modified (1)

V_PAYR_ACCTG_DETL

Universes

New (1)

EDW – HRFIN BOS Expense

BOS 3 Tables & Views and Universes


Bos 3 table and view changes l.jpg
BOS 3 Table and View Changes Ledgers OL GL Universe


Bos 3 data model tables l.jpg
BOS 3 Data Model: Tables Ledgers OL GL Universe



Slide58 l.jpg

Data Model: Ledgers OL GL UniverseDefinitions for OL Expense Source Detail columns


Slide59 l.jpg

Data Model: Definitions Ledgers OL GL Universe


Slide60 l.jpg

Data Model: Definitions Ledgers OL GL Universe


Slide61 l.jpg

Data Model: Definitions Ledgers OL GL Universe


Slide62 l.jpg

Data Model: Definitions Ledgers OL GL Universe


Slide63 l.jpg

Data Model: Definitions Ledgers OL GL Universe


Slide64 l.jpg

Data Model: Definitions Ledgers OL GL Universe


ad