Announcements
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 !!
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
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.
Did you add the field to the staging table related to the entity as well?
No. let me try.
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.
Could you please share a few screenshots of the changes you did?
1)Added field on CustInvoice Table2) form changes3) staging table4) SQL levelEXcelThat all -I tried one more thing which is giving me the fields in excel, added relation as shown belowand dragged Dimension field into entity.but i think this is not the correct way.
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.
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.
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.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 426 Super User 2026 Season 1
Subra 371
Martin Dráb 279 Most Valuable Professional
