Use this tab to specify settings for different aspects of the prices defined in your company, set whether inactive price lists are displayed, and enable removing items with no price from the database. To access this tab, from the SAP Business
One Main Menu, choose: Administration > System Initialization > General Settings > Pricing tab.
Pricing Tab Fields
Remove Unpriced Items from Price List in Database
Select if you want to remove all items with no price from the database. This setting can reduce the database size and affect performance when you are running applications on the database, as with SQL queries and add-ons.
Note: When an item with no price has been defined as “manual” or has a specific factor that is different from the overall price list factors, it will not be removed from the database. For more information about those settings, see [Price Lists Name] Window.
When you deselect this checkbox, all items with no price are inserted into the database.
Note: When this checkbox is selected, SAP Business One removes all items with no price from the database level but still displays all items at the application level. To not display items with no price, including in the application itself, use the setting Hide Unpriced Items, which is located in the selection criteria of the price lists and the reports. For more information about this setting, see Price List – Selection Criteria Window
When modified, this setting is updated immediately per company, for all users.
You can change this company-specific setting at any time.
Display inactive Price Lists in:
Select whether inactive price lists are displayed in the price lists dropdown list, available for choosing in the different forms, as follows:
- Reports – Select this checkbox to include inactive price lists in the selection criteria window of Price Report and of Inventory in Warehouse Report.
- Sales, Purchase and Inventory Documents – Select this checkbox to include inactive price lists in the following windows: Gross Profit of the document window; Form Settings window of sales, purchase, and inventory documents; Inventory Transfer; Inventory Posting; Goods Issue; Issue for Production; Document Drafts report; and Inventory Opening Balance.
- Settings – Select this checkbox to include inactive price lists in the following windows: Document Settings; Special Prices for Business Partners; Period and Volume Discounts; Business Partner Master Data, Payment Terms tab; Customer\Vendor Groups – Setup; Express Configuration Wizard; Item Master Data; Bill of Material; G/L Accounts Revaluation; and Stock Revaluation.
Note: In the Price Lists main form and in the Update Parent Item Prices Globally window, all price lists are always displayed in the price lists dropdown list.
By default, all checkboxes are not selected.
When one or more of the above checkboxes are selected, all price lists, active and inactive, are displayed in the relevant price lists dropdown list. In addition, all inactive price lists appears with the string ‘Inactive’ in the dropdown list, for easy recognition.