> 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/configurations/setup-schemes/setup-schemes-lot-wise-scheme.md).

# Setup Schemes - Lot Wise Scheme

## How to give a different discount for each lot in a scheme

A **Lot Wise Scheme** lets one scheme slab give its discount **only on selected lots** of the scheme's items, with **a different value for each lot** if needed. Use it when an offer runs on particular stock rather than on the whole item, for example "Buy 1 → 30% off, Buy 2 → 40% off" on selected lots only.

The lots and their values are entered in the **Lot Wise Scheme** window, which opens from the **Scheme Details** tab of **Setup Schemes**. You can enter lots one by one, pick them from a list, or bring in thousands of lots at once from an Excel sheet.

Lot wise slabs are available for **sale schemes**. They are not available for schemes set up for Sale Orders.

***

### **Before you start**

* Create the scheme, add its items and define its dates as usual - see [Setup Schemes](https://kb.logicerp.com/logic-erp-learning-hub-tutorials-and-best-practices/setups/configurations/setup-schemes.md).
* Open **Setup\Configurations\Setup Schemes** and go to the **Scheme Details** tab.
* Select the scheme date and enter the slabs (for example slab **1** and slab **2** for "Buy 1" and "Buy 2").
* If the slab grid does not show the **LOT WISE SCHEME** column, add it through the grid's column settings.

***

### **Open the Lot Wise Scheme window for a slab**

* In the slab grid, move to the **LOT WISE SCHEME** column of the slab.
* Press any key (for example the **Space bar**) in that cell. The **Lot Wise Scheme** window opens for that slab.
* When the slab already has lots, the cell shows **LOT WISE SCHEME**.

Each slab has its **own** list of lots. For a slab-wise offer, enter the lots in **every** slab, each with that slab's discount.

***

### **Choose how the lots are identified**

At the top of the window, select **Barcode As**:

* **Lot Number** - lots are entered by their lot number.
* **Lot Code** - lots are entered by their lot code.
* **Lot Code + Pcs No.** - a single piece of a lot is entered, as lot code and piece number.

Choose **Barcode As** before entering lots: changing it clears the rows you have entered. Once the slab has saved lots, **Barcode As** is locked.

***

### **Enter lots one by one**

* In the **FREE ITEM NAME** column, press a key to open the item list. Only the scheme's items are listed.
* Select the lot:
  * **Lot Number** - press a key in the **LOT NUMBER** column and select the lot.
  * **Lot Code** - press a key in the **LOT CODE** column and select the lot.
  * **Lot Code + Pcs No.** - select the lot in **LOT CODE**, then type the piece number in **PCS NO.**
  * The list shows lots with stock in this branch that are not expired or hidden.
* Enter the discount in one or more of **SCHEME/UNIT**, **SCHEME RS**, **CD**, **TD** and **SPCD**. At least one of these must be more than 0 in every row.
* A row is checked when you leave it. If something is missing, a message appears and the cursor moves back to that column.

**Set or clear a value for all rows**

* Move to a **SCHEME/UNIT**, **SCHEME RS**, **CD**, **TD** or **SPCD** cell.
* Press **F2**, enter one value and confirm. The value is set in that column for all rows. The value cannot be more than 100.
* Press **F3** and confirm to clear that column for all rows.

**Delete rows**

* Press **F8** on a row to delete it; you are asked to confirm.
* Click **Delete All** and confirm to remove every row of the slab.

***

### **Pick many lot codes from a list**

With **Barcode As** set to **Lot Code** or **Lot Code + Pcs No.**:

* Select the discount type (**Scheme/Unit**, **Scheme Rs**, **CD**, **TD** or **SPCD**) and enter its value next to it.
* Tick **Select Lot Codes** (or **Select Lot Code + Pcs**).
* Select the lots (or pieces) and click **OK**. Only lots of the scheme's items with stock are listed. They are added with the value you entered.
* To pick more lots, untick the box and tick it again.

The list does not check for lots already in the grid, so avoid picking the same lot twice.

If no value is entered, the message *Invalid Scheme OR Discount Value,Please Define Atleast One ...* appears.

***

### **Import lots from Excel**

Use this for large offers - thousands of lots can be imported in one go.

**Prepare the sheet**

Set **Barcode As** first: the lot column of the sheet must match it. Put a header row on the sheet with these column names. The columns can be in any order:

| Column                                   | What to enter                                                                                                                                             |
| ---------------------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------- |
| ITEM CODE                                | The item's code (required)                                                                                                                                |
| LOT NUMBER, LOT CODE or LOT CODE-PCS NO. | The lot, as chosen in **Barcode As** (required). For **Lot Code + Pcs No.** write the lot code and the piece number with a hyphen, for example **1205-3** |
| SCHEME/UNIT                              | Scheme value per unit                                                                                                                                     |
| SCHEME RS                                | Scheme amount                                                                                                                                             |
| CD                                       | Cash discount                                                                                                                                             |
| TD                                       | Trade discount                                                                                                                                            |
| SPCD                                     | Special discount                                                                                                                                          |

If the sheet has no **ITEM CODE** header, the columns are read in the order of the table above. The rows are read from the row below the header, until the first row with a blank item code. If the same lot appears twice in the sheet, the later row's values are used.

**Import the sheet**

* Tick **Retrieve From Excel**. The **Lot Wise Scheme - Excel Import** window opens.
* Click the **...** button next to **File Path** and choose the Excel file.
* Select the sheet in **Select Sheet** and enter the **Header Row** (normally **1**).
* Click **Help** to see the column names this window expects (\* = required).
* Tick **Overwrite Existing Data** to replace all the lots already in the window with the sheet. Leave it unticked to add the sheet to the existing lots - a lot already in the window takes the sheet's values.
* Click **Ok**.

The lots are added to the grid. A row is skipped when its item code, lot or piece number is not found, or when it has no scheme or discount value. If any row is skipped, the **Excel Import Log** lists each skipped Excel row and the reason, with the number of rows imported and skipped.

The import checks that each item and lot exist. Make sure the sheet holds only the scheme's items.

***

### **Save the scheme**

* Click **Ok** in the **Lot Wise Scheme** window to return to **Scheme Details**.
* Click **Save** on the **Scheme Details** tab and answer **Yes** to *Save Data..?*. The lots are saved with the slab.
* Click **Cancel** in the window to close it without keeping the changes.

***

### **How the scheme works in a bill**

Lot wise slabs work when schemes are applied in a **Sale Bill**. They are not applied in a **Sale Order**.

* The bill takes the **highest slab** whose quantity is reached by the bill's total (for a quantity based scheme).
* Only the lots in the **chosen slab's** list get its discount, at the value entered for that lot. A lot that is not in that slab's list gets no discount from the slab.
* When **every** slab of a scheme date is a lot wise slab, only lots that appear in the list of at least one slab of that date **count towards the slab quantity**. Other lots of the same item do not lift the bill to a higher slab.
* If any slab of the date is not a lot wise slab, all lots of the scheme's items count towards the slab quantity.

> **Example - Buy 1 get 30% off, Buy 2 get 40% off, on selected lots**
>
> Asha sets up a scheme for the item Kurta. Slab **1** has lots **K-101** and **K-102** with **TD 30**. Slab **2** has the same two lots with **TD 40**.
>
> * A customer buys one piece of lot K-101: slab 1 applies and K-101 gets **30%** off.
> * A customer buys one piece each of K-101 and K-102: two offer lots, so slab 2 applies and **both** get **40%** off.
> * A customer buys one piece of K-101 and one piece of lot K-205, which is not in the offer: only K-101 counts, so slab 1 applies. K-101 gets **30%** off and K-205 gets no discount.
>
> Enter the lots in both slabs: a lot listed only in slab 2 gets no discount when the bill falls in slab 1.

***

### **Messages you may see**

| Message                                                                         | What to do                                                                                                                                         |
| ------------------------------------------------------------------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------- |
| Invalid Item Name                                                               | No item is selected in the row. Select the item.                                                                                                   |
| Invalid Lot Number / Invalid Lot Code                                           | No lot is entered in the row. Select the lot.                                                                                                      |
| Invalid Lot Code....                                                            | None of the lots picked with Select Lot Codes could be added. Check the lots picked.                                                               |
| Item With Same Lot Number already exist (or Lot Code / Lot Code + Pcs No.)      | The lot is already in this slab's list. Change the existing row instead.                                                                           |
| Invalid Scheme Values OR Discounts,Please Define Atleast One ...                | Enter at least one of Scheme/Unit, Scheme Rs, CD, TD or SPCD in the row.                                                                           |
| Commission Percent Can not be greatre then 100                                  | The value entered with F2 is more than 100.                                                                                                        |
| Please Select File to Continue...                                               | No file was chosen in the Excel Import window. Choose the file first.                                                                              |
| LOT NUMBER / LOT CODE / LOT CODE-PCS NO. column not found in the Excel sheet... | The sheet has an ITEM CODE header but no column for the lot, as chosen in Barcode As. Nothing is imported. Add the lot column with the name shown. |
| No rows found in the Excel sheet...                                             | The row just below the Header Row has no item code. Check the sheet and the Header Row.                                                            |


---

# 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/configurations/setup-schemes/setup-schemes-lot-wise-scheme.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.
