Invoice Selected for Payment Report

To access this report, go to 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. 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.

 

Tip: If you're not familiar with the MIP Cloud Report Builder, see Report Builder for an introduction.

 

You can choose to use the report as-is by selecting Export or View, or make edits to the report by selecting Edit.

If you choose to make edits to the report, the Report Builder page will display. From this page, use the Setup tab to choose the columns you'd like to appear on the report. You can rename the columns under the Column Heading.

 

The following columns are available to include in the report:

 

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 AP 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>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>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 Date	The date of the invoice or credit (number).
Due Date	The due date entered on the AP Invoices form.
Invoice/Credit Description	The description entered on the AP Invoices form, the AP Credits form, or the Manual Checks form.
Credit Type	The On Account credit type displays. On Account credits were recorded on the AP 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 MISC-15, DIV-01a, INT-01, R-09b, or W2G-01. The box number for this vendor was set up using the Maintain>Vendors form.
Discount Date	The discount date for the Vendor on this invoice. The box number for this vendor was set up using the Maintain>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>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 Transactions>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 Transactions>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 Transactions>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 Transactions>Invoices.
{User Defined Field} - Vendors	A vendor type user defined field and its data. There will be a separate column for each field.

 

Use the Filter tab to narrow down and define the data using the available filters.

Use the Options tab to Summarize Amounts on the report, implement security features, and more.

• Select "Summarize Amounts" 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.

• Select "Do Not Allow Changes to this Report" to secure the report so that other users cannot save their changes to it. This option can only be undone by the user that locked the report.

• Select "Year End Adjustments" to include year end adjustments on the report. This entry type was designated during transaction entry.

• Select "Open Entries in Detail" to include opening balances (system or user opening entries) in detail.

• Select "Replace total debits and credits with Balance" to show the net amount for each segment where totals have been requested. Otherwise, the report displays the total debits and total credits for each segment.

• Select "Suppress Lines with All Zeros" so that documents with zero amounts do not print. This eliminates records having zero in all amount columns. If it is not selected, every line prints, even if it has a zero value.

Use the Layout tab to change the font and page setup for a report.