Payable Aging Detail (Inquiry)

Additional Information

The Payable Aging Detail Inquiry displays aged payable detail information in a format for easy excel export and analysis of data. See Export Request for information on how to request an export.

The Payable Aging Detail Inquiry provides authorized users the ability to view attachments on documents. See attachments for more information.

Right click on a line item to display the related items icon and then select Open to open the Input Source Document (e.g., voucher, expense report, journal entry, payment, voucher void, expense report void). Each of these options can be opened for selected rows. If multiple rows are selected, each document opens in a separate tab.

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 Date	Enter or select a posting date. This is the last date in the date range to include items. This field defaults to the current posting period.
	Aging Date As Of	Displays today's date (default) and is the date to compare the Payable Summary Document Date to determine days old. A calendar picker is available and can be used to select another date.
	Currency Type	Enter or select the type of currency to display on the inquiry. Available options include Base Currency, Company Currency, and Document Currency.

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

The following optional restrictions are available:

Account
Aging Category 1 (default is 30 days)
Aging Category 2 (default is 60 days)
Aging Category 3 (default is 90 days)
Aging Category 4 (default is 120 days)
Aging Criteria
Balance
Company
Country
Currency
Detail Document Amount
Detail Document Number
Document Number
Employee Location
External Reference Number
Include Payee Balance of Zero

On Hold
Organization
Organization Manager
Organization Map
Organization Map Level
Pay When Paid
Payee
Payment Amount
Project
Payment Cycle
State / Province
Transaction Type
Unallocated Amount
Vendor Parent
Vendor Type
Voucher Amount

Results

Payable Aging Detail: The only level of detail the inquiry provides payable aging detail information, which includes Payee Code, Payee Name, Project Code, Project Name, Document Number, Document Date, Currency Code, Voucher Amount, Balance, Document Type, Detail Document Number, Detail Document Date, Detail Document Amount, Data by Aging categories, and Unallocated Amount. Payable Aging Detail Optional Columns.

The following optional columns of information are available:

Account Code
Account Name
Company Code
Company Name
Country Code
Country Name
Discount Date
Discount Suffix Code
Discount Suffix Name
Due Date
External Reference Date
External Reference Number
Financial Description
Multiple Projects
On Hold
Organization Code
Organization Map Level 2-6 Name
Organization Name
Pay When Paid

Payee Status
Payee Type
Payment Amount
Payment Routing Code
Payment Routing Name
Posting Date
Posting Period
Project Code
Project Name
Project Company Code
Project Company Name
Project Status
State / Province Code
State / Province Name
Vendor Parent Code
Vendor Parent Name
Vendor Type Code
Vendor Type Name