on 05-06-2011 11:00 AM
Dear All,
how can i block cash Account entries ? if company have not balance in Cash Account.
Thanks in Advance
Deepak Patel
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.