QAD 2017 Enterprise Edition > User Guides > Master Data > Pricing > Using List/Discount Table Pricing > Creating Price Lists
  
Creating Price Lists
You must define separate price lists using the appropriate menu function:
Use Supplier Price List Maintenance (1.10.2.1) to set up price lists for POs, blanket orders, purchase requisitions, and supplier scheduled orders.
Use Cust Sched Price List Maint (1.10.3.1) to set up price lists for customer schedules and RMA receipts.
Note: You cannot have the same price list name in both classifications.
When entering an item on an order, the system looks for a matching price list in the following order:
1 Currency, price list, item number, unit of measure
2 Currency, price list, item number
3 Currency, price list, product line (with item number blank)
4 Currency, price list (with product line and item number blank)
If no match is found, the item base price displays, converted to the currency of the order.
The system uses price list defaults when you create new orders. Default price lists are derived in different ways, depending on the kind of transaction:
Purchase Orders: Price lists are associated with suppliers in Supplier Maintenance (2.3.1) and provide defaults when purchase orders, blanket orders, and supplier scheduled orders are created.
Discrete POs can have two types of lists—price lists and discount tables—assigned to them. Both types can be defined for the supplier and default to all order types, except supplier scheduled orders. Supplier scheduled orders can only have discount tables.
Customer Scheduled Orders: Price lists are associated with customers in Customer Maintenance (2.1.1) and provide defaults when customer scheduled orders are created.
Return Material Authorizations: A credit price list is associated with warranty and contract types. This price list provides the default in RMA Maintenance (11.7.1.1) and is used for RMA receipt line credits.
Only one price structure can be applied to each order. You cannot set up a price list with base prices in a foreign currency and then access another price list to apply quantity discounts to those foreign currency prices.
You can create price lists and discount tables under the same pricing code. If you do, remember to consider the following. If you create minimum or maximum price ranges, you must ensure that they include any range set on the associated discount table. This is because the minimum and maximum prices on price tables take precedence over discount table prices.
Different price structures can be entered for specific units of measure. This enables you to set up discounts so that if, for example, you buy a case (CS), you get a better price than if you buy only one unit (EA).
Total This Level GL Cost and Total GL Cost are display-only fields. The categories whose elements are included are material, labor, burden, and subcontract. Total GL cost is the total GL cost for the item’s default site. It includes all cost elements for this level and lower levels. Total This Level GL Cost is used as the default purchase price. It includes this-level costs, excluding any overhead cost elements. Both purchase and selling prices are for one unit of the item using the item unit of measure.
When you create a new price list, you must specify start and end dates; see Supplier Price List Maintenance (1.10.2.1).