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