Click the Customer (1) button to select a specific customer or leave the default **ALL** to search through all customer payments. From the Item Reference (2) drop down menu, you can select to Search (5) by the following criteria: Job #, Job Name, Item Reference, Item Amount, Invoice #, Amount Paid, and Status (I for Invoice or S for Service Charge). After making an Item Reference selection, to further narrow the search, you can enter a Beginning and Ending Post Date (3) for the payment and/or a Beginning and Ending Invoice Date (4). Click the Build (6) button after entering a date range or changing the Customer ID. The Clear button is used to clear Search criteria for the same customer so a new selection can be made.
At the top left, you will see a Print option next to the Exit option. This option will allow you to print an A/R Invoice and Payment Report. This report is designed to provide detail on a Customer’s account including Invoices, Credit Memos, Payments, and how Payments were applied to Invoices. The data on this report is the same as what can be printed on an A/R Statement, but this report will include purged (month end or cleared account activity) and will allow you to set a date range. Currently this report will print for one customer at a time. You do not need to first select a Customer ID in the Customer Payment History module in order to use this report. The system will prompt an A/R Invoice and Payment Report screen as follows:
Select a Customer ID (1) using the Look Up button. Use the Beginning and Ending Date (2) fields to set a date range for the data. Click the Print button to print to paper, or click the Excel icon to export the data. A sample of the report appears below.
Once a list of items appears in the Customer Payment History screen, you have a few additional options. After the initial search, the items will sort in order of the Item Reference option you selected as follows:
If there are multiple items on the screen, you can click on any of the column heading buttons to change the listing order. You can also right click on a highlighted line (1) to prompt the following: Invoice Reprint. This is the same feature that appears in the Invoice/Credit Memo module and will allow reprinting of Invoices from this screen. And finally, you can click on the Excel (2) icon to export all the data on the screen to Excel. This data will display the Customer Name along with the Customer ID, and the Salesperson 1 & 2. Additional Excel data export items include Payment Type Code and whether payment/deposit was posted in Deposits or via Post Customer Payments.