Payment History
From this screen, the user is able to run a report that will give the payment history for all or a few vendors, for a specific or very large period of time. The report will display almost the same information as the one from the Vendor Maintenance under the Statement tab. However, unless the Statement tab from the Vendor Maintenance that can only display the specific information relate to one vendor at a time - the Payables Payment History can present the payment history for multiple vendor.
The report gives a few options to the user - the user will need to review them before the report is being print:
•Date Selection: The report can only be run for an interval of dates. In the from and to field, the user needs to specified the interval of dates that the report will be present. The report will then print the historic of all payments made in the system in respect with this interval of dates. If the from and to field are left blank - the system will default the date to today's date.
•Vendor: The report can either be print for:
- All Vendors;
- A few of them: If selected - the user will need to fill Selection 1 up to the number of Selection needed by entering the specific vendor number that he wants to have the payment information to show on the report. By pressing F1 with the cursor positioned in one of the Selection field, the system will open the Search window which will allow the user to look by other characteristics than the vendor number.
- Interval: If selected - the user will need to fill the From and To field with vendor number. In example, if 10 to 1000 are entered in the From and To field once the Vendor option is positioned to Interval - the system will print the payment history of all vendors that has as a vendor number something included between 10 and 1000.
By pressing F1 with the cursor positioned in one of the From or To field, the system will open the Search window which will allow the user to look by other characteristics than the vendor number.
•Sort: The report can either be sort by:
- Date: If selected - the report will display all payments in chronological order, based on their payment date.
- Vendor: If selected - the report will display all payments per vendor number.
- Cheque number: If selected - the report will display all payment per cheque number.
Once all report options has been reviewed and selected - the user can either click on ACCEPT or press F2. This will generate a report with the following information:
- The vendor number and name associate with the payment;
- The customer number and name if the payment was made to a customer;
- The payment date;
- The type : Manual Cheque, Automatic Cheque or Cancelled cheque;
- The discount/ rebates taken per invoice and cheque;
- The cheque number;
- The invoice number that was paid on a specific cheque number;
- The currency;
- The rate if the currency was different than the Company currency;
- The invoice amount.
- The total per Vendor - Cheque # or Date depending on how the report was Sort as per the Report option.