Payables & Cash Management

Get Involved. Join the Conversation.

Topic

    Heena Jesani
    Payables Period Close Exceptions Report not displaying any...
    Topic posted August 21, 2019 by Heena JesaniGreen Ribbon: 100+ Points, last edited August 21, 2019, tagged Financials, Payables, Period Close / Reconciliation 
    28 Views, 3 Comments
    Title:
    Payables Period Close Exceptions Report not displaying any data
    Summary:
    Payables Period Close Exceptions Report is not displaying any data eventhough the Payables period cannot be closed
    Content:

    Hi Folks,

    We are facing an issue when trying to close payables period, the Close Payables Accounting Period program ends in warning with "AP_UNACCT_TRXS_EXISTS - Unaccounted Invoices and/or payments". However the Payables Period Close Exceptions report ends in Error with no data in it. 

    When trying to run the report from Scheduled Processes work area, it runs successfully however there is still no data in it.

    We are on 19C. Has anyone faced this issue? Appreciate your inputs if you have also faced this or were able to resolve it.

    Thanks!

    Comment

     

    • Karthikeyan Sukumar

      This is not 19C issue.

      May be there are invoice lines exist without distribution.Can you run the below SQL and check.

      ​If you found any invoices without distribution then correct those validate again or delete the invoice is not required.

      SELECT ap_invoices_pkg.get_posting_status(ai.invoice_id) posting_flag
      ,AI.*
      FROM AP_INVOICES_ALL AI
      WHERE AI.SET_OF_BOOKS_ID = <&ledger_id>
      AND AI.GL_DATE BETWEEN to_date('<&yyyy-mm-dd>', 'YYYY-MM-DD') and
      to_date('<&yyyy-mm-dd>', 'YYYY-MM-DD')
      AND ap_invoices_pkg.get_posting_status(ai.invoice_id) != 'Y';

      Thanks!

      Karthik

    • Phil Nibert

      We had a similar issue with one of our AP closes and resolved it by running the AP sweep transactions to sweep any unaccounted AP transactions to the next month.