Skip to Content
avatar image
Former Member

SP for Inventory Transfer blocking by Warehouse

Dear experts,

Need a SP

I have 2 Warehouse named

1) A

2) B

I want to allow inventory transfer from warehouse A to Warehouse B

But I also want to block inventory transfer from warehouse B to warehouse A.

Thanks In advanced...

Regards

Rahul P.

rahulpathare@outlook.com

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jul 03, 2017 at 04:08 AM
    Try this to block from B to A warehouse
    
    
    IF (@object_type= N'67') and @transaction_type= N'A' BEGIN IF EXISTS (SELECT T0.DocNum FROM dbo.OWTR T0 INNER JOIN WTR1 T1 ON T0.[DocEntry] = T1.[DocEntry] WHERE (T1.[FromWhsCod]='B'and T1.[WhsCode]='A' AND T0.DocEntry = @list_of_cols_val_tab_del)) BEGIN SET @error = 123 SET @error_message = 'Transfer Type for respective Whse not allowed, input please' END End
    
    Regards:
    Balaji.S
    Add comment
    10|10000 characters needed characters exceeded