In the next step, use this screen to create subsidiary project reporting data. This process summarizes project data at the account, organization, and project level specified in this screen, so that you can create or export summarized amounts. Depending on whether the receiving location is internal or external, the project data is either created or exported. If it is created, the project data will be inserted directly in the consolidation project report tables of the receiving company. If it is exported, a file will be created that can be imported and uploaded into the receiving company's consolidation project report tables. This application creates costs, revenue, and budget amounts up to and including the fiscal year, period, and subperiod selected. The created project data can be converted from the sending company's functional currency to the receiving company's functional currency. These selections should be consistent with the Create Consolidation Entry screen.
Reporting tables to be summarized and created include the Project Status Report (PSR) and the Revenue Summary Report. Project, account, and organization names are also created so that reports and inquiries contain proper names. The process creates these names and other limited master information at the level specified in this screen. The application assumes that the level of summarization selected here is the level at which reports and inquiries will be run. Therefore, the application exports names only at these levels.
Use this screen to create the consolidation project data after the Consolidation Transfer History screen and before the Import Consolidation Data screen.
Use the drop-down box to select a receiving location code. Only active location codes are available for selection. The home location of your login company is not available.
The location description will display in the untitled field to the right.
Use the drop-down box to select the ending fiscal year for project data to be created.
Use the drop-down box to select the ending period for project data to be created.
Use the drop-down box to select the ending subperiod for project data to be created.
Enter a level number to signify the detail of project information to be created. The larger the integer, the greater the detail that will be created. If you use a smaller integer, less detail will be created. To show all levels of detail, enter zero.
Enter a level number to signify the detail of account information to be created. The larger the integer, the greater the detail that will be created. If you use a smaller integer, less detail will be created. To show all levels of detail, enter zero.
Enter a level number to signify the detail of organization information to be created. The larger the integer, the greater the detail that will be created. If you use a smaller integer, less detail will be created. To show all levels of detail, enter zero.
Use the Select pushbutton to choose a name and file path for the output file. After you have made your choice, the file path and filename will be displayed in the untitled field to the right, where they can be edited.
The Output File group box will be enabled only if the receiving location is external.
This non-editable field displays the sending company's functional currency.
This non-editable field displays the receiving company's functional currency.
Select this pushbutton to review the currency and rate that will be used to convert the sending company's functional currency to the receiving company's functional currency. This pushbutton will be enabled only if the From and To currencies are different.
Use this button on the toolbar to create the project data using the selected location, fiscal year, period, and subperiod.
Data entered in this screen is stored in the following tables:
CONS_ACCT_EXP
CONS_ORG_EXP
CONS_PROJ_EXP
CONS_PSR_HDR_EXP
CONS_PSR_FN_DT_EXP
CONS_RPT_RV_SM_EXP
CONS_ACCT
CONS_ORG
CONS_PROJ
CONS_PSR_HDR
CONS_PSR_FINAL_DAT
CONS_RPT_REV_SUM