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

Thierry Tur

• October 20, 2023 08:17

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

 

Vote

0

• 

  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.