AP: Invoice List

Make the following menu selections to display this tab:

eFinancials—Reports—AP Reports—Invoice List or
ePO
—Reports—Invoice List

Use this tab to print a report that provides details on accounts payable invoices created from purchase orders.

ClosedFields

Select PropertiesCompanies

Click to select PropertiesCompanies from the Select PropertiesCompanies tab. The report runs for all selected PropertiesCompanies.

From Accounting Date / Thru Accounting Date

Enter a starting and ending accounting date. Or use the Calendar Button to select a date.

From Expense Code  / Thru Expense Code

Click the Lookup icon to display the Select Expense Code Tab and select a starting and an ending expense codes. Expense codes appearing on this list are established on the Expense Codes Tab in AP Setup.

From Vendor ID / Thru Vendor ID

Click the Lookup icon to display the Select Vendor Tab and select a starting and an ending vendor ID. Entries appearing on this list are established on the Vendors Tab in AP Setup.

Status

Select an invoice status from the drop-down list. The following statuses are possible: All Statuses (default), Hold, Normal, Paid, Partially Paid, Void.

Sort by

Select a sort mechanism from the drop-down list. The following sorts are possible: Account # (default), Due Date, Invoice Date, Invoice #, Vendor ID.

Print by PropertiesCompanies

Select this option if you want the system to sort and print the report by PropertiesCompanies. When you select this option, the report still sorts by your selection in the Sort by field; however, the system then sorts the report by PropertiesCompanies.

Print Full Invoices

Select this option if you want to print additional pages with more detail. Refer to the report description for more information on the additional pages that print.

Standard Report/Alternate Report

Select to print either a Standard Report or an Alternate Report. These options appear when you select to print a report that is sorted by Expense Code and printed by PropertiesCompanies.

PDF Format

Select this option if you want the report to print in PDF format. For more information, refer to Report Printing Options.

Create Spreadsheet

Select this option if you want the report to print in an Excel spreadsheet. For more information, refer to Report Printing Options.

Cancel

Click to exit without saving changes.

Print

Click to print the report.

ClosedReport Description

This report provides information on invoices that have been created using purchase orders. The report runs for selected PropertiesCompanies. You can limit this report to a range of account dates, expense codes, or vendors. You can also limit this report by invoice status. For printing, the report includes several sort options. The report prints in one of the two standard formats: PDF or Spreadsheet.

When the report displays, it includes information on the invoice date and due date, the invoice number, vendor ID and name, the invoice amount and status, and the voucher ID. A total amount line appears at the end of the report.

If you select the option Print Full Invoices, additional pages with more detail print. The header of these pages includes the vendor's name and address, the PropertiesCompanies name and address, the invoice number, date, due date, and invoice status, and the ID of the user who entered the invoice. In addition, the report lists one line for each invoice detail line that includes the PropertyCompany ID, purchase order number/contract number, expense code, vendor name, account description, and detail date and line item amount. An invoice total amount line appears at the end of the list of detail lines along with a signature and date line.

Note

If you select to print a report that is sorted by Expense Code and printed by PropertyCompany, the report can be printed as a Standard Report or an Alternate Report.

ClosedTo Print the Report

  1. From the eFinancials menu, select Reports—AP Reports—Invoice List. Or, from the ePO menu, select Reports—Invoice List.
  2. Click Select PropertiesCompanies. Select the PropertiesCompanies for which you want to print the report and click Save.
  3. From the From Accounting Date and Thru Accounting Date fields, type an accounting date range for the report. Or use the Calendar icon to select a date.
  4. From the From Expense Code and Thru Expense Code fields, click the Lookup icon to display the Select Expense Code Tab and select an expense codes range for the report.
  5. From the From Vendor ID and Thru Vendor ID fields, click the Lookup icon to display the Select Vendor Tab and select a Vendor ID range.
  6. From the Status drop-down list, select an invoice status: All Statuses (default), Hold, Normal, Paid, or Void.
  7. From the Sort by drop-down list, select a sort order: Account # (default), Due Date, Invoice Date, Invoice #, or Vendor ID.
  8. To sort and print the report by PropertyCompany, check the Print by PropertyCompany check box. Otherwise, leave the check box unchecked.
  9. To print additional pages for the report with more detail, select the Print Full Invoices check box. Otherwise, leave the check box cleared.
  10. If you selected to print a report that is sorted by Expense Code and printed by PropertyCompany, select an option: Standard Report or Alternate Report.
  11. Select one of the following report printing options:
  12. Click Print. If you selected Create Spreadsheet, you are prompted to open or save the report Excel file. Otherwise, the report opens in PDF format.

See Also

Reports Introduction

ePO Introduction

Alternate Report Format