Show TOC

Object documentationInventory Posting Window Locate this document in the navigation structure

 

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   Inventory   Inventory Transactions   Inventory Counting Transactions   Inventory Posting  .

Note Note

This topic documents fields and other elements in this window that either are not self-explanatory or require additional information.

End of the note.
General Area Fields
Count Date, Time

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.

Price Source

You can take prices from the following three sources:

  • By Price List - The Price List field appears. Select the required price list from the list.

  • Last Evaluated Price - This is only relevant if a warehouse valuation report was previously generated.

  • Item Cost

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).

Note Note

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.
Branch

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:

  • Document numbering

  • Users and employees from which you can select the counters

  • Warehouses

Journal Remark

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.

Table Area Fields
In-Whse Qty on Count Date

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.

Inventory Offset Increase/Decrease Account

Select the accounts in which the inventory increasing and decreasing movements are recorded respectively.

Note Note

These two fields appear only if you use perpetual inventory.

End of the note.
Counted Qty

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.

Variance

Displays the difference between the in-warehouse quantity on the count date and the counted quantity.

Variance %

Displays the absolute variance percentage between the in-warehouse quantity on the count date and the counted quantity.

The calculation is as follows:

  • Counted Qty › In-Whse Qty on Count Date: Variance % = (Counted Qty ­ In-Whse Qty on Count Date) ÷ In-Whse Qty on Count Date × 100

  • In-Whse Qty on Count Date › Counted Qty: Variance % = (In-Whse Qty on Count Date ­ Counted Qty) ÷ In-Whse Qty on Count Date × 100

If the variance percentage is larger than the threshold defined in   System Initialization   Document Settings   Inventory Posting  , the row is displayed in red.

Price

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:

  • The valuation method of the item is FIFO or moving average.

  • The price is different from the item's current cost.

Note Note

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.

Note Note

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

Total = Price × Variance

The total value is displayed in local currency.

UoM Code

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.

UoM Counted Qty

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.

Items per Unit

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.

Allow Bin Negative Quantity

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.

Buttons
Add Items

Choose one of the following options to add items to the document:

Copy from Inventory Counting

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.