hi there, does anyone know how I can get planned cost and actual costs at work or level instead of activity level? thanks
Best answer by AsankaGaru
View originalhi there, does anyone know how I can get planned cost and actual costs at work or level instead of activity level? thanks
Best answer by AsankaGaru
View originalHi,
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’
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.