Content Comparison

What is the Budget Object

...

Quick info: The financial module includes three objects for budgeting purposes which is the Budget Object, Invoice Object & the Change Register Object.

1. Budget Tab

View of the Budget Tab

...

Activating the Budget object in your Project

...

The original budget value will also change to 100,000.000 and will roll up to the budget type respectively.

Need image

...

Values in “Red” would show you that there is a Change sent to Increase the budget figure on the respective Budget. for an example.

Original Budget Value on the grid is 101,000.000

Change to Increase on the Budget value is 1000.000 this change is shown in the Grid in Red once approved from the change register.

The original budget value will also change to 100,000.000 and will roll up to the budget type respectively.

Need imageImage Added

...

3. Save - Clicking on the save button will allow you to save changes made to any Budget Types and lines within the Budget Grid.

4. Upload - This allows you to upload data through a data upload wizard. you can refer below for more details on the Data Upload wizard.

5. Export - This allows you to Export budget data within the grid into an excel document.

6. Filter - Thid button will be enabled to you when the “Reporting Year” functionality is activated within your table view. You can filter budget data for selected 'Reporting Years' and respective 'Budget Types/Lines.' Once the filter is applied, the filter button will change color and indicate that the data is already filtered.

...

You can click on the 'Duplicate' button to duplicate the budget type. You will only be allowed to duplicate the budget hierarchy within the project timeframe, and it will only duplicate the rows without carrying forward any data.

...

Duplicating a Budget line

You can simply click the 'Duplicate' button which is placed on the Budget Type to duplicate a budget line. You will only be allowed to duplicate the budget hierarchy within the project timeframe, and it will duplicate the rows without carrying forward any data.

...

Deleting a Reporting Year / Budget Type / Budget Line

You can simply delete a reporting year / budget type / budget line by clicking the 'Delete' button. Reporting years Budget data cannot be deleted if there are purchase orders linked to the reporting year budgets OR if there are change requests linked to the budgets. All links to purchase orders must be removed before deleting a reporting year / budget type / budget line, as you will be prompted with an error message.

...

1. File Upload Phase -

   1. You have to download the template by clicking on the Download Template button to upload data. Date Fields and the fields which have formulars configured from budget object configuration area will not be included within the downloaded template.

   2. After downloading the template, you have to enter data into that downloaded template correctly and then you can upload that excel document via Upload File side (Right side of the File Upload Phase)
      Quick Tip: If you have entered data in incorrect format, a warning message will appear in red color.

      

2. Select Worksheet Phase

   1. Once you upload the downloaded template, “Next” button gets enabled. So, you can navigate to the “Select Worksheet”.

   2. You have to select the correct sheet which is in the uploaded excel document. Once you select the worksheet, “Next” button in the bottom right corner gets enabled.

      

3. Budget Tab Phase

   1. You will be able to see the titles of the budget object and phase which you are going to upload budget data.

      

4. Data Mapping Phase

   1. Data will be automatically mapped by considering the column names within budget object and the column headers in the uploaded excel document.

   2. But you can change the mapping fields under “Map to Excel Column” by clicking on the relevant column header name.
      Quick Tip: You cannot map same table column to two different excel columns.

      

      

5. Finish Phase

   1. Once data is successfully mapped, you can navigate to Finish Phase by clicking on the “Next” button.

   2. In the finish phase, you will be able to see the grid same as the budget grid after uploading the data.

   3. If there are any data errors within the uploaded excel document, those errors will appear in the bottom of the finish phase.
      Quick Tip: Incorrect data will not be uploaded to the budget grid.

      

      

...

Once user update a value in budget line level, the rollup should be performed. Also, if that field is used in a formula, that formula added field also should be updated accordingly. Delete Budget Data

Delete button is placed in the right-side corner against each budget hierarchy level including reporting year rows.

Users can delete reporting years, budget types and budget lines using this delete button only if there are no linkages with purchase orders raised in Invoice Object. Addition to that, if there are change requests raised under a budget line, users will not be able to delete that particular budget line from the budget object.

Duplicate Budget Data

Now the budget object has the feature which allows users to duplicate budget details from one reporting year to another reporting year.

...

Change Request Process is same as the Change Register Object. Once you make changes vis Change Request Process and then if that raised change request get approved, budget values should be updated within the Budget Object.

...

x

2. Cashflow

This tab allows you to add the cumulative values in reporting year wise.