Khue Trinh: Fill Utility in AX2009

[Blog bot]

Источник: http://khue.spaces.live.com/Blog/cns...A0C2!580.entry
==============

If you are using AX2009, you may want to explore a new feature called Fill Utility. This functionality allows you to update a range of records with a value. Basically, I found that this works like using UPDATE T-SQL statement in query analyzer.

An example: I want to change all customers that are using mode of delivery 10 – Truck to 30 - Rail.



Firstly, you need to activate the configuration setting for Fill Utility by going to Administration > Setup > System > Configuration

Under Administration node, you will find the Fill utility node and need to activate this. It may take a while to finish the task with configuration change or synchronization.



Once you have done that, go to the customer master file, right click on the customer, and choose Record Info



Click Fill utility, you will be able to specify the selection criteria you want to filter. Reset the customer account to blank and set the Mode of delivery to 10 and click OK, system will filter the customer list to get your customers.



Enter the new Mode of delivery and think twice then click OK.



Technorati Tags: AX2009,Fill utility


Источник: http://khue.spaces.live.com/Blog/cns...A0C2!580.entry