Automatic Dimension Values While Creating Project

(0) Share

Report

Posted on by Community Member

Hello everyone,

We have requirement to give financial dimension value automatically while creating project. That value coming automatically will be stored in the proj group table. That value will be fetched while creating project. I tried to find table storing dimension values for particular project. In D365 MS has used Dimension Entry control for displaying dimensions.

I checked default dimension for the project and found one record in DIMENSIONATTRIBUTEVALUESET. This table is storing all dimensions for this project but when I tried to find field I found DEL_ValueSetHash1 and similar 5 fields. But in SQL all fields I can see even my dimension values attached with that project. Can anyone explain me same?

What approach I should use to update dimension value as there is no field available from back end? Any inputs will be helpful.

Thanks in advance.

Regards,

Smit

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (2)

Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi Smit,

I did something similar in AX2012 for fixed assets

dynamicsax-fico.com/.../alternative-methods-for-reconciling-inventory-with-general-ledger

dynamicsaxfico.files.wordpress.com/.../en_32_0030.png

Is your requirement similar/related?

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report
Copy link

Link copied!

Hi Ludwid,

Thanks for your reply. Yeah I have similar requirement for project creation. Your code i understood and fine for requirement.

I checked in D365 using same but they have obsolete AXddimensionutil class itself and saying to use dimensionresolver class. But not able to find anything in that.

Again thanks. I will update if find any solution.

Regards,

Smit

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Smit,

Would be great if you could keep us updated on this one and help getting a standard functionality for that by voting on the suggestion that I just created (ideas.dynamics.com/.../ID0001622).

Many thanks and best regards,

Ludwig

Was this reply helpful? Yes No
Verified answer

André Arnaud de Cal... 303,691 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hi Smit,

It would be possible to extend the ProjGroup table and have a DefaultDimension field. The form can also be extended to show all default dimension like on the Project form or Customer details.

When this is completed, you can just extend the initFromProjGroup() method from the ProjTable table to copy the DefaultDimension field to the project DefaultDimension field. This will copy all selected values from the group. It will be done on selecting the group rather than the insert as done in Ludwigs post. Then you don't need to copy individual dimensions using a dimensionutil or resolver class. Moreover, your don't need to hard code dimension names or create setup field for it. And it is much more simple. When a sales order is created, the same is done by copying the default dimensions from the customer to the sales order header.

Was this reply helpful? Yes No
Community Member on at

Like (2)

Report
Copy link

Link copied!

Hi Andre,

It was fantastic solution. It worked for me. Whatever id based on combination is stored on projGroup we will pass same combination during creation of project.

Regards,

Smit Patel

Was this reply helpful? Yes No