Use this screen to print a report that lists all the vouchers that are outstanding and waiting for payment. You can age the vouchers according to any date ranges you specify. However, because the headings of the columns are specified independently of the date ranges that determine the aging of the columns, be sure that the headings correspond to what the columns actually reflect. For example, the first column range of dates is set to zero and cannot be changed; however, the heading of the column, which defaults to "0," is editable. If you changed the heading to 0-30 days, it would not reflect what is actually going to show up in that column, because only vouchers that are not yet due will be printed in the first column. You can select the vouchers by "A/P Acct/Org," "Pay Vendor ID," or "Pay Vendor Name."
Run this report when you need to review the outstanding items. The report is useful for seeing the age of your outstanding vouchers and the status of all open items. As this is the only report that shows deferred vouchers, review it periodically to check for items that are set to Defer.
Use the fields in this group box to specify the field on which to base your sort, and whether a page break should be inserted when that field changes. You can specify the date to print on the report, the account and organization levels to include in the report, and the secondary sort.
Use the drop-down box to select the field upon which you would like to base your sort. The possible values are "A/P Acct/Org," "Pay Vendor ID" or "Pay Vendor Name." Only those records that match the specified field will be included in the report.
Use this drop-down box to select the range of values to be included. Valid options are "All," "One," "Range," "From Beginning," and "To End." The default for this field is "All."
Enter, or use Lookup to select, the starting value for the range you want to include. If you select "All" or "From Beginning" in the Range Option field, this field will be inactive.
Enter, or use Lookup to select, the ending value for the range you want to include. If you select "All," "One," or "To End" in the Range Option field, this field will be inactive.
Enter the date you would like to see printed at the top of the report. This date should coincide with the periods you include in this report. The system does not use this date to select vouchers to be included in this report. The selection is based on the Fiscal Year, Period, and Subperiod information specified in the Select Period group box.
Select this checkbox if you would like the report to break when the selection field changes. For example, if you run the report for all A/P Acct Descriptions, when the A/P Acct Description changes, the new A/P Acct Description will start printing at the top of a new page.
Use this drop-down box to select the range of organizations to be included. Valid options are "All," "One," "Range," "From Beginning," and "To End." The default for this field is "All."
Enter, or use Lookup to select, the starting organization for the range you want to include. If you select "All" or "From Beginning" in the Range Option field, this field will be inactive.
Enter, or use Lookup to select, the ending organization for the range you want to include. If you select "All," "One," or "To End" in the Range Option field, this field will be inactive.
Specify the top level of the account you want to see included on this report. If your account structure has three levels and you want to see vouchers for only the third level, enter "3" here. The report will then include only those vouchers charged to the third level of the account. If you wanted to see vouchers for all levels, enter "1." The report will then include vouchers that were charged to all three levels of the account.
Specify the top level of the organization you want to see included on this report. If your organization structure has five levels and you want to see vouchers for only the fifth level, enter "5." The report will then include only those vouchers charged to the fifth level of the organization. If you wanted to see vouchers for all levels, enter "1." The report will then include vouchers that were charged to all five levels of the organization.
Use the fields in this group box to select the range of periods of the vouchers to be included in the report.
Use this drop-down box to select the range of vendors to be included. Valid options are "All," "One," "Range," "From Beginning," and "To End." The default for this field is "From Beginning."
Enter, or use Lookup to select, the starting fiscal year of the vouchers you want included on the report.
Enter, or use Lookup to select, the ending fiscal year of the vouchers you want included on the report.
Enter, or use Lookup to select, the starting period of the vouchers you want included on the report.
Enter, or use Lookup to select, the ending period of the vouchers you want included on the report.
This field displays the starting subperiod of the vouchers that will be included on the report.
This field displays the ending subperiod of the vouchers that will be included on the report.
Select this checkbox to have each voucher listed on the report for each vendor.
Select this checkbox to include unrealized gains and losses on the report. This will allow you to track the open AP totals back to the accounts payable balance sheet account.
This checkbox is unselected by default. If this box is selected, an indented row will display on the report showing the unrealized gain/loss.
Select this checkbox to exclude pay-when-paid vouchers from the report.
This checkbox is unselected by default.
Use these radio buttons to specify a secondary sort for the report. The primary sort will be by the field you selected in the Primary Sort group box. For example, if you selected by "A/P Acct/Org," the report will first print in "A/P Acct/Org" order, then by whatever is specified in the Secondary Sort group box. The available radio buttons will be controlled by the selection in the first sort.
If you want the report to print using pay vendor ID as the secondary sort, select this radio button. The report will order the vouchers in voucher number order within each pay vendor. This option will be available only if the primary sort is A/P Acct/Org.
If you want the report to print using pay vendor name as the secondary sort, select this radio button. The report will order the vouchers in voucher number order within each pay vendor. This option will be available only if the primary sort is A/P Acct/Org.
Select this radio button to print the report in voucher number order within the field that the report is selected by. For example, if you selected "A/P Acct/Org" in the Primary Sort group box, the report will sort the vouchers into "A/P Acct/Org" order. Within the "A/P Acct/Org," the vouchers will be printed in voucher number order.
Use this drop-down box to select the range of transaction currencies that you want included in the report. Options are "All," "One," "Range," "From Beginning," and "To End." The default for this field is "All."
Enter, or use Lookup to select, the currency code as the beginning of the range you want to include in the report. If you select "All" or "From Beginning" in the Range Option field, this field will be inactive. Only those currencies saved in the Maintain Currencies screen in Costpoint Multicurrency will be available in Lookup.
Enter, or use Lookup to select, the currency code as the ending of the range you want to include in the report. If you select "All," "One," or "To End" in the Range Option field, this field will be inactive. Only those currencies saved in the Maintain Currencies screen in Costpoint Multicurrency will be available in Lookup.
Use the fields in this group box to specify how the report will age the vouchers that are outstanding. The column headings are independent of the voucher aging, so be sure that the headings of the columns correspond to what is actually reflected in the columns. The default values come from the A/P Settings screen.
Enter the description that you would like to print above the first aging column of the report. This column, regardless of what you name it, will contain those vouchers that are not yet due.
This field is set to zero and is not editable.
Enter the description that you would like to print above the second aging column of the report. This column will contain those vouchers that are from one day to whatever you specify in the Days To column, past due.
The system calculates the Days From column by adding one to the value in the previous column's Days To field. In the second column, the value in the Days From box will default to one. This field is not editable.
Enter the ending number of the range of days you would like included in column two.
Enter the description that you would like to print above the third aging column of the report. This column will contain those vouchers that fall within the range of days past due, that you specify in the Days From and To fields.
The system calculates the Days From column by adding one to the value in the previous column's Days To field. This field is not editable.
Enter the ending number of the range of days you would like included in column three.
Enter the description that you would like to print above the fourth aging column of the report. This column will contain those vouchers that fall within the range of days past due, that you specify in the Days From and To fields.
The system calculates the Days From column by adding one to the value in the previous column's Days To field. This field is not editable.
Enter the ending number of the range of days you would like included in column four.
Enter the description that you would like to print above the fifth aging column of the report. This column will contain those vouchers that fall within the range of days past due, that you specify in the Days From and To fields.
The system fills this field in with the value of "Over," which means that any voucher that is past due by the number of days in the Days To column will be included in this column.
This report accesses the following tables:
VHCR_HDR_HS (Voucher Header History)
VEND_CHK (Vendor Check)
VEND_CHK_VCHR (Vendor Check Voucher)
AP_UNREAL_G_L_HS (AP Unrealized Gain/Loss History)