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.
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:
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
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.