I have a simple SelectFrom where I am getting all of the AMBomMatl items (joining them with the Operation and BomItem tables) who’s ItemClassID equals ‘811’, but for some reason I am not getting any results. When I look through the var object results I only noticethe ‘Single row was requested’ error which to be honest I don’t know what it means.
I have been following this documentation but with no luck. I have done other SelectFrom’s before with success but not this for some reason. Any ideas?
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/30a202b2-fa8d-4df9-87d2-7670ab819507.png)
Best answer by manley75
View original