Microsoft Dynamics AX (Archived)

Automatic table update for everyday in Ax 2009

(0) Share

Report

Posted on by Sathish Sivakumar

3,732

Hi,

I have a table named as "SOP" in that I have fields are "Release date", and so on. I'm working on the revision.

What is my question means. When ever the "release date" is equal to the system date then "Active" field should be enable until the next revision "release date" come. If next revision date comes means then that have to come to active the previous one have to go inactive. I have a code for this scenario. But I don't know in which method I have to write the code. Can you tell me which method is the right one for this scenario in table.

For this scenario that code have to execute for every day to check the release date.

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (1)

Sohaib Cheema 49,443 User Group Leader on at

Like (0)

Report

before answering question, "what if new coming RelaseDate is not equal to today?? should it make itself active and previous dates inactive?? because coming release data is not today. As you said in your first condition that if release date is equal to today"

Was this reply helpful? Yes No
Sathish Sivakumar 3,732 on at

Like (0)

Report
Hi Sohaib,

If release date is not equal to today date means it should in inactive state.

If release date is equal to today means it should go active, util the new release date come.

If release date is previous date to today means is should be in inactive state.

Thanks for you reply Sohaib, I need to know which method update the table eventually (For every moment) by seeing the date.

Was this reply helpful? Yes No
Verified answer

Sohaib Cheema 49,443 User Group Leader on at

Like (0)

Report

man, you need to write a batch class. Batch class periodically runs based on reoccurance setup

heave a look at following examples

tech.alirazazaidi.com/exploring-the-batch-job-process-in-dynamics-ax-2012-r3

www.atomicax.com/.../create-batch-executable-class

and in AOT>>Classes >>Tutorial_RunbaseBatch

create a RubBaseBatch class an put your logic there. then add it to batch jobs and after every few minutes it can check your table to do whatever you want

Was this reply helpful? Yes No
Sathish Sivakumar 3,732 on at

Like (0)

Report

Hi Sohaib,

Where to set the batch job timing? (When this batch job should run or should I go to job and run manually?) I'm using Ax 2009.

Other than that is there any other way to achieve my scenario?

Was this reply helpful? Yes No
Sohaib Cheema 49,443 User Group Leader on at

Like (0)

Report

Hi after creating class, as you will run it through a menu item or otherwise, It will provide you option to set reoccurrence.

kindly open class Tutorial_RunbaseBatch and press Ctl+O on it

the class Tutorial_RunbaseBatch, can also be found on AX2009

Was this reply helpful? Yes No
Sathish Sivakumar 3,732 on at

Like (0)

Report

Hi Sohaib,

Once I set the batch, that time its running. But I have to set the date as "No end date". But this scenario is not working. I set time interval as 1 minute.

Was this reply helpful? Yes No
Sohaib Cheema 49,443 User Group Leader on at

Like (0)

Report

you can set time interval as per you need 1 minute 10 minutes, 1 hour 1 day anything.

there is choice to select different sort of intervals. you may choose as per needs. after setting time click ok, click okay gain to close dialog which was opened as result of running class, its will add a new job in batch jobs and will execute periodically

Was this reply helpful? Yes No
syed baber 11,633 on at

Like (0)

Report

Hi Sathish,

If you want to run the batch job for indefinite period as per the defined interval, then I think there is an option of 'No end date' when you click the Recurrence button. Please check after clicking the Recurrence button and see if there is an option related to this.

Thanks,

Baber.

Was this reply helpful? Yes No