Skip to main content
Solved

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

  • 28 June 2024
  • 1 reply
  • 38 views

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​​​

1 reply

ejmillar
Rank
Userlevel 5
Badge +1

You need to join INItemXRef like below….

 

 

Then use the following expression:

=IIF([INItemXRef.Descr]=Null,[ARTran.InventoryID_description],[INItemXRef.Descr])

Ewan ~ Rubech IT ~ Please remember to "Mark Best Answer" to help those who are facing the same problem.~

Reply


Terms & ConditionsCookie settings