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

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested answer

Financial Dimension and sales order

(0) ShareShare
ReportReport
Posted on by 304

Hello,

Now when I change Business unit in the financial dimension tab in sales order form, I catch the change and I display it as info box.. I found this in DimensionDefaultingControllerBase not in the form, what I need to do it's to catch the sales id at the same time at the same place, because I'll create a table with three columns sales id, Business unit name, Business unit value.. how can I do this in the same time I change the Business unit value?

I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    297,200 Super User 2025 Season 2 on at
    RE: Financial Dimension and sales order

    Hi Kareem,

    You can extend the insert and update methods on the SalesTable table. At that time there is a commit. If you try to catch the business unit change, it would be much harder to catch and the user might change it again before saving the record.

    On these methods you can find the SalesID and also find the related Business Unit from the DefaultDimenion field.

  • Suggested answer
    Gunjan Bhattachayya Profile Picture
    35,421 on at
    RE: Financial Dimension and sales order

    Hi Kareem,

    Have you taken a look at DimensionDefaultingController\updateDataSourceFK() method()?  

    You can get SalesTable/SalesLine record similarly  by datasource.cursor() method and use the same for value insertion.

  • KareemTaima Profile Picture
    304 on at
    RE: Financial Dimension and sales order

    Hi All,

    the reason for doing this, because I need to build a link that have direct access to business unit through sales id, po, pr and everything that uses business unit, because each time I open (for say) sales orders I'll filter based on the business unit that the user has or a chosen business unit from combo box

  • Kevin Huo Profile Picture
    on at
    RE: Financial Dimension and sales order

    Try add code on DefaultDimension modified. then check BU changed or not. 

  • André Arnaud de Calavon Profile Picture
    297,200 Super User 2025 Season 2 on at
    RE: Financial Dimension and sales order

    Hi Kareem,

    Please explain what your business process would have to do exactly. You are mentioning some technical details, but we don't know the functional requirement. I don't know why you want to store some duplicated data in another table.

  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Financial Dimension and sales order

    Hi Kareem Taima,

    What's the reason for doing this?

    Why you catch the change and display the change in an info box and what other things do you want to track and why?

    Would be great if you could elaborate.

    Many thanks,

    Ludwig

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…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Sohaib Cheema Profile Picture

Sohaib Cheema 665 User Group Leader

#2
Martin Dráb Profile Picture

Martin Dráb 595 Most Valuable Professional

#3
Yng Lih Profile Picture

Yng Lih 558

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans