Field to show remaining qty for job?

Yahoo Archive
1
The third part of my previous post said,

"If you want to show location(s) of job in production by workcenter,
I would...
1 join jobhead->joboper.
2 Sort/group on joboper.oprseq, joboper.WCCode.
3 Add joboper.qtycompleted > 0, joboper.opcomplete = yes to filter.
4 Place the last quantity completed (joboper.qtycompleted) on the
OprSeq group line and subtract from jobhead.prodqty"

Scratch that. You would NOT need to sort/group by joboper.wccode,
just show last WC on OprSeq group. Anyway, it's irrelevant to the
question. More coffee needed this Monday.

Lonnie
2
Does anyone know of a field that shows the remaining quantity for a
job (i.e. Original Production Quantity for a job was 1000, 7000 were
made so 3000 remain)?

Trying to create a report which will have WIP quantities included.

John Wapner
Bracalente Mfg.
3
At 08:06 AM 9/17/2001 , you wrote:
>Does anyone know of a field that shows the remaining quantity for a
>job (i.e. Original Production Quantity for a job was 1000, 7000 were
>made so 3000 remain)?

Look in the JobHead data dictionary. You'll have to use a calculated field
-- I don't recall the exact names, but it's something like ProdQty -
QtyComplete.

-Wayne
4
John,

JobHead contains a QtyCompleted field which is a copy of JobOper last
operation QtyCompleted, so jobhead.ProdQty - Jobhead.Qtycompleted
should yield the unfinished quantity.

If you want to know the difference between the quantity shipped from
the job and the original quantity for the job I would try
jobhead.ProdQty - jobhead.ShippedQty.

If you want to show location(s) of job in production by workcenter, I
would...

1 join jobhead->joboper.
2 Sort/group on joboper.oprseq, joboper.WCCode.
3 Add joboper.qtycompleted > 0, joboper.opcomplete = yes to filter.
4 Place the last quantity completed (joboper.qtycompleted) on the
OprSeq group line and subtract from jobhead.prodqty

The latter is the logic I have traditionally used for WIP related
reports by department or workcenter. Of course, it depends on
whether the operations are marked complete when finished.

Icons for custom reports -- I've created folders in vantage under the
main modules (job management, advanced bill of materials, etc)
called "Custom Reports".

HTH

Lonnie

--- In vantage@y..., jwapner@b... wrote:
> Does anyone know of a field that shows the remaining quantity for a
> job (i.e. Original Production Quantity for a job was 1000, 7000
were
> made so 3000 remain)?
>
> Trying to create a report which will have WIP quantities included.
>
> John Wapner
> Bracalente Mfg.