Finance | Project Operations, Human Resources, ...

Set a certain financial dimension

(2) Share

Report

Posted on by ..

2,005

Hi,

How to set a certain financial dimension by code?

So in SalesTable header, i have mutiple finanical dimensions, where one of them i want to fill it based on salesLine

So this "flow" is empty in SalesTable, and I want to fill it by code based on the "Flow" value for one of the SalesLines that have the highest salesPrice

how can i do that?

So i was able to get the "Flow" value for the SalesLine with the highest SalesPrice... it's the DisplayValue from from dimensionAttributeValueSetItemView
but now how to set it for SalesTable??

        SalesTable                          salesTable;
        SalesLine                           salesLine;
        DimensionAttribute                  dimensionAttribute;
        DimensionAttributeValueSetItemView  dimensionAttributeValueSetItemView;


        select firstonly RecId from dimensionAttribute where dimensionAttribute.Name == 'Flow';

        select firstonly DefaultDimension from salesLine 
         order by SalesPrice desc
         where salesline.SalesId == 'XXXSO' ;

        select firstonly DisplayValue from dimensionAttributeValueSetItemView
            where dimensionAttributeValueSetItemView.DimensionAttributeValueSet == salesLine.DefaultDimension
                && dimensionAttributeValueSetItemView.DimensionAttribute == dimensionAttribute.RecId;

        ttsbegin;
        //select forupdate salesTable where salesTable.SalesId == 'XXXSO';
        //salesTable.DefaultDimension = salesline.DefaultDimension
        ttscommit;

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Suggested answer

Waed Ayyad 9,135 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Check the following link:
https://brianjparker.tech.blog/2017/03/24/writing-to-financial-dimensions-defaultdimension-in-x/

Thanks,

Waed Ayyad

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

Was this reply helpful? Yes No
.. 2,005 on at

Like (0)

Report
Copy link

Link copied!
Hi,

I wrote this code but it's not working
when i debugged dimensionAttributeValueSetStorage after calling addItem, i didn't see the new value, even though i can see the value in dimensionAttributeValueSetItemView.DisplayValue
SalesTable salesTable; SalesLine salesLine; DimensionAttribute dimensionAttribute; DimensionAttributeValueSetItemView dimensionAttributeValueSetItemView; DimensionAttributeValueSetStorage dimensionAttributeValueSetStorage; DimensionAttributeValue dimensionAttributeValue; select firstonly RecId from dimensionAttribute where dimensionAttribute.Name == 'Flow' select DefaultDimension, SalesId from salesLine where salesLine.SalesId == XXXSO; if(salesLine.DefaultDimension) { select firstonly DisplayValue from dimensionAttributeValueSetItemView where dimensionAttributeValueSetItemView.DimensionAttributeValueSet == salesLine.DefaultDimension && dimensionAttributeValueSetItemView.DimensionAttribute == dimensionAttribute.RecId; salesTable = salesTable::find(salesLine.SalesId); dimensionAttributeValueSetStorage = DimensionAttributeValueSetStorage::find(salesTable.DefaultDimension); dimensionAttributeValue = DimensionAttributeValue::findByDimensionAttributeAndValue(dimensionAttribute, dimensionAttributeValueSetItemView.DisplayValue, true, true); dimensionAttributeValueSetStorage.addItem(dimensionAttributeValue); dimensionAttributeValueSetStorage.save(); }

Was this reply helpful? Yes No
Suggested answer

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

Like (0)

Report
Copy link

Link copied!

You said you debugged the code and didn't see the value, but not where do you expect to see the value.

The purpose of this code is generate a new dimension combination value (RecId), which is returned by save() method. An obvious problem of your code is that you ignore this value; you haven't assigned it to to salesTable.DefaultDimension.

Was this reply helpful? Yes No
Justin Kruger 186 on at

Like (0)

Report
Copy link

Link copied!
Hi,

Once you have your dimension combination value that you get by calling DimenstionAttributeValueSetStorage.save() you can assign it to your DefaultDimension field.

DimensionDefault defaultDimension; defaultDimension = dimensionAttributeValueSetStorage.save(); ttsbegin; salesTable.DefaultDimension = defaultDimension; salesTable.update() ttscommit;

Was this reply helpful? Yes No
Waed Ayyad 9,135 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Is your issue resolved? If yes, mark the answers that helped you as verified.

Thanks,

Waed Ayyad

Was this reply helpful? Yes No
Waed Ayyad 9,135 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Is your issue resolved? If yes, mark the answers that helped you as verified.

Thanks,

Waed Ayyad

Was this reply helpful? Yes No