Skip to main content
Answer

Inquiry to display configuration attributes with invoiced lines duplicating records

  • August 8, 2022
  • 2 replies
  • 87 views

Forum|alt.badge.img+1

We have two attributes tied to configurations. We would like to display the value of the attribute in the invoiced line item inquiry. The inquiry is working except that there are two records generated for the invoice lines with configurations. I’ve tried various join types and can’t get the inquiry to return one record per invoiced line. Here are snips from the system:

Production Order attributes tab
Configuration Entry attributes tab
Inquiry displaying multiple records for the invoiced line with each attribute separate
GI tables
GI relations - configuration results attributes
GI Results Grid with formula to display attribute CFGAPIIN as OPT1

The inquiry returns the correct number of records if I deactivate the relation to AMConfigResultsAttribute and the related fields in the grid, so I’ve narrowed it down to that part of the inquiry. Any suggestions on how to eliminate the duplicates would be greatly appreciated.

Thanks!

Best answer by Laura03

Hello,

What field(s) is the inquiry grouping on ? If nothing, maybe try order number & Line number, Production number & Line number.

 

2 replies

Laura03
Captain II
Forum|alt.badge.img+19
  • Captain II
  • Answer
  • August 8, 2022

Hello,

What field(s) is the inquiry grouping on ? If nothing, maybe try order number & Line number, Production number & Line number.

 


Forum|alt.badge.img+1
  • Author
  • Semi-Pro II
  • August 8, 2022

Thanks! I added the following grouping and it eliminated the duplicates while providing both attributes.