Inventory Opening Balances Window

Use this window to define opening balances for inventory.

For more information, see Entering Inventory Opening Balances.

To access this window, from the SAP Business One Main Menu, choose Start of the navigation path Inventory Next navigation step Inventory Transactions Inventory Opening Balances 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

Posting Date
Displays the beginning date of the current fiscal year, by default. Once you change the posting date, the document date changes accordingly.

Document Date
Displays the beginning date of the current fiscal year, by default. You can update the document date if necessary.

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

Add Items
Choose one of the following options to add items to the document: Select Items: Choosing this option opens the Items Selection Criteria window. In this window, you specify various selection criteria to select items. For more information, see Manually Entering Counting Results and Inventory Counting / Posting / Opening Balances - Items Selection Criteria Window. Import Items: Choosing this option opens the Import from Excel window. In this window, you can define import templates and import counting results into the application based on a template. For more information, see Importing Counting Results from Microsoft Excel.

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 lines of a document. The following values must be the same across these lines:

Inventory opening balance account
Project
Distribution rule

In addition, if this item is managed by the standard, FIFO or moving average valuation method and has a positive opening balance in some rows, the price in these rows must also be the same.

End of the note.

In Warehouse
Displays the current quantity in the selected warehouse or bin location.

Opening Balance
Enter the quantity of the item for its opening balance.

Unit Price

If the opening balance is positive, 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.

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 Unit 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 opening balances, you must enter 0 for the price rather than keeping the field blank. Nevertheless, these opening balances are not reflected in the journal. For more information, see the description of the Allow Positive Inventory Opening Balances with Zero Price field at Document Settings: Per Document Tab.

Actual Price

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 inventory opening balance of the item in this warehouse is positive, the actual price is the price specified by the user. If the total inventory opening balance of the item in this warehouse is negative, the actual price is the item cost.
FIFO	If the total inventory opening balance of the item in this warehouse is positive, the actual price is the price specified by the user. If the total inventory opening balance 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 = Opening Balance × Actual Price

Total
Total = Unit Price × Opening Balance

Open Inventory Account
Select the account to which you want the opening balances to be posted for the item.

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.