Greetings, it is possible for the variables of Alternate ID to be reflected as for example in excel, individual columns?
example:
Solved
Same variable on different column - generic inquiry
Best answer by Laura02
Hello,
I was able to move the alternate id’s into separate columns using Iif Statements, like this:
=IIf([INItemXRef.AlternateType]='BAR',[INItemXRef.AlternateID],' ')
=IIf([INItemXRef.AlternateType]='BAR',[INItemXRef.AlternateID],' ')
I think this is a partial answer for you - since the results are not on the same line. I found four possible values for Alternate Type:
Laura
+19Hello,
I was able to move the alternate id’s into separate columns using Iif Statements, like this:
=IIf([INItemXRef.AlternateType]='BAR',[INItemXRef.AlternateID],' ')
=IIf([INItemXRef.AlternateType]='BAR',[INItemXRef.AlternateID],' ')
I think this is a partial answer for you - since the results are not on the same line. I found four possible values for Alternate Type:
Laura
Laura ~ Klear Systems, Inc. Irvine, CA. ~ Click my logo to Follow me ~
Thank u Laura, Its work with the barcode but I’m having struggle with the Customer Part Number. I also wanna ask as for the Alternate Type where in SQL can we find it? So we can do a query
1 person likes this
alejandradiaz68 wrote:
Thank u Laura, Its work with the barcode but I’m having struggle with the Customer Part Number. I also wanna ask as for the Alternate Type where in SQL can we find it? So we can do a query
+19Hello,
The table I found the Alternate Type values in INITEMXREF.
Laura
Laura ~ Klear Systems, Inc. Irvine, CA. ~ Click my logo to Follow me ~
1 person likes this
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.