im creating a commissions report and I only want it to show on Invoices that changed to Paid In Full in the last month. I have an invoice created in May and doesn't get paid until July, how do I trigger it so that the May invoice will still show up in the July commission report? I can't use transaction date because that only shows invoices that were created in July. I tried using payments, but then it doesn't pull all the information from the Invoice that I need

date closed

Be aware Date Closed has some flaws if the payment or credit memo applied to the invoice is dated in the past. Closed date shows the transaction date of the applied transaction (which could be anything), rather than the date it was actually applied and closed. Jordan, we did something similar to you except we created a custom field to actually store the system notes date of when it became paid in full. We have a workflow running on a schedule to set the value.

good to know, @Joanna Curtis, was unaware of those issues. Thanks.