Intercompany Unbilled Detail (Inquiry)

Additional Information

The Intercompany Billing Detail Inquiry allows you to identify, review, and report on intercompany unbilled transactions. This inquiry will query intercompany unbilled, intercompany project detail, and intercompany revenue detail information and provide the functionality to group by, sort, filter, and export the results.

Restrictions

The inquiry includes the following default restrictions:

Restriction Description
  From Posting Date Enter or select a posting date. This is the first date in the date range to include all items.
  To Posting Date

Enter or select a posting date. This is the last date in the date range to include open items. This field defaults to the last posting date of the prior posting period.

Currency Types

Select a currency type. Available selections include Bill Currency IC, Project Currency, Company Currency, and Base Currency.

  Working Company Enter or select an active, working company.
  Currency Enter or select an active currency.
  From Transaction Date

Enter or select a transaction date. It is the first date in the date range to include items.

This is an additional date used to further refine results returned from the Posting Date range.
  To Transaction Date

Enter or select a transaction date. It is the last date in the date range to include items.

This is an additional date used to further refine results returned from the Posting Date range.

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

The following optional restrictions are available:

  • Budget Category
  • Create Bill
  • Owning Company
  • Project
  • Revenue Basis

Results

The inquiry contains a single level of intercompany billing information, which includes Working Company Name, Owning Company Name, Working Organization Name, Document Date, Document Number, Revenue, and Revenue Adjustment. The initial view is grouped in ascending order by Working Company, Owning Company, Project, Task, and Budget Category. ClosedIntercompany Unbilled Optional Columns.

The following optional columns of information are available:

  • Bill Currency Code
  • Bill Currency Name
  • Budget Category Code
  • Budget Category Name
  • Cost
  • Cost Basis
  • Currency Code
  • Currency Name
  • Currency Type
  • Discount Term Code
  • Discount Term Name
  • Document Type
  • Effective Cost Rate
  • Effort Basis
  • Effort Rate Bill Currency
  • EVC Code
  • EVC Name
  • EVC Type
  • Fee Type Code
  • Fee Type Name
  • Labor / Expense
  • Overtime
  • Owning Company Code
  • Posting Date
  • Posting Period
  • Project Client Code
  • Project Client Name
  • Project Code
  • Project Name
  • Quantity
  • Regular Cost Rate
  • Revenue Basis
  • Task Code
  • Task Hierarchy Code
  • Task Name
  • Transaction Date
  • Unit Code
  • Unit Name
  • Working Company Code
  • Working Organization Code