Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

Financial Dimension and sales order

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?

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,280 Super User 2024 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
    Gunjan Bhattachayya 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
    KareemTaima 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
    Kevin Huo 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
    André Arnaud de Cal... 291,280 Super User 2024 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
    Ludwig Reinhard 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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans