Skip to main content

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

Hi,

Budget tab will help you.

 


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 


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’