Edit Grid lines on binding

(0) Share

Report

Posted on by KCDeVoe

1,450

Is it possible to edit each line on a grid as it is binding? I'd like to sum a series of records and have it display on one line. I'm setting it up as a multi-sourced table with an inner and outer join. RouteVersion is the main table with InventDim/InnerJoin and SalesLine/OuterJoin.

My ultimate goal is to Display a line for each Route per site and the RemainSalesPhysical sum for that Route on each site. Each route is tied one to one with an Item.

I've tried this through table methods, but since I can't access the current grid line's fields I don't know the specific route, or site, or item (depending on what table the method is in).

Maybe I'm going about this the wrong way, does anyone have any suggestions for me?

*This post is locked for comments

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Bilal Issa 4,370 on at

Like (0)

Report

Hi,

I think you should create a view and add group by site and route and sum RemainSalesPhysical, please check view InventValueFinancialTransaction , and try to do the same with your scenario.

Regards,

Bilal

Was this reply helpful? Yes No
KCDeVoe 1,450 on at

Like (0)

Report

Thanks, I knew there had to be an easier way. I'm still learning all the ins and outs of AX development.

Was this reply helpful? Yes No