Blocking specific GL accounts for manual JEs

[Former Member]

Dear All,

Is there any possibility to block specific GL accounts for manual Journal Entry in SAP.

Exampl:- Client is making JE in the Control accounts like......GRNI .

Kindly suggest me a way to block tis other than SP.

Regards,

Shyam

[KennedyT21]

Hi Shyam....

Try This change XXXX with your original account code

IF @transaction_type in  ('A', 'U'  ) AND @Object_type = '30'

    BEGIN

    If Exists ( select t1.account from JDT1 T1

    INNER JOIN OACT T0 ON T1.Account = T0.AcctCode 

   where t1.transid = @list_of_cols_val_tab_del and T1.Transtype='30' and t1.revsource <> 'F' and 

  Account='XXXX' or ShortName='XXXX'

   )

    BEGIN

        SELECT @Error = 1, @error_message = N'Manual JE for these accounts is not permitted!'

     END

   END

Hope Helpful

Regards

Kennedy

[Former Member]

Hi,

2 option:

1. Use Journal voucher function for posting all manual JEs by grant authorization read-only to JE function and full authorization to JV function.
2. Use SP_TN

IF (@transaction_type = N'A' or @transaction_type = N'U' ) AND (@Object_type = N'30')

BEGIN

  IF @transaction_type = N'A'

  BEGIN

   if Exists ( select t1.account from JDT1 T1 INNER JOIN OACT T0 ON T1.Account = T0.AcctCode  

   where (t0.Fathernum in ('1111-add your own father account')

   and T1.Transtype='30' and t1.revsource <> 'F'

   and t1.transid = @list_of_cols_val_tab_del))

    BEGIN

         SELECT @Error = 1, @error_message = N'Manual JE for these accounts is not permitted!'

    END

  END

END

Hope this helps,

TVSon.

[kothandaraman_nagarajan]

Hi,

Please refer below screen shot:

Hope helpful.

[VamcParimisetti]

Hi Shyam,

I am afraid ,You Can achieve this by using SP only or you can use Confidential Accounts but that will not be applicable in your case because GRNI is a Control Accounts.Else Give the User Read Only Access to Pass JE and Give Access to Pass JV where Authoriser/Manager can Post/Reject the Voucher where you will be having some control to restrict Posting of JE's for Specific GL's

Regards,

Vamsi