Skip to main content

Bulk Import Delivery Notes (Excel)

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 feature uses an import Excel file (.xlsx) to create multiple delivery notes in bulk with Inventory Management (New Method).

Purpose​

Importing multiple delivery notes in an XLSX file reduces the time required to create delivery notes one by one.

Feature Description​

What Is Bulk Import of Delivery Notes?​

Bulk importing delivery notes allows you to use an import XLSX file to create Original delivery notes and delivery notes based on Order Confirmation Lines.

Rows with the same delivery note number are registered as one delivery note.

The import creates the delivery notes. Complete delivery and shipping operations must be performed separately afterward.

For information about creating delivery notes individually or changing the status of delivery notes, see the following manuals.

Types of Delivery Notes by Data Source​

Bulk importing delivery notes allows you to create the following types of delivery notes, depending on the specified data source.

  • Original: Creates an Original delivery note that is not linked to an order.
  • Order Confirmation Lines: Creates a delivery note based on lines included in a confirmed Order Confirmation.

When creating a delivery note based on Order Confirmation Lines with Item Type set to SKU, you can create the delivery note within the quantity remaining on the original order line. Quantities used in incomplete delivery notes are also treated as used quantities.

Item Types​

Use Item Type to specify the type of line to register on the delivery note.

  • SKU: A line that specifies a product model number and SKU number registered in the product master.
  • Custom Item: A line for items other than product SKUs, such as packing or processing charges.

You can combine SKU and Custom Item lines in one delivery note.

Differences in Input Items by Data Source and Item Type​

The required and applicable fields vary depending on the specified Data Source and Item Type.

The items required for all lines are Delivery Note Number, Item Type, Buyer Code, Invoice Creation Allowed (true, false), and Quantity.

Required Items​

Data SourceItem TypeRequired Items
Original
or blank
SKUProduct Model Number, SKU Number, Apply Inventory (true, false)
Original
or blank
Custom ItemCustom Item Name, Unit Price (Excluding Tax), Apply Inventory (true, false)
Order Confirmation LinesSKUOrder Confirmation Number, Product Model Number, SKU Number
Order Confirmation LinesCustom ItemCustom Item Name, Unit Price (Excluding Tax)

Creating an Original Delivery Note​

When Original is specified as the Data Source, or the Data Source is blank, an Original delivery note is created.

When the Item Type is SKU, you can specify inventory allocation conditions as needed. For details about inventory handling, see Inventory Handling.

Creating a Delivery Note Based on Order Confirmation Lines​

When Order Confirmation Lines is specified as the Data Source, a delivery note is created based on lines included in the confirmed Order Confirmation.

When the Item Type is SKU, enter the values corresponding to the original order line in Order Confirmation Number, Product Model Number, and SKU Number.
If the original order line cannot be identified using only Order Confirmation Number, Product Model Number, and SKU Number, enter Option Selection.

If the product has no options or the order line can be identified using the entered items, Option Selection is not required. You can check the codes for options and option variations in Create a Product Option.

A delivery note based on Order Confirmation Lines must contain at least one SKU line linked to an order. A delivery note containing only Custom Item lines cannot be created.

Unused Items​

Data SourceItem TypeUnused Items
Original
or blank
SKUCustom Item Name
Original
or blank
Custom ItemProduct Model Number, SKU Number
Order Confirmation LinesSKUCustom Item Name, Apply Inventory (true, false), Facility Code, Location Code, Inventory Segment Code, Lot Code, Expiry Date
Order Confirmation LinesCustom ItemOrder Confirmation Number, Product Model Number, SKU Number, Apply Inventory (true, false), Facility Code, Location Code, Inventory Segment Code, Lot Code, Expiry Date

Leave unused items blank.
When a delivery note based on Order Confirmation Lines contains Custom Item lines, specify Order Confirmation Lines as the data source for Custom Item rows as well.

Inventory Handling​

For an Original delivery note, when Item Type is SKU, inventory handling varies according to the value of Apply Inventory (true, false).

When Item Type is Custom Item, inventory is not allocated regardless of the value of Apply Inventory (true, false).

  • true: Allocates available free inventory when the delivery note is registered.
  • false: Creates a delivery note that is not linked to inventory.

When true is specified for Apply Inventory (true, false), you can specify inventory allocation conditions using the following items. When false is specified, leave these items blank because they are not used.

  • Facility Code, Location Code, Inventory Segment Code, Lot Code, and Expiry Date

When a condition is specified, inventory is filtered by that condition. When no condition is specified, inventory is allocated without filtering by that condition.

If the required quantity cannot be secured for a delivery note to which inventory is applied, the delivery note is not registered.

For information about how to check each item, see the following manuals.

Import Results​

After the import, the processing results are displayed in the import screen. You can see whether all, some, or none of the delivery notes were registered successfully.

You can check the number of delivery notes, the number of successful registrations, the number of failed registrations, and the registration result and failure reason for each delivery note number. The count is based on the number of delivery notes, not the number of rows in the Excel file.

Depending on the entered values or inventory availability, registration may succeed or fail for each delivery note. Other delivery notes in the same file may be registered even if one delivery note fails to register.

When you need to check the entered values or inventory, check the displayed delivery note number, Excel row number, item name, reason, and correction method.

If an error is found before registration, registration of the entire file does not start.

Instructions​

Follow these steps to bulk import delivery notes.

  1. Download the Import XLSX File
  2. Enter Data in the Import XLSX File
  3. Import the XLSX File

1. Download the Import XLSX File​

  1. Click the Transactions menu > Delivery Management.
  2. Click the Bulk Import Delivery Notes button.
    The "Import Inventory V2 Delivery Notes" modal opens.
  3. Click the Download Inventory V2 delivery notes template button.
    The import XLSX file is downloaded.

2. Enter Data in the Import XLSX File​

Open the downloaded import XLSX file and enter data starting from row 3 in the delivery_notes sheet.

Do not change the column names.
Changing the column names may cause an import error.

Input Item Details​

The required items vary depending on the specified Data Source and Item Type. For details, see Differences in Input Items by Data Source and Item Type.

Enter the values for the fields as follows.

info

For rows with the same Delivery Note Number, use the same values for Buyer Code, Delivery Date, Invoice Creation Allowed (true, false), and Data Source.

When creating an Original delivery note, use the same value for Apply Inventory (true, false) as well.

The quantities for rows with the same Product Model Number and SKU Number in one delivery note may be aggregated depending on the conditions.

  • Delivery Note Number (Required)
    Enter the number of the delivery note to create.

    • Rows with the same value are grouped into one delivery note.
    • Registered delivery note numbers cannot be used.
  • Item Type (Required)
    Select one of the following from the drop-down menu.

    • SKU: Registers a product on the delivery note.
    • Custom Item: Registers a charge such as packing or processing on the delivery note.
  • Buyer Code (Required)
    Enter the unique code for the buyer.

    • When the data source is Order Confirmation Lines, it must match the buyer of the specified Order Confirmation.
    • For details about how to check or edit the Unique Code, see Edit a Buyer.
  • Delivery Date
    Enter the date in YYYY-MM-DD format. For example, 2026-01-15.

    When blank, the delivery note is created without a delivery date.

  • Invoice Creation Allowed (true, false) (Required)
    Select from the drop-down menu whether the delivery note can be linked to an invoice.

    • true: Allows the delivery note to be linked to an invoice.
    • false: Makes the delivery note ineligible for invoicing.

    When the data source is Order Confirmation Lines and the Order Confirmation is linked to a settled order, specify false. If true is specified, an error occurs during the pre-import check.

    Specifying true does not automatically create an invoice during the import. The delivery note is created in a state that allows it to be linked to an invoice later.

  • Product Model Number
    Enter the Product Model Number registered in the product master.
    Required when Item Type is SKU.

  • SKU Number
    Enter the SKU Number registered for the specified Product Model Number.
    Required when Item Type is SKU.

  • Custom Item Name
    Enter the name of the line to be displayed on the delivery note.
    Required when Item Type is Custom Item.

  • Custom Item Description
    Enter a supplementary description of the Custom Item. This can be left blank.

  • Unit Price (Excluding Tax)
    Enter the tax-exclusive unit price. Enter numbers only, without a currency symbol or thousands separators.

    • When Item Type is SKU: Optional.
      • When the data source is Original and this field is blank: The price corresponding to the buyer's transaction terms and currency is automatically populated.
      • When the data source is Order Confirmation Lines and this field is blank: The unit price of the original order line is used.
    • When Item Type is Custom Item: A tax-exclusive unit price is required.
  • Quantity (Required)
    Enter the delivery quantity. Enter an integer.

    • When the data source is Order Confirmation Lines and Item Type is SKU, enter a positive number no greater than the remaining quantity available for creation. If the entered quantity exceeds the remaining quantity or an order line whose entire quantity has already been used is specified, an error occurs and the delivery note cannot be registered.
    • The quantities for rows with the same Product Model Number and SKU Number in one delivery note may be aggregated depending on the conditions.
  • Applicable Tax Numbers
    Enter the tax identification number registered in the tax master under Maker Settings.

    • Specify an available tax applicable to the country of the buyer specified by Buyer Code.
    • To specify multiple taxes, separate them with a half-width comma, such as TAX-A,TAX-B.

    When blank

    • When Item Type is SKU: The handling varies depending on the data source.
      • When creating an Original delivery note: The tax configured for the product that applies to the buyer's country is applied.
      • When creating a delivery note based on Order Confirmation Lines: The tax configured for the original order line is used.
    • When Item Type is Custom Item: The line is treated as tax-free.

    For details about tax settings, see Create a Tax Master.

tip

Apply Inventory (true, false) is used when creating an Original delivery note.

The following five inventory allocation condition items are used for an Original delivery note when Item Type is SKU.

Facility Code, Location Code, Inventory Segment Code, Lot Code, and Expiry Date

When creating a delivery note based on Order Confirmation Lines, leave the inventory allocation condition items blank and proceed to Data Source.

  • Apply Inventory (true, false)
    Select whether to apply inventory from the drop-down menu.
    Required when creating an Original delivery note.

    • true: Allocates available free inventory to the SKU.
      • You can specify inventory allocation conditions as needed. For details, see Inventory Handling.
    • false: Creates a delivery note that is not linked to inventory.
      • Because inventory is not allocated, leave the inventory allocation condition items blank and proceed to Data Source.

    This field is also required when creating an Original delivery note containing only Custom Item lines.

    • You can specify either true or false. Inventory is not allocated in either case.
    • Leave the inventory allocation condition items blank and proceed to Data Source.
  • Facility Code
    Enter a facility code to filter the inventory allocation source by facility.

  • Location Code
    Enter a location code to filter the inventory allocation source by location.

    When a facility code is specified, specify a location belonging to that facility.

  • Inventory Segment Code
    Enter an inventory segment code to filter the inventory allocation source by inventory segment.

  • Lot Code
    Enter a lot code to allocate inventory from the specified lot.

    When no lot code is specified, inventory is allocated from stock matching the other conditions without filtering by lot.

  • Expiry Date
    Enter an expiry date to restrict allocation to matching inventory.

    Enter the date in YYYY-MM-DD format. When no date is specified, inventory is allocated without using the expiry date as a condition.

    • When Lot Code is blank and only Expiry Date is specified, the lot is not limited and inventory matching the specified expiry date is allocated.
    • Only inventory matching the specified date is targeted; inventory dated after or before it is not included.
  • Data Source
    Specify one of the following. You can select it from the drop-down menu. When blank, it is treated as Original.

    • Original: Creates a delivery note that is not linked to an order.
    • Order Confirmation Lines: Creates a delivery note based on lines included in the confirmed Order Confirmation.

    A delivery note based on Order Confirmation Lines must contain at least one SKU line linked to an order.
    When creating a delivery note containing only Custom Item lines, specify Original as the data source or leave the field blank.

  • Order Confirmation Number
    Enter the number of the Order Confirmation on which the delivery note is based.
    Required when the data source is Order Confirmation Lines and Item Type is SKU.

    Leave this field blank when Item Type is Custom Item or when creating an Original delivery note.

  • Option Selection
    Used when the data source is Order Confirmation Lines and Item Type is SKU.
    Specify this when the original order line cannot be identified using only the Order Confirmation Number, Product Model Number, and SKU Number.

    • Leave this field blank when the order line can be identified.
    • Specify Option Selection in the format Option No.=Option Variant No..
      For example, enter WRAP=GIFT. To specify multiple options, separate them with a half-width comma. (Example: WRAP=GIFT,PRINT=LOGO)

    Leave this field blank when Item Type is Custom Item or when creating an Original delivery note.

3. Import the XLSX File​

  1. Click the Transactions menu > Delivery Management.

  2. Click the Bulk Import Delivery Notes button.
    The "Import Inventory V2 Delivery Notes" modal opens.

  3. Click the Select File button.

  4. Select the created import XLSX file.

  5. Click the Import Inventory V2 delivery notes button.

    After the import, successfully registered delivery notes appear, and the registration result for each delivery note number is displayed.

    Click the Refresh and check Delivery Management button to refresh the delivery note list and close the import result display.

    If delivery note registration fails, the reason for the failure is displayed.

Important Notes​

Do Not Change the Template Structure​

Data is imported from the delivery_notes sheet. Data in the "Input Examples and Descriptions" sheet is not imported.

Do not change the sheet names, headings, template identification information, or hidden sheets in the XLSX file.

Files modified only by adding columns and files with changed headings cannot be imported.

Use the XLSX template for Inventory Management (New Method). XLSX files for Inventory Management (Conventional Method) cannot be used.

Be Careful When Entering Delivery Note Numbers​

Rows with the same Delivery Note Number in Excel are processed as one delivery note during the import.

Do not enter the same delivery note number for delivery notes intended for different buyers or for data that should be separated into different delivery notes.

Conversely, if you enter a different delivery note number for every row, data that should have been combined is created as separate delivery notes, which may unintentionally create a large number of delivery notes.

Specifying the Data Source​

You can create Original delivery notes and delivery notes based on Order Confirmation Lines together in one XLSX file.

However, Original and Order Confirmation Lines cannot be mixed within the same Delivery Note Number. Enter different delivery note numbers for delivery notes with different types.

Notes When Applying Inventory​

When creating an Original delivery note with Item Type set to SKU, specifying true for Apply Inventory (true, false) allocates available free inventory when the delivery note is registered. If the required quantity cannot be secured, the delivery note is not registered, so check the available inventory and allocation conditions in advance.

Inventory allocation performed when the delivery note is registered is separate from delivery completion and shipping operations.

Quantity for Order Confirmation Lines​

When the data source is Order Confirmation Lines and Item Type is SKU, enter a delivery quantity no greater than the quantity remaining on the original order line. Quantities used in existing incomplete delivery notes are also treated as used quantities.

If the entered quantity exceeds the remaining quantity or no quantity remains because the entire quantity has been used, an error occurs and the target delivery note cannot be registered. The entered quantity is not automatically reduced to the remaining quantity, and the applicable row is not automatically skipped.

Errors Before Import​

If an error is found during the pre-import check, the file is not imported. Correct the applicable row and import the file again.

Re-importing When the Result Is Unknown​

The registration status of a delivery note may be unknown due to a communication failure or an interrupted process.

If the result is unknown, do not immediately import the same file again because you cannot confirm whether the delivery notes have already been registered. Check the registration status in Delivery Management and re-import only the unregistered delivery notes. When the result is unknown, you cannot select and import the file again from the same screen.