I am having trouble finding any AP report that I can range/condition to display both the check date, not payment date, and the original invoice date. The payment date is prefilled when the invoice is entered, so that data is meaningless, the actual check date is what we care about. For example I'd like to look at one specific vendor on one job and see what dates their checks were cut and what invoice dates those correspond to. I thought this would be a relatively commonly used report, but I'm having trouble being able to condition any of the standard AP reports in this way. I can easily display payment dates, invoice dates, and check dates for one vendor on one job on separate reports, but having all of that info on one report would be much easier to look at.
Any ideas? Or am I better off just having a custom report built?
