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.
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.
Main Menu > Setup > Price Lists
You are able to filter the records by Customer Category. Both sides of the dual list will be filtered.
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:
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:
To update the Item Prices on a Transaction, for instance when the Customer has been changed, use the Menu > Update Prices from Setups functions.
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:
The highest ranking price is the one that will be applied.
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.