FormerMember

Pulling payments for specific time period for specific invoices/clients.

Posted By FormerMember

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!