We have a GI that provides PO Receipt Information. We would like the GI to exclude Returns and associated PO lines (hide them). Is there a function similar to VLookup that can be used? Below screen shot is one of the examples we are using.
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/8b28473d-e8f6-4f4c-9a2a-0a97881f83f7.png)
We tried the below formula but that is not working.
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/fd04db81-8680-4357-bcf3-6349fc8655e9.png)
I have attached a xml file of the GI. Any suggestions would be helpful, thank you!
Best answer by Robert Sternberg
View original