Inventory list

i windowevent loadstock next to UDFs warehouse filter can be defined. Use variable "e_stock_(area)_where" or subordinated: e_stock_where for definition.

Area: destinguish between normal, batch or serial number items.

Batch: e_stock_batch_where

Series: e_stock_serial_where

Normal: e_stock_std_where

A general filter in variable "e_stock_where" can be defined or a separate filter for batch or serial number items. The standard behavior can be changed completely.

Priority:

Filter as per area filter e_stock_(area)_where

If not set: filter as in variable e_stock_where
If not set: standard filter (see Standard behavior)

Enter a SQL-fragment for the WHERE-clause

The following tables are available:

Serial number: OSRN, OSRQ, OWHS, OITW, BEAS_WHSBINITEM, BEAS_WHS, BEAS_WHSBIN, BEAS_WHSAREA

Batch: OBTN, OBTQ, OWHS, OITW, BEAS_WHSBINITEM, BEAS_WHS, BEAS_WHSBIN, BEAS_WHSAREA

Normal: OWHS, OITW, BEAS_WHSBINITEM, BEAS_WHS, BEAS_WHSBIN, BEAS_WHSAREA

For batches you can change the sorting using the variable (beas 9.1 PL:08)

e_stock_batch_order

Example:

User "harald" may only withdraw from warehouse "02" and "03"

windowevent loadstock
if <currentuser> = harald then
  setvar=e_stock_where= and`OWHS`.`WhsCode` in ('01','02')
end if
 
// Default sort for batchnumber: only by batchnumber
setvar=e_stock_batch_order="OBTN"."DistNumber"
end event

This window can be called up as reservation or issue window. If, depending on the area, different filters are needed, use the variable as_menu.

Example: Extended rule only for issue

windowevent loadstock
if <as_menu> = issuewo then
  setvar=e_stock_where= and`OWHS`.`WhsCode` in ('01','02')
end if
end event

Note:

The rule defined here has no effect on allocation. This is set up separately. See Extended rules.

See Customization

beas9.0-000-002-006

Only "Hard" Reservations are displayed.

"Soft" Reservations are ignored.

Example in Issue function.

There are 2 lines with the same material

Stock = 100

in the first line you choose the item 50 Pcs

if you go on to the second line, you will see "avaiable stock" = 50

Reason:

in an issue window you work with "soft reservation"

in the second line you cannot see the "soft reservation" from another line, another station or another process.

With this concept we can reduce the number of problems that may emerge when working with hard reservation

In "Reservation Window" Beas use a hard reservation and this type of reservation will be checked in every window and every line.

Insert the quantity you want to reserve or assign for the current Bill of Materials Line.

Double-click this line to assign the max. quantity automatically.

Note: In WO Stock Transfer Request this field is not used to reserve quantities! Here the creator of the request can indicate (request) quantities for specific batches/serials, which may be considered or dropped later in the SAP Stock Transfer  document creation.

See WO Stock Transfer Request.

There are serial number/batch related and normal items

Serial number: e_stock_serial_udf1 ..4, e_stock_serial_udfname1 ... udfname4

Batch: e_stock_batch_udf1...4, e_stock_batch_udfname1 ... udfname4

Normal: e_stock_std_udf1..4, e_stock_std_udf1name1 ... udfname4

The following tables are available:

Serial number: OSRN, OSRQ, OWHS, OITW, BEAS_WHSBINITEM, BEAS_WHS, BEAS_WHSBIN, BEAS_WHSAREA

Chargen: OBTN, OBTQ, OWHS, OITW, BEAS_WHSBINITEM, BEAS_WHS, BEAS_WHSBIN, BEAS_WHSAREA

Normal: OWHS, OITW, BEAS_WHSBINITEM, BEAS_WHS, BEAS_WHSBIN, BEAS_WHSAREA

To check which window is currently open, check the content of the variable "as_menu". In the reservation window "reservation" is stored.

Example:

in case of serial numbers and reservations in UDF1 the field U_myfield shall be displayed and labeled with "my field"

windowevent loadstock
setvar=e_stock_serial_udf1=`OSRN`.`U_myfield`
setvar=e_stock_serial_udfname1=my field
end event

Note:

Set variables are not reset as long as the window is not reopened.

UDF's are only visible if activated in they are windows settings.

See Customization.