Inventory Posting Window 
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 Document Settings window. Furthermore, as long as an inventory posting document remains as a draft, every time you open the document, the system asks for your confirmation to recalculate in-warehouse quantities on the count date. For more information, see Calculation of In-Warehouse Quantities on Count Date. |
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 Price field. In other words, the variance in the inventory value (Total field) posted to the journal entry is calculated according to the item cost (counted quantity variance * item cost).
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 Price field. This can happen if the item cost has changed between the time of adding the item to the document and the time of adding the document itself, for example, because you have recorded some more purchases that use different prices. 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 Remarks field of the journal entry. By default, this field contains the text: Inventory Posting. After you add an inventory posting document, a link arrow is added to this field that links to the journal entry created. |
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. |
The variance in the inventory value posted to the journal entry is calculated according to the value in this field: Variance × Price. If the variance is positive (the counted quantity is higher than the in-warehouse quantity), this field displays by default the price according to the specified price source, but you can always update the price. In addition, the price changes the item cost if the following conditions are met:
Even if you allow prices of zero for positive variances, you must enter 0 for the price instead of keeping the field blank. In addition, these variances are not reflected in the journal. For more information, see the description of the Allow Inbound Posting with Zero Price field at Document Settings: Per Document Tab. End of the note. If the variance is negative, this field is not editable and displays the current item cost.
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 Price field. This can happen if the item cost has changed in the time between adding the item to the document and adding the document itself, for example, because you have recorded some more purchases that use different prices. End of the note. |
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 Inventory Counting by UoM window, this field is non-editable and displays Multiple. If the UoM group for the item is Manual, this field is non-editable and displays Manual. |
Enter the counted quantity in the specified UoM. If you have entered multiple UoMs in the Inventory Posting by UoM window, or if the UoM group of the item is Manual, this field is blank and non-editable. |
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 Inventory Counting by UoM window, or if the UoM group of the item is Manual, this field is blank. |
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 Block Negative Inventory By field at Document Settings: General Tab. |
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 Document Settings window for inventory counting documents. For more information, see Document Settings: Per Document Tab. 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. |