Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Cash Amount in my Cash Ledger

Dear experts,

My client wants to block transaction if he dont have sufficient amount in his cash ledger .So how to configure same in SAP Business One

Thanks

Saurabh

Former Member
Former Member replied

Hello ,

You should need to SP_Transaction Notification because SAP does not have same configuration which your client wants.

-


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'We have not sufficiant Cash Amount '

end

end

-


Thanks

Manvendra Singh Niranjan

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question