In SAP Business One you can update price lists by any of the following methods:
Updating entire price lists
Updating prices by selection
Updating prices manually
These methods are described in the sections below.
Note
When you update a price list that is a base price list for other price lists, the prices in those lists change accordingly. In the case of an independent price list, the factor reverts to 1 after you update.
From the SAP Business One Main Menu, choose
.In the Price Lists window, in the upper left area, select the Update Entire Price List radio button.
In the row of the price list you want to update, change any of the following:
In the Price List Name column, enter a name.
In the Base Price List column, in the dropdown list, select a price list.
In the Factor column, enter the factor by which the base price list is multiplied to calculate the prices in the selected price list.
In the Rounding Method column, in the dropdown list, select a rounding method.
In the Authorization Group column, in the dropdown list, select an authorization group.
Double-click the row of the price list whose entire list of items you want to update.
In the [Price Lists Name] Window, in the Unit Price column, make the required changes, and choose the Update button.
Note
If you have updated an independent price list, in the Price Lists window, in the row of the new price list, in the Factor column, the factor again appears as 1, since the price list is based on itself.
Choose the OK button.
In this procedure, you update the item prices only in the selected range. Other item prices do not change.
Example
The Peaches and Cream fruit store divides its price lists according to seasonal fruit. The Berries price list requires updating in the winter, when fruit is out of season and the prices must reflect the higher import costs. Annie, the owner, updates the factor from 1 to 1.5.
She selects Update By Selection and chooses the Update button. When the Price List - Selection Criteria window opens, she selects the Berries item group. The new factor applies only to the items belonging to this group. After she chooses the OK button, the berry prices are updated for the selected items and groups only.
Note
When you update the prices of the selected item range, the prices of these items are updated automatically in price lists linked to the current price list.
Note
In the Factor column, the factor displayed is the one defined during the last update.
From the SAP Business One Main Menu, choose
.In the Price Lists window, in the upper left area, select the Update by Selection radio button.
In the row of the price list you want to update, change any of the following:
In the Price List Name column, enter a name.
In the Base Price List column, in the dropdown list, select a price list.
In the Factor column, enter the factor by which the base price list is multiplied to calculate the prices in the selected price list.
In the Rounding Method column, in the dropdown list, select a rounding method.
In the Authorization Group column, in the dropdown list, select an authorization group.
Double-click the row of the price list whose prices you want to update by selection.
In the Price List - Selection Criteria Window, specify the vendors and items you want to update, and choose the OK button.
In the [Price List Name] window, in the Unit Price column, update the unit prices of the items in the list and choose the Update button, then choose the OK button.
In the Price Lists window, choose the OK button.
You may need to define prices for certain items regardless of the ones set by a price list. In this case, you specify a price manually, using one of the following windows described below.
Example
You may want to sell a number of items at a different price because you are running a sales promotion. In this case, you can change the prices in one or all of the price lists.
Item Master Data Window
You can update item unit prices manually in the Item Master Data window.
Note
When you update an item unit price in the Item Master Data window, the price is updated in the price list that is associated with the item. When you update an item price in the Price Lists window, the item unit price in the Item Master Data window is also updated.
In the SAP Business One Main Menu, choose
.In the Item Master Data window, in the general area, do the following:
In the Price List dropdown menu, select the price list to which you want to assign the item.
In the Unit Price field, enter a price.
[Price List Name] Window
From the SAP Business One Main Menu, choose
.In the Price Lists window, use one of the methods shown above to open the [Price List Name] window.
Update the relevant fields. For more information about the fields in the [Price Lists Name] window, see [Price Lists Name] Window.
Choose the Update button, then choose the OK button.
Bill of Materials Window
You can update item unit prices manually in the Bill of Materials window.
In the SAP Business One Main Menu, choose
.In the Bill of Materials window, in the Unit Price column, enter a price.
Choose the Update button, and then choose the OK button.