Overwrite Lot No.'s/Rates

YouTube: How to Overwrite Lot Numbers / Batch Numbers and Rates?

How to Overwrite Lot Numbers / Batch Numbers and Rates?

In this tutorial, we will learn how to override lot numbers and modify lot-wise item rates in Logic ERP and how to track rate changes using system reports.

---

Opening the Overwrite Lot Number / Rate Utility

• Navigate to the Inventory Module from the main menu

• Open Overwrite Lot No.'s/Rates.

---

Selecting Item and Lot for Modification

• Select the required Item Name

• Choose the corresponding Lot / Batch Number

• Click Refresh to load the current rate details

---

Understanding Default Rate Behavior in Sales Billing

Before making any changes, let’s review how rates work by default:

• Open the Sales Bill window

• Transact an item normally

• The system applies the existing lot-wise rate by default

Note: You can manually edit the rate in the sales bill by pressing F5 on the Lot / Batch column. However, editing each lot individually can be time-consuming.

---

Overwrite Lot Numbers and Rates Using Utility

To simplify bulk rate changes:

• Navigate to Overwrite Lot No.'s/Rates

• Enter the new rate against the selected lot

• Modify rates item by item as required

The rate defined here will be automatically picked in the sales bill whenever that lot is selected.

Overriding Rates for All Items at Once

• Press F3 in the rate column

• Enter the new rate

• The system will overwrite rates for all listed items

• Click Save to apply the changes

Note: If the F3 shortcut is not working, enable the “Overwrite Rate for All Items” option from the Configuration menu at the top.

---

Verifying Updated Rates in Sales Bill

• Return to the Sales Bill window

• Create a New Transaction

• Select the item and lot

Result: The updated batch number and overridden rate are automatically applied.

---

Tracking Lot Rate Change History

To review both old and new rate values:

• Go to the Menu Bar

• Navigate to Reports/Queries

• Click on Item Reports

• Open Item Wise Rate Change History Report

• Select the required Item(s)

• Generate the report

The report clearly displays:

• Old Sale Rate

• New Sale Rate

• Old MRP

• Updated MRP

---

Conclusion

This completes the Override Lot Number and Rate process in Logic ERP, enabling quick and efficient lot-wise rate management along with complete rate change traceability.