to select one. To inquire on a range of projects, use Subquery
to select them. If you select a single project, its description displays
next to the project ID.Use this screen to review project costs and revenue without printing a report. The amount of information is limited compared to the project reports because of space and speed considerations. If you want additional data on a project, use the reports to print out this information. The initial screens contain summary information that was created by the Create Project Report Tables screen (Projects » Inquiry and Reporting » Report Processing) for the revenue summary data. In the main screen, use Subquery to select a specific project or organization with which you want to work. You can view your inquiry using either the Home organization (Owning Org) or the contributing organization (Performing Org).You can conduct either of these inquiries using either target or actual rates. You can perform inquiries on specific project, organization, and account levels without including the lower levels. You can use the Project Inquiry by Level screen for inquiries in which you can specify the project, organization, and account levels which will include all information at and below that level. The inquiry screens are non-editable.
You must have posted the journals and performed the Compute Burden Cost screen (Projects » Cost and Revenue Processing » Project Cost Processing), Compute Revenue screen (Projects » Cost and Revenue Processing » Revenue Processing), Update Project Status Report Table screen (Projects » Inquiry and Reporting » Report Processing), and Create Project Report Tables screen for the fiscal year, period, and subperiod for which you want to inquire. These are the same steps you take to print reports for the same time period. The only available fiscal year information is that which currently exists in the report tables. If you want to produce an inquiry for a period other than those currently available, follow these steps to create the report table. Keep in mind that some of the steps might have already been run, such as Compute Burden Cost and Compute Revenue screens. If you have already run the Compute Burden Cost and Compute Revenue screens, there is no need to rerun them. Normally, for previous periods, you will need to create only the report tables in order to inquire against them. The amount of time you keep report tables determines how many subperiods worth of information are available simultaneously. Normally, you will want to run the processes for the latest subperiod to have the most up-to-date information.
To narrow the rows shown in the table window to a specific fiscal year, use this drop-down list to select that fiscal year before executing the inquiry. Keep in mind that the only fiscal years shown are those that have activity in the report tables. If you do not select a fiscal year, all fiscal years with rows in the report table will be shown. Normally only one fiscal year will be available at a time unless the report tables have been created for a previous fiscal year. If your data is purged on a weekly basis, you do not need to select a fiscal year because only one will still exist in the report table.
To narrow the rows shown in the table window to a specific period, use this drop-down list to select that period before executing the inquiry. Keep in mind that the only periods shown are those that have activity in the report tables. If you do not select a period, all periods that have rows in the report table will be shown. If your data is purged on a weekly basis, you do not need to select any period because only one will still exist in the report table.
To narrow the rows shown in the table window to a specific subperiod, use this drop-down list to select that subperiod before executing the inquiry. Keep in mind that the only subperiods shown are those with activity in the report tables. If you do not select a subperiod, all subperiods with rows in the report table will be shown. If your data is purged on a weekly basis, you do not need to select a subperiod because only one will still exist in the report table.
To inquire on a specific project, enter a project or use to select one. To inquire on a range of projects, use Subquery
to select them. If you select a single project, its description displays
next to the project ID.
To inquire on a specific organization, enter the organization ID, or
use to select one. To inquire on a range of organizations,
use Subquery to select them. If you select a single organization, its
description displays next to the organization ID.
Select the rate type you want to use for your inquiry.
Select this option if your company does not calculate actual rates for each subperiod.
If you select this option and the rates have not been calculated yet for the accounting period, the costs will not reflect any indirect burden. This may cause the cost and revenue values to be incorrect.
Select the organization type that you want to use for your inquiry. You can inquire using the Owning Org or the Performing Org.
Information in the table window comes from the revenue report table (RPT_REV_SUM). The number of rows or projects shown in the table window is based on your selection criteria. You can change the size and order of the columns and save them to meet your requirements. The column information contains cost, revenue, and net inventory information for the subperiod, period, YTD, and inception-to-date for the project(s) selected, as well as the ITD billed, open receivable, retainage amount, and the project manager's name. If you did not narrow your inquiry to a specific fiscal year, period, subperiod, project, and organization, columns will also display for each item for which you did not select a specific value before executing your inquiry.
Information displays in the table window when you click the Execute button on the toolbar, which then enables the Match button on the toolbar. If you click the Match button and then click the Execute button, the fields from the first row automatically populate the screen header fields. Alternately, if you highlight a specific row in the table window, click the Match button, then click the Execute button, the fields from the highlighted row will populate the screen header fields, and the columns will not be visible in the table window.
Highlight a row in the table window and click this button to view additional project status information about the row. The information in the Project Status subtask defaults from the Project Status Report (PSR) table.
Click this button to view project labor detail by General Labor Category (GLC). The information in the GLC Labor Summary subtask defaults from the Project Labor Summary Report table.
Click this button to view project labor detail by Project Labor Category (PLC). The information in the PLC Labor Summary subtask defaults from the Project Labor Summary Report table.
Click this button to view employee labor detail for the selected project.