Inventory Data

Field

Description

Set G/L Accounts By

Selection of default G/L account method from the available options for the item:

•	Warehouse - All G/L accounts defined at warehouse level.

•	Item group - All G/L accounts defined at item group level.

•	Item level - All G/L accounts defined at item level.

UoM Name

Defines the unit of measure of the item when it is stored and inventory is managed, e.g. crate, carton, box.

Only visible when "UoM Group" is not set to Manual.

If this field is left empty, the field Production UoM will also be empty, and Beas will show no decimals in the Item Structure Report and will not display the Unit of Measure field when this material is included into another item’s Bill of Materials.

SAP Business One standard does not support defined UoM Definition in item master Data. The UoM is only a name.

With Beas integration, the name is the UoM ID. It must be defined in Unit of Measure Setup.

Beas can work correctly only if UoM Code and UoM Name are exactly the same:

uomsetup

The system checks the existence of UoM Code in all UoM name fields.

It inserts the correct Code or make the field empty if the UoM Code does not exist.

Example:

If you insert "sp" + TAB, the System inserts "Spool"

Use the golden button with three points to choose the UoM from the list.

Note:

Many Beas functions, especially MRP and Work order can only work properly if the correct UoM is defined.

Working with UoM Group

If a UoM Group is activated, the system displays two UoM fields.

Beas always uses Purchasing UoM name and does not support the code.

This only works if UoM Code and UoM Name are the same.

UoM Code general

See Concept of UoM

Weight

Weight.

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

Note:

This is used as reference weight in Beas bin location management for transactions. If used with weight calculation in bin location management, it should not be changed here.

Valuation Method

This option is only relevant for continual inventory management.

Selection of one of the following options:

Moving average - This method is based on the calculation of the average costs for the item in each purchasing and sales transaction.SAP Business One calculates it automatically in the background. Beas returns this price at pricing, it is always calculated in home currency.

Standard pricing allows to select a fixed price, which will be used for all transactions. The standard price is stored in Item master / inventory data / item costs. The price can only be changed, as long no journal entries exist. The price is always stored in home currency. As soon a journal entry exists, the standard price can be changed only via Warehouse management > Stock transactions > Stock revaluation.

Another continual inventory management system in which the first goods purchased are the first sold or issued without consideration of the current goods movements.The valuation method can only be changed as long as no material has been posted.

Pricing Precalculation: For Fifo the following formula is used:

Total value of all items currently in stock - valued by FiFo

: total stock

= average value

This value is used as default for all calculations and for posting in material and assemblies. For issue Fifo principle applies.

If there is no stock, the last purchase price is used as reference.

From SAP Business One 9.1 the valuation method "Series / Batches is available. This is a moving average method per series/batch.

Pricing Precalculation:

The average price of all batches in stock is determined.

This value serves as default for all calculations and for posting in material or assemblies. For issue, the average pricing per batch applies.

If there is currently no stock, the last purchase price is used as reference.

Item Cost

Input of the costs of the item for the default calculation method.

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

Manage Inventory by Warehouse

If the flag is set, the total quantity of the fields Minimum warehouse stock, Req. warehouse stock and Max. warehouse stock is displayed in the warehouse table.

Inventory Level

Set of fields used to define the inventory level required to be ordered and stored. SAP Business One has three fields for determining the optimal inventory levels, Required (reorder point), Minimum, and Maximum. Fields Required and Minimum are considered by MRP for calculating the purchases recommendation. If you need to define these values by Warehouse you have to do it in the Standard SAP Business One Item Master Data window, inventory tab.

Required (Purchasing UoM)

Input of the required inventory levels for this warehouse. Value deposited in purchasing unit, it is supported in order recommendation report, if no minimal stock was entered. The quantity required to reach to the minimum warehouse stock is displayed in the Required (purchasing UoM) field.

If release of warehouse stocks under the minimum limit is selected in the document settings, the system issues warnings if the minimum warehouse stock is not reached. The system does not permit further input of inventory documents if the warehouse stock has reached the maximum quantity.

Minimum

Input of the minimum warehouse stock quantity for this warehouse.

Maximum

Input of the maximum warehouse stock quantity for this warehouse.

Set Default Whse: SAP function to define the warehouse as a default for the item.