Using Price Lists

Setting up your Price lists, assigning them to customers and entering sales invoices

Written By Grainne Reidy (Super Administrator)

Updated at November 21st, 2024

Introduction

Price lists allow you to maintain customised prices. You can create Price Lists with alternative Prices and Price structures and use them for: 

  • Certain groups of Customers: Prices associated with items can vary on a customer-by-customer basis. Once a price list is set up and assigned to a customer record, it overrides any price categories already assigned to that customer account. These prices and discounts will display on any Invoices.
  • Promotions: You can sell specified Products at a different Price for a period. This can also be used to create promotional prices that only apply on specific dates for specific customers.
  • Specific products/services
  • Volume Pricing and Discounting. 

Price Lists cater to different currencies, allowing you to maintain the price of the items in the customer currency. 

Delete

Info

To use price lists, you must set up your browser in IE mode.

See:

Delete

Creating Price Lists

  1. In the blue banner, go to Items > Maintain Price Lists.

  2. Delete

    Info: Our New Look

    If you are using our new look navigation, Maintain Price Lists can be found in the Items tab in the new sidebar. Click the plus icon to select New Price List:


  3. In Maintain Price Lists, you can set up and maintain as many different Price Lists as you wish, each identified by a Code (alphanumeric). The screen shows any previous Price lists set up. Graphical user interface, text, application, email Description automatically generated
  4. To create a new Price List, click New.
  5. Enter a Code and Description for this price list.
  6. Complete the details:
    • Item, Account: You can enter your Items and Customer accounts by entering a "?" into the field and pressing the Tab or Enter key. This displays the full list of your Items / Customers. Alternatively, if you know the code of the Item / Customer, you can enter this and then tab or enter to move to the next field.
    • Description: This comes from the previous step.
    • From Qty: You can enter your minimum quantity from which this special price for the Customer and Item will start.
    • Currency: This is the base currency.
    • Unit Price, Discount: If you enter a value in both fields, you will receive the warning shown below, indicating that you can override a price or add a Discount percentage, but not both. 
    • Start Date, End Date: You can specify a Start Date and an End Date. This can be forever if you want to apply special Prices or Discounts to specific Customers. The Start Date can be in the past. 
    • Active: Tick for this Line to be active and applied to your Sales Invoice.
  7. Click Process.

Editing a Price List Description

  1. Click on the ellipsis next to its code.
  2. Edit the description.  Graphical user interface, application, Word Description automatically generated
  3. Click Process.
Delete

Associating a Customer with a Price List

1. To open the Customer Master Record, go to Sales > Customers and click on the relevant code.  

 

A screenshot of a computer

Description automatically generated

Delete

Info: Our New Look

If you are using our new look navigation, the Customers listing grid can be found in the AR tab in the new sidebar:


 2. In the Finance Settings tab, complete the following fields: 

  • Price Category: This is mandatory and determines which one of the eight Price Categories is for this Customer. It is inherited from Customer Defaults but can be changed at new Customer setup stage. This determines the Price for each Product at Order or Invoice stage, but you can override it at that time. 
  • Price List: This is optional. If left blank, then the Price Category for the Customer determines the Prices at Order/Invoice stage. If, however, it contains a valid entry from the list of Price Lists then the system will use this field to examine the Price List in question to see if a Promotional Price or some other special Price arrangement applies instead. 

 

 

2. Click Save.

Delete

Using Price Lists on Sales Transactions

When you enter the Customer Code, Qty and Unit Price will display the values set up in the Price List.

Graphical user interface, application

Description automatically generated

Delete