Price Lists give you a central place to set all promotional Prices, specials and adjustments. This module allows you to set special Selling Prices or adjustments (sales / bargain bins) for Items and Services which are linked to specified Customers or Customer Categories. These Prices will be applied when Items are added to a Sales Quote, Sales Order or to a Point of Sale (POS) Order.

One or more Price Lists can be linked to a Customer and only apply to Selling Prices and, therefore, Transaction Types that use Selling Prices.

When you add an Item to a Transaction, active Price Lists that are linked to the Customer on the Transaction as well as to the Currency of the Transaction, will be queried. If a match is found, it will be used to override the standard Item Price and the default Adjustment.

If both an Adjustment and a Price has been located, then both will be applied.

Discover Price Lists

• Get Started
• Price Lists Setup
• Ranking Order
• Validity - Unit & Currency

Get Started

User Access needs to be granted to access Price Lists Setups. Navigate to Main Menu > Setup > Settings > Users tab > Select a User > Setups Group > Price Lists - Access Allowed.

Price Lists Setup

Navigation

Main Menu > Setup > Price Lists

1. Price Lists Data Grid - This data grid will list all the Price Lists created in the database.
2. Price Lists Setups - Here you are able to set-up Price Lists and add Prices to them.
3. Hide/Show Price Lists Data Grid - Clicking on this arrow button will hide the Price Lists data grid (1).
4. Scroll - These buttons allows you to toggle between Price Lists that exists in the Price Lists data grid (1).
5. New - Clicking this button will create a new Price List, populating the Price Lists data grid (1) with a new row.
6. Copy - This button allows you to copy a Price List. This is handy when you want to create a new Price List similar to an existing Price List. When you copy a Price List all the linked Prices will be copied as well.
7. Menu - The Menu button provides the following additional functionality:
   • Link Customers to Price Lists - This will open a window that allows you to link Customers to available Price Lists. See image below:

You are able to filter the records by Customer Category. Both sides of the dual list will be filtered.

• Delete Price List - This will delete the selected Price Lists. You are not able to delete a Price List if all the linked Prices has not been deleted first.
• Save/ Restore Grid - This allows you to save or restore the data grid.

8. Description - Enter the name of the Price List here.

9. Code - Here you are able to enter a Code to represent the Price List throughout the application.

10. Currency - Here you are able to specify the Currency that applies to the Price List.

11. Adj% - This allows you to add an adjustment percentage to the Price List.

12. Active - This shows whether or not the Price List is in use.

13. Add - Clicking this button will add a Price to the Price List. This will populate the Price data grid with a new row.

14. View History - This allows you view all the changes that has been made on the selected Price List. When this button is clicked, the Prices data grid will change to a History data grid that displays the Date and Time when the change was made as well as the User who made the change. Other fields such as Detail, Unit, Old Price, Old Price VAT, New Price, New Price VAT, Variance and Variance % are also displayed. See image below:

Clicking on the Back button will return you to the Prices data grid.

15. Item Category - This specifies the Item Category.

16. Item - This specifies which Item is selected. If the record applies to all Items within the Item Category, then All can be selected.

17. Unit - This shows the base Unit for the Item.

18. Std. Price (exc) - This shows the Standard Price, excluding VAT.

19. Std. Price (inc) - This shows the Standard Price, including VAT.

20. Type - The different Types that can be used to create Price Lists are:

• Adj % - Prices will be adjusted by a percentage (%).
• Price - This option is used to set a Price and can only be used when a Category, Item and a Unit is selected. The Price can be including or excluding VAT and in different Currencies. The 'Currency' setting on the Price List header determines whether it can be used in any Transaction or only in Transactions with the same Currency.
• Min Adj% - This type enables users to restrict the minimum adjustment (maximum discount) that may be applied to the selected Category, Item or Unit

21. VAT Type - This specifies what VAT Type is used when adding the Price to a Transaction.

22. Currency - Here you are able to specify the Price's Currency.

23. Fixed Price - Fixed Prices can only be set when a specific Item or Service Item has been selected in the Type field.

24. Unit Price - This specifies the Unit Price for the Price record.

25. VAT - Here you are able to specify if the VAT is included or excluded from the Price.

26. /Qty - This allows you to specify the quantity the Price applies to, i.e., Price per quantity.

27. Adj % - This field is used as the markup on the Item's Cost Price. The default Adj% for a Price List can be set on the Price List record. This will be applied to new Prices that are added to the Price List. The Price will be rounded according to the Round setting on the Item from which the Price is updated. If the /Qty field does not match the /Qty field on the Cost/Sell record, the Price won't be updated.

28. Auto Update - Auto Update - Price Lists can be Auto-updated from an Item's Cost Price or from the Selling Price to ensure that existing markups are maintained when Costs change. This only applies to Prices where the Type = Price.

29. Last Updated - This shows the last time the Price was updated.

30. By right-clicking on a Price (or the ellipsis in the last column of the row) provides the following additional functionality:

• View Item Summary - This will open the Item Summary.
• Copy Price - This allows you to copy the selected Price.
• Delete Price - This will delete the selected Price. All Prices must be deleted before you are able to delete the Price list.

Ranking Order

Because there might be instances where duplicate prices exists for an item, a ranking order has been established against which the Price Manager is checked from highest to lowest as follows:

1. Material/Service Item + Customer
2. Material/Service Item + Customer Category
3. Material/Service Category + Customer
4. Material/Service Category + Customer Category

The highest ranking price is the one that will be applied.

Validity - Unit & Currency

Specials for Material Items will only apply when the Item is sold in the same Unit against which the Special is loaded. If a Fixed Price is set, it will only be used if the Currency of the Special matches the Currency of the Transaction.