In the normal course of business, inventory taking is carried out to verify the quantity and condition of items in the warehouse, and to provide information about existing inventory and inventory valuation to the auditors.
There are several ways to take inventory, of which cycle counting is the most common.
Recommendation
If your company conducts cycle counting, you can use cycle count recommendations to plan your counting date and time. You can receive an alert every time counting is due.
For more information, see Cycle Count Recommendations.
The following procedure describes what to do before and after taking inventory.
Before taking inventory, you can print out lists of items to be counted.
From the SAP Business One Main Menu, choose
.Select the Inventory Opening Balances tab.
Specify your selection criteria:
Select the items for inventory taking.
If necessary, narrow down the item range by specifying further selection criteria.
Choose the OK button.
The Inventory Tracking window appears.
To print the list of items, do one of the following:
In the toolbar, choose (Print).
In the menu bar, choose
.After taking inventory, you may need to record and reconcile inventories.
Note
When you record the inventory taking results, no corrective goods movements are posted.
Example
For item 0110, as displayed in the Inventory Opening Balances, Inventory Tracking, and Inventory Posting window, the Stock in Whse is 200. But after the factory floor worker conducts the inventory taking in the warehouse, the physical quantity is only 150.
The warehouse manager enters the updated quantity in the Counted in Whse column on the Inventory Tracking tab and chooses the Update button to save the updated quantity and the value of the inventory in the system. The manager can also see the difference of -50 on the Inventory Posting tab.
Once the inventory count has been completed in the other warehouses, the manager can see the total quantity of item 0110 in all warehouses, in both the Inventory in Warehouse Report and the item master data.
From the SAP Business One Main Menu, choose
.Select the Inventory Tracking tab.
Specify your selection criteria:
Specify the item numbers and/or the business partner codes of the vendors, as required.
If necessary, filter your selection further under Item Group or Item Properties.
Specify the warehouse in which inventory taking was carried out.
Choose the OK button.
In the Inventory Tracking window, enter the inventory taking results.
Save your data by choosing the Update button.
Repeat this procedure for each warehouse in which an inventory was taken.
If there are differences between the inventory taking results and the item quantities in SAP Business One, you may need to reconcile the quantities in order not to distort your inventory valuation results. For this purpose, use the inventory posting function.
From the SAP Business One Main Menu, choose
.Select the Inventory Posting tab.
Specify your selection criteria:
Specify the item numbers and/or business partner codes of the vendors, as required.
If necessary, filter your selection further under Item Group or Item Properties.
Specify the warehouse in which inventory was taken.
To allow inventory posting for items with a price value of zero (0), select the Allow Inbound Posting Without Price checkbox.
Note
If you choose to allow the value 0, the last purchase price is not updated for an inventory posting with the value 0.
Select the price source of the items for inventory posting and choose OK.
The application processes as follows:
Selects the items according to your entries and displays them in the Inventory Posting window.
Displays the item quantity differences between the warehouse as shown in the system and the inventory taking results.
If required, you can print the differences list.
To rectify the item quantities in this warehouse, choose Reconcile.