# 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**
* Click on the **Refresh** button
* 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
* 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
* Click on the **Excel Help** button to understand:
* Required columns
* Correct Excel format
* Prepare the Excel sheet accordingly
* Click on the **Excel** option
* Browse and select the Excel file from your system
* Click **Refresh**
**Result**
* The rates defined in the Excel sheet are successfully imported
* 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
* 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: Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter:
```
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=
```
The question should be specific, self-contained, and written in natural language.
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.