PeopleSoft NVision 8

2y ago
18 Views
2 Downloads
598.89 KB
10 Pages
Last View : 18d ago
Last Download : 2m ago
Upload by : Gideon Hoey
Transcription

PeopleSoft FinancialTraining ManualPeopleSoft nVision 8.x

Table of ContentsNavigationComments2 Introduction to nVision3 Chapter 1: nVision Basics TimeSpans Trees nVision Home Page nVision Components Choosing the Layout Type Creating Matrix Layouts Types of Information Checklist Layout Options Summary Tab Data Flow Source Filter nPlosion Labels Variables Creating a Report Request nVision Options Combining Text with nVision Variables Organizing Report Instances and Formatting Dates/Times Attaching a Macro to a layout - 3031 Chapter 2: Scope and nVision Variables Understanding Scope Defining a Scope Scope-Related Variables Scopes with Multiple Fields3232333435 Chapter 3: DrillDown DrillDown Options Matrix DrillDown363738 Chapter 4: Tabular Layouts Understanding Tabular Reports Defining Tabular Reports Pivot Tables39394041 Chapter 5: Web-based nVision Define Report Request Define Report Request Run Report Request Report Manager HTML Drill-Down AP Detail42434445464748 Chapter 6: Report Books nVision Report Books4949PeopleSoft 8.x Training Manual – 2006 SpearMC

Introduction to nVisionPeopleSoft nVisionNavigation Welcome to the PeopleSoft nVision for General Ledger training course. Wehave designed this course to guide you through PeopleSoft nVision, apowerful and flexible spreadsheet based financial reporting tool that you canuse within the PeopleSoft applications. Along with nVision basics, thiscourse introduces several advanced topics such as Report Labels, nPlosion,Scope, Summary Trees and DrillDown. PS/nVision is an end user reporting tool that is both a Windows and webbased application. PeopleSoft 8.x delivered the ability to run and viewPS/nVision reports via the web, while maintaining the Windows baseddesigner. Operating inside of Microsoft Excel, PS/nVision uses information retrievedby PeopleSoft Query as the data source for its reports and uses theintersections in the Excel spreadsheet as a base when creating reports.PS/nVision combines the mathematical and formatting features of Excel withadvanced reporting features such as scope, variables, and labels. As a reporting tool, PS/nVision is multifaceted. Because this reporting tool isso complex, it is highly recommended that you be familiar with PeopleSoft,Excel, Trees, and PeopleSoft Query.Comments3PeopleSoft 8.x Training Manual – 2006 SpearMC

nVision BasicsNavigation Log onto PeopleTools (Win) Go nVision Log onto PeopleSoft (Web) Setup Financials Common Definitions Calendars/Schedules TimeSpansCommentsObjectives By the end of this chapter, you will be familiar with the basics of PeopleSoft nVision. Wewill review the basic components of PeopleSoft nVision, including: 4Defining TimeSpans to specify what period(s) you want to report onDefining a layoutDefining a report request.Running an nVision reportPeopleSoft 8.x Training Manual – 2006 SpearMC

nVision Basics – Time SpansNavigation Log onto PeopleSoft (Web) Setup Financials Common Definitions Calendars/Schedules TimeSpansComments5Time Spans TimeSpans are used in PeopleSoft General Ledger to provide you with a method toeasily select and retrieve ledger balances for use in allocations, inquiries andPeopleSoft nVision reporting. The TimeSpan controls the number of periods forwhich data is extracted from the ledger table and summarized. Many TimeSpans areexpressed relative to the current period, so that they automatically adapt the contentof a report to the As of Date specified when the report is executed. Others aredefined for specific periods. Examples of TimeSpans that you may use are PER, to retrieve only activity for theperiod selected, or YTD, to include year-to-date amounts for the items selected. Youcould also use a TimeSpan named BAL to retrieve life-to-date amounts for balancesheet accounts. The calendar on above page is used to validate Absolute periods and years that youenter for a TimeSpan. These periods and years must exist on the calendar that youspecify on this panel. Balance Forward amounts and Adjustments are each stored inspecial calendar periods, therefore, they must be specifically retrieved in TimeSpans.Balance Forward amounts are stored in Period 0 while Adjustments are stored inPeriod 998.PeopleSoft 8.x Training Manual – 2006 SpearMC

nVision Basics – Home PageNavigation Log onto PeopleTools (Win) Go nVisionCommentsPS nVision Home Page When you open nVision, Microsoft Excel opens as well and you are presented withthe NVSUSER macro sheet. This worksheet is designed to be customized for eachnVision user. Note the additional drop-down menu options specific to nVision 12nVision: Options and Tasks specific to Layouts, Report Requests, ScopesDrill: Drill Options specific to the Report intersection of column and rowPeopleSoft 8.x Training Manual – 2006 SpearMC

nVision Basics – ComponentsNavigationLayoutReportRequestSales RevenueWalnut Creek Sales Rev.Atlanta Sales RevenueScopeChicago Sales RevenueWalnut Creek Sales DepartmentAtlanta Sales DepartmentChicago Sales DepartmentCommentsnVision Components There are three key components to the nVision report definition process which we willcover in detail in this chapter. They are: 13LayoutScopeReport Request The relationship between these components is illustrated above Pre-requisite: Nvision must be set properly on the client in order for Nvision reports towork on the workstation. Microsoft Excel must be installed on the client as well. A chart ofaccounts, and the current tree structure of all account rollups and entities are mandatory.PeopleSoft 8.x Training Manual – 2006 SpearMC

nVision Basics – Layout TypeNavigation Log onto PeopleTools (Win) Go nVisionTabular LayoutCommentsLayout Type All nVision layouts are classified as either matrix or tabular layouts. The major differencebetween these layout types is how they specify the data to retrieve. 14Matrix LayoutMatrix layouts have data selection criteria associated with each column and each row in thespreadsheet, creating a criteria matrix. The data retrieved for an individual cell is determinedby combining the criteria for its column and its row.Tabular layouts use a standard query to retrieve data. The columns in the report correspondto the fields selected by the query; the rows display the query result set. In general, matrix layouts are more appropriate for summarized reporting while tabularlayouts lend themselves to detailed reporting. For example, if you want to create a highlevel income statement showing total revenues, total expenses and net income, you wouldcreate a matrix layout. On the other hand, if you want to see a listing of all the journals fromyour Payroll system, you could create a tabular layout to do this. In this class we will focus on summarized reporting using matrix layouts. However, tabularlayouts will be covered briefly in a later chapter. The layout is a kind of template for defining how a report will look and what type ofinformation will go into the different cells of the spreadsheet. A layout can be used byseveral reports. It does not contain financial data from the database. You specify the links,or criteria, that will map the desired data directly into your report from the database at runtime.PeopleSoft 8.x Training Manual – 2006 SpearMC

nVision Basics – Creating a Matrix LayoutNavigationIncome StatementPERYTD Log onto PeopleTools (Win) GoRevenues nVisionExpensesNet IncomeWorksheet: LedgerColumn:TimeSpansRow:Field (Account)A led g er or a P S/ Que r y m ay be sp e ci fi e d to dir e ct n Vi si o n to th e a pp ro pri a te t a bl eto re tri e v e t h e des ire d b a l an c es. Wh en r e por ti n g fro m th e Pe opl e Sof t Gen e ralLed g er a p p li cat io n , a l ed g er i s n o rm a l ly us ed to r etr i e ve po ste d jou r n a l b a la n c es.nV ision au tom a t ica l ly kn o ws th e t abl e t o a cc e ss and the f iel ds to retr ie ve ba se don t he le dg er de fi n it io n . Al th o ugh th i s c o ur se wi l l f o cu s o n le d ge r r e po rti ng,que r y -ba se d re po rt s wi ll b e c ove r e d bri ef ly in a la ter ch a pt e r.CommentsCreating a Matrix Layout – Types of Information There are four common types of information you may want to include in your layout: Text and Excel Formulas: As with any spreadsheet, you may type text in any cell.Text is typically used for report headings, titles, labels, etc. You may also use anyExcel formula to perform calculations on your spreadsheet data. Formulas can beused to foot or cross-foot columns or rows, compute variances, calculate ratios, andso forth. Refer to the Microsoft Excel Users Guide for complete information onavailable formulas.Report Labels: nVision also has a Report Labels feature that enables you toautomatically place labels in a cell, based on fields in your database (such as anaccount description (DESCR) field). This is covered later in the course.nVision Variables: nVision variables are generally inserted into a report layout aspart of heading information. Because the value of these variables is determined atrun time they are best used for information which might change from report run toreport run. Examples include reporting date, the Operator ID of the person runningthe report, the name of a period, the name of a business unit requesting the report,and so forth.Establishing Criteria: Through criteria you specify the data you wish to extract fromyour PeopleSoft database and where to place it on the report. The criteria is enteredin rows and columns; each intersection of row and column criteria defines a dataelement to be retrieved. An intersection typically contains the following elements ofcriteria: 15The Ledger you wish to access or the name of the PeopleSoft Query whichdescribes the table and fields you wish to access.The TimeSpan you wish to include (optional with queries).The Field value(s) you wish to appear on the report (optional with queries).PeopleSoft 8.x Training Manual – 2006 SpearMC

nVision Basics – Creating a Matrix LayoutNavigation Log onto PeopleTools (Win) Go nVision New Layout Layout DefinitionCommentsCreating a Matrix Layout - Checklist This is the blank sheet that you will see. The blank sheet has 2 things that you shouldnotice. First column “A” is hidden. Second, Row “1” is hidden. This is where Nvisionplaces it’s people code. Do not place any text in these columns and rows. Begin by determining what are nVision Criteria and Excel text and formulas. Have arough diagram of what you want the final report to look like: column and rowheadings, excel formulas, etc. You can have nVision retrieve column or row headingsfor you, or you can type in the text you want. You can add the formulas after you add the nVision criteria. Checklist for Creating Reports The following checklist will be helpful if you have trouble getting started or loose track of thesequence of steps required to define an nVision report.Outline report specs on paper showing desired rows, columns, and headings.Clone an existing layout, if possible, instead of starting from scratch.If you desire multiple report instances, define a scope.Determine the naming convention for your layout, scope, request and instances.Determine at which levels (worksheet, column, row, or cell) you should specify the Ledger(s),TimeSpan(s), and Field(s) you want to use as your criteria.Identify existing Trees that may support your field criteria and use them instead of specifyingdetail values. Can you use nPlosion?Enter your text, formulas, variables, and criteria.Define your report request. Run your report. 16PeopleSoft 8.x Training Manual – 2006 SpearMC

Introduction to nVision PeopleSoft nVision Welcome to the PeopleSoft nVision for General Ledger training course. We have designed this course to guide you through PeopleSoft nVision, a powerful and flexible spreadsheet based financial reporting tool that you can use within the

Related Documents:

PeopleSoft nVision Training Email Distribution With Scopes Chapter 11 Page 1 Created by David Vandiver Email Distribution With Scopes nVision Scopes are useful for running a single nVision Report Request to several individual nVision Excel files (instances). Thes

Upon completion of the training, learners will be able to utilize the PS Financial application to: 1 nVision Reports 1.1 Explain what is an nVision report 1.2 Analyze the naming convention for an nVision report description 1.3 Describe the roles of trees with nVision

PeopleSoft Financials Long-Term Support Retail & Logistics 24 Hr Fitness: PeopleSoft Reporting Strategy Bekins: PeopleSoft Billing v8.9 Implementation Higher Ed & Government Art Institute: PeopleSoft Financials Training City of Seattle: Chart of Accounts Redesign SpearMC delivers Oracle/PeopleSoft services across numerous industry domains and .

nVision Reporting Overview nVision is the primary departmental reporting tool. It is an Excel add-on within the PeopleSoft Finance application. It delivers reports in an Excel spreadsheet and can be opened within the PeopleSoft application to allow for online

PeopleSoft Portal Solutions product family. PeopleSoft Enterprise Portal feature overview. PeopleSoft Enterprise Portal and PeopleTools. PeopleSoft Portal Solutions Product Family This section discusses the products that are part of the PeopleSoft Portal Solutions product family: PeopleSoft Enterprise Portal.

O:\Public Folder\Peoplesoft Training Materials\9.1 Documentation_Training Info\How To Run A Drill Down In PSF 9 1 USING A MAC.Docx Running an nVision Drill Down Report in PeopleSoft Financials 9.1 (USING A MAC) You may want to run a drill down on certain fields in your r

PeopleSoft Human Resource Management System (HRMS) provides support for general human resource functions. . Note that PeopleBooks and PeopleSoft query training books have been utilized to build this guide. . PS/nVision PS/nVision enables users to import information directly from query into predefined Ex

SETTING UP AUTOCAD TO WORK WITH ARCHITECTURAL DRAFTING STYLE You will need to make some changes to AutoCAD to use it as a drafting tool for architectural drawings. AutoCAD “out-of-the-box” is set up primarily for mechanical drafting: drawing small parts for machinery using the metric system because that is the type of drafting is the most practiced in the world. However, making drawings of .