This routine configures and maintains a Price List for the use of different selling conditions for one or several products, by using specific sales terms and different criteria, such as region and price range.
To compose discounts and sale price, the system uses the product price as a reference. This price is defined in the product register, in the field Sale Price.
Example of application of a Price List:
Item | Product Code | Product Desc. | Base Price | Sale Price | Discount Value | Factor | State | Range |
001 | 000001 | Computer | 1,000.00 | 900.00 | 100.00 | 0.90 | SP | 500.00 |
002 | 000001 | Computer | 1,000.00 | 850.00 | 150.00 | 0.85 | SP | 999,999.99 |
In this example, the product Computer will have a 10 percent discount on its base price when 500 units are traded in the state of São Paulo. Above 500 units, the discount will be 15 percent.
Besides defining Price List items, you can also determine effective periods, by date and time ranges, and indicate a payment term.
Price Lists are identified by the following colors:
Active List - list within the period selected.
Inactive List - a list becomes inactive when is effective date is due.
Special Active List - list whose effective date was changed manually.
Registration of Last-Minute Sales
You can register the following information in price lists (DA0 and DA1):
DA0 – Header
- Effective initial date and time/Effective final date and time
- Time Type – Single/Recurring
- Active List – Yes/No
DA1 – Items
- Product or Product Group
- Base Price (automatically returns the value of field Sale Price)
- Sale Price (price actually charged in sale)
- Discount/Factor (to be applied to Sale Price field)
- Active (whether the product is active in the grid)
- State
- Operation Type (State, Interstate, etc.)
- Range/Currency
- Effective Period
Since payment term and type are defined only in the end of the concurrent sale process in modules Store Control and Point of Sales, only lists for which payment term and type were not defined are considered. Fields of payment term and type are disabled in module Store Control in the Price List registration screen.
In Assisted Sales and Point of Sales, only State operations are handled.
Possible Scenarios | |
Description | Action |
A single price list with a product informed in the sale. | The rule defined in the price list will be considered and applied to the product item value. |
The product exists in more than one active price list. | To define which price to apply to the product item value, the system considers the parameter that indicates whether the product price must be the highest or the lowest found. |
No active price list found for the product. | The product sale price will be the one registered for the product (field Sale Price). |
No price list available for the product and sale price registered for the product is ZERO. | The system informs that this product cannot be registered because it has no sale price defined. |
Other routines involved in last-minute sale registration are: Discount Rules and Bonus.
When you open a sales transaction, the system checks all the active Price Lists in that moment, not demanding that you query the active Lists whenever a new product is launched. Only after you open a new sales transaction, the system checks again if there are other active Price Lists. To do so, the parameter MV_LJRETVL and an index in DA0 table are required. This new parameter is only configured with the values 1 or 2, where 1 is for the system to find the lowest price of a product among the active Price Lists, and the value 2 is for the highest price. |
Procedures
Creating a price list:
1. In Price List, press [F12] to configure routine parameters.
2. Fill out data according to field help instructions.
3. Check out the following parameter:
- Display by?
This parameter indicates whether information in the screen is displayed by List or Product.
If you choose Product, all tables featuring the product are displayed. That makes easier to view/edit lists which feature the product.
This option allows you only to view/edit the list.
If you choose Table, products can be added to the price list.
4. Check data and confirm them.
5. Select Add.
6. Fill out data according to field help instructions.
Information in this register is self-explanatory. However, refer to the Main Fields/Controls topic for details.
7. Confirm data and new list.
8. Press the down arrow key to add other products to this price list. The same product can be listed several times in the price list, creating ranges of price application and different criteria. Use [DEL] to check/uncheck an item for deletion.
See Also
Visão Geral
Import HTML Content
Conteúdo das Ferramentas
Tarefas