Track specific expense type in the project workbench

Abdellah TAHRI
Tera Contributor

In the investment funding application , there is two expense types Capex & Opex .

AbdellahTAHRI_5-1726044811928.jpeg

 

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.

AbdellahTAHRI_10-1726044961150.png

 

Create a new Widget. For example: Specific Opex Sum

Make sure Active, Show Label, Formatter required and Scripted is checked.

AbdellahTAHRI_7-1726044811998.png

 

 

To add the widget associations navigate to application menu, go to  sn_app_widget_association.List.

AbdellahTAHRI_8-1726044812012.png

 

 

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.

AbdellahTAHRI_9-1726044812021.png

 

 

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 .

0 REPLIES 0