Skip to main content
Answer

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

  • June 28, 2024
  • 3 replies
  • 186 views
M
Freshman I

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])

Kandy Beatty

3 replies

ejmillar
Varsity II
Forum|alt.badge.img+1
  • ejmillar
  • Varsity II
  • Answer
  • June 28, 2024

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.~
Kandy Beatty
Chris Hackett
J
Freshman I
Forum|alt.badge.img
  • jdabney37
  • Freshman I
  • November 17, 2025

DId this work for you? I can’t get my UPC code on the AR invoice. Do you mind sharing?

 

ejmillar
Varsity II
Forum|alt.badge.img+1
  • ejmillar
  • Varsity II
  • November 18, 2025

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

Ewan ~ Rubech IT ~ Please remember to "Mark Best Answer" to help those who are facing the same problem.~
Chris Hackett
Terms & ConditionsCookie settingsAccessibility statement
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved