How to block journal entry posting

[Former Member]

How to block journal entry posting 

[KennedyT21 · Accepted solution]

Hi Rajeesh...

Can you explain in detail  what  case you need to block the Journal..

sample for the dimensions...

IF @object_type = '30' AND @transaction_type = 'A'

  BEGIN

    IF EXISTS (SELECT

        TransId

      FROM jdt1 t1     

      WHERE @list_of_cols_val_tab_del = TransId AND (ISNULL(t1.ProfitCode, '') = '' OR ISNULL(t1.OcrCode2, '') = ''))

    BEGIN

      SET @error = -2

      SET @error_message = 'Select the Dimensions and Departments'

    END

  END

Regards

Kennedy

[Former Member · Accepted solution]

This is our old db. I want to stop new posting from 2014-07-10

[KennedyT21 · Accepted solution]

Try  This

IF @object_type = '30' AND @transaction_type = 'A'

  BEGIN

    IF EXISTS (SELECT

        TransId

      FROM OJDT t1    

      WHERE @list_of_cols_val_tab_del = TransId AND   t1.CreateDate>='20140710'  )

    BEGIN

      SET @error = -2

      SET @error_message = 'Posting Not allowed'

    END

  END

[Former Member · Accepted solution]

we have to punch some details  <=2014079. kindly help

[Former Member · Accepted solution]

Dear Kennedy

below query is working for me.

IF @object_type = '30' AND @transaction_type = 'A'

  BEGIN

    IF EXISTS (SELECT

        TransId

      FROM OJDT t1   

      WHERE @list_of_cols_val_tab_del = TransId AND   t1.RefDate>='20140710'  )

    BEGIN

      SET @error = -2

      SET @error_message = 'You are not authorize to add.No new posting is allowed in WILLIAMPENN!'

    END

  END

[Former Member]

How do I block same way other transactions too?

[kothandaraman_nagarajan]

Hi,

Try this:

IF (@object_type = '30') and (@transaction_type IN (N'A'))

BEGIN

IF EXISTS (

SELECT TRANSID FROM OJDT A WHERE  TransId = @list_of_cols_val_tab_del)

BEGIN

Select @error = 10, @error_message = N'You are not authorize to add this JE'

END

END

Thanks & Regards,

Nagarajan

[Former Member]

Nagaraj kindly specify the date range which i was given