nVision Reporting. Finance Systems Training. Rohin Whitford Finance Business Solutions – User Support & Training. Slide Directory. Slide # Topic 3 Agenda 4 Our systems 5 NS Financials overview 6 What is nVision 9-14 Layouts & Scopes 15-19 Recommended reports
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.
Finance Systems Training
Finance Business Solutions – User Support & Training
Slide # Topic
5NS Financials overview
6What is nVision
9-14Layouts & Scopes
20-23Drill down options
26-31 Scheduling reports in NS Financials
34Further support & guidance
General Ledger updates overnight
HRMS / Payroll
* No Commitment Control
(monthly interface from PeopleSoft
PS/nVision retrieves information from the NSF database and places it into a Microsoft Excel spreadsheet, in a form that helps you see the big picture, explore details, and make decisions.
You use familiar Excel commands to format and analyse the data.
With PS/nVision, you spend your time analysing results
rather than summarising data and entering it into
To specify the data you want to bring into Excel, you use a report layout. A report layout is an Excel spreadsheet used as a template to define how a report looks and the type of information that goes into the spreadsheet’s different cells. A layout does not contain data from the database. Rather, it specifies what data should be mapped directly into your report. Once a library of report layouts has been created, select an existing layout that best suits your needs. At UNSW Layouts are preset – you cannot create your own.
A report scope allows you to create multiple instances of a report using a single report layout and report request. Using a scope, each report instance contains data specific to an individual field value, such as a business unit, department, account or project, or to a group of values, such as a tree node that summarises all sales departments. In this way, each report instance can share the same layout, while containing data unique to these field values. You might run three instances of an expense report that share the same layout but contain the details of one division each.
Scope is usually a project id or department
How much I have spent this year against my budget?
What I have spent on?
How much I have spent on individual accounts?
What are the transactions?
Source – To identify the information (the following in red provide further drilldown options):
AM – Asset Management (Asset Management)
AP – Accounts Payable (AP Vouchers excl Procurement Cards or Procurement Card Transactions)
AR – Accounts Recievable(Billing Line Details)
BI –Billing Information (Billing Line Details)
PO – Purchase Orders (Purchase Order Details)
ZPA – Accrual Journal Lines (Accrual Journal Lines)
ZPC –Payroll Encumbrance (HRIS Payroll Encumbrance)
ZPY – Payroll Salary (HRIS Payroll Salary)
The following are some of the common Source Codes that does not provide further drilldown options
ALO – Allocation process
EOM – End of Month Journal (It can be either Actuals or Accruals)
GST – GST Adjustments
INT – Interest Distribution (System generated)
OLE – Online Encumbrance (Commit.) Entry Journal
ONL –Online Journal Entry
PRT – Payroll Tax (System generated)
SSJ – Spreadsheet Journal
Sundry Other Revenue - YTD
Actual Journal Lines
Account by Period
Billing Line Details
AP excl Procurement Card
PS19432 - Revenue
Billing Line Details
Non People Costs
First time users will need to select Preferences.
Ensure that the tick box labelled Enabled under the heading Process Request Notification is ticked.
Ensure the Process Bookmarks radio button is selected as well as the type of process you are scheduling (in this case nVision Report)
Select the report you want to schedule.
Choose the date & time you want the report to run – run larger reports overnight so that it reduces the load on the systems during business hours
Reports may also be scheduled (preferably overnight) in NS Financials via the Reporting Console and delivered by email