The generic cost sheet displays transactional data by period and shell level. In the context of working with the generic cost sheet, you can filter the cost data you are viewing by shells or sub-shells. The generic cost sheet is accessed from the Shell > Configurable Managers > Generic Cost Manager > Generic Cost Sheet log. You can use the shell or sub-shell filter in combination with the timescale selector documented in the next section to create various views in your spreadsheet based on shell or sub-shell and time period.
To view generic cost sheet data by shell or sub-shell
- Open the shell and click Configurable Managers > Generic Cost Manager > Generic Cost Sheet in the left Navigator. The Generic Cost Sheet log opens.
- Open the Generic Cost Sheet you want to work with by double-clicking the cost sheet name or by selecting the cost sheet name in the log and then choosing File > Open.
- In the View By selection list, choose one of the following:
- Current Shell only: Data from the current shell you have selected. Manual column data is editable in the Current Shell only view.
- Current Shell and Subshells only: Data from both the current shell and its sub-shells.
- Subshells only: Data from the sub-shells of the current shell.
In Generic Cost Sheet views, data is rolled up from the current shell and sub-shells. When data is rolled up from sub-shells, the generic cost sheet under a shell can roll up data from other shells that are created as sub-shells and their sub-shells. The Current Shell and sub-shells only and Subshells only views support this rollup. For example:
- North Region (shell)
- Property A (sub-shell)
- Building 101 (sub-shell)
- Building 102 (sub-shell)
- Property B
- Building 201
- Building 202
- Property A (sub-shell)
In this example, the North Region Generic Cost Sheet will have data from Property A, Property B, Building 101, Building 102, Building 201, and Building 202. Property A has data from Building 101 and Building 102. Property B has data from Building 201 and Building 202.
Also, data from a sub-shell to its parent shell can only roll up if the codes match. For example,
- North Region (Shell)
- Property A (1000–1001: $500)
- Building 101 (1000–1001: $500)
- Building 102 (1000–1002:$200)
- Property A (1000–1001: $500)
In this example, Building 101 will roll up to Property A as the codes match (1000–1001). Building 102 will not roll up because the codes are different (1000–1002). Parent and child shell cost codes must match for roll up to occur. Timescale and column definition must also match across the shells and sub-shells.
Also, all sub-shells that will roll up must have the same currency as the parent shell. If all of the sub-shells and the current parent shell have the same currency, the data displays in that currency. If at least on sub-shell has a different currency, the data displays in the Base Currency. A confirmation message alerts you to this currency display.
While rolling up, only parent shell generic cost sheet codes should be considered. This is applicable under all views.