Grid Support for Change Commit
Note: Except when noted, other functions of the Change Commit Grid are similar to those for the Base Commit Grid.
The Grid for the Change Commit Business Processes of Summary Payment Application (SPA) SOV type enables you to add:
- Lump Sum
- Unit Cost
- Modify Committed Lines
The first column (Gear menu) provides the following options:
- Insert Line Item
- Insert Multiple Line Items
- Insert Costed Line Items
- Modify Committed Line Item
- Add Remaining
- Copy
- Paste
- Remove
- In the Remove gear menu, the following message is displayed when the action is triggered: “Are you sure you want to remove the selected Line Items and all the associated Costed Line Items?"
Note: The "Modify Committed Line Item ..." option will be disabled when you select a Costed Line Item.
- In the Remove gear menu, the following message is displayed when the action is triggered: “Are you sure you want to remove the selected Line Items and all the associated Costed Line Items?"
When you click the "Modify Committed Line Item ..." option, the Commit Line Picker window opens. Follow the prompts to select a Commit Line Item from SOV to insert in the Grid.
The columns in the Change Commit grid are similar to the Base Commit grid. Alongside Item Quantity, Item Unit Cost, and Amount are the following new columns:
- Error Indicator
- Attachment
- Linked Record
- Cost Line Item Type
- Cost Name
- Short Description
- Current Quantity
- Current Scheduled Value
- New Scheduled Value
The remainder of the columns display based on the form design established in uDesigner.
Total Amount Row
Similar to a Base Commit grid, a total amount row (at the bottom of the Grid) displays the Total Line Item Amount of all the Summary Line Item rows.
Form Validations
All form level validations at the system and user-defined levels are done once the Save option is selected in the toolbar.
For Lump Sum validations, the Costed Amount must be the same as the Line Item Amount for the Cost Line Item Type.
For Unit Cost validations, the Costed Quantity must be the same as the Line Item Quantity for the Cost Line Item Type.
Selecting and Modifying Line Items
You can use the "Item Quantity" and "Amount" to enter "Change Quantity" and "Change Amount" when modifying the Committed Line Items.
When you select "Modify Committed Line Item ..." option, the Committed Line Item Picker window opens to allow you to select the Line Item that you want to modify. The behavior of a line item selection is similar to the one seen when line items are added through selecting the Modify Committed Line option in Form View. You can select any Summary Line Item, from this window. Once you select the Line Item, the following occurs:
- The uuu_cost_li_type and uuu_unit_price fields, when Cost LI type = Unit Cost, are copied from the reference Commit Line Item and transferred into the Change Commit Line Item as read-only fields.
- The uuu_cost_li_type and uuu_unit_price fields are read-only and cannot be modified because the fields are from the SOV sheet.
- The short_desc field is also copied from the reference Commit Line Item and transferred into the Change Commit Line Item.
The following Costed Line Items, below the Commit Line Item, are copied into the Change Commit Line Item:
- The currency field Scheduled Value
- The bi_item, bitemid, and short_desc fileds
Note: The fields mentioned above are copied from the source distribution row and transferred into the destination distribution row.
If you select a Costed Line Item instead of a Summary Line Item, and you select Costed Line Item from the Commit Line Item Picker window, then you will add the parent Line Item, along with all the child distribution Line Items, into the Change Commit Line Item.
The short description field of the Change Commit Line Item updates the SOV sheet.
Gear Menus for Modify Committed Line Item > Summary Line Item
The following explains the functions of the Gear menus when you select the Modify Committed Line Item > Summary Line Item and click the Gear menu (in the first column).
Option | Enabled/ Disabled | Description |
---|---|---|
Insert Line Item… | Enabled | If you highlight a Committed Summary Line Item and click this option, then the system inserts another Committed Summary Line Item row above the highlighted row. |
Insert Multiple Line Items… | Enabled | If you highlight a Committed Summary Line Item and click this option, then the system inserts multiple Committed Summary Line Items. |
Modify Committed Line Item… | Enabled | If you highlight a Committed Summary Line Item and click this option, you will launch the Commit Line Item picker, and you can select the Summary Line Item for insertion. |
Insert Costed Line Items… | Enabled | If you highlight a Committed Summary Line Item and click this option, then, you can add Costed Line Items below the highlighted row. |
Add Remaining… | Enabled | If you highlight a Committed Summary Line Item and click this option, then the system launches the CBS Picker window. When you select the CBS code, the system adds a Costed Line Item, with the Short Description field auto-populated from the Short Description of the Summary Line Item, and the system calculates the value in the Amount field as Non Costed Amount - Costed Amount. This option is disabled when the Costed Amount = Amount in the Costed lines. |
Paste | Disabled (until you perform a Copy) | If you highlight a blank row and perform a Paste action, then the system inserts the Committed Summary Line Item and the Costed Line Item above the highlighted Line Item. |
Copy | Enabled | If you highlight a Committed Summary Line Item and click this option, then you copy the Committed Summary Line Item and the associated Costed Line Items. |
Remove | Enabled | If you highlight a Committed Summary Line Item and click this option, then the Committed Summary Line Item and all the associated Costed Line Items are removed. |
Gear Menus for Modify Committed Line Item > Costed Line item
The following explains the functions of the Gear menus when you select the Modify Committed Line Item > Costed Line Item and click the Gear menu (in the first column).
Option | Enabled/ Disabled | Description |
---|---|---|
Insert Line Item… | Disabled | You cannot add a Summary Line Item when a hierarchical relationship exists between the Costed Line Item and a Committed Summary Line Item. |
Insert Multiple Line Items… | Disabled | You cannot add a Summary Line Item when a hierarchical relationship exists between the Costed Line Item and a Committed Summary Line Item. |
Modify Committed Line Item… | Disabled | You cannot add a Committed Summary Line Item from an SOV sheet when a Costed Line Item is highlighted. |
Insert Costed Line Items… | Enabled | If you highlight a Costed Line item and click this option, then you can add additional Costed Line Items below the highlighted row. |
Add Remaining… | Disabled | You can perform this action for Committed Summary Line Items, only. |
Paste | Disabled (until you perform a Copy) | You can paste a Costed Line Item within the Summary Line Item. For example, if you copy the Costed Line Item 1.1 from the parent Line 1, then the copied Costed Line Item can be pasted under Line 1, only. Renumbering of the Costed Line Items occurs automatically. You can paste Costed Line Items that have the same source and destination. |
Copy | Enabled | If you highlight a Costed Line Item and click this option, then the highlighted Costed Line Item is copied. You can copy multiple Costed Line Items and insert them below the highlighted/selected Costed Line Item. The copied Costed Line Items must belong to the same Summary Line Item. You cannot copy Costed Line Items that belong to different Summary Line Items. |
Remove | Enabled or Disabled depending on the case | Case 1: A new Costed Line Item that does not exist in the SOV sheet: If you highlight the Costed Line Item and click this option, then Costed Line Item will be removed. Case 2: The Costed Line Item exists in the SOV sheet: This option is disabled if you select a Committed Costed Line Item (the Costed Line Item exists in the SOV sheet). |
Column Details Specific to Cost Allocation
The following provides the details specific to the Cost Allocation.
Log Column | Description |
---|---|
Cost Code | Required and editable within the Grid. You can select a Cost Code from the Cost Code Sheet, within the same Shell, by clicking inside the cell. Similar to the Line Items, you can enter a Cost Code in the cell and the system provides the matching Cost Codes for you to choose from. You cannot change the Cost Code of an existing Line Item that originates from an SOV sheet. |
Code Name | Read-only. The value in this field is auto-populated by the system according to the Cost Code that you have selected. |
Short Description | Editable. The default value in this field is auto-populated by the system according to the Line Item "short_desc" field. You can update/modify the default value. |
Current Quantity | Read-only. You can see the column and the values if 1) You select the Modify Reference Commit option and 2) The Commit Line Item = Unit Cost in the Cost Line Item type: uuu_cost_li_type. If the two conditions are satisfied, then the system auto-populates the value in this column as "Quantity" (from the source Commit distribution line). |
Current Scheduled Value | Read-only. The system displays this column and populates the value (regardless of the uuu_cost_li_type). The value in this column is populated when you modify an existing Line Item, from the SOV sheet, only. |
Item Quantity (Change Quantity) | Read-only if uuu_Cost_li_type = Lump Sum. Editable if uuu_cost_li_type = Unit Cost. You can enter the Costed Quantity. |
Amount (Change Amount) | Editable if uuu_cost_li_type = Lump Sum. You can enter the Costed Amount. The system calculates the value as "Change Quantity * Unit Cost" if uuu_cost_li_type = Unit Cost. The value of the Unit Cost must be according to the Detail Form (uuu_unit_price). If DE is missing, the value will be zero. |
New Schedule Value | Read-only. This column is populated when you modify an existing Line Item, from the SOV sheet, only. The value is calculated by the system as "Current Schedule Value + Change Amount". |
Last Published Monday, August 28, 2023