SO Stock Code Price Query by Price List

This program lets you view price list details for selected stock items.

Exploring

This program can't be run standalone and is accessed from the following program(s):

  • Stock Code Maintenance

    From the Edit hyperlink at the Pricing field within the Additional items section of the Stock Code Details pane.

  • Browse on Stock Codes

    From the Pricing option within the Edit toolbar menu.

  • Inventory Query

    From the Pricing option within the Queries toolbar menu.

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 listing that comprises of 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.

This indicates the lowest sales price available to the customer.

Starting

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

You can restrict operator access to programs by assigning them to roles and applying access control against the role (configured using the Role Management program).

Solving

Follow these steps to set up the sales pricing engine:

  1. Ensure that you have configured the following Electronic Signatures within the Electronic Signature Configuration Setup program:

    • SO Add Price Group
    • SO Change Price Group
    • SO Delete Price Group
    • SO Add Price Group e.net
    • SO Change Price Group e.net
    • SO Delete Price Group e.net
    • SO Add Price Group Rule e.net
    • SO Change Price Group Rule e.net
    • SO Delete Price Group Rule e.net
    • SO Add price list
    • SO Change price list
    • SO Delete price list
    • SO Add price list e.net
    • SO Change price list e.net
    • SO Delete price list e.net
    • SO Add price list details e.net
    • SO Change price list details e.net
    • SO Delete price list details e.net

    This only applies if the Secure by default option in the Global configuration tab is enabled, i.e. Electronic Signatures are denied by default.

  2. Define the Pricing method setup option as Price groups and then select the level at which you want to implement price groups at the Price group level setup option (Setup Options > Configuration > Distribution > Sales Orders).

  3. Create a price list and capture price list details:

    1. Access the Price List Maintenance program.

    2. Create a new price list and capture the price list header information.

    3. Select the Maintain Price List Detail icon to add price list details at the Price List Details Entrylistview.

      Use the Price List Details Selection pane to add a range of items, e.g. stock codes, product classes, etc. to the listview.

    4. Capture all relevant price list information such as discounts, mark-up %, etc.

    5. Save your changes.

  4. Create the price group and price group rules:

    1. Access the Price Group Maintenance program.

    2. Create a new price group and capture the price group header detail.

    3. Add the price group rule detail, such as the price list on which the rule is based, the effective dates and invoice discount at the Price Group Rules listview.

      Maintain invoice discounts using the AR Invoice Discounts program.

    4. Save your changes.

  5. Configure order discount breaks for the price group:

    1. Access the SO Price Group Order Discounts program.

    2. Select the order discount level and the price group for which you want to maintain order discount breaks.

    3. Capture the order discount breaks within the listview.

    4. Save your changes.

  6. Link the customer to a price group:

    This only applies if the Price group level setup option is defined as Customer (Setup Options > Configuration > Distribution > Sales Orders).

    1. Access the Customers program.

    2. Select the price group to which you want to link the customer at the General Details pane.

    3. Save your changes.

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.

  • 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 retrieves the currently highlighted entry into the calling program.

Field Description

Price list

This indicates all the price list(s) for the stock code (i.e. the price lists in which the selected stock code is included).

Description

This indicates the description of the price list.

Price

This displays the list price of the stock code.

When the Sales Pricing Engine is used, the active list price is obtained from the SorPriceListDetail table.

Uom

This indicates the unit of measure of the stock code.

Currency

This indicates the currency of the price list.

Start date

This indicates the date on which the price list comes into effect.

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 indicates the current status of the price list.