Reporting and Analytics for ERP

Get Involved. Join the Conversation.

Topic

    Amar
    Subledger Distributions to General Ledger
    Topic posted August 14, 2019 by AmarBlue Ribbon: 750+ Points, tagged BI Publisher, Fusion Financial reporting, OBI Answers, Reports, Sample Reports, Tip 
    91 Views, 9 Comments
    Title:
    Subledger Distributions to General Ledger
    Summary:
    Subledger Distributions to General Ledger
    Content:

    All-> Need to show the amounts of Invoice distributions/Matched/not matched POs related to Payables payments/reconciled payments flowing to XLA to General Ledgers(We are distribution amounts because we need to show invoice number, line number, line descriptions). We are facing issue with distribution adjusted/discounts applied which needs to be excluded from the report.

    How to exclude distributions which are adjusted .?

    Regards,

     

     

     

    Comment

     

    • Sudhakara Rao Kovuru

      Hey Amar,

      Adjustment details will be stored in AP_INVOICE_DISTRIBUTIONS_ALL and corresponding payments are captured in AP_PAYMENT_HISTORY_ALL so please use these tables to Exclude the Adjustments

      AP_INVOICE_DISTRIBUTIONS_ALL --> ROOT_DISTRIBUTION_ID --> original distribution that has been price adjusted 

                                                                 --> ADJUSTMENT_REASON    --> Reason for adjustment on the invoice line.

      AP_PAYMENT_HISTORY_ALL         --> INVOICE_ADJUSTMENT_EVENT_ID  --> Adjusted Invoice Event
       
      Thanks,
      -Sudha.