FAQ’s

We’ve collected together some of the more common Frequently Asked Questions below. If your question is not covered here, please fill out the form at the bottom of the page and we’ll do our best to answer it for you.

PrecisionPoint is a reporting and analytics solution designed specifically for organisations running Microsoft Dynamics AX or NAV. It provides an out-of-the-box reporting environment with a broad range of end-user access options. Its data platform is built on Microsoft SQL Server technology. Its data integrity and financial accuracy is automatically monitored and guaranteed. We also provide Custom Solutions that extend beyond providing Microsoft Dynamics ERP solutions, to extracting and manipulating data from many other source systems to provide customers with the ability to easily analyse business processes and performance.
Microsoft SQL Server 2005, 2008, 2008 R2, 2012, 2014
Microsoft Dynamics NAV versions: NAV4, NAV2009, NAV2013, NAV2015, NAV2016 and NAV2017

Microsoft Dynamics AX versions: AX4, AX 2009, AX 2012 and AX7

PrecisionPoint’s principal focus is Microsoft Dynamics NAV and AX.

That said, it is possible to configure PrecisionPoint to integrate additional data external to Microsoft Dynamics alongside NAV or AX data. Customer examples include situations where a company runs multiple different ERPs and requires multi-company consolidation. Here, the base PrecisionPoint system is built on a NAV or AX ERP and then summary data from the other ERPs can be pulled in and presented in the same single PrecisionPoint environment.

It’s quick to deliver benefit! On average, the installation of the self-building core data warehouse platform takes about 2 to 3 days. After this time, the key users can access the system and start to browse the environment and sample a range of standard report templates.
This of course varies on the needs of the individual, some watch a couple of introductory training videos and are away. Others prefer to consume the training guides in full and/or attend a classroom workshop. PrecisionPoint recommend a single day’s introductory classroom training for all users. More advanced users may seek further workshops based on specific areas of reporting or analysis. All that is required to become a PrecisionPoint report designer is a basic understanding of Microsoft Office. As PrecisionPoint provides a simple A-to-Z view of the data, it is not at all necessary to know NAV or AX database tables names and relationships.
PrecisionPoint users can vary greatly. From the Management Accountant and the Financial Controller to the CFO and CEO; the BI analyst to the Sales Manager and Commercial Analyst; Supply Chain, Procurement, Project Managers. What it is important to say is the PrecisionPoint user doesn’t require a technical understanding of AX or NAV in order to get going. Some users simply want a handful of reports on a scheduled basis, others never want to stop asking questions and seeking their own answers.
At the core of the system is a data model built from bottom line profit back out to the originating source information in AX or NAV. For this reason, the first report which might typically be created is an analysis of profit. This can be at a globally consolidated level or down at a departmental or individual product or customer level. The system connects the audit path between the elements of the business which affect profit and the actual profit itself. So whether the first report is a financial P&L, a multi-dimensional view of sales performance or an analysis of costs and purchase orders, the source is the same. It is possible to generate more detailed breakdowns from high-level starting points very quickly.
PrecisionPoint recognises that all NAV or AX transactions ultimately have a financial impact. At the centre of the financial system is the General Ledger and it is from here that the financial result of an organisation is calculated. For this reason, PrecisionPoint places great importance on always being reconciled to the GL to the penny. Every debit and credit entry which ultimately hits the GL is dissected into its originating source entry table component parts. For example, a single line entry hitting a GL revenue code may be the resultant posting of a multiple line item invoice. PrecisionPoint automatically fetches and reconciles this detail into a single core table ready for immediate analysis. The process which achieves this is monitored by a software application called Guardian.
PrecisionPoint is optimised for report speed. An average report will take somewhere between zero and ten seconds to refresh. We have recently added a month-end module specifically targeted at financial operations teams working on period-end reporting. With rapid refresh times, PrecisionPoint is increasingly able to satisfy all analysis and reporting requirements of the finance team, without compromising accuracy.
PrecisionPoint helps give the SSRS user a significant head-start with each report-writing task or project. By organising the AX or NAV data into a singular reconciled format, PrecisionPoint allows the SSRS report developer the advantage of concentrating on the layout and presentation of the report rather than needing to concern themselves with complex table relationships. Consistency of report definition and design is improved where several report developers work from the same organised data source and financial accuracy is guaranteed.
Very probably yes. Where businesses already own a BI front end, they can choose to continue to use it against the holistic PrecisionPoint view of the NAV or AX data. Comparison can easily be made with an existing tool and the range of front end tools which PrecisionPoint provide. It may well be that certain information consumers prefer one access medium and others prefer another. This might typically mean a choice between working in Excel, accessing a web based report or simply receiving an email.
Office 2007, 2010, 2013, 365
With each new version release of NAV or AX, PrecisionPoint sets about ensuring that any new data structures are accommodated automatically by the PrecisionPoint transformation processes. This means that where an ERP upgrade occurs, the amount of work to re-write any existing reports, KPIs or BI dashboards is kept to a minimum. It is usually just a case a making minor edits in an existing report rather than needing to “start from scratch” by making brand new data connections. Many of our clients have found that PrecisionPoint adds significant value as a data validation tool during the core ERP upgrade process.
As soon as the first test transaction postings enter the new ERP system, assessment should be made of how easily that information can be viewed and accessed. This result of such an assessment could fundamentally affect the set-up of the data capture process. We would therefore strongly recommend that any BI or reporting platform should be treated as a fundamental part of any ERP implementation. Often the party implementing the core ERP overlook the BI and reporting needs of users so the earlier you plan for this the better.
You can. The recommended “best practice” however is to install PrecisionPoint on a dedicated server alongside the live NAV or AX production server. This allows each server to be optimised to its purpose.

[hs_form id=”13″]