Export (0) Print
Expand All

Configure position budgeting [AX 2012]

Updated: March 6, 2014

Applies To: Microsoft Dynamics AX 2012 R3

This topic describes the procedures that are required to set up position budgeting so that you can create and work with forecast positions.

To budget for new and existing positions in future budget cycles, you must consider all costs that are related to forecast positions. In Microsoft Dynamics AX 2012 R3 and cumulative update 7 for Microsoft Dynamics AX 2012 R2, these costs are called budget cost elements. Budget cost elements represent earnings, employer benefits, taxes, or other expenditures for which an organization will budget for a forecast position. You can create as many budget cost elements as you want. After you create the budget cost elements that your organization requires, you can assign the budget cost elements to forecast positions.

If you have any problems while setting up position budgeting, see the frequently asked questions about how to configure position budgeting in Position budgeting setup issues.

If you are using a version of Microsoft Dynamics AX 2012 R2 prior to cumulative update 7, see Budget purpose types (form).

NoteNote

This topic does not apply to versions of Microsoft Dynamics AX 2012 prior to cumulative update 7 for AX 2012 R2.

The following illustration shows the steps that are required to configure position budgeting. The numbers correspond to the procedures later in this topic.

Configure position budgeting diagram

The following table shows the prerequisites that must be in place before you start.

Category

Prerequisite

Version

Microsoft Dynamics AX 2012 R3 or cumulative update 7 for Microsoft Dynamics AX 2012 R2

Budget cost elements are specific costs that are associated with a position, such as 401k matching, cell phone allowances, base pay, and so on. Each budget cost element can be assigned to multiple positions and can include detailed information, such as the legal entity and the main account to use.

NoteNote

If you are using a version of Microsoft Dynamics AX 2012 R2 prior to cumulative update 7, budget cost elements are called budget purpose types. For more information, see Budget purpose types (form).

To create a new budget cost element, follow these steps:

  1. Click Human resources > Setup > Budget planning > Budget cost elements.

  2. Click New and complete the following fields:

    Field

    Description

    Budget cost element

    The name of the budget cost element, such as Overtime or Dental plan A. You can’t change the name of the budget cost element after you save it. Therefore, consider all naming conventions before saving to make sure that the name is unique and the budget cost element can be identified easily.

    NoteNote

    All organizations should have at least one “Base pay” budget cost element. In addition, most have 401k elements, life insurance elements, car insurance elements, and many others.

    Description

    Enter additional information to help users if they are not sure which budget cost element to select when they assign budget cost elements to positions.

    Budget cost type

    Select the budget cost type that best describes the budget cost element:

    • Benefit – Select this option for benefit-related costs, such as Group dental.

    • Tax – Select this option for tax-related costs, such as FICA.

    • Other – This type is automatically assigned to all budget purpose types that were updated from Microsoft Dynamics AX 2012 R2. You can also assign this type to budget cost elements that are not accurately described by the other available budget cost types.

    • Earning – Earning budget cost elements are unique because they can be used as the cost basis for other budget cost elements. For example, if you create a Base pay cost element that has a budget type of Earning, you can create an Annual bonus cost element that is calculated by multiplying 10 percent of the Base pay value. If the base pay is 100,000, the bonus is 10,000. For more information about how to configure cost elements to use other cost elements as a calculation basis, see step 5.

  3. By default, users can override cost element values for individual forecast positions. Many taxes will fall into this category. If you do not want users to change the value of a particular cost element, on the General tab, make sure that you set the Forecast position override field to Do not allow cost changes.

  4. Complete the fields on the Cost calculation tab. The information in this tab determines the currency value that is calculated for the budget cost element.

    Field

    Description

    Add

    Add a new line to the cost element. You can create multiple lines for each cost element.

    If you are changing a line and adding a new line to a budget cost element that is already assigned to forecast positions, click Update positions to update the existing lines on the forecast positions. To add the new line to the assigned forecast positions, copy the list of forecast positions in which the budget cost element is assigned when updating the positions and continue with the update process. After you have updated the positions, click Add to positions and select the positions that you copied. The new line will be added to the positions.

    Legal entity

    You must create at least one line for each legal entity that offers the cost element. If you do not create a line for a legal entity, the cost element is not available to forecast positions that are assigned to a budget planning process that uses the ledger for the legal entity.

    NoteNote

    Each budget cost element can have multiple lines for the same legal entity, if the dates that are assigned to the lines do not overlap. For example, if you are creating a budget cost element for a 500.00 monthly car allowance that will increase to 550.00 next year for a particular legal entity, you would create two lines for the legal entity. One line would have an annual amount of 6000.00 for one year and the other would have an annual amount of 6600.00 for the following year.

    Effective

    Expiration

    If you enter multiple lines for the same legal entity, the date ranges can’t overlap, but gaps are permitted.

    Main account

    The main account is not required to save the budget cost element, but is required when users add the budget cost element to a forecast position.

    Percent

    If the cost element is percentage-based, enter the percentage, such as 3. You can create multiple lines for different percentages if you know that they will change. For example, if the PERS percentage will increase from 3 percent to 4 percent of base pay next year, enter 3 in the Percent field and set the expiration date to the end of the year. Then create a second line and enter 4 in the Percent field and set the effective date to the first day of the following year.

    You must assign a budget cost element as the calculation basis so the value can be determined. For more information, see step 5.

    ImportantImportant

    If you upgraded your data from Microsoft Dynamics AX 2012 R2, all budget purpose types that were calculated by using a percentage of the annual gross compensation are converted to fixed amounts. You must reconfigure these after the data upgrade is complete so they calculate correctly.

    Annual amount

    If the cost element is a fixed amount, enter the annual figure in the Annual amount field. For example, enter 600.00 for a 50.00 monthly gym allowance.

    Annual limit

    This field is available only for budget cost elements that are calculated by using a percentage. It is typically used for certain taxes and retirement contributions. If you are setting up a percentage-based cost element and there is no annual limit, leave this field set to 0 (zero).

    This limit applies to each 365 day increment that is found within the start and end date of the cost element. For example, if you enter a value of 3500.00 in the Annual limit field and the date range for the cost element spans two years, a limit of 7,000.00 will be enforced.

  5. If you entered a percentage instead of an annual amount for any calculation line on the Cost calculation tab, follow these steps on the Calculation basis tab:

    1. Click Add.

    2. Select the budget cost element that the percentage is based on.

    3. Repeat these steps until all the budget cost elements are listed.

NoteNote

All of the earning cost elements that you list on this tab are multiplied by the Percent field value on the Cost calculation tab to determine the value of the cost element that you are creating. For example, suppose you are creating a Medicare cost element and you list Base pay, Overtime pay, and Bonus pay on this tab. If you entered 1.45 in the Percent field on the Cost calculation tab, the system calculates 1.45 percent of each value to determine the Medicare tax estimate for forecast positions.

Although you can assign individual budget cost elements to forecast positions, it might be more efficient to group together budget cost elements for positions that receive similar pay and benefits. For example, you could create a compensation group called Admin that has the following budget cost elements assigned to it: 401k, medical, dental, and Social Security tax.

NoteNote

You can assign a compensation group to a forecast position on the Compensation tab of the forecast position. After you assign a compensation group to a forecast position, you can make any specific adjustments to the forecast position.

To create a compensation group, follow these steps:

  1. Click Human resources > Setup > Budget planning > Compensation groups.

  2. Click New.

  3. Enter a name for the compensation group. This is often the name of the group of positions that have the same compensation plan, such as Admin.

  4. Enter a description such as Hourly administrative assistant, to help users make the appropriate selection when they assign compensation groups to positions.

  5. On the General tab, specify the following information.

    Field group

    Field descriptions

    Annual conversion rules

    These field values determine the compensation amount for positions that are assigned to the compensation group.

    • Compensation basis – Select whether positions in this compensation group are paid on an hourly basis, or if they are paid a salary.

    • Annual regular hours – If you selected Hourly wage in the previous field, enter the number of regularly paid hours that positions in this group are expected to have each year. This value is used to convert hourly wages to an annual salary amount that can be used to calculate values for budget cost elements.

    Compensation details

    These fields provide information about when increases are awarded to positions that are assigned to the compensation group.

    • Increase schedule – Select whether increases occur on the same “common” date for positions in the compensation group, or if increases are awarded based on the worker’s anniversary date. This field determines the Scheduled increase date value for forecast positions that are assigned to this group. This field is for informational purposes only.

    • Date of increase - If you selected Common date in the previous field, enter the date that positions in this compensation group will receive an increase. This field is for informational purposes only.

    • Earning cost element – Select the budget cost element that defines the base compensation, such as Base pay. Only budget cost elements for which the Budget cost type field is set to Earning are displayed.

  6. On the Budget cost elements tab, assign the default budget cost elements to the group. (You can change these for individual positions if there are exceptions.)

    1. Click Add.

    2. Select a budget cost element to add to the group. You can assign the same cost element to a group only one time.

    3. Repeat these steps until you’ve listed all the cost elements that positions assigned to this group typically receive.

      TipTip

      You can’t change the cost element values in this form. If the cost element is not accurate for this group, you must create a new one or modify the existing one in the Budget cost elements form as described in the “1. Create budget cost elements” section earlier in this topic.

If your organization has standard compensation tables that are referenced to determine worker pay when positions are forecasted, you must create and assign step tables of currency values. You can use these tables as a basis for compensation calculations. If you have not created a reference point setup that you can use for this grid, you must exit this area and create it before you set up the grid. For more information, see Reference point setups (form).

NoteNote

The grids that you use for position budgeting are based on the grids that have already been created for active positions. However, any changes that you make in the position forecasting and budgeting areas do not affect live compensation calculations.

To create a compensation grid, follow these steps:

  1. Click Human resources > Setup > Budget planning > Compensation groups. Click Maintain compensation groups.

  2. In the Set up compensation form, do one of the following tasks:

    • If you don’t have an existing compensation grid that you want to use as a starting point for the grid, select Set up a new compensation grid and select the reference setup to use in the grid. All existing reference point setups that have the Type field set to Step are listed.

      TipTip

      The reference setup that you select determines the columns that appear in the compensation grid.

    • If a compensation grid already exists that is the same or very similar to the one that you are creating, select Create a new compensation grid from an existing grid and select the grid to copy in the Copy from grid field.

  3. Select the first level to use in the grid and enter the appropriate currency values for each step and level combination. These can be hourly or annual figures, depending on the Compensation basis setting for the compensation group.

  4. Click New to add more levels to the grid and enter the appropriate currency values for each combination until the grid is finished.

NoteNote

If you have selected a compensation group and a compensation level for a forecast position, a new budget cost line is added to the forecast position. This budget cost line uses the label that you selected in the Earning cost element field for the compensation group. The amount is calculated differently, depending on the compensation basis that you selected:

  • If you selected Annual salary in the Compensation basis field of the compensation group, the annual amount is copied from the compensation grid by using the level and step to determine the amount.

  • If you selected Hourly wage in the Compensation basis field of the compensation group, the annual amount is determined by using the level and step value, multiplied by the Annual regular hours value that is specified for the compensation group.

For more information, see Work with forecast positions.

If you don't have access to the pages that are used to complete this task, contact your system administrator and provide the information that is shown in the following table.

Category

Prerequisite

Configuration keys

Budget planning configuration key (LedgerAdv2BudgetPlanning)

Security roles

Budget clerk (compensation groups only)

Compensation and benefits manager

Budget manager

Human resource assistant


Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft