Hello everyone,
I have a custom financial dimension named 'SalesOrder'. Every time I create a new Sales order, a record having same salesId also gets created in my custom dimension values and a custom master form.
I have a field named 'User dimension 1' on sales line and the field contains a lookup of all the sales order Id values(custom master form ), Now the requirement is that when ever I select a value in user dimension 1 field, the custom financial dimension value should also get updated with the same value as user dimension 1.
I am able to do this for a single form(ex: SalesTable form) using code, but the requirement is to have this functionality for all the forms containing user dimension 1 field.
There is a standard similar functionality in the system for linking the financial dimension with site(whenever a site value is filled, the linked financial dimension value auto populates). I want a similar functionality with my custom financial dimension.
Since I'm new to this, I don't have any idea if this is even possible and if it is, then how to approach to the solution.
Please provide your valuable suggestions and advice on how to achieve this.
