Receivable Aging (Inquiry)

Additional Information

The Receivable Aging Inquiry allows you to query for and view project receivable information, which includes all project bill, deposit activity, and outstanding balances by time period (aging). The inquiry provides four levels of information, which include a summary of receivable balance and aging by project, a bill summary, a bill / deposit detail information, 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.

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 highlightinga Bill Deposit 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 Aging 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. 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 Receivable Aging Inquiry Optional Restrictions.

The following optional restrictions are available:

Account
Aging Amount (1 - 5)
Aging Category (1 - 4)
(default is 30 / 60 / 90 / 120 days)
Balance
Bill Amount
Bill Client
Bill Cycle
Bill Number
Bill Term
Bill Term Client
Bill Term Client City
Bill Term Client Country
Bill Term Client Parent
Bill Term Client State / Province
Biller
Company
Currency
Deposit Amount
EVC Type
Include Project Balance of Zero
Organization
Organization Manager

Organization Map
Organization Map Level
Project
Project Administrator
Project Business Unit
Project Client
Project Client Parent
Project Client Parent Type
Project Client Type
Project Company
Project Contract
Project Director
Project Manager
Project Market Segment
Project Organization
Project Service Line
Project Status
Project Work Type
Subsidiary Type
Transaction Type
Unallocated Amount

Results

The inquiry results include the following four levels of information:

Receivable Aging Summary: The first level of the inquiry provides receivable aging information, which includes Project Code, Project Name, Currency Code, Balance, data by aging categories, and Unallocated. Receivable Aging Information Optional Columns.

The following optional columns of information are available:

Bill Amount
Deposit Amount
Organization Map Level 2 - 6 Name
Project Administrator Code
Project Administrator Name
Project Business Unit Code
Project Business Unit Name
Project Client Code
Project Client Name
Project Client Manager Code
Project Client Manager Name
Project Client Type Code
Project Client Type Name
Project Company Code
Project Company Name

Project Contract Code
Project Contract 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

Bill Summary: The second level of the inquiry provides bill summary information, which includes Bill Number, Bill Date, Balance, data by aging categories, and Unallocated. Bill Summary Information Optional Columns.

The following optional columns of information are available:

Account Code
Account Name
Bill Amount
Bill Client Code
Bill Client Name
Bill Term Client Code
Bill Term Client Contact Name
Bill Term Client Contact Phone Number
Bill Term Client Name
Bill Term Code
Bill Term Name

Biller Code
Biller Name
Company Code
Company Name
Deposit Amount
Due Date
EVC Type
Organization Code
Organization Name
Project Client Payment Term Code
Project Client Payment Term Name

Bill / Deposit Detail: The third level of the inquiry provides bill and deposit detail information, which includes Document Type, Document Number, Document Date, Bill Amount, and Deposit Amount. Bill and Deposit Information Optional Columns.

General Ledger Transactions: The fourth level of the inquiry provides general ledger transaction detail information, which includes Account Code, Account Name, Organization Name, Organization Code, Internal Reference Number, Debit, and Credit. General 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
External Reference Number

Financial Description
Input Document Suffix Code
Input Document Suffix Name
Input Document Type
Line Item Type
Posting Date
Project Code
Project Description
Project Name