Receivable Detail (Inquiry)

Additional Information

The Receivable Detail Inquiry allows you to query for and view project receivable detail information. The inquiry directly provides only this single, lowest level of information so that detail data can be easily exported to spreadsheets for further analysis. A variety of restrictions allow a very easy selection of specific needed receivable data.

The View Final Bill Transactions Inquiry option is a related item that allows you to send Final Bills associated with a selected row. You can use the email service by highlighting a Receivable Detail line and right clicking to display the Related Items. If multiple rows are selected, each document opens in a separate tab. See Email Configuration for more information about the email service.

The Receivable Detail Inquiry also has a right click context menu that allows you to send the Final Bill or Bill Packet associated with the selected row.

Restrictions

The inquiry includes the following default restrictions:

Req'd 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 posting 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 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, Document Currency, and Project Currency.

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

The following optional restrictions are available:

  • Account
  • Aging Category (1 - 4)
    (default is 30 / 60 / 90 / 120 days)
  • Bill Amount (from Receivable Summary)
  • Bill Balance (from Receivable Summary)
  • Bill Client
  • Bill Client EVC Type
  • Bill Cycle
  • Bill Number (from Receivable Summary)
  • Bill Term
  • Bill Term Client
  • Bill Term Client City
  • Bill Term Client Country
  • Bill Term Client Parent
  • Bill Term Client State / Province
  • Biller
  • Company
  • Deposit Amount (from Receivable Summary)
  • Detail Document Number
  • Document Detail Amount
  • Document Type
  • Organization
  • Organization Manager
  • Organization Map
  • Organization Map Level
  • Project
  • Project Administrator
  • Project Business Unit
  • Project Client
  • Project Client Parent
  • Project Client Type
  • Project Company
  • Project Contract
  • Project Currency
  • Project Director
  • Project Manager
  • Project Market Segment
  • Project Organization
  • Project Service Line
  • Project Status
  • Project Work Type
  • Subsidiary Type
  • Transaction Type

Results

The inquiry results include the following detail level of information, which includes Project Name, Project Client Name, Currency Code, Bill Number, Bill Date, Bill Amount, Bill Balance, Document Type, Document Number, Document Date, Document Amount, data by aging categories, and Unallocated. ClosedReceivable Detail Information Optional Columns.

The following optional columns of information are available:

  • Account Code
  • Account Name
  • Bill Client Code
  • Bill Client Name
  • Bill Cycle Code
  • Bill Cycle Name
  • Bill Term Client Code
  • Bill Term Client Name
  • Bill Term Code
  • Bill Term Name
  • Biller Code
  • Biller Name
  • Company Code
  • Company Name
  • Deposit Amount
  • Document Days Old
  • Document Suffix Code
  • Document Suffix Name
  • EVC Type
  • External Reference Date
  • External Reference Number
  • Financial Description
  • Organization Code
  • Organization Map Levels (2-6) Names
  • Organization Name
  • Project Administrator Code
  • Project Administrator Name
  • Project Business Unit Code
  • Project Business Unit Name
  • Project Client Code
  • Project Code
  • Project Company Code
  • Project Company Name
  • Project Contract Code
  • Project Contract Name
  • Project Currency Code
  • Project Currency Name
  • Project Director Code
  • Project Director Name
  • Project Manager Code
  • Project Manager Name
  • Project Market Segment Code
  • Project Market Segment Name
  • Project Organization Code
  • Project Organization Name
  • Project Service Line Code
  • Project Service Line Name
  • Project Work Type Code
  • Project Work Type Name