Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / financial dimension
Microsoft Dynamics AX (Archived)

financial dimension

(0) ShareShare
ReportReport
Posted on by munsif 1,534

hi expert, when we create new sales order and give dimension (e.g cost center,department,business unit)more than one, so where that dimension data are stored, by default there is field in sales table named default dimension ,when i assigned only one dimension to a SO,either on sales header or sales line, then  data  in default dimension field were updated, but in case more than dimension (i.e, cost center,department,business unit) where be data will store in table, if in sales table ,then where?  and another table, then please guide

Regards.

*This post is locked for comments

  • 5400 Profile Picture
    5400 7,160 on at
    RE: financial dimension

    Default dimension is nothing but int64 field in Salestable.

    if you want to fetch the data which you are entered in sales table in multiple dimension fields

    you have to write query as below

    static void Job4(Args _args)
{
    DimensionAttributeValueSetItem  DimensionAttributeValueSetItem;
    DimensionAttributeValueSet      DimensionAttributeValueSet;
    DimensionAttributeValue         DimensionAttributeValue;
    SalesTable                      salestable = SalesTable::find('SO_0001');
    
    while select  DimensionAttributeValueSetItem
    join DimensionAttributeValueSet where DimensionAttributeValueSet.recid == salestable.DefaultDimension
          && DimensionAttributeValueSetItem.DimensionAttributeValueSet == DimensionAttributeValueSet.RecId 
     join dimensionAttributeValue where dimensionAttributeValue.recid == DimensionAttributeValueSetItem.DimensionAttributeValue
    {
       info(strFmt("%1",DimensionAttributeValueSetItem.DisplayValue));
    }

}
  • Martin Dráb Profile Picture
    Martin Dráb 230,198 Most Valuable Professional on at
    RE: financial dimension

    I thought we've just answered that. What else do you need or which part don't you understand?

  • munsif Profile Picture
    munsif 1,534 on at
    RE: financial dimension

    thanks martin,i always learn some new thing from experts, i want to know when we create sales order , and in header level i just applied more than one financial dimension ,then the record of that dimension against that SO where were store?

  • Mariano Gracia Profile Picture
    Mariano Gracia on at
    RE: financial dimension

    Look at DimensionAttributeLevelValueAllView, ValueCombinationRecId will match with salesTable DefaultDimension or SalesLine DefaultDimension, you will find one record for each dimension attribute (cost center, department...) and value.

  • Suggested answer
    Martin Dráb Profile Picture
    Martin Dráb 230,198 Most Valuable Professional on at
    RE: financial dimension

    The solution uses several tables.

    DefaultDimension contains a RecId of DimensionAttributeValueSet table; the next table you need is DimensionAttributeValueSetItem and from there you can find the actual DimensionAttributeValue.

    Nevertheless you normally don't have to work with these tables directly. If you explain what you're trying to achieve, we might show you some easier way.

  • Suggested answer
    jasman Profile Picture
    jasman 1,411 on at
    RE: financial dimension

    The DefaultDimension field relates to a record in table DimensionAttributeValueSet via Recid-field.
    The DAVSet is the gathering point for one or more DAVSetItem records.
    Each of these have a relation to DimensionAttributeValue which links to the backingentity.

    defdimexample.jpg

  • Suggested answer
    5400 Profile Picture
    5400 7,160 on at
    RE: financial dimension

    It is not in salesl table or salesline It will store in below tables.

    \Data Dictionary\Tables\DimensionAttributeValueSet

    \Data Dictionary\Tables\DimensionAttributeValueSetItem

    DimensionAttributeValueSet - recid is nothing but your default dimension in salesline or salestable.

    It has same relation with child (Dept,Cost ext) table DimensionAttributeValueSetItem

    Thanks

    Bhaskar

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans