cancel
Showing results for 
Search instead for 
Did you mean: 

SP TN Block Backdated Posting

former_member264311
Participant
0 Kudos

Good Day!

Hi Experts, Correct my code please. I cant get the notification on my SPTN Blocking Backdated posting in A/R and some of the transaction. Please see my Code Below:

if @transaction_type = 'A' and @object_type = '13'
begin
if exists(select T0.DocDate, T0.DocEntry from
dbo.OINV T0 INNER JOIN INV1 T1 ON T0.DocEntry = T1.DocEntry INNER JOIN OUSR T3 ON T0.UserSign = T3.USERID
where T0.docentry = @list_of_cols_val_tab_del and datediff(dd, T0.[DocDate],current_timestamp)<1 and t3.USER_CODE = 'Manager')
begin
SET @error = 13
SET @error_message = N'You are not allowed to post this transaction.'
end
END

Accepted Solutions (1)

Accepted Solutions (1)

kothandaraman_nagarajan
Active Contributor

Hi,

Try this,

if @transaction_type = 'A' and @object_type = '13'
begin
if exists(select T0.DocDate, T0.DocEntry from
dbo.OINV T0 INNER JOIN INV1 T1 ON T0.DocEntry = T1.DocEntry INNER JOIN OUSR T3 ON T0.UserSign = T3.USERID
where T0.docentry = @list_of_cols_val_tab_del and datediff(dd, T0.[DocDate],Getdate() )<1 and t3.USER_CODE = 'Manager')
begin
SET @error = 13
SET @error_message = N'You are not allowed to post this transaction.'
end
END

Have you tried with standard function under Document settings-->Block documents with earlier Posting Date

Regards,

Nagarajan

former_member264311
Participant
0 Kudos

Thanks for the reply Nagarajan,

But my requirements is to block backdating post only,not to block earlier posting date.

thanks

Answers (3)

Answers (3)

kothandaraman_nagarajan
Active Contributor
0 Kudos

Have you tried,

if @transaction_type = 'A' and @object_type = '13'
begin
if exists(select T0.DocDate, T0.DocEntry from
dbo.OINV T0 INNER JOIN INV1 T1 ON T0.DocEntry = T1.DocEntry INNER JOIN OUSR T3 ON T0.UserSign = T3.USERID
where T0.docentry = @list_of_cols_val_tab_del and datediff(dd, T0.[DocDate],Getdate() )<1 and t3.USER_CODE = 'Manager')
begin
SET @error = 13
SET @error_message = N'You are not allowed to post this transaction.'
end
END

former_member264311
Participant
0 Kudos

Thanks Nagarajan.

What if they change the Date and Time in the server? because all our users using remote desktop to use SAP B1.

Best Regards.

Thanks

Former Member

Dear Romel,

You can restrict users by applying policy after this they would not be able to change the system date to whom they are accessing through remote.

Thanks

Engr. Taseeb Saeed

Former Member
0 Kudos

Dear Romel Catalogo,

Please Select @error and @erro_message after setting them like

SET @error = 13
SET @error_message = N'You are not allowed to post this transaction.'

SELECT @error,@error_message

thanks,

Egr. Taseeb Saeed

narayanis
Active Contributor
0 Kudos

Hi,

Please try to get the result of datediff function.

Also instead of current_timestamp try using getdate() function with the condition <> 0

Regards

Pradnya