Inventory data

Inventory > Item master > Master Data tab > Inventory data

 Top  Previous  Next
Expand/Collapse Toggles

The warehouse data of the item are entered and displayed on this tab.

Item_master_Inventory

Window artikel_edit.psr

 

Header details

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.

Inventory UoM

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.

uomcol

 

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.

UoMGroup

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

 

UoM Code general

See Concept of UoM

 

Primary warehouse

Warehouse from which postings are done by default.

If in SAP B1 Administration > System initialization > General settings > Inventory: "Auto. add all warehouses to new items", was disabled, each warehouse will still be selectable from the drop-down, even those that are not defined in the Item Master. They will be added automatically for selection.

Note: If no standard warehouse is defined, various functions as allocation, backflushing, pre-assignment, reservation, MRP do not work correctly.

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.

Warehouse rule

A group of warehouse rules can be stored. See Warehouse rules.

 

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 Inventory > Inventory transactions > Inventory 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 costs

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.

Inventory Management by Warehouse no.

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.

Required (purchase 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.

 

Lower tabs - Stock information

Field

Description

By Warehouse No.

Display all warehouses for the current item.

Field

Description

Warehouse

Warehouse

Inventory

Total stock of the item including blocked batches.

Unit

Unit of measure

Confirmed

Planned issue for customer orders. No breakdown of sub-components. Calculation according to SAP rules.

Ordered

Planned receipt from purchase orders. Summation according to SAP rules.

Goods receipt from production

All planned receipts are displayed without consideration of any settings (blocked work orders etc).

Goods issue for production

All planned issues are displayed without consideration of any settings (blocked work orders etc). Important: all previous postings for this item are considered, no matter from which warehouse. This works only if the work order was created by Beas without any changes by external programs.

Reserved

For the future reservation system: all reservations are displayed, stock related and planned receipts.

Inventory locked

Is related to SAP Business One > Item Master Data > Inventory Data > field 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.

Inventory_locked

Warehouse Type

Type of warehouse. See Warehouse administration.

Warehouse Locked

Warehouse is locked. Related to SAP Business One - Warehouse - Field "Inactive".

By bin location

Display every stock by Warehouse, Bin location, Serial- and Batch number and Item Version (I-Version).

Beas and SAP Bin locations are supported. WMS Bin locations are not supported.  

 

Field

Description

Warehouse

Warehouse

Range

Storage Area

Description

Description of the warehouse area

Bin location

Bin location

Batch/series

If batch- or serial number-managed item: the serial number or batch

RFID

Sub-ID of a batch / series

Inventory

Current inventory at this bin location with this batch / serial number

 

By Batch

Batch inventory; only visible for batch-managed items.

By series

Inventory by serial numbers; – only visible for serial number-managed items.

 

back to item master

Help URL: https://help.beascloud.com/beas202106/index.html?bestandsdaten.htm