...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
What is Price List?
A Price List is a listing of prices for different products or services. Usually multiple price lists are created to cater to various organization need of maintaining separate price structures for different regions in which the products are sold or for different sales channels; more importantly to different customers. For example - a cheaper price is offered to the customer who makes purchase in all the seasons and a higher price is provided to the customer who purchases only in one season in the whole year.
What is the need for creating Price List?
Price lists tell agents and vendors the selling value of the products or services. The lists of prices tie the unit, product, and pricing details together; so before a price list is created, it must be ensured that the units and products are in place.
...
Expand |
---|
|
Pre-requisitesPrerequisites- The user's role must have the Add application operation enabled for Procurement Sales & Distribution > Setup > Customers > Price List in Admin > Security > User > Roles .
Step-by-step guideFollowing steps are used: - Go to Procurement > Sales & Distribution > Setup > Customers > Price List.
- Click on the Add button open Add Price List window.
Image Added
The following table shows the Field Names and provides a description of their functionality. Field Name | Field Description |
---|
GENERAL |
---|
Price List Name (Mandatory) | Name of new price list to be created. Note:Duplicate names will not be allowed. | Remarks | Any observations/notes may be put down here. | APPLICATION |
---|
Markup | The factor percentage (%) to be calculated on the following Price Type and added to price of applicable items for actual price determination. Applicable Price Types RSP - Retail Sale Price (default option) WSP - Wholesale Price MRP - Maximum Retail Price Standard Rate Effective Rate FIFO Rate Info |
---|
title | Important information |
---|
| - The factor percentage is a mandatory field with following conditions
- Negative value not allowed
- the factor (numeral) by which it will operate on the base value has to be ≦ 100
- Can be zero
- The Price type is also a mandatory field.
|
| Markdown | The factor percentage (%) to be calculated on the following Price Type and subtracted from price of applicable items for actual price determination. Applicable Price Types RSP - Retail Sale Price (default option) WSP - Wholesale Price MRP - Maximum Retail Price Standard Rate Effective Rate FIFO Rate
Info |
---|
title | Important information |
---|
| - The factor percentage is a mandatory field with following conditions
- Negative value not allowed
- the factor (numeral) by which it will operate on the base value has to be ≦ 100
- Can be zero
- The Price type is also a mandatory field.
|
| Dependent Field Description
- Include Tax - This field has five (5) options to choose from
- Do not include - This is the default option; tax is not included in the prices calculated on the basis of this price list.
- Based on selected price type before Markdown - In this option the customers' selected price type is taken into consideration for tax calculation before the price is marked down.
- Based on selected price type after Markdown - In this option the customers' selected price type is taken into consideration for tax calculation after the price is marked down.
- Based on net price before Markdown - In this option the net price is taken into consideration for tax calculation before the price is marked down.
- Based on net price after Markdown - In this option the net price is taken into consideration for tax calculation after the price is marked down.
Note |
---|
| Net Price is calculated by applying the taxes to be charged on the item. |
| Round Off | - The Round Off option is applied to make calculations easier and more practical.
There are four (4) options for this field - Do not Round (default option) Upper Lower Round - If applied - - the round off can be made to Upper i.e. to 3.67 will be upper rounded off to 4
- the round off can be made to Lower i.e. to 3.67 will be lower rounded off to 3
- the round off can be made to Round i.e. to 3.67 will not be rounded off to 3 but will be rounded off to 4 as it is nearer to the actual number. However by the same logic, 3.43 will be rounded to 3 and not 4.
2. Up to multiples of - This optional user input field signifies the multiple to which the value should be rounded; in other words, the rounded value should be divisible by the number given in this field i.e. suppose the value given in Up to multiples of field is 3, then 3.67 will be rounded off to 6 if the round off type is Upper and 3 if the round off type is Lower / Round. The two numbers (6 and 3) are divisible by 3.
Info |
---|
| Round Off is not applicable on Markdown if tax is included in the price calculations. |
| EXCEPTIONS - This block of data displays the assortments on which the default price list factor defined will not be applicable. The factor and the date range specified in the left hand side grid will be applicable on the right hand side assortment. Info |
---|
icon | false |
---|
title | Important information |
---|
| Note : The Markup / Markdown percentage defined in the Application section will be applicable on any item to which this price list is tagged. However, for the items in the assortments defined in the exception list, the markup / markdown factor will be the one defined in the Exceptions section. |
|
---|
Add Row | This button allows the addition of a new row at the end of the exception Earlier the Add Row function added a row to the bottom of the list and the record at the bottom had greater priority. Now the Add Row function will add a row to the top of the list and the record at the top will have greater priority. Tip |
---|
title | New feature from 11.130.0-1.130.0 |
---|
| Note: A very useful feature has been provided - on right clicking the records, you get the option to move the record directly to the top or bottom of the list. |
| Show items | Each row in the Exceptions grid is an assortment, clicking on any assortment and then clicking on this button opens a window to show the items included in that assortment. | Scan Items | When individual items are to be scannedThis button allows to add an item to the Price List - Exception Criteria by scanning its barcode. However, the scanning will be only in Automatic mode as inclusion of quantity is not required. | Copy Exception | Allows to copy exception details from another Price list. | Set Priority | Allows to set the priority for selection of price list exception to items within same date range but having different This button opens a new window to show the priority of the applicability of the various prices in the price list. You can set different priorities for same / different prices of items / assortment criteria for same / different date range. Example Image Added | Date From | The date from which the Price list is applicable. | Behavior of Date From and Date To * At least any one parameter needs to be selected for the assortment, in order to provide Date From / Date To or Factor% or Fixed Price. * Date Range specification is mandatory i.e. if Date From is provided then Date To is mandatory and vice versa * If Date From > Date To then, Price List creation is restricted. | Date To | The date till which the price list is applicable. | Exception Basis | This is the criterion based on which the items are exempted from the price list. | Behavior of Exception Basis As per Master config. - This option allows the flow of standard rate, wholesale price, retail sale price and maximum retail price. In case of this option the base price would be the price type mentioned in the Application section with the Markdown or Markup as defined in the Item Master. For example, if the price type in the Application section of a Price List is RSP, and the RSP for Item A001 is Image Added500; then on selection of the option As per Master config. in the Exception criteria for Item A001; the RSP of Image Added500 will be considered as base price for calculations. Fixed Price - This option allows to set a fixed price for the item within the selected date range. In case of this option the base price would be the price mentioned in the Factor/Price field of the same row as the item or assortment criteria. For example, on selection of the option Fixed Price in the Exception criteria for for Item A001, if the Factor/Price field has a value of Image Added600 - then it will update the base price asImage Added600 and not asImage Added500 on applying the price list within the stipulated date range. Tip |
---|
| Note: The Fixed Price is the final price and no other calculation is possible on it, i.e. no discounts are allowed on the Fixed Price of an item. |
| Factor/ Price (Percentage factor or Fixed Price) | The factor given here will be applicable on the assortments defined in the Exceptions grid. Note: The factor mentioned is always applicable as a percentage In case of particular items, a fixed price may also be mentioned which will be applicable on the item while the price list is applicable for items not in the exception grid. | Behavior of Factor * Saving is not allowed, if assortment criteria has been provided and factor is blank. * Negative figure is not allowed * Factor% cannot be Image Modified100 This field gives the factor based on which the calculations of applicable price, of the item or assortment criteria, would be made in case of Exception Basis option As per Master config. To illustrate, in the above example, if the factor specified is 10, the a discount of 10% will be considered for Item A001 on applying the price list within the stipulated date range. On selecting Exception Basis option Fixed Price, the value given in Factor/Price field is taken as the base price of all applicable price calculations of the item or assortment criteria. For example, on selection of the option Fixed Price in the Exception criteria for for Item A001, if the Factor/Price field has a value of Image Added600 - then it will update the base price asImage Added600 and not asImage Added500 on applying the price list within the stipulated date range. | Assortment | As mentioned before, exception displays the assortments on which the prices will be calculated by a different factor from the price list. It also shows the date ranges through which the exceptional price will be applicable on the respective assortment E.g. suppose | a an agent is invoiced at a 10% markup for all items, but for electronic goods he may be invoiced at a 15% markup by defining exceptions for a particular date range. | Behavior of Division, Section, Department, Article Name - * List has been provided for each field. * Manual input will be validated from the list of values. * Division, Section, Department and Articles will display dependent values in the Lookup, i.e. If division is selected then look-ups for subsequent fields will display values for that Division only * Selection of Section, Department or Article value will auto populate Division, Section and Department respectively * Change in Division, Section or Department will clear the subsequent fields | Retail Price From / Retail Price To | These two (2) fields, coming at the end of the Assortment Criteria, provide the values for the two ends of the price range of the item or Assortment Criteria. Tip |
---|
Note: The range defined here would be for the Price Type selected above, i.e. if RSP is selected as price type in the Application section for markup or markdown calculation: then the price range defined would also be for RSP. |
| FOOTER |
---|
This record is extinct | This check box allows the flexibility of making the price list extinct if they have become obsolete for application. | Save | This button will save the Price List. | Close | This button will close the Add Price List window. |
|
Expand |
---|
|
On selecting a Price List and clicking the Edit option, the Edit Price List window opens, similar to the Add Price List window. Image Added The user can edit any of the details in the window, provided the following conditions are fulfilled: Pre-requisites- The user's role must have the Edit application operation enabled for Procurement > Sales & Distribution > Setup > Customers > Price List in Admin > Security > User > Roles .
Warning |
---|
icon | false |
---|
title | Important information |
---|
| - Modification of 'Price Type' is not allowed if Price List is already tagged in other masters like Customer, Site etc.
- Modification of 'Include Tax' is not allowed if Price List is already tagged in other masters like Customer, Site etc.
- Change of Include Tax from "No" to "Yes" will -
* Delete Multiples of Round Off value. * Will disable the Round Off block. - Change of Tax Included from "Yes" to "No" will -
* Will enable Round Off block . - Modification of Mode, Factor, Round off is allowed even if transaction exists against the price list
- Exceptions can be modified even if transaction exists against the price list.
|
|
Expand |
---|
Pre-requisites
The user's role must have the Delete application operation enabled for Procurement > Setup > Customers > Price List in Admin > Security > User > Roles . |
On selecting a Price List and clicking the Delete option, the software will ask for confirmation. Upon confirmation it will delete the record with the appropriate message. Image Added Warning |
---|
| In case the selected Price List is referred to any document, the Price List cannot be deleted. |
|
...