on 01-13-2017 7:55 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
7 | |
6 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.