I am using advanced query in inventory items and it appears to have some issue.
I use same inventory item name but with different codes. I have downloaded latest Northwind file to demonstrate this. In the image below, you’ll see that I have two inventory items but with a different code and same name.
Here are the parameters that I use for advanced query and the results where it shows zero as qty owned for Aniseed Syrup. In the results I expected it to show qty owned as 41
If I click zero, it shows me the breakdown which is correct.
Any idea how can I use advanced queries to show 41 and not zero when grouped together by the item name?
I am using Cloud 24.9.26.1860