Michael Intravartolo
Sep 29, 2014
Updated: Jul 16, 2021
Technology Platform
Being designed to be interoperable with the Microsoft SQL Server® relational database platform, Microsoft Dynamics NAV is able to take advantage of the robust data management, query, reporting, analysis and integration tools which SQL Server offers.
Do you know whether Sage MAS 90 or MAS 200 support Microsoft SQL Server, and what the roadmap is for MAS 90/200 on Microsoft SQL Server.
The SQL Server technology platform enables rapid processing of large data volumes, real-time integration with other applications, and strong scalability in terms of users, data, and processes.
Reporting / Access to Information
Microsoft Dynamics NAV includes rich query tools (field filters, table filters, flow filters) for quickly producing snapshots of real-time data. Information can be drilled into in a 360 degree fashion from virtually anywhere in Microsoft Dynamics NAV.
Accuracy / Relevancy of Reported Data
Information entered into Microsoft Dynamics NAV is accurate, relevant, and current as soon as a data entry field is accepted and exited and so you can be assured that information is in real time. Ask how transactional data is updated in Sage MAS 90 and MAS 200 – is it real-time, or batch driven?
Microsoft Dynamics NAV data is kept in detail and immediately available. Data can be queried with any date parameters, whether they cross traditional accounting reporting periods or not. What happens to the detailed financial data in MAS 90/200 once a period is closed. Can MAS 90 or MAS 200 produce reports for a range that spans multiple periods?