I have a summary search for a specific customer. I...
# general
e
I have a summary search for a specific customer. It shows Open Invoices (Grouped), and shows the Qty of the SKUS (Summed). When I view the Saved Search, the sum of the Quantity column is showing double the actual Sum for Inventory Items, but showing correctly for all other item types?? ie. Invoice INV001 has SKU ABC with Qty 2 (Inventory Item) and SKU XYZ Qty 2 (Non-Inventory Item) on it. In the Summary Search, the Sum of Qty for ABC shows 4 (double the actual sum??), and the Sum of Quantity of XYZ Shows 2 (correctly). When I click on the Invoice Number to Drill Down to that Specific Invoice, It Shows 2 lines; SKU ABC with a Qty 2, and SKU XYZ with a Qty 2. Any one know why the Summary would double the Qty for certain item types?
j
@ericbirdsall Un-group and un-sum your search, run it, and look at the actual search detail being returned (versus drilling into the transaction record). Dollars to donuts you've got some piece of data that's duplicating for each line item (hard to say what without looking at it).
e
Thanks for the reply @James Morris - I had a critera of
Item : Name is not "End of Group"
, for whatever reason, when I removed that criteria, the numbers displayed as anticipated.
j
Glad it worked out 👍. Those summaries are always a little bedeviling.