Project WIP Adjustment
Form ID: (PM305600)
You use this form to create project WIP adjustments based on date-sensitive cost projections that have been created on the Cost Projection by Date (PM305500) form. These adjustments help you adjust costs for the reporting period and automatically calculate overbilling and underbilling amounts. For more information, see Project Cost Projections: Project WIP Adjustments.
Form Toolbar
The form toolbar includes standard buttons and form-specific buttons and commands. For the list of standard buttons, see Form Toolbar and More Menu. The form-specific commands can be shown as buttons on the form toolbar, as commands on the More menu, or in both places. These commands are listed in the following table in alphabetical order.
| Command | Description |
|---|---|
| Approve |
Approves the project WIP adjustment and changes its status from Pending Approval to Open. This command is available if the project WIP adjustment has the Pending Approval status. The command appears if the approval of project WIP adjustments has been configured. For more information, see Approval Configuration: Approval Maps. |
| Hold |
Changes the status of the project WIP adjustment to On Hold so that the project WIP adjustment becomes available for editing. This command appears if the project WIP adjustment has the Open, Pending Approval, or Rejected status. |
| Load Lines |
Loads lines on the Details tab and calculates the totals that are shown in the Summary area; each line represents a project. |
| Print WIP Adjustment |
Opens the Project WIP Adjustment (PM651850) report, which is generated for the current project WIP adjustment. |
| Print WIP Report |
Opens the Project WIP (PM651500) report, which is generated for the projects in the project WIP adjustment. |
| Reassign |
Opens the Reassign Approval dialog box, in which you can specify a new approver for this project WIP adjustment. This command is available if the project WIP adjustment has the Pending Approval status and the reassignment of approvals is allowed in the related rule of the approval map on the Approval Maps (EP205015) form. The command appears if the approval of project WIP adjustments has been configured. For more information, see Approval Configuration: Approval Maps. |
| Recalculate |
Recalculates all the amounts and reloads all the lines. If a newer date-sensitive cost projection exists, the system inserts its amounts and its link in the needed columns. |
| Reject |
Rejects the project WIP adjustment and changes its status from Pending Approval to Rejected. This command is available if the project WIP adjustment has the Pending Approval status. The command appears if the approval of project WIP adjustments has been configured. For more information, see Approval Configuration: Approval Maps. |
| Release |
Releases the project WIP adjustment, generates a GL batch for it, and assigns the adjustment the Released status. This command is available if the project WIP adjustment has the Open status. |
| Remove Hold |
Changes the status of the project WIP adjustment to:
This command appears if the project WIP adjustment has the On Hold status. |
| Void |
Voids the released project WIP adjustment. In the process, the system:
This command is available if the project WIP adjustment has the Released status. |
Summary Area
In this area, you can specify or modify the basic settings of the project WIP adjustment.
| Element | Description |
|---|---|
| Reference Nbr. |
The reference number of the project WIP adjustment. The system assigns this reference number based on the numbering sequence specified for these project WIP adjustments on the Projects Preferences (PM101000) form. |
| Status |
The status of the project WIP adjustment, which can be one of the following:
|
| Date |
The date when the project WIP adjustment was created. By default, the system inserts the current business date. |
| Projection Date |
The date that the system uses for the calculation of the projected values in the project WIP adjustment. By default, the system inserts the current business date. |
| Financial Period |
The financial period of the project WIP adjustment. By default, the system inserts the financial period of the Projection Date. |
| Branch |
The branch of the project WIP adjustment. By default, the system inserts the current branch. |
| Owner |
The owner of the project WIP adjustment. By default, the system inserts the name of the signed-in user. |
| Currency |
The currency of the project WIP adjustment. By default, the system inserts the currency of the branch. |
| Project Status |
The status of the projects whose lines will be added to the project WIP adjustment. You can select one of the following options: Active (default), Completed, Canceled, Suspended, Pending Approval, Rejected, Active, Completed, or All. |
| Description |
The description of the project WIP adjustment. |
| Overbilling Amount |
The total overbilling amount of the project WIP adjustment, which the system calculates as the sum of these amounts on the Details tab. |
| Underbilling Amount |
The total underbilling amount of the project WIP adjustment, which the system calculates as the sum of these amounts on the Details tab. |
| Total Amount |
The total amount of the project WIP adjustment, which the system calculates as the difference between the Overbilling Amount and Underbilling Amount. |
| Overbilling Adjustment |
The total overbilling adjustment amount of the project WIP adjustment, which the system calculates as the sum of these amounts on the Details tab. |
| Underbilling Adjustment |
The total underbilling adjustment amount of the project WIP adjustment, which the system calculates as the sum of these amounts on the Details tab. |
| Total Adjustment |
The total adjustment amount of the project WIP adjustment, which the system calculates as the difference between the Overbilling Adjustment and Underbilling Adjustment. |
| Element | Description |
|---|---|
| New Approver | The name of the employee to whom you want to reassign the selected record or records. |
| Ignore Approver's Delegations |
A check box that indicates (if selected) that the system will assign the selected records to the specified new approver but not to their delegate, even if the new approver is unavailable and has a delegate specified for the current business date. If the check box is cleared and if the new approver is not available and has a delegate specified for the current date, the system will reassign the selected records to the delegate if they’re available. If the delegate is unavailable, the system will reassign the requests to the delegate of the delegate. The system will continue the search in this way until:
|
| This dialog box has the following buttons. | |
| Reassign | Closes the dialog box and reassigns the project WIP adjustment to the specified new approver if the reassignment of approvals is allowed in the related rule of the approval map on the Approval Maps (EP205015) form. |
| Cancel | Closes the dialog box and cancels the reassignment of the project WIP adjustment to the new approver. |
Details Tab
On this tab, you can adjust costs for the reporting period and calculate overbilling and underbilling amounts for projects. When you click Load Lines on the form toolbar, the system adds a line for each project. The system uses the amounts in the project's latest cost projection created on the Cost Projection by Date (PM305500) form.
Each line shows the overbilling and underbilling amounts for the project. If no cost projection has been created or it has been created but not released, columns for amounts contain 0 in the line.
The table toolbar includes only standard buttons. For the list of standard buttons, see Table Toolbar.
| Button | Description |
|---|---|
| Send Email |
Opens the Email Activity (CR306015) form so that you can send an email message to a project manager and any other needed recipients that you may add. The email message lists projects from all the lines selected in the table and project managers specified in these lines are added to the recipients. |
| Recalculate Lines |
Recalculates amounts for each line selected in the table. |
| Delete Lines |
Deletes the lines selected in the table. |
| Column | Description |
|---|---|
| Included |
An unlabeled check box that you select to do the following, based on the button you click on the table toolbar:
|
| Project |
The project included in the project WIP adjustment. |
| Project Task |
The project task in the project line. By default, the system inserts the default project task specified on the Tasks tab of the Projects (PM301000) form, but you can override it. The system will use this task for an automatically generated project transaction when it generates a batch of GL transactions if you select Detailed Projects; Detailed Accounts or Detailed Projects; Default Accounts on the Financial tab of the current form. |
| Project Description |
The description of the project. |
| Project Status |
The status of the project. |
| Project Manager |
The ID of the employee who is responsible for managing the project and is authorized to approve the project tasks and task activities. |
| Last Cost Projection |
The reference number of the cost projection this project’s data is based on. This number is also a link that you can click to open the cost projection on the Cost Projection by Date (PM305500) form. By default, the system inserts the number of the most recent date-sensitive cost projection and displays its amounts in the line. You can select the number of another cost projection for the project specified in the line; the system will then show its amounts in the line and recalculate amounts in the Summary area. |
| Adjustment Date |
The date from the date-sensitive cost projection for the project selected in the Last Cost Projection column. The system uses this date for calculating the projected values. |
| Overbilling Amount |
The overbilling amount of the date-sensitive cost projection. The system calculates this amount by subtracting the Expected Current Revenue amount from the Billed Revenue amount on the Cost Projection by Date (PM305500) form. |
| Underbilling Amount |
The underbilling amount of the date-sensitive cost projection. The system calculates this amount by subtracting the Billed Revenue amount from the Expected Current Revenue amount on the Cost Projection by Date (PM305500) form. |
| Overbilling Adjustment |
The amount of the overbilling adjustment. If you manually change it, the Underbilling Adjustment becomes 0. By default, this amount equals the overbilling amount. |
| Underbilling Adjustment |
The amount of the underbilling adjustment. If you manually change it, the Overbilling Adjustment becomes 0. By default, this amount equals the underbilling amount. |
| Overbilling Account |
The account to which the system posts the overbilling amount on release of the project WIP adjustment. By default, the system inserts the account specified in the Overbilling Account box on the Defaults tab of the Projects (PM301000) form, but you can override it. |
| Overbilling Subaccount |
The subaccount to which the system posts the overbilling amount on release of the project WIP adjustment. By default, the system inserts the subaccount specified in the Overbilling Subaccount box on the Defaults tab of the Projects (PM301000) form, but you can override it. This column is shown only if the Subaccounts feature is enabled on the Enable/Disable Features (CS100000) form. |
| Underbilling Account |
The account to which the system posts the underbilling amount on release of the project WIP adjustment. By default, the system inserts the account specified in the Underbilling Account box on the Defaults tab of the Projects (PM301000) form, but you can override it. |
| Underbilling Subaccount |
The subaccount to which the system posts the underbilling amount on release of the project WIP adjustment. By default, the system inserts the subaccount specified in the Underbilling Subaccount box on the Defaults tab of the Projects (PM301000) form, but you can override it. This column is shown only if the Subaccounts feature is enabled on the Enable/Disable Features (CS100000) form. |
| Revenue Account |
The account to which the system posts the revenue amount on release of the project WIP adjustment. By default, the system inserts the account specified in the Default Sales Account box on the Defaults tab of the Projects (PM301000) form, but you can override it. |
| Revenue Subaccount |
The subaccount to which the system posts the revenue amount on release of the project WIP adjustment. By default, the system inserts the subaccount specified in the Default Sales Subaccount box on the Defaults tab of the Projects (PM301000) form, but you can override it. This column is shown only if the Subaccounts feature is enabled on the Enable/Disable Features (CS100000) form. |
| Pending CO Included |
A check box that indicates (if selected ) that the project WIP adjustment includes the pending amounts from change orders whose amounts are specified in the date-sensitive cost projection. If your project uses change orders, the system copies the state of this check box from the Include Pending CO in Calculations check box on the Cost Projection by Date (PM305500) form to this check box. This column appears on the form only if the Change Orders feature is enabled on the Enable/Disable Features (CS100000) form. |
Financial Tab
On this tab, you can select overbilling, underbilling, and revenue accounts and the levels that indicate how the system will post GL transactions to the overbilling, underbilling, and revenue accounts on release of the project WIP adjustment. After the batch is released, you can also view the batch number on this tab.
| Element | Description |
|---|---|
| GL Batch |
The identifier of the GL batch that the system has created when the selected project WIP adjustment was released. This identifier is also a link that you can click to open the batch on the Journal Transactions (GL301000) form. |
| Overbilling/Underbilling Posting Level |
The level that indicates how the system will post GL transactions to the overbilling or underbilling account on release of the project WIP adjustment. You can select one of the following options:
In a new project WIP adjustment, the system inserts the default level specified on the WIP Adjustment Settings tab of the Projects Preferences (PM101000) form, but you can select a different level. |
| Revenue Posting Level |
The level that indicates how the system will post GL transactions to the revenue account on release of the project WIP adjustment. You can select one of the following options:
In a new project WIP adjustment, the system inserts the default level specified on the WIP Adjustment Settings tab of the Projects Preferences (PM101000) form, but you can select a different level. |
| Overbilling Account |
The account to which the system posts the overbilling amount on release of the project WIP adjustment. In a new project WIP adjustment, the system inserts the default overbilling account specified on the WIP Adjustment Settings tab of the Projects Preferences (PM101000) form, but you can select a different account. |
| Overbilling Subaccount |
The subaccount to which the system posts the overbilling amount on release of the project WIP adjustment. In a new project WIP adjustment, the system inserts the default overbilling subaccount specified on the WIP Adjustment Settings tab of the Projects Preferences (PM101000) form, but you can select a different subaccount. This box appears only if the Subaccounts feature is enabled on the Enable/Disable Features (CS100000) form. |
| Underbilling Account |
The account to which the system posts the underbilling amount on release of the project WIP adjustment In a new project WIP adjustment, the system inserts the default underbilling account specified on the WIP Adjustment Settings tab of the Projects Preferences (PM101000) form, but you can select a different account. |
| Underbilling Subaccount |
The subaccount to which the system posts the underbilling amount on release of the project WIP adjustment. In a new project WIP adjustment, the system inserts the default underbilling subaccount specified on the WIP Adjustment Settings tab of the Projects Preferences (PM101000) form, but you can select a different subaccount. This box appears only if the Subaccounts feature is enabled on the Enable/Disable Features (CS100000) form. |
| Revenue Account |
The account to which the system posts the revenue amount on release of the project WIP adjustment. In a new project WIP adjustment, the system inserts the default revenue account specified on the WIP Adjustment Settings tab of the Projects Preferences (PM101000) form, but you can select a different account. |
| Revenue Subaccount |
The subaccount to which the system posts the revenue amount on release of the project WIP adjustment. In a new project WIP adjustment, the system inserts the default revenue subaccount specified on the WIP Adjustment Settings tab of the Projects Preferences (PM101000) form, but you can select a different subaccount. This box appears only if the Subaccounts feature is enabled on the Enable/Disable Features (CS100000) form. |
Approvals Tab
This tab displays the approval history of the project WIP adjustment. If approval is configured, the adjustment is automatically assigned for approval when it’s taken off hold. Authorized users approve or reject the project WIP adjustment either from the current form or by using the Approvals (EP503010) form.
The table toolbar includes only standard buttons. For the list of standard buttons, see Table Toolbar.
| Column | Description |
|---|---|
| Assignee ID | The employee ID of the person in the specified workgroup who’s authorized to approve the project WIP adjustment. |
| Assigned To | The name of the person in the specified workgroup who’s authorized to approve the project WIP adjustment. |
| Workgroup | The workgroup assigned to approve the project WIP adjustment. |
| Approver By (ID) | The employee ID of the person who actually approved the project WIP adjustment. |
| Approved By | The name of the employee in the specified workgroup who actually approved the project WIP adjustment. |
| Approval Date | The date when the project WIP adjustment was approved. |
| Status | The approval status of the project WIP adjustment after the approver was assigned or the approval was performed. |
| Reason | The reason the project WIP adjustment has been approved or rejected. |
