Update multiple records with 'Fill Utility'

Update multiple records with 'Fill Utility'

Note:- FOLLOW THIS STEPS ON YOUR OWN RISK,I WILL NOT BE RESPONSIBLE FOR ANY GOOF UPS. SO PLZ BE CAREFULL DURING THESE STEPS.
The Fill utility enables authorized users and/or administrators to mass-update records, similar to the find and replace functionality. We can use an alternative method also to Update Multiple records in Grid.
this utility assists administrators or users during implementations/Development or when business process changes affect multiple records.
Cautions:
1> It is recommended practice to take backup of entire database before performing this 'Fill Utility' operation.
2> It is recommended to use this feature during implementations/Development (or) when business process changes affect multiple records.
3> Please follow the standard procedure to enable this configuration. This may require restart of AOS & Data dictionary sync to make sure changes take immediate effect.
4> Be aware that changing numerous records at the same time can be time-consuming.
Enable configuration key:
Path: Dynamics Ax > Administration > Setup > System > Configuration > Under Administration tree (Enable 'Fill Utility' option)
Fill Utility usage:
Open the form that contains the field to update.
Example:  Dynamics Ax > Accounts Receivable > Common forms > Customer details > Select required customer record > payment tab

Right click on the field 'Ledger account' field > Record info

Click button 'Fill Utility'

We can select the criteria here
Click button 'OK'

Validate the records and click 'OK'

Select new 'Terms of payment' = N045 (here we have to specify new terms of payment)
Click 'OK'
Caution: Be aware that changing numerous records at the same time can be time-consuming.
Fill Utility log:
Path: Dynamics Ax > Basic > Inquiries > Fill Utility log

Security key: Adminfillutility
This completes 'Fill Utility' feature details from usage.
This a very useful to update multiple records at the same time.
- Harry

Axapta V/s Me: How to configure Automatic shutdown FOR ALL USER

Axapta V/s Me: How to configure Automatic shutdown FOR ALL USER: How to configure Automatic shutdown FOR ALL USER Hi friends, This a very common issue for companies which have a limited Ax user licen...

How to configure Automatic shutdown FOR ALL USER

How to configure Automatic shutdown FOR ALL USER

Hi friends,

This a very common issue for companies which have a limited Ax user license.  User just remain idle for a log time and eat license. To overcome this problem  we can set the automatic shut down for  user who Remains Idle For Few/Many Minutes in Axapta.

To do this go to Menu –> Tools –> Option as shown in following screen.

After click on Option menu here a new window will open.

Here u can set the minutes for automatic shut down .
Note:- This configuration will remain same for ALL USERS. It is not user specific. SO Be care full to choose the best Idle time for Automatic shutdown.
- Harry

How to update multiple rows at backend and refresh the UI?

Update multiple rows at backend and refresh the UI at the same time.

Hi friends,

           

              Some times we need to update multiple rows in grid (Form) and the same time need to refresh the user interface also. 

For example:-

In a form grid there is a check box that is for  xyzValue = Yes or No. all the selected records should be update when user press a button. In following image we are going to post all selected reords and at the same time we update all selected rows in back end as well as refresh the UI also.

    to do this write following code in your click method of post button.

void clicked()

{

    Ax_dataSource                                  _ Ax_dataSource  ;   // your data source Table

    ; 

    ttsbegin;

    while select forupdate   _ Ax_dataSource where   _ Ax_dataSource .Status == AllOpenPosted::Open

                                           &&   _ Ax_dataSource .checkBox == NoYes::Yes

    {

             // write here your required updation  after posting

          _ Ax_dataSource .Status    = AllOpenPosted::Posted;     

          _ Ax_dataSource .checkBox  = NoYes::No;                 

          _ Ax_dataSource .update();

        

    }

    ttscommit;

     Ax_dataSource _ds.refresh();        

     Ax_dataSource _ds .reread();

     Ax_dataSource _ds .research();

   super();

}

-Harry