Go to: Company Workspace > Admin mode > Templates > Shells > "Shell template" > Cost Manager > Cash Flow.
The Cash Flow module enables you to generate and compare Baseline, Actuals (or “spends”), Portfolio, Forecast, and Custom curves in a project or CBS code-based Shell.
You can use a Cash Flow Curve template to create cash flow curves in CBS-code based Shells.
All Cash Flows defined in a shell template will be included in the Configuration Package.
You can select and include multiple items in the Configuration Package.
Conditions for Creating a Cash Flow setup Configuration Package
Detail | Curve type | Component | Check |
---|---|---|---|
Project/Level Summary CBS CBS Commitment | Any | Cost = Distribute amount from cost sheet column ensure that the checks relevant to Cost Sheet are performed. If above conditions are not met, you will see an error. | Cost Sheet in the shell template. |
Project/Level Summary CBS CBS Commitment | Any | Schedule = Use dates from Schedule Sheet | Schedule Sheet in the shell template. |
Project/Level Summary CBS CBS Commitment | Any | Filter set to specific CBS Codes | When the Filter is set to specific CBS codes, ensure that the Cost Sheet in the Shell template has also been included. |
Commitment | Any | Commitment Business Processes both Commitment and Change Orders | Commit Business Process selected must be included in the Configuration Package. If this condition is not met, throw an error. |
Cash Flow Components in the Configuration Package
The system includes the following components of Cash Flow in the Configuration Package (.zip file):
- Cash Flow content – Detail Level: Project/Shell
- Cash Flow content – Detail Level: Summary CBS
- Cash Flow content – Detail Level: CBS
- Cash Flow content – Detail Level: Commitment
Note: For "Additional checks required" see to Conditions for Creating a Cash Flow setup Configuration Package, in this topic.
Cash Flow content – Detail Level: Project/Shell
Component | Field / Option |
---|---|
Cash Flow Properties / General | All fields |
Cash Flow Properties / Curves | All Curves |
Cash Flow Properties / Curves / Curve type - Baseline | All fields including the selected options for Distribution, Cost and Schedule 1 - If Distribution = Auto by default profile, the Distribution Profile will be included in the Configuration Package. 2 - If Cost = Distribute amount from cost sheet column, all the cost sheet columns available for selection will be included in the Configuration Package. In addition to this, the value selected for this field will also be included in the Configuration Package. Additional checks required. Note that Cost Sheet must always be included in the Package. 3 - If Schedule = Use dates from Schedule Sheet, the schedule sheet selected in the field should be included in the Package. Additional checks required. DEs selected in the From Date and To Date fields will also be included in the Configuration Package in addition to the possible values of the Schedule sheet DEs. |
Cash Flow Properties / Curves / Curve type - Forecast / General | All fields including the selected options for Distribution, Cost and Schedule. Behavior to be the same as the one outlined in Cash Flow / Curves / Baseline |
Cash Flow Properties / Curves / Curve type - Forecast / Options | All options selected for the Forecast Curve will be included in the Configuration Package |
Cash Flow Properties / Curves / Curve type – Portfolio Budget | All fields selected for the Forecast Curve will be included in the Configuration Package 1 - Additional checks might be needed for Portfolio Manager related Configuration. 2 - Currency is a required field for Portfolio Budget curve. The default value is set to the Project Currency. However this currency might differ from the Project Currency. It could be any of the Active and Future currencies listed in the Exchange Rate table. Therefore, if the currency differs from the Project Currency then in addition to the Currency value specified in this field, the currency and its exchange rate information will also be included in the Configuration Package. Rules for creating Currencies and Exchange Rates - Currency will get created if it does not already exist - Currency attributes such as Code, Name, Symbol etc will not be updated by means of Package import. - Currency tab content will get updated upon every import. If exchange rates defined for currencies in the source shell template do not exist in the destination environment, then a new exchange rate record will get created for that currency and that exchange rate will be set to Active. - The Effective date will be set to the Package Import Date. - The Peg rate will be brought over from the source environment. - The float rate will be brought over if the rate does not exist in the destination environment. |
Cash Flow Properties / Curves / Curve type - Actuals | All fields selected for the Forecast Curve will be included in the Configuration Package. Additional checks required. |
Cash Flow Properties / Filter | Selected Filter options If Filter = Select Summary CBS OR Select CBS codes, then the selected CBS codes will be included as part of Filter options. |
Cash Flow Properties / Options | Decimal Place Option will be included in the Configuration Package. |
Cash Flow Properties / Schedule | All options set in the Schedule tab will be included in the Configuration Package. |
Cash Flow Properties / Summary | Not applicable in templates |
Cash Flow / Permissions | Users and Groups |
Cash Flow / Filters | Filters defined for the curves will also be included in the Package |
Cash Flow content – Detail Level: Summary CBS
Component | Field / Option |
---|---|
Cash Flow Properties / General | All fields |
Cash Flow Properties / Curves | All Curves |
Cash Flow Properties / Curves / Curve type - Baseline | All fields including the selected options for Distribution, Cost and Schedule. 1- If Distribution = Auto by default profile per summary CBS, the Distribution Profile for the corresponding Summary CBS code will be included in the Configuration Package. Additional checks required. 2- If Cost = Distribute amount from cost sheet column, all the cost sheet columns available for selection will be included in the Configuration Package. In addition to this, the value selected for this field will also be included in the Configuration Package. Additional checks required. Note that Cost Sheet must always be included in the Package. 3- If Schedule = Use dates from Schedule Sheet, the schedule sheet selected in the field should be included in the Package. Additional checks required. DEs selected in the From Date and To Date fields will also be included in the Configuration Package in addition to the possible values of the Schedule sheet DEs. |
Cash Flow Properties / Curves / Curve type - Forecast / General | All fields including the selected options for Distribution, Cost and Schedule. Behavior to be the same as the one outlined in Cash Flow / Curves / Baseline |
Cash Flow Properties / Curves / Curve type - Forecast / Options | All options selected for the Forecast Curve will be included in the Configuration Package |
Cash Flow Properties / Curves / Curve type – Portfolio Budget | All fields selected for the Portfolio Budget Curve will be included in the Configuration Package. 1- Additional checks might be needed for Portfolio Manager related Configuration. 2- Currency is a required field for Portfolio Budget curve. The default value is set to the Project Currency. However this currency might differ from the Project Currency. It could be any of the Active and Future currencies listed in the Exchange Rate table. Therefore, if the currency differs from the Project Currency then in addition to the Currency value specified in this field, the currency and its exchange rate information will also be included in the Configuration Package. Rules for creating Currencies and Exchange Rates - Currency will get created if it does not already exist - Currency attributes such as Code, Name, Symbol etc will not be updated by means of Package import. - Currency tab content will get updated upon every import. If exchange rates defined for currencies in the source shell template do not exist in the destination environment, then a new exchange rate record will get created for that currency and that exchange rate will be set to Active. - The Effective date will be set to the Package Import Date. - The Peg rate will be brought over from the source environment. - The float rate will be brought over if the rate does not exist in the destination environment. |
Cash Flow Properties / Curves / Curve type - Actuals | All fields selected for the Forecast Curve will be included in the Configuration Package. Additional checks required. |
Cash Flow Properties / Filter | Selected Filter options If Filter = Select Summary CBS, then the selected Summary CBS codes will be included as part of Filter options. Additional checks required. |
Cash Flow Properties / Options | Decimal Place Option will be included in the Configuration Package. |
Cash Flow Properties / Schedule | All options set in the Schedule tab will be included in the Configuration Package. |
Cash Flow Properties / Summary | Not applicable in templates |
Cash Flow / Permissions | Users and Groups |
Cash Flow / Filters | Filters defined for the curves will also be included in the Package |
Cash Flow content – Detail Level: CBS
Component | Field / Option |
---|---|
Cash Flow Properties / General | All fields |
Cash Flow Properties / Curves | All Curves |
Cash Flow Properties / Curves / Curve type - Baseline | All fields including the selected options for Distribution, Cost and Schedule. Distribution Case 1: Auto by default profile per CBS, the Distribution Profile for the corresponding CBS code will be included in the Configuration Package. Additional checks required. Note: Cost Sheet must always be included in the Package. Case 2: Use data from Schedule Sheet, the schedule sheet will be included in the Configuration Package. Additional checks required. Case 3: Use data from P6 Source, the P6 source selected in the curve will also be included in the Configuration Package. If Cost = Distribute amount from cost sheet column, all the cost sheet columns available for selection will be included in the Configuration Package. In addition to this, the value selected for this field will also be included in the Configuration Package. Additional checks required. Schedule Case 1: Use dates from Schedule Sheet, the schedule sheet selected in the field should be included in the Package. Additional checks required. DEs selected in the From Date and To Date fields will also be included in the Configuration Package in addition to the possible values of the Schedule sheet DEs. Case 2: Use dates from P6 Source, the P6 source selected in the curve will also be included in the Configuration Package. |
Cash Flow Properties / Curves / Curve type - Forecast / General | All fields including the selected options for Distribution, Cost and Schedule. Behavior to be the same as the one outlined in Cash Flow / Curves / Baseline |
Cash Flow Properties / Curves / Curve type – Portfolio Budget | All fields selected for the Portfolio Budget Curve will be included in the Configuration Package |
Cash Flow Properties / Curves / Curve type - Forecast / Options | All options selected for the Forecast Curve will be included in the Configuration Package |
Cash Flow Properties / Curves / Curve type – Portfolio Budget | All fields selected for the Portfolio Budget Curve will be included in the Configuration Package 1- Additional checks might be needed for Portfolio Manager related Configuration. 2- Currency is a required field for Portfolio Budget curve. The default value is set to the Project Currency. However this currency might differ from the Project Currency. It could be any of the Active and Future currencies listed in the Exchange Rate table. Therefore, if the currency differs from the Project Currency then in addition to the Currency value specified in this field, the currency and its exchange rate information will also be included in the Configuration Package. Rules for creating Currencies and Exchange Rates - Currency will get created if it does not already exist - Currency attributes such as Code, Name, Symbol etc will not be updated by means of Package import. - Currency tab content will get updated upon every import. If exchange rates defined for currencies in the source shell template do not exist in the destination environment, then a new exchange rate record will get created for that currency and that exchange rate will be set to Active. - The Effective date will be set to the Package Import Date. - The Peg rate will be brought over from the source environment. - The float rate will be brought over if the rate does not exist in the destination environment. |
Cash Flow Properties / Curves / Curve type - Actuals | All fields selected for the Actuals Curve will be included in the Configuration Package. Additional checks required. |
Cash Flow Properties / Filter | Selected Filter options If Filter = Select CBS, then the selected CBS codes will be included as part of Filter options. Additional checks required. |
Cash Flow Properties / Options | Decimal Place Option will be included in the Configuration Package. |
Cash Flow Properties / Schedule | All options set in the Schedule tab will be included in the Configuration Package. |
Cash Flow Properties / Summary | Not applicable in templates? |
Cash Flow / Permissions | Users and Groups |
Cash Flow / Filters | Filters defined for the curves will also be included in the Package |
Cash Flow content – Detail Level: Commitment
Component | Field / Option |
---|---|
Cash Flow Properties / General | All fields. Additional checks required for Business Processes. |
Cash Flow Properties / Curves | All Curves |
Cash Flow Properties / Curves / Curve type - Baseline | All fields including the selected options for Cash flow granularity, Distribution and Commit BPs. Additional checks required for Business Processes. |
Cash Flow Properties / Curves / Curve type - Forecast / General | All fields including the selected options for Cash flow granularity, Distribution and Commit BPs. If Distribution Method has a Profile, then the Profile will also be included in the Configuration Package. Behavior to be the same as the one outlined in Cash Flow / Curves / Baseline |
Cash Flow Properties / Curves / Curve type - Forecast / Options | All options selected for the Forecast Curve will be included in the Configuration Package |
Cash Flow Properties / Curves / Curve type – Portfolio Budget | All fields selected for the Portfolio Budget Curve will be included in the Configuration Package 1- Additional checks might be needed for Portfolio Manager related Configuration. 2- Currency is a required field for Portfolio Budget curve. The default value is set to the Project Currency. However this currency might differ from the Project Currency. It could be any of the Active and Future currencies listed in the Exchange Rate table. Therefore, if the currency differs from the Project Currency then in addition to the Currency value specified in this field, the currency and its exchange rate information will also be included in the Configuration Package. Rules for creating Currencies and Exchange Rates - Currency will get created if it does not already exist - Currency attributes such as Code, Name, Symbol etc will not be updated by means of Package import. - Currency tab content will get updated upon every import. If exchange rates defined for currencies in the source shell template do not exist in the destination environment, then a new exchange rate record will get created for that currency and that exchange rate will be set to Active. - The Effective date will be set to the Package Import Date. - The Peg rate will be brought over from the source environment. - The float rate will be brought over if the rate does not exist in the destination environment. |
Cash Flow Properties / Curves / Curve type - Actuals | All fields selected for the Actuals Curve will be included in the Configuration Package. Additional checks required. |
Cash Flow Properties / Filter | Selected Filter options If Filter = Select CBS, then the selected CBS codes will be included as part of Filter options. Additional checks required. |
Cash Flow Properties / Options | Decimal Place Option will be included in the Configuration Package. |
Cash Flow Properties / Schedule | All options set in the Schedule tab will be included in the Configuration Package. |
Cash Flow Properties / Summary | Not applicable in templates. |
Cash Flow / Permissions | Users and Groups |
Cash Flow / Filters | Filters defined for the curves will also be included in the Package |