How do I use the WIP Transaction Inquiry report?

Reviewing manufacturing history and production records.

The WIP Transaction Inquiry report lets you search and review the full activity history for any WIP (Work in Progress) job, including BOM usage, material movements, and process details.

Where to Find the Report

In ERP, go to Manufacturing > WIP Transaction Inquiry

Filter Your Search

Use the filter fields at the top of the screen to narrow down results:

WIP No. – Search by a specific Work in Progress job number
BOM No. – Search for transactions related to a particular Bill of Materials
Start Date / End Date – Define the time range for the transaction search
Other Filters – Add SKU, factory, or other dimensions to refine the results

Once your filters are set, click Apply to run the report.

Review the Results

Each result row will show:

WIP Number and BOM Code
SKU and Description
Transaction Type (e.g., Material Pick, Outsource PO, Yield)
Quantity and Cost
Warehouse and Process details
Timestamps and user logs (who performed each step)

Use this report to trace issues, review past jobs, or reconcile production inventory.

Exporting the Data

You can export the report for offline review or audit by clicking the Export button.
Choose Excel or CSV format depending on your needs.

Tip:
This report is especially helpful when troubleshooting mismatches between planned and actual yields, or when verifying outsourced process costs.