I don't think standard MAPICS calculates the total standard time for an item. We
modified the routing inquiry to calculate the single level time per piece. To
roll up time per piece for an end item would require additional programming.
Mark Kupferberg
____________________Reply Separator____________________
Subject: MAPICS-L Digest, Vol 7, Issue 34
Author: mapics-l-request@xxxxxxxxxxxx
Date: 3/6/2009 12:00 PM
Send MAPICS-L mailing list submissions to
mapics-l@xxxxxxxxxxxx
To subscribe or unsubscribe via the World Wide Web, visit
http://lists.midrange.com/mailman/listinfo/mapics-l
or, via email, send a message with subject or body 'help' to
mapics-l-request@xxxxxxxxxxxx
You can reach the person managing the list at
mapics-l-owner@xxxxxxxxxxxx
When replying, please edit your Subject line so it is more specific
than "Re: Contents of MAPICS-L digest..."
Today's Topics:
1. Re: PCC reporting - run labor hours per machine (Tom E Stieger)
----------------------------------------------------------------------
message: 1
date: Fri, 6 Mar 2009 09:20:41 -0800 (PST)
from: Tom E Stieger <TEStieger@xxxxxxxxxxxx>
subject: Re: [MAPICS-L] PCC reporting - run labor hours per machine
If your averages are updated to the Routing file on MO Close and Purge, there
are fields at the Routing header for Average Run time, Machine time and setup
time.
For PDM - ROUTNG
AVGRM - Machine
AVGRL - Labor
AVGSL - Setup
and EPDM - RTGHDR.
TRMH - Machine
TRLH - Labor
TSDU - Setup
I think these are what you need, but I haven't ever used these.
-Tom Stieger
Engineer
California Fine Wire
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx [mailto:mapics-l-bounces@xxxxxxxxxxxx] On
Behalf Of Ioffe, Jane [BUL/LAK]
Sent: Friday, March 06, 2009 9:11 AM
To: MAPICS ERP System Discussion
Subject: Re: [MAPICS-L] PCC reporting - run labor hours per machine
Still, the question was on the Average hours per item , not work center.
Work center or Production facility could have multiple items. We need to know
Per One item how much we spent on average...
Thank you and Regards,
Jane Ioffe
847-295-4593
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Joe Perrault
Sent: Friday, March 06, 2009 10:29 AM
To: MAPICS ERP System Discussion
Subject: Re: [MAPICS-L] PCC reporting - run labor hours per machine
From the knowledgebase:
This can be caused by any of the following:
1) The last Order Close and Purge in IM may have said NO to Update
routing averages. If that happened, no averages would have changed.
2) The manufacturing order was force closed and the operation in
question was at a status 10, 20, or 30. Only status 40 operations
update averages in the PDM file. If the order had a status of 50 or 55,
the operation would be at a status 40 and would have updated the average
in the ROUTNG file, unless 3) is true.
3) If the operation is at a status 40, but the qty reported complete is
0.0, MAPICS could not convert the actual time back to the unit TBC times
in the routing file, so did not update the averages.
4) Someone has changed the TBC factor in the standard routing in PDM
since the last order close and purge. Changing the TBC factor will zero
the routing averages and set the NOTIM (number of times the averages
have been updated) field to zero.
5) Average run times are updated only when the actual work center for
the operation in the MOROUT file is the same as the standard work center
defined in the ROUTNG file. If a work center override was entered
during shop activity update, averages in the standard routing are not
updated.
Joe Perrault
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Ioffe, Jane
[BUL/LAK]
Sent: Friday, March 06, 2009 10:04 AM
To: MAPICS ERP System Discussion
Subject: Re: [MAPICS-L] PCC reporting - run labor hours per machine
For some reason it's not updated in our ROUTNG. Is there a set up we
should've done?
Thank you and Regards,
Jane Ioffe
847-295-4593
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Joe Perrault
Sent: Friday, March 06, 2009 8:57 AM
To: MAPICS ERP System Discussion
Subject: Re: [MAPICS-L] PCC reporting - run labor hours per machine
There is a running average calculated and stored in the ROUTNG file for
each operation.
Joe Perrault
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Ioffe, Jane
[BUL/LAK]
Sent: Friday, March 06, 2009 8:48 AM
To: mapics-l@xxxxxxxxxxxx
Subject: [MAPICS-L] PCC reporting - run labor hours per machine
Hello All,
I wonder if anybody knows if there is a report available in PCC or PMC
to calculate average hours spent for building any finished good item.
It could be using a range criteria for an item or completion date.
We are at R5.5 , but would think it should be a pretty basic function
of any manufactured shop.
I imagine it could be done separately, in Query or any reporting tool,
using MOHRTG and MOHMST with calculation of total hours spent per
operation divided by total qty completed this period, but still curious
if anybody else needed that in their workshop.
Thank you in advance,
Jane Ioffe
Applications System Analyst
Buehler LTD
41 Waukeegan Rd. Lake Bluff, IL 60044
(847) 295-4593
_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
http://archive.midrange.com/mapics-l.
_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
http://archive.midrange.com/mapics-l.
_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
http://archive.midrange.com/mapics-l.
_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
http://archive.midrange.com/mapics-l.
_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
http://archive.midrange.com/mapics-l.
------------------------------
_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) digest list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
http://archive.midrange.com/mapics-l.
End of MAPICS-L Digest, Vol 7, Issue 34
***************************************
midrange.com
