AX2012 traversing and updating grid value

Finance and Operations/AX Developer Forum
1

hi i have a current project that has the following scenario:

  • there is a form that has a header and grid.

  • at the header, i should input a value. this value should then be the value of a certain field in the grid.

lets say for example,

there is a field in the header named withholding percentage. then there is a grid that contains the records from the custTable.

whatever value that will be inputted in the header field which is withholding percentage, should be the value of of the ‘withlolding percentage’ field of ALL the records in the grid.

can anybody help me with this code.

2

you have to write code for updation in the grid based on the criteria.

eg;

update_recordset tableA

Setting field1 = 20%

where tableA.Field1 == …

3

note sir that the record should not be saved yet to the database.

4

then u should be more specific…

else

no one will fix your issue

5

If you just want to display the value, create a display method (or an edit method, if the value may be eventually set). It can simply return the value of the active header record (without any query to database).