Price List SAP Business One

SAP Business One allows you to list different prices for each item.

During the manufacture of sales and purchase documents, SAP Business One is based on the price of goods directly from the price list related to the requirements of the Business Partner Master Data.

The thing that must be considered in using the price list is to first setup the price to be standardized on the Inventory module = Price list = Price list

When opening the Price list Form there are 2 choices, namely

Update Entire Price list = When you want to fill in the price list, all items will be displayed

Update By Selection = When you want to fill in the price list the parameters will be displayed according to what items you will filter

Price list Name = For Price List 01 ... 10 It's Standard Created by the System, but you can change the Price name according to your needs.

Base Price List = Will be used as the basis for the use of price lists for each transaction, which we must setup on the master data business partner

Factor = Formula that will be used to calculate the base price.

For example Item A is filled with the price of IDR 20,000 and the Factor is filled with 2 then the price to be displayed is IDR 20,000 * 2

Rounding method = To calculate rounding on transactions that use price lists
Authorize Group = To Provide User Authorization on the use of price lists

For example, the Andi User is only registered for Price list Group 1. Andi cannot choose the price list in the other Group other than 1.

SAP Business One only provides up to 4 Groups

To fill in the price list, the button position must be OK, then double click the leftmost column in each price list listed, see the picture below.

If you choose

• The Entire Price list update will display the entire list of items when you double click. the results see the image below

• Update By Selection, the Form will be displayed to fill in the parameters. see the picture below, after you fill click the OK button, then a list of filtered items will be displayed

After Appearing the list of items you can simply fill in the Column in the Price Unit that will be registered.
The Price Unit is default by the System based on the Local Currency.
Example: If you have a local Currency IDR but the price list that you will register is USD, then you must fill in by adding USD before writing the price registered.

The Next Stage Is setup on each Vendor / Customer that is in the Business Partner Master Data Tab Payment Term Then Price list

After setting up the price list and Master Data Business Partner, the results are in the transaction, see the picture below

Things that often occur where the Unit Price that appears is not the same as the Price List inputted due to the use of the UoM Conversion Unit
For example, Storage of Inventory in a warehouse in the KG Unit

Whereas for Sales Using the Lbs Unit

For Purchase Can Be Seen In the Purchase Tab Form Item Master Data

Tweet