nVision: Beyond the GL
Creativity Enhances the Power of nVision
Posted on 1/11/2007 (originally published in print on 8/1/2004)
by Kenneth Creech
I admit it...I have a bias toward nVision. Blame it on my accounting background or the need to number crunch. In either case, have you ever met an accountant that didn't like a spreadsheet? When faced with creating new reports in PeopleSoft, I almost always turn to nVision. Of course nVision works great with General Ledger, but have you ever imagined using it to report on data from Asset Management, Payables, Receivables or other PeopleSoft modules?
What I like best about nVision is the ability to control output and format after reports are generated. For example, a typical SQR report with incorrect column-width formatting will deliver field output as a series of asterisks, forcing the developer to modify the SQR program and re-run the report. With Excel-based nVision, you simply expand the field width to fit your format criteria.
If you develop nVision reports, they are likely to be balance sheet, income statement, or expenditure-related report layouts, most commonly based on the matrix type of nVision layout.
Through detailed examples of a combination matrix/query-based layout, a layout using pivot tables, and a tabular report, we will dive into some of the advanced capabilities of nVision and expand your knowledge of PeopleSoft's financial reporting tool.
Query-Based, Matrix Report
The first report we will walk through is a report that on the surface appears to be a matrix report. The report, named Counts/Age, is illustrated in Figure 1. The format of the report appears as a typical nVision matrix report. The columns represent different years and the rows represent company product codes. Surprisingly enough, data populating this report comes from Asset Management.
To continue reading this article you must have a current VP1 Subscription.
