Saturday, October 15, 2016

CREATE A BATCH JOB IN AX 2012 AND SEND THE REPORT AS EMAIL ATTACHMENT VIA BATCH JOB SCHEDULER

STEPS TO CREATE A BATCH JOB IN AX 2012  AND SEND THE REPORT AS EMAIL ATTACHMENT THROUGH BATCH JOB.

This document covers the creation of batch job for Customers Report as an example.
Go to Accounts Receivable > Reports > Customer > Customers Report
Select the Customers range using select button in the customers report dialog box


Click on Destinations button to specify the print destination of the report
Various Print Destinations are available in Print Destination Settings
Print destination as screen is not allowed for a report runs as batch.
Select the E-mail and enter the email addresses as shown in the screen shot below. Select the File format from the different file format options available in the lookup.

Click OK after selecting Print Destination.
In the Customers Dialog box Click on Batch Tab.


Select the Batch processing check box.

Set the following options:
Task Description – Enter a description for the job.

Batch group - Assign the job to a batch group.
Batch groups are designed to enable you to run specific types of jobs on a specific batch server, or to run jobs on batch servers that are available at specific times. Batch groups are created by system administrators.
Private – Select this check box to restrict other users from processing your batch job. A private job can be run only by the user who submitted it, from the Set up batch processing form, and only on the computer where the user is logged on.

Click Recurrence to configure a batch job to recur on a specific schedule.


Time zone: Select the time zone.
Starting time: Enter the time that the batch job starts at.
Starting date:  Enter the date that the batch job starts at.
No end date: select this option to make the job run forever.
End after: Select this option to make the batch job stop after some occurrences.
Count:   Enter the specific number of recurrences.
End by:  Select this option to make the batch job stop at specific date
End date: Enter the last date of the job run.
Minutes:  select this option to make the job run for every specified number of minutes.
Enter the number of minutes in the Count Field.
Hours:  select this option to make the job run for every specified number of hours.
Enter the number of hours in the Count Field.
Days: select this option to make the job run for every specified number of days.
Enter the number of days in the Per field.
To run the batch job daily from Monday to Friday, click Every weekday
Weeks: select this option to make the job run for every fixed weekly intervals.
Enter the number of weeks in the Fixed weekly interval field, and then select the days on which you want the job to run.
For example, if you type 2 in the Fixed weekly interval field, and then select Monday and Wednesday, the batch job runs every two weeks on Monday and Wednesday.

Months:  select this option to make the job run for every fixed monthly intervals.
To set the day of the month and the frequency of the batch job, select Repeat a specific day by a fixed interval.
For example, if you enter 1 in the Day field and 3 in the Per field, the batch job runs on the first of the month for every three months.
To set a particular day of the week and the frequency of the batch job, select Repeat a specific weekday by a fixed interval.
For example, if you select Last in the Week field and Friday in the Weekdays field, and then enter 6 in the Per field, the batch job runs for every six months on the last Friday of the month.

Years:  select this option to make the job run for every year.
Select Repeat once a year or Repeat a specific weekday a year, and then set the starting date.
For example, if you select First in the Week field, Monday in the Weekdays field, and June in the Month field, the batch job runs for every year on the first Monday in June.



Click Alerts button.





Configure alerts for a batch job as shown in the following screen and Click OK.


Once the recurrence and alerts configuration is done click OK on the Customers Report dialog box.







The below message box pops up after the batch is created and added to queue.



Presetup’s needs to be done before sending the report as Email attachment

METHODS CALLED WHEN A FORM IS OPENED/CLOSED OR A RECORD IS CREATED/UPDATED IN AX 2012 FORMS

Sequence of methods called in AX from a FORM


Hi...
This gives the information of method calls in the form level while
1. Opening the Form.
2. Creating/Updating/Deleting the record in the Form.
3. Closing the Form.
Sequence of Methods calls while opening the Form
Form --- init ()
Form --- Datasource --- init ()
Form --- run ()
Form --- Datasource --- execute Query ()
Form --- Datasource --- active ()
Sequence of Methods calls while closing the Form
Form --- canClose ()
Form --- close ()
Sequence of Methods calls while creating the record in the Form
Form --- Datasource --- create ()
Form --- Datasource --- initValue ()
Table --- initValue ()
Form --- Datasource --- active ()
Sequence of Method calls while saving the record in the Form
Form --- Datasource --- ValidateWrite ()
Table --- ValidateWrite ()
Form --- Datasource --- write ()
Table --- insert ()
Sequence of Method calls while deleting the record in the Form
Form --- Datasource --- validatedelete ()
Table --- validatedelete ()
Table --- delete ()
Form --- Datasource --- active ()
Sequence of Methods calls while modifying the fields in the Form
Table --- validateField ()

Table --- modifiedField ()
Related Posts Plugin for WordPress, Blogger...