hi there, does anyone know how I can get planned cost and actual costs at work or level instead of activity level? thanks
This topic has been closed for replies.
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’
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.