Setting Up Special Price Levels for Groups of Customers

InventoryGuide > Inventory > Establishing Prices for Your Stock Items > Setting Up Special Price Levels for Groups of Customers

If you want to charge different prices for the same stock items to different categories of customers and you have the Inventory, Accounts Receivable, and Sales modules installed and integrated, you can use a combination of codes in Denali to set up special price levels.

To determine how many Price Level Codes you need to set up, we recommend you print a list of your customers and a list of your stock items to determine how many different customer groups and pricing categories you have. Once you determine this, you can set up the following codes to activate the special price levels. You must set up Price Level Codes in Sales after you establish AR Type Codes and Inventory Codes.

• Add the different AR Type Codes to the affected customer records in Accounts Receivable.

• Apply the proper Inventory Codes and set up your Level List, Level Margin, or Level Markup pricing on stock items in the IN Stock window in Inventory.

• Create the Price Level Codes in the Sales module.

To use price levels, you must select the Level List, Level Margin, or Level Markup pricing types for the stock item and set the different price levels.

The system combines the Type Code on the customer record with the Inventory Code on the stock item. It then compares this combination to the Price Level Codes in the Sales module. If it finds a match, it charges the price from the Price Level Code. For example, if the Price Level Code specifies Level 3, the system charges the Level 3 price for the stock item. Your Level 1 price should always be the highest price because if there is no Price Level Code match, the system automatically assigns the Level 1 price by default.

Example: Using Price Level Codes in a Bookstore
A bookstore has four distinct types of customers and uses many different Inventory Codes. First you will assign your customers Type Codes of no more than six characters in the Accounts Receivable module. This could be something like: Customers who receive the student price – STUDNT Customers who are members of the bookstore club – MEMBER Customers who are employees of the bookstore – EMPLOY Customers who are employees of the government – GOVNMT Inventory Codes allow you to separate your stock items into different categories. This means you can set your pricing so customers receive the pricing level you specify on certain categories of stock items. Now, assume you create the following Inventory Codes: Reference books – REFER Travel books – TRAVEL Fiction books – FCTION Children’s books – CHILDS Then you set up price levels (up to five) for your stock items in the Inventory module. Level 1 is the highest price. You could make your levels something like this: Dictionaries – $40, $35, $30, $25 Travel books – $20, $17, $15 Popular fiction books – $25, $20, $15 In the Sales Price Level Codes window, you will combine the Type Code and the Inventory Code and select a Price Level for the combination. For example, you could create the following Price Level Codes and assign different price levels to each: STUDNT REFER; Price Level 4 – Student will receive the level 4 price on reference books. MEMBER FCTION; Price Level 3 – Members will receive the level 3 price on fiction books. GOVNMT REFER; Price Level 2 – Government employees will receive the level 2 price on reference books.

Example: Using Price Level Codes in a Bookstore

A bookstore has four distinct types of customers and uses many different Inventory Codes.

First you will assign your customers Type Codes of no more than six characters in the Accounts Receivable module. This could be something like:

Customers who receive the student price – STUDNT
Customers who are members of the bookstore club – MEMBER
Customers who are employees of the bookstore – EMPLOY

Customers who are employees of the government – GOVNMT

Inventory Codes allow you to separate your stock items into different categories. This means you can set your pricing so customers receive the pricing level you specify on certain categories of stock items. Now, assume you create the following Inventory Codes:

Reference books – REFER

Travel books – TRAVEL

Fiction books – FCTION

Children’s books – CHILDS

Then you set up price levels (up to five) for your stock items in the Inventory module. Level 1 is the highest price. You could make your levels something like this:

Dictionaries – $40, $35, $30, $25

Travel books – $20, $17, $15

Popular fiction books – $25, $20, $15

In the Sales Price Level Codes window, you will combine the Type Code and the Inventory Code and select a Price Level for the combination. For example, you could create the following Price Level Codes and assign different price levels to each:

STUDNT REFER; Price Level 4 – Student will receive the level 4 price on reference books.

MEMBER FCTION; Price Level 3 – Members will receive the level 3 price on fiction books.

GOVNMT REFER; Price Level 2 – Government employees will receive the level 2 price on reference books.

Published date: 12/21/2020