Skip to Content

SP TN Block Backdated Posting

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Jan 17, 2017 at 10:54 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 13, 2017 at 11:23 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 17, 2017 at 06:31 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 19, 2017 at 12:59 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Romel Catalogo

      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