Duplicating Jobs and Parts listed on WIP Report

Yahoo Archive
1
>I'm 99% accurate.
Have you already seen the AnswerBook #: 3799MPS ?

I have been working on a BAQ.
This is the latest BAQ I've been using:

for each JobHead no-lock where JobHead.JobClosed = false JobHead.JobFirm = True , each PartTran no-lock where PartTran.TranType = 'MFG-CUS' Or PartTran.TranType = 'MFG-STK' and (JobHead.Company = PartTran.Company and JobHead.JobNum = PartTran.JobNum ) , each JobAsmbl no-lock where (JobHead.Company = JobAsmbl.Company and JobHead.JobNum = JobAsmbl.JobNum ) by JobHead.JobNum

It seems close but I have been finding exceptions too.







--- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@...> wrote:
>
> Still working on this.
>
>
>
> I don't need detail and could care less about costs. All I'm trying to do
> is get the jobs and related parts on the WIP report in a query.
>
>
>
> I'm *close* with a few records either not showing up or my query yields a
> couple jobs not on the WIP report. I'm 99% accurate.
>
>
>
> I have this so far:
>
>
>
> SELECT
>
> J.JOBNUM, J.PARTNUM FROM PUB.JOBHEAD J
>
> WHERE J.JOBCOMPLETE = 0
>
> AND J.JOBRELEASED = 1
>
> AND J.WIPCLEARED = 0
>
> AND J.JOBFIRM = 1
>
> ORDER BY J.JOBNUM
>
>
>
> Is there something obvious I'm missing? Another flag somewhere, perhaps?
>
>
>
> I know complete Jobs can show up on the WIP report, but if I drop the
> JobComplete = 0 then I get too many results. Granted, we do have some dirty
> data, but I'm looking for the "magical flag" that says "I am on the WIP
> report)".
>
>
>
> I feel like I'm missing something obvious.
>
>
>
> TIA.
>
>
>
>
>
> Vic
>
>
>
> [Non-text portions of this message have been removed]
>
2
Still working on this.



I don't need detail and could care less about costs. All I'm trying to do
is get the jobs and related parts on the WIP report in a query.



I'm *close* with a few records either not showing up or my query yields a
couple jobs not on the WIP report. I'm 99% accurate.



I have this so far:



SELECT

J.JOBNUM, J.PARTNUM FROM PUB.JOBHEAD J

WHERE J.JOBCOMPLETE = 0

AND J.JOBRELEASED = 1

AND J.WIPCLEARED = 0

AND J.JOBFIRM = 1

ORDER BY J.JOBNUM



Is there something obvious I'm missing? Another flag somewhere, perhaps?



I know complete Jobs can show up on the WIP report, but if I drop the
JobComplete = 0 then I get too many results. Granted, we do have some dirty
data, but I'm looking for the "magical flag" that says "I am on the WIP
report)".



I feel like I'm missing something obvious.



TIA.





Vic



[Non-text portions of this message have been removed]
3
I would substitute your job complete for jobclosed = 0 or combine them both

Mark

--- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@...> wrote:
>
> Still working on this.
>
>
>
> I don't need detail and could care less about costs. All I'm trying to do
> is get the jobs and related parts on the WIP report in a query.
>
>
>
> I'm *close* with a few records either not showing up or my query yields a
> couple jobs not on the WIP report. I'm 99% accurate.
>
>
>
> I have this so far:
>
>
>
> SELECT
>
> J.JOBNUM, J.PARTNUM FROM PUB.JOBHEAD J
>
> WHERE J.JOBCOMPLETE = 0
>
> AND J.JOBRELEASED = 1
>
> AND J.WIPCLEARED = 0
>
> AND J.JOBFIRM = 1
>
> ORDER BY J.JOBNUM
>
>
>
> Is there something obvious I'm missing? Another flag somewhere, perhaps?
>
>
>
> I know complete Jobs can show up on the WIP report, but if I drop the
> JobComplete = 0 then I get too many results. Granted, we do have some dirty
> data, but I'm looking for the "magical flag" that says "I am on the WIP
> report)".
>
>
>
> I feel like I'm missing something obvious.
>
>
>
> TIA.
>
>
>
>
>
> Vic
>
>
>
> [Non-text portions of this message have been removed]
>