Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

What is Price List?

...

Expand
titleAdd Price List

Pre-requisites

  1. The user's role must have the Add application operation enabled for Procurement > Setup > Customers > Price List in Admin > Security > User > Roles .

Step-by-step guide

Following steps are used:

  1. Go to Procurement > Setup > Customers > Price List.

  2. Click on the Add button open Add Price List window

The following table shows the Field Names and provides a description of their functionality.

Field NameField Description
GENERAL
Price List Name (Mandatory)

Name of new price list to be created.

Note:Duplicate names will not be allowed.

RemarksAny 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
titleImportant information
  1. The factor percentage is a mandatory field with following conditions
    1. Negative value not allowed
    2. the factor (numeral) by which it will operate on the base value has to be  100
    3. Can be zero
  2. 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
titleImportant information
  1. The factor percentage is a mandatory field with following conditions
    1. Negative value not allowed
    2. the factor (numeral) by which it will operate on the base value has to be  100
    3. Can be zero
  2. The Price type is also a mandatory field.


Dependent Field Description

  1. Include Tax - This field has five (5) options to choose from
    1. Do not include - This is the default option; tax is not included in the prices calculated on the basis of this price list.
    2. 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.
    3. 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.
    4. 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.
    5. 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
titleWhat is Net Price?

Net Price is calculated by applying the taxes to be charged on the item.


Round Off
  1. 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 -

      1. the round off can be made to Upper i.e. to 3.67 will be upper rounded off to 4
      2. the round off can be made to Lower i.e. to 3.67 will be lower rounded off to 3
      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
titleIMPORTANT

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
iconfalse
titleImportant 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 RowThis button allows the addition of a new row at the end of the exception list.
Show itemsEach 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 ItemsWhen individual items are to be scanned.
Copy ExceptionAllows to copy exception details from another Price list.
Set PriorityAllows to set the priority for selection of price list exception to items within same date range but having different 
Date FromThe 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 ToThe 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.

Fixed Price - This option allows to set a fixed price for the item within the selected date range

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

AssortmentAs 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 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

FOOTER
This record is extinctThis check box allows the flexibility of making the price list extinct if they have become obsolete for application.
SaveThis button will save the Price List.
CloseThis button will close the Add Price List window.



Expand
titleEdit Price List

On selecting a Price List and clicking the Edit option, the Edit Price List window opens, similar to the Add Price List window. The user can edit any of the details in the window, provided the following conditions are fulfilled: 

Pre-requisites

  1. The user's role must have the Edit application operation enabled for Procurement > Setup > Customers > Price List in Admin > Security > User > Roles .

Warning
iconfalse
titleImportant 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.



Pre-requisites

The user's role must have the Delete application operation enabled for Procurement > Setup > Customers > Price List in Admin > Security > User > Roles .
Expand
titleDelete Price List

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.

Warning
titleAlert

In case the selected Price List is referred to any document, the Price List cannot be deleted.


...