I have a case with NS Support, and they insist the behavior is correct. My most recent response to them is this: To be clear then, you believe that adding a column to include a Grouping of the transaction numbers actually pulls in additional transactions? The “Group” notion is purely a roll up of search results. Remember, we’re referring to the Totals of the results (the ones that add up the amounts across all the line items and displays at the bottom of the page).
We built a saved vendor search with the following setup:
Criteria:
- Inactive is false
- Transaction : Type is not Purchase Order
Summary Criteria:
- Maximum Transaction : Date is after 12/31/2015
- Maximum Transaction : Date is before 1/1/2017
Results:
- Internal ID (Group)
- Name (Group)
- Transaction : Type (Group)
- Transaction : Date (Maximum)
- Inactive (Group)
- Date Created (Group)
- Transaction : Amount (Credit) (Sum)
- Transaction: Amount (Debit) (Sum)
- Transaction : Transaction Number (Group)
When we run the search, we get totals for the results of:
Transaction : Amount (Credit) - 268,947,969
Transaction : Amount (Debit) - 176,447,732
If I remove the last column (or simply the grouping), Transaction Number, the totals change pretty significantly:
Transaction : Amount (Credit) - 267,247,454
Transaction : Amount (Debit) - 189,906,947
Why is this happening?