Invoices Selected for Payment
Access this report using Reports>Accounts Payable>Invoices Selected for Payment. |
Use this report to print a list of on account credits and invoices that have been selected for payment (Activities>Accounts Payable>Select A/P Invoices to Pay). You can print the discount date and amount available for each invoice. Then, you can review the selections for accuracy before printing checks. The report assists you in deciding whether you selected the appropriate invoices and on account credits for payment to the vendors. Additionally, it helps to determine the amount of cash necessary to cover the invoices to be paid. After you print a check for an invoice, that invoice does not appear on this report.

Account Level Security is available for this report. This feature allows the Administrator to define the account codes and related amounts a user can view in the report. When account level security is activated by the Administrator for the organization (Security>Set Up Account Level Segments) and enabled for a user or group (Security>Set Up Account Level Security), the report will only print account information the user is allowed to see. Note that if a user does not have Account Level Security enabled, the user will see all account codes.
If the "Print Disclaimer on Report" check box is selected on the Security>Set Up Account Level Segments form, "This report may be affected by Account Level Security" prints in the header of this report. In that case, an * also prints after the report title.

Additional columns and filters are available to help track electronic payments.

The Invoice Currency, Invoice Currency Description, and Functional columns are only available if the Administrator has installed and added this module (Organization>Add a Module).
Use this tab to assign a report name and determine whether or not to include it on the actual report. The report name can be printed in the header or the footer of the report.
Use this tab to determine what data to include in the report and to define the report layout.
- By selecting Available Items, the data is divided onto separate pages. The report starts a new page for each item, and the item is printed in the page header of the report.
- By selecting Available Columns, the data that appears in the body of the report is determined.
Column | Description |
---|---|
Class |
The class assigned to the vendor, such as Offsup, Rent, or Util. A class is used to limit or sort a range of Vendor IDs. You can assign it to different IDs so that they can be grouped together. |
Type |
The type assigned to the vendor, such as furniture or computers. A type is used as a second-level sort for Class. You can use it to limit or sort a range of Vendor IDs. |
Vendor ID |
The vendor entered on the Enter A/P Invoices form. The report shows the Vendor ID—ABC, SWB, TRANS, for example. |
Vendor Name |
The vendor associated with this document. This vendor was set up using the Maintain>Accounts Payable>Vendors form. |
Status | The status of the vendor ID—Active, Inactive, or Discontinued. |
Hold Payments |
A designation of Yes or No. Yes indicates the vendor has a hold payments status—you do not want the system to produce checks for this vendor. No indicates the vendor does not have a hold payments status. |
Check Address Code |
The vendor’s check address code, such as Main or Austin Office. |
Check Address |
The street or post office address of the vendor. This vendor was set up using the Maintain>Accounts Payable>Vendors form. |
Check City |
The city of the vendor. |
Check State/Province |
The state or province of the vendor. |
Check Postal Code |
The postal code for the vendor's city and state. |
Check Country |
The country associated with the Check Address. |
Invoice/Credit Entry Order |
The date and time an invoice or credit was processed. It is automatically assigned by the system. |
Invoice/Credit Number |
The number assigned to the original invoice or credit. The report can be sorted by invoice number, so that all entries made to an invoice are together. |
Invoice/Credit Currency |
The currency type, such as USD, MXN, or CAD, assigned to Accounts Payable transaction lines. Currencies were created and activated using the Organization>Currency Setup form. |
Invoice/Credit Currency Description |
The description associated with the invoice or credit currency, such as US Dollar, Mexican Peso, or Canadian Dollar. |
Invoice/Credit Date |
The date of the invoice or credit (number). |
Due Date |
The due date entered on the Enter A/P Invoices form. |
Invoice/Credit Description |
The description entered on the Enter A/P Invoices form, the Enter A/P Credits form, or the Enter Manual A/P Checks form. |
Credit Type |
The On Account credit type displays. On Account credits were recorded on the Enter A/P Credits form. |
Payment Type |
The payment type associated with the document—either Check or Voucher. |
{Segment Name} Code |
The actual account code associated with a transaction. The report prints the account code, such as 201, 05, 45001. One column displays for each code type, such as Fund Code or GL Code. |
{Segment Name} Title |
The title associated with each code above. The report prints one column for each code type, such as Fund Title or GL Title. |
{Segment Name} Short Title |
The short title for the title above (15 characters or less). The report prints one column for each code type, such as Fund Short. |
1099 Type-Box |
The form type-box number designated for the 1099 on this invoice, such as NEC-01, MISC-15, DIV-01a, INT-01, R-09b, or W2G-01. The box number for this vendor was set up using the Maintain>Accounts Payable>Vendors form. Note: In the MIP 2020.3 release, any MISC-07 coded activities with an effective date of 1/1/2020 or later have been automatically updated to NEC-01. |
Discount Date |
The discount date for the Vendor on this invoice. The box number for this vendor was set up using the Maintain>Accounts Payable>Vendors form. |
Discount Amount |
The discount amount for the Vendor on this invoice. The box number for this vendor was set up using the Maintain>Accounts Payable>Vendors form. |
Invoice/Credit Amount |
The amount entered during transaction entry. |
Functional Amount |
This is the functional amount. |
Cash Required |
The net of the invoice amount and the discount amount. |
Pending Check/Credit |
The check or credit number for the invoice that were previously selected for payment and printed but have not been posted. |
Pending Check/Credit Session |
The session information created for the invoice, including partial payments, that was previously selected for payment and printed but have not been posted. The session information was created using Activities>Accounts Payable>Pay Selected A/P Invoices. |
Pending Check/Credit Session Date | The session date for the invoice, including partial payments, that was previously selected for payment and printed but have not been posted. The session information was created using Activities>Accounts Payable>Pay Selected A/P Invoices. |
Pending Check/Credit Session Description | The session description of the invoice, including partial payments, that was previously selected for payment and printed but have not been posted. The session information was created using Activities>Accounts Payable>Pay Selected A/P Invoices. |
Pending Check/Credit Session Status | The session status of the invoice, including partial payments, that was previously selected for payment and printed but have not been posted, such as BP (Batch-To-Post), BS (Batch-To-Suspend), or OL (Online Posting). The session information was created using Activities>Accounts Payable>Pay Selected A/P Invoices. |
{User Defined Field} - Vendors |
A vendor type user defined field and its data. There will be a separate column for each field. |
Use this tab to narrow down and more explicitly define the data to include in the report by selecting from the Available Filters.
Use this tab to set up any Available Options for the report.
Options | Description |
---|---|
Summarize Amounts |
Select this option to add amounts together and display one line item with the total amount. All document information must be identical for the system to add items together. |
Use this tab to change the font and page setup for a report.
Use this tab to secure the active report so that other users cannot save their changes to it. The user that selects the check box, and then saves the report, is the only user that can change or save it later. This check box cannot be cleared by any user other than the user that locked the report.