Inventory Counting Window
Use this window to select items for inventory counting and record the counting results.
To access this window, from the SAP Business One Main Menu
, choose .
This topic documents fields and other elements in this window that either are not self-explanatory or require additional information. End of the note. |
Displays the date when inventory was counted and the exact time at which the counting began. If you have defined the system to calculate in-warehouse quantities on the count date according to transaction posting dates, you cannot record the count time. In addition, transactions recorded on the count date may or may not be taken into consideration, depending on your setting in the Once you update the count date and time, SAP Business One updates the in-warehouse quantities on the count date accordingly.
You cannot set a future date or time. End of the note. |
Select the counting type according to the actual counting scenarios. With multiple counters, you can record more than one set of counting results, for example, for validation purposes, and when teamwork is required at a large storage location or unit. Before a row is closed in the inventory counting document, you can always change the counting type. The existing counting results are handled depending on the predefined setting or your choice:
Be careful about changing the counting type. If you make the wrong setting or choice, and have updated the inventory counting document, you have no other way of correcting the mistake except to close the document and re-enter your counting results in a new document. End of the caution. |
Available only if you have chosen the single-counter counting type. Specify whether the counter is a user or an employee (who is not, meanwhile, an SAP Business One user), and then select the user or the employee. For more information about counting scenarios, see Inventory Counting. |
Available only if you have chosen the multiple-counter counting type. Individual counters conduct counting independently, while team counters work as a team. Team counters' counted quantities of an item add up to the team counted quantity, which is compared with individual counters' counted quantities of the item. For example, 2 individual counters count item I001 stored in the same bin location, and then a team of 2 counters validate their counting: team counter A counts one half of item I001 and team counter B counts the other half. Choose After you select at least one team counter, the For more information about counting scenarios, see Inventory Counting. |
Available only if you have enabled multiple branches for this company. The branch information in each row is for reference purposes and cannot be edited. For more information, see Working with Multiple Branches. Only the branches to which the current user is assigned are displayed for selection. Once you specify the branch, SAP Business One filters the following information according to the specified branch:
|
Displays the number and description of the item that is selected for counting. Note that you can change the item description specifically for this document without changing the item master data. To do so, enter the item description that you want to use and then press CTRL + TAB. |
Select this checkbox if you want to freeze an item, that is, prevent any transaction (except inventory posting) that affects the in-warehouse quantity of the item in the selected warehouse and bin. To unfreeze an item, deselect this checkbox in the relevant row, and choose the To unfreeze all items in the current inventory counting document, double-click the
SAP Business One automatically unfreezes the frozen items in the following situations:
End of the note. |
Displays the in-warehouse quantity of an item in a storage location that is recorded on the count date and, if the system calculates this quantity based on transactions' creation dates, at the count time. For more information about the calculation logic of this quantity based on different settings, see Calculation of In-Warehouse Quantities on Count Date. |
Select this checkbox to indicate that the item in the specified storage location has been counted. If you want to copy a row to an inventory posting document to post the inventory changes verified through inventory counting, you must select this checkbox.
If you select this checkbox without entering the counted quantity, the system considers the counted quantity as zero (not empty). End of the note. You can double-click the |
These fields appear only if you have selected at least one UoM item in the document and are relevant to UoM items only. The If the UoM item in the specified storage location is stored in only one unit of measure, enter the UoM counted quantity directly in the field. If the item in the specified storage location is stored in more than one unit of measure, enter the corresponding UoM counted quantities in the
If there exists more than one UoM counted quantity for this item, the counter's |
The counted quantities are always measured in inventory counting UoMs. Counted Qty, <Individual Counter> - Counted Qty The For a non-UoM item, enter the actual counted quantities in these fields. For a UoM item, each counter's counted quantity is the sum of the UoM counted quantities converted into the inventory counting UoM. For example, 1 box contains 6 bottles of milk (Item code: I001). In bin location A, you counted 3 boxes of item I001 (18 bottles) and an extra 5 bottles. In SAP Business One, the inventory unit of measure for item I001 is a bottle. As a result, the counted quantity of item I001 is 18 + 5 = 23 (bottles). Team Counted Qty, <Team Counter> - Counted Qty The To enter team counters' counting results (including UoM counted quantities, serial numbers, and batch information), you must use the |
Specify a bar code for the item in the specified unit of measure. To be available for selection, a bar code must have been linked to a UoM code (UoM code for non-UoM items is To link a bar code to an item measured in a particular UoM, you must do it in the corresponding |
After you enter the counting results into SAP Business One, the application compares the counting results with the in-warehouse quantities recorded in the system. The biggest variance between the counted quantities of an item in a storage location and the recorded in-warehouse quantity on the count date is the variance (for a single counter) or maximum variance (for multiple counters). In addition, two percentage values are provided based on the comparison:
If the percentage is larger than the defined threshold, the row is displayed in red. For more information, see Document Settings: Per Document Tab.
Two individual counters Counter A and Counter B, as well as a team of counters (including Team Counter A and Team Counter B), counted an item in the same storage location. Their counting results are as follows:
The item's in-warehouse quantity recorded in the system is 10 on the count date. Therefore, the maximum variance = 2, and the counters' difference percentage = (2/10) * 100% = 20%. End of the example. |
Choose a UoM code from the choose from list that lists all the UoMs in the UoM group specified for the item in item master data. If you have specified an inventory counting UoM for the item in item master data, this field displays this UoM by default. If you have entered multiple UoMs in the If the UoM group for the item is |
Inventory Items per Unit = Base Qty ÷ Alt. Qty This field is non-editable and displays the calculated value from the group UoM definition of the item. If you have entered multiple UoMs in the |
Available only if at least two sets of counting results are available. In other words, there must be one individual counter, and at least another individual counter or a team of counters.
Counting results of team counters are not compared. End of the note. If multiple counters participate in inventory counting, after you enter the counting results into SAP Business One, the application compares all the counting results. The biggest difference between different counting results of an item in a storage location is the counters' difference. In addition, a percentage value is provided based on the comparison: Counters' difference percentage = (|Counters' difference| / Lowest counted quantity) * 100%. If the percentage is larger than the defined threshold, the row is displayed in red. For more information, see Document Settings: Per Document Tab.
Two individual counters Counter A and Counter B, as well as a team of counters (including Team Counter A and Team Counter B), counted an item in the same storage location. Their counting results are as follows:
Therefore, the counters' difference = 2, and the counters' difference percentage = (2 / 8) * 100% = 25%. End of the example. |
This tab appears only after you have selected at least one team counter. You record each team counter's counting results (including UoM quantities, serial numbers, and batch information) on this tab. For an item in the same storage location (warehouse or bin location), all team counters' counts add up to the item's actual counted quantity, which is the team counted quantity.
Note that you must specify items, warehouses, and bin locations on the General
tab. Such information is only for your information on the Team Counting
tab.
The General
tab also displays the team counted quantity to be compared with various individual counting results and the in-warehouse quantity.
Choose one of the following options to add items to the document:
|
From the dropdown list, select either of the following options to adjust the counted quantities:
|
After adding an inventory counting document to the system, you can post the counting results by copying this document to an inventory posting document. After you add the inventory posting document, the inventory information recorded in the system is adjusted to match the actual storage.
Only rows that have been marked as counted are possible for copying. For more information, see the description for the End of the note. If there is no difference on a row between the counted quantities and the in-warehouse quantity recorded in the system, this row will not be copied to the inventory posting document. In addition, depending on your setting in the In addition to the above rule, depending on your counting type, the copy options are different:
|