JobHead.ShippedQty

Is there any easy or straightforward way to get the Shipped Qty for a Job? It’s not a DB field, which would be nice.

thanks

JobProd table has the shipped / received qty’s

JobProd.ShippedQty
JobProd.ReceivedQty

Thanks!

Also quick tip, if you have the Advanced Production Licence.

You can use the JobPart Table which is a child table of JobHead and a Parent to the JobProd table. which would give you a summarised quantity view without having to do all the grouping and summing associated when using the JobProd table.

Name Type Description
PartQty decimal The number of individual parts that are being produced
part. Sum of all related JobProd.ProdQty.
Not Directly maintable.
StockQty decimal Part Qty that is being produced for Stock.
ShippedQty decimal Total Quantity of the end part shipped from this job.
Updated via the ShipDtl write triggers.
ReceivedQty decimal Total quantity received to stock for the end part of the Job.
Updated via the Manufacturing receipts process.
WIPQty decimal Represents the outstanding WIP of production quantity.
A summary of JobProd.WIPQty, updated via JobProd write trigger.
QtyCompleted decimal Part Production quantity completed.
Updated via JobOper write trigger or LaborPart trigger. If JobOper is the Final Operation (see JobAsmbl.FinalOpr) then this is set equal to JobOper.QtyCompleted.
ReservedQty decimal Quantity of the job completed quantity that is Reserved for the linked demands (sales orders/other jobs). Summary of PartAlloc.ReservedQty where PartAlloc.SupplyJobNum = JobHead.JobNum. Reservations for Orders are made via the Order Allocations program. They are excluded from available quantity calculations for the job. Available Quantity = JobHead.QtyCompleted - (Shipped + Received to stk + ReservedAllocQty + PickingQty + PickedQty). Maintained via PartAlloc write trigger.
AllocatedQty900 decimal Total Allocated Quantity for this job part
PickingQty decimal Quantity of the job completed quantity that is considered as in the Picking process for the linked sales orders. Summary of PartAlloc.PickingQty where PartAlloc.SupplyJobNum = JobHead.JobNum. PickingQty is set in the Order Allocation program. Maintained via PartAlloc write trigger.
PickedQty decimal Quantity of the job completed quantity that is considered as in the shipping Staging process for the linked sales orders. Summary of PartAlloc.PickedQty where PartAlloc.SupplyJobNum = JobHead.JobNum. PickedQty is updated when the material move moves the item to the staging area. Maintained via PartAlloc write trigger.

Hope this helps.

1 Like