Want to Prevent Inventory Transfer More than Planned Quantity

[Former Member]

Dear Experts,

I want to Prevent Inventory Transfer More than Planned Quantity. so that No one can Post any Issue for Production More than Planned Quantity has Assigned that Production Order. Using SAP Business One B1 .

Please Advice ......

Thanks In Advance ,

Ajibul Hakim

[kothandaraman_nagarajan · Accepted solution]

Hi,

You can prevent by transaction notification. Check this thread:

http://scn.sap.com/thread/3452251

Thanks & Regards,

Nagarajan

[Former Member]

Hello Gordon,

Thanks for your Reply . I want to Prevent Inventory transfer , which will Exceed the Planned Limit. but yesterday I Have Tried Myself again and I have succeed ! so thanks you again ,

Also thanks to Nagarajan for your kind reply and i wanted to do like that but I want to restrict Inventory transfer...

I have Done Like this....

IF @object_type='67' 

  BEGIN

  IF @transaction_type='A' OR @transaction_type='U'-----Add

      BEGIN

        IF exists(SELECT * FROM  WTR1 T0

      LEFT JOIN OWTR T1 ON T1.DocEntry=T0.DocEntry

        WHERE  (T0.U_PlanQTY<(T0.Quantity+T0.U_TotalIssue)) AND T1.U_OrderType='100'

                     AND T0.DocEntry=@list_of_cols_val_tab_del)

        BEGIN

         SET @ERROR=1

         SELECT @ERROR_message = N'Issued Quantity Can not More than Planned Qty ,Check again and reconfirm please '

        END

      END   

   END

Thanks,

Ajibul Hakim

Message was edited by: Ajibul Hakim

[Former Member]

Hi Ajibul,

Please clarify do you want to block Issue for Production or Inventory Transfer.

Thanks,

Gordon