How do I use the WIP Transaction Inquiry report?

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 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

• SKU

• Transaction Type (e.g., Pick Material, Create Outsource PO, Adjust Finish Product, etc.)

• Quantity and Cost

• Process details

• Timestamps and user logs (who performed each step and when)

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 right clicking anywhere in the grid and selecting Copy to Excel. Then you can paste the data into your spreadsheet platform of choice.

Related Guides

• How do I create and manage a Work in Progress (WIP) job?

• What actions can I take from the WIP screen?

• How do I record the final goods yield?

• How do I handle outsourced production steps?

• How do I start and finish in-house processes?