Shop load hours

Yahoo Archive
1
Try the 5080 Build Shop Load File in Database Conversions. Then see if the
shop load is fixed.

Patrick Winter


-----Original Message-----
From: tim.goertz@... [mailto:tim.goertz@...]
Sent: Wednesday, August 20, 2003 10:50 AM
To: vantage@yahoogroups.com
Subject: [Vantage] shop load hours


Has anyone seen a problem with inaccurate (overstated) shop load hours
appearing on the shop load report? We have several work centers that show
way too many hours on the load report for certain work centers, jobs and
operations. When we look at the ones in question in job tracker, the load
looks to be correct and is different than what appears on the shop load.
I've created a report builder from the joboper (which job tracker uses) and
the jobopmac table (which the shop load report uses) that looks to be
accurately reflecting the difference between the 2 and we have close to 50
jobs that appear to out of sync. We can correct the problem by going into
job entry and re-scheduling each of these but I'd like to figure out how and
why it's happening. I reported this to Epicor last Feb. and at that time
(and early version of 5.2) they had found some problem and included in a fix
in a patch but that has obviously still not fixed the problem. We're on
version 5.20.320. Here is my email from last Feb. on the same problem. Are
we the only ones seeing this? Thanks.

Tim Goertz

Message: 3
Date: Tue, 11 Feb 2003 16:10:04 -0600
From: tim.goertz@...
Subject: inaccurate load showing on shop load report

Has anyone else seen too many hours appearing on the shop load report? The
scheduler just showed me another example of this problem of the shop load
report showing some real bogus information. We have an assembly work center
that showed over 1500 hours past due on the shop load. There were a few jobs
in the detail that showed over 100 hours remaining in the past due bucket
for this work center and she new those jobs were almost done (qty. complete
was like 10 under the planned run qty.) so she individually rescheduled
those jobs and they went down to under 5 hours remaining on shop load. She
did a few others and the load went down to under 1000 hours for that work
center. I've been trying to figure out how this could happen with Epicor for
the last few weeks but have yet to get an answer from them. They had me run
several of the database utilities to try and correct the load hours but it
did not do anything. The only thing that seems to fix them is individually
scheduling the jobs one by one in job entry (we do backward infinite so we
don't want to use the global finite program). The problem is I don't know
which ones are correct and which are not so we don't know which ones we need
to re-schedule (which we really do not want to take the time to do manually
anyway) and also really would like to know how this is happening in the
first place since we are relying on this load information for schedule our
shop.









[Non-text portions of this message have been removed]


------------------------ Yahoo! Groups Sponsor ---------------------~--> Buy
Ink Cartridges or Refill Kits for Your HP, Epson, Canon or Lexmark Printer
at Myinks.com. Free s/h on orders $50 or more to the US & Canada.
http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/l.m7sD/LIdGAA/qnsNAA/PhFolB/TM
---------------------------------------------------------------------~->

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
2
Has anyone seen a problem with inaccurate (overstated) shop load hours
appearing on the shop load report? We have several work centers that show
way too many hours on the load report for certain work centers, jobs and
operations. When we look at the ones in question in job tracker, the load
looks to be correct and is different than what appears on the shop load.
I've created a report builder from the joboper (which job tracker uses) and
the jobopmac table (which the shop load report uses) that looks to be
accurately reflecting the difference between the 2 and we have close to 50
jobs that appear to out of sync. We can correct the problem by going into
job entry and re-scheduling each of these but I'd like to figure out how and
why it's happening. I reported this to Epicor last Feb. and at that time
(and early version of 5.2) they had found some problem and included in a fix
in a patch but that has obviously still not fixed the problem. We're on
version 5.20.320. Here is my email from last Feb. on the same problem. Are
we the only ones seeing this? Thanks.

Tim Goertz

Message: 3
Date: Tue, 11 Feb 2003 16:10:04 -0600
From: tim.goertz@...
Subject: inaccurate load showing on shop load report

Has anyone else seen too many hours appearing on the shop load report? The
scheduler just showed me another example of this problem of the shop load
report showing some real bogus information. We have an assembly work center
that showed over 1500 hours past due on the shop load. There were a few jobs
in the detail that showed over 100 hours remaining in the past due bucket
for this work center and she new those jobs were almost done (qty. complete
was like 10 under the planned run qty.) so she individually rescheduled
those jobs and they went down to under 5 hours remaining on shop load. She
did a few others and the load went down to under 1000 hours for that work
center. I've been trying to figure out how this could happen with Epicor for
the last few weeks but have yet to get an answer from them. They had me run
several of the database utilities to try and correct the load hours but it
did not do anything. The only thing that seems to fix them is individually
scheduling the jobs one by one in job entry (we do backward infinite so we
don't want to use the global finite program). The problem is I don't know
which ones are correct and which are not so we don't know which ones we need
to re-schedule (which we really do not want to take the time to do manually
anyway) and also really would like to know how this is happening in the
first place since we are relying on this load information for schedule our
shop.









[Non-text portions of this message have been removed]