We have a need to every month change data on forms for sessions that are in jobs. For example: we work with service orders for the whole next month, but not for the next 30/31 days. So the date on the form should always be the last day in the next month.

Another example is automated printing of financial data. In some cases this is based on the financial period, so each month we need to change the period.

Does anybody have some kind of tool where this can be done more efficiently than setting the session in the job again and again, or by changing the string in the jobs table via GTM?

Any ideas will be appreciated
/Thomas

When adding session to job you can decide for every date/time field if you want to save absolute or relative date/time.

Thank you for your comment, but the problem is not that easy. In my first example I need to keep the date fixed for one month and then change it and keep it fixed for another month.

In my second example it is not at all a date so the change functionality built into the job system does not apply to this.

Regards,
/Thomas

I think you have to develop something your self to solve this problem. At least I did it once for a customer. Don't think Infor has a solution although you can explain it to your account manager and ask him if Infor can fix it.

Regards,
Han

Hi,

please check this old posting from Code & Utilities for a example of a small tool to handle this issue.

Change job parameters automatically http://www.baanboard.com/baanboard/showthread.php?t=9261

Regards,
Juergen

^A good improvement in V and up... there's a "Change Session Settings..." option in Sessions by Job that actually brings up the session and lets you make any changes to it and resave them to the job...

There are multiple ways.

1. If u have downloaded earlier the ERPJewels , there is provision for handling periods of unequal days and numeric period indiacators like month / week through front end . Now if u need it (with latest enhancements) , u need to buy the same from us. Now with 100 million rows in Excel 2010 and all leading reporting tool converging to XL for BI last mile , this is worth the price. If u need it , please send me a PM.

2. The sample code indicated on this thread to be run just before the job
to change 503 values.

3. If u want program specific development , u can write some few lines of code in before.choice of run.job (in absense of run.job , use cont.process) to change the period values dynamically when job.process is true. Not a big problem when program is customised or u have source.