Purpose
Pre-requisite :-
Before creating a price level, ensure that the configuration for applying prices from the Price List is enabled for Sales Order, Quotation, and Sales Bill.
To enable this setting:
Navigate to Tools → Configuration → Business Configuration → Process Outward
Set “Select Sell Price for Sales Order and Quotation From” to “Price List”
Go to Tools-> Configuration ->Business Configuration ->"Apply Price level" should be mapped to "Sales"
How Price Level Works
Options | Applies To | Usage / Formula |
Mark Up | Cost Price | Used to increase the default selling price based on Cost Price. |
| Net Cost (Landing Cost) | Formula: Selling Price = Landing Cost + (Value or % of Landing Cost) |
| Selling Price | Formula: Selling Price = Selling Price + (Value or % of Selling Price) |
Mark Down | Selling Price / MRP | Used to reduce the default selling price.
|
Steps to define a Price Level :-
1. Navigate to Inventory → Price Fixing → Price Level.
2. Click Add Price level Master.
3.Click Add Price Level Master.
4. Create Price Level Master
Enter the Price Level name.
Select an option from the MarkUp/MarkDown:
MarkUp - to increase the prices
MarkDown - to reduce the prices.
Select an option from the Based on list.
Select either Percentage to adjust the Sell Price by percentage or Value to adjust the Sell Price by the amount.
Click Save.
The Price Level vs Items screen allows you to map items with specific Price Levels to mark up automatically or mark down item prices according to the defined price level settings.
Steps to map Items to Price Level :-
1. From Dashboard, Navigate to Inventory → Price Fixing → Price Level vs Items.
2. Press Enter and select the required Price Level Name from the pop-up list.
3. Repeat the following steps to add all applicable items for the selected Price Level:
In the tabular grid, press Enter and select the Item.
(Optional) Select a Round Off option and specify a Round To value to round fractional price values.
Enter the Mark Up or Mark Down value as per the selected Price Level definition.
Press F6 or click Save to save the mappings.
Select the location to map the Price Level and click Save. A “Data saved successfully” message will appear — click OK to confirm.
Assign the created Price Level to the desired Customer.
Steps to Set the Price Level for Customer :-
After defining the Price Level and Items, set the price level to the customer for whom the modified (marked up or marked down) selling prices should be applied.
To enable the Price List, click Masters → Tools → Master Configuration.
In Search Master, type 'Customer'.
The Customer relevant master screens appear.
Click Edit to enable the control.
Select the Visible checkbox and click Save.
Click Masters → Customer → Click Edit against the Customer for whom you to apply prices defined in the Price Level.
4. After selecting the Item, the below screenshot shows the result after applying the Price Level. Based on the 10% markup, the Selling Price of 45,000 has increased by 4,500, making the new Selling Price 49,500.
5. Press F6 Save to save the bill.
The payment tender screen appears with the default payment option
Each of the letters in the alphabet list indicates the corresponding payment mode.
For example: Press 'A' for Cash, 'C' for Card, 'D' for Cheque and such like.
Click Ok to save the Bill.
Frequently Asked Questions (FAQ )-
Q1. How to map bulk items to price level?
The migration "Price level Vs Item mapping" can be used. Refer the link Migration Process to know about the migration process
Q2. Can created price level be edited?
Yes it can be edited. In the Price level menu, click on F4 or Edit button and load the price level and make the necessary changes and click on save button
Q3. Can Price level be mapped to the items, location wise?
Yes, it is possible by using Price level Vs item mapping migration. Under the field "Location" and "Location status", you can provide the location name and mark the status as Enable or disable.
Q4. Can we change the value of the items mapped to the price level?
Yes, in Price level Vs item mapping screen, you can load the price level and the items mapped to the price level will be listed. The value column will be edited and changes can be done.
Q5. Price level vs item mapped price was not getting applied in the sales bill?
Checklist
1. In "Price level vs Item"- Item were mapped
2. Price level mapped to the "Customer" in the Customer master
3.In Item Master "Item Open type " were mapped as "Open type" then the price level will not applied to the item, Please change it to "None" or "Non-Open" .