Contents of the Revenue Reconciliation Inquiry Screen

Use the fields and options to configure the Revenue Reconciliation Inquiry screen.

View Revenue Reconciliation

Field Description
Fiscal Year

Enter, or click to select, the fiscal year from which to view GL and project revenue amounts.

Period

Enter, or click to select, the period from which to view GL and project revenue amounts.

GL Filters

Use the fields in this group box to customize the result set for general ledger records.

Field Description
F/S Code

Enter, or click to select, the type of financial statement that includes the GL revenue amounts you want to view.

Account Level

Enter an account level from which you want to view revenue amounts.

Account

Enter, or click to select, the account from which you want to view revenue amounts.

GL and Project Filters

Field Description
Project Level

Enter a project level from which you want to view revenue amounts.

Organization Level

Enter an organization level from which you want to view revenue amounts.

Rate Type

Use this drop-down list to filter revenue amounts according to the rate type:

The options are:
  • Actual
  • Target
Project

Enter, or click to select, the project from which you want to view revenue amounts.

Organization

Enter, or click to select, the organization from which you want to view revenue amounts.

Additional Options

Use the options in this group box to set time metric filters to the result set.

Field Description
PTD

Select this option to include revenue amounts from a specified period to the current date.

YTD

Select this option to include revenue amounts from a specified fiscal year to the current date.

ITD

Select this option to include revenue amounts from the project inception to the current date.

GL Total

This field displays the general ledger revenue amount total. It is the sum of all values in the GL Period Amount column of the GL table window.

Project Ledger Total

This field displays the project ledger revenue amount total. It is the sum of all values in the PRJ Period Amount column of the Projects table window.

Variance

This field displays the difference between the GL Total and the Project Ledger Total.

GL Table Window

Field Description
GL Project

This field displays the ID of the project associated with the general ledger revenue amount.

GL Organization

This field displays the ID of the organization associated with the general ledger revenue amount.

GL Period Amount

This field displays the total general ledger revenue amount for the specified period.

Projects Table Window

Field Description
PRJ Project

This field displays the ID of the project associated with the project revenue amount.

GL Organization

This field displays the ID of the organization associated with the project revenue amount.

PRJ Period Amount

This field displays the total project revenue amount for the specified period.

Subtask

Subtask Description
GL Details Click this link to open the GL Details subtask.