Cash Amount in my Cash Ledger
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
Manvendra Singh Niranjan replied
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'
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
Select @error = 17 ,@error_message =N'We have not sufficiant Cash Amount '
Manvendra Singh Niranjan