It is possible to create a reference between one Pricing Company Parameter which is taken as the source and another Pricing Company Parameter which takes values from the first one (available in that column as a drop-down menu). You can also reference other tables in the system, e.g., Customer, Product Extension.
This is useful if you need to restrict users to select values from another Pricing Company Parameter table or to set a new Pricing Company Parameter table quickly with data provided by the source Pricing Company Parameter.
- Go to Master Data > Pricing Company Parameters and select your source Price Company Parameter.
- Right click the column header of the key or attribute from which you want make the reference and select 'Add columns to Rename... / Restrict Values list'. (For details see Customize Columns.)
- In the next pop-up window either keep the original label name or write your own.
- After clicking OK, select the second Price Company Parameter which will take values from the first.
- Right click the column header of the key or attribute you want make the reference to and click on 'on Rename and Customize Column'. (For details see Customize Columns.)
- In the 'Restrict Values' field choose 'By Data Source' and and click the Add button Add button below.
- Select your Data Source field that you named in Step 3, select the correct column in Fields and click the Select the Select button.
- Back in the Rename and Customize Column window click the Rename button.
- Go to your desired column and double click the field – a drop-down menu with the restricted values should appear.
