Price Query

This program lets you view pricing information to determine the best price and alternatives for a customer, price group and price list.

Exploring

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

  • Program List > Sales Orders > Pricing Engine

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.

The price group level establishes which price groups must be applied for the company.

For example:

If price groups exist for both the customer and geographic area, then this setting determines which price group takes precedence.

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.

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

Setup Options > Configuration > Distribution > Sales Orders

  • Pricing method
  • Price group level

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.

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.

Referencing

This exits the program.

This loads the Preferences form so that you can indicate your preferred selections.

This saves the details you entered or changed.

Field Description

Price preferences

 

Default unit of measure

This lets you define the default unit of measure for the quantity:

  • Stocking unit of measure

  • Alternate unit of measure

  • Other unit of measure

Currency

This lets you define the currency for which you want to view prices.

Warehouse for cost

This lets you indicate the warehouse from which the cost of the item is displayed.

The price's gross profit percentage is based on the cost in the selected warehouse.

This uses the default warehouse defined against your operator code in the Operator Maintenance program.

This uses the default warehouse defined against the customer in the Customers program.

This uses the default distribution warehouse defined against the stock item in the Stock Code Maintenance program.

This uses the default Warehouse to use defined against the stock item in the Stock Code Maintenance program.

This lets you specify the warehouse to use.

Warehouse

This lets you indicate the warehouse from which the cost of the item must be displayed.

Contract preferences

 

Include all contracts

This includes all pricing contracts in the listview.

Expiry - days before

Enter the expiry date (expiry date up to n days before today) up to which you want to include pricing contracts in the listview.

Starting - days ahead

Enter the starting date (starting date within n days of today) from which you want to include pricing contracts in the listview.

TPM preferences

 

Include global trade promotions

This includes global promotions in the listview.

Include unqualified promotions

This includes promotions that the customer did not qualify for.

For example:

This is useful in a 'Buy-5-get-1-free' promotion scenario:

If the customer orders a quantity of 4, then the promotion doesn't apply. If the unqualified promotions are displayed, you can then proactively inform the customer that the order would qualify for the promotion if they increase their order quantity to 5.

Promotion start date

Enter the promotion start date for which to include promotions in the query.

Promotion expiry date

Enter the promotion end date for which to include promotions in the query.

If this is left undefined, then all promotions that haven't expired at the time of running the query are included.

The dates you enter are saved for the current run of the program only.

This commences processing according to your selections and displays the stock codes in the listview.

This refreshes the data displayed.

Field Description

Price selection

Indicate the entity or level for which you want to view pricing information:

  • Customer

  • Price group level

  • Price group

Customer

Indicate the customer for which you want to view pricing information.

Price group level

Indicate the price group level for which you want to view the pricing information:

  • Customer

  • Branch

  • Customer class

  • Geographic area

  • Custom form

Price group

This lets you select the price group for which you want to view the pricing information.

Customer branch

This lets you select the AR branch for which you want to view the pricing information.

Quantity

This lets you select a specific quantity for which you want to view the pricing information.

Transaction date

This lets you select a specific date for which you want to view the pricing information.

Stock codes

This lets you select the stock codes for which you want to view pricing information.

Product classes

This lets you select the product classes for which you want to view pricing information.

Departments

This lets you select the departments for which you want to view pricing information.

Price categories

This lets you select the price categories for which you want to view pricing information.

This pane provides details of the price group, as defined in the Price Group Maintenance program.

This pane provides details of the selected customer, as defined in the Customers program.

The name of this listview pane and its subsequent columns are updated according to the tab that you select.

Stock Codes tab

Column Description

Stock code

This indicates the stock code included in the price group.

Best price

This indicates the best price found for the price group and customer.

Price group rule

This indicates the price group.

Start date

This indicates the start date when the price list came into effect.

Expiry date

This indicates the expiry date of the price list.

Manual price

This displays a Y when the price method is defined as Manual in the Price List Maintenance program.

List price

This displays a Y when the price method is defined as List price in the Price List Maintenance program.

Details

Select the View details hyperlink to open the Price Query by Stock Code program to view more details.

Description

This indicates the description of the stock code.

GP%

This indicates the gross profit percentage for the price, based on the cost in the selected warehouse.

This is calculated as follows:

((Unit cost / Contract price) x 100) - 100

Cost

This indicates the unit cost of the item.

Order Discounts tab

This displays the order level discount break information for the customer and price group.

Column Description

Type

This indicates whether the discounts are based on quantity or value.

Value

This indicates the value on which the discount is based.

Discount 1 - 3

This indicates the discount percentages applied.

Unit of measure

This indicates the unit of measure for a quantity type discount.

Invoice Discounts tab

This displays the invoice discounts for the price group rule within the price group.

Column Description

Code

This indicates the invoice discount code.

Description

This indicates the description of the invoice discount.

Discount 1-3

This indicates the discount percentages applied.

Basis

This indicates the basis price list on which the discounts are calculated.

Price indicator

This indicates how prices are displayed on sales orders:

  • Gross indicates that the total merchandise value is displayed separately from the discount value on a sales order.

  • Net indicates that the merchandise displayed on the sales order includes the discount.