This chapter contains these topics:
Section 63.1, "Job 5001 - Job Level Summarization (P51800) (Update A9.3)"
Section 63.2, "Profit Recognition History File Delete (P51810) (Release A9.3 Update)"
Section 63.7, "Profit Recognition Report (P51445) (Update A9.3)"
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| PROCESSING MODE: | |
| 1. Enter '1' for Final or leave it blank for Preliminary (Default Preliminary). | |
| EXECUTION PARAMETER SELECTION: | |
| 2. Enter the period ending date through which profit will be recognized.
You MUST enter a valid date here. |
|
| 3. Enter the prior quarter ending date.
This date should have an existing profit recognition history record. If you do not enter a valid prior quarter ending date, the Earned Current Quarter amounts will be set to the Earned Job to Date amounts. |
|
| 4. Enter the company number for which Profit Recognition will be performed. | |
| 5. Enter the summarization level to store financial data:
'1' = Project level '2' = Job level (default) '3' = Subledger level '4' = Revenue Performance Obligation (RPO) level |
|
| 6. Enter the profit recognition threshold (for example, enter 10% as '10'). | |
| 7. Enter the deferred profit recognizing method:
'1' = Recognize deferred profit all at once (default). '2' = Defer recognition over the life of the Job/Profit. |
|
| 8. Enter '1' to derive Projected Final Cost using the percent of completion from the F% ledger with a blank Cost Code and Cost Type. Leave blank (default) to accumulate the Projected Final Cost stored in the HA ledger. | |
| 9. Enter the Profit Recognition Method to load into each project, job, or subledger processed as follows:
'1' = Percent of Cost (default). '2' = Percent of Revenue. '3' = Percent of Cost or Revenue, whichever gives lower profit. |
|
| PRINT OPTION: | |
| 10. Enter '1' to print the "Executive Summary" report format. Leave blank (default) to print the "worksheet" report format. | |
| POSTING EDIT CODE SELECTION.: | |
| 11. Enter a '1' to display only the jobs associated with the projects that are not closed, or enter a blank to see all jobs. |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| VERSION SELECTION: | |
| 1. Enter the Profit Recognition (P51810) DREAM Writer version to remove. | If you set the Delete Obsolete Records processing option to delete obsolete records, the system ignores this processing option and deletes obsolete records from all versions of Profit Recognition. |
| JOB SELECTION | |
| 2. Enter the job number of the profit recognition records to be removed from the F5144 and F5145 tables.
If left blank, the system removes all records for the Profit Recognition version specified in the Version Selection processing option. |
|
| DELETE OBSOLETE RECORDS | |
| 3. Enter '1' to delete obsolete records for a job from F5144 and F5145 tables.
If left blank, obsolete records will not be deleted from F5144 and F5145. |
If this processing option is set, the system deletes obsolete records for the job specified in the Job Selection processing option for all versions and not only the version specified in the Version Selection processing option. |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| DW VERSION SELECTION: | |
| 1. Enter the Job Status Inquiry (P512000) DREAM Writer version for the related function key exit. The default is version 'ZJDE0001'. |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| DW VERSION SELECTION: | |
| 1. Enter the Job Status Inquiry (P512000) DREAM Writer version for the related option selection. The default is version 'ZJDE0001'. |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| PRINT OPTION: | |
| 1. Enter '1' to print Earned Current Quarter amounts. Leave blank (default) to print Earned Current Period amounts. |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| RECORDING PROJECTED FINALS: | |
| 1. Enter '1' to create journal entries for changes to Projected Final Cost, Revenue, and Profit. Leave blank (default) to not book these entries. | |
| 2. To create entries for changes to Projected Finals, enter the Ledger Type to use. Leave blank (default) to use Ledger Type 'FA'.
NOTE: If using Ledger Type 'FA', the Method of Computation should be 'F' or 'G' in order for Projected Final Amounts to be recalculated correctly. |
|
| OVERRIDE OPTION: | |
| 3. To override the business unit or add subledger information to the account entries for cost, revenue and over/ under billings on the Invoice Statement, enter the following:
NOTE: These values will override or add to the accounts retrieved from the AAIs: ISxxxx, JCCOUA, JCBOUS, JCLOSS. a. Job (Business Unit): b. Subledger: c. Subledger Type: d. Enhanced Subledger 1: e. Enhanced Subledger Type 1: f. Enhanced Subledger 2: g. Enhanced Subledger Type 2: h. Enhanced Subledger 3: i. Enhanced Subledger Type 3: j. Enhanced Subledger 4: k. Enhanced Subledger Type 4: |
|
| DATE SELECTION: | |
| 4. Enter the General Ledger date for entries created in Profit Recognition. If left blank G/L date from Profit Recognition build will be used.
NOTE: If Profit Recognition is not run at the end of each period then assigning the G/L date is necessary to be able to reconcile the WIP accounts. |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| EFFECTIVE DATE | |
| 1. Enter the effective date used to select the Profit Recognition detail that appears on the report. If this processing option is left blank, the financial reporting period end date for company 00000 will be used for the effective date. | Note that the effective date is not a through date. The effective date in this processing option must match the effective date in the journal entry records. |
| REPORTS AND DATA PRINT | |
| 2. Enter "1' to bypass printing either report. If both fields are left blank, the system prints both reports.
Projected and Job to Date Prior and Current Period Balance |
|
| 3. Enter '1" to bypass printing subledger information on the report. If left blank, the system prints subledger information if it is not blank. | |
| PROVISION FOR LOSS | |
| 4. Enter a '1" to not add the Provision for Loss to the Job Earned to Date. If left blank, the Provision for Loss will be added to the Job Earned to Date. |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| PROCESSING MODE | |
| 1. Enter '1' for final of leave blank for preliminary. | When you run the program in preliminary mode before running it in final mode, the system creates a report, which you can use to verify that correct profit recognition records are marked as obsolete. In preliminary mode, the system does not update profit recognition information.
When you run the report in final mode, the system selects the Obsolete Flag on the profit recognition records. |
| EXECUTION PARAMETER SELECTION | |
| 2. Enter the summarization level at which obsoleting profit recognition records will be performed.
1: Project level 2: Job level 3: Subledger level 4: Revenue Performance Obligation (RPO) level Blank: All levels (default) |
|
| 3. Enter the company number for which obsoleting profit recognition records will be performed. | If you leave this processing option blank, then, depending on the data selection, the system makes all profit recognition records corresponding to all companies obsolete. |