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.
|
|
Reservation
|
reservation
|
Allocation
|
supply
|
issue provision parts
|
externalissue
|
issue
|
issuewo
|
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
|