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 .

[J Siva · Accepted solution]

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

[Ankur Bawiskar · Accepted solution]

@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.

[Ankur Bawiskar]

@Aniket Shukla 

whichever field is marked as Display=true on that table will show once you select the variable

If you want to see ERP Supplier Code then you need to make that field as Display=True at dictionary level

But remember this will impact entire instance wherever this table is being referred.

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

[Aniket Shukla]

Did not work with display true of erp code and only legal name was visible.

[Ankur Bawiskar]

@Aniket Shukla 

please share your variable config and also the dictionary screenshots.

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

[Aniket Shukla]

following are screenshots