Price List Review

This program lets you review and update price lists, giving you the ability to increase or decrease prices by a percentage or value.

You can create a new price list based on the cost of a stock code, as well as the prices of an existing price list.

Exploring

Things you can do in this program include:

  • Create a new price list (from an existing price list)

  • Update an existing price list

  • Update the status of a price list

  • Link the price list to a price group

This program is accessed from the Program List of the SYSPRO menu:

  • Program List > Sales Orders > Pricing Engine > Transaction Processing

The pricing engine is used to create flexible, multi-level pricing structures to manage a wide variety of price rules and methods. To facilitate this, a customer is linked to a price group which contains price rules. Price rules may refer to price lists or other configurations like invoice discounts or order discount breaks. Price lists can be created for stock codes, product classes, departments and price categories.

A stock code can exist on multiple price lists, which can have different price methods defined (e.g. flat price, price less %, etc.). In addition, multiple price lists can be linked to one price group, where each price list functions as a price rule.

The pricing method determines what price the system must use for a sales order line as well as the discounts applicable to the sales order lines and total merchandise value.

The pricing method for Contract Pricing is defined at company level (Setup Options > Configuration > Distribution > Sales Orders) and against stock items using the Stock Code Maintenance program.

To use the Sales Pricing Engine, your Pricing method must be defined as Price groups at company level (Setup Options > Configuration > Distribution > Sales Orders) and the pricing method must be specified against price lists using the Price List Maintenance program (not against stock items).

Price groups are used to assign prices and discounts to commercial entities (e.g. customers, geographic areas or branches).

Price groups can have multiple price rules, which are linked to price lists.

You can create a hierarchical pricing structure by defining priorities and contracts against price rules. The price rule with the highest priority trumps other price rules and overrides the ‘best price’. When a contract is linked to a price group, it becomes a price rule that is included in the pricing hierarchy.

This indicates a list of prices for a grouping of stock codes, product classes, departments or price categories. A price method is specified for each price list, which may be a flat price, discounted price, or quantity discounted price.

You can define statuses against a price list, such as Blank - Active, R - In review or H - On hold.

Only price lists that have a status of Blank - Active are included when the Price Query determines the best price.

Topics

Sales Pricing Engine

Starting

To use this program, the following setup option(s) must be configured appropriately:

Setup Options > Configuration > Distribution > Sales Orders

  • Pricing method

    This must be defined as Price groups.

You restrict operator access to activities within a program using the Operator Maintenance program.

Controls whether an operator can change the status of a price list in the Price List Maintenance and Price List Review programs.

This is set to denied by default.

You can restrict access to the eSignature transactions within a program at operator, group, role or company level (configured using the Electronic Signature Configuration Setup program).

Electronic Signatures provide security access, transaction logging and event triggering that gives you greater control over your system changes.

Controls access to the New function of the Price List Maintenance program.

Controls access to the addition of price lists in the SO Price List Header Maintenance business object.

Controls access to maintaining price lists in the Price List Maintenance program.

Controls access to the maintenance of price lists in the SO Price List Header Maintenance business object.

Controls access to the Delete function of the Price List Maintenance program.

Controls access to the deletion of price lists in the SO Price List Header Maintenance business object.

Controls access to the addition of price list detail lines in the SO Price List Detail Maintenance business object.

Controls access to the maintenance of price list detail lines in the SO Price List Detail Maintenance business object.

Controls access to the deletion of price list detail lines in the SO Price List Detail Maintenance business object.

The price list status parameter has been added to the applicable Electronic Signatures.

The following configuration options in SYSPRO may affect processing within this program or feature, including whether certain fields and options are accessible.

To use this feature, the following setup option(s) must be enabled:

Setup Options > Configuration > Distribution > Sales Orders

  • Pricing method

    This must be defined as Price groups.

  • Price group level

  • Default uom for order quantity

  • Request uom for order quantity

  • Minimum price percentage above cost

Setup Options > History > Distribution > Inventory

  • Retain history of price changes

Solving

This message is displayed when you attempt to open any of the following programs before the Pricing method setup option has been configured:

  • Price List Maintenance

  • SO Price Group Order Discounts

  • Price Group Maintenance

  • Price List Maintenance

  • Price Query

  • Price List Query

  • Price Group Query

  • Price List Browse

  • Price Group Browse

  • Price List Review

  • Price List Conversion

  • SO Stock Code Price Query by Price List

  • SO Contract Price Maintenance by Price Group

Ensure that the Pricing method setup option is defined as Price Groups within the Setup Options program (Setup Options > Configuration > Distribution > Sales Orders) before attempting to use any of these programs.

Changes made to price list header records can be viewed within the Price List History report (Program List > Sales Orders > Pricing Engine > Reports).

Changes made to price list detail line records can be viewed within the Price List History Detail report (Program List > Sales Orders > Pricing Engine > Reports).

These changes are also recorded within the SorPrcListHdrHist and SorPriceListHist tables, if the Retain history of price changes setup option is enabled (Setup Options > History > Distribution > Inventory).

Using

  • Columns in a listview are sometimes hidden by default. You can reinstate them using the Field Chooser option from the context-sensitive menu (displayed by right-clicking a header column header in the listview). Select and drag the required column to a position in the listview header.

  • Fields on a pane are sometimes removed by default. You can reinstate them using the Field Selector option from the context-sensitive menu (displayed by right-clicking any field in the pane). Select and drag the required fields onto the pane.

    The captions for fields are also sometimes hidden. You can select the Show Captions option from the context-sensitive menu to see a list of them. Click on the relevant caption to reinstate it to the form.

    If the Show Captions option is grayed out, it means no captions are hidden for that form.

  • Press Ctrl+F1 within a listview or form to view a complete list of functions available.

The following indicates the possible status codes that can be assigned to a price list:

Status Description

Blank - Active

This indicates that the price list is effective and will be included when the Price Query determines the best price.

When the effective dates of a price list have lapsed, the status of that price list remains as Blank - Active, however it is no longer considered when determining the best price.

H - On hold

This indicates that a price list is retired and won't be considered when determining the best price.

R - In review

This indicates that the price list was created, but has not yet been used or is currently in the process of being updated.

A price list with this status won't be considered when determining the best price.

Considerations:

  • The status of all existing price lists defaults to Blank - Active.

  • The status of newly created price list using the List price price method, defaults to R - In review.

Referencing

This displays data according to the selection criteria indicated. The function is enabled when you first load the program and then by selecting the Change Criteria option.

This lets you change the currently configured review criteria.

Field Description

Price change

 

Percentage based on

Indicate the cost on which the price change is based:

To base the price change on an existing price list, select a price list that has a pricing method of Flat price or List price.

You can't select a price list that uses the Flat Price for QDB or Price List Less % for QDB pricing methods.

This lets you base the price change on the unit cost of the stock code.

This lets you base the price change on the last cost of the stock code.

This lets you base the price change on the item's bill of materials.

Percentage information

 

Percentage change

This lets you specify the percentage with which you want to increase or decrease the prices within the selected price list.

Increase/decrease

This lets you specify whether you want to increase or decrease the prices within the price list.

Existing price list

 

Price list

This lets you select the price list for which you want to change the prices.

Description

This indicates the description of the price list.

Currency

This indicates the currency of the price list.

Start date

This indicates the start date of the price list.

Expiry date

This indicates the expiry date of the price list.

This field may be blank, as an expiry date is not required for a price list.

Price method

This indicates the pricing method defined against the price list.

Status

This indicates the status of the price list.

Include costing information

Select this option to include costing information in the listview.

Warehouse to use for costs

 

Warehouse

This lets you select the warehouse in which the costing information resides that should be included in the listview data.

Warehouse description

This indicates the description of the warehouse.

Rounding method options

 

Rounding method

Specify whether you want to round off to the nearest decimal or to the nearest value when calculating the new or updated price:

This lets you round the calculated value to the nearest decimal (i.e. from 0-5).

For example:

Old price = 21.00

Percentage increase = 5%

New price = 22.05

If you define the Rounding method as 0-5 decimals and specify 1 at the No of decimals field, then the rounded price is 22.1.

This lets you round off the calculated price to a certain value, that can be specified at the Value field.

For example:

Old price = 21.00

Percentage increase = 5%

New price = 22.05

If you define the Rounding method as Specified value and enter 5 at the Value field, then the rounded price is 20.00, as the value is rounded to the nearest 5.

No. of decimals

This lets you specify the number of decimals to which you want to round off.

Value

This lets you specify the value to which you want to round off.

Stock code

This lets you select specific stock codes for which you want to update the price and is typically used if you don't want to update the pricing for all the stock codes included in the price list.

Product class

This lets you select specific product classes for which you want to update the price and is typically used if you don't want to update the pricing for all the product classes included in the price list.

Department

This lets you select specific departments for which you want to update the price and is typically used if you don't want to update the pricing for all the departments included in the price list.

Price category

This lets you select specific stock codes for which you want to update the price and is typically used if you don't want to update the pricing for all the price categories included in the price list.

This lets you create a new price list from the stock items displayed in the listview.

In the SYSPRO Desktop UI, the Create New Price List and Details window is displayed.

In the SYSPRO Web UI (Avanti), the Price List Maintenance window is displayed.

This lets you update the existing price list with the new prices of the stock items displayed in the listview.

In the SYSPRO Desktop version, the Update Existing Price List and Details window will be displayed.

In the SYSPRO Web UI (Avanti), the Price List Maintenance window will be displayed.

Price lists can't be changed once the status is Blank - Active and when the price list is used for an active price catalog where the Price method is defined as List Price.

This lets you update the status of a price list that currently has a status of R - In review or H - On hold.

You can use the Price List Maintenance program to change the status of an active price list.

Field Description

Stock code

This indicates the stock code for which the price was increased or decreased.

Description

This indicates the description of the stock code.

Product class

This indicates the product class for which the price was increased or decreased.

Old price

This indicates the previous or old price.

If the price is based on an existing price list created in a foreign currency, the price will be converted to the local currency.

Price basis

This indicates the type of unit of measure on which the price list is based (e.g. stocking uom).

Price uom

This indicates the pricing unit of measure of a stock item.

Cost

This indicates the unit cost of a stock item.

Cost uom

This indicates the costing unit of measure of the stock item.

New price

This indicates the newly calculated price (i.e. the price that was calculated after the increase or decrease percentage was applied).

New price % above cost

This indicates the percentage by which the new price exceeds the cost price of the stock item.

Active sales orders

This indicates the number of active sales orders for the stock item.

New GP %

This indicates the gross profit percentage for the stock item after applying the increase or decrease.

Required price % above cost

This indicates the minimum percentage by which the price must exceed the cost, which is defined at the Minimum price percentage above cost setup option.

This saves the details you entered or changed.

Field Description

Price list

When creating a new price list, this lets you indicate a name for the new price list.

The price list name can't be changed when updating an existing price list.

Description

When creating a new price list, this lets you indicate a description for the new price list.

The price list description can't be changed when updating an existing price list.

Currency

This indicates the currency defined against the price list.

Start date

This displays the start date of the price list, which can be updated.

Expiry date

This indicates the date on which the price list expires and is no longer valid.

This is optional, as a price list doesn't necessarily need an expiry date.

Price method

This indicates the price method defined against the price list, which is either List price or Flat price.

When creating a new price list, the price method is inherited from the original price list and can't be changed.

Link new price list to price groups

This lets you link the new price list to the price groups to which the original price list was linked.

This is typically done to ensure that the new price list can be selected when maintaining price groups.

This field is disabled when updating an existing price list, as it is already linked to price groups.

Create price list line if not on file

This lets you create a new price detail line for the stock code in the SorPriceListDetail table, if the line doesn't exist yet.

This field is disabled when creating a new price list, as new detail lines are added by default when a new price list is created.

Status

This indicates the status of the price list, which is Blank - Active by default.

This saves the details you entered or changed.

Field Description

Price list

This indicates the name of the price list.

Description

This displays the description of the price list, which can be updated.

Price method

This indicates the price method defined against the price list.

Currency

This indicates the currency defined against the price list.

Start date

This displays the start date of the price list, which can be updated.

Expiry date

This indicates the date on which the price list expires and is no longer valid.

This is optional, as a price list doesn't necessarily need an expiry date.

Status

This lets you change the status of the price list to R - In review.

This status is selected by default.

A price list with this status won't be considered when determining the best price.

This lets you change the status of the price list to Blank - Active, so that it is included when the Price Query determines the best price.

This lets you change the status of the price list to H - On hold.

A price list with this status won't be considered when determining the best price.