Hello Deepak,
Try this solution
Make SP_transaction notification
-
Not sufficiant Cash Amount----
IF @transaction_type = 'A' ANd @object_type ='46'
Begin
Declare @Amount decimal(10,3)
Set @Amount = (Select T3.CurrTotal from OACT T3 where T3.AcctCode = (Select CashAcct from OVPM where DocEntry = @list_of_cols_val_tab_del ))
if @Amount < 0
Begin
Select @error = 17 ,@error_message =N'Company have not sufficiant Cash Amount '
end
end
-
Thanks
Manvendra Singh Niranjan
Add a comment