Aged A/P Report |
  
|
This report recreated the vendor account status as of a selected cut-off date. It reconstructs the account using payment history and accurately identifies the exact bills that were paid. It lists each vendor with the amounts owing, printed in the five aging categories (current/ 31-60 days/ 61-90 days, 91-120 days/ and over 120 days.)
The screen prompts are:
ALL REGIONS - When this box is checked, the description “ALL REGIONS” will display. You will not be able to select an individual region when this is checked. (If your user id is NOT set up with multi-region access, this field will be disabled).
REGION CODE - From the drop-down list, select the region for which you wish to run the report. (If your user id is NOT set up with multi-region access, this field will be disabled).
ALL LOCATIONS - When this box is checked, “ALL LOCATIONS” will display. (You will not be able to select an individual location when this is checked. If your user id has been set up to NOT prompt for location, this field will be disabled).
LOCATION - From the drop-down list, select the location for which you wish to run the report. (If your user id has been set up to NOT prompt for location, this field will be disabled).
CUT-OFF DATE - This date determines the ending point for selecting bills. The cut-off date applies to the bill date. Press enter to set the cut-off date to today's date.
AGE AS OF MONTH END - When this check box is checked, bills are aged according to month end. When unchecked, bills are aged according to individual bill dates.
FROM VENDOR - From the drop-down list, select an starting and ending vendor for the record selection. Leave these fields blank to search to the end of the vendor file.
REPORT OPTIONS - From the available options, indicate if you would like the report printed or exported directly to Microsoft Excel.
REPORTTYPE - From the available options, indicate if you would like the report printed in summary or detail format. When exporting to Microsoft Excel, this field will be disabled.
Click CONTINUE to run the report using the selected criteria.
Click EXIT to close the window.