setres_externalissue

Define rules for Pre-Assign in External Issue window or WEB APP or related services

preassign

 

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