ISSUE for production-Blocking

[Former Member]

Dear Experts,

In issue for production screen,dont allow to choose 21 & 26 warehouse rest of all warehouse allow to choose & issue the material.

Can you please provide SP_TN for this case.

I tried it but its not blocking.

[Former Member · Accepted solution]

Hi,

You may check if you can have any results by running a simple query:

select n.DocEntry, n.DocDate  from IGE1 n

where n.WhsCode in ('21' ,'26')

Thanks,

Gordon

[Former Member]

Hi ,

Try this

IF @object_type= '60' AND @transaction_type in ('A')

BEGIN

IF EXISTS (select n.DocEntry  from IGE1 n

where n.WhsCode in ('21','26') and n.BaseType=202  AND n.DOCENTRY= @list_of_cols_val_tab_del)

BEGIN

SELECT @Error = 1, @error_message = 'Change Whscode'

END

END

[Former Member]

Hai,

Above SP_TN not blocking its allowing to add.

[Former Member]

Try this,

IF @object_type= '60' AND @transaction_type in ('A')

BEGIN

IF EXISTS (select n.DocEntry  from IGE1 n

where (n.WhsCode ='21' or n.WhsCode ='26')   AND n.DOCENTRY= @list_of_cols_val_tab_del)

BEGIN

SELECT @Error = 1, @error_message = 'Change Whscode'

END

END