sselman
Well Known Member
I am curious as to how other companies look at the rolled up actual cost of a manufactured item. We are building some custom reporting, but it is really complex and didnt know if there was a better way.
The main issue is how JDE rolls up the cost of a sub item and it appears as a material cost when issued into a parent work order (not the labor, overhead, etc buckets).
So when I try to look at the total labor or overhead it took to produce my end item, the labor found on the sub levels is masked in material costs.
In the end, I need a report that says to produce finished good x, taking into account all of the sub orders used to create it, we consumed this amount of material cost, labor cost, and overhead cost throughout then entire process. Not just at a single work order level.
It is frustrating that the standard cost roll-up has the buckets but i cannot get the same level of detail when looking at the actual work orders.
Has anyone else solved this issue or do i just have some setup wrong causing this problem?
The main issue is how JDE rolls up the cost of a sub item and it appears as a material cost when issued into a parent work order (not the labor, overhead, etc buckets).
So when I try to look at the total labor or overhead it took to produce my end item, the labor found on the sub levels is masked in material costs.
In the end, I need a report that says to produce finished good x, taking into account all of the sub orders used to create it, we consumed this amount of material cost, labor cost, and overhead cost throughout then entire process. Not just at a single work order level.
It is frustrating that the standard cost roll-up has the buckets but i cannot get the same level of detail when looking at the actual work orders.
Has anyone else solved this issue or do i just have some setup wrong causing this problem?