Report Payables Aged Trial Balance  

Access

Use this routine to report payable balances as of a specified date. Once the run-time options have been selected, choose Run to produce the report.

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 Multi-Company Processing is not active, the system company defaults and you cannot edit this field.

Date 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.  

As Of DateIf you select CUS (custom) at Date Code field, you activate this field.  Use this field to specify the as-of date 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.

AP bills that were back-dated may not be included on the report if they were not active on or before the As Of Date that you specify.

Aging Type

Past Due OnlyCheck this box if you want to run report for past due invoices only.  To include current invoices, leave the field blank.  Note, this field is only active if you have selected Past Due as the Aging Type.  

Summary Only

VendorSpecify one or more vendors to which you want to restrict the output of this report. If you click on the Search button, the Vendor Name Search appears from which you can select a vendor.  If you click on the Action 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.

Vendor ClassEnter one or more vendor classes to which you want to restrict the output of this report. If you click on the Arrow, a list of vendor classes appears from which you can choose. If you click on the Action button, the Multiple Vendor Classes Selection Window appears. If you leave the field blank, you select all vendor classes. If you select a vendor at the Vendor field, you inactivate this field.

Aging DaysEnter the number of days to use for aging buckets.  The default is set based on the Bill Aging Days from the Payables Control Settings.

Buyer

CountryEnter one or more countries to which you want to restrict the output of this report. If you click on the Arrow, a list of countries appears from which you can choose. If you click on the Action button, the Multiple Country Selection Window appears. If you leave the field blank, you select all countries.

Sort by CountryIf you choose to run the report for more multiple or for all countries at the Country field, this field is active. To sort by payables country, check the box.  

 Sort by InvoiceTo sort the report by invoice number, check this box. Otherwise, leave the box blank. Regardless of your selection at this field, the report sorts first by vendor.

Debit Balances OnlyTo generate a report of vendors with debit balances only, check the box.  Otherwise, leave the field blank.  This field is active only if the As of Date is set to the current date.

Hold CodeEnter one or more hold codes to which you want to restrict the output of this report. If you click on the Arrow, a list of hold codes appears from which you can choose. If you click on the Action button, the Multiple Hold Code Selection Window appears. If you leave the field blank, you select all hold codes.

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.