Show TOC

Object documentationItem Master Data: Inventory Data Tab Locate this document in the navigation structure

 

Use this tab to enter and view the warehouse information for the item.

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.
Item Master Data, Inventory Data Tab Fields
Set G/L Accounts by

From the following available options, choose the default G/L method for this item:

  • Whse – all G/L accounts that you have defined at the warehouses level

  • ItemGroup – all G/L accounts that you have defined at the item group level

  • ItemLevel – any G/L accounts that you have defined at the item level

UoM Code, UoM Name
  • When the UoM group is Manual:

    The UoM Code field is not visible.

    In the UoM Name field, enter the UoM by which you manage the inventory, for example, box, carton, or case.

  • When the UoM group is not Manual:

    In the UoM Code field, from the choose from list, choose a UoM as the inventory UoM. The default inventory UoM is the base UoM of the specified UoM group.

    The default inventory UoM displayed changes depending on the following situations:

    • If a default inventory UoM is defined for an item group which you select for the item, and you do not change the default UoM group, SAP Business One displays the default inventory UoM defined for that item group.

    • If there is no default inventory UoM defined for the item group you select for the item, or the UoM group specified is not the default UoM group of that item group, SAP Business One displays the base UoM of the UoM group specified.

Weight

Enter the weight of the item, followed by the weight measure.

Inventory Counting UoM Code, Inventory Counting UoM Name, Items per Counting Unit

These three fields are available only when the UoM group is not Manual.

In the Inventory Counting UoM Code field, from the choose from list, select a UoM to be used as the default inventory counting UoM.

The Inventory Counting UoM Name field and the Items per Counting Unit field are not editable. Once you specify the inventory counting UoM code, SAP Business One fills them with corresponding values, as defined in UoM setup and UoM group setup.

Note Note

If the UoM group contains only one UoM, SAP Business One fills the Inventory Counting UoM Code field with this UoM. The Items per Counting Unit field displays the value 1.

End of the note.
Valuation Method

This is relevant for perpetual inventory only.

Select one of the following:

  • Moving Average– the method is based on the calculation of an average cost for the item in each sales and purchasing transaction.

  • Standard– the standard pricing system permits the selection of a fixed price, which is then used for all transactions.

  • FIFO– an additional perpetual inventory system, in which goods purchased first are sold first, regardless of the actual goods flow.

Item Cost

Specify the cost of the item for the standard valuation method.

The value is updated and calculated for all inventory entries for Moving Average and FIFO.

Manage Inventory by Warehouse

Defines the calculation method for the inventory level requirements. You can define the minimum, maximum, and required quantities for an item on company level or warehouse level.

If you select the checkbox, the system checks the warehouse inventory level in the warehouse that was selected for the item when the sales document was entered. If a transaction causes the inventory level in that warehouse to fall below the defined inventory level, a warning message appears even if the total available inventory of the item is greater than the minimum warehouse quantity.

If you do not select this checkbox, the application checks the company inventory level values and checks the total available inventory in all warehouses where this item is stored.

When you select this checkbox, the following three columns appear in the table on the Inventory Data tab, and you can define the inventory level values for each warehouse respectively:

  • Min. Inventory Quantity

  • Req. Inventory Quantity

  • Max. Inventory Quantity

When you deselect this checkbox, the following three fields on the Inventory Data tab become editable, and you can define the inventory level values for all warehouses in this company jointly.

  • Required

  • Minimum

  • Maximum

Required (Purchase UoM), Minimum, Maximum

Enter minimum, maximum, and required inventory levels for the item. This is a company level definition. You can only edit these fields when you deselect the Manage Inventory by Warehouse checkbox.

  • If your inventory level across the company falls below the Required (Purchase UoM) quantity you defined, then in a purchase document, the application suggests a minimum quantity to fulfill the inventory level required.

  • If your inventory level across the company falls below the Minimum quantity you defined, the application may block your sales transactions or issue an alert, according to your definition for Response to Release/Receipt of Inventory Outside Defined Range in the Document Settings window.

  • If your inventory level across the company exceeds the Maximum quantity you defined, the application may block your purchase transactions or issue an alert, according to your definition for Response to Release/Receipt of Inventory Outside Defined Range in the Document Settings window.

Item Master Data, Inventory Data Tab, Warehouse Fields

Note Note

The next three fields are available only if you have enabled bin locations for at least one warehouse:

End of the note.
First Bin Location

Displays the bin location code as follows:

  • If the item is stored in more than one bin location, the field displays the bin location code that is first in the alphanumeric sequence. In addition, the field is highlighted in green.

  • If the item is stored in only one bin location, the field displays the code of the bin location.

To view the item's detailed inventory information in the bin locations, click Link Arrow (Link Arrow) before the bin location code to open the bin location contents list.

Note Note

If the items in all bin locations have negative inventory, the field still displays the bin location code that is first in the alphanumeric sequence.

End of the note.
Default Bin Location

Specify the default bin location for receiving the item.

Enforce Default Bin Loc.

Note Note

If you have not specified a default bin location, the checkbox is disabled.

End of the note.

Select the checkbox to enforce the use of the default bin location for receiving the item. That is, when you receive the item to your warehouse, you must place it in the default bin location.

SAP Business One lets you specify default bin locations on three different levels: warehouse, item group, and item. Among the three default bin locations, the priority is as follows:

Default Bin Location of Item > Default Bin Location of Item Group > Default Bin Location of Warehouse

Min. Inventory, Max Inventory, and Required Inventory

Enter values for the minimum, maximum, and required inventory levels for each warehouse, if necessary. These three columns only appear when you select the Manage Inventory by Warehouse checkbox.

  • If your inventory level in a certain warehouse falls below the Required (Purchase UoM) quantity you defined, then in a purchase document, the application suggests a minimum quantity to fulfill the inventory level required.

  • If your inventory level in a certain warehouse falls below the Minimum quantity you defined, the application may block your sales transactions or issue an alert, according to your definition for Response to Release/Receipt of Inventory Outside Defined Range in the Document Settings window.

  • If your inventory level in a certain warehouse exceeds the Maximum quantity you defined, the application may block your purchase transactions or issue an alert, according to your definition for Response to Release/Receipt of Inventory Outside Defined Range in the Document Settings window.

Locked

Locks the warehouse for the item and prevents you from adding the item from this warehouse to any A/R or A/P document.

Consignation

The number of items on consignation. The value in this field is a result of the quantity in open deliveries minus the quantity in open returns.

Cycle Code

Displays an inventory count cycle for the item in the warehouse as defined in the Inventory Cycles – Setup window.

Next Count Date

Displays the date of the next inventory count according to the cycle you have selected. You can change the date manually.

Time

Displays the time of the next inventory count according to the cycle you have selected. You can change the time manually.

User

Displays by default the SAP Business One user defined for the linked cycle count; you can also select a different user from the dropdown list. On the next count date, an alert will be issued upon the user's logon.

Alert

The system issues an alert when the next inventory count is due.

WIP Offset P&L Account

An offsetting account (contra-account) to a WIP (work in progress) account used within production transactions and used for change of value of a WIP account during the production process.

This account is used only when you select the Accounting with Balance Sheet Accounts and Profit & Loss Accounts option of the production order document, on the Per Document tab of the Document Settings window.

Inventory Offset P&L Account

An offsetting account (contra-account) to an inventory account used within production transactions and used for change of value of an inventory account during the production process.

This account is used only when you select the Accounting with Balance Sheet Accounts and Profit & Loss Accounts option of the production order document, on the Per Document tab of the Document Settings window.

Frozen In

Indicates that the item is "frozen" - the Freeze checkbox is selected in open inventory counting documents - for one or more storage locations. If an item is frozen in a storage location, you cannot record transactions for the item in that storage location until it is unfrozen. For more information, see Inventory Counting Window.

Depending on whether the warehouse has bin locations, there are different values for this field:

  • If the warehouse has no bin locations, the system displays the document number of the inventory counting document in which this item is frozen. You can click the link arrow to access the document.

  • If the warehouse has bin locations, the system displays Bin Locations. To check in which inventory counting documents this item is frozen for which bin locations, do the following:

    1. Click the link arrow.

      The Bin Location Content List window opens, displaying all the bin locations where transactions have occurred for this item.

    2. In the Bin Location Content List window, check the Frozen In column, which displays document numbers of inventory counting documents in which the item is frozen.

      If you cannot see the Frozen In column, enable it in the corresponding Form Settings window.

    For more information, see Bin Location Content List Window.

Set Default Whse

Defines the warehouse as a default for the item.