# Generate Stock Status and Production WIP Report

**YouTube:** [How to Generate Stock Status and Production WIP Report?](https://www.youtube.com/watch?v=7zx7iFBglIg\&t=1s)

## How to Generate Stock Status and Production WIP Report?

In this tutorial, we will learn how to generate the **Stock Status and Production Work-in-Progress (WIP) Report** in Logic ERP. This report provides a detailed, process-wise overview of production progress, helping you track completed and pending quantities at every stage.

***

### **Accessing Reports and Configuration**

* Open the **Production Module**.
* Navigate to Production\Production Reports/Queries\Production Finished Goods Reports and then select **"Stock Report - Stock Status + Production WIP Report".**
* Click **Configuration** to create a new report setup.
* Enter a suitable **Report Configuration Name**.

<figure><img src="/files/fwWA0EBAtqF8QNKf6pWR" alt=""><figcaption></figcaption></figure>

***

### **Configuring Report Options**

* **Report Totals**
  * Enable **Report Totals** based on available parameters.
  * These totals help display summarized values at the end of each section for quick analysis.
* **Report Order**
  * Use the **Report Order** option to define the sequence in which data should appear.
  * Rearrange the order using the directional buttons provided.
* **Item Consolidation**
  * Consolidate items using the **Item Consolidation** feature.
  * Group similar items together for improved readability and structured presentation.
  * Adjust the consolidation sequence as per your requirements.
* **Item Totals**
  * Enable **Item Totals** to display totals at the item level.
  * This helps generate well-organized and detailed item-wise summaries.

<figure><img src="/files/yBXH4MIjoQsRblpoIdgF" alt=""><figcaption></figcaption></figure>

* **Other Options**
  * Select the **Job Order Consolidation Basis** based on how you want job orders grouped in the report.
  * Use the **Column As** option to decide which data will appear in each column.
  * Configure the **Stock Received Production** dropdown to define how production receipts should be considered in the report.
* **Additional Settings**
  * Use the bottom **Checkbox Options** to refine and customize the report output further based on your specific reporting needs.

<figure><img src="/files/8mU6FigzrhPr1d9GroNP" alt=""><figcaption></figcaption></figure>

***

### **Saving and Generating the Report**

* Once all options are configured, click **Save** to store your report setup.
* Click **Create** to generate the report.

<figure><img src="/files/JutpgUyfuvKmvLif0Zja" alt=""><figcaption></figcaption></figure>

***

### **Customizing Report Columns**

* Open **Setup Column Attributes**.
* Click **Unselect All**, then select only the columns you want displayed in the report.
* Rearrange the column order using the arrow buttons.

<figure><img src="/files/cF1obDR1r48aLKXy1uuG" alt=""><figcaption></figcaption></figure>

* Save the changes and press **F2** to refresh the report.
* The report will now reflect the updated column settings.

***

### **Final Output**

This report provides a complete snapshot of your production progress, including:

* Process-wise WIP tracking
* Quantity completed vs. quantity pending
* Current stage of each job order
* Improved visibility across all stages of production
* Better monitoring, planning, and overall production control.

<figure><img src="/files/KEFFHrAjVOKWX1zuRzap" alt=""><figcaption></figcaption></figure>

***

### **Conclusion**

The Stock Status and Production WIP Report in Logic ERP is an essential tool for monitoring manufacturing activities. By configuring and customizing the report, you gain complete visibility into ongoing processes, enabling efficient planning, timely decision-making, and improved production management.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://kb.logicerp.com/logic-erp-installation-configuration-and-troubleshooting-solutions/faqs/production/generate-stock-status-and-production-wip-report.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.