Skip to Content
author's profile photo
Former Member

Block Cash Account Entries

Posted on May 06, 2011 at 10:00 AM 8 Views

Dear All,

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

Thanks in Advance

Deepak Patel

SAP Business One
Add comment
10|10000 characters needed characters exceeded

1 Answer

  • Best Answer
    author's profile photo
    Former Member
    Posted on May 06, 2011 at 10:01 AM

    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 comment
    10|10000 characters needed characters exceeded