Solved

Work Order Cost

  • 19 July 2021
  • 3 replies
  • 245 views

Userlevel 1
Badge +2

hi there, does anyone know how I can get planned cost and actual costs at work or level instead of activity level? thanks

icon

Best answer by AsankaGaru 19 July 2021, 12:21

View original

This topic has been closed for comments

3 replies

Userlevel 6
Badge +11

Hi,

Budget tab will help you.

 

Userlevel 1
Badge +2

Thank you for that :)

I am wanting to export the data into a crystal report.  

In IFS it would usually give me the table name in the system info tab but there is nothing there. do you know if there is a table containing this data that i can extract it from?

 

Many thanks in advance. 

Renee 

Userlevel 6
Badge +11

Hi,

Its fetched using a get method it seems.

Jt_Task_Cost_Line_Util_API.Get_Sum_Actual_Cost(WO_NO, WORK_ORDER_COST_TYPE_DB)

 

WORK_ORDER_COST_TYPE_DB would be … material cost ‘M’, Personal ‘P’, External ‘E’, Expense ‘X’, Fixed Price ‘F’, Tool and equip ‘T’