Sales Price List
The Sales Price List page shows all price lists in both Active and Inactive status, providing comprehensive price management for retail locations.
Price List Status
Active Price Lists
- Each retail location can have only one active price list
- Business Central always uses prices from the active price list
- Active price lists are used for all price calculations
Inactive Price Lists
- Contain prices that were valid before activation of a new price list
- Prices from inactive price lists are not used in calculations
- Maintained for historical reference and audit purposes
Configuration
Price List Number Series
Price List numbers are configured on the Sales and Receivables Setup page.
Creating a New Price List
When you click New on the Sales Price Lists page, fill in the following fields:
General Information
Code
- Source: Assigned from the configured number series
- Format: Automatically generated
Description
- Purpose: Specifies the description of the price list
- Usage: Identifies the price list purpose and period
Assignment Configuration
Assign-to Type
- Value: Always use Customer Price Group
- Note: This is also added to the customer card
Assign-to No
- Purpose: Determines the code of the customer price group
- Usage: Links the price list to specific customer groups
VAT Configuration
VAT Bus. Posting Gr. (Price)
- Purpose: Specifies the default VAT business posting group code
Price Includes VAT
- Purpose: Specifies if prices include VAT
- Options: Yes/No
Price List Type
View Columns for
- Purpose: Determines the type of price list
- Options: Price, Price and Discount
Status Management
Status
Indicates the current state of the price list:
- Draft: Editing is allowed, price list is not used
- Inactive: Editing or usage is not possible
- Active: Editing can be enabled, price list is used for price calculations
Validity Period
Currency Code
- Purpose: Determines the currency code of the price list
Starting Date
- Purpose: Specifies the date from which the price list is valid
- Note: Validity dates of price lists at the same location must not overlap
Ending Date
- Purpose: Specifies the last date until which the price list is valid
- Example: End date of previous price list: 31.05.2024, start date of new price list: 01.06.2024
Discount Configuration
Allow Invoice Discount
- Purpose: Determines whether invoice discount is allowed
- Flexibility: Value can be changed in the lines
Allow Line Discount
- Purpose: Determines whether line discounts are allowed
- Flexibility: Value can be changed in the lines
Location Assignment
Retail Location
- Purpose: Specifies the retail location for which the price list is used
- Restriction: A retail location cannot have more than one active price list
Important Notes
Customer Price Group Recommendations
We recommend that each customer price group be associated with a single location.
Cross-Location Usage
Although a customer price group from one location can be used for other locations:
- Business Central recognizes prices based on both location and customer price group
- A customer price group assigned to another location does not contain the same items
- Violating this rule will cause Business Central to report an error
Best Practice
Maintain separate customer price groups for each location to avoid conflicts and ensure proper price recognition.