Payable Aging (Inquiry)

Additional Information

The Payable Aging Inquiry allows you to view a summary of posted historical payables transactions or outstanding balances by time period (aging). The inquiry provides four levels of information, which include the payable aging summary, voucher summary, voucher and payment detail, and associated general ledger transactions.

 

Note: If you do not enter a date in the From Posting Period field, 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.

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.
  Payee Type Select to include instances that were paid to blank or to an Employee or Vendor. The default is blank so that all Payee Types are selected.
  Account Enter or select an account.
Currency Type Enter or select the type of currency to display on the inquiry. his field defaults to Document Currency, but available options include Base Currency, Company Currency, and Document Currency.

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

The following optional restrictions are available:

  • Aging 1 Amount
  • Aging 2 Amount
  • Aging 3 Amount
  • Aging 4 Amount
  • Aging 5 Amount
  • 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
  • Employee Location
  • Employee Status
  • External Reference Number
  • Include Payee Balance of Zero
  • On Hold
  • Organization
  • Organization Manager
  • Organization Map
  • Organization Map Level
  • Pay When Paid
  • Payee
  • Payment Amount
  • Payment Cycle
  • Project
  • State / Province
  • Transaction Type
  • Unallocated Amount
  • Vendor Parent
  • Vendor Type
  • Voucher Amount
  • Voucher Number

Results

The inquiry results include the following four levels of information:

  • Payable Aging Summary: The first level of the inquiry provides payable receiving information, which includes Payee Code, Payee Name, Currency Code, Balance, data by aging categories, and Unallocated. The initial view is grouped by Payee Code. Closed Payable Aging Summary Optional Columns.

    The following optional columns of information are available:

    • Country Code
    • Country Name
    • Organization Map Level 2-6 Name
    • Payee Type
    • Payment Amount
    • Payment Routing Code
    • Payment Routing Name
    • State / Province Code
    • State / Province Name
    • Vendor Parent Code
    • Vendor Parent Name
    • Vendor Type Code
    • Vendor Type Name
    • Voucher Amount

  • Voucher Summary: The second level of the inquiry provides Voucher Number, Voucher Date, Balance, data by aging categories and Unallocated. ClosedVoucher Summary Optional Columns.

    The following optional columns of information are available:

    • Company Code
    • Company Name
    • Discount Date
    • Due Date
    • External Reference Date
    • External Reference Number
    • Multiple Projects
    • On Hold
    • Pay When Paid
    • Payment Amount
    • Payment Cycle
    • Project Code
    • Project Company Code
    • Project Company Name
    • Project Name
    • Project Status
    • Voucher Amount

  • Voucher / Payment Detail: The third level of the inquiry provides voucher and payment detail information, which includes Document Type, Document Number, Document Date, Voucher Amount, and Payment Amount. ClosedVoucher / Payment Detail Optional Columns.

    The following optional columns of information are available:

    • Document Source
    • Document Suffix Code
    • Document Suffix Name
    • Financial Description
    • Posting Date

  • General Ledger Transactions: The fourth level of the inquiry provides general ledger transaction detail information, which includes Account Code, Account Name, Organization Code, Organization Name, External Reference Number, Debit, and Credit. ClosedGeneral Ledger Transactions Optional Columns.

    The following optional columns of information are available:

    • Company Code
    • Company Name
    • Document Date
    • Document Number
    • Employee / Vendor / Client Code
    • Employee / Vendor / Client EVC Type
    • Employee / Vendor / Client Name
    • External Reference Date
    • Financial Description
    • Input Document Suffix Code
    • Input Document Suffix Name
    • Input Document Type
    • Internal Reference Number
    • Line Item Type
    • Posting Date
    • Project Code
    • Project Description
    • Project Name
    • Task Code
    • Task Hierarchy Code
    • Task Name