Create Custom Reports in Sage 100 ERP using Business Insights

By | January 4, 2013

The success of an enterprise system mostly depends on the variety of reports it can generate in order to fully scrutinize and make a correct business decision. At times, it so happens that the users tend to feel, that some reports are not as per their requirement and they want to modify them. To Custom Reports in Sage 100, Sage 100 ERP (earlier known as Sage 90/200 ERP) has provided a module “Business Insights”. 

With help of this module, reports can be created for every module, customized, or can even modify the existing reports by following below instructions.

In order to create a custom report, there are certain pre-requisites which Users needs to fulfill before starting:

  1. A user needs to have Business Insights installed on his Sage 100 System.
  2. A user needs to have at least one report in the Sage 100 system.
  3. Crystal Reports must be installed on a machine.

Let take an example, say we want to create a custom reports in Sage 100 which will show “Customer List”. Thus to create customized reports follow the below-mentioned steps.

  1. In Sage 100 ERP, Navigate to Business Insights -> Reporter-> Business Insights Reporter, and click on Create Report button on the Business Insights Reporter window. A window would appear containing all the customized reports created previously on the system. However, if a customized report does not exist, then the Welcome page of the Business Insights Reporter Wizard will launch. Proceed through the wizard to create a report. Click on next button, for creating a report.
  2. Give name and description to reports; a select module for which report will belong and click on Next button.
custom report in Sage 100
  1. Now the window will appear where a user needs to select the information they want to show in the report, after selecting the options click on Next button.
add custom report
  1. Now, select fields that you want to see on the report.
sage 100 custom report
  1. Select fields on which you want to sort the reports.
sage 100 erp custom reports
  1. Select the report group.
business insights report sage 100

Hence, Report creation is finished. In our next blog, we would be discussing adding features to report such as filter, security etc.

About Us
Greytrix is a one stop solution provider for Sage ERP and Sage CRM needs. We provide complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third party add-on development and implementation expertise.

Greytrix has some unique solutions of Sage 100 integration with Sage CRM, and along with Sage 100 Migration from Sage 50 USSage IntacctQuickBooks, Sage Business Vision and Sage Business Works. We also offer best-in-class Sage 100 customization and development services to Sage business partners, end users, and Sage PSG worldwide.

For more details on Sage 100 Services, please contact us at We will be glad to assist you.