Block Back Dated Posting In any transaction Except for Super Users

[former_member264311]

Good Day,

Hi Experts. Help me to block specific users to posting Back Dated,

Best Regards,

Thanks

[narayanis · Accepted solution]

Hi,

if @transaction_type in('A','U') AND @object_type='20'

Begin

if not Exists(SELECT T0.DocEntry FROM dbo.OPDN T0 WHERE T0.DocDate = CAST(CURRENT_TIMESTAMP AS DATE)

and T0.DocEntry = @list_of_cols_val_tab_del)

Begin

SET @error = -2

SET @error_message = N'Please add Posting Date is todays date only'

End

End

This will disallow all the users from adding and updating a GRPO on a date earlier than current date. Please check your super user login number and add it in the condition.

Feel free to write in case of any further help

Regards

Pradnya

[former_member309532 · Accepted solution]

Hi.

Can we restrict all documents which post JE in back date ?

Is there a single sp for that.

Thanks

[narayanis]

Hi,

Please refer this link for a detailed document on SPTN.

http://projectservercode.com/transaction-notification-in-sap-b1/

https://blogs.sap.com/2009/05/22/the-sptransactionnotification-stored-procedure/

Regards

Pradnya

[Former Member]

Dear Romel Catalogo,

You can do it by SBO_SP_TransactionNotification for each document.

Thanks

Engr. Taseeb Saeed

[narayanis]

Hi,

You will have to go for SPTN.

Regards

Pradnya

[former_member264311]

Can you give me a sample code? thanks