Skip to main content
Solved

Repeated lines in inquiry

  • January 13, 2025
  • 3 replies
  • 66 views
  • Translate All

Forum|alt.badge.img

Hello!

I’m trying to do a generic inquiry that shows me the sales order and the qty on hand, but some lines repeats.

Can you help me?

Thanks a lot!

 

 

Best answer by Dipak Nilkanth

Hi ​@AFAguilera,

Try to group the data by Order Nbr from the Grouping tab, so it will not duplicate the lines.

Hope, it helps!

View original

3 replies

Kandy Beatty
Captain II
Forum|alt.badge.img+18

Hi ​@AFAguilera 

What are the joins in your GI? Look under the Relations tab. 

 

Translate

Dipak Nilkanth
Pro III
Forum|alt.badge.img+14

Hi ​@AFAguilera,

Try to group the data by Order Nbr from the Grouping tab, so it will not duplicate the lines.

Hope, it helps!

Translate

Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • January 13, 2025

Allright!

I think grouping not only by order but also by line nbr is what I needed to do.
I will see that now, thank for your answers!

Translate