to select, the starting project number
in the range. If you select All
or From Beginning in the Range
Option field, this field will be inactive.Use this screen to control the posting of revenue to the G/L for both the Compute Revenue (Projects » Cost and Revenue Processing » Revenue Processing) and Redistribute Revenue (Projects » Cost and Revenue Processing » Revenue Processing) processes. You can post revenue separately after each process is complete, or you can post after completing both processes. Posting separately (once after Compute Revenue and once after Redistribute Revenue) will provide you with a more detailed journal, but it is not necessary.
Revenue posting is a YTD "adjust-to" process. The system sums account balances from the GL_POST_SUM table for the revenue account for all periods up to and including the subperiod being calculated. The revenue account contains an Account Function Code = Revenue, and is set up at the level of the project where the revenue formula is entered. The system subtracts this amount from the sum of revenue amounts from the PROJ_SUM table for all subperiods up to and including the subperiod being posted and posts the difference to the revenue account in the GL_POST_SUM table for the current subperiod. Therefore, it is possible that revenue per GL Post Sum does not equal revenue per the PROJ_SUM table on a period-by-period basis. However, the two should be equal to YTD. The exception to this rule is when the revenue formula is set equal to Project Ledger. In this instance, no revenue is posted through this journal.
You can post revenue at either actual or target rates. If you select a target revenue posting, you can post cost variances between actual and target rates.
You can also post revenue for the owning organization or performing organization, in accordance with your option selection in the Basic Revenue Info screen (Projects » Project Setup » Revenue Setup). If you post revenue for the performing organization, a process for redistributing cost to the owning organization may be required for financial statement purposes.
This process updates the following tables for all account/organization combinations for each project selected:
FS_SUM - Financial Statement Summary table
GL_POST_SUM - Summary table for all GL Postings
GL_DETL - Detail Table for all GL Postings
REF_SUM - Reference Number Summary table
The input for this process is the PROJ_SUM table. The system does not delete records from the PROJ_SUM table at the end of the posting process, as it does with other journal postings. The journal code for this posting is SJ.
Execute this process either after the Compute Revenue process or after the Redistribute Revenue process, and before printing Financial Statements.
Use this group box to select the period for which you would like to post revenue. These fields are required.
Use this drop-down list to select a fiscal year.
Use this drop-down list to select an accounting period.
Use this drop-down list to select a starting subperiod number.
Use this group box to select the rate type you would like to use for posting revenue. This selection will apply only to cost plus type contracts. If you select Target rates, you will need to evaluate the options in the Select Variance Posting group box.
Select this option to post revenue that was calculated using actual rates.
Select this option to post revenue that was calculated using target rates. If you select this option, you can select a variance posting.
This non-editable field displays the posting status of selected records during the posting process.
Use this group box to select sorting criteria.
Select this check box to sort revenue and variance journals by project number. This is an optional sort. The standard sort is by account/organization, and a journal sorted by account/organization will always be printed.
Use this group box to select the option to post zero revenue amounts.
Select this check box to include zero revenue amounts in the posting. If you entered a ceiling or adjustment that has reduced the current fiscal year revenue in the Project Summary table (PROJ_SUM) to zero, you can select this check box to post the negative amount required to reduce the general ledger (GL_POST_SUM) to zero. If you are posting by Performing Organization (see the Basic Revenue Info screen (Projects » Project Setup » Revenue Setup)) and use the Redistribute Revenue screen (Projects » Cost and Revenue Processing » Revenue Processing), you must select this check box to reduce the revenue account balance in the general ledger (GL_POST_SUM) to zero.
If you do not select this check box, Costpoint will not post for projects that have year-to-date revenue amounts of zero. This option increases this screen's processing time, so you should use it only if you require a reduction to the general ledger revenue amount. An alternative to this option is a journal entry to reduce the revenue in the general ledger. If this check box remains blank, the total revenue columns (TOT_REV_ACT_AMT or TOT REV_TGT_AMT) in the PROJ_SUM table are zero, and the GL_POST_SUM will not be updated.
Most of the fields in this group box are available only if you have selected the Target option in the Rate Type group box.
Select this option to ensure that no cost variances are posted. This option is automatically selected when your Rate Type is Actual.
Select this option to post cost variances between actual and target burdens, by pool number, to the Cost and Receivable Variance Account/Org combinations specified in the Pool Base subtask of the Cost Pools screen (Projects » Cost and Revenue Processing » Cost Pool Setup). This option is enabled when you select the Target Rate Type. Costpoint looks for a revenue formula in the project revenue setup that begins with "Cost Incurred Plus" to determine a cost reimbursable project.
Select this option to post cost variances between actual and target burdens, by pool number, to the Cost and Receivable Variance Account/Organization combinations specified in the Pool Base subtask of the Cost Pools screen (Projects » Cost and Revenue Processing » Cost Pool Setup). This option is enabled when you select the Target Rate Type.
Select this option to perform two variance functions. When you select this option, the system will remove any previously posted variances and will not allow any new variances to be posted. Use this option when posting at Target. Since there are no variances for Actual postings, this button is not available for Actual.
Use this group box to limit the projects that will be posted.
Use this drop-down list to select the range of projects for posting.
Enter, or use to select, the starting project number
in the range. If you select All
or From Beginning in the Range
Option field, this field will be inactive.
Enter, or use to select, the ending project number
in the range. If you select All,
One, or To
End in the Range
Option field, this field will be inactive.
Click the Print Revenue icon on the toolbar to print the Revenue and Variance Journal Reports without posting to the G/L. A separate journal is provided for the revenue posting, which shows the Revenue Accounts and Unbilled-General Accounts. The variance journal contains only the Cost Variance Account and Receivable Variance Accounts. You can print the Revenue and Variance Journals as often as necessary before posting; however, for audit purposes, you should retain the Journals that you print before posting.
Click this icon on the toolbar to post to the G/L without printing the Revenue and Variance Journal Reports. You should use this icon only if you have already printed an auditable copy of each Journal.
Click this icon on the toolbar to print the Revenue and Variance Journal Reports, followed by a posting to the G/L.