Inventory Posting Window

Use this window to reconcile the item quantities with the inventory counting results.

For more information, see Inventory Posting.

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

Posting Date
Displays the current system date by default. If the inventory posting document is based on an inventory counting document, this field is not editable and displays the count date of the inventory counting document.

Count Date, Time
Displays the current system date by default. After you copy items 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 items from multiple inventory counting documents with different count date and time, these fields become empty and are disabled for editing.

Price Source for Inventory Posting
From the dropdown list, select the price source that the system uses to fill the Price column in the document rows. The prices will be used in journal entries and may affect the costs of the items. Note You can later change the prices in the Price column manually if the variances are positive. End of the note. By default, this field displays Item Cost if you use perpetual inventory and Last Evaluated Price if you use non-perpetual inventory. If you select By Price List, the Price List field appears below for you to select a specific price list or last purchase price.

Add Items
Opens the Inventory Posting – Items Selection Criteria window. You can select a range of items that meet the specified selection criteria.

Copy From Inventory Counting
Opens a list of inventory counting documents. After you select the inventory counting documents to copy, the draw document wizard starts. Follow the wizard steps to add items to the inventory posting document by copying counted items from selected inventory counting documents. You cannot select to copy two inventory counting documents with different numbers of counters for a single inventory posting document.

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

Inventory Offset Increase/Decrease Account
Select the accounts in which the inventory increasing and decreasing movements are recorded respectively. Note These two fields appear only if you use perpetual inventory. End of the note.

In-Whse Qty on Count Date
Displays the quantities of the item in warehouses recorded by the system on the selected count date and time. You cannot edit this field in inventory posting documents.

Counted Qty
Displays the quantity of the item as counted in actual warehouses. 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 Counting , the row is displayed in red.

Price
Displays the price per unit of the item according to the price type you select in the Price Source for Whse Inventory Posting field. You can update the price if the variance is positive. If the variance is negative, this field is not editable and displays the item cost.

Total
Total = Price × Variance The total value is displayed in local currency.

Branch
Specify the branch for which you want to create the document. Once you specify the branch, SAP Business One filters the following information according to the specified branch: Document numbering Warehouses Offset accounts Lists of inventory counting documents that appear after you choose the Copy From Inventory Counting button Note This field is available only in the Brazil localization. End of the note.

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.

Item 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 Posting by UoM window, or if the UoM group of the item is Manual, this field is blank.