Work in process report

Article • 4/27/2026 • 3 min read

Use the Work in Process report to generate the report that reflects the current value of charges that have been accumulated per Job Order, but that have not yet been moved to the Cost Of Goods Sold.

The RPWIP report is based on transactions and is used to reconcile and substantiate the WIP reported by your balance sheet WIP account(s).

By default, generic filters are available to generate this report. You can use Advanced Filters to customize or expand your filter criteria. For more information on Advanced Filters, click here.

To generate Work in Process Report

  1. Open the Work in Process Report (RPWIP) page.

    a. Select Financial Management > Financial Reports > Order Costing > Work in Process Report.

    Or

    b. Search for RPWIPin the Navigation box and then select Work in Process Report.

    The Work in Process Report (RPWIP) page appears.

  2. In the Selection list, select the information you want to view.

  3. In the Sort Order list, select how to sort the report.

    The Sort On field is populated based on the order selected in the Sort Order field.

  4. In the Layout list, select the layout in which you want to view the report.

    The Layout field is populated based on the type of report selected in the Selection field.

  5. Select the Summary check box to obtain a high-level data report.

  6. In the Sort Range area, you can sort the information.

    The Sort On field is populated based on the type of report selected in the Selection field.

The available sort ranges are:

Single- : Select this option to include only one item. Selecting this option enables the From field. Do one of the following:

a. Type the item reference in the **From** field.

b. Click the lookup reference and select the sort item from the Lookup for **From**. Select the required sort of item and click **Select**.

Range- : Select this option to include a range of items to sort from. Selecting this option enables the From and To fields. Do one of the following:

a. Type the first and last values of the range in the **From** and **To** fields.

b. Click the lookup reference (if available) and select the sort item from the Lookup. Select the required sort of item and click **Select**.

All- : Select this to include all available items.

  1. Specify the Other Variables value to filter the report generation based on Standard Revision, Facility or other variables.

    Only on selectingWIP by Part Number and WIP by Product Class options in the Selection box, the Other Variables field is populated.

  2. On the Toolbar, click Run Report. The Please Select dialog box appears.

    Select Open now to open the report in a new tab or select Notify when Complete to get notification. You can open the downloaded report from My Reports page.

​