Sage Accpac Insight integrates with Sage Accpac ERP (and Sage Pro ERP) to create bottom-up budgeting, budget write-back, drill-down, multi-dimensional analysis and other advanced customization capabilities. Providing access to your critical operational and sales data, as well as customer, product, vendor, employee, geographic data and more, you can quickly integrate information into meaningful reports and distribute them across your enterprise in near real time while applying user-level security, ensuring that confidential information remains confidential.
From basic reporting capabilities to full-feature enterprise consolidations, Sage Accpac Insight offers a range of components designed to help you build a system according to your particular business requirements.
Author
Author is a wizard-driven tool that allows you to create new templates quickly and easily in Microsoft Excel for pixel-perfect reports. Once your reports have been generated, you have the full capabilities of Excel at your disposal to further format and generate additional charts and graphs. Author for Data Warehouse in conjunction with Sage Accpac Insight Data Warehouse adds functionality of Workbook Generator and Budget Express.
Viewer
Viewer allows you to run reports against the Data Link/Mart and present reports in Excel, extending the value of the data available through your Sage Accpac system. Featuring powerful cross-module drill-down capabilities, Viewer lets you drill down to supporting transaction detail and even "drill around" from one module into another, making it simple to view underlying transactions and subtotals. Viewer for Data Warehouse in conjunction with Insight Data Warehouse adds functionality of Workbook Refresher, runtime version of Workbook Generator, Budget Express user and Budget Express Writeback.
Web Deployment Server
Ideal for mobile and remote staff, Web Deployment Server offers you the ability to generate reports and publish them on the Internet or a company intranet. Authorized staff can view the reports through a standard Web browser. You can maintain near real-time reporting and provide drill-down capabilities without the need to install any software on users' computers beyond their Web browsers.***
Enterprise Budgeting**
Enterprise Budgeting can be used to create very complex models containing multiple worksheets. You can deliver templates for end-user data entry and manipulation, and consolidate input into a single Data Mart to prepare an end-user budget in a true bottom-up fashion.**
Consolidations**
Manage the consolidations process and create financial statements that illustrate key financial performance indicators. Consolidations produces merged accounts for statutory or management reporting purposes. Multiple unrelated databases can be consolidated into a single set of financial reports, so that employees, branch offices and partners can operate with a single, unified view of financial data at any time.****
Data Warehouse
Sage Accpac Insight Data Warehouse module is deigned to fit every business need, delivering a powerful financial reporting solution by optimizing and correlating your data into a single, easy-to-manage database.* The Data Warehouse module acts as a warehouse for your vital information, allowing you to extract only the key data you want to report on. By capturing only the data you need, you eliminate the time-consuming task of sifting through irrelevant information and can focus on business at hand. It also contains vital budgeting and scheduling capabilities, along with special security features to ensure that only authorized personnel have access to key data. Additionally, it includes replication capabilities that let you synchronize your data warehouse across multiple locations – making key information even more accessible to employees across the enterprise.
Universal Database Adaptor (UDA)**
Sage Accpac Insight can connect and integrate with other software applications via the UDA module. It integrates data from other applications and databases into your Sage Accpac Insight reporting system using ODBC connection. Using UDA, Sage Accpac Insight becomes your one-stop reporting and analytical solution for enterprise-wide data.**
Alerts**
Alerts delivers the information needed to create highly responsive, proactive, customer-facing organizations. It automates the reporting process in the enterprise by scheduling data warehouse filter updates, report generation and report refreshes. Scheduling makes it easy to automate the execution of reports by providing report database and period index parameters that are applied to the execution of each report. You can even schedule reports to run after business hours to take advantage of underutilized computing resources that typically sit idle during this time.**
* Requires the Author for Data Warehouse module.
** Requires the Data Warehouse module.
*** Requires the Viewer module on the Web server. Web Deployment Server is limited to 20 concurrent users.
**** Requires the Data Warehouse module and MS SQL Server database.
Create pixel perfect reports in minutes with complete drill down capabilities.
Deploy reports over the Web to key personnel throughout your company.
Create a budget model with multiple spread methods using a bottom-up budgeting
approach.
