Updating Cost Sheet Columns in a Shell

Cost sheet columns can be updated in CBS code-based shells.

The Update Shell process runs in the background. Depending on the number of records and shells you are updating, it can take a considerable amount of time to complete. The process is complete when the End Date column in the Shell History window shows the complete date.

Notes:

A column is identified by a unique data source.
If the cost sheet does not exist in the shell, the column is not added.
If the shell cost sheet is present but the column does not exist, the column definition is created, and the column is added. Column restrictions are added. Users/Groups are created or updated.
For formula columns, be sure to first push the columns or data sources that make up the formula (if they do not exist in the cost sheet), then push the formula column.
Any new column that is created will use the column to its immediate left as the reference point for positioning. When a column is added to the cost sheet via an update, this means: If the column to the left of the column that is being pushed exists in both the template and cost sheet, the column will be positioned in the cost sheet according to its position in the template. If the column to the left of the column being pushed exists in the template but does not exist in the cost sheet, then the column will be added to the end (far right) in the cost sheet.

Related Topics