BVxL - Excel Reporting for Microsoft® Dynamics NAV 2009
- Overview
The 300 data tables in Dynamics NAV are diverse yet they can make it difficult for users to produce reports. Profile can now offer our customers greater reporting capabilities with BVxL. BVxL is unique in providing two elements, a Data Manager and an Excel Report Writer.
MiraclePay Payroll for Microsoft Dynamics NAV
The Data Manager enables the complicated table and field structures of Dynamics NAV to be presented in simple easy to understand 'Reporting Tables or 'Data-Marts''. All the problems of joining tables and understanding what field names mean are eliminated enabling even non-technical users to build reports in Excel, an environment they know well, quickly and easily.
BVxL has three different types of reporting tool all of which are accessed from within Excel:-
A list builder for variable length and variable content reports, such as Aged Debt
-
A linked cell builder for static format reports with data which varies monthly such as Budget Variance or Month End Management reports
-
An enhanced Pivot Builder for quick and easy analysis reporting
BvxL's Data Manager makes report writing simple for non-technical users. There is no need to download data and no need to understand Dynamics NAV's tables:-
You only need to design a report once as the data in the report updates directly from NAV, saving time, effort and avoiding keying errors: Changing any of the variables such as Fund or Accounting Period will cause the report to refresh dynamically.
-
Drill down on cells to see transaction details: You can click on any cell to drill down to the individual transactions making up the balance in the cell.
-
Display your data graphically : You can highlight any area within your spreadsheet and represent it graphically. As you change any variable, the graphs update immediately.
The BVxL Excel Report Writer has been designed to provide a simple but flexible solution to all your reporting requirements. BVxL provides you with the ability to see, at a glance, how your business is performing and what changes could be made to improve profitability.
The Reporting Module provides three different types of report building tool to suit any layout, Cell Builder, List Builder and Pivot Builder.-
Cell Builder - for static layouts such as budget variance reports from multiple data sources or different types of data
-
List Builder - for variable length reports such as Aged Debt lists, Product Lists etc.
-
Pivot Builder - for sales analysis and quick ad hoc reporting
BVxL has very powerful KPI reporting features as it can draw together information from many different tables onto a single summary spread-sheet. BVxL gives large and small businesses quick and easy access to essential KPI's.
The benefits of BVxL for your business-
Produce month end report packs at the press of a button - simply change the date and all the figures are updated automatically
-
Create ad-hoc reports that can be manipulated quickly and easily to provide instant management information
-
Display any information both as a spread-sheet and graphically, providing easy to understand summaries for month end board meetings
-
If you see an unexpected variance you can drill down in any cell on the spread-sheet to see what transactions make up the balance in the cell
-
Remove the need to manually re-key data as BVxL draws on live data, saving valuable time and money and eliminating confusing, time-wasting keying errors
If you would like to discuss how BVxL could work for your company, or if you would like to arrange an upgrade please contact us or call us on 08000 195101 to discuss this with a member of our team or your Account Manager.
-