It has become increasingly important in the company to report actual costs for various Work Order Legs. In the knowledge base, there is an article that claims you can use the Act_burden_cost, Act_Material_Cost etc in the Work order table in order to report costing information for legs (source:
www.inforxtreme.com/.../1355266.asp If the article is accurate, my problem would be easily solved.
In our database, however, work orders that have a sub ID <> 0 have a cost of 0 (costs for all legs are summed and put into the main header). I have got around this "feature" in the past by summing the actual cost fields in the operation table for a given leg. This works great, as long as there aren't legs coming off of other legs. As soon as a leg contains a sub-leg, I do not know of a way to pull the operations in that sub-leg to get its costs totaled for the part.
Does anyone else see all leg work orders have an actual cost of 0? Is there a way to report on total leg cost without having to go through some sort of recursion to find all operation costs in sub legs?
[Updated on 3/26/2013 6:23 PM]
