Using a varliable List to hold display substitute value
Posted: Tue Jan 28, 2025 6:02 pm
Hi,
I have been struggling to get this to work. I have an excel file with 2 columns (SupplierCode$ItemCode) and (ItemCode).
The 2nd column holds a specific supplier part number for items.
We have a Purchase Order template that has a column to display the value of this field.
Trying to use a variable called "SUPCODE" which is a "List" variable and the data source is the excel file.
Trying to use the following expression on a text field : {SUPCODE.Contains("{ObjectDetails.businessPartnerCode}${ObjectDetails_itemsWithSpecialLines.itemCode}")}
The idea being that it should compare against the excel file and in its place display (ItemCode)
I have been struggling to get this to work. I have an excel file with 2 columns (SupplierCode$ItemCode) and (ItemCode).
The 2nd column holds a specific supplier part number for items.
We have a Purchase Order template that has a column to display the value of this field.
Trying to use a variable called "SUPCODE" which is a "List" variable and the data source is the excel file.
Trying to use the following expression on a text field : {SUPCODE.Contains("{ObjectDetails.businessPartnerCode}${ObjectDetails_itemsWithSpecialLines.itemCode}")}
The idea being that it should compare against the excel file and in its place display (ItemCode)