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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Dimensions on header and line

(0) ShareShare
ReportReport
Posted on by

Dimensions are present on header and line records for below mentioned transactions:

 

  1. Timesheet header and line
  2. Expense header and line
  3. Sales order header and line
  4. Purchase order header and line

 

From reporting and analysis perspective, when the transactions are posted, who decides dimensions from which place should be considered for analysis, from header or from lines?

 

 

For example, when the sales order with 10 sales order lines, all having different dimensions, is invoiced:

 

Dr A/R

Cr Revenue

 

On this transaction should the dimensions on Sales Order Header be considered or should the dimensions on the individual lines be considered?

 

Ideally if 10 SO lines have different dimensions, then dimensions from the lines should be considered. But who makes this decision and where is it configured in the system.

 

And if the decision is to go ahead with lines dimensions, what happens to the dimensions on the header then?

 

Same question with other transaction as well?

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi,

    Please take a look at the following post, which describes a GL Parameter that takes care of that.

    blogs.msdn.microsoft.com/.../source-document-or-accounting-distribution

    Best regards,

    Ludwig

  • Community Member Profile Picture
    on at

    Hi Ludwig,

    Thanks for the answer. But my question is slightly different.

    For 'Source document', the dimensions from the master record is considered.

    For 'Accounting distribution' the dimensions from the lines are considered.

    What about the dimensions on the header of the transaction records?

    I am asking purely from an end analysis perspective.

    Kind Regards

    Sarang

  • Community Member Profile Picture
    on at

    Thanks Sukrut for the answer..!

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi Sarang,

    The header financial dimensions are filled by the master record for example from the customer or vendor. The paramater shown in the document for which I provided you the link defines from where the financial dimension for the summary account will be taken.

    Does that answer your question?

    Best regards,

    Ludwig

  • Suggested answer
    Mahmoud Hakim Profile Picture
    17,887 on at

    Hi Sarang Kusare

    as Dr. Ludwig Reinhard mention

    Action based on GL parameter Values used for summary account

    If you select the value ‘Source document’ in the parameter, the summary account posting will always take the dimension from the Vendor Master

    If you select the value ‘Accounting distribution  in the parameter, the summary account posting will always take the dimension from the Purchase order lines

    so if this information sufficient for you, please close this thread

  • Community Member Profile Picture
    on at

    Hello Dr.Ludwig,

    Just to sum it up:

    I now understand that header dimensions on the transactions come from the master records.

    And from an analysis perspective i understand that if the setting is 'Source document, then the dimensions from the header / master record is considered and if the setting is  'Accounting distribution' then the dimensions from the lines is considered.

    So far so good, but the next part of the question was, in an implementation, on what basis is it decided whether one should go ahead with dimensions on the header (Source document) or dimensions from the lines (Accounting distribution).

    There must be some thinking around this decision and that is what i wanted to know. If you could shed some light on that, i would get to know the entire picture.

    Thanks for the answers and understanding so far.

    Kind Regards

    Sarang

  • Verified answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi Sarang,

    The question whether to setup the parameter to source document or Accounting distributions has to be clarified with your accounting department.

    The selection that you make depends - among others - on the way how your master record and your items is setup.

    Let's assume that you need to make postings with a financial dimension "cost center". Let's also assume that this financial dimension cannot be linked to your master record e.g. your vendor because one vendor transaction can be posted with different cost centers. In this case I would select 'accounting distribution'. What you need to select depends on your business scenario and the level at which you can setup default dimensions.

    Best regards,

    Ludwig

  • Community Member Profile Picture
    on at

    Thanks a lot Dr. Ludwig this help me understand it much better.

    Kind Regards

    Sarang

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 16

#2
GiacomoRovai Profile Picture

GiacomoRovai 4

#3
Douglas Noel Profile Picture

Douglas Noel 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans