Budgetting In Ax 2012

 I will explain all about the new budgeting functionality for projects in AX 2012.
In AX 2009, we could do only forecasting of projects and then consider that as the project budget. There was not a well defined procedure for end to end budgeting of projects ( When i say end to end, it involves forecasting the project costs and revenues, creating budgets based on the forecasts, submitting the budget for approval, automatic budget overrun control, budget revisions etc).
Now in AX 2012, MS has done a tremendous job in the project budgeting functionality and i must say, this can be used out of box for implementations without requiring any(Major) customizations.
Let us now look at all the aspects of this one by one below.
Let us assume that we have a fixed price project TEST_BUD_01.
1. Setup the project budget parameters:
  • The budget control parameters can be set both at a global level and at the project level. To enable the budget control functionality for all the projects at a common place, go to Project Management  and Accounting > Setup > Project management and accounting parameters > Cost control link(On left pane).
  • Please see the screenshot below for the various fields for the budget control. Check mark the “Use budget control” check box
  • Set Transaction type to be controlled = Revenue and costs.
  • Budget overrun default = disallow overruns. Please refer to screenshot below.
2. Create and submit the project budget:
  • Go to Project Management  and Accounting > Common > All Projects.
  • Select the project for which we will create the budget. (TEST_BUD_01).
  • Click on tab Plan and click Budget > Project budget. Please see the screenshot below.
  • Now on the Project budget form, select forecast models Original budget = OrigCash and Remaining budget = RemCash.
  • Now select a budget basis from the 3 options which are ,
    Entry – Enter the Cost and revenue budgets manually. Forecast – Select a forecast model and the project forecasts will be converted to budget. Project transactions – Select this if your want to budget your current project based on the transactions of any existing project.
  • Depending on the selection of the basis of the budget, the budget lines budget lines will be entered.
  • In our case we will create the project forecasts and select the budget basis as Forecast. Below screenshot shows the project budgets which are created from the forecasts when clicked on the Load Values button.
  • Click on the Submit button(Workflow Yellow bar) to submit the budget for required approval.
  • Run the workflow tutorial form to kick off the workflow and after the record is processed in workflow, come back to the project budgets form and approve it making yourself as the approver for TEST purpose.
  • Now notice the work flowinfolog which says the budget is committed to the project.
4. Post project transactions:
  • I will not list out the steps to post the project transactions here as we all know about it. Let us say i will post 155  hours against category Design. With this let us verify the project budget balances.
  • Go to Project TEST_BUD_01 and click on Plan > Project budget.
  • Now on the Project budgets form, click Related information > Project budget balances.
Please see the screen below which shows the actual costs incurred and the remaining balances in the project budget.
6. Create and submit/Approve budget revisions:
  • The project budgets can be revised(+/-) as the project progresses depending on the project requirements.
  • To revise the project budget, Go to the Project budgets form of the project and click on Revise > New Revision.
  • On the Project budget revision form, enter values in revision amount field. This Value can be +ve or -ve. If you want to increase the budget, give a +ve amount and the budget will be increased by that amount and you can see the updated value in New budget field. Provide a -ve value if you want to reduce the budget.
  • Enter the reviosn amounts as below.
  • Now after making necessary revisions, click Submit button to submit the budget for approval.
  • Once the revised budget is approved, the new values will be committed as the project budget.
7. View revision history:
  • A complete history of all the budget revisions can be viewed at Revision > Revisions on the Project budget form.
  • Please see the screen below which depicts that he original budget and the revised amount and the new budget for both cost and revenues.

Comments

Post a Comment

Popular posts from this blog

Table Methods in Ax 2012

Table Methods in Ax 2012 Methods are used for adding X++ code to your application. The code in methods is also referred to as business logic. Whenever records are changed, inserted or deleted from a table various default methods are executed. We can change the default methods and by doing so we are overriding the default methods.To override a method go to the  Methods  node of a table, right click and choose  Override Method . Below are few examples of Overriding commonly used Table methods: initValue(): If we create a new record from the table browser or a form the table method initValue() is executed. It is used to set a default value for the fields.  Example (1): Let’s override intiValue for MyFirstTable and set default value for custGroupId public void initValue() { super(); this.custGroupId = "10"; } After adding this method, open table MyFirstTable  through Table browser and press ctrl+n to create a new record. The field custGroupId wil
Read more

Write/ Read to Excel Sheet

File exists in a Directory:  static void FileExists(Args _args) { str filePath = @”C:\\vani.pdf”; ; if(WinAPI::fileExists(filePath)) { WinAPI::copyFile(filePath,”C:\\1.pdf”); } } Dynamics AX X++ code to Read/Write data to excel Writing Data to Excel file   How it works 1. Use SysExcelApplication class to create excel file. 2. Use SysExcelWorkbooks and SysExcelWorkbook to create a blank workbook(by default 3 worksheets will be available). 3. Use SysExcelWorkSheets to select worksheet for writing data. 4. SysExcelCells to select the cells in the excel for writing the data. 5. SysExcelCell to write the data in the selected cells. 6. Once you done with write operation use SysExcelApplication.visible to open file. static void Write2ExcelFile(Args _args) { InventTable inventTable; SysExcelApplication application; SysExcelWorkbooks workbooks; SysExcelWorkbook workbook; SysExcelWorksheets worksheets; SysExcelWorksheet worksheet; SysExcelC
Read more

Financial Dimensions in AX 2012

Image
Today we will be exploring the new changes  related  to Financial dimensions in AX 2012. Earlier versions AX 2009, 4.0 : Ø   In older version System use to limit the creation of dimensions up to 10.  Ø   By default 3 dimensions were available in the system namely Department, CostCenter and Purpose. Ø   Technically these dimensions were controlled by Enum SysDimension and an array EDT Dimension. Ø   So If we have 3 enum elements in SysDimension, then its corresponding array elements are stored in    dimension EDT and can be referred as Dimension[0], Dimension[1]..... Ø   If you would like to store these dimension values against customized table, then simply we were adding the EDT Dimension to that Table. At  Form  level simply drag and drop field on Group then system use to  show all the array elements as string control. New version AX 2012 (6.0) :   Ø   In AX 2012(6.0), there is no limit to dimension creations. One can create n number of dimensions as per orga
Read more