> 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/setups/set-other-item-details/edit-rates-in-item-master.md).

# Edit Rates in Item Master

**YouTube:** [How to Edit Rates in Item Master directly or via Excel?](https://www.youtube.com/watch?v=4XTAh3M1ypA)

## How to Edit Rates in Item Master directly or via Excel?

In this tutorial, we will discuss **how to edit item rates in the Item Master of Logic ERP**, both **manually** and **by importing data through an Excel sheet**. We will also review how to track **rate change history** for audit and verification purposes.

***

### **Access to Edit Rates in Item Master**

* From the **Main Menu**, go to the **Setup Module**
* Navigate to **Set Other Item Details**
* Click on **Edit Rates in Item Master**

***

### **Select Items and View Existing Rates**

* Select the required items from the **Search List**

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2F6o1yb1ZY8OAScyH94RLu%2FSelect%20Items.png?alt=media&amp;token=a1ba2b22-a16d-4d11-a15e-6c3329a1cfd6" alt=""><figcaption></figcaption></figure>

* Click on the **Refresh** button

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FXWaxk6J5Ybgu047QbScb%2FRefresh.png?alt=media&amp;token=235402f4-f922-4b5b-b2d2-c84540c99056" alt=""><figcaption></figcaption></figure>

* This will display the **current rates** already defined in the item master for the selected items.

***

### **Update Rates Manually**

* Edit the rate values directly on the screen for each item
* Update one or multiple items as required

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2Fzfmhp8xmUfiW4VjYHekN%2FEdit%20Rate.png?alt=media&amp;token=0361f50a-b7c6-43a3-bc1b-e9c4aff98309" alt=""><figcaption></figcaption></figure>

* Click **Save** to apply the changes

The updated rates will now be reflected in the item master.

***

### **Update Item Rates Using Excel Import**

Logic ERP also allows bulk rate updates using Excel.

**Process**

* Enable the **Retrieve from Excel** option

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2F9ZzqoXxL1ZRLmY9ef3cJ%2FRetrieve%20from%20Excel.png?alt=media&amp;token=cd243696-443b-4945-a0f9-639385bdeb50" alt=""><figcaption></figcaption></figure>

* Click on the **Excel Help** button to understand:
  * Required columns
  * Correct Excel format

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FMJKgoikZdy9qNNh9cnd4%2FExcel%20Help.png?alt=media&amp;token=524438cd-e085-460b-899d-ea9bb2acf3cd" alt=""><figcaption></figcaption></figure>

* Prepare the Excel sheet accordingly
* Click on the **Excel** option
* Browse and select the Excel file from your system

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2F2SK6x9eEBMbdU3xNgmoQ%2FFile%20Path.png?alt=media&amp;token=68f87e65-6d5b-4c74-8032-60ac63d29769" alt=""><figcaption></figcaption></figure>

* Click **Refresh**

**Result**

* The rates defined in the Excel sheet are successfully imported

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2F7RwlDrr7ziDhjLA8ftAg%2FRefresh%20Data.png?alt=media&amp;token=3eba2383-02cf-4019-909e-29739052e83c" alt=""><figcaption></figcaption></figure>

* Click **Save** to update the rates in the item master

***

### **View Item-Wise Rate Change History**

Logic ERP provides a built-in report to track all rate modifications.

**Steps**

* Navigate to **"Reports/Queries"** and select **"Item Reports"**
* Open **Item-Wise Rate Change History Report**
* Generate the report

**Report Details Include**

* Date and time of rate change
* Previous (old) rate
* Updated (new) rate

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FEl4rzEAhUBN2SFML00SX%2FReport.png?alt=media&amp;token=6b34a502-9088-43e8-9d03-25ba4c271792" alt=""><figcaption></figcaption></figure>

* Item-wise change details

***

### **Conclusion**

By using the **Edit Rates in Item Master** feature in Logic ERP, you can:

* Modify item rates **manually**
* Update rates in **bulk via Excel**
* Maintain transparency with **rate change history reports**

This ensures **accurate pricing control**, easy bulk updates, and reliable **audit tracking** for administrators.


---

# 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/setups/set-other-item-details/edit-rates-in-item-master.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.
