slide1 n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Presented by EMSC BEGINS AT 2:15pm EST PowerPoint Presentation
Download Presentation
Presented by EMSC BEGINS AT 2:15pm EST

Loading in 2 Seconds...

play fullscreen
1 / 9

Presented by EMSC BEGINS AT 2:15pm EST - PowerPoint PPT Presentation


  • 106 Views
  • Uploaded on

Presented by EMSC BEGINS AT 2:15pm EST. ProcureIt Reporting. Steve Silloway Procurement Director, EMSC. Greenwood Village, Colorado. Emergency Medical Services Corporation.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

Presented by EMSC BEGINS AT 2:15pm EST


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
    Presentation Transcript
    1. Presented by EMSC BEGINS AT 2:15pm EST

    2. ProcureIt Reporting Steve Silloway Procurement Director, EMSC Greenwood Village, Colorado Emergency Medical Services Corporation

    3. ProcureIt Purchase Manager deployed to production at AMR on November 8, 2004 as a supply management tool • Needs/Requirements • Common platform company wide • Standard PO Creation • Approval Process • Promotes national vendor use • Punchouts • Ease of use • Intuitive – web-based – similar to online web stores • Client/Server – Easily deployed across company Intranet

    4. Since Inception – Evolution of ProcureIt at EMSC • Growth in scope of application • More Users • More Vendors • Capital Items and Projects • SOX Controls • Budget Module • eInvoicing • Asset Module • Invoice Manager • Current version 9.5

    5. ProcureIT Reports / Data Extraction • ProcureIT Standard Reports • Purchase Orders by Location and Vendor • On Demand versus Scheduled Task • Users and their Managers • Item Usage • Assets by Location and User • ProcureIT Custom Reports for EMSC • Accrual Report used by Finance • Orders received but not invoiced • EMSC Budget Information Report • EMSC Capital Budget Information

    6. ProcureIT Reports / Data Extraction • Extracting Data from ProcureIT’s Database • MS SQL Relational Database • Use MS Access or Crystal Reports to create custom reports • Budget • CapEx • Create queries to extract data for analysis and reporting • Item Pricing Analysis • Item Purchase Trending

    7. ProcureIT Reports / Data Extraction • Accessing backend data requires: • Read Only permission to database • Generally granted by database administrator in IT • Setting up an ODBC (Open Database Connectivity) link on your computer • Basic understanding of relational databases • Tables and Primary Keys – Connecting the dots • Practice using MS Access or Crystal Reports

    8. ProcureIT Reports / Data Extraction Demonstration and Q&A