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
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
- Item Groups and Units of Measure groups (set up manually or via DTW).
- Warehouses and, if used, bin locations.
- Item Master Data (
oItems), including warehouse-level settings. - Opening quantities and values, posted via a Goods Receipt (
oInventoryGenEntry) or the Inventory Opening Balance function. - 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.
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