Updating financial dimension in D365FO in from through x++

(3) Share

Report

Posted on by krishna.rao@dax

3,022

tiHi Team,

Expense management -> expense reports -> new expense report.

While creating new expense report, financial dimensions are automatically coming from employee setup. We need to update one of the custom financial dimension 'Funding_type' to some value while creating new expense report, which will be configured in parameters form part of customization instead of employee setup.

Could you please assist here x++ coding wise.

Find below screenshot for reference.

Thanks in advance,

Krishna.

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Adis 6,806 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hello,

I am not a developer, so I cant assist you, however, no one can paste you the exact code as no one knows the configuration in parameters form you mentioned.

What would help others in order to help you is to tell us what you have so far and at which point you are stuck.

Kind regards, Adis

If this helped, please mark it as "Verified" for others facing the same issue

Keep in mind that it is possible to mark more than one answer as verified

Was this reply helpful? Yes No
Verified answer

Martin Dráb 239,670 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!
Use DimensionAttributeValueSetStorage class to manipulate default dimensions. For example:

// Load dimensions to the the storage class (based on a table field) DimensionAttributeValueSetStorage dimStorage = DimensionAttributeValueSetStorage::find(yourTable.DefaultDimension); // Get the dimension attribute DimensionAttribute dimAttr = DimensionAttribute::findByName(...); // Find or create the dimension value record DimensionAttributeValue dimValue = DimensionAttributeValue::findByDimensionAttributeAndValue(dimAttr, 'New value' , false, true); // Assign the new value to the dimension set dimStorage.addItem(dimValue); // Generate a new ID of the dimension set and assing it to the table field yourTable.DefaultDimension = dimStorage.save();

Was this reply helpful? Yes No
krishna.rao@dax 3,022 on at

Like (0)

Report
Copy link

Link copied!

Thanks Team responses so far.

I have raised this thread to assist on how to write code. as it's bit different, Already debugged , this is not straight forward ..

Was this reply helpful? Yes No
André Arnaud de Cal... 305,550 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Krishna,

Can you tell us if the reply from Martin is helpful for you? It explains how to interact with the dimensions. You only need to implement it for the correct dimension in your environment. What exact coding did you use? What was the debugger outcome?

Was this reply helpful? Yes No
krishna.rao@dax 3,022 on at

Like (1)

Report
Copy link

Link copied!

Hi Andre,

It looks like working I need to do further tests and will update here.

Thanks so much for prompt response Martin and everyone on this..

Was this reply helpful? Yes No