Backfushing screen : possibility to block WO based on their WO Type

Thierry Tur

October 20, 2023 08:17
1 comment

Hi Guys,

this is a function I have to solve for a client with a script for now.

The client is managing manly 2 types of WO : Assembly WO and Manufacturing WO.

The assembly WO are monitored automatically with a MES interface. The Manufacturing WO are backflushed.

In order to miminize the risk to select an assembly WO in the backflushing screen, it would be great to be able to :

1. Define at the WO type level that the WO type is manageable with Backflushing Yes/No

2. Improve the backflushing screen in order to process only WO with a WO type which allows backflusing function.

With my best regards

Comments

1 comment

Martin Heigl

October 20, 2023 11:46

Hi Thierry,

i think, you speak about follow window

in this window Tools->Customization Tools -> Windows Customizing script

Insert follow script


global function dw_1_item_nummer_itemchanged 
setvar=wert1=
sql=select "BEAS_FTHAUPT"."TYP"  from "BEAS_FTPOS" &
  inner join "BEAS_FTHAUPT" on "BEAS_FTHAUPT"."BELNR_ID"="BEAS_FTPOS"."BELNR_ID"
  where "BEAS_FTPOS"."BarCode"='<nummer>' 

// Define here the blocked work order type
if <wert1> = "Kunde" then
   meldung=fehler$Fertigungsaufträge von Typ <wert1> dürfen hier nicht gemeldet werden
   event=script1
   setcolumn=nummer
   return failure
end if
end global

Please sign in to leave a comment.