Hi All
I am working on a report in report designer and need to pull the below line only into the report for the field I am setting up. Since there are many values in the Cross Reference section, does anyone have a suggestion on how to write it so only the one line pulls and nothing more?
Best answer by Zalman
Hi there,
In the Relations section, try adding the following conditions:
InventoryID = InventoryID
AlternateType = 'BAR'
UOM = 'CASE'
If your items may have more than one “CASE” UOM, you can also include an additional condition such as Descr = [the specific value you consistently use] to ensure only the correct line is pulled.
Hi there,
In the Relations section, try adding the following conditions:
InventoryID = InventoryID
AlternateType = 'BAR'
UOM = 'CASE'
If your items may have more than one “CASE” UOM, you can also include an additional condition such as Descr = [the specific value you consistently use] to ensure only the correct line is pulled.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
