Job Order Structure/Material Status [RPJSMS] page

Article • 5/19/2025 • 2 min read

Use the Job Order Structure /Material Status report to generate information which will detail the structure of Jobs and Sub-jobs. It will also display the detailed status of each of the items on the Job Material List indicating the quantity that has been issued or received.

By default, generic filters are available to generate this report. You can use Advanced Filters to customize or expand your filter criteria.

To generate Job Order Structure/Material Status Report

  1. Open the Job Order Structure/Material Status (RPJSMS) page.

    • Select Production Management > Production Reports > Job Orders > Job Order Structure/Material Status.

      Or

    • Search for RPJSMS in the Navigation box and then select Job Order Structure/Material Status.

      The Job Order Structure/Material Status (RPJSMS) page appears.

  2. From the Selection box, select the information you want to view.

  3. In the Sort Order box, select from the options on how to sort the report.

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

  4. In the Layout area, 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. In the Sort Range area, specify the sort range.

    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:

      1. Type the item reference in the From field.

      2. Click the lookup reference and select the sort item from the Lookup for From. Highlight the required sort 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:

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

      2. Click the lookup reference (if available) and select the sort item from the Lookup. Highlight the required sort item and click Select.

    • All-: Select this to include all available items.

  6. Click Run Report on the Toolbar to generate the report.

    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.