Customer Invoice Reconciliation

This form compares Invoices Charged to Account to Invoices paid. Paying by Invoice number is an option at the POS, it is not enforced, a payment can be made against the Account Statement only. The form shows a list of all charge Account Customers. Clicking on any customer will show a list of all Invoices that are aged as Current Over 15 Days Over 30 Days Over 60 Days Over 90 Days Depending on the options chosen at the top of the form. The list can then be sorted by Account, Name, Phone, Last Paid Date or Account Balance. The idea of the form is to select an aging range, then select a customer and print the report. The Report will show the total Invoices and Payments for any customer, providing an alternate view of the accounts than provided by the Statements module. There is an option to run the Report by 'All' in which case the report will show all customers based on the aging options chosen. If the Payments to Statement option is chosen, the report will show any payments made not to a specific invoice, but paid against the balance of the Account Statement. If the Payments to MisMatched # option is chosen, the report will show any payments made to an invoice, but where there is no match between the Invoice paid to an any existing Invoice Numbers. (Usually because of a data entry mistake at the POS Lane). Selecting a Customer then clicking on the 'Edit Customer' button, will jump into Customer Maintenance to edit or further review that customer's details.