Skip to main content

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!

 

 

Hi ​@AFAguilera 

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

 


Hi ​@AFAguilera,

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

Hope, it helps!


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!


Reply