Announcements
No record found.
I need the link of tables between the Sales order line and the financial dimensions.
Can someone help me?
*This post is locked for comments
The short answer it that SalesLine has a field called DefaultDimension.
Longer answers depend on what exact relation you're looking - there are many tables involved in this framework. Also note that you can use certain helper classes and views, so maybe your actual requirement can be resolved without going into deep discussions about intricacies of the data model.
The financial dimensions are data normalized and it is quite a hassle to report on them, which I assume is the premise of your question. There is only one field with a single value representing all the different dimensions and their values.
There are methods in X++ to get to them, so if you're doing SSRS reports, you would get these in your data source query directly.
If you're doing database mining for reporting you will need to go through the hard way of finding them...
You need to find the relations between the sales line and default dimension.
You can get to these directly using the the Excel add in which I would recommend for simple one off reporting.
Good luck.
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.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CP04-islander 39
Michel ROY 14
imran ul haq 8
