Show TOC

Process documentationPrice List Creation Locate this document in the navigation structure

 

You enter various price lists into SAP Business One so that the application suggests appropriate item prices for particular transactions.

Ten price lists are predefined in SAP Business One. You can add prices to these, change them, or delete them to map your pricing logic in SAP Business One. You can use all or just some of the defined price lists.

In addition, two price lists are automatically created and calculated by SAP Business One and you cannot manually change them:

  • Last Purchase Price

    This price list is automatically updated when an item enters the inventory with its original price.

  • Last Evaluated Price

    The price list is automatically updated after you run the Inventory Valuation simulation report.

    Note Note

    If your company manages nonperpetual inventory, the name of this report is Inventory Valuation Report.

    End of the note.

Process

  1. Define one or more base price lists in which you enter the price of each item. You then refer all the other price lists you define to the base price list, with a particular factor. The advantage of this is that you enter prices once and SAP Business One automatically calculates the valid prices for particular cases according to the base price list.

    Example Example

    You create price list A for regular customers and price list B for customers who make only occasional purchases. The prices in price list B are to be 10% higher. When you define price list B, you refer it to price list A with a factor of 1.1. SAP Business One then chooses the higher price for the occasional customer, whose master data record is assigned price list B.

    End of the example.
  2. To adjust all prices, change them once in the base price list. The changes are made automatically in all of the price lists that refer to the base price list.

  3. To change the ratio of two price lists to each other, change the factor once. In the example above, you could change the factor to 1.15 so that the prices for occasional customers are generally 15% higher than for regular customers.