> 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/physical-vs-actual-stock-doc-wise-entry/physical-vs-actual-stock-doc-wise-entry-configuration/allow-multiple-branch-auditing-from-external.md).

# Allow Multiple Branch Auditing From External

**YouTube:** [How to Enable Multi-Branch Stock Auditing from External Files in Physical vs. Actual Stock Entry?](https://youtu.be/2pQhxcw_1mc)

## How to Enable Multi-Branch Stock Auditing from External Files in Physical vs. Actual Stock Entry ?

In this tutorial, we’ll learn how to use the **“Allow Multiple Branch Auditing From External”** feature in the **Physical Vs Actual Stock – Document Wise Entry** module in Logic ERP. This feature allows users to import physical stock audit data for multiple branches using a single Excel file. It also provides an option to refresh stock before importing, ensuring that the stock details of items available in the specified godown are included along with the items listed in the Excel sheet.

***

### Let's Enable Multiple Branch Auditing

* Navigate to the **"Inventory"** and then open "**Physical Vs Actual Stock – Document Wise Entry"** module.
* Open the **Configuration** window.
* Locate and enable the option labeled as:

**“Allow Multiple Branch Auditing From External”.**

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FzBY1q2hxq2pkO3l3H5f3%2FCNF.png?alt=media&amp;token=78a2eddf-3a4b-4077-861e-c0045e611250" alt=""><figcaption></figcaption></figure>

* Once enabled, the system unlocks the **“Always Refresh Stock Before Excel Retrieval”** option.

**Let’s understand how the stock refresh option affects the Excel import process.**

***

### Understand the Always Refresh Stock Before Excel Retrieval Option

* Locate the **“Always Refresh Stock Before Excel Retrieval”** option in the configuration window.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FgjRDRG37ld0Ri9vwVMbF%2FCNF%20-%202.png?alt=media&amp;token=b29649e8-ee57-45b1-8111-ff4d0d7f26ad" alt=""><figcaption></figcaption></figure>

* When enabled, the system refreshes the stock of all items available in the godown specified in the Excel sheet for the respective branch.
* This includes items available in the specified godown even if they are not listed in the Excel sheet.
* When disabled, the system imports only the item stock details listed in the Excel sheet.

**First, we’ll keep this option disabled and observe the import results.**

***

### Review the Excel File

* Open the Excel file that will be used for the stock audit.
* Review the stock details provided in the sheet.
* As shown, the Excel file contains physical stock details for multiple branches.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2F0yxJ1PlT4aeBr42CxhiC%2FExcel.png?alt=media&amp;token=c9f9bf25-bd9a-4c65-9eeb-2738083fd27c" alt=""><figcaption></figcaption></figure>

**The Excel file is ready. Let’s import it and verify how the system processes the branch-wise stock details.**

***

### Import the Excel File with Stock Refresh Disabled

* Return to the **Physical Vs Actual Stock – Document Wise Entry** module.
* Click **“Import Data from Excel File.”**

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2F0WpKHVbwUMUeJFJo9lpW%2FImport.png?alt=media&amp;token=4eea32a0-50c8-4115-9887-8ee95765dd3c" alt=""><figcaption></figcaption></figure>

* Select the prepared Excel sheet and start the import process.
* Once the import is complete, verify the generated documents.
* The system successfully saves the documents for the respective branches specified in the Excel sheet.
* Open the documents one by one to review the imported physical stock details.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FPPlkIqMbB9VK19pviPUR%2FModify.png?alt=media&amp;token=ca3f0e5f-93c4-4159-b55b-0d26433ab522" alt=""><figcaption></figcaption></figure>

* Since **“Always Refresh Stock Before Excel Retrieval”** is disabled, the system imports only the item stock details listed in the Excel file.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FA3bWYP45zFdhRVvJ4oBI%2F1.png?alt=media&amp;token=0ec10b9e-ae0d-4053-b8dd-848dcf4dec15" alt=""><figcaption></figcaption></figure>

**This confirms that, when stock refresh is disabled, the import is limited to the items included in the Excel sheet for each branch.**

***

### Import the Excel File with Stock Refresh Enabled

* Open the configuration window again.
* Enable **“Always Refresh Stock Before Excel Retrieval.”**
* Return to the stock entry module and import the same Excel file again.
* Verify that the documents are saved successfully for the respective branches.
* Open the generated documents and review the imported stock details.
* The system imports the stock details listed in the Excel sheet and also includes the available stock of other items in the specified godown for each respective branch.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FQ7cTpLPJPg4IUhvR564w%2F2.png?alt=media&amp;token=247c1837-76ef-40b9-9c76-55dfaf983781" alt=""><figcaption></figcaption></figure>

**This confirms that enabling the stock refresh option includes additional stock details from the specified godown, even when those items are not listed in the Excel file.**

***

### Conclusion / Result

* **Allow Multiple Branch Auditing From External:** Enables physical stock auditing for multiple branches through an external Excel file.
* **Stock Refresh Disabled:** Imports only the item stock details listed in the Excel sheet.
* **Stock Refresh Enabled:** Imports the listed items and includes stock details for other items available in the specified godown of each respective branch.
* **Key Benefit:** This feature simplifies multi-branch stock auditing by allowing users to import branch-wise stock data in one process, with the flexibility to include additional godown stock details when required.

**By using these configuration options, users can manage physical stock audits across multiple branches more efficiently and control whether the import includes only listed items or additional stock from the specified godowns.**


---

# 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/physical-vs-actual-stock-doc-wise-entry/physical-vs-actual-stock-doc-wise-entry-configuration/allow-multiple-branch-auditing-from-external.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.
