I am creating a GI that combines the SOOrder and SOLine tables. When I use the SOOrder.OrderNbr field as a parameter, the magnifying glass to search the Order Numbers does not show any of the sales orders. I am able to type in an Order Number in the parameter and the inquiry works but I would like to have the search functionality work properly. Is there another table that needs to be added into the GI to make the searching work?
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/2f3852d6-b032-4cce-9688-d72643408ea9.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/4de94748-7709-412b-8914-0bc713136a7f.png)
Best answer by Laura Carpenter
View original