Common data > Logistics tables > Cost structures 

This setup function is used as part of the management of landed costs in the Purchasing module.

The management of landed costs makes it possible to take into account the costs corresponding to the routing of the goods from the supplier to the buyer and to allocate them to the products upon order, receipt or invoice.
The costs that are identified are taken into account in the purchase cost calculation.

Two methods can be used to manage landed costs:

  • A first method based on a landed cost coefficient and/or a fixed cost per unit, which makes it possible to define global costs (undetailed costs).
     
  • A second method based on a cost structure, which make it possible to detail all the costs that are considered as fixed costs and can be easily identified at the time of the purchase.

This function is to be used when applying the second method. It is used to define cost structures by indicating the various costs included in them and by specifying, for each cost, the parameters linked to its calculation mode.

    Prerequisites

    SEEREFERTTO Refer to documentation Implementation

    Screen management

    In this screen it is possible to:

    • Create cost structures.
        
    • Modify an existing cost structure via:
      • the deletion of existing costs, 
      • the addition of new costs,
      • the modification of the information linked to the cost calculation (change in value, calculation basis, etc.).

    In this case, the existing documents in which the cost structure is used are not affected: all the costs and information of the cost structure as it existed at the time of the document entry are stored in the product line.

    • Delete a cost structure provided this cost structure is not already used.
      When a cost structure is used, it can no longer be deleted. In order to prevent it from being used again, it is necessary to deactivate it; to this end, it must no longer be associated with any common data (product category, product, product-supplier and product-site).

    Entry screen

    Fields

    The following fields are present on this tab :

    Block number 1

    • Cost structure (field STCNUM)

    The code of the cost structure is mandatory.

    • If the assignment of the sequence number has been defined as automatic, this field cannot be accessed and the code is assigned upon cost structure creation.
    • If the assignment of the sequence number has been defined as manual, this code can be entered. If it is not entered, it will be automatically specified upon cost structure creation.

    The code assigned to the cost structure depends on the setup of the sequence number assigned to the document of Cost structure type of the Common data module (functions Sequence number Structures and Sequence numberAssignment).

    • field STCDESAXX

    This long title is used as title in screens and reports.

    By default the short title, the long title or the column header of a data are recorded (on creation/update) in the connection language of the user.
    You can add your translation in another language using the Translation function:

    • Click Translation from the Actions icon in the corresponding field.
    • In the Translation window, add a new language code with the translation in this language.

    A user who logs on with this language will view the short description, long description or column header in their connection language if a translation exists. Otherwise, these descriptions will be available in the folder language.

    SEEINFOThe connection language must be defined as a default language for thefolder.

    • Active (field ENAFLG)

    This checkbox is used to specify if the cost structure is active or inactive. A cost structure declared as inactive is not displayed in the selection windows and cannot be used.
    SEEWARNINGA blocking message prohibits any deactivation of a cost structure assigned to a product, product-supplier or product category.

    Grid

    This field is used to specify the costs that will be used in the cost structure. It can be entered manually or by clicking Selection or Costs (jump to the Cost function) on the Actions icon.

    SEEINFOOnly product and active costs can be entered.

    • Description (field DESAXX)

    This field, which cannot be modified, displays the description of the entered cost.

    • Cost nature (field FCSNAT)

    This field, which cannot be modified, displays the nature of the entered cost.

    • Doc rate type (field DOCCHGTYP)

    This field, which cannot be modified, specifies if the exchange rate type of the document to which the cost is applied must be used to calculate the amount of this cost (when the amount of the document is in currency).

    • Rate type (field CHGTYP)

    It is only relevant to use this field if checkbox "Document exch rate type" is set to "No".
    It indicates the exchange rate to be used when the document, to which the cost is applied, is in currency.

    • Calculation mode (field DIRCLCMOD)

    This field, which cannot be modified, displays the calculation mode of the entered cost.
    This calculation mode determines the information that must be entered in the next columns.
    The calculation principle of each mode is detailed in the documentation on Costs.

    • Net price % (field PRINETPRC)

    The net price percentage must be entered for the calculation mode: "Percentage per net price".

    • Value (field UNTPRI)

    The unit price must be entered for the following calculation modes: "Fixed amount", "Amount per unit", "Amount by fixed bracket" and "Weighted amount".

    The currency must be entered for the following calculation modes: "Fixed amount", "Amount by unit", "Amount by fixed bracket", "Amount by schedule" and "Weighted amount".

    • Quantity (field QTY)

    The quantity must be entered for the following calculation modes: "Amount by fixed bracket" and "Weighted amount".

    • Basis (field BAS)

    The basis must be entered for the following calculation modes: "Amount by unit", "Amount by fixed bracket", "Amount by schedule" and "Weighted amount".

    The unit must be entered for the following calculation modes: "Amount per unit", "Amount by fixed bracket", "Schedule" and "Weighted amount".
    If the calculation mode relies on a schedule, the entry of a unit containing decimals leads to the display of a message indicating that it is necessary to check the schedules in order to make sure that the various schedules follow each other without any gaps.
    You cannot proceed with the entry if the window used to enter/check the schedules has not been previously opened (button ..\FCT\GESSTC_01.jpg").

    SEEWARNINGIn case of unit modification, if the new unit is not consistent with the units of the product category, product and/or supplier product to which the cost structure is linked, a warning message is displayed in the log file created upon saving the schedules.
    Indeed, the purchase unit of the cost structure must be the same as either the purchase unit, the stock unit, or the packing unit. If it is a weight or volume unit, the conversion with respect to those of the product category, product and/or supplier product must be defined in the Unit conversion table.

    • Weighting % (field WEIPRC)

    The weighting percentage must be entered for the following calculation mode: "Weighted amount".

    • Range (field LIM)

    This field, which cannot be modified, is associated with the calculation mode: "Amount by schedule".
    It contains the button ..\FCT\GESSTC_01.jpgwhich is used to open a window where the various schedules (lower ranges, upper ranges and unit prices) can be entered.
    SEEINFOWhen creating a cost of "Schedule" type, the schedule entry window automatically opens at the end of the line if no schedule line has been previously entered by the user.

    • Schedule (field LIMTYP)

    This field, which cannot be modified, is associated with the calculation mode: "Amount by schedule". It specifies the type of schedule: "Per unit" or "By amount".

    • Stock valuation (field STKVLT)

    This field, which cannot be modified, indicates if stock valuation is requested for the specified cost.

    • Higher fixed bracket (field HGHBKT)

    This field, which cannot be modified, is associated with the calculation mode: "Amount by fixed bracket".
    It is automatically activated when the setup performed for the entered cost indicates that the calculation must be applied to the higher bracket.

    This field must be entered only for the following calculation mode: "Formula".
    It is used to specify the reference of a formula defined in function: Formulas.

    Close

     

    Specific Buttons

    This function is used to display the detailed list of the products using the current cost structure for the calculation of landed costs. The search can be refined by specifying product and/or category ranges. 
    SEEINFOThe screens of this inquiry function can be set up (STI code) via the corresponding setup function.

    This function is used to display the detailed list of the supplier products using the current cost structure for the calculation of landed costs. The search can be refined by specifying product and/or supplier ranges.
    SEEINFOThe screens of this inquiry function can be set up (STP code) via the correspondingsetupfunction.

    This function is used to display the detailed list of the product categories using the current cost structure for the calculation of landed costs. The search can be refined by specifying a category range.
    SEEINFOThe screens of this inquiry function can be set up (STG code) via the correspondingsetupfunction.

    Error messages

    The only error messages are the generic ones.

    Tables used

    SEEREFERTTO Refer to documentation Implementation