|
xTuple ERP Reference Guide |
|
|
xTuple ERP Reference Guide |
| 11.3.1. List Pricing Schedule | ||
|---|---|---|
 | 11.3. List Pricing Schedules |  |
A single list pricing schedule may contain multiple items or product categories—and multiple quantity breaks. To create a new list pricing schedule, select the button. The following screen will appear:
When sales orders are entered, the system will search for quantity break matches between the sales order item and the relevant list pricing schedule. If duplicate quantity breaks are found, the lowest price for the given quantity will be used.
When creating a new list pricing schedule, you are presented with the following options:
Enter the name of the list pricing schedule.
Enter a description to identify the list pricing schedule.
Enter the date when the list pricing schedule becomes effective.
The effectivity and expiration dates for list pricing schedules correspond to the created date for sales orders. Changes to line item quantities or scheduled dates for already-created sales orders can also cause list pricing schedule effectivity to be recalculated as of the date the changes occur.
Enter the date when the list pricing schedule expires.
Display lists all sold items or product categories assigned to this list pricing schedule.
Select the currency.
This field is only enabled when multiple currencies are used.
Select the site to be used for calculating net price when average cost is used as the markup basis.
List pricing schedules are not updated by site. The site indicated here is only used for calculating the net price.
To create a new list pricing schedule item, select the button. The following screen will appear:
When creating a new list pricing schedule item, you are presented with the following options:
Specify which type of list pricing schedule item you want to create: nominal, discount, or freight. The screen will present different options depending on which type option you select.
Select the Nominal option for simple quantity break pricing by item. When the Nominal option is selected, you will be presented with the following choices:
Enter the item number of the item you want to add to the list pricing schedule. The lookup feature located to the right of the field leads to a searchable sold items list. Multiple sold items may be assigned to a single list pricing schedule.
Inventory unit of measure (UOM).
Enter the lowest quantity of the specified item that must be purchased to receive the specified price. The quantity break is measured in the inventory UOM. Multiple quantity breaks may be assigned to a single item.
Enter the price the specified item may be purchased for if the specified quantity break is met. The price is measured in the price unit of measure.
Displays the list price for the specified item.
Specify the UOM to be used when selling the line item. Sold items may be assigned multiple selling UOMs. These alternate UOMs may be defined on the Item master. You may also select a global conversion ratio here. Global conversions have the label Global appended to them. If a line item has no selling UOM defined, then the inventory UOM will be used here by default.
When using a selling UOM for the quantity break, you may not select an alternate price UOM. The reason for this is that selling UOMs use the same UOM for both quantity and pricing.
Specify the price UOM to be used with the specified quantity break UOM. If you select a selling UOM for the qty. UOM, you will not be able to select a price UOM. For selling UOMs, the selling UOM and the price UOM are the same.
Displays the ratio between the price and inventory UOMs for the specified item.
Displays standard cost and actual cost for the specified item.
The margin is determined by the following formula:
Price - Cost / Price.
If the specified item is a configured item, then the tab will be available. Characteristics for configured items can carry their own list prices. These characteristic prices may be added to the base price when configured items are sold. To define characteristic pricing for configured items, select the tab. The following screen will appear:
When defining characteristic pricing for configured items, you are presented with the following options:
List displays all the characteristic prices which have been associated with the list pricing schedule item.
To add a new characteristic pricing item, select the button. The following screen will appear:
When adding a new characteristic pricing item, you are presented with the following options:
Select a characteristic from the list of item characteristics defined for the specified item.
Select a value from the list of values defined for the specified item characteristic.
Enter a new price for the characteristic and value combination. This alternate price will be used in place of the standard characteristic list price when the list pricing schedule is used.
Displays the default list price for the item characteristic. The list price for characteristics is added to the base price of sales order items when the characteristic is specified at sales order entry time. List pricing schedules are designed to override standard list prices.
Select the Discount option for fixed amount or percentage based discount pricing by item. For list pricing schedules, only discounting by item is available. Discounting by product category is not available for list pricing schedules. To enter discounts by item, select the Item option. The following screen will appear:
When discounting by item, you will be presented with the following options:
Specify the item you want to add to the list pricing schedule.
Enter the lowest quantity that must be purchased to receive the specified discount.
Enter the discount percentage off list price to be used when the specified quantity break is reached.
Enter the fixed amount you want to be discounted off the list price. If a discount percentage is also used, the fixed amount will be subtracted after the discount percentage. However, the price can never go below zero.
Select the Markup option to calculate the price as a markup on the wholesale price.
When the Markup option is selected, you will be presented with the following choices:
Select this option if the markup depends on the item that is selected. You will be prompted for the item number.
Enter the item number this list pricing schedule item will be applied to.
Markup by product category is not available for list pricing schedules.
Enter the lowest quantity that must be purchased for the specified markup to be applied.
Enter the markup percent that needs to be added to the inventory cost.
Enter the fixed amount the inventory cost will be increased by.
The inventory cost will be increased with the sum of the markup percent and the fixed amount.
| |  | |
| 11.3. List Pricing Schedules |  | 11.4. Update List Pricing Schedules |