Have the revenue report use the payment_applied date for date ranges
Have the revenue report use the payment_applied date for date ranges, since that is when the total payment for that item was entered, not when the billing detail was first billed/generated
Whiteboard
fixed the problem with credits not adding a payment_applied date, and changed the revenue2 report to only show items that have been fully paid, this will prevent items from showing up on two different reports, once if partially paid and then later then fully paid, since they can only be fully paid once. This may cause a credit to show up in a different time frame than the thing the credit was put towards if the item was only partially paid with the credit and then fully paid later.
I'm not sure if I like this way of reporting the amounts now that I see it, so i'm going to leave this in the tools folder as revenue2 for now and not link to it by default.