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.
that’s a new software right ?
Hi Thang,This is Dynamics AX 2009, a Microsoft ERP product.
Hi,"think twice" because the input is not checked?You can put any value of the correct type in, regardless the value exists in the corresponding table or not(if a relation is defined)
Hi,
is there any reason why this functionality has been restricted to tables in MAIN table group? is there any problem to make this run on tables in worksheet header group (by modifying the restriction in SysRecordInfo::init)? thank you
This functionality I think, only available on the tables which has indexing
Hi. This is due to the Index in the database. The functionality is only available on indexed columns in the database