Skip to main content

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.