How to use Business Insights Explorer in Sage 100 for faster operational reporting 

Organizations running Sage 100 often depend on accurate, timely data to manage operations, monitor sales activity, and make informed financial decisions. However, many teams still rely on static reports or manual data exports when trying to answer common business questions such as invoice trends, customer activity, or sales by region. 

This approach can slow down analysis and make it difficult for operational leaders to quickly access the information they need. 

Business Insights Explorer is designed to address this challenge. As part of the Business Insights module in Sage 100, it provides an interactive reporting interface that allows users to explore live system data, filter results, and customize views without requiring technical reporting expertise. 

In this article, we will walk through how Business Insights Explorer works, the core features that make it useful for operational reporting, and how organizations can use it to access and analyze Sage 100 data more effectively. 

Understanding Business Insights Explorer in Sage 100 

Business Insights Explorer is an interactive data exploration tool within Sage 100 that enables users to view, organize, and analyze system data from multiple tables in a grid-based interface. If you want to understand how Business Insights Explorer fits into the broader Sage 100 reporting ecosystem, explore our Ultimate guide to Sage 100 reporting and analytics.

Instead of running static reports, users can interact directly with the data. They can change which fields are displayed, reorganize columns, apply filters, and group information in real time. This allows users to quickly adapt their view of the data based on the business question they are trying to answer. 

The tool typically presents data using two related grids: 

• The upper grid displays the primary dataset, such as invoice history or customer activity. 
• The lower grid displays related records tied to the selected row in the upper grid. 

For example, when reviewing customer invoice history, the upper grid may show invoice-level information such as invoice number, customer name, date, and total amount. Selecting a specific invoice automatically updates the lower grid to display the associated line items. 

This parent-child structure allows users to move seamlessly from high-level financial information to detailed transaction-level insight without opening multiple reports or screens. 

For many organizations, this capability significantly improves the ability to analyze operational data directly within Sage 100. If you’re new to the tool, start with our overview of Sage 100 Business Insights Explorer to understand its core features and use cases before diving into the workflow below.

How to use Business Insights Explorer to analyze invoice data 

To illustrate how Business Insights Explorer works in practice, consider a common operational scenario: reviewing historical customer invoices to understand sales activity. The Explorer interface allows users to quickly organize and analyze this information without building a custom report. 

The following workflow outlines a typical process for analyzing invoice data. 

Step 1: Open Business Insights Explorer and select a data view 

From the Business Insights module in Sage 100, launch Business Insights Explorer and select a dataset such as Customer History Invoices. This view pulls information from the invoice history tables and displays it in the Explorer interface. 

Step 2: Review the two-grid layout 

The Explorer window typically displays two grids. 

• The upper grid shows high-level records such as invoice numbers, customer names, dates, and totals. 
• The lower grid displays related detail records tied to the selected invoice, such as line items or products sold. 

Selecting a record in the upper grid automatically updates the lower grid to show the related information. If you want to customize this detail view, such as adding fields, calculated metrics, or formatting data, see our guide on configuring the secondary grid in Sage 100 Business Insights Explorer.

Step 3: Customize the fields displayed on screen 

Users can adjust the view to focus on the most relevant data. 

• Drag columns to rearrange them. 
• Remove unnecessary columns by dragging them off the grid. 
• Add fields through the column settings or field selection tool. 
• Include fields from related tables, such as customer master data. 
• Add user-defined fields if they exist in the system. 

For example, an accounts receivable manager might simplify the view to show only customer name, invoice number, invoice date, and invoice amount. 

Step 4: Filter data to focus on a specific subset 

Explorer includes multiple filtering tools that allow users to narrow the dataset. 

• Apply filters from the toolbar. 
• Filter directly from a column value. 
• Combine multiple filters to refine the results. 

A user could filter invoices to display activity for a specific customer or restrict results to a certain invoice date range. 

Step 5: Group records to identify trends 

Grouping helps organize data into meaningful categories. 

• Drag a column header into the grouping panel. 
• Group data by attributes such as customer name, ship-to location, or state. 

Grouping by customer, for example, allows users to quickly evaluate total invoice activity per account. 

Step 6: Calculate subtotals and grand totals 

Totals can be calculated directly within the grid. 

• Right-click in the totals area. 
• Choose an aggregation option such as sum. 

This allows users to calculate subtotals for each group and display an overall grand total for the dataset. 

Step 7: Save the configuration as a reusable view 

Once the desired layout and filters are configured, users can save the setup. 

• Save the configuration as a custom view. 
• Choose whether the view should be private or public. 

Saving the view allows users to return to the same configuration without repeating the setup each time. 

This workflow demonstrates how Business Insights Explorer transforms Sage 100 data into an interactive reporting environment. Instead of generating multiple reports, users can explore, filter, and analyze information directly within the system. 

 

Creating and saving custom views for consistent reporting 

While ad hoc data exploration is valuable, many users frequently review the same type of information. Business Insights Explorer addresses this need by allowing users to save customized views. 

A view defines how the data is displayed, including: 

• Selected columns 
• Column order 
• Filters applied 
• Grouping settings 

Sage 100 includes a default Standard View, but users can create additional custom views tailored to their workflows. 

Custom views can be saved in two ways: 

• Private views: Only the user who created the view can access or modify it. 
• Public views: The view is available to other users within the system. 

This capability is particularly useful for organizations that want to standardize how operational teams analyze key datasets. 

For example: 

• Finance teams might create a view focused on invoice totals by customer. 
• Sales teams might create a view highlighting shipment locations or product sales. 
• Operations teams might build views that emphasize item quantities and order fulfillment data. 

Once a custom view is saved, users can quickly select it the next time they open Business Insights Explorer, ensuring consistent reporting without repeated setup. 

This small feature can significantly improve efficiency for teams that review the same operational metrics regularly. 

Filtering, grouping, and analyzing data interactively 

Beyond customizing fields and views, Business Insights Explorer includes several tools that allow users to analyze data directly within the interface. 

These features help transform raw data into meaningful insights without exporting information or running additional reports. 

Key analysis capabilities include: 

• Filtering data: Users can filter records by applying criteria through built-in filtering tools or directly from column values. 
• Grouping data: Columns can be dragged into the grouping panel to organize results by customer, location, product, or other attributes. 
• Drilling into records: Selecting rows reveals related records in the lower grid for deeper analysis. 
• On-screen totals: Subtotals and grand totals can be calculated directly within the grid. 

These capabilities make it easy to answer common business questions quickly. 

For example, a user reviewing invoice history might: 

• Filter invoices for a specific customer 
• Group results by customer name or shipping state 
• Calculate subtotals for each group 
• View a grand total for the filtered dataset 

Similarly, users analyzing item-level data can group the lower grid by item number or product category to understand which products are being sold most frequently. 

Because these adjustments happen instantly within the interface, users can experiment with different perspectives on the data without running multiple reports. 

This flexibility makes Business Insights Explorer especially useful for operational analysis and day-to-day decision-making. 

Exporting data for further analysis and reporting

Although Business Insights Explorer offers powerful in-system analysis tools, many organizations still need to share data outside of Sage 100. 

To support this requirement, the Explorer interface includes built-in export functionality that allows users to send the current data view to external formats. 

Common export options include: 

• Microsoft Excel 
• Microsoft Word 
• Other supported file formats 

Exporting is simple. Once the desired filters, columns, and grouping settings are configured, users can export the data directly from the Explorer interface. 

This approach ensures the exported dataset reflects exactly what is currently displayed on the screen. 

For organizations that rely on Excel for additional modeling or reporting, this capability provides a convenient bridge between Sage 100 operational data and external analysis tools. 

It also allows teams to distribute formatted datasets to managers, analysts, or external stakeholders when necessary. 

However, the primary advantage of Business Insights Explorer is that much of the analysis can be performed directly within Sage 100, reducing the need for frequent exports. 

When organizations benefit most from Business Insights Explorer 

Business Insights Explorer is particularly valuable for organizations that need faster access to operational data without building complex reports. 

Several scenarios commonly benefit from this tool. First, companies with frequent reporting requests can reduce reliance on static reports by allowing business users to explore data themselves. Second, teams responsible for sales or customer activity monitoring can quickly analyze invoice history, customer performance, or shipping trends. Third, organizations that maintain custom fields or extended data structures can easily incorporate that information into Explorer views. Finally, finance teams responsible for invoice review or revenue analysis can use filtering and grouping features to evaluate financial activity across customers, products, or locations. 

In each of these cases, Business Insights Explorer enables faster access to information and reduces the time spent building or requesting new reports. 

Why work with Rand Group for Sage 100 reporting and optimization

Sage 100 includes powerful reporting capabilities, but many organizations only use a fraction of what the system can deliver. Tools like Business Insights Explorer are often underutilized because reporting workflows are not fully configured or teams have not been trained on how to use them effectively.

Rand Group helps organizations get more value from their Sage 100 environment by aligning reporting tools with real operational needs. Our Sage consultants combine deep Sage expertise with practical experience in finance, operations, and ERP reporting.

We support Sage 100 clients with:

• Reporting optimization to improve visibility into financial and operational data
• Business Insights configuration to support real-world reporting workflows
• Custom reporting and dashboards when organizations require more advanced analytics
• User training and process improvements to help teams work more efficiently with Sage data

By improving how teams access and analyze ERP data, organizations can move beyond static reports and make faster, more informed decisions.

Whether you are implementing Sage 100, expanding reporting capabilities, or improving operational visibility, Rand Group provides the expertise needed to help your organization get more from its ERP investment.

Frequently asked questions about Business Insights Explorer in Sage 100

Next steps 

Business Insights Explorer is one of the most practical reporting tools available within Sage 100. By allowing users to explore system data interactively, customize views, and analyze information in real time, it helps organizations make better use of the data already stored in their ERP system. 

However, many companies only use a fraction of the reporting capabilities available in Sage 100. Proper configuration, training, and reporting strategy can significantly improve how teams access and interpret operational data. 

Rand Group works with organizations to optimize Sage 100 reporting environments, implement Business Insights tools, and ensure teams can access the information they need to support day-to-day operations and strategic decision-making. 

If your organization is looking to improve visibility into Sage 100 data or streamline operational reporting, our Sage consultants can help you evaluate your current setup and identify opportunities for improvement. Reach out to Rand Group to start the conversation.