> 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-learning-hub-tutorials-and-best-practices/inventory/stock-transfer-godown-wise/retrieve-items-from-excel-in-godown-wise-stock-transfer.md).

# Retrieve Items from Excel in Godown - Wise Stock Transfer

**YouTube:** [How to Retrieve Items from Excel in Godown-Wise Stock Transfer?](https://youtu.be/TpRloqJFZm0)

## How to Retrieve Items from Excel in Godown - Wise Stock Transfer?

In this tutorial, we will learn how to retrieve items from an external file while creating a **Stock Transfer Godown-Wise** voucher in Logic ERP.

This feature allows you to import item details from an external file (Excel or text file). The system validates the barcodes and checks stock availability in the **Godown From** before retrieving the items into the item details grid.

***

### Access to the Stock Transfer Godown-Wise Entry Window

* Navigate to the **Inventory** module from the main menu.
* Open the **Stock Transfer - Godown Wise** window.
* Select the **Godown From** and **Godown To**. The retrieve option is refused until both are selected.
* The configuration option **Do not create new lots for godowns** must be ticked; otherwise the system asks you to tick it before proceeding.
* Proceed to the **Item Details** section.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FxJIaq1wdzqLEN2TgB7og%2FGD.png?alt=media&#x26;token=b8c74d50-6b88-4a44-a987-935df7fb5498" alt=""><figcaption></figcaption></figure>

***

### Retrieve Items from an External File

* In the **Item Details** section, click on **Retrieve...**.
* From the available options, select **Items from External File** and click **OK**.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FTVhHtzhMST4o7GLj9H2s%2FRet.png?alt=media&#x26;token=527d338b-9c35-499f-b275-c2885e815d66" alt=""><figcaption></figcaption></figure>

* Select the import **Configuration**. The configuration sets the file type and the column numbers of the file; at least a **barcode** column and a **quantity** column are needed, and **Barcode Type** says what the barcode holds (item code, lot code and so on).
* In **File Path**, browse your device and select the required file.
* In **Select Sheet**, select the appropriate sheet.
* In **Header Row**, enter the row that holds the column headings (**1** in this example, because the headings are in the first row). It cannot be blank or 0.
* Click **Refresh** to process the file.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FESv78vLdYanSgWdGEkvk%2FrEF.png?alt=media&#x26;token=c815f561-daff-4403-848e-c216280aaf14" alt=""><figcaption></figcaption></figure>

* The system will now validate the barcodes and check whether the corresponding items can be retrieved.

***

### Understand Barcode Validation

* As you can see, some barcodes are highlighted in **red**.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2Fo5ACIct6Z0m8dEEr0lsL%2FrED.png?alt=media&#x26;token=dee84131-cdcd-4b45-8f19-66e6e4811da3" alt=""><figcaption></figcaption></figure>

**What Does This Mean?**

* Red highlighting indicates a line that cannot be used. The reason is shown in the **Invalid Remarks** column, for example: the item is not found, the lot number exists more than once, or the MRP does not match the file (when that check is enabled).
* Red lines are not retrieved. Red does **not** indicate low stock; stock is checked in the next step.
* Click **Ok** to continue.

***

### Review Items That Could Not Be Retrieved

* After clicking **Ok**, if any quantity could not be retrieved, the **Barcode Items not Retrieved** window appears listing those items.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FQ8IGf8DFJYevitgLm0hB%2FpRO.png?alt=media&#x26;token=001bdfbe-74ae-4a47-b8f1-13c1ac689d48" alt=""><figcaption></figcaption></figure>

**Possible Reasons**

An item is listed here because:

* The item has no stock in the **Godown From**, or
* The quantity in the file is more than the stock available. In this case the item is still retrieved for the quantity in stock, and only the shortfall is listed here.

(Barcodes that could not be identified are the red lines in the previous step; they do not appear in this window.)

Review the details displayed in the window, then click **Close** to continue.

***

### Verify the Retrieved Items

* After closing the pop-up, review the **Item Details** grid.
* As you can see, the system has automatically retrieved the valid items, up to the stock available in the **Godown From**.
* Red (invalid) lines and items with no stock are excluded from the retrieved entries.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FQ6qbdxtv4KOTZUu9AUk1%2FSAVE.png?alt=media&#x26;token=cac09cfc-a2a0-4917-acfc-d85eb8988599" alt=""><figcaption></figcaption></figure>

***

### Final Outcome

The **Items from External File** option allows you to retrieve item details into a Stock Transfer - Godown Wise voucher efficiently. Logic ERP validates the barcodes, checks stock availability in the Godown From, lists any quantity that could not be retrieved, and automatically loads the valid items, up to the available stock, into the item details grid.


---

# 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-learning-hub-tutorials-and-best-practices/inventory/stock-transfer-godown-wise/retrieve-items-from-excel-in-godown-wise-stock-transfer.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.
