This function is used to manage (create, modifiy or delete) price lists codes for the current site.

Definition of a price list: a price list represents the rating of a price list code (hence of a heading) over a given validity period. It is possible to create several Price lists for a single heading. On the other hand validity periods cannot overlap.

    There are three main Price list types:
  • A "fixed" Price list (for the 'fixed' heading): this price list is characterized by a fixed amount.
  • A "Proportional" Price list (for headings of Table or Statistics type): this price list is characterized by a fixed (optional) amount to which a price list is added depending on the tariff bracket corresponding to the measured value.
  • A Price "by bracket" (for headings of Table or Statistics type): this price list is also characterized by a fixed (optional) amount to which a price list by bracket is added.

This function is part of the optional invoicing module for Logistics Services (GEOPLO).

    Prerequisite

    SEEREFERTTO Refer to documentation Implementation

    Screen management

      The screen is made up of:
    • a left list containing the Price lists existing for the current site.
    • A part on the right-hand side with:
      • The Price list header specifying its main characteristics (code, validity period, Type, fixed amount, etc.)
      • 1 table to define the price list brackets.

      Notes on the management rules of services:
    • Modification Mode: a price list can only be modified if all associated invoices are validated.
    • Deletion Mode: a price list can only be deleted if it is no longer associated with any invoices of the current folder (there is no control of the history folder).

    Entry screen

    Presentation

     

    Close

     

    Fields

    The following fields are present on this tab :

    Block number 1

    • Price list (field IPHCOD)

    Indicates a price list name.

    For information, a price list defines a price setting for a price list code on a given validity period.

    • Description (field IPHDESAXX)

     

    Price-list code used to calculate the field amount in the GEOPLO functionality (logistic service pre-invoicing module).

    Section code defined in GEODE section table.

    This section is a service invoicing element such as "the number of DN shipped", "the number of parcel shipped", "the weight of pallets received", etc.

    • Type (field IPHTYP)

    This parameter specifies the price list type. The 3 following types are available:

    • Fixed: a fixed price list is associated with a fixed amount only.
    • Proportional: a proportional price list is associated with a fixed amount plus a price list depending on the tariff bracket corresponding to the measured value.
    • By bracket: it is a price list with a fixed amount plus a price list by bracket.

    Example of calculation of a proportional price list: Let us consider the measured value of a heading equal to 15 Parcels, and the following price list: fixed amount of 10 Euros
    Bracket 1: from 1 to 10 parcels, Unit Price = 5 Euro/parcel
    Bracket 2: from 11 to 20 parcels, Unit Price = 3 Euro/parcel
    Bracket 3: from 21 to 999,999 parcels, Unit Price = 2 Euro/parcel
    If measured value = 15 parcels, Price list = 10 + 15 * 3 = 55 Euros
    If measured value = 25 parcels, Price list = 10 + 25 * 2 = 60 Euros
    Example of calculation of a price list by bracket: Let us consider the measured value of a heading equal to 15 Parcels, and the following price list: fixed amount of 10 Euros
    Bracket 1: from 1 to 10 parcels, Unit Price = 5 Euro/parcel
    Bracket 2: from 11 to 20 parcels, Unit Price = 3 Euro/parcel
    Bracket 3: from 21 to 999,999 parcels, Unit Price = 2 Euro/parcel
    If measured value = 6 parcels, Price list = 10 + 6 * 3 = 40 Euros
    If measured value = 15 parcels, Price list = 10 + 10 * 5 + 5 * 3 = 75 Euros
    If measured value = 25 parcels, Price list = 10 + 10 * 5 + 10 * 3 + 5 * 2 = 100 Euros

    Block number 2

    • Valid from (field IPHSTRDAT)

    Indicates the start date of the price list validity period.

    • Valid to (field IPHENDDAT)

    Indicates the end date of the price list validity period.

    • Contract (field IPHFIXAMT)

    Indicates the flat fee amount of this price list. This amount is compulsory for the price lists linked to a flat fee-type field. It is optional for the other types (Table, Statistics).

     

    Grid Price classes

    • field BKT0

     

    • field BKT

    These are the price list brackets. A price list bracket is defined by a low and a high range as well as a unitary price. In the case of a price list linked to a field that is not fixed (Table or Statistics), it is compulsory to create at least one bracket.

    • Unit price (field BKTPRI)

    Unitary price of the bracket price unit.

    • Price unit (field BKTUOS)

     

    Close

     

    Error messages

    In addition to the generic error messages, the following messages can appear during the entry :

    Price list period overlapping prohibited: XXX

    the validity period overlapps the validity period of Price list XXX.

    Tables used

    SEEREFERTTO Refer to documentation Implementation