Define rules for Pre-Assign in Reservation window
More information see PreAssign
Variable
|
Read
|
Write
|
Description
|
e_res_dfltwhs
|
x
|
x
|
By default the following value is stored:
case when ifnull("BEAS_FTSTL"."WhsCode",'') <> '' then "BEAS_FTSTL"."WhsCode" else "OITM"."DfltWh" end
If always the same warehouse is to be set as default in reservation window:
function setres_reservation
setvar=e_res_dfltwhs=('01')
end function
Important: brackets, otherwise the ' -character could be misinterpreted
Alternatively setvar=e_res_dflthws="'01'"
Available tables:
BEAS_FTSTL, BEAS_FTPOS, BEAS_FTHAUPT, OITM, O2 (OITM from assembly), BEAS_ME, BEAS_AGTYP
|
|
e_res_whscode_std
|
x
|
x
|
Available tables:
OITM, OWHS
batch item: OBTN, OBTQ,
serial number item: OSRN, OSRQ
Withdrawal always with priority:
1. Reservation (the switch has no effect)
2. Allocation warehouse – if included in the list
3. Default warehouse which may be overwritten by a warehouse list. Extended definition of sorting is not possible.
The withdrawal sorting set up in configuration wizard is applied for batches and serial numbers.
To consider additionally the default warehouse insert the place holder "*****"
function e_res_issuewo
setvar=e_res_whscode_std="OWHS"."WhsCode" in ('*****','01','02')
end functoin
|
|
e_res_filter
|
x
|
x
|
Used to determine for which BOM positions to create a reservation or allocation
The following tables are available:
BEAS_FTSTL, BEAS_FTPOS, BEAS_FTHAUPT, OITM, O2 (OITM from assembly), BEAS_ME, BEAS_AGTYP
Example: For reservation, consider only batch-related items, for which a "Y" was entered in the material group in field "UDF1".
function setres_reservation
setvar=e_res_filter= <cr_lf>and ("OITM"."ManBtchNum"<>'Y' or coalesce((select "BEAS_MATGRP"."UDF1" from "BEAS_MATGRP" &
where "BEAS_MATGRP"."GRUPPE" = "OITM"."U_gruppe"),'N')='Y')
end function
|
|
Why WoDocEntry / WoLineNumber not available?
Reason: In the reservation list you can have more then one work order. You must define the rules in the SQL query
// reservation: User "1" has only access to warehouse 01 and 02
function setres_reservation
if <currentuser> = "1" then
setvar=e_res_whscode_std="OWHS"."WhsCode" in ('01','02')
end if
end function