This topic contains 4 replies, has 0 voices, and was last updated by j.j 7 years, 9 months ago.
-
AuthorPosts
-
February 17, 2017 at 10:02 am #4958
VoltronI 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?
This is a cached copy. Click here to see the original post. -
February 17, 2017 at 10:11 am #4959
david.smithMost likely you’re getting both the body and the lines. Also, you don’t need the inactive in your results if you’re criteria has it set to false.
-
February 17, 2017 at 10:26 am #4960
VoltronThanks, David. I’m sure I am getting header and lines. The lines share the transaction number, so that shouldn’t make a difference. It’s a rollup. The totals per line would, of course, change with a grouping that results in more lines, but, I’ll reiterate, my contention is that regardless how the rollup occurs, the complete totals should not be impacted.
I thought I had a good hold on summaries and summary criteria, but this is making me doubt
-
February 17, 2017 at 10:52 am #4961
david.smithTry changing from “transaction number” to “Number” (tranid) and see what happens.
-
February 19, 2017 at 9:32 pm #4962
j.jalso the summary criteria is in 2 lines, you can rather put it in a single filter as – Maximum Transaction : Date is within 12/31/2015 and 1/1/2017
-
AuthorPosts
You must be logged in to reply to this topic.