When I run an open invoice report that includes an invoice that has scheduled payments, the entire remaining balance shows up on the open invoice report, even if future sheduled payments for that payment lie outside of the parameters set up in the general tab. I have attempted to create a query that...

We have attempted to run a Vendor Query to identify vendors with total payments greater than $100K for a year. We have set the criteria to look for post dates in 2009 and for total payment to be greater than $100K. When we run this query, the total payment amount that it returns does not match what was...