Chapter 6: Sync YTD and LYTD Sales Data Using Windows Scheduler

As we now know about displaying the YTD and LYTD sales data using import custom fields process which has to be done manually can now be synced automatically based on windows scheduler.

User will have to schedule the batch file using Task Scheduler which will sync 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’ batch file from ‘C:\Program Files (x86)\Greytrix\GUMU for Sage CRM Server’

2. Edit the below details in that file :– a. Sage CRM URL – Enter the Sage CRM URL (like http://grey087/CRM2017R3/eware.dll)

   b. Sage CRM User Name – Enter Sage CRM username

   c. Sage CRM Password – Enter Sage CRM password

   d. Sage CRM Instance Name – Enter Sage CRM Instance name

   e. 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.