Report Payables Activity

Access

This report has two basic modes:

• report open and closed payables activity since the last End-of-Day cycle, including AP bills created and/or adjusted since the last End-of-Day.

• report open and closed payables activity for a range of dates.  

If you select activity during a specific date range, the report shows ALL activity (bills whether open or closed). If you check the box at the Payment field to include payments on the report, the Payment column indicates the amount paid on the bill, whether fully or partially paid.

The primary sort for the report is Company.  Each company starts on a new page.  If you choose to include a GL recap (via the Print GL Recap field), the recap prints after all companies have been printed. Once the run-time options have been selected, choose Run to produce the report.

 This report also runs as part of the End-of-Day process.   

Date of Activity

Since Last End of Day

CodeClick on the Arrow button to view a list of date codes, then select the code that best indicates the time period on which to base your report.  

StartIf you select CUS at the Date Code field, you activate this field.  Use this field to specify the start date of the custom date range for which you want to run this report. If you click on the Calendar Icon, you can select a date from the calendar that appears.

If you select another date code instead of CUS, this field fills in based on that selection and you cannot edit this field.

EndIf you select CUS at the Date Code field, you activate this field.  Use this field to specify the end date of the custom date range for which you want to run this report. If you click on the Calendar Icon, you can select a date from the calendar that appears.

If you select another date code instead of CUS, this field fills in based on that selection and you cannot edit this field.

Bill Activity

Type

EDI OnlyTo include only AP Bills generated via EDI (Electronic Data Interchange) An optional feature of the STORIS system used to electronically transmit purchase orders to vendors and receive acknowledgements and invoices from vendors., check the box.  Note that if you select a vendor, you inactivate this field.

Status to Include

Pending Bills

Hold CodeSelect one or more hold codes whose AP bills you want to include in the report. If you click on the Arrow, a list of available Hold codes appears from which you can choose. If you click on the Action button, the Multiple Hold Code Selection window appears, from which you can choose one or more hold codes. If you leave the field blank, you select all hold codes.

Additional Options

CompanyIf Multi-Company Processing is active, you can specify one or more companies for which to run the report. If you click on the Action button, a list of companies appears from which you can choose. If you leave the field blank, you select all companies.

If not using Multi-Company Processing, the default company appears and the field is inactive.

Report By

SubtotalTo include a subtotal for each vendor or remit-to, check the box. Otherwise, leave the box blank. If you check the box, the report sorts and breaks on vendor/remit-to.

VendorIf you select Vendor at the Report For field, you can restrict the report to one, several, or all vendors.  If you click on the Search button, the Vendor Name Search appears from which you can select a vendor.  If you click on the Actions button, the Multiple Vendor Selection Window appears from which you can select one or more vendors. If you leave the field blank, you select all vendors.

Remit ToIf you select Remit-To at the Report For field, you can restrict the report to one, several, or all vendor remit-to's. If you click on the Arrow, a list of remit-to's appears from which you can choose. If you click on the Action button, the Multiple Remit-To Selection window appears from which you can choose.

Payments

Print GL Detail

Print GL Recap

Send Report to

Send Output toThe output destination of the report displays.  To change the output destination, click on the Actions button and select Output Settings.

Export PathIf you select either the Personal Report Viewer (PRV (Personal Report Viewer) A STORIS printer output option that allows you to customize report results, for example to rearrange data columns.), Excel Export, or ASCII Export, this field displays the pre-set computer drive and folder location to which the system exports the report data. You cannot edit the export path using this process.