AX2012 Financial Dimension Cost Center

(0) Share

Report

Posted on by Community Member

Hi all

I do have a table which should hold the CostCenter (initialized from CustTable). Now I want to have the possibility to group the data in that table on Cost Center (in a Form, Report, Export)

How can I manage that?

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (0)

dolee 11,279 on at

Like (0)

Report

Hi,

Have you consider create a View in AOT which group the data to your requirement? Then you can create forms, reports and export data based on this view.

Kind regards,

Dominic Lee

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Yes I thought about it but my problem is to save the "CostCenter" the table and to group just by that...

I just want to have the CostCenter of a related Customer in my data...all other Dimensions are not useful in this case. As understood the whole thing the DefaultDimension is always a set of Dimensions and I don't know how to show only the Cost Center value in a form (or whereever) and even I don't know how to group or filter for it

Was this reply helpful? Yes No
dolee 11,279 on at

Like (0)

Report

Try the code posted by Ali: community.dynamics.com/.../how-to-get-default-dimensions-for-vendor-and-customer-in-dynamics-ax-2012.aspx.

In case that's not enough, check out the appendix in this Whitepaper to better understand the tables used in the Financial Dimension Framework (and their relations)

technet.microsoft.com/.../hh272858.aspx

Knowing the relation, you will be able to build queries that start from CustTable and link with the CostCenter dimension alone.

Kind regards,

Dominic Lee

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I do have this code and it is fine....but it just gives a string and I do not know how to create a filter or a group for such a costcenter value. Basically the Default Dimension can have multiple entries with CostCenter(eg. '1234')

Example. I want to print an internal list having the data from my table (which holds CostCenter in a field of type DimensionValue). On the Dialog before printing I want to add a filter for CostCenter to just print data related to this or print the list grouped by costcenter...thats what I don't get

Was this reply helpful? Yes No
dolee 11,279 on at

Like (0)

Report

So, you have a CustomTable with a DimensionValue field containing CostCenter information. Now DimensionValue field is a string field, you can just add filter and grouped by this field like normal string field.

What were you expecting to see and that ain't working for you?

Was this reply helpful? Yes No
André Arnaud de Cal... 301,075 Super User 2025 Season 2 on at

Like (0)

Report

Hi Chris,

Which version of AX are you using? Can you explain more on the 'a table' and what you mean with 'group the data'? Do you want to summarize or just having a sorting?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi, as mentioned in the title it is AX 2012....the table is a special version for Commission and I want to hava a sorting on cost center AND a summarization on it as well

Was this reply helpful? Yes No
André Arnaud de Cal... 301,075 Super User 2025 Season 2 on at

Like (0)

Report

Oops overlooked the title ;-)

Just like Dominic mentioned, you can create a string field in a new custom table. In this way it is easier compared to the Default dimensions. But it will be limited to only this dimension.

If you have used the organization unit 'Cost center' and linked this to the dimensions, you can also consider saving the organization link in stead of the dimensions.

A sample with Department is available in the HRM module.

Was this reply helpful? Yes No