Taking Stock Taking Stock Implementing and Integrating Inventory - - PowerPoint PPT Presentation

taking stock taking stock
SMART_READER_LITE
LIVE PREVIEW

Taking Stock Taking Stock Implementing and Integrating Inventory - - PowerPoint PPT Presentation

Taking Stock Taking Stock Implementing and Integrating Inventory in 8.9 Session 27377 March 1, 2010 12:45 1:45 Your Presenter Maria Whitaker Maria Whitaker Business Analyst Florida State University Current enrollment 40,255 FSU


slide-1
SLIDE 1

Session 27377 March 1, 2010 12:45 – 1:45

Taking Stock Taking Stock

Implementing and Integrating Inventory in 8.9

slide-2
SLIDE 2

Your Presenter

Maria Whitaker Maria Whitaker – Business Analyst

slide-3
SLIDE 3

Florida State University

Current enrollment 40,255

slide-4
SLIDE 4

FSU and Oracle PeopleSoft

  • Financials 8.4 Implementation July 2004
  • Upgrade to 8.9 November 2006

– MP5 applied April 2007

  • Upgrade to 9.0 April 2009
  • Financials Modules include:
  • GL with Commitment Control
  • Accounts Receivable/Billing
  • Purchasing/ePro (w/workflow)
  • Asset Management
  • Projects/Grants/Contracts
  • Travel & Expense (w/workflow)
  • Accounts Payable
  • Inventory/Cost Management
slide-5
SLIDE 5

Session Overview

  • Project background and objectives
  • Functionality used
  • Maintenance Management overview
  • Maintenance Management integration with Inventory
  • Maintenance Management integration with

Purchasing

  • Inventory integration with Purchasing
slide-6
SLIDE 6

Project Background and Objectives Legacy Systems and Process Flow

FMP Work Order System FMP Inventory & Purchasing System PS ePro/Purchasing & Receiving FMP Work Order System FMP Inventory & Purchasing System MySoft Billing

slide-7
SLIDE 7

Project Background and Objectives

  • Overview and mission

– Implementation was specific to the our Office of Telecommunications

  • Goals

– Reduce redundancy, increase inventory control, and improve audit trails

  • Scope

– Inventory – Cost Accounting – Utilize items – Maintenance Management

slide-8
SLIDE 8

Project Background and Objectives New Process Flow

FMP Work Order System PS Maintenance Management PS Inventory FMP Work Order System PS Purchasing & Receiving MySoft Billing PS Inventory

slide-9
SLIDE 9

Functionality Used

Maintenance Management

  • Established Item Master
  • Custom interface

– FMP Work Order system to PS MM – Header level information

  • Two types of demand:

– Inventory – Purchase/On-Hand

  • Two integration points:

– Inventory module – Purchasing module Inventory

  • Replenishment
  • Picking
  • Putaways
  • Issue to work orders
  • Inventory counts
slide-10
SLIDE 10

Maintenance Management Overview

Work Order Header

Maintenance Management > Work Orders > Work Order (tab)

slide-11
SLIDE 11

Maintenance Management Overview

Inventory

Work Order Requirements

Maintenance Management > Work Orders > Requirements (tab), Inventory

slide-12
SLIDE 12

Maintenance Management Overview

Special Purchase

Work Order Requirements

Maintenance Management > Work Orders > Requirements (tab), Purchase/On-Hand

slide-13
SLIDE 13

Maintenance Management Overview

Work Order Schedules

Maintenance Management > Work Orders > Schedules (tab)

slide-14
SLIDE 14
  • Maint. Mgmt. Integration with Inventory

Work Order Schedules Create Picking Plan in Inventory Issue to Work Orders from Inventory Replenishment for Unavailable Quantities

Process Flow

slide-15
SLIDE 15
  • Maint. Mgmt. Integration with Inventory

Work Order Schedules

Maintenance Management > Work Orders > Schedules (tab)

slide-16
SLIDE 16
  • Maint. Mgmt. Integration with Inventory

Issue to Work Orders from Inventory

Inventory > Fulfill Work Orders > Issue to Work Orders > WO Issue Search (tab)

slide-17
SLIDE 17
  • Maint. Mgmt. Integration with Inventory

Work Order Reference

Issue to Work Orders from Inventory

Inventory > Fulfill Work Orders > Issue to Work Orders > WO Issue Location (tab)

slide-18
SLIDE 18
  • Maint. Mgmt. Integration with Purchasing

Work Order Schedules Load Requisitions from Work Order Schedules Requisition Load Process Source Requisition to PO and Dispatch

Process Flow

slide-19
SLIDE 19
  • Maint. Mgmt. Integration with Purchasing

Work Order Schedules

Maintenance Management > Work Orders > Schedules (tab)

slide-20
SLIDE 20
  • Maint. Mgmt. Integration with Purchasing

Requisitions Load Process

Purchasing > Requisitions > Load Requisitions

slide-21
SLIDE 21
  • Maint. Mgmt. Integration with Purchasing

Requisition Created from a Work Order

Purchasing > Requisitions > Maintain Requisitions

slide-22
SLIDE 22
  • Maint. Mgmt. Integration with Purchasing

Requisition Created from a Work Order

Purchasing > Requisitions > Maintain Requisitions > Schedules (link)

slide-23
SLIDE 23

Inventory Integration with Purchasing

Reorder Point Replenishment Requisition Load Process Source Requisition to PO and Dispatch

Process Flow

slide-24
SLIDE 24

Inventory Integration with Purchasing

Reorder Point Replenishment

Inventory > Replenish Inventory > Create Replenishment Requests

slide-25
SLIDE 25

Inventory Integration with Purchasing

Reorder Point Replenishment

Inventory > Replenish Inventory > Manage Replenishment Requests

slide-26
SLIDE 26

Inventory Integration with Purchasing

Requisition Load Process

Purchasing > Requisitions > Load Requisitions

slide-27
SLIDE 27

Inventory Integration with Purchasing

Requisition Created from a Work Order

Purchasing > Requisitions > Maintain Requisitions

slide-28
SLIDE 28

Inventory Integration with Purchasing

Requisition Created from a Work Order

Purchasing > Requisitions > Maintain Requisitions > Requisition Defaults (link)

slide-29
SLIDE 29

Project Outcomes

After

FMP Work Order System PS Maintenance Management PS Inventory FMP Work Order System PS Purchasing & Receiving MySoft Billing PS Inventory FMP Work Order System FMP Inventory & Purchasing System PS ePro/Purchasing & Receiving FMP Work Order System FMP Inventory & Purchasing System MySoft Billing

Before

slide-30
SLIDE 30

Questions?

slide-31
SLIDE 31

This presentation and all Alliance 2010 presentations are available for download from the conference site heug.org

Presentations from previous meetings are also available