Thursday, January 4, 2018

AP Invoice Interface Errors & Fix

      INVALID DISTRIBUTION ACCT
     DUPLICATE LINE NUMBER
     ZX_IMP_TAX_RATE_AMT_MISMATCH
     NO EXCHANGE RATE
     INVALID ASSIGNMENT

      INVALID DISTRIBUTION ACCT
      Given GL Code combination is invalid, to verify use the below query by passing the parameter of gl code combination
               select * from gl_code_combinations_kfv
               where concatenated_segments  = <GL Code combination>;
     If there is no value from the above query then given code combination is not available in oracle.
      
       DUPLICATE LINE NUMBER
    If the invoice file has the value of line number multiple times then it will throw the error like this.
    Correct the line number and make it unique and process the file.

       ZX_IMP_TAX_RATE_AMT_MISMATCH
     Tax code is defined for zero tax value and the file having the tax value of greater than zero.
     Either change the tax code or tax amount value.

       NO EXCHANGE RATE

       In case of foreign currency involved in the payment process then exchange rate is mandatory. Make sure exchange rate is available 

        INVALID ASSIGNMENT
       Sequential numbering setup missed against the operating unit



4 comments: