Costs

• Cost (field FCSCOD)

The code of the cost 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 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 creation.

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

• Description (field DESAXX)

This long description is used as a 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.

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

• Active (field ENAFLG)

This checkbox is used to specify if the cost code is active or inactive. A cost code declared as inactive is not displayed in the selection windows and cannot be used.
A blocking message prohibits any deactivation of a cost used in a cost structure, a non closed order, a non invoiced receipt or a non validated invoice.

• Cost nature (field FCSNAT)

This field is used to specify the nature of the cost. The list suggests all the natures defined in local menu 2276.
The nature of the cost can be modified as long as the cost is not used in a cost structure or a document.

• Product (field DIRFLG)

Use this check box to specify if the cost is a product cost or a shipment cost.
In the current version of the product, only product costs are managed.
This information can be modified as long as the cost is not used in a cost structure or a document.

• Doc exchange rate type (field DOCCHGTYP)

When the document to which the cost is applied is in currency, the exchange rate type of this document is used by default to calculate the amount of the cost.
This checkbox can be deactivated in order to select the required exchange rate type in the next field.

• Rate type (field CHGTYP)

It is only relevant to use this field - and it is only possible to access it - if checkbox "Document exch rate type" is not checked.
It is used to specify the exchange rate to be used when the document, to which the cost is applied, is in currency.

• field DIRCLCMOD

This block is used to select the calculation mode of the product cost:

Percentage per net price

The calculation is as follows: Net price * (% net price) * Quantity * (% payable by)
Notes:

• The Percentage per net price is specified in the cost structure. It can be modified in the Structure detail window which can be accessed from the order.
• % payable by: see the general note at the end of the field help.

Example:

• Detail of the cost in the cost structure:
  - % per net price: 10 %
   
• Detail of the order line:
  - Net price: €100
  - Quantity : 10.
  - Percentage payable by the buyer: 50%

Calculated cost: 100 * 10% * 10 * 50 % = €50

Fixed amount

This is a fixed amount which is applied regardless of the amount, quantity, weight or volume.
The calculation is as follows: Value * (% payable by)
Notes:

• The fixed amount value and the currency are specified in the cost structure. They can be modified in the Structure detail window which can be accessed from the order.
• In case of conversion of this amount into company currency, the exchange rate type used is the one defined in the cost.
• % payable by: see the general note at the end of the field help.

Example:

• Detail of the cost in the cost structure:
  - Fixed amount: €100
   
• Detail of the order line:
  - Percentage payable by the buyer: 50%

Calculated cost: 100 * 50% * = €50

Amount per unit

This calculation mode is used to specify a cost per unit.
The calculation is as follows: Value* (% payable by) * quantity

Notes:

• The cost value, the basis to which the cost is applied (the quantity, volume or weight) and the unit of measure used are specified in the cost structure.
• When calculating the cost amount, the quantity of the product line is converted into the unit of the cost if they are different.
• % payable by: see the general note at the end of the field help.

Example: 

• Detail of the cost in the cost structure:
  - €10.50 per kg (value = 10.50, quantity = 1, basis = weight, unit = kg)
   
• Detail of the order line:
  - Quantity : 100 and Stock unit: 1.
  - Weight unit: kg and Weight of the STK: 0.500 (the stock unit thus weighs 0.500 kg).
  - Percentage payable by the buyer: 50%

1/ Conversion of the quantity into stock unit, in kg (unit of the cost): 100 * 0.500 kg = 50 kg
2/ Calculated cost:  10.50 * 50 % * 50 = €262.50

Amount by fixed bracket

This calculation mode is used to specify a cost per fixed bracket.
The calculation is as follows: Value * Number of brackets * (% payable by)
 
Notes: 

• The cost value, the quantity included in the bracket, the basis to which the cost is applied (the quantity, volume or weight) and the unit of measure used are specified in the cost structure.
• When calculating the cost amount, the quantity of the product line is converted into the unit of the cost if they are different.
• By enabling the Highercheck box, it is possible to take into account the cost of the higher bracket when the quantity corresponding to the lower bracket has been exceeded.  See example in field help Higher.
• % payable by: see the general note at the end of the field help.

Example:

• Detail of the cost in the cost structure:
  - €10 by bracket of 10 kg (value = 10, quantity = 10, basis = weight, unit = kg.
  - The check box Higher is selected.
   
• Detail of the order line:
  - Quantity : 15 and Stock unit: 1.
  - Weight unit: kg and Weight of the STK: 5.00 (the stock unit thus weighs 5 kg).
  - Percentage payable by the buyer: 50%

1/ Conversion of the quantity into stock unit (in kg): 15 * 5 kg = 75 kg.
2/ The cost calculation takes into account 8 brackets of 10 kg: 10 * 8 * 50 % = €40

Amount by schedule

This calculation mode is used to specify a cost defined according to a schedule, either per unit, or by amount.
The calculation is as follows:

• Schedule per unit: Value originating from the schedule * Quantity * (% payable by)
• Schedule by amount: Value originating from the schedule * (% payable by)

Notes: 

• In the cost structure, it is necessary to specify the basis and the unit, then to define the schedule by indicating the cost value for each range of the schedule (defined by a lower range value and an upper range value).
• % payable by: see the general note at the end of the field help.

Example for a schedule per unit 

• Detail of the cost in the cost structure:
  - The basis = volume and the unit = m3
  
  - Defined schedule:
  - €10 for a purchase from 0 to 10.000
  - €9 for a purchase from 10.001 to 20.000
  - €8 for a purchase from 20.001 to 30.000
   
• Detail of the order line:
   
  - Quantity : 10 and Stock unit: 1.
  - Volume unit: m3 and Volume of the STK: 3.00 (the stock unit thus has a volume of 3 m3).
  - Percentage payable by the buyer: 50%

1/ Conversion of the quantity into stock unit (in m3): 10 * 3 m3 = 30 m3.
2/ The calculated cost takes into account the schedule of €8: 8 * 30 * 50 % = €120

Example for a schedule by amount

• Detail of the cost in the cost structure:
  - The basis = quantity and the unit = UN
   
  - Defined schedule:
  - €100 for a purchase from 0 to 10.00
  - €180 for a purchase from 10.01 to 20.00
  - €250 for a purchase from 20.01 to 30.00
   
• Detail of the order line:
  
  - Quantity : 10 and Stock unit: 1.
  - Percentage payable by the buyer: 50%

2/ The cost calculation takes into account the bracket of €10: 10 * 50 % = €5

Weighted amount

This calculation mode is used to specify a cost to which a weighting percentage is applied.
 The weighting percentage makes it possible to take into account efficiency and performance aspects.It is used, for instance, to qualify the efficiency of operators according to their experience: a weighting coefficient of 80% indicates an average efficiency whereas a weighting coefficient of 100% indicates a high efficiency.This coefficient will thus increase the cost.
The calculation is as follows: Value * (% payable by) * Quantity / Weighting %
 
Notes:

• The cost value, the quantity involved, the basis (quantity, volume or weight) to which the cost is applied, the unit of measure used as well as the weighting percentage are specified in the cost structure.
• % payable by: see the general note at the end of the field help.

Example:

• Detail of the cost in the cost structure:
  - €100 for 1 unit
  - Weighting coefficient of 90%
   
• Detail of the order line:
  
  - Quantity : 10.
  - Percentage payable by the buyer: 100 %

Calculated cost: 100 * 100 % * 10 / (90 %) = €1,111.11

Formula

The cost is calculated according to a formula whose reference is specified in the cost structure. The formula makes it possible to deal with situations that cannot be managed with the standard calculation modes.

  The formula returns amounts which are expressed in the currency of the folder.If the formula uses amounts or prices that are not expressed in the currency of the folder, it is mandatory to specify this currency and to use the relevant conversion coefficient in the formula.

General note:
The Percentage payable by is the percentage payable by the buyer. The distribution of each of the cost natures between the buyer and the seller is specified in the incoterm used and entered in the purchase document (order, invoice). If there is no incoterm, the entire cost is to be paid by the buyer.

• Higher (field HGHBKT)

This check box can only be selected if the calculation of the product cost is based on an amount by fixed bracket.
When it is selected, the calculation takes into account the cost defined for the higher bracket when the lower bracket has been exceeded.

Example based on an amount of €5 every 100 liters (value = 5, quantity = 100, basis = volume, unit = liter).

• Dimension type (field DIE)

This grid is automatically loaded with the default dimension types associated with the 'Cost' basic data.

• Dimension (field CCE)

An analytical dimension is an element of the analytical chart of accounts on which accounting entries can be posted.
Each analytical dimension type represents a specific division of the company into a set of analytical payment attributes. An analytical dimension is thus an analytical payment attribute within a dimension type.

• Stock valuation (field STKVLT)

This field is used to indicate whether or not the amount of the cost should be taken into account in the calculation of the stock cost and stock cost per unit in the document lines (order and receipt). It is also used to take into account or not the costs in the calculation of the average cost during receipts.