Skip to main content

Create a Landed Cost

info

This page describes procedures for environments using Inventory Management (New Method).

If your screen layout differs from the one shown on this page, refer to the Inventory Management (Conventional Method) manuals.

Overview​

This page explains how to allocate a landed cost to confirmed receipt lines and create a landed cost in Inventory Management (New Method).

Purpose​

Use this feature to reflect costs incurred when purchasing products in the cost of received products and manage product costs.

By creating a landed cost as a draft, you can review the allocation targets and allocated amounts before posting the landed cost to inventory costs.

Feature Description​

What Is a Landed Cost?​

A landed cost allocates costs incurred when purchasing products, such as freight, insurance premiums, and customs duties, to receipt lines and reflects those costs in the cost of received products.

When you post a created landed cost, the allocated costs are reflected in inventory valuation for remaining inventory and in the difference in the cost of goods sold for products already sold.

You can register multiple charge lines in one landed cost. You can also select multiple receipts and specify receipt lines to which each charge line is allocated.

Advance Preparation​

Before creating a landed cost, check the following settings.

  • The status of the receipt to be used as an allocation target is Confirmed.
  • A supplier to use as the landed cost biller is registered, and Landed cost biller is enabled for the supplier's usage.
  • Inventory valuation is configured to be performed in DEXTRE.
    • You can check the valuation policy settings and enabled status at [Inventory] > [Settings] > [Valuation policy].

You cannot use landed cost processing for inventory valuation when inventory valuation is disabled or inventory is managed by a system other than DEXTRE.

Charge Categories​

The following seven charge categories are available for landed costs.

The tax rule and allocation method that can be specified differ depending on the charge category.

Charge categoryTax ruleAllocation method
国際海上・航空運賃 (International ocean and air freight)輸出免税 (Export tax exemption)Received quantity, Landed cost allocation by amount, or Manual amount
貨物海上保険料 (Cargo marine insurance)非課税 (Tax-exempt)Received quantity, Landed cost allocation by amount, or Manual amount
関税 (Customs duty)不課税 (Out of scope)Manual amount only
通関料・取扱手数料 (Customs clearance and handling fee)課税10% (Consumption tax 10%)Received quantity, Landed cost allocation by amount, or Manual amount
国内区間の輸送費(港→倉庫) (Domestic transportation cost (port → warehouse))課税10% (Consumption tax 10%)Received quantity, Landed cost allocation by amount, or Manual amount
買付手数料 (Buying commission)Select from the available optionsReceived quantity, Landed cost allocation by amount, or Manual amount
送料(仕入先からの引取運賃) (Shipping fee (pickup freight from supplier))課税10% (Consumption tax 10%)Received quantity, Landed cost allocation by amount, or Manual amount

Allocation Methods​

Allocation means assigning landed costs to the selected receipt lines.

The allocation method sets the basis used to assign costs to each receipt line.

The following three allocation methods are available for landed costs.

  • Received quantity: Automatically allocates the cost according to the ratio of the receipt quantities.
  • Landed cost allocation by amount: Automatically allocates the cost according to the ratio of the basis amounts calculated from the quantity and receipt base unit cost of each receipt line. This is not the ratio of the final cost including landed costs.
  • Manual amount: Does not allocate the cost automatically. Enter an allocation amount for each receipt line.

Status After Creation​

When a landed cost is successfully created, its status is set to Draft.

The landed cost is not reflected in inventory costs when it is created. You can edit the landed cost as needed.

To reflect a landed cost in inventory costs, execute Post landed cost. When you post a landed cost, the allocated costs are reflected in inventory valuation for remaining inventory and in the difference in the cost of goods sold for products already sold.

Instructions​

Navigate to the Landed Cost Creation Screen​

  1. Click the Inventory menu.
  2. Click the Purchasing tab.
  3. Click Purchase orders, receipts, and landed costs.
    This tab is open by default.
  4. Click Landed costs.
  5. Click the New Landed Cost button.
    The "New landed cost" page opens.

How to Fill in the Form​

Enter Landed Cost Details​

  1. Document number
    Enter the landed cost document number.

    • If you leave the field blank, a number is automatically assigned when the landed cost is created.
    • You cannot use a landed cost number that has already been used within the same brand.
  2. Currency
    The currency configured in the valuation policy is displayed. You cannot change it.

  3. Occurred date (Required)
    Enter the occurrence date. The date on which the landed cost creation screen is opened is set as the initial value.

    You can select a date from the calendar.

  4. Landed cost biller (Required)
    Select the supplier to use as the landed cost biller using a radio button.

    • Suppliers with Landed cost biller enabled for the target brand are displayed as options.
    • You can filter the landed cost billers using the search field.

Enter Charge Details​

To add multiple charge lines, click the Add Charge button to add input rows.
To remove an unnecessary charge line, click Remove for the target row.

  1. Charge category (Required)
    Select a charge category from the pull-down menu. 国際海上・航空運賃 (International ocean and air freight) is set as the initial value.

    • 国際海上・航空運賃 (International ocean and air freight)
    • 貨物海上保険料 (Cargo marine insurance)
    • 関税 (Customs duty)
    • 通関料・取扱手数料 (Customs clearance and handling fee)
    • 国内区間の輸送費(港→倉庫) (Domestic transportation cost (port → warehouse))
    • 買付手数料 (Buying commission)
    • 送料(仕入先からの引取運賃) (Shipping fee (pickup freight from supplier))
  2. Tax rule (Required)
    Depending on the charge category, the value is fixed and cannot be changed.

    When the charge category is 買付手数料 (Buying commission), select one of the following from the pull-down menu.

    • 課税10% (Consumption tax 10%)
    • 課税8%(軽減税率) (Consumption tax 8% (reduced tax rate))
    • 輸出免税 (Export tax exemption)
    • 非課税 (Tax-exempt)
    • 不課税 (Out of scope)

    For the tax rules and allocation methods that can be specified for each charge category, see Charge categories.

  3. Landed cost charge amount (Required)
    Enter the charge amount.

    • Enter the tax-exclusive amount.
    • You can enter a number greater than or equal to 0. You can enter 0, but you cannot create a landed cost when the amount is blank or negative.
    • Commas for three-digit grouping and currency symbols cannot be used.
  4. Allocation method (Required)
    Select how to allocate the charge to receipt lines.
    When the charge category is 関税 (Customs duty), the allocation method is fixed to Manual amount and cannot be changed.

    Select one of the following from the pull-down menu.

    • Received quantity: Automatically allocates the charge according to the ratio of the receipt quantities.
    • Landed cost allocation by amount: Automatically allocates the charge according to the ratio of the basis amounts calculated from the quantity and receipt base unit cost of each receipt line.
    • Manual amount: Enter an allocation amount for each receipt line subject to allocation.

    When the total receipt quantity or amount used as the allocation basis is 0 and the charge amount is greater than 0, select Manual amount.

    When Manual amount is selected, enter an allocation amount for each target receipt line in Allocate Costs to Receipt Lines.

  5. Description
    Enter a description as needed. You can register the description as a memo.

    The description can contain up to 1,000 characters and can be left blank.

Select Receipts​

  1. Select the receipts to which to allocate the charge.

    Select the checkboxes for the target receipts.

    • You can select multiple receipts.
    • You can filter receipts by receipt document number, document date range, and goods supplier.
      • To filter receipts, enter the conditions and click the Search button.

When you select a receipt, its receipt lines are loaded into Receipt line allocation.

Allocate Costs to Receipt Lines​

info

When multiple charge lines are registered, allocate the cost for each charge line.

To set allocation targets for each charge line, click Edit allocation targets in the target charge category row.

The Receipt line allocation screen displays the charge category whose allocation targets are being edited.

  1. Select allocation targets
    Select the checkboxes for the receipt lines to use as allocation targets.

    • You must specify at least one allocation target for each charge line.
    • Each selected receipt must be used as an allocation target for at least one charge line.
  2. Enter the Landed cost allocated amount
    Enter the amount when the charge category is 関税 (Customs duty) or when Manual amount is selected as the allocation method.

    Enter the allocation amount for each target receipt line in Manual amount.

    • Enter an allocation amount for every target receipt line.
    • For a receipt line with a receipt quantity of 2 or more, enter the total charge amount for the entire receipt line in Manual amount, not the amount per item.
    • Enter the amounts so that the total of the entered allocation amounts matches the tax-exclusive charge amount.
      • You cannot create a landed cost when the total of the entered allocation amounts does not match the tax-exclusive charge amount.

    When Received quantity or Landed cost allocation by amount is selected as the allocation method, the amount is allocated automatically and does not need to be entered.

  3. Allocation preview
    Click the Preview Allocation button.

    Server allocation preview is displayed. Check the tax-exclusive amount, allocation method, allocation targets, allocation amounts, and other details for each charge category.

    If you change the input contents or allocation targets after the preview, click Preview Allocation again.

Create a Landed Cost​

  1. After reviewing the details in Server allocation preview, click the Create Landed Cost Draft button.

    When processing succeeds, the landed cost is created. The status of the landed cost immediately after creation is Draft.

Important Notes​

Receipt Lines and Suppliers That Cannot Be Used as Allocation Targets​

The following receipt lines and suppliers cannot be used to create a landed cost.

  • Receipts with a Unconfirmed status cannot be used as allocation targets for landed costs.
  • Suppliers with only Goods supplier enabled for Usage cannot be used as a landed cost biller.

Even for a confirmed receipt, receipt lines that are not subject to inventory cost calculation cannot be used as allocation targets for a landed cost.

If the same receipt contains receipt lines that are subject to inventory cost calculation, you can use only those receipt lines as allocation targets. Receipt lines that are not subject to inventory cost calculation are not excluded automatically, so remove them from the allocation targets.

Specify Allocation Targets for Each Charge Line​

Selecting a receipt does not automatically make all of its receipt lines allocation targets.

Each selected receipt must be used as an allocation target for at least one charge line.
Specify allocation target receipt lines for each charge line.

If you do not use a selected receipt, remove the receipt from the selection. Removing a receipt from the selection also removes its allocation target selections and manual allocation amounts.

Automatic Allocation Cannot Be Performed When the Allocation Basis Is 0​

For automatic allocation, if the total of the receipt quantities or basis amounts selected as allocation targets is 0 for a charge line and the charge amount is greater than 0, you cannot run the allocation preview.

Review the allocation targets to set a valid allocation basis, or change the allocation method to Manual amount and enter an allocation amount for each target receipt line.

Do Not Include the Same Charge in Inventory Cost Twice​

Do not include a charge in inventory cost as a landed cost if it has already been included in inventory cost as an additional charge on the receipt.

Do not include the same charge in inventory cost both through the receipt and through a landed cost.

For information on creating a receipt, see Create a Purchase Receipt from a Supplier.

Troubleshooting​

When "Preview Allocation" Cannot Be Executed​

If you cannot click the "Preview Allocation" button, check the following items.

  • A landed cost biller is selected.
  • An occurrence date is entered and is valid.
  • An amount is entered for every charge line.
  • A charge category and tax rule are set.
  • At least one confirmed receipt is selected.
  • The selected receipts have finished loading.
  • At least one receipt line is selected as an allocation target for each charge line.
  • When Manual amount is selected, an amount is entered for every target receipt line.

If receipt loading fails, reload the receipts and check their contents. Remove unused receipts from the selection.

The document number and description are optional, so you can run the allocation preview without entering them.

When an Error Is Displayed After Running the Allocation Preview​

If an error is displayed after you run "Preview Allocation", check the following items.

  • The charge amount and manual allocation amounts are not negative or invalid numbers.
  • The total manual allocation amount for each charge line matches the tax-exclusive amount for that charge line.
  • The total receipt quantity or basis amount used for automatic allocation is not 0.
  • No receipt line that is not subject to inventory cost calculation is selected as an allocation target.
  • Every selected receipt is used as an allocation target for at least one charge line.
  • The receipt status or contents have not changed after the receipt was selected.
  • The current settings allow inventory cost processing, including inventory valuation being enabled.

If the receipt status or contents have changed, reload the receipts, check the targets, and run the allocation preview again.