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

Inventory UoM

Enter the type of unit by which you manage the inventory, for example, box, carton, or case.

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, on the Inventory Data tab, the following three columns appear in the table, 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, on the Inventory Data tab, the following three fields 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, 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 blocks your sales transactions, or issues 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 blocks your purchase transactions, or issues 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
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 deselect the Manage Inventory by Warehouse checkbox.

  • If your inventory level in a certain warehouse falls below the Required (Purchase UoM) quantity you defined, 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 blocks your sales transactions, or issues 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 blocks your purchase transactions, or issues 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.

Counted, Was Counted

Displays whether you have counted the items in stock and the current number of the counted items in stock.

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 the code of the employee who is defined as a user in the system.

Alert

Select to define whether 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.

Set Default Whse

Select to define the warehouse as a default for the item.