Track specific expense type in the project workbench
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-11-2024 01:57 AM
In the investment funding application , there is two expense types Capex & Opex .
Some organizations have specific expense types , that cannot be considered as 100% Capex or Opex .
Let me share an example that I already had for a customer :
the amount related to the rent of an equipment is considered as a specific expense type (let’s call it Specific_OPEX) for the first 12 months , and opex after that .
The financial department will need to track this specific expense type in the financial summary of the project workbench .
We have consistently advised the customer against creating additional expense types, as it could have repercussions on various aspects of SPM, including but not limited to roll-ups to Demand, Project, Program, Budget, Portfolio Workspace, Project Workspace, and Investment Funding .
Bear in mind that SPM is not designed to manage capitalization process, but it can provide information as input to capitalization process managed in a financial tool.
The best solution that we identified and validated with the customer is to add a widget to track this specific expense .
In the following the steps to do in order to create this widget .
Navigate to Application menu, Project Administration -> Investment Portal Widget.
Create a new Widget. For example: Specific Opex Sum
Make sure Active, Show Label, Formatter required and Scripted is checked.
To add the widget associations navigate to application menu, go to sn_app_widget_association.List.
Filter with Association Table as “pm_console”, open any one of the record and change the widget to current widget in our case “Specific Opex Sum” and do insert and stay so that the association is added.
Now that the association is added to the page, we can see the widget name in our Widget Configuration, enable the widget(Specific Opex Sum) added. So that it is displayed.
You can script now all the specific calculations for the specific expense type .