How to show all dimension value from custom dimension field in Excel add-in

(0) Share

Report

Posted on by Vijay Yelmame VY

476

Hi Community,

I have requirement to add new dimension entry control on custinvoiceline and show all dimensions values in excel add-in.
I completed the part of adding dimension control field and everything related to that. but stuck to show it in excel add-in.

As below screen is showing financial dimension similarly i want to show dimensions values from custom dimension entry control.

Please help !!

I have the same question (0)

All responses (23)

Answers (1)

Gunjan Bhattachayya 35,423 on at

Like (0)

Report

Hi Vijay,

Looks like you have already added the dimension fields to the entity. You can add these fields to "Selected fields" and then click on Update.

You can click on "Done" after adding the field to the excel sheet. Post this, you will need to refresh the excel sheet to look at the existing data

Was this reply helpful? Yes No
Vijay Yelmame VY 476 on at

Like (0)

Report

Gunjan Bhattacharyya (Gunjan Bhattachayya)

thanks for the reply -

I added custom dimension field in FreeTextInvoiceLineEntity.Extension but , in excel addin i can see the only Recid of dimension not the all values.

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

Like (0)

Report

Hi Vijay,

Did you add the field to the staging table related to the entity as well?

Was this reply helpful? Yes No
Vijay Yelmame VY 476 on at

Like (0)

Report

No. let me try.

Was this reply helpful? Yes No
Vijay Yelmame VY 476 on at

Like (0)

Report

I tried adding fields in staging table but it is not working.

Also there is relation with entity DimensionSetEntity .... similarly added for custom field but no luck.

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

Like (0)

Report

Could you please share a few screenshots of the changes you did?

Was this reply helpful? Yes No
Vijay Yelmame VY 476 on at

Like (0)

Report

1)Added field on CustInvoice Table

2) form changes

3) staging table

4) SQL level

EXcel

That all -

I tried one more thing which is giving me the fields in excel, added relation as shown below
and dragged Dimension field into entity.

but i think this is not the correct way.

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

Like (0)

Report

Hi Vijay,

The last way which you tried would be the correct way. If you look at the existing DefaultDimension field in FreeTextInvoiceLineEntity, it has the property Access modifier set to "Private".

We have "DimensionSetEntity" joined to CustInvoiceLine and the field DisplayValue of this entity is the mapped field "DefaultDimensionDisplayValue".

You should join the same entity to CusInvoiceLine just like you have done as per your screenshot. You can set the access modifier on the entity field "MTICPDimension" to Private and add the DisplayValue field to the entity extension. The dimension field should be available to you in the excel add-in after this.

Was this reply helpful? Yes No
Vijay Yelmame VY 476 on at

Like (0)

Report

Gunjan Bhattachayya
Thanks for the help.
I am able to see dimensions in one column as shown in below screen. but i want to show in separate column just like defaultDimension.

Finding standard code to check how they are populating dimensions in separate column, will come back.

Was this reply helpful? Yes No
Suggested answer

Gunjan Bhattachayya 35,423 on at

Like (0)

Report

Hi Vijay,

Based on the screenshot, I think the customizations are done as per this link.

I don't think this will work with the new field in the existing entity. I couldn't get that to work as I had a similar requirement a few months back. Your only option might be to create a new data entity to show the individual dimension fields.

Was this reply helpful? Yes No