Go to: Company Workspace > Admin mode > Templates > Shells > "Shell template" > Cost Manager > Funding > Funding Sheet
A CBS Shell template can have a Funding Manager which helps keep track of Funds. Shell Funding sheet can be used to specify the appropriation and assignment of funds from each funding source.
The Funding Sheet setup in shell template is included in the Configuration Package.
Conditions for Creating a Funding Sheet setup Configuration Package
When the Sheet Setup information is packaged for the first time, the Fund Attribute design must also be included in the package, which means that the design must be included in the Configuration Package. If this check fails, then the package creation will result in an error. The deployed version and the Published version of the design must match.
Note: Although you are not packaging the Funding Rows, the Company Fund sheet depends on the deployed version of the design. Fund codes in the Company Fund sheet is used in order to create the fund codes in the shell templates.
This check will not be performed for customers who do not use Fund attribute forms. If the destination server has the Fund attribute form, but the Configuration Package does not include the Fund Attribute design, then the import will fail and an error will be displayed.
When the Sheet Setup information is packaged for the first time, the design of any data source used in the column definition of the sheet must be part of the package. This means that these designs must be included in the Configuration Package. If this check fails then the package creation will result in an error. For subsequent exports, check will be made to ensure that the design which uses the Data Element (ex: Status) that is specifically used in the setup is present in the Published package. As long as this condition is met, the package creation will be successful. If not, the latest design will have to be included in the package.
Funding Sheet Components in the Configuration Package
The system includes the following components of Funding Sheet in the Configuration Package (.zip file):
Component | Field / Option |
|---|---|
Funding Sheet Properties / General | Title |
Funding Sheet Properties / General | Description |
Funding Sheet Properties / General | Display Mode |
Funding Sheet Properties / Assignment / Project block | Process Contributing Assignable Funds |
Funding Sheet Properties / Assignment / CBS block | CBS Fund Source |
Funding Sheet Properties/ Assignment / Assignment Levels block | Assignment Rules |
Funding Sheet / Rows | The Fund rows are the ones that exist in the Company level Fund Sheet. As a result, this data will not be packaged. |
Funding Sheet / Columns | All columns |
Funding Sheet / Columns | All column properties. Since the data source of a Funding sheet column maybe a Fund BP, additional checked are to be performed at the time of Configuration Package creation to ensure that the Fund BP has been included in the Configuration Package as well. |
Funding Sheet / Fund assignment | Fund assignment order will not be carried over since it is dependent on the Funding rows. |
Funding Sheet / Filters | All filters set in Funding sheet. |