Category Archives: GUMU™ Tricks & Tips

Optimizing Log Management: Automating Deletion of Logs, Import Job Logs, and Integration Statistics

In a previous blog, we explored how GUMU™ simplifies log management. In this blog, we dive deeper into the enhanced features of automating deletion of log records, exploring practical implementation strategies, and providing insights on maximizing its benefits for the organization. This new functionality will provide users with the ability to delete Import_Jobs__c and Integration_Statistics__c… Read More »

How to separate Shipping and Billing Street into multiple address lines while importing data from Sage into Salesforce

In this post, we’ll discuss how to split or separate Shipping and Billing Street into multiple address lines in Salesforce. These fields are often used to store address information and are typically set up as long text fields, allowing for multiple lines of data like street numbers, names, apartment or suite numbers, and other details.… Read More »

How to fix the error “Illegal Assignment from String to Decimal” while importing data from Sage to Salesforce

One common issue when integrating SF to any system is the “Illegal Assignment from String to Decimal” error, which occurs when string data from the other system is assigned to a numeric field in Salesforce. Integrating data between Salesforce and ERP (or any other system) can be complex, especially dealing with mismatched data types. This… Read More »

GUMU’s upcoming feature: Enhanced Security Matrix with a Dynamic Tree View!

In this blog we shall outline the new feature enhancement for the Security Matrix UI. The Enhanced Security Matrix provides better access control at both the Administrator and User levels, featuring two distinct components: Security Level Profiles and User Levels. Purpose of Enhanced Security Matrix Previously, accessing different security levels (Profiles and Users) in the… Read More »

How to import data from Sage 300 ERP to Salesforce using the Last Sync field and Last Sync value

Import data from Sage 300 ERP to Salesforce

In this blog, we will explore how to import data from Sage 300 ERP to Salesforce using the Last Sync Field and Last Sync Value features. GUMU™ for Salesforce is a real-time, bi-directional integration that allows users to sync data between Salesforce and Sage ERP seamlessly. To import data from Sage 300 ERP to Salesforce… Read More »

How to ensure Product Line Descriptions meet character limits while promoting Quotes/Order to Sage 300

A key challenge when integrating Salesforce with Sage is managing Product Line Descriptions meet character limits. Salesforce allows descriptions up to 255 characters, while Sage restricts them to 60 characters, causing truncation and potentially losing important information when promoting quotes or orders in Sage. To prevent this, a validation rule in Salesforce is needed to… Read More »

GUMU™ Feature: Experience Real-time Product Inquiry on Quote Line Item in Salesforce – Sage 300C Integration

In this blog, we’ll discuss the new feature in the GUMU™ Integration, Real-time Product Inquiry on Quote Line Item which allows users to view real-time product information while adding or updating line items on the Quote Line Item screen in Salesforce. Follow the steps below to get real-time pricing from the Sage 300C system. Real-time… Read More »

GUMU™ Feature: Enhanced Entity Mapping/Import based on Sync Type

In this blog, we will be discussing the benefits of using the “Sync Type” in Entity Mapping/Import based on Sync Type Import routine to streamline data management processes and improve overall workflow. The Entity Mapping/Import module has been upgraded to clearly differentiate between Default Import routines provided by the GUMU™ package and Custom Import routines created… Read More »

GUMU™ Feature – Use Filters in Import functionality

In this blog, we will discuss how to use Filters in Import routine & bring in only specific data from Sage X3 ERP to Salesforce using the new GUMU™ Interface in Lightning Component. How to apply and use Filter(s) while importing data from Sage X3 Follow the steps stated below in order to use filter functionality in Salesforce:… Read More »