how to add dimension column in list page

(0) Share

Report

Posted on by Chaitanya raj

Hello Guys,

I need to add financial dimensions as a separate columns for sales order open lines form in list page.

Can anyone suggest me

Thanks in advance for help

I have the same question (0)

All responses (17)

Answers (1)

Gunjan Bhattachayya 35,423 on at

Like (0)

Report

Hi Chaitanya,

Have you tried using the "DefaultDimensionView"? You can link by DefaultDimension from SalesLine and filter the records by field "Name"(should have values for financial dimension name).

Was this reply helpful? Yes No
Chaitanya raj 65 on at

Like (0)

Report

I don't want to be a display fields.

How can i use DefaultDimensionView to display columns, Can u brief more please

Was this reply helpful? Yes No
Gunjan Bhattachayya 35,423 on at

Like (0)

Report

Hi Chaitanya,

Are you looking to update these fields from the list page form?

Was this reply helpful? Yes No
Chaitanya raj 65 on at

Like (0)

Report

No Gunjan,

I won't update any fields in the form.

Open sales order lines list page will display all the open sales order lines.

So i need to add dimension columns to grid as well.

User want to sort the columns , so display method won't work here

Was this reply helpful? Yes No
Gunjan Bhattachayya 35,423 on at

Like (0)

Report

Hi Chaitnaya,

I don't think you can add the dimensions dynamically. Let's say you have for dimensions - Department, Cost center, Business unit and Worker. If you add another dimension "Customer', it won't appear on the form.

Will that work for you?

Was this reply helpful? Yes No
Chaitanya raj 65 on at

Like (0)

Report

Now i don't have any dimension columns on the listpage

So any way to add those as columns in the grid of listpage

Was this reply helpful? Yes No
Suggested answer

Gunjan Bhattachayya 35,423 on at

Like (0)

Report
Hi Chaitanya,

You can try doing this -

1. Create an extension of the form.

2. Add a new datasource - "DefaultDimensionView". Name is "DefaultDimensionView_Dept" ( I am doing an example for Department dimension).

3. Create a new class and copy event handler for "OnQueryExecuting" event. -

[FormDataSourceEventHandler(formDataSourceStr(SalesLineOpenOrder, DefaultDimensionViewDept), FormDataSourceEventType::QueryExecuting)] public static void DefaultDimensionViewDept_OnQueryExecuting(FormDataSource sender, FormDataSourceEventArgs e) { FormRun salesLineOpenOrder = sender.formRun(); SalesLine salesLine = salesLineOpenOrder.dataSource("SalesLine").cursor(); sender.query().dataSourceName(sender.name()).addRange(fieldnum(DefaultDimensionView, DefaultDimension)).value(queryValue(salesLine.DefaultDimension)); sender.query().dataSourceName(sender.name()).addRange(fieldnum(DefaultDimensionView, Name)).value(queryValue("Department")); }

4. Add the DisplayValue field to the design -

5. You have to repeat this for all dimensions.

Was this reply helpful? Yes No
Chaitanya raj 65 on at

Like (0)

Report

Thanks a lot for your guidance.

I have implemented the same way what you have suggested above, but i am seeing the dimension value only for the first line in the form and not showing for other records.

If i click on any other record then it is displaying dimension value for that record.

if i select other record, then dimension value is displaying for currently selected record and for previous record again dimension is displaying blank value

Was this reply helpful? Yes No
Verified answer

Gunjan Bhattachayya 35,423 on at

Like (1)

Report
Hi Chaitanya,

Please change the following -

1. Join type on DefaultDimensionView. Changes it to "Outer join".

2. Instead of "OnQueryExecuted", try "OnIntialized" and set the link type and range -

[FormDataSourceEventHandler(formDataSourceStr(SalesLineOpenOrder, DefaultDimensionViewDept), FormDataSourceEventType::Initialized)] public static void DefaultDimensionViewDept_OnInitialized(FormDataSource sender, FormDataSourceEventArgs e) { sender.query().dataSourceTable(tableNum(DefaultDimensionView)).addLink(fieldnum(SalesLine, DefaultDimension), fieldnum(DefaultDimensionView, DefaultDimension)); sender.query().dataSourceTable(tableNum(DefaultDimensionView)).addRange(fieldnum(DefaultDimensionView, Name)).value(queryValue("Department")); }

Was this reply helpful? Yes No
Suggested answer

vinitgoyal2005 6,332 on at

Like (0)

Report

Hi,

Look at d365foe.blogspot.com/.../get-individual-financial-dimension-value.html. I have views created for each financial dimension and join it to any other table where FD exists.

Was this reply helpful? Yes No