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
Best answer by ejmillar
You need to join INItemXRef like below….
Then use the following expression:
=IIF([INItemXRef.Descr]=Null,[ARTran.InventoryID_description],[INItemXRef.Descr])
+1You need to join INItemXRef like below….
Then use the following expression:
=IIF([INItemXRef.Descr]=Null,[ARTran.InventoryID_description],[INItemXRef.Descr])
+1Add the following join clause:
Parent Field:
=’GIN’
Child Field:
INItemXRef.AlternativeType
The code for GTIN/EAN/UPC/ISBN’ is ‘GIN’
The relationship between AccountID and BAccountID is not needed.
HTH
Add the following join clause:
Parent Field:
=’GIN’
Child Field:
INItemXRef.AlternativeType
The code for GTIN/EAN/UPC/ISBN’ is ‘GIN’
The relationship between AccountID and BAccountID is not needed.
HTH
Is there an easy way to find see what the code for something like GTIN/EAN/UPC/ISBN. The way we do it is a little cumbersome and I am hoping I am just missing an easy way to view the values when there isn't a way to see them in the Element Properties like there is in the Drop Down control type
+1I don’t think there is tbh.
I would create a GI and you can use an expression to find the db value as below.
Group by the Alternative Type to get a distinct list.
Regards,
Ewan Millar.
Add the following join clause:
Parent Field:
=’GIN’
Child Field:
INItemXRef.AlternativeType
The code for GTIN/EAN/UPC/ISBN’ is ‘GIN’
The relationship between AccountID and BAccountID is not needed.
HTH
Thanks, Ewan! That is basically what we do currently.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
