Skip to Content
avatar image
Former Member

Prevent Posting AP Invoices without P.O & GRPO

Hi ,

How to set authorization for the following scenario .

Some of the users put AP Invoice without P.O & GRPO.How can i prevent it ? A users shouldn't directly post AP Invoices without P.O & GRPO.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Feb 13, 2017 at 12:21 PM

    Hello,

    You can achieve it by writing a SQL code in Transaction Notification which will block the user when he will enter AP Invoice without a base entry. You need to just check BaseType for PCH1 table. BaseType should be either 22 (PO) or 20 (GRPO)

    Regards,

    Engr. Taseeb Saeed

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 13, 2017 at 12:39 PM

    Hi,

    No authorization setting for AP invoice without base document. If you have only one line in AP Invoice, then you can use approval procedure.

    If multiple lines, you can use Transaction notification.

    Regards,

    Nagarajan

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 14, 2017 at 05:14 AM

    Hello,

    This is the code for you

    
    If @object_type = '18' And @transaction_type in ('A','U')
    BEGIN
    
    
    DECLARE @intError INT
    
    
    SELECT @intError =   COUNT(*) FROM dbo.PCH1 T0
    WHERE T0.DocEntry = @list_of_cols_val_tab_del
    AND t0.BaseType NOT IN (22,20)
    
    
    
    
     IF @intError > 0
      BEGIN
      SET @error = 1004
      SET @error_message = 'A/P Invoice -- You can not make A/P Invoice without base document PO or GRPO'
      select @error, @error_message
      END
      
      
    
    
    
    
    END
    

    Thanks

    Engr. Taseeb Saeed

    Add comment
    10|10000 characters needed characters exceeded