What are the types of physical inventory in SAP?

by | Sep 11, 2022 | Articles

What are the types of physical inventory in SAP?

Physical inventory taking is the process of counting the stock present at a warehouse for balance sheet purposes. The stock in question could be the company’s stock or special stock such as consignment stock at the customer location or stock from the vendor.

The stock-taking process is done separately on each material present. The physical inventory process however does not include stocks that have been blocked, stocks that have been returned, or stocks in transfer. To include such stocks, they need to be moved to other stocks that are to be included in the inventory.

SAP physical inventory is done at the storage location level. Each separate location needs a different inventory sheet for the quantity of the goods located in the warehouse. Methods used for physical inventory taking are mentioned below.

Periodic Inventory

In this physical inventory process, the stock is counted physically at the location. All materials that are present are counted separately. During the counting of stock, no movement of goods in or out of the storage location is permitted.

It is the most used method of taking the physical inventory process in SAP. The process takes place once a year and is mostly done at the end of a season to check the level of goods that remain and the difference from year to year can be measured in the reports stored in the system.

Inventory Sampling

The inventory sampling process takes randomly selected stock from a location and a count is made on a balance sheet key date. The closeness of the data to how correct it should be according to the system and quantity present leads to the assumption that other stocks stored in the warehouse are close to the same variance and are thus correct. The differences between the book balance and the count should be small.

Continuous Inventory

This physical inventory count takes place throughout the entire fiscal year. All materials are required to be counted and involved in the report at least once. The process can be done at any time.

The difference in stock level and quantity is documented each time regardless of the season beginning or end. The clear levels of the movement of goods within the warehouse are always known and accounted for regularly in the storage location.

Cycle Counting

In this physical inventory process, stock counts are taken at regular intervals throughout the entire fiscal year. A set indicator for all goods determines when they will be counted and the levels documented. This indicator determines the intervals or cycles for each material.

In this method, determining the differences between different groups of materials is easier to establish. Faster moving cycles or groups of stock are counted more often than slower moving cycles or groups of materials. The categories are then documented in the master document awaiting reports and the formation of pdfs.

It is a more accurate method of physical inventory of assets to be reported as most of the inventory is counted and in a more frequent manner.

Restrictions

There are, however, restrictions to such inventory-taking procedures.

Active batch status management allows for a stock type to cover restricted-use stock and unrestricted-use stock.
If a given type of goods has never been stored at a location meaning there has never been any movement of such material in said warehouse, there is no way to make physical inventory for the material in that location as there are no previous data records of its existence.

However, a zero balance of a different material does not mean it does not exist, there is just none left in storage. This means there are previous records in the data showing movement and previous transactions of the stock and that it has existed in the said location. A physical inventory of such a material is taken as the storage data is still available showing the material has been present with a stock balance of zero remaining.

The data of each inventory taken is stored in the master together with all storage location data of all materials present. This is used to correlate reports of physical inventory and previous existing levels of materials stored. Thus warranting the need for separate documents for separate locations.

scantronix