cancel
Showing results for 
Search instead for 
Did you mean: 

Block Cash Account Entries

Former Member
0 Kudos

Dear All,

how can i block cash Account entries ? if company have not balance in Cash Account.

Thanks in Advance

Deepak Patel

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

Thank You Very Much Mr.Manvendra

Answers (0)