Legacy module
The module described in this article has been marked as a legacy module. This means the following:
-
We don't create new features for this module or fix any bugs.
-
The module is not available anymore in Xentral instances (demo or licensed) created after 28-Sep-2022. If you as a new user have special requirements that could only be fulfilled by this module, please contact our customer support team to discuss a solution.
For more information, see also Why is Xentral deprecating some modules and what does this mean for you?
The copper surcharge module has been removed in xentral version 21.5. Thus, it will not be available anymore in the versions 21.5 and higher.
Can be found under App Center > Master data > Copper surcharge. The module is used to add extra items to documents that have a copper content. The purchase prices of these extra items can then be maintained via the Daily Prices app.
The following values are maintained in the module:
-
Copper surcharge item: An item which is then added as an additional item
-
Insert item: Select here how the surcharge items in a document should be supplemented
-
Copper surcharge - offer to order: The copper rate at a certain date is to be entered here for the copper surcharge
-
Create copper surcharge invoice: Select here which date of the copper rate for the invoice should be set
-
How should the data be saved?: Here is either the field with the app raw material list or the field with article additional fields to be selected to mark an article as a copper article
-
Sourcing costs: The sourcing costs are to be entered in %.
-
Standard copper base: The price for the standard copper base is to be entered in EUR per 100kg
-
Article specific copper base: The price of the article specific copper base is to be inserted in EUR per 100kg
Insert item
There are three ways in which overhead items can be added to a document:
-
Add one copper surcharge item per line: For each item in the document that is identified as a copper item, a copper surcharge item is added
-
Insert only one collective item: The copper surcharge of all copper items Is added in one position. This position is always at the end.
-
Add one copper surcharge position per group: Per group, all copper surcharges are added up and always inserted at the end of the group as a position
Copper surcharge - offer to order
There are two choices:
-
Copper rate from quote date: If an order has been continued from a quote, the date of that quotation is used as the basis, otherwise the order date
-
Copper rate from the order date: The order date is always used.
Create copper surcharge invoice
There are four choices as to which date can be used as a basis:
-
Copper rate from order date: The date of the order is selected here. If this is not available, the current date is to be set.
-
Copper rate from delivery note/delivery date: Here, the delivery date is to be selected. If this is not present, the current date is to be used
-
Copper rate from invoice date (to the day): The date of the invoice is to be entered.
-
Copper rate from the date of the offer: the date of the offer is to be selected. If this is not available, the current date is to be used
How should the data be stored?
There are two ways in which an item can be marked as a copper item. Either the raw material app can be used for this in addition. or another article additional field for the article specific copper number:
-
Item-specific copper count (kg/km): This field only appears if previously the maintenance of the data by article additional fields was selected.
-
Reference costs (in %): The current calculation basis always includes a reference cost surcharge. This is currently preset with 1% and can be changed here for all surcharge items.
-
Standard copper base (in EUR per 100kg): This value also occurs in the calculation base and can be changed here for all items
-
Article-specific copper basis (in EUR per 100kg): If for special articles, the copper basis is to be changed, the free field can be selected here, which can then be filled.
The additional surcharge items need a product as a base. For this, a new product is created. This product must then be marked in the Variants area as a daily price product, i.e. a checkmark at daily prices.
In the Item Description(EN) field, the following variables are still recognized and replaced when used: {ARTICLE NUMBER}, {ARTICLE NAME}, {NETPRICE} the net price of the surcharge, {COPPERBASIS} the copper base (see calculation base), {COPPERNUMBER} the copper weight (kg/km) (see calculation basis), {DELVALUE} the used Daily Price
 |
In order for an item to be recognized as a copper item, it must either be marked as a raw material list item or the additional free field for the copper weight (kg/km) must be filled in. This depends on the selection in the module. If the raw material list is used, a new item must be added in the 'Raw materials' tab. Here the overhead item should be used as item and Quantity as Copper weight (kg/km).
 |
 |
In the respective product, in the parts list area, a check mark must be placed next to the raw material list.
In the Daily prices module in the Configuration tab, for one of the seven items select the copper surcharge item again and assign a column name, e.g. Copper surcharge.
 |
In the tab Overview, often unrestricted, a new price can be entered.
 |
As soon as a new price is saved, the validity date in the old one is set to yesterday and a new purchase price is added.
The following formula serves as the basis for the calculation:.
Copper surcharge EUR/km = (copper weight (kg/km) * (DEL + 1% purchase cost)) - copper base / 100
DEL here is to be understood as German electrolytic copper quotation for conductive material.
An example:
Copper weight/km: 13.00 kg Copper base: 150.00 EUR/100 kg DEL: 550.00 EUR/100 kg
13 * ((550.00 + (550.00 * 0.01)) - 150.00) / 100 = 52.72 EUR/km