Help with grid...

Finance and Operations/AX Developer Forum
1

Hi all,

I created a grid with 4 columns(salesid, custaccount, salestype, and total line amount) in a second tab with a salestable datasource. The 4th column, total line amount, is a calculated field based on the salesid which will be used in SalesTotal construct which need the current salestable. I cannot find a way to grab the salesid when the grid is initialize or populated with records from the data source. Can somebody point me in the right direction or codes.

I can make a temp table for this but still doubting because it’s only 1 calculated field.

Thanks.

2

simply make display method on salesTable

diplay real totalline()

{

totalline = //your code here to calculate totalline;

return totalline;

}

on grid create 1 realedit, set datasource to salestable, set datamethod to totalline

3

Already did that but the UI response is slow when browsing lots of records in the grid.

4

Hi Earl,

Take a global variable and assign it the value of salesid before navigating to the new form and pass this value as a parameter for the new form method to find the corresponding records.