ZFMBVSA_Budget vs Actual by Funds Center



The Pennsylvania State UniversitySIMBA Hands-On Guide TITLE \* MERGEFORMAT ZFMBVSA_Budget vs Actual by Funds Center ? 2020 The Pennsylvania State University? Copyright 2020 Labyrinth Solutions, Inc. All rights reserved. Labyrinth Solutions, Inc., the LSI logo, and CampusOneTM are trademarks of Labyrinth Consulting, Inc. SAP, R/3, SAP NetWeaver, and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP AG in Germany and other countries. Business Objects and the Business Objects logo, BusinessObjects, Crystal Reports, Crystal Decisions, Web Intelligence, Xcelsius, and other Business Objects products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of Business Objects S.A. in the United States and in other countries. Business Objects is an SAP company.ZFMBVSA_Budget vs Actual by Funds Center ?Overview?Transaction Description:This?tile displays the aggregated amounts per cost object, starting with the budget amount compared with the posted commitments and actuals. ?Scenario Description:In this scenario, we will show budget vs. actual for business area 1620, showing various drilldowns by funds center, fund and funded program.?Penn State?Purpose:This?transaction allows a user to choose cost objects (fund, funds center, functional area, funded program) to compare budget vs. actual. The reports shows budget compared against posted commitments and actuals, to arrive at the available balance. It is sorted by commitment item groupings. Process Steps?Fund Center: Selection StepActionThe Budget vs. Actual by Fund Center tile has been clicked to open the Fund Center: Selection screen.?Fund Center: Selection StepActionSets have been set up for each business area.? You can type the busness area number or you can click on the Possible Values button for a listing of the Funds Center Sets. 1.1620 is typed into the Funds Center field.? StepActionFund, Functional Area and Funded Program are intentionally left?blank. This will pull all of those items.The fiscal year is 2020 and fiscal periods 1-16. This includes the 12 periods in Fiscal year 2020, plus the 4 post closing periods that are used for year end.?Fund Center: SelectionStepAction2.The Execute button is clicked.?FM Bdgt vs Act by Fund Center StepActionColumn headings:BudgetCommitmentsActualsCommit+ActAvail Balance (Budget minus Commit+Act)Row headings are Commitment Item Groupings:Total RevenueTotal ExpenseNet Income (Total Revenue minus Total Expense) ?FM Bdgt vs Act by Fund Center StepActionClicking on the Options/Office Integration button will freeze the Page header and the lead column.?FM Bdgt vs Act by Fund CenterStepAction3.The Expand node is clicked.?FM Bdgt vs Act by Fund Center StepActionYou can see which commitment items are included in the sum of salary expense by Budget, Commitments, Actuals, Commit+Act, and Avail Balance. ? StepActionNow Collapse the group by clicking on the “-“ sign. 4.The Collapse button is clicked.?FM Bdgt vs Act by Fund CenterStepAction5.The 75,732 Commit+Act?field is double-clicked.?FM Bdgt vs Act by Fund Center StepActionChoose Search Actual Documents <=10,000. This means that we expect the results to return fewer than 10,000 records. This shows you detailed transactions that make up the 75,732.6.The Search Commitments/Actuals <= 10,000 option is clicked.?FM Bdgt vs Act by Fund CenterStepAction7.The Choose button is clicked.?Document JournalStepAction8.The 4100000050?line item?is double-clicked.?SRM Standard PO 4100000050 Created by SRM Conversion user StepActionThis shows you transaction details for document 4100000050, a Purchase Order. ?SRM Standard PO 4100000050 Created by SRM Conversion userStepAction9.The Back button is clicked.?Document JournalStepAction10.The Back button is clicked.?FM Bdgt vs Act by Fund CenterStepAction11.The 13,512 Budget field is double-clicked.?FM Bdgt vs Act by Fund Center StepActionChoose Search Budget Documents since these would be budget transactions. This shows you detailed transactions that make up the 13,512.12.The Search Budget Documents?option is clicked.13.The Choose button is clicked.?Selection List for Change DocumentsStepAction14.The 10000027315 Change Doc?field is double-clicked.?Change Document StepActionThis shows you transaction details for document 1000027315, a budget entry document.?Change DocumentStepAction15.The Back button is clicked.?Selection List for Change DocumentsStepAction16.The Back button is clicked.?FM Bdgt vs Act by Fund CenterStepAction17.The Functional Area button is clicked.?FM Bdgt vs Act by Fund Center StepActionThis shows you all of the functional areas in this set that have activity. ?Click on 500000 Student Services. This shows the activity for Student Services only.18.The 500000 Student Services button is clicked.?FM Bdgt vs Act by Fund Center StepActionYou can do this for all functional areas. Note how the headings change at the top.?FM Bdgt vs Act by Fund Center StepActionClick on the top node to view total selection again.19.The Functional Area button is clicked.?FM Bdgt vs Act by Fund CenterStepAction20.The Fund button is clicked.?FM Bdgt vs Act by Fund CenterStepAction21.The Expand?node is clicked.?FM Bdgt vs Act by Fund Center StepActionThis shows you all of the funds in this set that have activity. You can view this for each fund.22.The 1100000001 University general fund button is clicked.?FM Bdgt vs Act by Fund Center StepAction1100000001 is the University general fund. This shows the activity for that fund only. ? StepActionSee how the headings change at the top. ?FM Bdgt vs Act by Fund CenterStepAction23.The 1110000002 Unrestricted Gifts button is clicked.?FM Bdgt vs Act by Fund Center StepActionThis shows the activity for the 1110000002 Unrestricted Gifts fund only.?FM Bdgt vs Act by Fund Center StepActionClick on the top node to view total selection again.24.The Fund?button is clicked.?FM Bdgt vs Act by Fund CenterStepAction25.The Funds Center button is clicked.?FM Bdgt vs Act by Fund CenterStepAction26.The?Expand?node is clicked.?FM Bdgt vs Act by Fund Center StepActionThis shows you all of the funds centers in this set that have activity. ?Click on 162040900 Advising. This shows the activity for that funds center only.27.The 1620400900 Advising button is clicked.?FM Bdgt vs Act by Fund Center StepActionYou can do this for all functional areas. Note how the headings change at the top.?FM Bdgt vs Act by Fund Center StepActionClick on 1622701500 Web and CRM. This shows the activity for that funds center only. 28.The 1622701500 Web and CRM button is clicked.?FM Bdgt vs Act by Fund Center StepActionYou can do this for all functional areas. Note how the headings change at the top.?FM Bdgt vs Act by Fund CenterStepAction29.The 1620 World Campus button is clicked.?FM Bdgt vs Act by Fund CenterStepAction30.The Funded Program button is clicked.?FM Bdgt vs Act by Fund CenterStepAction31.The Expand?node is clicked.?FM Bdgt vs Act by Fund Center StepActionThis shows you all of the funded programs in this set that have activity. ?Click on 230000000201 Prof Dev - Bursar. This shows the activity for that funded program only. 32.The 230000000201 Prof Dev - Bursar button is clicked.?FM Bdgt vs Act by Fund Center StepActionYou can do this for all functional areas. Note how the headings change at the top.?FM Bdgt vs Act by Fund Center StepActionClick on 400001000837 World Campus Military. This shows the activity for that funded program only. 33.The 400001000837 World Campus Military button is clicked.?FM Bdgt vs Act by Fund Center StepActionYou can do this for all functional areas. Note how the headings change at the top.?FM Bdgt vs Act by Fund CenterStepAction34.The Funded Program button is clicked.?FM Bdgt vs Act by Fund Center StepActionNow let’s look at some further breakdowns of funds centers by fund and funded program.35.The?Back?button is clicked.?FM Bdgt vs Act by Fund CenterStepAction36.The Yes button is clicked.?Fund Center: Selection StepActionThis will give us all funds centers under department 1620200000. 37.1620200000 is typed into the Or value(s) field.38.1620299999 is typed into the to Funds Center field.?Fund Center: SelectionStepAction39.The Execute button is clicked.?FM Bdgt vs Act by Fund Center StepActionNotice that?this department contains?two funds centers. Click on each to view activity. 40.The 1620210001 Adult Lrnr Advocacy button is clicked.?FM Bdgt vs Act by Fund Center StepActionSee how the headings change at the top.41.The 1620210000 VP of Online Ed button is clicked.?FM Bdgt vs Act by Fund CenterStepAction42.The Fund button is clicked.?FM Bdgt vs Act by Fund Center StepActionTwo fund types appear. Click on each to see the activity of each on Funds Center 1620210000. ?We will choose 1110000008 Residuals/Royalties.43.The 1110000008 Residuals/Royalties button is clicked.?FM Bdgt vs Act by Fund Center StepActionSee how the headings change at the top. ?FM Bdgt vs Act by Fund CenterStepAction44.The 1110000002 Unrestricted Gifts button is clicked.?FM Bdgt vs Act by Fund CenterStepAction45.The Funded Program button is clicked.?FM Bdgt vs Act by Fund Center StepActionThis shows?five Funded Programs that appeared in the 1620200000-1620299999 funds center range. ?As you click through them, note that some do not contain data. This means that there is no combination of Funds Center 1620210000 with fund 1110000002 for the selected Funded Program (400001000833 and 590000000368). 46.The 400001000833 ADULT LEARNER STUDENT button is clicked.?FM Bdgt vs Act by Fund Center StepActionThis means that there is no combination of Funds Center 1620210000 with fund 1110000002 for the selected Funded Program (400001000833 and 590000000368). ?FM Bdgt vs Act by Fund CenterStepAction47.The 400001000837 WORLD CAMPUS MILITARY button is clicked.?FM Bdgt vs Act by Fund Center StepActionFunded Program 400001000837 shows activity. Note the header continues to display the Fund, Funds Center and Funded Program. Click through the remaining funded programs. ?FM Bdgt vs Act by Fund CenterStepAction48.The 400001000838 WORLD CAMPUS GRADUATE button is clicked.?FM Bdgt vs Act by Fund Center StepActionFunded Program 400001000838 shows activity. Note the header continues to display the Fund, Funds Center and Funded Program. Click through remaining funded programs. ?FM Bdgt vs Act by Fund CenterStepAction49.The 400001000839 WC ANNUAL FUND button is clicked.?FM Bdgt vs Act by Fund Center StepActionFunded Program 400001000839 shows activity. Note the header continues to display the Fund, Funds Center and Funded Program. Click through remaining funded programs. ?FM Bdgt vs Act by Fund CenterStepAction50.The 590001000368 WORLD CAMPUS MISC GE button is clicked.?FM Bdgt vs Act by Fund Center StepActionThis means that there is no combination of Funds Center 1620210000 with fund 1110000002 for the selected Funded Program (400001000833 and 590000000368). ? StepActionNow let’s look at one more funds center by funded program.51.The Back button is clicked.?Fund Center: Selection StepActionThis will give us all funds centers under department 1622700000. 52.1622700000 is typed into the Or value(s) Funds Center field.53.1622799999 is entered into the to Funds Center field.?Fund Center: SelectionStepAction54.The Execute button is clicked.?FM Bdgt vs Act by Fund Center StepActionIn the screens that follow, note that?it has: - one functional area: 400000 Academic Support - one fund: 110000001 General Fund - one funds center: 1622701500 Web and CRM - and several Funded Programs. 55.The Functional Area button is clicked.?FM Bdgt vs Act by Fund CenterStepAction56.The Fund button is clicked.?FM Bdgt vs Act by Fund CenterStepAction57.The Funds Center button is clicked.?FM Bdgt vs Act by Fund CenterStepAction58.The Funded Program button is clicked.?FM Bdgt vs Act by Fund Center StepActionClick through the various funded programs to see activity. Note that the NOTRELEVANT Funded Program is included, as its part of Funds Center 1622701500. 59.The 230000000223 Prof Dev -MKT Web button is clicked.?FM Bdgt vs Act by Fund Center StepActionFunded Program 230000000223 shows activity. Note the header continues to display the Fund, Funds Center and Funded Program. Click through remaining funded programs. ?FM Bdgt vs Act by Fund CenterStepAction60.The 800000001332 MKT Project and Port button is clicked.?FM Bdgt vs Act by Fund Center StepActionFunded Program 800000001332 shows activity. Note the header continues to display the Fund, Funds Center and Funded Program. Click through remaining funded programs. ?FM Bdgt vs Act by Fund CenterStepAction61.The NOTRELEVANT NOTRELEVANT button is clicked.?FM Bdgt vs Act by Fund Center StepActionFunded Program?NOTRELEVANT shows activity. Note the header continues to display the Fund, Funds Center and Funded Program. Click through remaining funded programs. ?FM Bdgt vs Act by Fund CenterStepAction62.The?Funds Center?button is clicked.?FM Bdgt vs Act by Fund CenterStepAction63.The More button is clicked.?FM Bdgt vs Act by Fund CenterStepAction64.The Save button is clicked.?FM Bdgt vs Act by Fund CenterStepAction65.The Text with Tabs?radio button is selected.66.The Continue button is clicked.?FM Bdgt vs Act by Fund CenterStepAction67.The Possible Values button is clicked.?FM Bdgt vs Act by Fund CenterStepAction68.TEST is typed into the File Name field.69.The Save as type?dropdown is clicked.?FM Bdgt vs Act by Fund CenterStepAction70.The EXCEL Files (*.xls)?option is clicked.?FM Bdgt vs Act by Fund Center StepActionMake sure the Save a copy to the native file system is clicked.?FM Bdgt vs Act by Fund CenterStepAction71.The Choose button is clicked.?FM Bdgt vs Act by Fund CenterStepAction72.The Generate button is clicked.?FM Bdgt vs Act by Fund CenterStepAction73.The OK button is clicked.?FM Bdgt vs Act by Fund Center StepActionWe end up getting?getting the file?from the browser's downloads. Open the XLS file.74.The TEST.xls button is clicked.?TEST - Excel StepActionView the report in Excel, then close the Excel file to return to Selection Screen.?FM Bdgt vs Act by Fund CenterStepAction75.The?Exit?button is clicked.?FM Bdgt vs Act by Fund CenterStepAction76.The Yes button is clicked.?Fund Center: Selection StepActionYou are able to run these reports with any combination of Fund, Funds Center, Functional Area, or Funded Program as noted on this Selection screen. ?Disclaimer?Alternative Format Statement This publication is available in alternative media upon request.??Statement of Non-Discrimination The University is committed to equal access to programs, facilities, admission, and employment for all persons. It is the policy of the University to maintain an environment free of harassment and free of discrimination against any person because of age, race, color, ancestry, national origin, religion, creed, service in uniformed services (as defined in state and federal law), veteran status, sex, sexual orientation, marital or family status, pregnancy, pregnancy-related conditions, physical or mental disability, gender, perceived gender, gender identity, genetic information, or political ideas. Discriminatory conduct and harassment, as well as sexual misconduct and relationship violence, violates the dignity of individuals, impedes the realization of the University’s educational mission, and will not be tolerated. Direct all inquiries regarding the nondiscrimination policy to Affirmative Action Office, The Pennsylvania State University, 328 Boucke Building, University Park, PA 16802-5901; Email: aao@psu.edu; Tel: 814-863-0471. ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download