Click the Save action to create or add these new column details to the view. Click the quick Edit icon on the individual lines to change an existing column to suit your organization.
| Tips and Tricks
- The outline structure, or columns defined for each report structure is predetermined. That is, for each Financial view activated in Miscellaneous table 388 - Financial view, the report structure must mirror the report structure defined with master Financial views '10' (expenses) and '20' (revenue). For example, the first column is the type of structure, the second column the project budget and the ninth column, the budget remaining.
- By default, all predefined columns – Budgets, Remaining for commitment, Provisional cost price, Margins – are calculated when you run the Financial overview (when you select the Financial overview action in the Project management (GESPJM) function). You can only, therefore, choose not to display these columns.
- You can only customize (or hide) the content of a column identified as a 'Free column', that is where the field Column content (field CODDES) is set to 'Free column 1-10'.
Free columns equate to columns 3-7, column 13 and columns 16-19.
- Five free columns (Free columns 1-5) are specifically for managing costs (expenses) – committed, pre-committed, actual and posted amounts. The sum of these 5 free columns is used to calculate the total cost of a project.
- By default, one expense column tracks 'commitments' and one expense column tracks 'actuals'.
You might consider using two free columns (from Free columns 1-5), for example, to differentiate between 'pre-commitments' and 'commitments' or 'posted expenses' and 'actuals'.
Each free column is subdivided into two subcolumns. You define the type of data represented in each subcolumn as a quantity figure or an amount.
- You can use five additional 'miscellaneous' type columns (Free columns 6-10) to add extra information to a Financial overview, if needed.
By default, Free columns 6-10 are only used in view '20' to track revenue. They are hidden in view '10'.
'Free column 6' provides the facility to compare the 'budget' and the 'provisional cost price'. The result of these calculations populates columns 'Compare Col.6 to budget' and 'Compare Col.6 to Total' respectively.
Master Financial view 20 – this Financial view provides an example of the use of free columns in a revenue tracking context.
- As the content of a 'Free column' (Free column 1-10) is customizable you must use the Financial overview queries (PJMBUDTRQ) function to apply the relevant calculations. The content of each predefined column – Budgets, Remaining for commitment, Provisional cost price, Margins – is generated automatically when you run the Financial overview.
- Save a copy of a master report structure before you modify it.
Error messages
In addition to the generic error messages, the following messages can appear during the entry :
Miscellaneous table [table number] : Code [Financial view] does not exist
This function is used in conjunction with Miscellaneous table 388 - Financial view. You have entered a financial view code which has not been enabled for data tracking in table 388. Select a valid financial view code or add the code you require to Miscellaneous table 388 first.