Price List Relations

The Price List Relations option is available under Options on the menu bar in Maintain Future Price Lists (IM21) only. This option provides you with a visual representation of the master price list (MPL) and all associated price lists from Product Price Lists (ibis_icpl.im18) or Future Price Lists (IM21). Because a MPL can be referenced on multiple non-MPL price lists (contract, special, quote, flyer), this relationship 'table' can be very useful in determining where a MPL is used. The 'Price List Relations' option is available for information purposes only. You cannot modify or change the details of a price list on this screen.

  • In the left panel on the screen, all master price lists are displayed. If there is a plus sign Plus beside a master price list folder, this means that other price lists exist which are related to that master price list, such as flyers, common quotes, specials and contracts. If there is no plus sign beside the master price list, then there are no price lists related to that master price list.

  • To see the price lists that are related to the master price list, click on the plus Plus beside the folder, or double click on the folder with the red arrow. All of the price lists related to that master price list display alphabetically.

  • The following screen capture displays the CA master price list with the related price lists, CAXXX, CAYYY, ENGLISH, RENR and SEARS:

    IM18/IM21 Price List Relations

  • To see the products that are attached to any price list, double click on the yellow folder beside the price list. On the right side of the panel all of the products that belong to that price list are displayed with the product, description, pricing method, quantity break code (QBC) and method value 1 (the first price of the product - there may be more if quantity breaks are allowed).

  • The following screen capture displays products on the CA master price list:

IM18/IM21 Price List Relations

  • The following screen capture displays the products on the ENGLISH price list.

  • This information is useful to determine which related price lists will be impacted by changes that may be made to the master price lists.

  • For example:

    • A master price list contains a product where the price is going to be increased, this might affect any of the related price lists, such as a special or a flyer, where the product has a discount applied to it.

    • A master price list contains a product where the QBC is being changed. Any related price lists using either a discount off the master price list or master price multipliers will be effected.

    • If a master price is deleted, all related price lists must be deleted first.

  • The Maintain Future Price Lists (IM21) program which is used to maintain future prices in existing or new price lists also has the 'Price List Relations' option available. Here, only the live or active master price lists that have related price lists in IM21 are displayed.

  • This is important and useful since changes to the live master price list may also affect the related price lists in the future.

  Back