Reporting and Analytics for ERP

Get Involved. Join the Conversation.

Topic

    Mary King
    Data provided in subject Area Procurement - Purchasing Real...
    Topic posted March 21, 2019 by Mary KingRed Ribbon: 250+ Points, tagged Public Sector 
    40 Views
    Title:
    Data provided in subject Area Procurement - Purchasing Real time
    Summary:
    Data from Purchase Order Pre-processing Days inconsistent
    Content:

    I am having difficulty obtaining metric information.

    I am working with OTBI and trying to get the cycle time between requisition last approval date/time and the  date/time the PO is created.  I am using the Procurement – Purchasing Real Time subject area.  Under Purchase Order Header there are two options that I am using:  Purchase Order Pre-processing Days and Purchase Order Approval Processing Days (to track how long PO approvals were taking). 

    I was hoping to obtain date on the number of days from the last requisition approval date to PO creation date in the Purchase Order Pre-processing Days (optimally with data display 3 places to the right of the decimal to account for partial days. 

    Our buyers do their governance and evaluation of the requisition prior to creating the PO.  This calculation mentioned above would provide me a metric on how long the buyers are taking to move a requisition to a PO.  I noticed information in documentation, from older releases, that there were cycle time subject area fields provided at one time.

    I am also getting inconsistent results predominantly from the Purchase Order Pre-process Days field.   I am wondering if the Purchase Order Pre-processing Days is collecting different information than what I expected.  I checked a random number of PO’s from a three- month period.  

     

    • Rounding is not consistent
    • Displays to the right of the decimal are inconsistent (usually does not display any numbers to the right of the decimal however, when it does it can be from 1 to 3 places to the right of the decimal– I am using the default data format and tried going with the custom format but that made no difference.  Optimally I would like to see the data always provided at least 3 places to the right of the decimal.
    • Using the User Interface I was doing manual calculations
      • This manual review was  done by calculating the minutes from the last requisition approval to the PO creation date.
      • Sometimes data it matches the amount of  time in the report and other times it does not – there does not appear to be a pattern where I can determine what is causing the difference.  I have checked for:
        • Change Order and revision issues
        • Withdrawals, cancellations and rejections

    I would appreciate any information you may have to get me started down the correct path.

    Version:
    Rel 13 19A