We have been looking into the Shop Load and Resource ** dashboard. As the report is not in Crystal we are unable to customise it but basically what we want data wise is shown below and I would also do a graph to match:
Part Number W/C1 W/C2
Part A 50Hrs 20 Hrs
Part B 35 Hrs 45 Hrs
I have looked back through some previous posts and as far as I can see there are a couple of suggestions.
1) Use table ShopLoad, ShopCap and ResourceTimeUsed - These tables have the information I want but I can't figure out how to link the ResourceTimeUsed table to the other 2?
2) There are some calculation suggestions but as far as I can work out they give a production balance of hours against a date but this doesn't help if the job goes over 2 weeks?
I would also like to ask if this report has been changed much in Epicor 9? Who knows it may be the final thing that forces us to upgrade ;)
Part Number W/C1 W/C2
Part A 50Hrs 20 Hrs
Part B 35 Hrs 45 Hrs
I have looked back through some previous posts and as far as I can see there are a couple of suggestions.
1) Use table ShopLoad, ShopCap and ResourceTimeUsed - These tables have the information I want but I can't figure out how to link the ResourceTimeUsed table to the other 2?
2) There are some calculation suggestions but as far as I can work out they give a production balance of hours against a date but this doesn't help if the job goes over 2 weeks?
I would also like to ask if this report has been changed much in Epicor 9? Who knows it may be the final thing that forces us to upgrade ;)