Purchase Price List: Items Section

Use this section to add items to a price list and define price for them.

Items section comprises 2 tabs, the Goods tab and the Services tab.
 
Under the Goods tab, you can manually add one or multiple goods to the price list and enter information about them.
 

Goods (number)

Displays/shows the total number of line items added under the Goods tab.
 
To add a service or services, go to the Services tab.
 

Services (number)

Displays/shows the total number of line items added under the Services tab.
 
You add both goods and services as a line item.
 
Line item is a line structure that contains an item and item details. Line item of the price list is comprised of a number of fields, such as item, unit, price.
 
Line item fields are identical for goods and services in the price list.
 
To add a new line item manually, click the +Add new button above the table used for listing added line items. Otherwise, line items are added automatically on click of the Add goods and services button.
 
Line Item Fields
 

Field

Used for

Good/Service

A sales item.

If you add line items manually, select an item (good or service) that from the list of previously created items or create a new one.

Unit

A unit of measurement, whether it is a piece, a kilogram or a liter, etc.

A base unit of measurement specified for the item is provided automatically. If several units of measurement are defined for an item, you can select one that is most suitable in a particular case. However, this unit will be used only for displaying quantities in the document, all inventory and accounting transactions will use the base unit of measurement into which the selected alternative unit will be converted according to the specified conversion ratio.

  • It is an optional field. You use it only if you want the indicated price to be set for/ linked to a specific unit of measurement.  Otherwise, the price set will be linked to the item’s default unit of measurement specified in the item’s data.  
  • You can define different prices for the item’s different units of measurement. To do that, you have to add one and the same item as a line item several times to the price list, select different units of measurement for the line items and set prices for them. The prices will be linked to the item’s units of measurement.

Old price in current currency

Item price as indicated in the base price list from which the item was retrieved.

  • Old price is provided in the currency of the current price list. 
  • The field is calculated automatically for informational purposes only; it is disabled for editing and cannot be overridden.
  • The field appears if the Based on sales prices option is selected in the field Type of price list.

Purchase price in current currency

Item cost as indicated in the purchase quotation from which the item was retrieved.

  • Quotation price is provided in the currency of the current price list. 
  • The field is calculated automatically for informational purposes only; it is disabled for editing and cannot be overridden.
  • The field appears if the Based on purchase prices option is selected in the field Type of price list.

Change, %

Price change percentage. It is the percentage of change from the old price of an item to the new one.

The field is useful only for items that have already appeared in previously created price lists.

You can either enter price percentage in this field, then the new price will be automatically calculated according to the following formula:


New Price = Old Price x (100% + Change %)

 

Or, when you manually enter a new price, the change percentage is automatically worked out.

If you set a common change percentage for all items in the Change,% field in the general area, the specified percentage will be displayed in this field as well. However, you can change it for a specific item if necessary.

  • The field appears if the Based on sales prices option is selected in the field Type of price list.

Mark-up, %

Mark-up percentage. Mark up is the ratio between the cost of an item and its sales price./The mark-up is a percentage over the cost of an item.

The field is useful only for items retrieved from purchase quotations.

You can either enter a mark-up percentage in this field, and then the new price will be automatically calculated according to the following formula:


New Price = Price from purchase order x (100% + Change %) 


Or, when you manually enter a new price, the mark-up percentage is automatically worked out.

If you set a common mark-up percentage for all items in the Mark-up,% field in the general area, the specified percentage will be displayed in this field as well. However, you can change it for a specific item if necessary.

  • The field appears if the Based on purchase prices option is selected in the field Type of price list.

New price/Sales price

Sales price of the item.

You can enter it manually for each item or it can be calculated automatically based on the price change percentage/ mark-up percentage specified.

 
You can also automatically add all items recorded in the system to the Items section. To do that, select the For all items as a type of price list.
 
Advanced line item fields 
 
Not all line item fields are displayed by default. To enable such fields, you have to turn on the extended mode for line item by clicking the More button above the list of items. On enabling the extended mode, the following fields appear: 
 

Field

Used for

Date of old price/Date of purchase price

Date when a price retrieved from the base list or the purchase quotation was defined.

Date when the old price was set.

  • This date is provided automatically for informational purposes only; it is disabled for editing and cannot be overridden.

Old price document

The base price list from which the item was retrieved. 

  • The field appears if the Based on sales prices option is selected in the field Type of price list.
 

Currency of old price

Currency in which item price was indicated in the base price list.  

  • The field appears if the Based on sales prices option is selected in the field Type of price list.

Old price

   Item price in the currency of the base price list from which it was retrieved.
  • The field is calculated automatically for informational purposes only; it is disabled for editing and cannot be overridden.
  • The field appears if the Based on sales prices option is selected in the field Type of price list.

Purchase quotation

   The purchase quotation from which the item was retrieved. 
  • The field appears if the Based on purchase prices option is selected in the field Type of price list.

Currency of purchase

Currency in which item price was indicated in the purchase quotation.  

  • The field appears if the Based on purchase prices option is selected in the field Type of price list.

Purchase price

Item cost in the currency of the purchase quotation from which it was retrieved.

  • The field is calculated automatically for informational purposes only; it is disabled for editing and cannot be overridden.
  • The field appears if the Based on purchase prices option is selected in the field Type of price list.
 
If you want to turn off the extended mode, click the Less button.
Note: After turning off the extended mode, advanced item details will persist.

More information