cancel
Showing results for 
Search instead for 
Did you mean: 

Duplicate Batch No Notification

ramco1917
Participant
0 Kudos

Hi

  I have below Notification for Duplicate Batch No but i want that it should not be check if User Cancels the Document.

  IF @object_type ='20' and @transaction_type in ('A')
BEGIN
if exists(Select distinct 'Error' from IBT1 B1 , IBT1 B2
where b1.BatchNum in (isnull(b2.BatchNum,'')) and B1.BaseEntry = @list_of_cols_val_tab_del
and b1.ItemCode = B2.ItemCode and b2.BaseEntry <> @list_of_cols_val_tab_del and b2.BaseType = 20 and b1.BaseType = 20)
begin
SET @error = 2000
SET @error_message = 'Duplicate Batch No. not allowed!'
End
End

Thanks

View Entire Topic
ANKIT_CHAUHAN
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi ramco1917,

For Cancel, include @transaction_type = 'C' accordingly in the notification script.

Hope it helps!

Kind regards,

ANKIT CHAUHAN

SAP Business One Support