Is there a way to add report logic to pull the alternate ID based on the value of the Alternate Type?

Question

Hello,

My company has multiple cross references for each product. One is global, one is an ISBN, and another is a Customer/Vendor part number.

On my SO report and Invoice report, I need to include the ISBN. I am having trouble writing the logic necessary to say that if the alternate type is GTIN/EAN/UPC/ISBN then pull the alternate ID. If null, nothing.

Thanks

Page 1 / 1

You need to join INItemXRef like below….

Then use the following expression:

=IIF(IINItemXRef.Descr]=Null,uARTran.InventoryID_description],oINItemXRef.Descr])

Reply

ejmillar · Accepted Answer

You need to join INItemXRef like below….Then use the following expression:=IIF([INItemXRef.Descr]=Null,[ARTran.InventoryID_description],[INItemXRef.Descr])

Reply

Sign up

Social Login

Login to the community

Social Login

Scanning file for viruses.

This file cannot be downloaded