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!
Answer
Repeated lines in inquiry
Best answer by DipakNilkanth
Hi
Try to group the data by Order Nbr from the Grouping tab, so it will not duplicate the lines.
Hope, it helps!
+17Hi
What are the joins in your GI? Look under the Relations tab.
Kandy ~ If a member helped you, please *Like* their post, and if a member provided an answer to your question, please mark it as *Best Answer*.
+13Hi
Try to group the data by Order Nbr from the Grouping tab, so it will not duplicate the lines.
Hope, it helps!
Dipak Nilkanth || MVP @2025 || https://www.linkedin.com/in/dipak-nilkanth-293591102 || Acumatica Developer
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!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.