Outlining Physical Inventory Methods

Objective

After completing this lesson, you will be able to outline the physical inventory methods available in SAP S/4HANA.

Core Methods Available in SAP S/4HANA Public Cloud Edition

The SAP S/4HANA Cloud Public Edition solution makes various physical inventory methods available to the user. The methods have different time scales and organizational inventory procedures.

Diagram outlines four main physical inventory methods—periodic inventory, cycle counting, continuous inventory, and inventory sampling, illustrating options for conducting inventory processes.

Periodic (annual or fixed-date) inventory

Periodic inventory is a full count of all relevant stock on a specific key date, typically at fiscal year-end. Operations may be paused or tightly controlled during the count, and any differences between book and physical stock are posted after reconciliation.

Continuous (perpetual) inventory

With continuous inventory, counts are spread throughout the year instead of being done all at once. Each storage bin or material is counted at least once within the defined period, and normal operations continue during inventory. Differences are posted as they are found, avoiding a year-end shutdown.

Cycle counting

Cycle counting is a structured form of continuous inventory that uses ABC (or similar) classification to set different count frequencies by item criticality, value, or movement. High-priority items are counted more frequently than lower-priority items, improving control where it matters most.

Inventory sampling

With inventory sampling, counting is limited to a representative number of items and the results are extrapolated for all stock management units. If discrepancies in the sample remain within defined statistical tolerances, the remaining inventory is accepted; if not, a full count is triggered. Audit acceptance varies by jurisdiction and policy.

Note

  • For Extended Warehouse Management (EWM)-managed storage locations, physical inventory is executed in embedded EWM with its own physical inventory document, counting, and difference posting apps. The results then reconcile to Inventory Management.
  • Specific app names can vary slightly by release and role catalogs; the core steps remain the same.

Periodic Inventory

Let's take a closer look at periodic inventory.

Periodic inventory is a scheduled physical count performed at a defined point in time to determine the exact quantities of stock on hand. Its objective is to reconcile physical counts with inventory ledger balances, investigate and document any variances, and post the necessary adjustments to accounting records. Having accurate inventory records is essential for reliable financial reporting and compliance with statutory, tax, and audit obligations. Plus, they help make good decisions in management and day-to-day operations.

Periodic inventory process steps:

  1. Preparation: Plan scope and date, communicate cutoff rules, and apply posting blocks if needed at the material or storage location level.
  2. Create physical inventory documents: Create documents for the selected plant/storage location/materials. In SAP Fiori, use the Create Physical Inventory Document app.
  3. Print/distribute count sheets: Provide counters with the inventory documents and instructions. You can use the print functions in the Create Physical Inventory Document app.
  4. Perform the physical count: Teams count stock on the key date, noting batches/serials where relevant.
  5. Enter counts: Record results against each inventory document. In SAP Fiori, use the Enter Inventory Count app.
  6. Count: Stock is physically counted and results are documented, potentially using handheld devices for recording. This data is then entered into SAP systems, either directly or through a data communication interface.
  7. Investigate and, if needed, recount: Review large variances and trigger recounts or create a new inventory document for recheck.
  8. Post differences: After approval, post variances to update book stock and post accounting differences. Use the Post Inventory Differences app.
  9. Close and unblock: Finalize documents, remove posting blocks, and archive as required. Review the List of Inventory Differences for audit.

Continuous Inventory

Let's look at the steps for continuous, or perpetual, inventory.

  1. Plan rolling counts: Schedule materials/bins throughout the year so each is counted at least once in the defined period. Normal operations continue during the counts.
  2. Create physical inventory documents as per the schedule: Create and release documents for each planned area. In SAP Fiori, use the Create Physical Inventory Document app.
  3. Count and enter results: Perform the count and record the results. Use the Enter Inventory Count app.
  4. Post differences and monitor: Promptly post any variances in the Post Inventory Differences app. In addition, use lists/reports to ensure coverage and resolve issues by using the Monitor Physical Inventory app.

Cycle Counting

Follow these steps to perform cycle counting.

  1. Classify materials: Define cycle counting indicators and frequencies in customizing. Optionally, you can run ABC analysis to propose indicators.
  2. Assign indicators: Maintain the cycle counting indicators in the material master at plant/storage-location level.
  3. Generate physical inventory documents: Automatically create inventory documents for materials due, based on the last count date and indicator. Fiori: Scheduled creation via job apps or Manage Physical Inventory Documents
  4. Execute counts: Print/distribute, count, and enter the results in the Enter Inventory Count app.
  5. Post differences: Update stock and accounting for variances. In SAP Fiori, use the Post Inventory Differences app.
  6. Monitor adherence: Use monitoring apps to ensure required frequencies are met and address recurring variances.

Inventory Sampling

Let's have a look at the steps required for inventory sampling.

  1. Define the sampling procedure: Configure sampling rules, tolerances, and acceptance criteria in IMG. Confirm audit/legal acceptance for your jurisdiction.
  2. Create sample physical inventory documents: Select representative materials/bins and create inventory documents for the sample. In SAP Fiori, you can use the Create Physical Inventory Document app.
  3. Perform and record sample counts: Enter the results of the count. In SAP Fiori, use the Enter Inventory Count app.
  4. Evaluate the sample: The system or controller compares discrepancies to defined tolerances to decide whether to accept the count or escalate.
  5. Act on results: If the sample is accepted, close out; if not, expand to a broader or full count and post differences where applicable. In SAP Fiori, use the Post Inventory Differences app.

High-Level Comparison: When to Use Which Method

Here's a structured overview comparing periodic inventory (annual count), continuous inventory (cycle counting/permanent inventory), and inventory sampling, focusing on their characteristics, operational needs, and ideal use cases within SAP environments.

 Periodic inventory (annual count)Continuous inventory (cycle counting/permanent inventory)Inventory sampling
Frequency and TimingTypically conducted once a yearConducted continuously throughout the yearCan be periodic or continuous
Operational RequirementsRequires complete shutdown of operations for a full count. Needs thorough preparation and planning.Less disruptive, scattered effort across the year, focusing on high-value/critical items.Requires statistical methods to select samples. Simpler logistics, focused on minimal extrapolation errors.
Strengths and LimitationsEnsures comprehensive data for financial reporting and compliance. However, is resource-intensive and disruptiveIncreases accuracy with less operational disruption. Allows for quicker issue identification and resolution.Efficient and cost-effective, but not suitable for critical regulatory needs where every item's accuracy is important.
Best-Fit ScenariosIdeal for smaller inventories or when regulatory compliance dictates a full physical count.Suitable for large warehouses with diverse inventory items, especially wen inventory accuracy needs to be high.Best used when resource constraints prevent full inventory counts, and rough estimates suffice for operational needs.

When to use periodic inventory (annual count)

This method is often used when there is a legal or regulatory requirement to conduct a full physical count of inventory at least once a year. It is particularly beneficial for businesses with smaller inventories or those not overly reliant on inventory accuracy for daily operations. The comprehensive nature of this method ensures precise financial accounting at the cost of operational downtime.

When to use continuous inventory (cycle counting/permanent inventory)

This approach is beneficial for large operations with many inventory items, demanding constant accuracy for operational efficiency. Cycle counting reduces operational disruptions because it allows inventory checks to be smaller and more manageable. High-value or fast-moving items are typically prioritized, making it a strong choice for environments where frequent updates and adjustments are necessary to maintain accuracy.

When to use inventory sampling

Inventory sampling is appropriate when businesses want to minimize the efforts associated with full inventory counts while still maintaining reasonable inventory accuracy. It is particularly suited for operations where complete physical counts are impractical, and the accuracy provided by sampling is sufficient for decision making. It allows for cost-effective management and enhanced efficiency without sacrificing too much accuracy.

By understanding the strengths, limitations, and operational requirements of each method, businesses can select the approach that best aligns with their specific needs and constraints in SAP environments.

Summary

  • SAP S/4HANA Public Cloud supports periodic, continuous, and inventory sampling methods for physical stock management.
  • Periodic inventory requires a full count annually, ensuring compliance but disrupting operations.
  • Continuous inventory improves accuracy and reduces disruption by distributing counts over time.
  • Cycle counting is used to set the count frequency for items based on value or movements.
  • Inventory sampling estimates stock by counting a representative sample, saving time and resources while maintaining reasonable accuracy.
  • Selecting the right method depends on compliance needs, inventory size, and operational constraints.