Solved

Work Order Budget Tab - Planned Cost/Planned Revenue

  • 5 April 2021
  • 2 replies
  • 140 views

Userlevel 4
Badge +7

We are now using the Service Quotation functionality. Upon accepting a Service Quotation this will generate a work order with pre-populate information, including budget costs/revenue.

 

Within the Budget tab of the work order both Planned Cost and Planned Revenue fields are populated with data. 

 

I would like to use these tabs on some quick reports, however when I query the WORK_ORDER_BUDGET_TAB these fields do not appear. Below is the Systems info page whilst on the Budget tab of a work order. The second screenshot is the table itself.

 

Any ideas how to get access to these two fields?

 

 

 

 

icon

Best answer by Janitha Jinarajadasa 5 April 2021, 13:18

View original

This topic has been closed for comments

2 replies

Userlevel 6
Badge +14

Planned cost and planned revenue are taken from following method using work order planning tab

 

 

 

 

Userlevel 6
Badge +14

IFSAPP.Work_Order_Planning_Util_API.Get_Sum_Planned_Cost(WO_NO,
                                                                WORK_ORDER_COST_TYPE)
       IFSAPP.Work_Order_Planning_Util_API.Get_Sum_Planned_Revenue(WO_NO,
                                                                   WORK_ORDER_COST_TYPE)