Batch Utilization Report
The Batch Utilization Report traces a batch in both directions. It shows the inward / inspection records each batch was created from, and how the batch quantity has been used afterwards (released to production, in process, finished, rejected, and the job work, DC, final inspection and invoice documents it moved on). A batch created from several inspection records lists every one of them.
1. Search the Batch Utilization Reportβ
Step 1: Reach the Batch Utilization Reportβ
From the main side menu, click on Production & Quality β Reports β Batch Utilization Report. This will open the Batch Utilization Report search page.
Step 2: Fill in Detailsβ
- Part
[Mandatory][Dropdown]Select the part whose batches you want to trace. - Batch Date From
[Mandatory][Date]Start of the batch date range. It defaults to the first day of the current month. - Batch Date To
[Mandatory][Date]End of the batch date range. It defaults to today. - Search Button β Lists every batch of the selected part created within the date range.
- Clear Button β Clears the part and the results, and resets the dates.
Step 3: See the Resultsβ
Click Search. The summary and the batch table appear below the search section.
- If no batch was created for the part in the period, the message No batch was created for this part in the selected period is shown.
- One search shows up to 300 batches. When the period holds more, a message asks you to narrow the date range.
2. Summaryβ
The strip above the table totals all the batches listed.
| Field | Description |
|---|---|
| Batches Created | Number of batches created for the part in the period. |
| Total Batch Qty | Total quantity of those batches. |
| Released to Production | Batch quantity for which production serials have been created. |
| In Process | Released quantity that is neither finished nor rejected yet. |
| Finished | Quantity approved at the last process of the control plan. |
| Rejected | Quantity rejected at any process. |
| Not Yet Released | Batch quantity not yet released to production. |
| Completion | Finished quantity as a percentage of the total batch quantity. |
3. Batch Creation and Utilization Tableβ
The table has one row for each inward / inspection record used in a batch. The batch columns and the utilization columns span all the rows of that batch, so a batch created from three inspections shows three inward rows against one batch.
Inward / Inspectionβ
| Column Name | Description |
|---|---|
| S.No | Serial number of the batch. |
| Source | Where the material came from: Purchase Inward, Customer Job Work In, Internal Material Inward, Miscellaneous Inward, Returnable DC In or Finished Goods Stock. |
| Inward No / Date | Number and date of the inward document (for example the GRN). |
| Supplier / Customer | Supplier, customer or source plant of the inward document. |
| Inward Qty | Quantity received on the inward line. |
| Inspection No | Inspection in which the material was accepted. |
| Accepted | Quantity accepted in that inspection. |
| Used in Batch | Quantity of that inspection used to create this batch. |
Batchβ
| Column Name | Description |
|---|---|
| Batch No / Date | Batch number and batch date. Click the batch number to open the batch details. |
| Batch Qty | Quantity of the batch. |
Batch Utilizationβ
| Column Name | Description |
|---|---|
| Released | Batch quantity released to production. |
| In Process | Released quantity still moving through the processes. |
| Finished | Quantity approved at the last process. |
| Rejected | Quantity rejected at any process. |
| Not Released | Batch quantity not yet released to production. |
| Completion | Finished quantity as a percentage of the batch quantity, with the batch status (Not Started, In Progress or Completed). |
The last row shows the totals of Used in Batch, Batch Qty and the utilization columns.
Adjusted inspectionsβ
When the accepted quantity of an inspection was adjusted in stock, an Adjusted mark is shown beside its Inspection No. Move the mouse over the mark to read the adjustment remarks. A line under the table explains the mark whenever the result contains an adjusted inspection.
- A batch created from Finished Goods Stock has no inward document, so its inward and inspection columns show -.
- A batch with no recorded material source shows Not recorded in the Source column.
4. Batch Detailsβ
Click a Batch No in the table to open its details below the table. Click Close to hide them.
The header shows the Batch No with its status, Batch Date, Batch Qty, Material Sources, Released to Production, In Process, Finished, Rejected and Completion, followed by the Part, Control Plan, Production period, Reference and Created By.
4.1 Batch Creationβ
The inward / inspection records the batch material was taken from.
| Column Name | Description |
|---|---|
| Material | Material consumed by the batch and the quantity required. |
| Source | Type of inward document. |
| Inward No / Inward Date | Inward document number and date. |
| Supplier / Customer | Party of the inward document. |
| Order No | Purchase order or material order of the inward. |
| Party Invoice / DC No | Supplier invoice number, or the DC number when there is no invoice. |
| Inward Qty | Quantity received. |
| Inspection No / Inspection Date | Inspection number and date. |
| Accepted Qty / Rejected Qty | Quantities accepted and rejected in the inspection. |
| Used in Batch | Quantity of the inspection used in this batch. |
| Balance in Inspection | Accepted quantity of the inspection still unused. |
The last row, Total used in batch, adds up the Used in Batch quantities of all the sources.
4.2 Batch Utilization - Process Wiseβ
How far the batch quantity has moved through its control plan, one row per process.
| Column Name | Description |
|---|---|
| Process No / Process | Process number and name from the control plan. |
| Quantity | Quantity that has reached the process. |
| Approved | Quantity approved at the process. |
| Rejected | Quantity rejected at the process. |
| Rework | Quantity sent for rework. |
| On Hold | Quantity on hold. |
| Pending | Quantity waiting to be processed. |
| Outsourced | Quantity processed through outsourcing. |
| Start Date / End Date | First and last date of work on the process. |
| No of Days | Days between the start and end date. |
| Progress | Approved (green) and rejected (red) quantity as a share of the batch quantity. |
| Status | Not Started, In Progress or Completed. |
4.3 Batch Utilization - Transactionsβ
The documents the batch quantity was moved on after creation: Job Work DC Out, Job Work DC In, Returnable DC Out, Returnable DC In, Non-Returnable DC, Final Inspection and Sales Invoice.
- The tiles above the table show the quantity and number of documents for each transaction type. Click a tile to show only that type; click it again to show all.
| Column Name | Description |
|---|---|
| Transaction | Type of document. |
| Document No / Document Date | Number and date of the document. |
| Party | Supplier or customer of the document. |
| Process | Process the quantity was at when the document was raised. |
| Quantity | Batch quantity on the document. |
| Reference | Related document, for example the job order of a Job Work DC Out or the DC Out of a DC In. |
| Status | Status of the document, where it has one. |
5. Export or Print Reportβ
- Excel β Downloads the result with three sheets: Batch Creation, Process Wise Utilization and Utilization Transactions, covering every batch listed. Adjusted inspections are marked (Adjusted) beside the inspection number.
- Print β Prints the report.
- The report is available to users who have access to the Batch Wise Stock Report.
- Use the Batch Wise Stock Report for the process-wise stock of a single batch, and this report to trace all the batches of a part over a period.
Thatβs it! Youβve learned how to use the Batch Utilization Report in the DMeX application. For further assistance, please contact the Customer Support Team.