Budget planning integration with other modules

You can generate budget plans from several different resources. The basic elements of the periodic process are the same for all resources.

Periodic processes for generating budget plans

You can generate budget plans from the following resources:

• General ledger transactions
• Fixed assets
• Forecast positions
• Project forecasts
• Supply forecasts
• Demand forecasts
• Budget register entries
• Other budget plans

The basic elements of the periodic process are the same for all the processes. Use the tabs to define the source of the data, the target (budget plan) attributes, and options to run the process in the background as a batch process. Later sections of this article describe items that might not be apparent in each process.

Actions

For each generation process, three actions are available:

• Create a new budget plan creates a new plan that has the attributes that you select in the Target section. These attributes don't have to be unique. Therefore, two plans can have the same name and other values.
• Replace the existing budget plan scenario deletes all data in the target budget plan in the selected budget plan scenario and creates new lines that use the selected source data.
• Update the existing budget plan scenario, and append new data updates existing lines in the target plan that match the source lines and adds new lines for new data. The matching is based on the ledger account, date, budget class, and various other fields. For example, when you generate budget plans from forecast positions, the position number is an important field. All lines that have a position number that matches the source position number are replaced with the new lines from the source.

Source

For all processes, use the Source tab to filter data by using the Filter button. By default, the filter includes specific fields for each process. For example, for the Generate budget plan from general ledger process, the Ledger account and Main account categories are available and appear on the generation page. When you add fields to the filter, you also add them to the page along with any criteria you specify.

Target

Use the Historical option on the Target tab to set the effective date in the budget plan to the dates from the source data. Typically, the effective date must be within the plan’s budget cycle. When you set the Historical option to Yes, the date (including the year) of the source is used, so you can use past data as a basis for comparison. You can't modify historical data in the budget plan, and the plan is set to an approved workflow status. However, you can reset the status if other scenarios in the plan require changes.

The Aggregate total by field at the top of the page also determines the date that is used. This field totals amounts and optionally sets the effective date to the first day of the fiscal year or fiscal period.

Many of the fields on the Target tab become editable or read-only, depending on the action that you select. When you change from creating a new budget plan to updating an existing plan, the Budget plan name field becomes unavailable, and the fields that are related to selecting an existing plan become available. On both the Target tab and the Source tab, the Ledger field is always unavailable, because the value is determined by the selected budget planning process.

Use the Budget class field to set the budget plan lines as either expense transactions or revenue transactions. Usually, revenue transactions are credits to a ledger account and are therefore stored as negative amounts. Typically, these transactions also appear as negative amounts in the budget plan. However, by adding the budget class as a field in the plan layout, you can enable revenue to appear as positive amounts.

Generation rules

Three fields provide additional functionality: Factor, Minimum, and Rounding rule.

The value in the Factor field is multiplied by the source amount to set the amount in the budget plan. You can then make adjustments when you create budget plan lines. For example, you can enter 1.03 for a 3 percent increase. The factor must be a positive number.

Use the Minimum field to set the threshold amount for creating a budget plan line. If the source amount is less than this number, the budget plan line isn't created. A value of 0.00 allows all amounts but doesn't limit lines to positive amounts. (No value limits lines to positive amounts. Negative amounts are always included and usually represent credit entries.)

Use the Rounding rule field to set the precision of the budget plan lines that are created. You can round amounts to the nearest 1.00, 10.00, 100.00, and so on, of currency.

Notes for specific processes

Generate budget plan from general ledger

When you create a budget plan from general ledger data, set the Aggregate total by field to Fiscal year if you set the Historical option to No. The periods and dates in the source might not match the periods and dates in the target. Because the process has no reliable way to map these values, you must limit the process to the first of the year.

In the target, set the Budget class field to either Expense or Revenue. Use this setting to select the Budget type attribute for lines that you create when the main account on a line isn't of the Revenue or Expense type.

Generate budget plan from fixed assets

The Generate budget plan from fixed assets process has no option for aggregating by period or day. There's also no option for setting the plan as historical. Use this periodic process to include projected transactions for fixed assets in your budget planning.

Generate budget plan from forecast positions

The Generate budget plan from forecast positions process assigns the source forecast position to the budget plan line. You can view the position by adding the forecast position as a row in the budget plan layout or by using the Budget plan lines inquiry. If you don't want the forecast position assigned to budget plan lines, set the Include position in budget plan line option to No.

Lines in the budget plan are aggregated by ledger account and position. However, you can exclude the position number so that lines are aggregated by ledger account only. On the Target tab, set the Include position in budget plan option to No.

In the Budget plan FTE scenario field, select a scenario to include the number of full-time equivalents (FTEs) in the budget plan. This field is limited to quantity-type scenarios that are included in the layout of the target budget plan. If you select an FTE scenario, you must also select an FTE main account. Use this account to create the quantity budget plan lines.

The budget planning process and budget plan scenario that you select in the source set the target scenario budget planning process and scenario. Because these attributes are assigned to forecast positions, they must match the budget plan. Therefore, you can't modify these attributes on the target.

Generate budget plan from project forecasts

The Generate budget plan from project forecasts process, like the Generate budget plan from forecast positions process, includes an option to add project quantities (hours, expenses, and items) in a quantity scenario. These two processes also have similar filters for the columns in the budget plan layout.

On the Source tab, three options in the Include statement section determine which budget plan lines are created. These options match the options that are available when you create budget register entries directly from project forecasts. Set the Profit and loss option to Yes to create lines for costs and for revenues. Set the WIP option to Yes to create work in process entries. Set the Payroll allocation option to Yes to create lines for the payroll offset accounts for hour transactions.

There's no Budget class field, because the source determines the budget class (Expense or Revenue).

You can use project budgets as a source by selecting the forecast model that contains the project budget amounts. Remember that project budgets create project forecast entries as they are approved.

To select only costs or revenues for budget plan lines, use the filter to select Budget updates: Amount type = Cost. To select only one type of forecast, use the filter to select Budget updates: Transaction type = xxx.

You can use only one forecast model to generate a budget plan scenario. If you run the process for one forecast model, and then do an update and try to specify another model, the first model is overwritten if the same project and ledger accounts apply. To generate a budget plan scenario from more than one forecast model, generate into different budget plan scenarios, and use allocation options to add them together in another scenario.

The Generate budget plan from project forecasts process also assigns the source project to the budget plan line.

Generate budget plan from supply forecast

The source filter options in the Generate budget plan from supply forecast process were modeled after options in the Transfer purchase budget to ledger function, because of similarities between the process and the function.

Generate budget plan from demand forecast

For the Generate budget plan from demand forecast process, set the Sales order option to Yes to generate revenue lines in the budget plan, set the Consumption option to Yes to create expense lines, or set both options to Yes.

Generate budget plan from budget register entries

For the Generate budget plan from budget register entries process, the source must specify one submodel, one budget code, and one entry number. In other words, you can create budget plan lines for only one budget register entry at a time. To use more entries in the same budget plan, run the process one time for each source entry.

Generate budget plan from budget plan

For the Generate budget plan from budget plan process, an extra set of options on the Target tab lets you assign new financial dimensions. If you select a financial dimension, all budget plan lines use that value. You can use one budget plan as the basis for other budget plans, but you can also assign, for example, a different department or cost center to the new budget plans.

Looking back from the budget plan

Budget plans by dimension set inquiry

The Budget plans by dimension set inquiry includes several options that you can use to run a query to help identify the source of the budget plan data.

Select a line and select the Budget plan lines button to run the Budget plan lines query. The results are filtered for the dimension values of the selected line. You can then apply more parameters.

Use the Supply forecast and Demand forecast buttons to run these queries. In both cases, the query searches for forecast lines that could have created the budget plan lines.

Additional reports that are available include the Forecast positions by budget plan report. This report is especially useful when you want to determine whether a position is correctly allocated to budget plans.