Show TOC

Object documentationInventory 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 Start of the navigation path Inventory Next navigation step Inventory Transactions Next navigation step Inventory Counting Transactions Next navigation step Inventory Posting End of the navigation path.

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

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

End of the note.
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 Start of the navigation path System Initialization Next navigation step Document Settings Next navigation step Inventory Posting End of the navigation path, the row is displayed in red.

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 item price.

  • If the opening balance is negative, this field is not editable, with one exception (explained below).

    Exception: For items managed by the serial/batch valuation method, if both issuing and receiving transactions exist on a row (for example, some item units are issued while some other item units are received into the bin location), you can edit the Price field. However, this price is used for receiving transactions only; issuing transactions still use the item cost for valuation.

    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.

    Depending on the valuation method, the field value is different:

    Valuation Method

    Field Value

    Moving Average / Standard

    Current item cost.

    FIFO

    Average of all layers consumed by that document row, starting with the first open layer.

    Serial/Batch

    Average cost of all available units of the item in the company.

  • If you allow prices of zero for positive variances, you must enter 0 for the price rather than keeping the field blank. Nevertheless, 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.

  • For items managed by the serial/batch valuation method, this field is irrelevant and remains blank.

  • For items managed by the other valuation methods, this field is uneditable. After the document is added, this field is automatically updated and displays the actual price used to calculate the posted value.

    Valuation Method

    Actual Price Field Value After Document Is Added

    Standard

    Item cost.

    Moving average

    • If the total variance of the item in this warehouse is positive, the actual price is the price specified by the user.

    • If the total variance of the item in this warehouse is negative, the actual price is the item cost.

    FIFO

    • If the total variance of the item in this warehouse is positive, the actual price is the price specified by the user.

    • If the total variance of the item in this warehouse is negative, the actual price = total posted value ÷ total inventory opening balance.

Posted Value (Local Currency), Posted Value (System Currency)

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

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.