# Control Rate Updates for Transacted Lots in Purchase Voucher

**YouTube:** [Why Rates Are Not Updated in the Lot Master After Retrieving a Purchase Challan?](https://www.youtube.com/watch?v=PH2l2e6XA04)

## Why Rates Are Not Updated in the Lot Master After Retrieving a Purchase Challan?

This tutorial explains **how to control the behavior of rate updates for transacted lots when retrieving a Purchase Challan into a Purchase Voucher**, and how to adjust the system setting to allow or restrict such updates.

***

### Retrieve Purchase Challan in Purchase Voucher

Begin by creating a Purchase Voucher entry.

**Steps:**

* Open the **Purchase Voucher** window
* Start a **new entry**
* Retrieve the **Purchase Challan**

Once the challan is retrieved:

* The **rates defined in the challan** will automatically be fetched into the voucher.&#x20;

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FZyCCvnbqQfsTR7zi63ua%2FRetreive%20Challan%20in%20Purchase%20Voucher.png?alt=media&#x26;token=2d8d586a-4da1-4bbb-bb24-4977fb5d5766" alt=""><figcaption></figcaption></figure>

* **Save the voucher entry**

***

### Check Rate Behavior in Modify Mode

Reopen the **Purchase Voucher in Modify Mode**

You will notice:

* **Rates of most items get updated automatically**

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FE6fniOLq87IWaZEsDiRo%2FRate%20Update.png?alt=media&#x26;token=080ca782-db1c-445a-ab0d-0aff6306bb52" alt=""><figcaption></figcaption></figure>

* This happens due to **user-defined purchase rate formulas configured in the system**

However:

* **Some items may not have their rates updated.**
* Press **F5 on the Lot** to check the **lot details and rate information**.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FEEFNGmehHdZHmSbf5w4L%2FOld%20Rate.png?alt=media&#x26;token=2d223e1a-55ce-4c96-973c-5fe7fa3d5bfd" alt=""><figcaption></figcaption></figure>

* You will observe that the **rate for that specific lot remains unchanged**.

***

### Identify the Reason Using Stock Query Report

To understand why the rate did not update, analyze the stock movement.

**Open the report**

* Go to **Stock Query – New Report**

Generate the report for **only the items included in the challan**.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FQWRFo6okZdwHY85TngEG%2FReport.png?alt=media&#x26;token=e96919aa-ee85-408d-8ce6-77a26eeb1764" alt=""><figcaption></figcaption></figure>

In the report you will see:

* **Purchase Challan created on 18th December** → Stock added
* **Sales Bills generated on 09th March** → Some items sold

**Key Observation**

* Items **already used in sales transactions** did **not update their rates** when the purchase voucher was modified.

***

### Why This Happens

* This behavior occurs because of a **system setting enabled in the Logic Admin Panel**.
* The setting prevents **rate changes for lots that have already been transacted**.

**Change the System Setting**

To allow rate updates for such lots:

**Follow this path**

* Open **Logic Admin Panel**
* Go to **Global Settings**
* Navigate to **Purchase Options**
* Locate and **untick the option**

> **“Do not allow change in rates of transacted lots.”**

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FsX2CM04gzdz4I49X3kdx%2FGlobal%20Admin%20New.png?alt=media&#x26;token=3e669f1e-ba0d-4908-b06e-2a35813cf9c6" alt=""><figcaption></figcaption></figure>

* Save the settings and **Restart the software.**

***

## Repeat the Process for Testing

To clearly understand the behavior, repeat the process.

#### Create Purchase Challan

* Create a **Purchase Challan**
* Enter item details and **save the challan**

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FY1VLAHyZTWOVpXBn1byj%2FNew%20Purchase%20Challan.png?alt=media&#x26;token=20a9cfdd-06ff-4894-a08b-3dc784198d1b" alt=""><figcaption></figcaption></figure>

#### Generate Sales Transaction

* Create a **Sales Bill**
* Sell **one or two items from the challan**

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FirWYZefZS7W6BTQ2WqA4%2FSaleBill.png?alt=media&#x26;token=6ed301ff-cee6-4d81-bf0d-ea163643d317" alt=""><figcaption></figcaption></figure>

* Save the sales bill

This ensures those items become **transacted lots**.

#### Retrieve Challan in Purchase Voucher

* Open the **Purchase Voucher window**
* Retrieve the **same purchase challan**

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FI0Ehe8pVx3XFeQDNsQgx%2FPurchase%20Voucher.png?alt=media&#x26;token=8fdd69e4-5a9f-4de4-a113-adfd42acec2b" alt=""><figcaption></figcaption></figure>

* Save the voucher

#### Open Voucher in Modify Mode

* Now Re-Open the voucher in **Modify Mode**.

**This time you will notice:**

* Rates of all items,  Including the transacted lots are updated automatically according to the user-defined purchase rate formula.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FzySy6QOadUtFjxZqBv3Z%2FNo.png?alt=media&#x26;token=5c6188e4-0fcc-4804-8264-8b5c41731e0b" alt=""><figcaption></figcaption></figure>

***

### Practical Approaches to Handle This Scenario

There are **two practical ways** to manage rate updates effectively.

#### Approach 1: Disable the Restriction Setting

* Disable the option **“Do not allow change in rates of transacted lots”**
* This allows **automatic rate updates even for transacted lots**

#### Approach 2: Apply Rate Formula in Purchase Challan

* Instead of applying the formula in the **Purchase Voucher**, apply it directly in the **Purchase Challan**.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2Fib8hjRpG7c8c0mdBqHCy%2FDefine%20Rate%20Formula.png?alt=media&#x26;token=21a390c9-bbac-4bae-8b74-8152d0af4e92" alt=""><figcaption></figcaption></figure>

Benefits:

* Rates are **calculated and saved at the challan stage**
* When the challan is retrieved into the purchase voucher:
  * The system **uses the same predefined rates**
  * Even if the lots have **already been transacted**

***

### Conclusion

By controlling the **rate update settings for transacted lots**, businesses can:

* Maintain **accurate purchase costing**
* Avoid **unexpected rate changes**
* Ensure **consistent stock valuation**
* Manage **purchase formulas effectively**

This feature provides **flexibility in handling purchase transactions while maintaining data accuracy**.
