Possibilty about Coresuite Designer

Chi Fai Cheung

For our prospect we want the following:

Is there an option to determine the company logo on the layout of an Invoice based on the selected item? For instance to set a UDF (True or False) on the item, when selected in a sales document to determine which company logo is selected on the printout.

Thanks in advance.

Philipp Knecht

Hi Chi Fai

Yes you can bind the Image Property to whatever expression you like.
But this case seems to be a bit special bcause there can be multiple items in a sales order.
I assume that if just one of them is set to the specific value in the udf the corresponding logo should get printed?

if yes add the following to your commonscript:

Dim printLogo As String

Then in the Generatescript of the document:

printLogo = LD.QueryData("SELECT MAX(U_YourUDF) FROM O@@RDR WHERE DocEntry = " & GetData("B1_Data.Document.DocEntry"))

Then for a first testing put a textbox in the layout and set its bound value expression to : printLogo

If the value is ok then you can use it in the bound image property of the logo like:

iif(printLogo="ValueXY","C:logo1.jpg",C:logo2.jpg)

hth