Supplier Management

Get Involved. Join the Conversation.

Topic

    Jasper Oskam
    Export supplier data retrieved from supplier self...
    Topic posted November 17, 2016 by Jasper OskamRed Ribbon: 250+ Points, last edited November 17, 2016, tagged Supplier Creation, Supplier Registration 
    72 Views, 4 Comments
    Title:
    Export supplier data retrieved from supplier self registration
    Summary:
    How to extract supplier information to excel
    Content:

    Our client wants to easily extract all data that a supplier enters through the self registration form into excel. Is that possible? I am checking the export objects option, but I cannot find an object that fully shows all supplier registration data in one excel file. Is there any other option available?

    Thank you

    Jasper Oskam

    Comment

     

    • Hong Gao

      You can use BI reporting to achieve this.  Please go to Reports and Analytics and create an analysis in the Supplier Registration Real Time subject area using specified criteria.  After that, you can export the report to excel.

      Regards,

      Hong

    • Jasper Oskam

      Thank you.

      is it also possible to add attachments that a supplier adds to that excel extract?

    • Hong Gao

      Do you mean the attachments added during supplier registration? No, that cannot be added to the BI report.  But Note to Approver entered during registration can be part of the BI report.

      Regards,

      Hong

    • Jasper Oskam

      Thank you Hong.