Hi everyone! I've got a saved search of vendor bil...
# administration
k
Hi everyone! I've got a saved search of vendor bills by paying transaction date. I have the bill amount and the paying transaction line amount, but need to add a column with a total of a vendor's paying transaction lines in the same search without forcing the user to click the vendor name in the summary to see all their individual paying transaction line amounts. Is this possible with a saved search?
k
Applying transaction joins
k
How so?
k
"Applying Transaction Fields..."
k
Got that, but it's still grouping it by transaction, I need to group it by vendor
k
I guess I'm not tracking.
You need a "total amount paid to vendor" for a particular group of vendor bills?
k
Yes, a total amount of all vendor bill payments within the filter range for each vendor
k
You'd have to have a search that didn't group on any of the transaction details.
for that to work.
k
That's what I was afraid of. Is it possible via reports or analytics?
k
i doubt it
It sounds like you are wanting mixed result set.
k
Right. 😞