EXPLORING THE FUNCTIONALITY OF SAGE 100 LOT AND SERIAL TRACKING IN SAGE CRM USING THE GUMU™ CUSTOMIZATION.

By | July 19, 2023

The GUMU™ Sage 100 CRM integration is a fully bi-directional solution where users can have access to Sage 100 data wherever they log into Sage CRM. Connecting Sage 100 with Sage CRM allows customer-facing staff to view accounting data and create orders through the Sage CRM interface. 

Today in this blog we will discuss a customization analysis we had done in the past, wherein the Sage CRM user will have the ability to manage the distribution of Lot/Serialized Items in Sage CRM itself while creating Quotes/Orders in Sage CRM.

The standard versions of GUMU™ currently do not include support for Lot/Serialized Item functionality in Sage CRM. However, it is possible to add this feature to GUMU™ through customization. Lot and Serial tracking are intricate features that require users to manage the distribution by assigning specific Lot and Serial numbers. To fully comprehend the functionality that can be achieved through customization, let’s take a brief overview of the Lot and Serial functionality in Sage 100.

The lot and Serial Distribution functionality in Sage 100 empower businesses to efficiently manage the distribution of inventory items with lot or serial numbers. By accurately assigning lot and serial numbers, businesses can maintain traceability, optimize warehouse management, and precisely fulfill customer orders.

Now let’s have a look at the functionality that can be added to GUMU™ as customization for the distribution of Lot/Serial Items in Sage CRM itself.

Firstly, the Lot and Serial Product will have to be imported in Sage CRM from Sage 100 using the GUMU™ Import Products Utility.

Prepare to convert

Users can enable or disable lot/serial customization through the ‘Enable Lot/Serial’ checkbox present on the Configuration screen.

Prepare to convert

If the User adds any lot/serial item in Sage CRM Quote/Order using New Line Item Screen then a Enter Lot/Serial button will get displayed.

Prepare to convert

Using the Enter Lot/Serial button user can add a lot and serial numbers and save the record.

Prepare to convert
Prepare to convert

Validations will be displayed as per standard Sage 100 functionality

The Lot/Serial item and its corresponding lot/serial numbers will be promoted to Sage 100 during the Promote Order process.

Similarly, we can provide the above functionality on the QLE screen as well. See the image below.

Prepare to convert

For more information about the GUMU™ integration link, please refer to below links:

Blog link:
https://www.greytrix.com/blogs/sagecrm/tag/gumumas/

YouTube video link:
https://www.youtube.com/watch?v=r1QlaTC0PX4

For any queries related to GUMU integration, you can contact us at sage@greytrix.com

About Us

Greytrix – a globally recognized and one of the oldest Sage Development Partners is a one-stop solution provider for Sage ERP and Sage CRM organizational needs. Being acknowledged and rewarded for multi-man years of experience and expertise, 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 has some unique integration solutions developed for Sage CRM with Sage ERPs namely Sage X3Sage IntacctSage 100Sage 500, and Sage 300. We also offer best-in-class Sage ERP and Sage CRM customization and development services to Business Partners, End Users, and Sage PSG worldwide. Greytrix helps in the migration of Sage CRM from Salesforce | ACT! | SalesLogix | Goldmine | Sugar CRM | Maximizer. Our Sage CRM Product Suite includes addons like  Greytrix Business ManagerSage CRM Project ManagerSage CRM Resource PlannerSage CRM Contract ManagerSage CRM Event ManagerSage CRM Budget PlannerGmail IntegrationSage CRM Mobile Service SignatureSage CRM CTI Framework.

Greytrix is a recognized Sage Champion Partner for GUMU™ Sage X3 – Sage CRM integration listed on Sage Marketplace and Sage CRM – Sage Intacct integration listed on Sage Intacct Marketplace. The GUMU™ Cloud framework by Greytrix forms the backbone of cloud integrations that are managed in real-time for the processing and execution of application programs at the click of a button.

For more information on our integration solutions, please contact us at sage@greytrix.com. We will be glad to assist you.