web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Reporting on Sales Lin...
Microsoft Dynamics AX (Archived)

Reporting on Sales Line Financial Dimensions

(0) ShareShare
ReportReport
Posted on by Community Member

In AX2009 it was simple to do Fin Dims in Sales line as there where in the SQL table.   I am trying to figure out how to do the same thing in AX2012.   It looks like sometimes there is a LedgerDimension code and others there is a Default Dimension code.   Is there a setting that controls this?   I see the default Dimension code and it links to DimensionAttibutevalueset.   I see the hashtag but don't see where the hashtag links to.   Any help would be appreciated.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,210 Super User 2025 Season 2 on at

    Hi Jim,

    There is a whitepaper on the new Financial Dimensions framework. It also contains data models to help understaning the logic. You can find it here: technet.microsoft.com/.../hh272858.aspx

    I think this document would help you.

  • Community Member Profile Picture
    Community Member on at

    LedgerDimension and DefaultDimension fields are the Financial Dimension reference recId field to the the table DimensionAttributeValueSet

    You will find methods on the table to get the value.

    Please follow following link for more details

    msdn.microsoft.com/.../dimensionattributevalue.aspx

    Table DimensionAttributeValueCombination stores the combinations of dimension values any tables that uses dimension  combinations for main account and dimensions has a reference to this table’s recid

    Class Dimension storage is used to store and manipulate the values of combination

    Class DimensionStorageSegment will get specfic segments based on hierarchies

    Please verify and update us if this information helps you solve your problem

  • Community Member Profile Picture
    Community Member on at

    Thank the document doesn't discuss why or how the switch between LedgerDimension and Default Dimension.   Is there a setup option in AX2012?    

  • Community Member Profile Picture
    Community Member on at

    Please explain what you want to know when you say

    ....why or how the switch between LedgerDimension and Default Dimension....

    Please explain this to understand what you want to know.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,210 Super User 2025 Season 2 on at

    Hi Jim,

    I think you want to know when these fields are used and for what purpose?

    The LedgerDimension is used for storing the Main account and also the dimensions when the Account Type 'Ledger' is used. In case of other account types this fields, only contains the reference to e.g the customer or asset id.

    The DefaultDimension field is used for providing dimensions in cases where the account type is not Ledger.

  • Community Member Profile Picture
    Community Member on at

    It doesn't explain why some Saleslines have default dimension and some Ledger Dimensions

  • Community Member Profile Picture
    Community Member on at

    Thanks I have customers that want to report both Fin Dims and accountstructure.   It seem each process is different as some tables have Default Dimensions and some have Ledger Dimensions and some use Accounting Distribution.   In 2009 it was straight forward but doesn't seem to be so in AX2012.

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,210 Super User 2025 Season 2 on at

    Hi Jim,

    On the sales line, the LedgerDimension field contains a main account in cases where you have specified a service item and want to expense the costs on this main account. The sales line financial dimensions are stored in the field DefaultDimension.

  • Community Member Profile Picture
    Community Member on at

    Thanks that is helpful.

    Jim

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Priya_K Profile Picture

Priya_K 4

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans