Material Requisition vs Work Order Comparison

Report Module Guide: Material Requisition vs Work Order Comparison

Module Location

Production > Reports > Material Requisition vs Work Order Comparison

Module Objective

The Material Requisition vs Work Order Comparison Report module is used to generate a reconciliation report that compares the details of a Material Requisition (materials requested by production) with the details of a Work Order (the planned finished good). This report is very useful for verifying whether the requested materials match the recipe (BOM) requirements of the product to be made.

1. Report Parameters (Filter)

The main page of this module is a form containing various parameters to customize the report that will be generated.

Here is an explanation for each parameter:

• JO Filter:

  • Select All Work Orders to display all, or Select Work Order to focus on one or more specific Work Orders.

• Work Order - Start Date:

  • Specify the Work Order date range in the From and To fields for which you want to compare requisitions.

2. Steps to Generate the Report

Step 1: Set Report Parameters

Define the Work Order date range or select the specific Work Orders you wish to review.

Step 2: Generate the Report

After all parameters are set, click one of the two buttons at the bottom:

• [Display Report]: To preview the comparison report directly on your screen.

• [Export to MS Excel]: To download the report data in an Excel file format.

3. Reading the Report (Report Content)

The generated report is a detailed comparison between the Material Requisition and its related Work Order.

Key Column Explanation

This report displays the details of the Work Order (the finished good to be made) and then details all the Material Requisitions (raw materials) associated with it:

• Work Order Number: The main reference.

• Item/Service Name (Work Order): The planned finished product.

• Raw Material / Supporting Material: A list of all materials requested for that Work Order.

• Quantity Requested: The quantity of raw materials requested.

How to Analyze: This report helps verify whether the raw material items and quantities requested via the Material Requisition are in accordance with the standard recipe (BOM) used by the Work Order.

Tips & Important Notes

• This report is an important internal audit tool for PPIC to ensure there are no excessive or insufficient material requests for a Work Order.

• Use this report to identify potential errors in the material requisition process or discrepancies with the BOM.

• This is a good closing report to ensure all production and material request data are synchronized.