Finance | Project Operations, Human Resources, ...

Create custom filtrable field with default dimension string value

(0) Share

Report

Posted on by Awaxx

203

Hi all,

Is there a way to create a field for CustTrans form based on CustTrans.defaultdimension to display the string value of this one ?

This field must be filtrable so display method doesn’t work here and we can’t use defaultDimensionView because new standard method don’t work with it.

Thank you.

All responses (26)

Answers (0)

Awaxx 203 on at

Like (0)

Report

Create custom filtrable field with default dimension string value

So the range filter need the initialized event no ?
Suggested answer

Bharani Preetham Pe... 3,587 Super User 2024 Season 1 on at

Like (0)

Report

Create custom filtrable field with default dimension string value

If you need to add some filter you just need to add the range filter for that datasource. It is not again required to rejoin them as I said in my previous response.
Awaxx 203 on at

Like (0)

Report

Create custom filtrable field with default dimension string value

How did you filter the dimension attribute range ?
Bharani Preetham Pe... 3,587 Super User 2024 Season 1 on at

Like (0)

Report

Create custom filtrable field with default dimension string value

I tried the same thing added Default dimension view as a join to this CustOpenTrans form in version 37. When I click on the view settlements I am able to open the settlement transactions and it is working fine. As I said the Oninitialised event is not required.
Awaxx 203 on at

Like (0)

Report

Create custom filtrable field with default dimension string value

It was the case before but now i got the warning and the settlement form not opening.

If someone could tell me how i could do it without Using views step by step, it will be appreciate.
Bharani Preetham Pe... 3,587 Super User 2024 Season 1 on at

Like (0)

Report

Create custom filtrable field with default dimension string value

Then in this case initialised event is not required. As you are already getting it in CustTrans form, when you open settlements, the same thing will come there too.
Awaxx 203 on at

Like (0)

Report

Create custom filtrable field with default dimension string value

Here's my custTrans form where i added the same custom field named 'Campus'. This field give this dimension attribute value associated to Dimension Attribute : 'Departements'.

Then when click on settlement transaction

I used to have this screen :

Based on dimension choices :

It was working good for about 6 month and now i've got the warning i mentionned and no access to custOpenTrans form.
Bharani Preetham Pe... 3,587 Super User 2024 Season 1 on at

Like (0)

Report

Create custom filtrable field with default dimension string value

The initialised event is not required. Because from the properties of form you are already adding a link like outer join. In that case, only giving the range by getting the datasource buffer is enough.

And as you said you need to filter view settlements, do you mean when you open the view settlements from custtrans then ideally this will show based on predefined ranges from base. Can you give more details here.
Awaxx 203 on at

Like (0)

Report

Create custom filtrable field with default dimension string value

The way i wanna change is only adding a custom field reprensenting custTrans.defaultDimension value.
Users need it to filter settlement and custTrans by dimensions value on the form to find easily the one they want.

Is it a nonsense ?
Martin Dráb 230,414 Most Valuable Professional on at

Like (0)

Report

Create custom filtrable field with default dimension string value

Okay, I see. You're trying to change the form in a way that it doesn't support. You'll either have to redesign your solution, give it up or ask Microsoft to change the form.

Because the whole requirement sounds strange to me, I'd review the underlying business requirement and reconsider whether this implementation makes a good sense.