Hello! Thank you in advance!
I am attempting to pull payments received from 01/01/19 - 08/31/19 only for invoices dated 01/01/19 - 08/31/19. Any report I try to create ends up pulling in payments that I've recorded during that time frame, regardless of the corresponding invoice (i.e. a payment for an invoice dated 12/01/18).
For example, I have billed a specific client a total of $1,000.00 from 01/01/19 to 08/31/19. When I pull an A/R report for 01/01/19 - 08/31/19, I have $1,050.00 in payments because $50 was paid on 01/05/19 for an invoice dated 12/01/18.
I have tried numerous reports configurations but cannot figure out how to pull an A/R report for a specific date/set of invoices only.
Thank you!