cancel
Showing results for 
Search instead for 
Did you mean: 

Validation for Item Master Data

Former Member
0 Kudos

Hi Experts,

I want to put validation/restriction that if someone change the status from InActive to Active in the Item Master data, it should block them to do so.

At the same time it should allow them to Inactive from Active.

Active -> InActive - Should Allow

InActive -> Active - Should not Allow

Can anyone help me out on this.?

Thanks

Accepted Solutions (0)

Answers (7)

Answers (7)

KennedyT21
Active Contributor
0 Kudos

Please close your thread by marking helpful/correct answer.

Thanks,

Kennedy

Former Member
0 Kudos

Please close your thread by marking helpful/correct answer.

Thanks,

Gordon

Former Member
0 Kudos

Below worked...Thanks for replies.

Note: If anything wrong in below, please let me know.

If (@object_type = '4' And @transaction_type = 'U')

If (select top 1 frozenFor from OITM where ItemCode = @list_of_cols_val_tab_del) = 'N'

Begin

Select @error = -555, @error_message = 'You are not allowed to update inactive item details!'   

Select @error, @error_message

Return

End

former_member184146
Active Contributor
0 Kudos

Hi Team,

your TN is correct

Manish

former_member196081
Active Contributor
0 Kudos

Go to general authorization and select the user. in right side pane, go to item master data. there are two options in Active and inactive. you can authorize here users as you required.

former_member196081
Active Contributor
0 Kudos

you can try the standard authorization for the same.

KennedyT21
Active Contributor
0 Kudos

Hi Team Tech..

Try This TNSp

If @object_type = '4' and @transaction_type in ( 'U')

BEGIN

  if exists

   (

Select I.ItemName From OITM i

  Where I.ItemCode=@list_of_cols_val_tab_del and validFor <> 

  ( select validFor from AITM c where c.ItemCode=i.ItemCode and validFor='N'

   and c.LogInstanc =

( select MAX(LogInstanc) from AITM d where  c.ItemCode=d.ItemCode )) 

     )

Select @error =12,

    @error_message = 'Not Authorised'

END

Regards

Kennedy

Message was edited by: Kennedy T

former_member225732
Contributor
0 Kudos

Hello Dear,

  You can do it by using Transaction Notification....

Regards,

Sandesh