The purpose of this table is to hold information about different cost types used for calculating landed cost.
Landed costs are those costs, such as freight, duty, insurance and handling costs, that are over and above the price paid to a supplier for the goods. The cost is incurred by the buyer during the transportation of goods from the seller to the buyer, and then into the warehouse.
The terms of delivery code on the purchase order header controls whether landed cost information should be calculated for the purchase order or not.
When goods are received landed costs can be added, changed or deleted. Two types of costs can be entered:
- distributed costs
- discrete costs
Distributed costs are costs distributed over all received lines. Discrete costs are costs defined for each individual reception line. This table holds information about how discrete costs for an order line are to be calculated.
Note: Distributed costs have to be entered manually, either in the Inbound shipment file when a shipment is created, or in the Confirm purchase order reception note or Receive replenishment line programs.
The table consists of three different sets of information:
- Cost types: General information about the cost type
- Key values: Keys to apply on the purchase order line for the system to generate the cost. For example, depending upon the country the order line is dispatched from, the warehouse it is received by and the manner of transport that is used, different cost values will apply. The keys in this example are From country, To warehouse and Manner of transport.
- Key details: Values for all keys. For example, if the goods are dispatched from Great Britain, to the Central warehouse, using manner of transport code SGA, the landed cost is 6% of the purchase price net price.
Options
| Key values | Select this option to display key values. |
| Included costs | Select this option to display included costs. |
Selection fields
- Type
- Displays the landed cost type code.
- Fictitious item
- Displays a code from the Item file, indicating the fictitious item to be used when creating accounting transactions for this landed cost type and when writing goods reception transactions.
- Key
- Indicates if key values are defined for the landed cost code. The key values control when the landed cost should be calculated.
Landed cost type table enquiry (DIR64104)
This panel displays general information about the landed cost type.
- Type
- Fictitious item
- Displays a code from the Item file, indicating the item to be used when creating accounting and goods reception transactions for this landed cost type.
- Cost alloc. method
- Displays a code indicating the default method by which costs are allocated. This method will be defaulted when adding key values to this cost type.
The Cost allocation method determines what the landed cost should be based on. If selecting, e.g., a percentage, the landed cost will be calculated as a percentage of the net value of the purchase order line plus any included costs.
Note: Different cost allocation methods can be defined for each key value.
The value displayed depends on what the corresponding panel value is for your system’s language (defined in the Panel value table and Language table).
- Internal cost
- Indicates if this cost type is an internal cost. This could be, e.g., labour or resources, for which a supplier’s invoice will not be received and therefore not matched with the purchase order line.
For external costs, i.e. NO in this field, a record will be added to the Goods received transaction file, i.e. that the cost can be matched with a supplier invoice when entering A/P invoices in DC1 Financials.
Note: Accounting transactions, to be transferred to DC1 Financials, are created for both internal and external costs.
- Calc. at back order
- Indicates if landed costs should also be calculated for backlogged purchase order lines.
Landed cost type table enquiry, Key values (DIR64105)
This panel displays the existing key values that have been set up in the Landed cost type table for the selected cost type. The key values hold information about the parameters (keys) that control how to calculate the landed costs.
The sequence for each key value determines the order in which the system should search to find the applicable key value for a particular purchase order line.
The landed cost (import duty) for a purchase order line should be based on a percentage depending upon where the goods are dispatched from, where they are delivered to, and the commodity code of the item.
For goods dispatched from country HK, received in country GB, with commodity code 123456789, the percentage is 6.
For good dispatched from country USA, received in country GB, with commodity code 123456789, the percentage is 8.
Options
Selection fields
- Seq
- Displays a sequence number indicating the order in which the system will search to find the applicable key value.
- Details
- Indicates if detailed information has been defined for the keys in the key value. If set to NO, the keys have been defined, but no applicable values for the keys are defined.
Example if this field is set to NO
The controlling parameters (keys) are, e.g., From country and To country. These keys are defined. But no information about which country and which warehouse the key value applies for are defined.
Landed cost type table enquiry, Key values (DIR64108)
This panel displays the controlling parameters (keys) for the selected key value.
- Sequence
- Displays the sequence number between 1 and 999, indicating the order in which the system should search to find the applicable key value.
From
In the fields below, indicates which parameter to use to determine from where goods are sent.
- Country
- Indicates if the country from which the goods are sent should be used as a key for this key value.
- Supplier
- Indicates if the supplier on the purchase order should be used as a key for this key value.
To
In the fields below, indicates which parameter to use to determine where goods are received.
- Country
- Indicates if the country in which the goods are received should be used as a key for this key value.
- Warehouse
- Indicates if the receiving warehouse should be used as a key for this key value.
How
In the field below, indicates if Manner of transport should be used as a key.
- Manner of transport
- Indicates if the manner of transport code on the purchase order line should be used as a key for this key value.
By
In the field below, indicates if Shipping agent should be used as a key.
- Shipping agent
- Indicates if the shipping agent on the purchase order line should be used as a key for this key value.
Item
In the fields below, indicates which parameter to use for this key value.
- Commodity code
- Indicates if the commodity code for the item on the purchase order line should be used as a key for this key value.
- Shipment group
- Indicates if the shipment group of the item on the purchase order line should be used as a key for this key value.
- Item
- Indicates if the item on the purchase order line should be used as a key for this key value.
- Cost alloc. method
- Displays the cost allocation method to be used when calculating the costs.
The value displayed depends on what the corresponding panel value is for your system’s language (defined in the Panel value table and Language table).
- Calc. at back order
- Indicates if landed costs should also be calculated for backlogged purchase order lines.
Landed cost type table enquiry, Key details (DIR64109)
This panel displays all parameters defined for the selected key value. The information is used to find the applicable values for calculating the landed costs for a particular purchase order line.
The column headings differ depending on the controlling parameters (keys) defined for the key value.
Options
Landed cost type table enquiry, Key details (DIR64112)
This panel displays the values of the keys that must be defined on the purchase order line in order to match this record.
The fields displayed in the top part of the panel differ depending on the controlling parameters (keys) defined for the key value you are maintaining.
When the system is to calculate the landed costs for a purchase order line, it checks if the corresponding fields on the purchase order line match the information defined on this panel. If the purchase order line matches the information defined here, the cost values, displayed on the next panel, will be used in the calculation.
Click OK on this panel to display the values to be used in the landed costs calculation.
- From country
-
Displays a code from the Country table indicating the country the goods on the purchase order line must be dispatched from in order to match this record.
- From supplier
-
Displays a supplier from the Business partner file indicating the supplier the goods on the purchase order line must be purchased from in order to match this record.
- To country
-
Displays a code from the Country table indicating the country that the goods on the purchase order line must be received from in order to match this record.
- To warehouse
-
Displays a code from the Warehouse table indicating the warehouse that the goods on the purchase order line must be received from in order to match this record.
- Manner of transport
-
Displays a code from the Manner of transport table indicating the manner of transport that must be defined on the purchase order line in order to match this record.
- Shipping agent
-
Displays a code from the Shipping agent table indicating the shipping agent that must be defined on the purchase order line in order to match this record.
- Commodity code
-
Displays a code from the Commodity code table indicating the commodity code that must be defined for the item on the purchase order line in order to match this record.
- Shipment group
-
Displays a code from the Shipment group table indicating the shipment group that must be defined for the item on the purchase order line in order to match this record.
- Item
-
Displays a code from the Item file indicating the item that must be defined for the item on the purchase order line in order to match this record.
- Vendor
- Displays a supplier from the Business partner file that indicates the supplier of the landed cost. This could be the same supplier as the one that appears on the purchase order but it may be a completely different one. For example, if creating a landed cost for import duty, the vendor will probably be the government customs and excise department. For a landed cost for road haulage, the vendor might be the transport company.
- VAT based
- Indicates if this cost is VAT based, i.e. if VAT accounting transactions should be created when accounting transactions are created for this cost.
- VAT handling code
- Displays a code from the VAT handling table indicating the VAT handling code to apply to this cost.
If the VAT based field is YES and this field is blank, the system will retrieve the VAT handling code automatically from the Country/country VAT table.
The system searches in the following order to find the correct VAT handling code:
- Business partner VAT table.
- Item file, Country/Country VAT information panel (the fictitious item attached to the landed cost type is used.)
- Country/Country VAT table
- DIS control file
In the Country/country VAT tables the system uses the following values for From country and To country:
- From country: The country defined in the dispatch address of the landed cost vendor.
- To country: The country defined for the receiving warehouse. If this is a BtB direct delivery, this will be the country defined in the sales order delivery address.
- VAT included
- Indicates if VAT is included in the calculated cost.
- Include VAT % code
- Displays a code from the VAT handling table indicating the VAT percentage that is included in the calculated cost.
- Calc. at back order
- Indicates if landed costs should also be calculated for backlogged purchase order lines.
Landed cost type table enquiry, Key details (DIR64113)
This panel displays the actual values to be used in the cost calculation. Different fields are displayed depending on the Cost allocation method defined for the cost type.
If the cost allocation method is Weight, Volume or Quantity, the value displayed on this panel will be multiplied with the total weight/volume on the purchase order line to calculate the cost.
If the cost allocation method is Percentage, the percentage displayed on this panel will be multiplied with the total net value (amount) on the purchase order line.
If the cost allocation method is Value, the value displayed on this panel is a discrete value, i.e. the value is the actual cost, which is not dependent upon other factors as, e.g., weight or volume.
Active
Displays, in the fields below, the cost values that are currently active.
- Value
- This field is only displayed if the Cost allocation method defined is Gross weight, Gross volume, Net weight, Net volume and Quantity.
Note: If cost allocation method is Quantity, a field to the right of the per field is also displayed.
If the cost allocation method is weight or volume, the value displayed in this field will be multiplied by the total weight/volume on the order line.
Cost allocation method is Gross weight.
Gross weight per unit of the item on the order line is 10.
Quantity on order line is 25.
Value in this field is 2.The calculated cost will be: 10 * 25 * 2 = 500
Note: The unit for the value is displayed to the right of this field. This unit is retrieved from the Unit for volume or Unit for weight fields in DIS control file.
Cost allocation method is Quantity.
Quantity on order line is 25.
Unit on order line is PCS.
Value in this field is 2.
Unit defined in the per field on this panel is also PCS.The calculated cost will be: 25 * 2 = 50
- per
- If the cost allocation method defined is Gross weight, Gross volume, Net weight or Net volume, the unit in which the values are defined is displayed. If the cost allocation method defined is Quantity, this field will display the unit from the Unit table that must be entered on the purchase order line in order to match this record.
- % of incl costs
- This field is only displayed if the cost allocation method defined is Percentage. Displays a percentage to be used to calculate the cost. The cost will calculated as:
(Net purchase price on the order line + included costs) * quantity on order line * this percentage
- Discrete value
- This field is only displayed if the cost allocation method defined is Value. Displays a discrete value to be used as the landed cost. This value is not dependent upon other factors, such as weight, volume or quantity on the purchase order line.
- Currency
- Displays a currency from the Currency table indicating the currency in which the value is expressed. The currency displayed does not have to be the same currency as on the purchase order. If, for example, a purchase order line generates a cost for duty, the customs and excise department sends an invoice for the duty cost. The purchase order might be defined in currency GBP but the currency on the invoice from the customs and excise department is in EUR.
- Valid from
- Displays the date upon which the values displayed take effect.
- Valid to
- Displays the date upon which the values cease to apply.
Current
Displays, in the fields below, the cost values that are currently active. When adding new values, the field below should be completed. To activate the values below Current and update the fields below Active, run the Refresh landed costs menu item.
- Value
- This field is only displayed if the Cost allocation method defined is Gross weight, Gross volume, Net weight, Net volume and Quantity.
Note: If cost allocation method is Quantity, an input field to the right of the per field is also displayed.
If the allocation method is weight or volume, the value displayed in this field will be multiplied with the total weight/volume on the order line.
Cost allocation method is Gross weight.
Gross weight per unit of the item on the order line is 10.
Quantity on order line is 25.
Value in this field is 2.The calculated cost will be: 10 * 25 * 2 = 500
Note: The unit for the value is displayed to the right of this field. This unit is retrieved from the Unit for volume or Unit for weight fields in the DIS control file.
Cost allocation method is Quantity.
Quantity on order line is 25.
Unit on order line is PCS.
Value in this field is 2.
Unit defined in the per field on this panel is also PCS.The calculated cost will be: 25 * 2 = 50
- per
- If the cost allocation method defined is Gross weight, Gross volume, Net weight or Net volume, the unit in which the values are defined is displayed. If the cost allocation method defined is Quantity, this field will display the unit from the Unit table that must be entered on the purchase order line in order to match this record.
- % of incl costs
- This field is only displayed if the Cost allocation method defined is Percentage. Displays a percentage to be used to calculate the cost. The cost will calculated as:
(Net purchase price on the order line + included costs) * quantity on order line * this percentage.
- Discrete value
- This field is only displayed if the Cost allocation method defined is Value. Displays a discrete value to be used as the landed cost. This value is not dependent upon other factors, such as weight, volume or quantity on the purchase order line.
- Currency
- Displays a currency from the Currency table, indicating the currency in which the value is expressed. The currency displayed does not have to be the same currency as on the purchase order. If, for example, a purchase order line generates a cost for duty, the customs and excise department sends an invoice for the duty cost. The purchase order might be defined in currency GBP but the currency on the invoice from the customs and excise department is in EUR.
- Valid from
- Displays the date upon which the values displayed take effect.
- Valid to
- Displays the date upon which the values cease to apply.
New
In the fields below, displays the new values to apply. This is useful if new cost values should apply within, e.g., one month.
- Value
- This field is only displayed if the Cost allocation method defined is Gross weight, Gross volume, Net weight, Net volume and Quantity.
Note: If cost allocation method is Quantity, an input field to the right of the per field is also displayed.
If the allocation method is weight or volume, the value displayed in this field will be multiplied with the total weight/volume on the order line.
Cost allocation method is Gross weight.
Gross weight per unit of the item on the order line is 10.
Quantity on order line is 25.
Value in this field is 2.The calculated cost will be: 10 * 25 * 2 = 500
Note: The unit for the value is displayed to the right of this field. This unit is retrieved from the Unit for volume or Unit for weight fields in the DIS control file.
Cost allocation method is Quantity.
Quantity on order line is 25.
Unit on order line is PCS.
Value in this field is 2.
Unit defined in the per field on this panel is also PCS.The calculated cost will be: 25 * 2 = 50
- per
- If the Cost allocation method defined is Gross weight, Gross volume, Net weight or Net volume, the unit in which the values are defined is displayed.
If the Cost allocation method defined is Quantity, this field displays the unit from the Unit table that must be entered on the purchase order line in order to match this record.
- % of incl costs
- This field is only displayed if the Cost allocation method defined is Percentage. Displays a percentage to be used to calculate the cost. The cost will be calculated as:
(Net purchase price on the order line + included costs) * quantity on order line * this percentage
- Discrete value
- This field is only displayed if the Cost allocation method defined is Value. Displays a discrete value to be used as the landed cost. This value is not dependent upon other factors, such as weight, volume or quantity on the purchase order line.
- Currency
- Displays a currency from the Currency table indicating the currency in which the value is expressed.
The currency displayed does not have to be the same currency as on the purchase order. If, for example, a purchase order line generates a cost for duty, the customs and excise department sends an invoice for the duty cost. The purchase order might be defined in currency GBP but the currency on the invoice from the customs and excise department is in EUR.
- Valid from
- Displays the date upon which the new values are to take effect.
- Valid to
- Displays the date upon which the new values cease to apply.
Landed cost type table enquiry, Included costs (DIR64114)
This panel displays all costs that are included in the calculation of a cost type.
All records from the Landed cost type inclusion file are displayed displaying the cost type code and its description.
- Type
- Displays the cost types included in the calculation of this cost type.