I have a saved search that I'm trying to use to compare how much of an item was Estimated to a customer vs how much was actually put to Sales Orders.
When I drill down, here we can see the customer, the items and the related transactions they appear on. The quantities are all coming through correctly, but the issue occurs once I try to summarize the results.
From the consolidated view, there are three items missing which are the ones highlighted in the above image. So the items it's missing are the ones that were both quoted for and sold, so there is an issue with it trying to Sum/Group the results and I'm not sure what. It's the same item to the same customer, so the grouping should be fine, then it just needs to sum with the 63MR10 example, Qty Quoted = 1 + 1 + 0 + 0 and Qty Ordered = 0 + 0 + 2 + 2.
In the search itself, the results are only being grouped by Customer Name and Item to which there certainly are matching sets. I'm really not sure why the quantity for the SOs isn't being summed at all.
Results:
Criteria:
Would really appreciate the help if anyone can spot my mistake.
In the meantime, I may try and create the search from scratch to see if I can come out with a different result.