Reporting and Analytics for ERP

Get Involved. Join the Conversation.

Topic

    Madhu Babu Vitta
    BPM - capture comments in a ReportAnswered
    Topic posted May 8, 2019 by Madhu Babu VittaBronze Medal: 1,250+ Points, tagged BI Publisher, Fusion Financial reporting, Reports, Sample Reports, Tip 
    93 Views, 3 Comments
    Title:
    BPM - capture comments in a Report
    Summary:
    BPM - capture comments in a Report
    Content:

    Hello All,

    We have a requirement to build the report to fetch all the invoices where Approvers either Rejected or Requested for more information during the Invoice Approval.

    We are planning to create custom BIP report using below key tables.

    1) ap_invoices_all

    2) ap_inv_aprvl_hist_all

    But we couldn't find a way to capture the Approver comments entered during the approval process.

    Let us know if you have any such report/suggestions.

    #BPM

    #BIPReport

    Thanks,

    Madhu
    Version:
    19B

    Best Comment

    Alexey Shtrakhov

    Hi Madhu

    please check attached script what I'm using.
    you can certainly adapt it to your needs (please check it and change some id which I hard coded there in one of the branch), also I just copied from you the part from the parametrized report so you will see those parameters here (mainly you can keep INVOICE_ID).

    This script will pickup:
    - notes from invoice
    - comments from approval history
    - comments from BPM

    Note, that BPM tables will be purged after some time, so that is why approval history and notes are in the long run the only place to pickup these comments.

    Alexey

    Comment

     

    • Alexey Shtrakhov

      Hi Madhu

      please check attached script what I'm using.
      you can certainly adapt it to your needs (please check it and change some id which I hard coded there in one of the branch), also I just copied from you the part from the parametrized report so you will see those parameters here (mainly you can keep INVOICE_ID).

      This script will pickup:
      - notes from invoice
      - comments from approval history
      - comments from BPM

      Note, that BPM tables will be purged after some time, so that is why approval history and notes are in the long run the only place to pickup these comments.

      Alexey

    • Madhu Babu Vitta

      Thanks for quick help Alexy!

      I will check and get back to you.

    • Madhu Babu Vitta

      Thanks Alexy it worked !

      Marking it as Answered !