How to Conduct Inventory Counting with SAP Business One - SAP Business One 9.0 - Guide

Sep 22, 2026

Upload by Finn

How to Conduct Inventory Counting with SAP Business One explains how inventory counting (stock taking) supports accurate reconciliation between physical quantities and database records. It describes how the enhanced inventory counting solution in SAP Business One 9.0 (including patch level 9 on Microsoft SQL and SAP HANA) helps companies detect discrepancies, adjust records, and improve inventory management. It also clarifies that inventory changes require posting via an inventory posting document and covers entering or importing counting results for a single finalized set.

LanguageEnglish

CategoryPresentations

FormatPDF

Pages30

Reading Time11 min

AccessFree to download

1 Introduction

1.1 Counting Scenarios

1.2 Counters' Difference Versus Maximum Variance for Multiple Counters

1.3 User Counters Versus Employee Counters

1.4 Changes for Upgraded Companies

2 Defining Counting Settings

2.1 Calculation of In-Warehouse Quantities on Count Date

3 Creating Inventory Counting Documents

3.1 Manually Entering Counting Results

3.2 Importing Counting Results from Microsoft Excel

3.2.1 Example of Preparing Import Data

4 Posting Counting Results

4.1 Copy-To Method

4.2 Copy-From Method

5 Printing Inventory Counting Documents

Appendix: Importing Rules for Inventory Records

How-to Guide SAP Business One 9.0 Document Version: 1.3 – 2014-08-13 PUBLIC How to Conduct Inventory Counting with SAP Business One SAP Business One 9.0 and SAP Business One 9.0, version for SAP HANA Typographic Conventions | Type Style | | Description | | | | | | --- | --- | --- | --- | --- | --- | --- | | Example | | Words or characters quoted from the screen. These include field names, screen titles, pushbuttons labels, menu names, menu paths, and menu options.
Textual cross-references to other documents. | | | | | | Example | | Emphasized words or expressions. | | | | | | EXAMPLE | | Technical names of system objects. These include report names, program names, transaction codes, table names, and key concepts of a programming language when they are surrounded by body text, for example, SELECT and INCLUDE. | | | | | | Example | | Output on the screen. This includes file and directory names and their paths, messages, names of variables and parameters, source text, and names of installation, upgrade and database tools. | | | | | | Example | | Exact user entry. These are words or characters that you enter in the system exactly as they appear in the documentation. | | | | | | | | Variable user entry. Angle brackets indicate that you replace these words and characters with appropriate entries to make entries in the system. | | | | | | | | | | | | | | EXAM PLE | | Keys on the keyboard , for example, | F2 | or | EN TER | . | | | | | | | | | Document History | Version | Date | Change | | --- | --- | --- | | 1.0 | 2014-01-10 | First version, for SAP Business One 9.0 PL09 (Microsoft SQL and SAP HANA) | | 1.1 | 2014-02-12 | Highlight Rows where Counters Variance is Greater Than field changed to Highlight Rows with Max Variance Greater Than in the Document Settings window | | 1.2 | 2014-06-25 | Depending on the user setting, inactive items may or may not be included in inventory counting transactions. | | 1.3 | 2014-07- | • Import of inventory opening balances is supported.
• Include prices and price currencies in the import of inventory posting records. | Table of Contents 1 Introduction ....................................................................................................................................................5 1.1 Counting Scenarios .................................................................................................................................................5 1.2 Counters' Difference Versus Maximum Variance for Multiple Counters ...........................................................6 1.3 User Counters Versus Employee Counters .......................................................................................................... 7 1.4 Changes for Upgraded Companies ........................................................................................................................ 7 2 Defining Counting Settings ..........................................................................................................................9 2.1 Calculation of In-Warehouse Quantities on Count Date ..................................................................................... 11 3 Creating Inventory Counting Documents ................................................................................................. 13 3.1 Manually Entering Counting Results .................................................................................................................... 13 3.2 Importing Counting Results from Microsoft Excel ............................................................................................. 15 3.2.1 Example of Preparing Import Data ...................................................................................................... 17 4 Posting Counting Results .............................................................................................

FAQs

Why is inventory counting important in SAP Business One?

Inventory counting reconciles actual stock with quantities stored in the database. Matching these quantities enables adjustments to existing records and helps identify unusual discrepancies.

What must be done after creating an inventory counting document?

After creating an inventory counting document, inventory changes must be posted by creating an inventory posting document based on it. This is required to apply adjustments in the system.

Can counting results be entered and imported multiple times?

Counting results can be entered or imported into an inventory posting document, but only one final set of counting results can be recorded. It is not possible to record multiple counter result sets as the final outcome.

Sep 22, 2026

Upload by Finn