How to resolve the PROVIDEX Error in Salesforce – Sage 100 ERP GUMU™ Integration

By | September 9, 2025
0 Comment

When integrating Salesforce with Sage 100 ERP using the GUMU™ Integration, users may sometimes face an issue during the import routine preview when a date filter (Last Sync Field – DateUpdated) is applied.

Instead of showing the required Sage 100 records, the system only displays the total record count.

Date Updated Filter
Date Updated Filter

This happens due to a missing configuration. Fortunately, the fix is quick by adding the keyword “PROVIDEX” in the ERP configuration settings, you can restore the correct record-level preview.

Issue Overview (Before Fix)

On preview records does not show
On preview records does not show
  • Import routine preview shows only the total record count.
  • No individual Sage 100 ERP records are displayed.

We’ll go step by step to solve this error

  • Navigate to the Configuration tab.
  • Click on the ERP Configuration Settings icon.
Configuration Tab
Configuration Tab
  • Locate the field named DB Type.
  • Enter PROVIDEX in the DB Type input field.
  • Save the configuration.
Add PROVIDEX text in DB type
Add PROVIDEX text in DB type
  • Again, navigate to the Import Routine.
  • Now, click the Preview button.
  • You should now see all Sage 100 ERP records displayed along with their total count.

After Fix

  • After adding PROVIDEX in DB Type, the preview now shows all records with counts.
Preview records showing successfully
Preview records showing successfully

The PROVIDEX error can cause confusion by hiding record-level details during import preview. Fortunately, the fix is simple: just update the DB Type field in ERP Configuration with the keyword PROVIDEX.

This ensures that both the total record count and detailed records are visible, making the import process smooth and error-free.

By following the steps above, you can easily resolve the PROVIDEX error in Salesforce – Sage 100 Integration. If you still have queries or any related problems, don’t hesitate to contact us at salesforce@greytrix.com. More details about our integration product are available on our website and Salesforce AppExchange.

We hope you find this blog resourceful and helpful. However, if you still have concerns and need more help, please contact us at salesforce@greytrix.com.

About Us

Greytrix – a globally recognized and one of the oldest Sage Development Partner and a Salesforce Product development partner offers a wide variety of integration products and services to the end users as well as to the Partners and Sage PSG across the globe. We offer Consultation, Configuration, Training and support services in out-of-the-box functionality as well as customizations to incorporate custom business rules and functionalities that require apex code incorporation into the Salesforce platform.

Greytrix has some unique solutions for Cloud CRM such as Salesforce Sage integration for Sage X3, Sage 100 and Sage 300 (Sage Accpac). We also offer best-in-class Cloud CRM Salesforce customization and development services along with services such as Salesforce Data Migration, Integrated App development, Custom App development and Technical Support business partners and end users. Salesforce Cloud CRM integration offered by Greytrix works with Lightning web components and supports standard opportunity workflow. Greytrix GUMU™ integration for Sage ERP – Salesforce is a 5-star rated app listed on Salesforce AppExchange.
The GUMU™ Cloud framework by Greytrix forms the backbone of cloud integrations that are managed in real-time for processing and execution of application programs at the click of a button.

For more information on our Salesforce products and services, contact us at salesforce@greytrix.com. We will be glad to assist you.

Related Posts