Hi, I am working on a report where I need to modify the inventory balance report and add a filter that only filters data from issues, whereas other reports import the data from receipt. This is what I did:
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/8f462e0c-89dc-4b0c-9146-b7e2a89241ae.png)
For the schema builder, I added these two relationships to establish a link:
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/3d39f87c-f122-41d7-9678-685d675301bb.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/c924a0ad-7260-40be-bc47-b1ef9df9e152.png)
I can’t seem to figure what I did wrong, I keep getting an error anytime I try to run the report with these config. If there a better way to filter the data and filter thru only Issues?
Thanks in advance :)
Best answer by Laura02
View original