Look at using the "JobOper" table - has due date for each operation in
each job - do a calculation for: quantity remaining = prod qty - qty
complete, then for hours = qty remain * production standard. Reports
hours remaining for each operation/work center by date for open jobs.
Norm Watkins
Engineering Manager
SCHOTT ELECPAC, LLC
740 Industrial Drive
Cary, IL 60013
Phone: 847.639.2307
Fax: 847.639.3830
For ITAR/EAR sensitive communications please e-mail me at:
norm.watkins@...
This message contains confidential and privileged information and is
intended only for the individuals to whom it is addressed. It should not
be reviewed, retransmitted, disseminated or otherwise used by persons or
entities other than the intended recipient. If you received this message
in error, please contact the sender and delete the material from your
computer system(s). Thank you.
"rezn0rix" <reznuh@...>
Sent by: vantage@yahoogroups.com
08/27/2009 01:36 PM
Please respond to
vantage@yahoogroups.com
To
vantage@yahoogroups.com
cc
Subject
[Vantage] Vantage 6.1: Shop Load Report to Crystal
Hello,
Anyone have any luck creating a Crystal Report for V6.1's Shop Load as a
replacement? My boss wants to get the Shop Load report into that format to
then edit it a bit concerning machines and jobs. Not having that much luck
messing with the ShopLoad table.
Thanks!,
Z
each job - do a calculation for: quantity remaining = prod qty - qty
complete, then for hours = qty remain * production standard. Reports
hours remaining for each operation/work center by date for open jobs.
Norm Watkins
Engineering Manager
SCHOTT ELECPAC, LLC
740 Industrial Drive
Cary, IL 60013
Phone: 847.639.2307
Fax: 847.639.3830
For ITAR/EAR sensitive communications please e-mail me at:
norm.watkins@...
This message contains confidential and privileged information and is
intended only for the individuals to whom it is addressed. It should not
be reviewed, retransmitted, disseminated or otherwise used by persons or
entities other than the intended recipient. If you received this message
in error, please contact the sender and delete the material from your
computer system(s). Thank you.
"rezn0rix" <reznuh@...>
Sent by: vantage@yahoogroups.com
08/27/2009 01:36 PM
Please respond to
vantage@yahoogroups.com
To
vantage@yahoogroups.com
cc
Subject
[Vantage] Vantage 6.1: Shop Load Report to Crystal
Hello,
Anyone have any luck creating a Crystal Report for V6.1's Shop Load as a
replacement? My boss wants to get the Shop Load report into that format to
then edit it a bit concerning machines and jobs. Not having that much luck
messing with the ShopLoad table.
Thanks!,
Z