Share This Post

NAV Updates

Dynamics NAV Budget Creation and Functionality

Dynamics NAV Budget Create

You can have multiple Dynamics NAV budget for identical time periods by creating budgets with separate names. First, set up the budget name and then enter the budget figures. The budget name is then added on all budget entries you create.

Dynamics NAV Budget

Dynamics NAV Budget

When you create a Dynamics NAV budget, you can define four dimensions for each budget. These budget specific dimensions are called budget dimensions. You select the Dynamics NAV budget dimensions for each budget from among the dimensions you have already set up.
Budget dimensions can be used to set filters on a Dynamics NAV budget and to add dimension information to budget entries.
Dynamics NAV Budget plays an important role in the business intelligence, such as in the financial statement based on the account schedules that add the budget entries or when analyzing the budgeted versus the actual amounts in the chart of accounts.
Budgets play an important role in the business intelligence, such as in the financial statement based on the account schedules that add the Dynamics Navision budget entries or when analyzing budgeted versus the actual amounts in the chart of accounts.
In the cost accounting, you work with the cost budgets in a similar way.

To create a new budget

Create new budget

Create new budget

 

  1. Enter the G/L Budgets, and then select the related link.

  2. Select the Edit List action, and fill the fields as necessary. And choose a field to read a short description of the field or link to more information.
  3. Then Choose the Edit Budget action.
  4. At the top of the Dynamics NAV Budget window, fill in the fields as necessary to define what is displayed. Only the entries that contain the budget name, you entered in the budget Name field are displayed. Because the budget name has been made, then there are no entries that match the filter. Therefore, the window is empty.
  5. To enter the amount, select the relevant cell in the matrix. The G/L Budget Entries window opens.
  6. Create a new line and fill the Amount field. Close the G/L Budget Entries window.
  7. Repeat the steps 5 and 6 until you have entered all the budget amounts.

Creating Cost Budgets

Budgeting in the cost accounting resembles budgeting in general ledger. A cost Dynamics NAV budgets are created based on cost types just as a budget for the general ledger is created based on general ledger accounts.

A cost Dynamics NAV budgets are created for a certain period of time, for example, a fiscal year. we can create as many cost budgets as needed. You can create a new cost budget manually, or by importing the cost budget, or by copying the existing cost budget as the budget base.

Use the following windows to create and analyze cost budgets and then read the tooltip for each.

 Cost Allocation page Cost Budget Registers page

To See
 Transfer budgets from the general ledger.  Copy G-L Budget to Cost Acctg. batch job
 Copy cost budgets.  Copy Cost Budget batch job
 Allocate budgets.
 See cost budget registers and cost budget entries.
 Print cost budget comparisons using various reports.  Cost Acctg. Balance-Budget report
 Cost Acctg. Statement-Budget report
 Cost Budget by Cost Center report
 Cost Budget by Cost Object report

Microsoft Dynamics NAV advanced budgeting functionality

Advance Budgeting

Advance Budgeting

Distributed budgeting and advanced budgeting functionality have always been a shortcoming of Dynamics NAV and many other ERP solutions.

The ability to create the budget models and distribute these to the contributors has often been managed by Microsoft Excel or third-party products like Microsoft Forecaster. Anyone who has used Excel for distributed budgeting knows the issues that create along with users changing rows and columns and links that tend to die just as you think you’re finished.

Third party products require integration, the re-creation of your financial structure and delayed updates of actual data to provide comparisons. Another weakness of both is the inability for them to work in the cloud.  Microsoft Forecaster is at the end of its life, with Microsoft not giving the roadmap for it.
Based on this, Intergen has developed an Advanced Budgeting solution which provides a distributed budgeting solution inside MS Dynamics NAV.
Being built inside NAV means there is no recreating the organizational structure because all Dimensions and G/L accounts are already available. Administrators can push out the budgets to contributors based on the Dimension G/L account combinations.
Entries can be created by copying the previous budgets or the actuals, spreading across periods, basing results of the account on other accounts values, entering the quantities and prices or updating from the fixed asset module.
The functionality can be accessed either through the Windows client, the web client or the SharePoint framework and only requires a limited use license for budget users. The budgets can be seen using the standard reporting tools given by the Dynamics NAV or third-party solutions.
One advantage of the Excel is the ability to create formulas between cells; therefore we’ve needed to recreate that the functionality to allow target accounts to be driven off source accounts or create the fixed prices where the users are only asked to include the quantity and the cost is decided for them, examples, where this may be used, is trips or mobile phone bills etc.
For services-based organizations, like Intergen, payroll costs make up a large portion of our overall costs; therefore being able to budget at the individual employee level is important.
Different types of employee costs can be associated with the employee and posted through to the G/L budget. Access the payroll budget is again controlled by the security with the ability to post to the G/L budget.
What it offers:

  • G/L based budgeting with the ability to have contributors
  • Built inside NAV and utilizes all standard NAV functionality
  • Security at Dimension/GL Account  level
  • Unlimited number of budgets and forecasts
  • Quantity and amounts able to be budgeted
  • Formulas for calculating account values based on other accounts
  • Spread functionality across time
  • Copy from previous budgets or actuals
  • Integrated Fixed Asset budgeting for Capex and depreciation
  • Payroll budget for employees’ salaries or wages
  • Approval and Workflow functionality
  • Advanced cost allocations
  • Interfaces with Excel
  • Ability to store notes or linked documents

Share This Post

Leave a Reply

avatar
  Subscribe  
Notify of
Skip to toolbar