Bulk Import Delivery Notes (Excel)
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.
- Change the Delivery Note Status
- Create a Delivery Note
- Create a Delivery Note Directly from an Order
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 Source | Item Type | Required Items |
|---|---|---|
| Original or blank | SKU | Product Model Number, SKU Number, Apply Inventory (true, false) |
| Original or blank | Custom Item | Custom Item Name, Unit Price (Excluding Tax), Apply Inventory (true, false) |
| Order Confirmation Lines | SKU | Order Confirmation Number, Product Model Number, SKU Number |
| Order Confirmation Lines | Custom Item | Custom 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 Source | Item Type | Unused Items |
|---|---|---|
| Original or blank | SKU | Custom Item Name |
| Original or blank | Custom Item | Product Model Number, SKU Number |
| Order Confirmation Lines | SKU | Custom Item Name, Apply Inventory (true, false), Facility Code, Location Code, Inventory Segment Code, Lot Code, Expiry Date |
| Order Confirmation Lines | Custom Item | Order 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, andExpiry 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.
- For facilities, see Edit an Inventory Facility.
- For locations, see Edit an Inventory Location.
- For inventory segments, see Edit an Inventory Segment.
- For lot codes, see Create a Purchase Receipt from a Supplier.
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
- Click the Transactions menu > Delivery Management.
- Click the Bulk Import Delivery Notes button.
The "Import Inventory V2 Delivery Notes" modal opens. - 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.
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 inYYYY-MM-DDformat. 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.
- When Item Type is SKU: Optional.
-
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.
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.
- Because inventory is not allocated, leave the inventory allocation condition items blank and proceed to
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.
- true: Allocates available free inventory to the SKU.
-
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-DDformat. When no date is specified, inventory is allocated without using the expiry date as a condition.- When
Lot Codeis blank and onlyExpiry Dateis 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.
- When
-
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 Selectionin the formatOption No.=Option Variant No..
For example, enterWRAP=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
-
Click the Transactions menu > Delivery Management.
-
Click the Bulk Import Delivery Notes button.
The "Import Inventory V2 Delivery Notes" modal opens. -
Click the Select File button.
-
Select the created import XLSX file.
-
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.