PRINT OPEN ACCOUNTS PAYABLE REPORT
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 that 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 change the heading to 0-30 days, it does not reflect the actual contents of the column because only vouchers that are not yet due print in the first column.
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.
Screen Contents
This screen has the following elements:
-
Use the Identification block to enter a parameter ID and description.
-
Use the Selection Ranges block to specify the primary sort, as well as the organization, the transaction currency, and the period of the vouchers to appear on the report.
-
Use the Options block to specify the level of detail that you want on the report.
-
Use the Sort By block to specify the secondary sort of the report.
-
Use the Generate block to specify how the report ages outstanding vouchers.
Location
Identification
Use the fields in this block to create a new parameter ID or to retrieve
a previously saved parameter ID. A parameter ID represents a set of screen
selection parameters. After you have saved a parameter ID and its related
parameters, you can retrieve them using Query.
You can use the retrieved parameters to produce reports and run processes
more efficiently and with greater consistency. The saved parameters are
also useful and necessary when you want to run the process as part of
a batch job. Many users save a unique set of parameters for each different
way they run a report or process. When you select a previously saved parameter
ID or parameter description, the associated saved screen selection parameters
automatically display as selection defaults. The page setup and print
options are also included in the saved parameter ID if there are any.
You can change any of the associated selection defaults as necessary.
Parameter ID
Enter, or click 
to select, a parameter
ID of up to 15 alphanumeric characters. Choose characters for your parameter
ID that help identify the type of selections you made in the screen, such
as PERIOD or QUARTERLY.
When you save your record, all the selections made in the screen are
stored with the parameter ID. Later, you can retrieve the parameter using
Query.
You can use the parameter to run the process more efficiently because
you can select the parameter ID with its previously defined screen selections.
After the default selections display in the screen, you can override the
defaults.
Description
Enter, or click to select, a parameter
description of up to 30 alphanumeric characters.
(Primary Sort)
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.
Select
Use this drop-down list to select the field on which to base the sort. The possible values are:
-
AP Acct/Org
-
Pay Vendor ID
-
Pay Vendor Name
Only those records that match this field are included in the report.
Option
Use this drop-down list to select the range of values to be included. Valid options are:
-
All — Select this option to include all available values. The Start and End fields are disabled for this option. This is the default.
-
One — Select this option to include only one value and then enter that value in the Start field. The End field is disabled for this option.
-
Range — Select this option to include a contiguous range of values. Enter the beginning value for the range in the Start field and enter the ending value of the range in the End field.
-
From Beginning — Select this option to include a range of values that begins with the first of all the available values and ends with the value that you enter in the End field. The Start field is disabled for this option.
-
To End — Select this option to include a range of values that begins with the specific value that you enter in the Start field and ends with the last of all the available values. The End field is disabled for this option.
Start
Enter, or click 
to select, the starting value for the range that you want to include. If you select All or From Beginning in the Option field, this field is inactive.
End
Enter, or click to select, the ending value for the range that you want to include. If you select All, One, or To End in the Option field, this field is inactive.
Organization
Option
Use this drop-down list to select the range of organizations to be included. Valid options are:
-
All — Select this option to include all available organizations. The Start and End fields are disabled for this option. This is the default.
-
One — Select this option to include only one organization and then enter that organization in the Start field. The End field is disabled for this option.
-
Range — Select this option to include a contiguous range of organizations. Enter the beginning organization for the range in the Start field and enter the ending organization of the range in the End field.
-
From Beginning — Select this option to include a range of organizations that begins with the first of all the available organizations and ends with the organization that you enter in the End field. The Start field is disabled for this option.
-
To End — Select this option to include a range of organizations that begins with the specific organization that you enter in the Start field and ends with the last of all the available organizations. The End field is disabled for this option.
Start
Enter, or click to select, the starting organization for the range that you want to include. If you select All or From Beginning in the Option field, this field is inactive.
End
Enter, or click to select, the ending organization for the range that you want to include. If you select All, One, or To End in the Option field, this field is inactive.
Transaction Currency
Option
Use this drop-down list to select the range of transaction currencies to be included. Only those currencies established via the Manage Currencies screen are available from the lookups in these fields. Valid options are:
-
All — Select this option to include all available transaction currencies. The Start and End fields are disabled for this option. This is the default.
-
One — Select this option to include only one transaction currency and then enter that transaction currency in the Start field. The End field is disabled for this option.
-
Range — Select this option to include a contiguous range of transaction currencies. Enter the beginning transaction currency for the range in the Start field and enter the ending transaction currency of the range in the End field.
-
From Beginning — Select this option to include a range of transaction currencies that begins with the first of all the available transaction currencies and ends with the transaction currency that you enter in the End field. The Start field is disabled for this option.
-
To End — Select this option to include a range of transaction currencies that begins with the specific transaction currency that you enter in the Start field and ends with the last of all the available transaction currencies. The End field is disabled for this option.
Start
Enter, or click to select, the starting currency code for the range that you want to include. If you select All or From Beginning in the Option field, this field is inactive.
End
Enter, or click to select, the ending currency code for the range that you want to include. If you select All, One, or To End in the Option field, this field is inactive.
Period
Use the fields in this group box to select the range of periods of the vouchers to be included in the report.
Option
Use this drop-down list to select the range of periods to be included. Valid options are:
-
All — Select this option to include all available periods. The Start and End fields are disabled for this option. This is the default.
-
One — Select this option to include only one period and then enter that period in the Start field. The End field is disabled for this option.
-
Range — Select this option to include a contiguous range of periods. Enter the beginning period for the range in the Start field and enter the ending period of the range in the End field.
-
From Beginning — Select this option to include a range of periods that begins with the first of all the available periods and ends with the period that you enter in the End field. The Start field is disabled for this option.
-
To End — Select this option to include a range of periods that begins with the specific period that you enter in the Start field and ends with the last of all the available periods. The End field is disabled for this option.
Start Fiscal Year
Enter, or click to select, the starting fiscal year of the vouchers to be included on the report.
Start Period
Enter, or click to select, the starting period of the vouchers to be included on the report.
Start Subpd
Enter, or click to select, the starting subperiod of the vouchers to be included on the report.
End Fiscal Year
Enter, or click to select, the ending fiscal year of the vouchers to be included on the report.
End Period
Enter, or click to select, the ending period of the vouchers to be included on the report.
End Subpd
Enter, or click to select, the ending subperiod of the vouchers to be included on the report.
Options
Show Detail
Select this check box to have each voucher listed on the report for each vendor.
Include Unrealized Gain/Loss
Select this check box to include unrealized gains and losses on the report, so that you can track the open Accounts Payable totals back to the accounts payable balance sheet account. This check box is cleared by default. If this box is selected, an indented row displays on the report to show the unrealized gain or loss.
Exclude Pay When Paid
Select this check box to exclude Pay-When-Paid (PWP) vouchers from the report. This check box is cleared by default.
As of Date
Enter the date to print at the top of the report. This date should coincide with the periods you include in this report. Costpoint 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 Period group box.
Include
Account Level and Below
Specify the top level of the account structure that you want included on this report. For example, if your account structure has three levels and you want to see vouchers for only the third level, enter 3. The report then includes only those vouchers charged to the third level of the account or below.
To see vouchers for all levels, enter 1. The report includes vouchers that were charged to all three levels of the account.
Organization Level and Below
Specify the top level of the organization structure that you want to see included on this report. For example, if your organization structure has five levels and you want to see vouchers for only the fifth level, enter 5. The report includes only those vouchers charged to the fifth level of the organization or below.
To see vouchers for all levels, enter 1. The report includes vouchers that were charged to all five levels of the organization.
Sort By
Use this block to specify a secondary sort for the report. For example, if you selected by account/organization combination in the Selection Ranges block, the report first prints in account/organization order, then by the selection specified in the 2nd Sort drop-down list.
1st Sort
This non-editable field displays the first sort, which is by the field you selected from the drop-down list in the Selection Ranges block.
2nd Sort
Use this drop-down list to specify a secondary sort for the report. The valid selections are:
-
Pay Vendor — Select this setting to print the report using pay vendor ID as the secondary sort. Vouchers display in voucher number order within each pay vendor.
-
Pay Vendor Name — Select this setting to print the report using pay vendor name as the secondary sort. Vouchers display in voucher number order within each pay vendor.
-
Voucher — Select this setting to print the report in voucher number order within the first sort selection. If you select this setting, Costpoint automatically selects the Show Detail check box. For example, if you select A/P Acct/Org in the Selection Ranges block, the report sorts the vouchers in A/P account/organization order; then, within the A/P account/organization, the vouchers print in voucher number order.
Page Break
Select this check box if you want the report to break by the 1st Sort. For example, if you run the report for all pay vendors, a new page prints for each pay vendor.
Generate
Use the fields in this block to specify how the report ages the outstanding vouchers. 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 Configure Accounts Payable Settings screen.
Column Heading - 1
Enter the description to print above the first aging column of the report. This column, regardless of what you name it, contains the vouchers that are not yet due.
Days - From
This non-editable field is set to zero.
Column Heading - 2
Enter the description to print above the second aging column of the report. This column contains those vouchers that are from one day to whatever you specify in the Days To field, past due.
Days - From
Costpoint calculates the Days From field by adding one to the value in the previous column's Days To field. In the second column, the value in the Days From defaults to one. This field is not editable.
Days - To
Enter the ending number of the range of days that you want included in column two.
Column Heading - 3
Enter the description to print above the third aging column of the report. This column contains those vouchers that fall within the range of days past due, that you specify in the Days From and To fields.
Days - From
Costpoint calculates the Days From column by adding one to the value in the previous column's Days To field. This field is not editable.
Days - To
Enter the ending number of the range of days that you want included in column three.
Column Heading - 4
Enter the description to print above the fourth aging column of the report. This column contains those vouchers that fall within the range of days past due, that you specify in the Days From and To fields.
Days - From
Costpoint calculates the Days From column by adding one to the value in the previous column's Days To field. This field is not editable.
Days - To
Enter the ending number of the range of days that you want included in column four.
Column Heading - 5
Enter the description to print above the fifth aging column of the report. This column contains those vouchers that fall within the range of days past due, that you specify in the Days From and To fields.
Over
Costpoint 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 is included in this column.