Welcome, Guest. Please Login.
09/20/24 at 20:17:34
News:
Home Help Search Login


Pages: 1
Send Topic Print
std labor vs avg. labor... (Read 782 times)
ASM
Full Member
***


The Guitarman...

Posts: 142
Gender: male
std labor vs avg. labor...
06/17/05 at 04:59:02
 
Hi,
  What tables would I use to bset create a report of Standard labor hours vs. Average labor hours for an item?
 
Thanks
 
Jim P.
Back to top
 
 
  IP Logged
David Waldmann
Active Member
*****


Live to work, or
work to live?

Posts: 1924
Gender: male
Re: std labor vs avg. labor...
Reply #1 - 06/17/05 at 07:57:51
 
MTICMSTR - MTIC.PROD.RCOST [4] Labor Cost - This level
MTICMSTR - MTIC.PROD.RCOST [10] Rolled up Labor Cost - All Levels
BKICMSTR - BKIC.PROD.AVLAB - Average labor cost
Back to top
 
 

David N Waldmann
President
Vermont Hardwoods
Chester, VT

Evo-ERP, 5 user
IST Build: 3/4/19, patched 04/30/19
Pervasive v11.31
Server 2012 / Win10 x64
Crystal Reports v11
Email WWW   IP Logged
ASM
Full Member
***


The Guitarman...

Posts: 142
Gender: male
Re: std labor vs avg. labor...
Reply #2 - 06/17/05 at 09:52:12
 
...I did that unfortunitly there isn't any data in the AVLABOR or AVMAT.
Back to top
 
 
  IP Logged
cathyh
Active Member
*****


I used to be
indecisive; now I'm
not so sure......

Posts: 1213
Gender: female
Re: std labor vs avg. labor...
Reply #3 - 06/17/05 at 10:34:11
 
I don't know if this is what you are looking for, but we do a report in Access using WOROUT, WORKORD and WORECV to collect the number of hours for estimated(standard) and actual per work order and average them by part number.  The WOROUT has actual and estimated hours per sequence, and the WORKORD file has actual labor and estimated labor totals.
WORECV filters by receipt date. We can do this by sequence or by total.  I think even if you are only interested in labor dollars you would have to use work order files, and average the labor over a given date range (could be all date ranges).
Back to top
 
 

Cathy Hamilton
Wing Inflatables, Inc.
EVO-ERP2008.1(20 users) w/IS Tech update 5/25/09 (as of 08/21/09)
Windows 2008 Server/client
Pervasive V10.1
Email WWW   IP Logged
Pages: 1
Send Topic Print