# Configure Flat Item- Wise Discount / Scheme in Scheme Campaigns

**YouTube:** [How to Configure Flat Item-Wise Discount/Scheme in Scheme Campaigns?](https://youtu.be/JqnKDnta5Ds)

## How to Configure Flat Item- Wise Discount / Scheme in Scheme Campaigns?

In this tutorial, we will learn about the **newly added “Scheme Campaign Type” option** in Logic ERP and understand how to configure and use a **Flat Scheme Campaign** with Excel-based item import.

***

### Enable Scheme Campaign Type Column

* Navigate to the **Configuration** menu from the menu bar
* Open **Setup Scheme Campaign**
* Go to **Column Attributes**
* Locate the newly added **Scheme Campaign Type** column

<figure><img src="/files/V8VLHpGhF5mM4bC45eAa" alt=""><figcaption></figcaption></figure>

* **Enable** this column
* Click **Save**

**This option provides two campaign types:**

* **Slab Wise**
* **Flat Scheme**

<figure><img src="/files/G7PtQuNVCyEjZoJoLktp" alt=""><figcaption></figcaption></figure>

***

### Create a New Scheme Campaign

* In the **Setup Scheme Campaign** window:
  * Enter the **Campaign Name**
  * Define the **From Date** and **To Date**
* In **Scheme Campaign Type**, select **Flat Scheme**

<figure><img src="/files/FU39g8ubh21CZ0TwCKoP" alt=""><figcaption></figcaption></figure>

* Click **Save**

***

### Define Scheme Group

* Navigate to the **Group** tab
* Select the newly created **Campaign**
* Enter the **Group Name**
* Select:
  * **Scheme Campaign**&#x20;
  * **Group Name**&#x20;
  * **Scheme Group Type**

<figure><img src="/files/zC5cQO72CENEF8baXEqp" alt=""><figcaption></figcaption></figure>

* Click **Save**

***

### Import Flat Scheme Items via Excel

In the case of a **Flat Scheme Type**, the data needs to be imported through Excel. This allows you to import **multiple items at once**, each with **different discount percentages**, in a single process.

* Open the **Scheme Group** section
* Click on **Import from Excel**
* Use the **Help** option to:
  * View required columns
  * Understand the Excel format

<figure><img src="/files/7V7H5fAk6pSJkmIM02Vk" alt=""><figcaption></figcaption></figure>

**Note:**\
Columns marked with an **asterisk (\*)** are **mandatory**.

***

### Upload Excel File

* Browse and select the **Excel file** from your system
* Choose the correct:
  * **Sheet Name**
  * **Header Row**
* Click **OK**

<figure><img src="/files/Z7fw8l2kL422TWaxRxLL" alt=""><figcaption></figcaption></figure>

* Click **Save**
* Press **Yes** to confirm the import

<figure><img src="/files/yl6IYqpAU8eHc7YbnGf3" alt=""><figcaption></figcaption></figure>

The Excel data is successfully imported into the scheme group.

***

### Apply Scheme in Sales Bill

* Open the **Sales Bill** window
* Initiate a new transaction
* Scan or select an item
* While saving the bill:
  * The **Scheme Selection window** appears
  * Select the appropriate **Flat Scheme**

<figure><img src="/files/A4rTWq81bzbCKc38PVeE" alt=""><figcaption></figcaption></figure>

The discount is automatically applied to the bill.

***

### Item-Specific Discount Validation

* Add another item to the same bill
* Save the bill again

<figure><img src="/files/maNUpyYkbtiXqTC6Fbqs" alt=""><figcaption></figcaption></figure>

Even if the **same scheme** appears:

* A **different discount** is applied if it is defined differently for that item in the Excel sheet

This confirms that **item-wise discount logic** is working correctly under the Flat Scheme.

***

### Conclusion

The newly added **Scheme Campaign Type** option in Logic ERP allows you to:

* Choose between **Slab Wise** and **Flat Scheme** campaigns
* Import bulk items with **different discount rates** via Excel
* Apply schemes dynamically during billing
* Maintain flexibility and accuracy in promotional campaigns

This enhancement makes scheme management more powerful and scalable.


---

# 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/configurations/setup-scheme-campaign/configure-flat-item-wise-discount-scheme-in-scheme-campaigns.md?ask=<question>
```

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.
