That was a good catch! We currently have no negatives allowed so I didn’t think about it. I amended all the queries to be <>0 and it has the same results. 
I also regenerated the data model but that didn’t fix anything either.
Have you done a trace on the SQL server? A lot of times the last few SQL statements run will point to where it’s finding something it doesn’t like.
1 Like
Try looking for rows in the partbin table in general. It shouldn’t have any rows If the inventory is 0. It probably won’t matter but it removes any possible issue with rounding.
2 Likes
Remove the PartWhse for the part
Update - apparently it was because there was an open job for it. No allocations, just an open job. Terrible error message but thanks for the suggestions it really helped get it sorted out. Thanks again everyone.
2 Likes
At the time it was empty. All inventory tables were.