Page 1 of 1

Using a varliable List to hold display substitute value

Posted: Tue Jan 28, 2025 6:02 pm
by manic2003
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)

Re: Using a varliable List to hold display substitute value

Posted: Tue Jan 28, 2025 10:23 pm
by Lech Kulikowski
Hello,

Please check the following expression:
{SUPCODE.Contains(ObjectDetails.businessPartnerCode + ObjectDetails_itemsWithSpecialLines.itemCode)}

If the issue is still present, please send us a sample report with test data that reproduces the issue for analysis.

Thank you.