Finished Good Lot Trace shows how a manufactured finished-good lot was produced and where it went after shipment.
What this report is for
Use Finished Good Lot Trace to trace a manufactured lot from work order completion to customer shipments, sales orders, and invoices.
This report is read-only. It does not change inventory, shipments, invoices, or work orders.
Screen path
Dashboard > Manufacturing > Reports > Finished Good Lot Trace
Report inputs
| Input | Notes |
|---|---|
Part Number |
Select a manufactured part that has at least one inventory lot. |
Lot |
Select a lot for the chosen part. Disabled until a part is selected. |
Run Trace |
Runs the trace after both part and lot are selected. |
The part selector is limited to traceable manufactured parts with lot values in inventory records.
Results
Lot information
The lot info bar shows:
- Part
- Lot
- Expiration, or
N/A - Quantity on hand
Production History
The Production History section shows work order completion records for the selected lot.
| Column | What it shows |
|---|---|
WO Number |
Work order that completed the lot. |
Status |
Current work order status. |
Qty Completed |
Quantity completed into the lot. |
Completion Date |
Completion timestamp. |
Cost Transferred |
Completion cost transferred for that lot quantity. |
Orders & Invoices
The Orders & Invoices section shows downstream shipment and invoice activity for the selected inventory lot.
| Column | What it shows |
|---|---|
Order Number |
Sales order number. |
Customer |
Customer name and code. |
Customer PO |
Customer PO from the sales order. |
Qty Shipped |
Quantity shipped from the lot. |
Ship Date |
Shipment date. |
Tracking |
Shipment tracking number when present. |
Invoice |
Invoice ID when an invoice line exists. |
Invoice Status |
Invoice status when present. |
Line Amount |
Invoice line amount when present. |
What happens behind the scenes
PAX first loads manufactured parts that have lot records. After a part is selected, it loads lots for that part.
When Run Trace is selected, PAX finds the inventory lot record, work order completion lots for the part and lot, and shipment lines tied to that inventory lot. It joins shipments to sales orders, customers, invoice lines, and invoices.
The report relies on finished goods being completed with correct lot numbers and shipped through normal lot-aware shipment workflows.
Troubleshooting
The part is not available
Likely cause: The part is not marked as manufactured in inventory, or it has no inventory records with a lot value.
Safe fix: Confirm the part source and finished-good lot records.
Contact support if: The manufactured part has lots but does not appear.
The lot is not available
Likely cause: The selected part has no matching lot value in inventory records.
Safe fix: Confirm the lot number on the work order completion or inventory lot record.
Contact support if: The lot exists but the selector does not show it.
No orders are shown
Likely cause: The lot has not been shipped, or shipment lines are not tied to that inventory lot.
Safe fix: Review shipments for the finished-good lot.
Contact support if: The lot shipped but the report does not show the shipment.