Reporting and Analytics for SCM

Get Involved. Join the Conversation.

Topic

    Emre Kuscu
    Total Purchases for Tier I Suppliers
    Topic posted February 26, 2018 by Emre KuscuGreen Ribbon: 100+ Points, tagged BI Publisher, Costing, Dashboards, Order Management, OTBI, Procurement, Reporting and Analytics, SCM 
    79 Views, 1 Comment
    Title:
    Total Purchases for Tier I Suppliers
    Summary:
    I need to create an analysis that shows total purchases for specific suppliers.
    Content:

    I need to create an analysis that shows purchase order line details such as quantity and line description for some suppliers (Tier I Suppliers) in a certain timeframe (In last 6 months).

    For example:

    Supplier Name / PO Number / PO Creation Date / Item Description  / Quantity

    Can anybody help me creating this?

    Thanks in advance!

    Emre

    Comment

     

    • Emre Kuscu

      Supplier 

      PO Number Accounting Date Between Oracle Item # Line Description Order Qty
      ABX - -   - -
      XYZ          

      Here is the table of the report I am looking for. Currently we are exporting the data manually, and entering into this spreadsheet. I'd like to have a BI report/analysis that can provide this info anytime.