Notification query in item master

[Former Member]

Dear experts,

I need a notification query for user should select issue method as a Manual in Item Master for Inventory item.

Thanks & Regards,

Akshata

[Former Member · Accepted solution]

Hi Akshata.....

Please try this......

If @object_type='4' and @transaction_type='A'

BEGIN

If Exists (Select T0.ItemCode from OITM T0

Where T0.IssueMthd='B'

And T0.ItemCode = @list_of_cols_val_tab_del)

BEGIN

Select @error = -1,

@error_message = 'Please select Issue Method as Manual'

End

End

Regards,

Rahul

[Former Member · Accepted solution]

Dear Rahul sir,

I need in query if user tick on inventory item then user should select issue method as manual not to non-inventory item.

Thanks & Regards,

Akshata

[Former Member · Accepted solution]

Hi Akshata.....

Ok Please try this......

If @object_type='4' and @transaction_type='A'

BEGIN

If Exists (Select T0.ItemCode from OITM T0

Where T0.IssueMthd='B' and T0.[InvntItem]='Y'

And T0.ItemCode = @list_of_cols_val_tab_del)

BEGIN

Select @error = -1,

@error_message = 'Please select Issue Method as Manual'

End

End

Regards,

Rahul