Price Level

Price Level

Purpose  

The Price Level feature allows you to define specific pricing levels that automatically adjust the selling price (either increase or decrease) for selected customers.
Once a price level is created, use the Price Level vs Items screen to map items with their respective price levels to apply the markup or markdown settings.
After defining the price levels and mapping the items, assign the corresponding price level to the customer. The adjusted (marked-up or marked-down) selling prices will automatically apply in the Sales Bill screen for that customer.

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.
Formula: Selling Price = Cost Price + (Value or % of 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.
Formula:
Selling Price = Selling Price - (Value or % of Selling Price)
or
Selling Price = MRP - (Value or % of MRP)

 

 

 

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.



Price Level Vs Items

Purpose   

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.

  1. To enable the Price List, click Masters → Tools → Master Configuration.

  2. In Search Master, type 'Customer'.
    The Customer relevant master screens appear.

  3. Click Edit to enable the control.

  1. Select the Visible checkbox and click Save.

  2. Click Masters → Customer → Click Edit against the Customer for whom you to apply prices defined in the Price Level.

  

 6. On the Others tab, select the Price Level from the dropdown list and click Update.


The Sales module screens will apply the marked up Sell Price as shown below:

Steps to map the Price Level to the customer :-

1. Navigate to Sales → Sales Bill.

 

2. Press ENTER and select the Customer.

 

3.Press ENTER and select the Item name. In the list of values (LOV), if the Selling Price is ₹45,000, the below screenshot shows the price before applying the Price Level (i.e., the Selling Price of the item is ₹45,000).

 

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

 


    • Related Articles

    • Price Level Advance

      Price Level Advance Purpose: The Price Level Advance module allows you to create and manage price levels for items based on different states or branches. This helps you control which price level should be applied automatically during billing for each ...
    • Price Level Master Migration

      Price Level Master Migration Price Level Master Migration Purpose : Price levels allow you to set multiple pricing options for each inventory item. Each customer can be assigned a specific price level, which determines the default item price that ...
    • Item Price Change

      Purpose: The Item Price Change feature in TruePOS allows businesses to modify the prices of their products with ease and precision. This feature ensures seamless price updates across all relevant points of sale, helping businesses stay competitive ...
    • Ingredient Price Update

      Ingredient Price Update Purpose:You can now update the price of Ingredient items used in Kit items directly from the Inventory module in TruePOS.Additionally, ingredient items can also be printed on bills. Steps Included :- 1.Firstly we have to ...
    • Inventory Conversion

      Inventory Conversion Purpose : The importance of proper inventory management can’t be emphasised enough these days. A good inventory system will provide high visibility of all items right down to the shelf and bin in multiple locations, if necessary. ...