Skip to main content
Answer

Duplicate GI Lines

  • July 23, 2024
  • 6 replies
  • 126 views

Forum|alt.badge.img

Hello,

 

I have a GI that I created to take SO’s to SO Lines so we can see the SO by inventory items. The team wanted to add the opportunity stage status, which has now created duplicate lines. I thought if I grouped by inventory item it would help, but it removed the below order I have been sampling. Anyone have an idea what the easiest solution fix is. I would like to be left with the line(s) with the stage ID and the duplicates can go away. Thanks

 

 

Best answer by darylbowman

Ah, that would do it. Try adding this to your relationship:

 

6 replies

darylbowman
Captain II
Forum|alt.badge.img+15

Hey Jason 👋🏼 Would you mind exporting and sharing the GI?


Forum|alt.badge.img
  • Author
  • Varsity I
  • July 23, 2024

@darylbowman   Thanks - I have attached it.


darylbowman
Captain II
Forum|alt.badge.img+15

Does that particular Order have more than one related Opportunity?


Forum|alt.badge.img
  • Author
  • Varsity I
  • July 23, 2024

@darylbowman - No it has one opportunity and one quote

 

 


darylbowman
Captain II
Forum|alt.badge.img+15

Ah, that would do it. Try adding this to your relationship:

 


Forum|alt.badge.img
  • Author
  • Varsity I
  • July 23, 2024

This worked great. Thank you for the support!!!