Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

How could I add a field to a custom table saving single financial dimension values per record?

(0) ShareShare
ReportReport
Posted on by 1,650

Hello,

I know how to store the combination of multiple financial dimension values like in the CustTable (CustTable.DefaultDimension). But in my case I need to store only a single financial dimension value to map the value to a custom value.

I would like to add a field to a custom table in order to store a value of a single financial dimension (e.G.: "Cost Center = Marketing")?

The table and the form should look like this:

25_2D00_05_2D005F00_2023_5F00_10_2D00_11_2D00_54.jpg

The field / column "financial dimension cost center" should have a lookup to the financial dimension like the single dropdown field in the CustTable: 

Thanks for any hint.

Sebastian

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,971 Super User 2025 Season 1 on at
    RE: How could I add a field to a custom table saving single financial dimension values per record?

    Hi Sebastian,

    In case your requirement is only about a the cost center backed with the entity operating units, you can create a lookup to the OMOperatingUnit table and set a fixed value for the OMOperatingUnitType.

    There is an example how to do this with the department type.

  • Suggested answer
    GirishS Profile Picture
    GirishS 27,821 Super User 2024 Season 1 on at
    RE: [D365FO] How could I add a field to a custom table saving single financial dimension values per record?

    Hi Sebastian,

    You can refer to the standard view DefaultDimensionView - This view will contain dimension value against cost center, Department etc.

    You can use this table to get the single financial dimension value and insert into your custom table.

    Thanks,

    Girish S.

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.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,971 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,846 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans