Skip to main content
Solved

Scheduling Order Reports (Order Confirmation Reminder)


Forum|alt.badge.img+3

(Apps 10, Upd 7)

 

Anyone having experience from setting up “Order Reports” like for example “Order Confirmation Reminder” as an scheduled job ? 

 

I have seen earlier issue (https://community.ifs.com/topic/show?tid=3909&fid=50) and also tried to setup as a “Task Schedule” job  but would need some input if anyone done this before ? 

 

 

Best answer by Thushitha Chandrasiri

Hi @Magnus Svensson ,

Yes, you can easily schedule a report is available in order reports through “Create New Report Schedule”.

There, you can change the Report Schedule Name as you want, and select the wanted report from the list of values available.

 

You can set the parameters in Parameters tab (note that Parameters section will change based on the report you select).

And, in the Schedule tab, the scheduling time parameters can be entered. 

In the Settings tab, you can specify what the system to do after the report is run; whether it is just save the report in report archive, or print, or email to a set of users…

Hope this helps..

 

Thanks,

View original
Did this topic help you find an answer to your question?
This topic has been closed for comments

7 replies

Thushitha Chandrasiri
Superhero (Partner)
Forum|alt.badge.img+21

Hi @Magnus Svensson ,

Yes, you can easily schedule a report is available in order reports through “Create New Report Schedule”.

There, you can change the Report Schedule Name as you want, and select the wanted report from the list of values available.

 

You can set the parameters in Parameters tab (note that Parameters section will change based on the report you select).

And, in the Schedule tab, the scheduling time parameters can be entered. 

In the Settings tab, you can specify what the system to do after the report is run; whether it is just save the report in report archive, or print, or email to a set of users…

Hope this helps..

 

Thanks,


Forum|alt.badge.img+3
  • Author
  • Do Gooder (Employee)
  • 6 replies
  • June 8, 2021

Many thanks ! (works fine in test environment)


lopespetro
Hero (Customer)
Forum|alt.badge.img+13
  • Hero (Customer)
  • 276 replies
  • August 24, 2021
ThushAsanka wrote:

Hi @Magnus Svensson ,

Yes, you can easily schedule a report is available in order reports through “Create New Report Schedule”.

There, you can change the Report Schedule Name as you want, and select the wanted report from the list of values available.

 

You can set the parameters in Parameters tab (note that Parameters section will change based on the report you select).

And, in the Schedule tab, the scheduling time parameters can be entered. 

In the Settings tab, you can specify what the system to do after the report is run; whether it is just save the report in report archive, or print, or email to a set of users…

Hope this helps..

 

Thanks,

Hi. This is gr8.

Is there a way to schedule a custom quick report?

Tks


Thushitha Chandrasiri
Superhero (Partner)
Forum|alt.badge.img+21

Hi @lopespetro ,

Yes, you can schedule to run a SQL statement type quick report and email to a set of users as an excel export. You can use Application Server Task for this, defining the Job type as Quick Report.

 

After saving, RMB and select “Scheduled Task”. Then, it will create a scheduled task for this.

 

Then, in the scheduled task window which is populated with the data for the defined application message, you can schedule it as you want.

You can find more information on Application Server Task in this help document.

https://docs.ifs.com/techdocs/Foundation1/040_administration/230_bckgrnd_processing/030_app_server_tasks/default.htm

 

Thanks,


lopespetro
Hero (Customer)
Forum|alt.badge.img+13
  • Hero (Customer)
  • 276 replies
  • August 30, 2021
ThushAsanka wrote:

Hi @lopespetro ,

Yes, you can schedule to run a SQL statement type quick report and email to a set of users as an excel export. You can use Application Server Task for this, defining the Job type as Quick Report.

 

After saving, RMB and select “Scheduled Task”. Then, it will create a scheduled task for this.

 

Then, in the scheduled task window which is populated with the data for the defined application message, you can schedule it as you want.

You can find more information on Application Server Task in this help document.

https://docs.ifs.com/techdocs/Foundation1/040_administration/230_bckgrnd_processing/030_app_server_tasks/default.htm

 

Thanks,

Hi ThushAsanka,

Yes. I found it there.

How about Crystal reports? Is there anyway or do I need a customization?

Tks a lot


Thushitha Chandrasiri
Superhero (Partner)
Forum|alt.badge.img+21

Hi @lopespetro ,

I’m not aware of a standard functionality to schedule a crystal report type quick report in IFS. Maybe you can define a custom database procedure to run the quick report, and export/email the report, and create a new database task in the application using that custom procedure, and then create a new database task schedule using that database task.

If there’s a standard way to do this, please someone let us know.

 

Thanks,


lopespetro
Hero (Customer)
Forum|alt.badge.img+13
  • Hero (Customer)
  • 276 replies
  • August 31, 2021
ThushAsanka wrote:

Hi @lopespetro ,

I’m not aware of a standard functionality to schedule a crystal report type quick report in IFS. Maybe you can define a custom database procedure to run the quick report, and export/email the report, and create a new database task in the application using that custom procedure, and then create a new database task schedule using that database task.

If there’s a standard way to do this, please someone let us know.

 

Thanks,

Hi @ThushAsanka ,

Tks 4 the info.

I’ll try that method.

Best Regards!


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings