Record producer Variable

[Aniket Shukla]

Reference variable is taking different field value from reference table and i need different value of same table . Can that happen? legal name is displayed but need erp supplier code to display in variable .

[Ankur Bawiskar]

@Aniket Shukla 

you didn't set the Display=True on your dictionary for ERP Code

Then how did you say that it's not working.

Please mark that and then see

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Aniket Shukla]

Hi @Ankur Bawiskar  i did that but one it will impact other instance as well, is there any substitute method for this. And also when i did display to true it shows correctly but may impact entire instan

ce.

[Ankur Bawiskar]

@Aniket Shukla 

that's what I informed earlier, it would be a global change.

you can use variable attributes to show the other fields when user types in some value.

see how it's done by @J Siva 

If my response helped please mark it correct and close the thread so that it benefits future readers.

[J Siva]

Hi @Aniket Shukla 

I believe the "Legal Name" field is currently set to display by default because its display value is set to True.
Based on the requirement, you have two options:

1. Update the Display field in the reference table – This change will be applied globally across the instance.
2. Add the following variable attribute to display both the legal name and the ERP supplier code.

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=legal_name;erp_code,ref_ac_columns_search=true

Regards,
Siva

[Aniket Shukla]

Both didn't work in my case .