Define Cash Forecast Components
Define the individual components that make up each row
on your cash forecast report. You can share components across reports. It
is best to layout the report on paper first, and then start building the
components.
When defining components, the opening cash balance in the starting
position and the ending cash balance in final position must reference each other.
Because of this circular reference, Workday recommends that you define your components
in this sequence:
- Define your starting position using aBalance/Carry Overcomponent but leave theCarry Forward Fromfield blank.
- DefineAmountcomponents for your inflows and outflows.
- Define yourAccumulationcomponents, the final accumulator being your ending balance.
- Update your starting position component to reference the ending balance component in theCarry Forward Fromfield.
- Access theCreate/Edit Cash Forecast Componenttask.
- Select the component to edit, or create a new component:
Option Description AmountThe basic building blocks of your cash forecast reports. You can have them pull data from Workday sources and cash forecast adjustment entries.AccumulationAggregate of one or more amount components and other accumulation components into a new component.Balance/Carry OverThis is the beginning balance for the first column of your cash forecast report. You can specify amount details just like an amount component.For subsequent columns, this is the carry over balance from one of the accumulator components, typically your ending balance component. You can specify amount details, a carry over accumulation component, or both. - As you complete the task, consider:
Option Description NameThe name that displays in prompts when retrieving the component for inclusion in the report.Report Row LabelThe label that displays for the row on the actual report.CategoryTo organize your components for easier retrieval, select a category. To create categories, use theMaintain Cash Forecast Component Definition Categoriestask.InactiveNot available for future use. Existing use of the component in report definitions and other component definitions remains functional.In Report DefinitionIn Component DefinitionIf in use, Workday displays these fields to indicate where.Days Prior to Report Date(Amountcomponents only) Specify when you want to begin pulling source data into the amount component. Enter0to have Workday pull source data beginning on theReport Datespecified when you create a cash forecast report. Or specify the number of days before this report date for which you want to pull additional data into the first column of the report. You can go back as many as 180 days before the report date. Example: A weekly report that pulls data 7 days prior and is run on March 8 will include data in the first column back to March 1.Carry Forward From(Balance/Carry Overcomponents only) Specify the accumulation component that carries over from the previous column of the report. This is typically the ending balance accumulation component.CurrencyAssign a specific currency andCurrency Rate Typeto use for this component in the cash forecasting report. If the currency of any data that Workday pulls into the report differs when you run the report, Workday converts these amounts to this currency. You can display individual components in their own currencies on the same report.Reverse Sign for Accumulation(AmountandBalance/Carry Overcomponents) Select to reverse the sign for this component amount. The sign reversal impacts the number that displays on the cash forecast report for this component. It also impacts the sum of any accumulation component that uses this component, such as the ending cash position. Example: Select to reverse the sign for your outflows so that they display on the report and in accumulation components as negative numbers. - For amount and balance/carry over components, specify theAmount Details:
Option Description Source DefinitionFrom the Workday delivered source definitions, select the data that you want to pull into the report through the component. Unless you assign a condition rule to filter source transaction data, Workday pulls in the data for all statuses (approved, in progress, draft, canceled and so on).Amount and DateSometime sources have multiple amount values. Select the one that you want to use.Condition RuleTo limit the scope of data, apply a condition rule as defined using theMaintain Cash Forecast Rulestask. Workday does not provide filters for any of the source transaction data. To filter, create a condition rule. Example: You can create a rule to pull in approved supplier invoices only.MultiplierAdd a multiplier greater or less than one to the results.Add New RuleWhen editing, click to add a new cash forecast rule for the selectedSource Definition. You can then select this new rule as aCondition Rulefor the source.For components that only pull data from external sources, you can define an amount component without details. Then you can record adjustments against the component when you run the report. - For accumulation components, specifyAccumulation Details:
Option Description OrderThe order that you list the included components controls the structure and order of how amounts appear in the cash forecast report.Cash Forecast ComponentFrom the existing cash forecast components, select the ones that you want to accumulate and pull into the report through the component. - To launch theCreate/Edit Cash Forecast Componenttask in a new window, clickAdd ComponentorEdit Component.
The cash forecast component is available for use in cash forecast reports definitions,
and in other components.
You can use the
View Cash Forecast Component Definition
report to
review details of a specific cash forecast component. Workday provides buttons that
enable you to edit or add a component. You can also add a cash forecast rule to use as
condition when pulling data from a source definition.If you change the component definition or condition rules, create a new report.
Refresh Data
doesn't reflect these modifications. - Define another cash forecast component.
- Set up cash forecast report definitions.