I am trying to figure out how to get this report and the same report that shows job detail to filter by vendor. I have 4 big vendors that I need this information on, not every vendor we have paid in the specific timeframe I am looking at.
I have gone so far as to add a "supplier type" to each of those 4 vendors (a field I haven't used in the past with any vendors) calling them "suppliers" and then filtered on that, and I still couldn't get those 4 vendors isolated on the report. As a matter of fact the report blanked out completely :(
I am sure there is a simple solution that I am overlooking because I have been fighting with this report for awhile now.
Yes, manual manipulation of the data using Excel is certainly an option, but it is also takes a lot of time and effort. I was really hoping that I could get this report to do what I need it to do without resorting to a manual Excel process.