> For the complete documentation index, see [llms.txt](https://kb.logicerp.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://kb.logicerp.com/logic-erp-version-release-notes/october-2026/reports-queries/stock-reports/stock-query-new.md).

# Stock Query - New

Logic ERP has added an option to the **Stock Query - New** report that keeps **Stock Receipt - Production** entries out of the purchase columns, and two new columns that show the value of these entries. Earlier the production quantity could be shown in its own column, but its value always stayed inside **PUR VALUE-1**.

***

### **Step 1: Open the Report**

* Navigate to **Reports/Queries** and select **Stock Reports**.
* Open **Stock Query - New**.

***

### **Step 2: New columns**

* **PRODUCTION VALUE-1** shows the value of the stock received through **Inventory\Stock Receipt - Production**.
* **PRODUCTION RETURN VALUE-1** shows the value of returns on those entries.
* Both are valued the same way as **PUR VALUE-1** and **PURCHASE RETURN VALUE-1**, so the purchase value setting of your configuration applies to them too. One exception: when **Sale Value-1 As** is **UD Net Amount** and **Use Sale Value Settings for Purchase Values also** is ticked, **PRODUCTION RETURN VALUE-1** is not filled.
* They sit next to the existing **PRODUCTION QTY** and **PRODUCTION RETUEN QTY** columns.
* They are not shown by default. Tick them in the report's column selection.

***

### **Step 3: New option - Exclude Stock Receipts - Production Qty and Values from Purchase**

* Find it in the report configuration under **Report Options-1**. It is not ticked by default.
* **Ticked:** Stock Receipt - Production entries are left out of **PURCHASE-1**, **PUR VALUE-1**, **PURCHASE RETURN-1** and **PURCHASE RETURN VALUE-1**, and appear only in the production columns. **NET PURCHASE-1**, **NET PURCHASE VALUE-1**, **AVERAGE PURCHASE RATE** and **SALE / PURCHASE(%)** follow the purchase columns. **TOTAL STOCK-1** and **TOTAL VALUE-1** still include the production entries, and the closing stock and closing value do not change.
* **Not ticked:** the production entries stay inside the purchase quantity and value columns. The production columns still show them separately.

> **Example - one item, two receipts**
>
> An item has no opening stock. In October, 50 pcs are bought on a purchase voucher and 20 pcs are received through Stock Receipt - Production. By the report's value setting the purchase is worth ₹5,000 and the production receipt ₹200.
>
> * **Option not ticked:** PURCHASE-1 70, PUR VALUE-1 ₹5,200, PRODUCTION QTY 20, PRODUCTION VALUE-1 ₹200.
> * **Option ticked:** PURCHASE-1 50, PUR VALUE-1 ₹5,000, PRODUCTION QTY 20, PRODUCTION VALUE-1 ₹200.
> * In both cases TOTAL STOCK-1 is 70 and TOTAL VALUE-1 is ₹5,200.

***

### **Changes to note**

* Earlier, showing **PRODUCTION QTY** or **PRODUCTION RETUEN QTY** took the production quantity out of **PURCHASE-1** and **TOTAL STOCK-1** but left its value in **PUR VALUE-1**. Now only the new option takes production out of the purchase columns, and it moves the quantity and the value together.
* A saved configuration that shows **PRODUCTION QTY** will now include the production quantity in **PURCHASE-1**, **NET PURCHASE-1** and **TOTAL STOCK-1**. This is intended. To keep production out of the purchase columns, tick the new option.
* When **Sale Value-1 As** is **UD Net Amount** and **Use Sale Value Settings for Purchase Values also** is ticked, **PUR VALUE-1** now includes the Stock Receipt - Production entries while the new option is not ticked, the same as **PURCHASE-1**. Earlier it left them out. The higher **PUR VALUE-1** in this setting is intended.
* With **Transaction Filter** set to **Transacted Items** or **Transacted Items(Excluding OP/CS)**, a row whose only movement is a Stock Receipt - Production entry is no longer left out when **PRODUCTION QTY** or **PRODUCTION RETUEN QTY** is shown.
* The detail levels opened by double-clicking a row of the report keep the earlier behaviour: the new option is not applied there and the new value columns stay empty.
* Stock produced through the production cycle is not affected. It continues to show in **PRODUCTION RECEIPTS-1** and **PRODUCTION RECEIPTS VALUE-1**.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

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

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://kb.logicerp.com/logic-erp-version-release-notes/october-2026/reports-queries/stock-reports/stock-query-new.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

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.
