8.03 table for part wip qty

Yahoo Archive
1
Try partwip

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Adam Riffer
Sent: Tuesday, January 08, 2013 2:42 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] 8.03 table for part wip qty



Ed-

Thanks. But I was looking for the job part # and qty of jobs in process
not the materials, but this will be helpful for finding the shortages. Is
there a table that gives you the part #, job # and qty?

Thanks,

Adam Riffer

Purchasing

IQuum, Inc.

508-970-0099x506

********************************************************************

This message, including any attachments, is intended only for the designated
recipient(s). It contains CONFIDENTIAL and/or PROPRIETARY information and
may be subject to attorney-client privilege or other confidentiality
protections. If you are not a designated recipient, you may not review,
use, copy or distribute this message. If you received this in error, please
notify the sender by reply e-mail and delete this message. Thank you.

_____

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of
Ed Garbowski
Sent: Tuesday, January 08, 2013 2:37 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] 8.03 table for part wip qty

If you are looking for issued material in WIP, check the JobMtl table where
JobComplete = 0.

Thanks,
Ed
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> ] On
Behalf Of ariffer
Sent: Tuesday, January 08, 2013 1:31 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] 8.03 table for part wip qty

I am trying to do some reporting for management and looking for a table
where I can find the qty in WIP for a given part thru ODBC. The table I
expected to have it was a temp table and empty.

thanks in advance.

-Adam

________________________________

The information contained in this message is intended solely for the
individual to whom it is specifically and originally addressed. This message
and its contents may contain confidential or privileged information. If you
are not the intended recipient, you are hereby notified that any disclosure
or distribution, or taking any action in reliance on the contents of this
information, is strictly prohibited.
We have taken precautions to minimize the risk of transmitting software
viruses, but we advise you to carry out your own virus checks on any
attachment to this message. We cannot accept liability for any loss or
damage caused by software viruses.

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

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



[Non-text portions of this message have been removed]
2
I am trying to do some reporting for management and looking for a table where I can find the qty in WIP for a given part thru ODBC. The table I expected to have it was a temp table and empty.

thanks in advance.

-Adam
3
If you are looking for issued material in WIP, check the JobMtl table where JobComplete = 0.

Thanks,
Ed
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of ariffer
Sent: Tuesday, January 08, 2013 1:31 PM
To: vantage@yahoogroups.com
Subject: [Vantage] 8.03 table for part wip qty



I am trying to do some reporting for management and looking for a table where I can find the qty in WIP for a given part thru ODBC. The table I expected to have it was a temp table and empty.

thanks in advance.

-Adam


________________________________

The information contained in this message is intended solely for the individual to whom it is specifically and originally addressed. This message and its contents may contain confidential or privileged information. If you are not the intended recipient, you are hereby notified that any disclosure or distribution, or taking any action in reliance on the contents of this information, is strictly prohibited.
We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses.


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



Thanks. But I was looking for the job part # and qty of jobs in process
not the materials, but this will be helpful for finding the shortages. Is
there a table that gives you the part #, job # and qty?



Thanks,



Adam Riffer

Purchasing

IQuum, Inc.

508-970-0099x506

********************************************************************

This message, including any attachments, is intended only for the designated
recipient(s). It contains CONFIDENTIAL and/or PROPRIETARY information and
may be subject to attorney-client privilege or other confidentiality
protections. If you are not a designated recipient, you may not review,
use, copy or distribute this message. If you received this in error, please
notify the sender by reply e-mail and delete this message. Thank you.

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Ed Garbowski
Sent: Tuesday, January 08, 2013 2:37 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] 8.03 table for part wip qty





If you are looking for issued material in WIP, check the JobMtl table where
JobComplete = 0.

Thanks,
Ed
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of ariffer
Sent: Tuesday, January 08, 2013 1:31 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] 8.03 table for part wip qty

I am trying to do some reporting for management and looking for a table
where I can find the qty in WIP for a given part thru ODBC. The table I
expected to have it was a temp table and empty.

thanks in advance.

-Adam

________________________________

The information contained in this message is intended solely for the
individual to whom it is specifically and originally addressed. This message
and its contents may contain confidential or privileged information. If you
are not the intended recipient, you are hereby notified that any disclosure
or distribution, or taking any action in reliance on the contents of this
information, is strictly prohibited.
We have taken precautions to minimize the risk of transmitting software
viruses, but we advise you to carry out your own virus checks on any
attachment to this message. We cannot accept liability for any loss or
damage caused by software viruses.

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





[Non-text portions of this message have been removed]
5
I like to use the PartDtl Table - SourceFile = 'JH'.



That way I don't have to mess with the JobProd table.







From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Adam Riffer
Sent: Tuesday, January 08, 2013 1:42 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] 8.03 table for part wip qty





Ed-

Thanks. But I was looking for the job part # and qty of jobs in process
not the materials, but this will be helpful for finding the shortages. Is
there a table that gives you the part #, job # and qty?

Thanks,

Adam Riffer

Purchasing

IQuum, Inc.

508-970-0099x506

********************************************************************

This message, including any attachments, is intended only for the designated
recipient(s). It contains CONFIDENTIAL and/or PROPRIETARY information and
may be subject to attorney-client privilege or other confidentiality
protections. If you are not a designated recipient, you may not review,
use, copy or distribute this message. If you received this in error, please
notify the sender by reply e-mail and delete this message. Thank you.

_____

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Ed Garbowski
Sent: Tuesday, January 08, 2013 2:37 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] 8.03 table for part wip qty

If you are looking for issued material in WIP, check the JobMtl table where
JobComplete = 0.

Thanks,
Ed
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of ariffer
Sent: Tuesday, January 08, 2013 1:31 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] 8.03 table for part wip qty

I am trying to do some reporting for management and looking for a table
where I can find the qty in WIP for a given part thru ODBC. The table I
expected to have it was a temp table and empty.

thanks in advance.

-Adam

________________________________

The information contained in this message is intended solely for the
individual to whom it is specifically and originally addressed. This message
and its contents may contain confidential or privileged information. If you
are not the intended recipient, you are hereby notified that any disclosure
or distribution, or taking any action in reliance on the contents of this
information, is strictly prohibited.
We have taken precautions to minimize the risk of transmitting software
viruses, but we advise you to carry out your own virus checks on any
attachment to this message. We cannot accept liability for any loss or
damage caused by software viruses.

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

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





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