Show TOC

Object documentationExpress Configuration: Step 2 - Defining the Inventory System Locate this document in the navigation structure

 

Use this window to make settings related to the inventory system.

Note Note

The settings displayed in this window depend on the localization of the SAP Business One application that you are using. Not all settings are relevant for all localizations.

End of the note.
Use Perpetual Inventory

Select this option to indicate management of perpetual inventory accounting system. If selected, each transaction of inventory items is reflected also in the inventory related G/L accounts.

Note Note

After the first inventory transaction is posted, this option is disabled, and its status cannot be changed.

End of the note.
Item Groups Valuation Method

Specify the default valuation method for newly added item groups. This field is active only if the Use Perpetual Inventory option is selected.

The available valuation methods are:

  • Moving Average: Calculates the inventory value by the item cost (see the   Inventory   Item Master Data   Inventory Data   tab).

    This field is updated dynamically by every inventory receipt posting.

  • Standard Price: Calculates the inventory value by a fixed price.

    The item's standard price should be set before you start working in your company.

  • FIFO: Calculates the inventory value by the FIFO (first in first out) method.

    • Each inventory receipt transaction creates a "layer" of quantities linked to costs.

    • Each inventory release transaction uses quantities and their corresponding costs from the first open layers.

Note Note

You can change the selected valuation method at any time; however, the change applies only to item groups added after the change, not retroactively.

End of the note.
Manage Item Cost per Warehouse

This field appears only if you have selected the Use Perpetual Inventory option.

Select this option for calculating inventory pricing for each individual warehouse.

Deselect this option for calculating inventory pricing for all the warehouses combined.

Note Note

Users in China should select this field to group data by warehouse in the inventory audit report. Otherwise, the inventory audit report is grouped only by item, and the checkbox Group by Warehouses First is not visible for all the warehouses selected.

End of the note.
Use Purchase Accounts Posting System

In localizations where purchase accounting is used, selecting this option enables purchase accounting. Once journal entries have been made, this setting cannot be modified.

Note Note

This field is not available for users in Brazil.

End of the note.
Allow Stock Release Without Item Cost

Permits items to be included in documents such as deliveries or A/R invoices, even when the item cost has not been determined.

Select when the inventory valuation is performed according to moving average or FIFO. If you selected Standard Price, a cost has already been defined.

Warehouses

Define the warehouses for the company. For more information, see the Warehouses – Setup Window topic in the online help.

Default Warehouse

Choose a default warehouse for new item records.

When modified, this setting is updated immediately per company, for all users.

Set G/L Accounts by

Choose one of the following to define whether you relate G/L accounts to items by:

  • Warehouse

  • Item Group

  • Item Level

When modified, this setting is updated immediately per company, for all users.

Auto. Add All Warehouses to New Items

Select if you want to add all warehouses each time you create a new item, or to automatically add a new warehouse to existing items.

When modified, this setting is updated immediately per company, for all users.

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