Reporting and Analytics for ERP

Get Involved. Join the Conversation.

Topic

    Dharmendra Jha
    BIP PO rtf Template archive queryAnswered
    Topic posted October 1, 2019 by Dharmendra JhaGreen Ribbon: 100+ Points, tagged BI Publisher 
    37 Views, 3 Comments
    Title:
    BIP PO rtf Template archive query
    Summary:
    Displaying the Line Level Notes to Supplier in the PO Template in BIP
    Content:

    Hi,

    I have a requirement to display "Notes to Supplier" field on to PO rtf Template at the line level. The PDFARCHIVEPURCHASEORDERLINE query is having a field "Line.NOTE_TO_VENDOR AS NoteToVendor," in the query.

    when I am running the Data Model query I only see the outputs from the Draft queries. The Archive queries don't execute. Is there any background process in the Fusion application to be run to display the Archive queries output or should the PO be Approved to get the Archive queries executed.

    Thanks in advance.

    Dharmendra

     

     

     

     

    Version:
    11.1.1.9.0

    Best Comment

    Pasupathi Reddy

    Hi ,

     

    Once Po approved then only Archive query will be executed . In draft mode stage we are not get archive dataset values .

    Thanks

    Pasupathi

    +91-9916246397

    Comment