Core Features and Excel Reporting Interface
Easy yet powerful reporting that integrates seamlessly with your accounting system (ERP) and Microsoft Excel®. General Ledger information is automatically organized into six fundamental categories allowing you to quickly build the financial reports your organization needs. Included out of the box are the following core features:
- Control Panel – easily select and view your report based on any financial category
- Report Check – finds missing accounts and other chart-of-account mapping problems
- Report Analyzer – calculates and finds variances on your reports
- Drill Down Analyzer – drill to accounts, G/L transactions, journal entry, G/L details
- Drill Compare – drills into multiple columns of a report for easy account level comparison
- Drill Across – identify trends based on time or account segment
- Drill To A/P – view accounts payable vendor history by invoice or payment and see purchase order details (select systems).
- Main Menu – administer user security and settings, view your chart of accounts, configure and maintain the system
Adds functionality to define jobs and related tasks that can be applied to reports. Each job can be configured to automatically e-mail, save, or print the reports selected. This is used to easily distribute a set of reports to various users based on their unique requirements. It can also generate a set of identically formatted reports across multiple files and worksheets which can be used as budget input templates.
Multiple Company / Database
Adds functionality to combine and consolidate information in reports that span across multiple databases and companies. This can also be used to combine information from companies with different charts of accounts and account formats.
The Currency Converter enables the user to convert reports to any selected currency. Ideal for organizations with multiple companies that have different functional currencies and that need to be consolidated. Ending and average conversion methods can be applied to the companies and account ranges defined. Different conversion rates can also be applied to actuals and each budget defined. The Currency Converter can be used with unit or statistical accounts to convert between different units of measure, i.e. miles to kilometers or pounds to kilograms.
Lead Sheet Generator
This feature produces a detailed “lead sheet” report from a parent report. The lead sheet report displays each line from the parent report along with a listing of the underlying accounts and related balances below each line. The lead sheet can be formatted to be grouped by company/database and/or by segment. The lead sheet report is ideal for auditing purposes, and for distribution of highly detailed reports to users.
The Vivid Reports Basic User license includes the core functionality and features of the software plus all of the modules purchased. This user type can view and analyze reports; however they do not have the ability to define new report formats, report definitions, or budget. The number of Basic Users licenses purchased controls the number of user profiles that can be defined within Vivid Reports. A Basic User license is required for each person in the organization who will be logging into or using the Vivid Reports software. The number of Basic User licenses purchased also determines the volume discount rate that will be applied.
Add Report Builder Functionality
Adds the functionality to create new report formats and report definitions to a Basic User license. These features include the Row and Column Definition, Filter Control, and Filter Builder screens. Each installation of Vivid Reports must have at least one Report Builder license in order to create and manage reports.
Add Budget Input Functionality
Adds the functionality to enter and save budget information into the Vivid Reports database to a Basic User license. This includes the Budget Save, Budget Distributor, Comment Tracking, and Budget History Tools.
Database Components and Server Engine
The Vivid Reports Server consists of the database and server side components that must be installed on a server running Microsoft SQL Server. This component is required for Vivid Reports to function. There are additional server components required to enable the budgeting engine when Budget Input users are selected. Vivid Reports is compatible with Microsoft SQL Server version 2000, 2005, 2008, and 2008 R2. 32-bit and 64-bit are supported.
Update Scheduler for Server
Enables scheduled data updates from the ERP to Vivid Reports. For example nightly updates can be scheduled to run. Manual updates can be performed on demand as required.
Drill to Document Image
This module is used in conjunction with compatible image capturing software to display a transaction’s source document image within Vivid Reports when drilled down upon.
Drill to Payroll
This module opens a window from the General Ledger payroll entries back to the organization’s Payroll information. (select systems)
GP Analytics Functionality
For organizations using the Dynamics GP Analytical Accounting module, this module will allow users to treat the Code dimensions like segments within your chart of accounts and create reports based on them. When drilling down to transactions users will be able to view Codes, Numeric, Date and Boolean information.