Synch YTD and LYTD sales data using windows scheduler

By | November 13, 2019

GUMU for Sage CRM – Sage 100 integration is a real-time bi-directional link where we can synchronize all the customer data from Sage 100 to Sage CRM and vice versa.

In our previous blog we had discussed about displaying the YTD and LYTD sales data using import custom fields process Today, we will discuss about how YTD and LYTD sales data can be synced automatically based on windows scheduler.

New Stuff: New Feature in GUMU for Sage CRM – Sage 100 Integration – Find Inventory

User will have to schedule the batch file using Task Scheduler which will synch YTD, LYTD and Last Invoice Date data automatically into Sage CRM based on scheduled time.

If user wants to keep sales value updated on daily, weekly or monthly basis then user can run scheduler (on daily, weekly or monthly basis ) by scheduling the utility. Before running scheduler, user will have to follow below steps –

1.  Edit ‘SyncCustomFields’ bat file from C:\Program Files (x86)\Greytrix\GUMU for Sage CRM Server

2.  Edit the below details in that file –

<Sage CRM URL> – Enter the Sage CRM URL (like http://grey087/CRM2017R3/eware.dll)

<Sage CRM User Name> – Enter Sage CRM username

<Sage CRM Password> – Enter Sage CRM password

<Sage CRM Instance Name> – Enter Sage CRM Instance name

<Sage 100 company code> – Enter the Sage 100 Company Code which is integrated with GUMU™ Integration.

3. Save the file

4. Run ‘SyncCustomFields’ with Run as Administrator which will import YTD sales data from Sage 100 to Sage CRM OR you can schedule under Windows Task Scheduler.

Note: – Scheduler will work only for 1 Sage 100 Company Code not for multiple Sage 100 Company Codes.

For any queries related to GUMU integration, you can contact us at

About Us

Greytrix is 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 integration solutions for Sage CRM with Sage ERP’s (Sage X3Sage 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 migrating to Sage CRM from ACTGoldmine and other CRM’s.

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