Generate budget plan from general ledger (form)

  • Article

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2

Click Budgeting > Periodic > Budget plan generation > Generate budget plan from general ledger.

Use this form to create budget plan scenarios from general ledger entries. The general ledger entries can be actual revenues or expenditure amounts, and they can be used as a historical basis for new budget plan scenarios.

On the Source FastTab, select the source information, time period, and type of ledger account to use.

On the Target FastTab, select the budget planning information to create or update. If you set the Historical field to Yes, the Is historical check box in the Budget plan form is selected. The document status for the budget plan then is set to Finalized when the budget plan is submitted to workflow. The budget plan will not follow the review and approval process that is set up for the workflow.

Task that uses this form

Generate budget plans from source information

The following table provides descriptions for the controls in this form.

Fields

Tab

Field

Description

Header

Action

Select the action to perform when the budget plan is generated:

  • Create a new budget plan – Create a new budget plan from the source information that is provided.

  • Replace the existing budget plan scenario – Delete the existing budget plan scenario, and then create a new budget plan scenario from the source information that is provided.

  • Update the existing budget plan scenario, and append new data – Update the existing budget plan scenario with the source information that is provided.

Aggregate total by

Select the aggregation option to use when the budget plan data is summarized. Aggregated lines include only accounts and amounts. Comments are not included on the aggregated lines.

Source

Ledger

Fiscal year

From period

To period

Include closing transactions

Account type

Selection criteria

Specify the source information to use for the budget plan that you are creating. This information includes the source financial ledger, fiscal year, period dates, and main account types. To include advanced criteria as source information, click Select to open the inquiry form.

Target

Budget planning process

Ledger

Document number

Budget plan

Budget plan scenario

Budget class

Historical

Responsibility center

Budget plan preparer

Budget planning user group

Generation rules

Specify the target information to use for the budget plan that you are creating. For the target budget plan, select the budget plan process, budget plan, budget plan scenario, and responsibility center. Depending on whether you are creating a new budget plan or updating an existing budget plan, different information is required. For more information about the budget planning process and the budget planning configuration options, see Key tasks: Configure budget planning and set up budget planning processes.

In the Generation rules field group, enter the rules to use for the target budget plan lines:

  • Factor – The conversion factor to apply to the source amount. For no conversion, enter 1.0.

  • Minimum – The minimum amount that is permitted for a budget plan line.

  • Rounding rule – The rounding format to use for the budget plan line amounts that are generated. For example, if the budget plan line amount is 2,444.44 and the rounding rule is 0.1, the budget plan line amount is 2,444.40. Enter 0.0 if you do not want to use a rounding rule.

Batch

For information about the batch options in this form, and about how to submit a batch processing job, see Batch tasks (form) and Submit a batch processing job from a form.

Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).