Show TOC

Object documentationPrice Lists Window Locate this document in the navigation structure

 

The window displays price lists defined in SAP Business One. Use the window to get basic information about the prices that are defined for different items.

To open the window, in the SAP Business One Main Menu, choose   Inventory   Price Lists   Price Lists  .

Note Note

This topic documents fields and other elements in this window that either are not self-explanatory or require additional information.

End of the note.
Price Lists Fields
Update Entire Price List

To open the price list window, select the radio button and double-click the number of the price list row . All the items that are associated with the price list appear. To open the Price List - Selection Criteria window, choose the Selection Criteria button.

Update by Selection

To open the Price List - Selection Criteria window, select this radio button and double-click the number of a price list row.

Price List Name

You can enter any name for a price list. The last purchase price list is the only price list whose name you cannot change.

Base Price List

Choose the base price list on the basis of which the prices in this price list are to be calculated.

Factor

Enter the factor by which the base price list is multiplied to calculate the prices in the selected price list.

You can refer all the price lists to a base price list or implement appropriate intermediate levels.

Example Example

You can specify that price list 2 is to be calculated with a factor of 1.5 with respect to price list 1, and price list 3 with a factor of 1.65 with respect to price list 1. Alternatively, you can specify that price list 3 is to be calculated with a factor of 1.1 with respect to price list 2 (factor 1.5 x factor 1.1 = factor 1.65). The result in price list 3 is the same.

End of the example.
Rounding Method

Define the type of rounding used for calculating the prices on the basis of the base price list and the factor.

Note Note

The rounding method is calculated for a single item and not for the total.

End of the note.

The following options are available from the dropdown list:

  • No Rounding

  • Round to Full Decimal Amount

  • Round to Full Amount

  • Round to Full Tens Amount

Group

A price list is assigned to a group. Using the group, you can control the access rights when maintaining a price list.

Note Note

Only authorized users can maintain a price list. For more information, see Authorizations

End of the note.
Country-Specific Fields: China, Japan, Korea

SAP Business One lets you maintain and use gross price lists in these localizations. If you select the Gross Price checkbox as described in the procedure below, the Price List window includes an additional column: Gross Price.

Procedure
  1. From the SAP Business One Main Menu, choose   Inventory   Price Lists   Price Lists  .

  2. Double-click the row number of the price list to which you want to add the Gross Price column.

  3. To define the price list for gross price, in the [Price List Name] window, select the Gross Price checkbox.

    Note Note

    By default, the Gross Price checkbox is deselected and the price list is set to net price.

    End of the note.
  4. Choose the Update button and then choose the OK button.

Result

Note Note

In the [Price List Name] window, the Gross Price column appears.

To use gross prices for business partners, set a gross price list as the default for a business partner’s payment terms in the Business Partner Master Data window, on the Payment Terms tab. The gross price then appears in the Total(LC) field in sales and purchasing documents.

End of the note.