Create Business insights – explorer in Sage 500

By | May 31, 2020

In current Sage 500 functionality, user can create Business insights explorer based on SQL View and also can navigate the business explorer into the Sage 500 Menu.

User can create the business explorer on any existing SQL View or new SQL View of Sage 500 database, the main pre-requisites is SQL View name needs to be start from prefix ‘vdv’. Example: vdvStockstatus, vdvVendorList.

Goto System Manager >> Maintenance >> Maintain Business Insights Views / Context Menus

a new or existing Business Insights view ID, or click the Lookup button to list all view IDs.

You need to set some of the fields on the screen and generate the business explorer.

  • View Name :

Enter the SQL View name or click the Lookup button to list existing view names.

  • Caption, Name and Description :

Type a caption, name and description to display for the view in Business Insights Explorer.

  • Goto Navigation Relationships tab

Use this tab to add and update navigation relationships between the business explorer and the destination views. A relationship needs to be specified for each unique destination view listed on the Preview the explorer.

In the last steps, you need to click save button or finish button to generate task id for the business explorer in Sage 500.

If you want to create a business explorer or for any other form of customizations feel free to contact us at

About Us

Greytrix – a globally recognized and one of the oldest Sage Gold Development Partner is a one-stop solution provider for Sage ERP and Sage CRM organizational needs. Being acknowledged and rewarded for multi-man years of experience, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third party add-on development and implementation competence.

Greytrix offers unique GUMU™ integrated solutions of  Sage 300 with Sage CRM,, Dynamics 365 CRM and Magento eCommerce along with Sage 300 Migration from Sage 50 US, Sage 50 CA, Sage PRO, QuickBooks, Sage Business Vision and Sage Business Works. We also offer best-in-class Sage 300 customization and development services and integration services for applications such as POS | WMS | Payroll | Shipping System | Business Intelligence | eCommerce for Sage 300 ERP and for Sage 300c development services we offer, upgrades of older codes and screens to new web screens, latest integrations using sData and web services  to Sage business partners, end users and Sage PSG worldwide. Greytrix offers 20+ addons for Sage 300 to enhance productivity such as GreyMatrixDocument AttachmentDocument NumberingAuto-Bank ReconciliationPurchase Approval SystemThree way PO matchingBill of Lading and VAT for Middle East. The GUMU™ integration for Dynamics 365 CRM – Sage ERP is listed on Microsoft Appsource with easy implementation package.

For more details on Sage 300 and Sage 300c Services, please contact us at, We will like to hear from you.