0 Replies Latest reply on Nov 15, 2018 5:07 PM by 3733404

    AP and PO Accrual Reconciliation Report

    3733404

      AP and PO Accrual Reconciliation Report is not showing "Return to vendor" Details

       

      1. Nov-18 Periods are open.

      2. Create Accounting - Receiving is run. That particular transaction is posted to GL.

      3. Return to Vendor created Debit Memo in AP. This is validated and accounted.

      4. Accrual Reconciliation Load Run is run

      5. Account Analysis report for Accrual Code Combination is showing the Return to Vendor Transaction in NOV-18

      6. AP and PO Accrual Reconciliation Report is not showing the transaction

       

      What else i can check ?

       

      Any help/inputs appreciated.

       

      Thanks,

      Siva

       

       

      Update:

      I ran this from the R12: Discrepancies with Accrual Reconciliation Report - Troubleshooting (Doc ID 1117353.1). Script 2.

       

       

      SELECT transaction_date,

      po_distribution_id,

      transaction_type_code,

      amount,

      quantity,

      accrual_account_id

      FROM cst_ap_po_reconciliation

      WHERE po_distribution_id IN

      (SELECT po_distribution_id

      FROM po_distributions_all

      WHERE po_header_id IN

      (SELECT po_header_id

      FROM po_headers_all

      WHERE segment1 = '&po_number'

      AND org_id =

      &org_id

      )

      )

       

      No rows returned