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!
Solved
Repeated lines in inquiry
Best answer by Dipak Nilkanth
Hi
Try to group the data by Order Nbr from the Grouping tab, so it will not duplicate the lines.
Hope, it helps!
+18Hi
What are the joins in your GI? Look under the Relations tab.
+14Hi
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!
Login to the community
No account yet? Create an account
Social Login
Login with your Acumatica accountEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.