Run Financial Report (PS Level 3)

Prerequisites

• Excel should be installed on the server where Process Scheduler is run/scheduled in Windows Scheduler. 

• You also need to run a Sage 300 workstation setup if the schedule doesn't run on the Sage 300 application server.

Key Steps

The following steps are required to schedule a financial report :

Log into a Sage 300 database with an existing install of Process Scheduler.

• Go to the schedules screen and create a new schedule

  Note: Use the detail screen (F9 Zoom) to setup a schedule to Run Financial Report

For the Action specify Run Financial Report Group

• Specify the company and report group name from IM Report Runner

• Define the parameters Year, Period, File name

• Define the e-mail subject and address

All reports in the group will use the same configuration.

Tip: You can add another "Run Financial Report Group" Action for another Report Group with different parameters.

Year

You can select a specific fiscal year or one of the options relative to the date the schedule is run

Current fiscal year eg "2027"      

Previous fiscal year eg "2026"      

Next fiscal year eg "2028"      

Period

You can select a specific fiscal period or one of the options relative to the date the schedule is run

Current fiscal period eg "9"      

Previous fiscal period eg "8"      

Next fiscal period eg "10"    

Email subject and To

If you want to email the reports, enter an email subject and the email address.

Email settings in Information Manager options need to be configured.

FILE path and NAME:

You can include the following fields in the filename:  

{NAME} - Report description configured in Financial Report Runner e.g. "Dept 100 forecast"      

{FILENAME} - Source file name (without the path and the xls extension)

{DD} - day e.g. "05"      

{D} - day e.g. "5"      

{MM} - month e.g. "01"      

{M} - month e.g. "1"      

{MMM} - month e.g. "Jan"      

{YY} - year e.g. "09"      

{YYYY} - year e.g. "2009"      

{hh} - hour e.g. "02"      

{h} - hour e.g. "2"      

{mm} - minute e.g. "04"      

{m} - minute e.g. "4"    

Tip: Consider if you want the file overwritten in each run or you need a unique file name everytime the Financial Report is refreshed in selecting the variable names.

Tip: If you refresh multiple FR files in one run, ensure that the Save As includes the {filename}. Otherwise, it appears that only the last file is refreshed as all files have the same name.

The following options are relative to the date the schedule is run

{FSCYEAR} - fiscal year eg "2027"      

{PFSCYEAR} - previous fiscal year eg "2026"      

{NFSCYEAR} - next fiscal year eg "2028"      

{FSCPER} - fiscal period eg "9"      

{PFSCPER} - previous fiscal period eg "8"      

{NFSCPER} - next fiscal period eg "10"    

 {YEAR} - the selected financial year

{PERIOD} - the selected financial period