Windows Scheduler in Sage 300 ERP: For Auto Execution of EXE files

By | August 20, 2013

In Sage 300 ERP, clients need to execute a specific . EXE file on a daily basis for a specific time. Users can receive notifications for setting up reminders, however, they cannot run the EXE file automatically using Scheduling >> Reminder List. This makes it a manual and tedious task to carry out every day. Hence, User needs to run the Task Scheduler from Windows >> Control Panel.

*For example, users may want to create “Price List Code” for each item in the database on a regular basis by using EXE file.

Steps to run EXE using Windows Scheduler.

a) Navigate to Start >> Control Panel >> Administrative Tools >> Task Scheduler
b) Click on Task Scheduler >> Create Task option

Task Scheduler

 New Blog: Auto Generate OE Confirmation Report in PDF format in Sage 300 ERP

c) ‘Create Task’ UI will open.  In General Tab, Enter the Task Name.

Create Task

d) In case you want the scheduler to run in case the user is logged off, then select the checkbox (Run whether the user is logged on or not).
e) Then navigate to Action tab and select New.
f) You will see the ‘New Action’ UI.

New Action

g) In ‘Program/Script’, select ‘EXE’ file, for which you want to execute using the Browse button.
h) In ‘Add arguments (optional)’ field, enter Sage 300 User Id, Password, and Company Name.  Separate these fields by comma (ADMIN,ADMIN,SAMINC)
i) Click on OK >> ‘New Action’ UI will get closed.
j) Now, navigate to Triggers Tab >> New >> ‘New Trigger’; an UI will get opened.
k) Add a scheduler to run the EXE.

New Trigger

l) Click on OK >> New Trigger UI will get closed.
m) Now click on OK button in ‘Create Task’ UI.
n) A pop up will get opened asking for System User Id and Password. Enter details and click on OK.

This way, the EXE file will run on a daily basis as set in windows scheduler. Thus making it easier for the users to automate their Sage 300 ERP process, reducing the time consumed to run EXE File on a regular basis.

 

About us:

Greytrix have some unique solutions of Sage 300 ERP integration with Sage CRM, Salesforce.com and Magento Ecommerce. We offer 20+ add-ons for Sage 300 ERP. It also offers best-in-class Sage 300 ERP customization and development services to business partners, end users, and Sage PSG worldwide.

Greytrix helps in migrating to Sage 300 ERP from Sage Pro, Sage 50 US, Sage 50 CA, Sage 50 UK, Sage Business Works, Sage Business Vision, QuickBooks and MS Dynamics Great Plains.

For more information on troubleshooting the error on Sage 300 ERP, please contact us at Sage@greytrix.com .We will be glad to assist you.

 

Also Read:

1. Run VBA Macro without Logging to Sage 300 ERP
2. Recurring Payables in Accounts Payable module of Sage 300 ERP
3. Financial Budgeting in Sage 300 ERP
4. Plan Execute Track Measure – For ERP Implementation
5. Create Recurring Entries in General ledger of Sage 300 ERP
6. Create custom startup folder in Sage 300 ERP