Back to Tutorials
DTW & Migration•3 min read
TUTORIAL • FREE MEMBER

DTW Masterclass: Importing Item Master Data and Opening Stock (with Batches & Serials)

Import thousands of items and their opening quantities in the right order, with correct valuation and batch/serial numbers on day one.

SB1

SAP B1 Academy Editorial

Published • 3 min read

Save
Warehouse stock prepared for an ERP go-live cutover.
Warehouse stock prepared for an ERP go-live cutover. (Image source: SAP B1 Academy Lab)

Inventory is usually the largest and riskiest dataset in an SAP Business One migration. Get the items wrong and every sales order breaks; get the opening stock wrong and the balance sheet is wrong from day one. This guide shows the import sequence we use on every go-live.

The Correct Import Sequence

  1. Item Groups and Units of Measure groups (set up manually or via DTW).
  2. Warehouses and, if used, bin locations.
  3. Item Master Data (oItems), including warehouse-level settings.
  4. Opening quantities and values, posted via a Goods Receipt (oInventoryGenEntry) or the Inventory Opening Balance function.
  5. Batch and serial numbers, imported as child rows of the opening stock document.

Importing opening stock before G/L account determination is configured is the most common cause of stock values landing on the wrong account. Double-check Item Group → Accounting first.

Free Member Content

Create a free account to unlock the full step-by-step guide & copy the production SQL script.

Join SAP Business One consultants and key users worldwide. Free forever, no credit card required.

or use a magic link