Report to show Customer Payments entered as of a certain date for Invoices that were Open as of a certain period

1. Navigate Reports > Customers/Receivables > A/R Payment History by Payment.

 

2. Click on Customize button.

 

3. In the Edit Columns link > click on Transaction Dimension folder > select Date field.

 

4. In the Filters link > click on the field for Invoices by Payment : Date and select Insert button.

* This will lead to a blank filter to which we can replace it with the field from Transaction Dimension folder and selected Date field to be used as main filter footer.

 

5. Still in the Filters link > set the following fields and exposed them to show in footer as well:

--- Transaction Dimension : Date = 1/1/2013 to 3/31/2013 {select the date for when the Payments have been made}

--- Invoices by Payment : Date = before and including 12/31/2012 {select the date of the Invoice}

 

6. Enter a title for the report.

 

7. Hit Save button.

 

This report gives all payments made between 1/1/2013 to 3/31/2013 for invoices that were open as of 12/31/2012.