Where is Stock in Inspection stored? 905.700C

 

Thank you very much Greg, 

 

I looked everywhere else!

 

- Neil

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, 26 February 2015 12:44 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Where is Stock in Inspection stored? 905.700C

 

 

Incoming inspection is in RcvDtl. Also receipts that are not marked complete are here. I think in timephase you will see them marked as incoming.

 

I use the query below to show material in-house, but not in-stock.

 

select * from       RcvDtl

WHERE     (RcvDtl.InspectionPending = 1 AND Received=1) OR (InspectionPending = 0 AND  Received = 0)

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, February 25, 2015 4:34 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Where is Stock in Inspection stored? 905.700C

 

 

 

Can anyone tell me if the quantitiy in Inspection for a part is stored somewhere or does it ihave to be calculated from PartTran?

 

PO receipts to inspection are shown in TimePhase. I would like to be able to read this from a table if possible rather than calculate it.

 

Thanks for any clues,

 

 - Neil

 


CONFIDENTIALITY NOTICE

The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.

"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."


Notice:This e-mail and any attachments are confidential and are only for the use of the person to whom they are addressed. If you are not the intended recipient please advise the sender by return e-mail and delete the message and any attachments. Any use, interference with, disclosure or copying of this message or any attachments is unauthorised and prohibited. The sender does not warrant that the information is free of a virus or any other defect or error, and any views expressed herein, unless specifically indicated otherwise, are those of the individual sender.

The DH Gibson Group of Companies - http://www.gibsonshopfitters.com.au

P Please consider our shared environment before printing this communication.


 

Can anyone tell me if the quantitiy in Inspection for a part is stored somewhere or does it ihave to be calculated from PartTran?

 

PO receipts to inspection are shown in TimePhase. I would like to be able to read this from a table if possible rather than calculate it.

 

Thanks for any clues,

 

 - Neil

Look to the nonconf table I believe

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-3119
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]
Sent: Wednesday, February 25, 2015 3:34 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Where is Stock in Inspection stored? 905.700C





Can anyone tell me if the quantitiy in Inspection for a part is stored somewhere or does it ihave to be calculated from PartTran?



PO receipts to inspection are shown in TimePhase. I would like to be able to read this from a table if possible rather than calculate it.



Thanks for any clues,



- Neil



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

Incoming inspection is in RcvDtl. Also receipts that are not marked complete are here. I think in timephase you will see them marked as incoming.

 

I use the query below to show material in-house, but not in-stock.

 

select * from       RcvDtl

WHERE     (RcvDtl.InspectionPending = 1 AND Received=1) OR (InspectionPending = 0 AND  Received = 0)

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, February 25, 2015 4:34 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Where is Stock in Inspection stored? 905.700C

 

 

 

Can anyone tell me if the quantitiy in Inspection for a part is stored somewhere or does it ihave to be calculated from PartTran?

 

PO receipts to inspection are shown in TimePhase. I would like to be able to read this from a table if possible rather than calculate it.

 

Thanks for any clues,

 

 - Neil



CONFIDENTIALITY NOTICE

The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.

"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."