Finance | Project Operations, Human Resources, ...

Financial Dimension and sales order

(0) Share

Report

Posted on by KareemTaima

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)

All responses (6)

Answers (0)

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

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

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

Like (0)

Report

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.

Was this reply helpful? Yes No
Kevin Huo on at

Like (0)

Report

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

Was this reply helpful? Yes No
KareemTaima 304 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Gunjan Bhattachayya 35,423 on at

Like (0)

Report

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.

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

Like (0)

Report

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.

Was this reply helpful? Yes No