I need help figuring out the missing piece on a Generic Inquiry.
I want my users to be able to pull up a list of items needed for Planned, Released and In Process Work Orders. I have an inquiry started but it’s listing some items multiple times and it shouldn’t.
The goal is for them to be able to see how much of Item A they need for the next 3 days or so and how much of Item B they need and so forth.
I’m attaching screenshots with the linking currently on the inquiry. I think I have a join wrong or maybe there is a link missing…
I would appreciate any input or if there is another way to get this info, please share.
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/2fbb9398-4b97-4541-9557-db515a157d8b.jpg)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/f9c7e13b-4eb1-4089-9fd7-e03a8f278fad.jpg)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/4f93dcf6-5120-4a16-9a1c-06071013f63a.jpg)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/196ddf2f-ef60-4ba8-8eba-624cfa1bd96b.jpg)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/7086fdff-94ab-4d59-a14d-369cc26e5ede.jpg)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/18710dd3-f202-4538-9ecb-b27e4f553109.jpg)
Best answer by rbrownNAW
View original