Skip to Content
0
May 29, 2020 at 07:38 AM

outgoing payment select checkbox

119 Views Last edit May 29, 2020 at 01:37 PM 3 rev

user must select invoice while add outgoing payment if its not select it not going to add.

i have tried below sp_notification but not working.

<br>IF @object_type='46' AND (@transaction_type in ('U','A'))
Begin
IF EXISTS(Select * from OVPM T0  INNER JOIN VPM1 T1 ON T0.[DocEntry] = T1.[DocNum]
 where T0.DocEntry=@list_of_cols_val_tab_del and T1.[ManualChk] ='N')
 BEGIN
SELECT @Error = 1, @error_message = 'Please select the invoice'
END
End