SP Transaction notification on field in item master data

[Former Member]

Hi Experts,

Is anyone able to provide me with example of SP Transaction notification to make ‘Additional Identifier’ field mandatory when creating new Item Master record please?

Greatly appreciate your help.

Many Thanks,

Matt

[former_member712472]

Hi Any example to check with SP transaction notification when an Item is created/updated and generate a .txt or .csv file?

thank you

[kothandaraman_nagarajan]

Hi,

Please try this,

IF @object_type = '4'

         AND @transaction_type IN ( 'A','U')

BEGIN

  if EXISTS  (Select t0.SWW from OITM  T0

  where T0.SWW IS NULL and T0.ItemCode=@list_of_cols_val_tab_del)

  begin

  SElect @error = -1

     SElect @error_message= 'Additional Identifier field mandatory'

  end

end​

Thanks

[Former Member]

Still no change. Can add new item without Additional Identifier field populated.

Thanks,

Matt

[former_member227598]

Hi Matt,

If your issue are resolved so kindly  closed the thread with mark the correct or helpful answer.

Thanks,

Kamlesh Naware

[former_member227598]

Hi Matt,

Please try below SP .....

IF @object_type = '4'

         AND @transaction_type IN ( 'A','U')

BEGIN

  if EXISTS  (Select t0.SWW from OITM  T0

  where (T0.SWW ='' OR T0.SWW IS NULL) and T0.ItemCode=@list_of_cols_val_tab_del)

  begin

  SElect @error = -1

     SElect @error_message= 'Additional Identifier field mandatory'

  end

end​

Thanks ,

Kamlesh Naware

[Former Member]

Hi Kamlesh,

I am still able to add new item without 'Additional Identifier' populated.

Any idea?

Many Thanks,

Matt