Related topics
This panel is accessed from the Work with landed costs routine.
On this panel you can add or change information about the discrete cost for the selected purchase order line. The fields displayed in the upper half of the panel are key fields that are used to calculate the costs automatically. They are:
- From country
- To country
- Supplier
- To warehouse
- Manner of transp
- Shipping agent
- Item shipment group
- Commodity code
- Item
If any of the above fields are changed on the order line, the landed cost will be re-calculated according to the matching record in the Landed cost type table.
Note: Not all fields on the order line can be changed. Supplier cannot be changed, for example.
When new costs are added to the line, the system will put default values in some of the above mentioned fields according to the information on the purchase order line. These default values can be changed, however, if you add a landed cost type for which records already exist in the Landed costs details active file the system will use the information defined in the upper part of the panel to find a matching record, and the values for the fields displayed after the Item field will be retrieved automatically. If no such record exists some or all of these fields will need to be completed manually.
If a matching record is found, the new discrete landed cost will be created based on the Cost allocation method and the values from the record.
Function keys
Included costs | This function key is valid only if the Cost allocation method is set to Percentage (PC). View information about the included costs for the purchase order line. |
Line summary | This function key is not displayed if you are adding new costs. View summary details on the purchase order line. |
Retrieve defaults | This function key is displayed only if you are adding new costs. Retrieve details from the Active landed cost detail file that match the values entered in the following fields on the panel: From/To Country, Supplier, To warehouse, MOT, Shipping agent, Item shipment group, Commodity code, and Vendor.
Note: The above fields are defaulted from the details held against the item and supplier but may be deleted as required. This function can be useful in the reception routine, if new cost types have been created since the order was entered. |
- Landed cost type
- Mandatory entry. If you are adding a new cost, enter a code from the Landed cost type table indicating how to calculate the landed cost.
- From country
- If you are adding a new cost, the from country is retrieved automatically from the Address panel on the purchase order (dispatch address country) but it can be changed.
- To country
- If you are adding a new cost, the to country is retrieved automatically from the warehouse on the purchase order line but it can be changed.
- Supplier
- If you are adding a new cost, the supplier is retrieved automatically from the purchase order but it can be changed.
- To warehouse
- If you are adding a new cost, the to warehouse is retrieved automatically from the warehouse on the purchase order line but it can be changed.
- Manner of transport
- If you are adding a new cost, the manner of transport is retrieved automatically from the purchase order but it can be changed.
- Shipping agent
- If you are adding a new cost, the shipping agent is retrieved automatically from the Address panel on the purchase order (dispatch address) but it can be changed.
- Item shipment group
- If you are adding a new cost, the item shipment group is retrieved automatically from the Item file for the item displayed in the Item field but it can be changed.
- Commodity code
- If you are adding a new cost, the commodity code is retrieved automatically from the purchase order line but it can be changed.
- Item
- If you are adding a new cost, the item is retrieved automatically from the purchase order line but it can be changed.
- Vendor
- If you are adding a new cost and the system finds a record that matches the values defined in the upper part of the panel in the Landed cost details active file, the value from this file will be retrieved automatically.
If no record is found, or if you want to change the retrieved value, enter a valid supplier from the Business partner file, indicating the supplier of the landed cost.
This is the supplier who will send the invoice for the landed cost. Note: This supplier could be the same as the one that appears on the purchase order but it may be a completely different one.
- Cost alloc method
- If you are adding a new cost and the system finds a record that matches the values defined in the upper part of the panel in the Landed cost details active file, the value from this file will be retrieved automatically.
If no record is found, or if you want to change the retrieved value, enter a code indicating the method to be used when calculating the cost. The value you enter depends upon what the corresponding panel value is for your system’s language (defined in the Panel value table and Language table).
- Discrete value
- If you are adding a new cost and the system finds a record that matches the values defined in the upper part of the panel in the Landed cost details active file, the value from this file will be retrieved automatically.
If no record is found, or if you want to change the retrieved value, enter the actual discrete cost. The amount should be expressed in the currency defined in the Transaction currency field on this panel.
Note: This field can only be completed if the Cost allocation method is defined as Net value.
- Percentage
- If you are adding a new cost and the system finds a record that matches the values defined in the upper part of the panel in the Landed cost details active file, the value from this file will be retrieved automatically.
If no record is found, or if you want to change the retrieved value, enter the value to be used to calculate the cost. This value represents the percentage of the net value on the purchase order line.
Note: This field can only be completed if the Cost allocation method field is defined as Percentage.
- Value/costing unit
- If you are adding a new cost and the system finds a record that matches the values defined in the upper part of the panel in the Landed cost details active file, the value from this file will be retrieved automatically.
If no record is found, or if you want to change the retrieved value, enter the value upon which the cost should be based.
If the Cost allocation method field contains the value for Gross/Net Weight/Volume, the value entered in this field will be multiplied with the total weight/volume on the order line to calculate the cost.
If the Cost allocation method field is defined as Quantity, an input field to the right of the per field is also displayed in which you should enter the unit of measure on the purchase order line. Note: If this input field is not displayed the Landed cost type field on this panel is not defined as Quantity. You have to change the Landed cost type to be able to enter the unit upon which the value in this field should be based.
- per
- If you are adding a new cost and the system finds a record that matches the values defined in the upper part of the panel in the Landed cost details active file, the value from this file will be retrieved automatically. If the Cost allocation method field is defined as Quantity and the system did not find a matching record, or if you want to change the retrieved value, enter a valid unit of measure from the Item file (Units panel) for the item on the purchase order line.
- Transaction currency
- If you are adding a new cost and the system finds a record that matches the values defined in the upper part of the panel in the Landed cost details active file, the value from this file will be retrieved automatically.
If no record is found, or if you want to change the retrieved value, enter a code from the Currency table, indicating the currency in which the cost should be calculated.
- VAT based
- If you are adding a new cost and the system finds a record that matches the values defined in the upper part of the panel in the Landed cost details active file, the value from this file will be retrieved automatically.
If no record is found, or if you want to change the retrieved value, indicate whether or not this cost is VAT based, i.e. if VAT accounting transactions should be created when accounting transactions are created for this cost.
- Exchange rate
- VAT handling code
- If you are adding a new cost and the system finds a record that matches the values defined in the upper part of the panel in the Landed cost details active file, the value from this file will be retrieved automatically.
If no record is found, or if you want to change the retrieved value, enter a code from the VAT handling table, indicating the VAT handling code that is to be applied to this cost.
If the VAT based field is set to YES and you leave this field 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 table the system uses the following values for From country and To country:
- From country: Extracted from the dispatch address of the landed cost vendor.
- To country: Extracted from the receiving warehouse that has been defined. If this is a BtB direct delivery, however, the sales order delivery address determines the To country.
- Fixed rate
- VAT included
- If you are adding a new cost and the system finds a record that matches the values defined in the upper part of the panel in the Landed cost details active file, the value from this file will be retrieved automatically.
If no record is found, or if you want to change the retrieved value, indicate whether VAT is included in the calculated cost or not. If set to YES, the Incl VAT % code field must be completed.
- System value
- Displays the calculated cost in system currency. Note: This value is always displayed excluding any VAT.
- Include VAT % code
- If you are adding a new cost and the system finds a record that matches the values defined in the upper part of the panel in the Landed cost details active file, the value from this file will be retrieved automatically.
If no record is found, or if you want to change the retrieved value, enter the VAT handling code for the VAT percentage (if any) that is included in the cost.
Order line landed costs summary (DIR65002)
This panel displays summarised information about the landed costs for the purchase order line.
Function keys
Show purchase unit / Show price unit | Price unit information is only displayed if the PRCUNIT (Price unit handling) function is activated in the Function control file. See About price unit handling for more information. Toggle between viewing the information in purchase and price unit. |
- Await cost check
- Indicate whether or not the await cost check function is required for the discrete cost.
Note: If you are working with cost for order lines included in a shipment, this code has to be the same as the corresponding code defined for the shipment.
- Reception note
- Displays the number of the reception note on which the order line has been printed, if it has been printed on a reception note.
- Order status
- Displays the current order status of the order line.
- Shipping status
- Displays the shipping status of the order line.
Code Description 10 The discrete cost has been created. 30 The order line has been partly received, using the Receive replenishment line program, but it is still not closed. Note: If the item on the line should be quality controlled, the line status will remain at 30 until the quality control note is confirmed. 45 The order line is closed, meaning nothing more will be received. 60 The order line has been booked.
- Purchase unit
- Displays the unit of measure, from the Unit table, in which the item was purchased.
- Conversion factor
- Displays the conversion factor that determines the relation between the Purchase unit displayed above and the stock unit defined in the Item file for the item on the purchase order line.
- Price unit
- Only displayed if the PRCUNIT (Price unit handling) function is activated in the Function control file. Displays the unit in which the price is presented. See About price unit handling for more information.
- Stock unit
- Displays the unit in which the item will be stocked.
- Purchase price
- Displays the purchase price of the item being purchased expressed in the currency displayed in the Currency field on this panel.
- Currency
- Displays the currency in which the purchase price is expressed.
- Purchase unit/Price unit
- Note: Price unit information is only displayed if the PRCUNIT (Price unit handling) function is activated in the Function control file. Displays the unit in which the price is presented. See About price unit handling for more information.
Displays, in the fields below this column, the values for the unit in which the item was purchased/priced (Click Show purchase unit / Show price unit to toggle the information).
- Stock unit
- The values in this column are expressed in the stock unit of the item being purchased.
- Extended
- The values in this column display the total values for each of the fields in the Purchase unit column, meaning:
Net price in the Purchase unit column * Quantity = Net price value in the Extended column Gross weight in the Purchase unit column * Quantity = Gross weight value in the Extended column, and so on.
- Quantity
- Displays the received quantity if the order line has a status that is higher than 30. Otherwise the field will display the ordered quantity.
- Net price
- Displays the net purchase price, in system currency, of the item being purchased.
- Gross weight
- Displays the gross weight of the item being purchased.
- Net weight
- Displays the net weight of the item being purchased.
- Gross volume
- Displays the gross volume of the item being purchased.
- Net volume
- Displays the net volume of the item being purchased.
- Line landed cost
- Displays the total cost, in system currency, for the purchase order line. Note: This is the sum of all discrete and distributed costs defined for the line.
- Total landed cost
- Displays the total landed cost, in system currency, for the purchase order line calculated as:
Net price + Line landed cost
Order line landed costs, Included costs (DIR65003)
This panel displays all records from the Landed cost type table, with the exception of the type being maintained. A mandatory input-capable Included Y/N field is displayed on each line and will be set to YES if there is a record in the Landed cost inclusion file for this type, otherwise it will be set to NO.
- Type
- Displays the various cost types that can be included in the calculation of this cost.
Included
In the fields below, indicate which cost types you want to include in the calculation of this cost.