Use this window to reconcile the item quantities with the inventory counting results.
For more information, see Posting 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. |
If you copy counting results from inventory counting documents with the same count date and time, these two fields display the count date and time of the copied inventory counting documents and are disabled for editing. If you copy counting results from multiple inventory counting documents with different count dates and times, these fields become empty and are disabled for editing. If you have set 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 |
You can take prices from the following three sources:
If the variance is negative (the counted quantity is lower than the in-warehouse quantity), the system always displays the current item cost in the
The journal entry for the document takes the item cost at the point of posting and this may not be the same as the cost displayed in the End of the note. |
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:
|
Enter the information to display in the After you add an inventory posting document, a link arrow is added to this field that links to the journal entry created. |
Note
If an item is stored in different bin locations within a warehouse, its inventory data in these bin locations are entered in different rows of a document. The following values must be the same across these rows:
Inventory offset account for increases
Inventory offset account for decreases
Project
Distribution rule
In addition, if this item is managed by the standard, FIFO or moving average valuation method and has a positive variance in some rows, the price in these rows must also be the same.
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 the accounts in which the inventory increasing and decreasing movements are recorded respectively.
These two fields appear only if you use perpetual inventory. End of the note. |
Displays the quantity of the item as counted in actual warehouses. For a UoM item, you specify its UoM counted quantities and its counted quantity is converted from UoM counted quantities. 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). If you add an item without entering the counted quantity, SAP Business One considers the counted quantity to be zero. If a counted item is copied from an inventory counting document, this field displays the counted quantity recorded in the inventory counting document, and you cannot edit it in the inventory posting document. |
Displays the difference between the in-warehouse quantity on the count date and the counted quantity. |
Displays the absolute variance percentage between the in-warehouse quantity on the count date and the counted quantity. The calculation is as follows:
If the variance percentage is larger than the threshold defined in , the row is displayed in red. |
|
|
Uneditable and irrelevant to items managed by the serial/batch valuation method. Updated after the document is added. Calculation formula: Posted Value = Variance × Actual Price |
Total = Price × Variance The total value is displayed in local currency. |
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 |
Enter the counted quantity in the specified UoM. If you have entered multiple UoMs in the |
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 |
If you need to enter a negative quantity for an item in a bin location, select this checkbox. Note that if you block negative inventory at the company or warehouse level, the total quantity of the item still cannot be negative across the whole company or the corresponding warehouse. For more information, see the explanation about the |
Choose one of the following options to add items to the document:
|
Displays a list of inventory counting documents for copying to the inventory posting document. After you select the inventory counting documents to copy, the draw document wizard starts. Follow the wizard steps to add counting results from selected inventory counting documents. If there is no difference on a row between the counted quantities and the in-warehouse quantity recorded in the system, this row in the inventory counting document may or may not be automatically closed after you add the inventory posting document. This depends on your setting in the Note that you cannot select to copy two inventory counting documents with different counting types (multiple counters or a single counter) for a single inventory posting document. For more information, see Posting Counting Results and Copy From Method. |