Payable Aging by Project (Inquiry)

The Payable Aging by Project Inquiry displays outstanding aged payable information by Project and Payee in a format for easy excel export and analysis of data.

The Payable Aging by Project Inquiry allows users the ability to see which vendors have been paid, how those payments apply to their projects, and the outstanding balances remaining.

This inquiry provides the ability to include attachments on the document based on your user authorizations.

The three result levels of payable summary information include information for the project, the payees, and voucher summary level. The number of rows returned are displayed in parentheses next to the inquiry name.

Restrictions

The inquiry includes the following default restrictions.

Restriction		Description
	From Posting Period	Enter or select a posting period. This is the first date in the date range to include all items. If you do not enter a date, only open items are returned. Open includes items posted after the To Posting Period or where the Zero Balance is empty. In addition, you can use the optional Include Payee Balance of Zero restriction to include employee / vendor / clients with a balance amount of zero.
	To Posting Period	Enter or select a posting period. This is the last date in the date range to include open items. This field defaults to the current fiscal period.
	Aging Date As Of	Enter or select the reference aging date to use on the inquiry. This field defaults to the current date.
	Currency Type	Select the type of currency to display on the inquiry. This field defaults to Document Currency, but available options include Base Currency, Company Currency, and Document Currency.

For a list of the optional restrictions, see Payable Aging by Project Inquiry Optional Restrictions.

Results

The inquiry results include the following three levels of Payable Summary information:

• Project: The first level of the inquiry provides summary view aggregated by project and currency, displaying total vouchered amount and associated outstanding balances (total, by aging, unallocated) Project / Currency Optional Columns.

  The following optional columns of information are available:

  Balance Currency Code Payment Amount Payment Administrator Code Payment Administrator Name Project Code Project Director Code Project Director Name

  Project Manager Code Project Manager Name Project Name Project Status Unallocated Voucher Amount

• Payee Summary: For each project / currency combination, the second level aggregates by payee, displaying total vouchered amount and associated outstanding balances (total, by aging, unallocated) Payee Summary Optional Columns.

  The following optional columns of information are available:

  Balance Country Code Country Name Currency Code Payee Code Payee Name Payee Status Payee Type

  Payment Amount State / Province Code State / Province Name Vendor Parent Code Vendor Parent Name Vendor Type Code Vendor Type Name Voucher Amount

• Voucher Summary: For each Payee, the third level displays corresponding voucher summary information, along with the associated outstanding balances (total, by aging, unallocated)Voucher Summary Optional Columns.

  The following optional columns of information are available:

  Balance Discount Date Document Date Document Number Document Source Document Type Due Date Financial Description

  Invoice Date Invoice Number On Hold Pay When Paid Payment Amount Transaction Type Unallocated Multiple Projects