How come when I have a grouped Transaction Saved S...
# generalk
Koon Kabob
05/08/2024, 4:37 PMHow come when I have a grouped Transaction Saved Search the Sum of the Amount is showing $13,079.70 (which is wrong) but when I drill drown into this Sales Order the Sum of Amount is $6281.10 which is correct. Why is it almost doubling? This happening for all
e
Edgar Valdes
05/08/2024, 4:49 PMMain Line: true... or Main Line:false?
k
Koon Kabob
05/08/2024, 4:51 PMcurrently False (True won't work).
I guess some more info, I'm trying to show all Sales Orders and RA's and the result I have Applying Transaction : Date because I want to see when the SO got invoiced
Koon Kabob
05/08/2024, 4:53 PMm
Michael Pope
05/08/2024, 4:53 PMCan you show us what your filters and columns are?
Michael Pope
05/08/2024, 4:53 PMPerfect
Michael Pope
05/08/2024, 5:02 PMHey Sean, it's hard to say in this case. My suggestion would be this.
Michael Pope
05/08/2024, 5:02 PM(1) Filter it to a small date period
Michael Pope
05/08/2024, 5:02 PM(2) Remove all groupings
Michael Pope
05/08/2024, 5:02 PM(3) See if there are some things that are showing up that don't show up when you drill down
Michael Pope
05/08/2024, 5:03 PMSorry if that's not a great answer.
k
Koon Kabob
05/08/2024, 5:04 PMOh, it's definitely a push in the right direction. I appreciate it. Thank you :)
👍 1
p
PaulJ
05/09/2024, 9:54 PMI wonder if some of the sales orders have multiple applying transactions (ie two invoices) that would lead to double counting?
52 Views