Monthly Shipment Analysis [RPMSHA]

Use the Monthly Shipment Analysis page to generate status for orders including for shipments, items shipped and cost summaries.

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

To generate Monthly Shipment Analysis Report

1. Open the Monthly Shipment Analysis (RPMSHA) page.

   • Select Executive Information System > EIS Reports > Production Performance > Monthly Shipment Analysis.

   Or

   • Search for RPMSHA or Monthly Shipment Analysis in the Navigation box and then select Monthly Shipment Analysis.

   The Monthly Shipment Analysis (RPMSHA) page appears.

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

   • Items Shipped: Select this option to include all SO items shipped during a specific period.

   • Shipped & Scheduled - SO Due Date: Select this option to include all SO items that were planned to be shipped during a specific period.

   • Shipped-Ship Date/Scheduled-SO Date: Select this option to include all SO items shipped during a specific period and the SO items that were planned to be shipped during a specific time period.

3. In the Sort Order field, select 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 Date Range area, type/select the date range for the report to be generated. You can select the date in the From and To fields only if the Custom option is selected in the Fill Dates field.

   The Date On field is populated based on the type of report selected in the Selection dropdown list.

   To include the entire time frame, leave the date fields blank.

   In the Fill Dates field, you can select from the predefined date ranges. They are:

• Custom:
  Selecting this option enables the From and To fields in the Date Range area.

• Calendar Year:
  Selecting this option displays the Calendar Year field. You can select any of the predefined calendar year formats from the dropdown list.

• GL Periods:
  Selecting this option displays the GL Periods field. You can select any of the predefined GL period formats from the dropdown list.

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:

     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.

7. In the Other Variables section, filter the report generation based on Gross Profit Goal or other variables.

   Only on selecting Shipped-Ship Date/Scheduled-SO Date from the Selection dropdown list, the Other Variables section becomes available.

8. On the Toolbar, click Run Report 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.

​