Query Help Please

Yahoo Archive
1
The parttran table also has the job, assembly sequence, jobseq and
jobseqtype = S for subcontract.





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
ttfitman
Sent: Wednesday, February 27, 2013 10:20 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Query Help Please





I'm starting to bang my head against the wall, can someone point me in the
right direction please. Tables, criteria,?

I'm trying to pull all subcontract jobs that show PUR-INS in parttran but
not MFG-STK

Any help would greatly appreciated!

Jason





[Non-text portions of this message have been removed]
2
I'm starting to bang my head against the wall, can someone point me in the right direction please. Tables, criteria,?

I'm trying to pull all subcontract jobs that show PUR-INS in parttran but not MFG-STK

Any help would greatly appreciated!

Jason
3
criteria on the parttran table where parttrantype = pur-sub AND = pur-ins



________________________________
From: ttfitman <jwebby.sync@...>
To: vantage@yahoogroups.com
Sent: Wednesday, February 27, 2013 12:20 PM
Subject: [Vantage] Query Help Please

Â
I'm starting to bang my head against the wall, can someone point me in the right direction please. Tables, criteria,?

I'm trying to pull all subcontract jobs that show PUR-INS in parttran but not MFG-STK

Any help would greatly appreciated!

Jason




[Non-text portions of this message have been removed]
4
You will need Part and PartTran tables.

Michael Brown
Master Scheduler / Programmer
D&S Manufacturing
715-284-5376 Ext. 344

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of ttfitman
Sent: Wednesday, February 27, 2013 11:20 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Query Help Please



I'm starting to bang my head against the wall, can someone point me in the right direction please. Tables, criteria,?

I'm trying to pull all subcontract jobs that show PUR-INS in parttran but not MFG-STK

Any help would greatly appreciated!

Jason



[Non-text portions of this message have been removed]
5
Let me explain what I need in the end and what is happening.

When the part comes in from subcontract it gets received(pur-ins) then goes through inspection(ins-sub) then is supposed to get received into stores (mfg-stk)


When the part is bought off by inspection and waiting to be received into inventory it goes into invisible limbo land.

I need to see all the records that are in this area, bought off by inspection but not received into inventory.

--- In vantage@yahoogroups.com, Mike Brown <mbrown@...> wrote:
>
> You will need Part and PartTran tables.
>
> Michael Brown
> Master Scheduler / Programmer
> D&S Manufacturing
> 715-284-5376 Ext. 344
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of ttfitman
> Sent: Wednesday, February 27, 2013 11:20 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Query Help Please
>
>
>
> I'm starting to bang my head against the wall, can someone point me in the right direction please. Tables, criteria,?
>
> I'm trying to pull all subcontract jobs that show PUR-INS in parttran but not MFG-STK
>
> Any help would greatly appreciated!
>
> Jason
>
>
>
> [Non-text portions of this message have been removed]
>