My Florida Market Place Customer Roundtable CRT Meeting

My. Florida. Market. Place Customer Roundtable (CRT) Meeting April 8, 2009, 9: 00 am EDT The toll free number is: (888) 808 -6959 Conference Code: 5263885 #

Agenda q Welcome / Introduction [Walt Bikowitz] q Review: Year End Processes Ø Certified Forward Ø Payables Ø Reducing/Releasing Encumbrances Ø Disbursement Transaction Override Ø Available Reports and Job Aids q 1% Fee Exemption Process q Training Update q Punchout Catalogs q Vendor Updates q SPURS Sunset q Wrap-Up! Page - 2

Agenda q Welcome / Introduction q Review: Year End Processes [Anne Rabon] Ø Certified Forward Ø Payables Ø Reducing/Releasing Encumbrances Ø Disbursement Transaction Override Ø Available Reports and Job Aids q 1% Fee Exemption Process q Training Update q Punchout Catalogs q Vendor Updates q SPURS Sunset q Wrap-Up! Page - 3

Review: Year End q Last year, MFMP was taken down on July 1 st to complete the “Certified Forward” and “Delay Purchase Until” process q Customers were notified of the systems availability through e-mail communications q 61% fewer transactions needed manual intervention than in previous years Ø The 387 transactions needing manual intervention, were resolved on July 3 rd whereas in previous years, they took approximately a week q Improvements were made to the MFMP Certify Forward program that processes the DFS Certify Forward file resulting in a reduction of overall run time for that batch program from eight hours to under two hours (32, 095 requisition line items were processed in less than two hours compared to 30, 324 in eight hours the previous year q These reductions in time assisted in a successful year end process q We would like to repeat the process again this year, taking MFMP down on July 1, 2009 Page - 4

Agenda q Welcome / Introduction q Review: Year End Processes Ø Certified Forward Ø Payables Ø Reducing/Releasing Encumbrances Ø Disbursement Transaction Override Ø Available Reports and Job Aids q 1% Fee Exemption Process q Training Update q Punchout Catalogs q Vendor Updates q SPURS Sunset q Wrap-Up! Page - 5

Certified Forward q On July 1, 2009, (early a. m. ), MFMP will be receiving the file update from FLAIR as to which encumbered requisitions should be marked with a Certified Forward Indicator q This process will only mark encumbered requisitions. Unencumbered requisitions will need to be marked manually by initiating a change order q Change Orders can be completed on requisitions in “Received” status Page - 6

Certified Forwards: Manual Process Overview Activity will need to be completed by Finance and Accounting Page - 7

Agenda q Welcome / Introduction q Review: Year End Processes Ø Certified Forward Ø Payables Ø Reducing/Releasing Encumbrances Ø Disbursement Transaction Override Ø Available Reports and Job Aids q 1% Fee Exemption Process q Training Update q Punchout Catalogs q Vendor Updates q SPURS Sunset q Wrap-Up! Page - 8

Payables: Process Overview Activity will need to be completed by Finance and Accounting Page - 9

Agenda q Welcome / Introduction q Review: Year End Processes Ø Certified Forward Ø Payables Ø Reducing/Releasing Encumbrances Ø Disbursement Transaction Override Ø Available Reports and Job Aids q 1% Fee Exemption Process q Training Update q Punchout Catalogs q Vendor Updates q SPURS Sunset q Wrap-Up! Page - 10

Reducing/Releasing Encumbrances q There are four ways to reduce or release encumbrances in MFMP: Ø Change Orders can be submitted to reduce the quantity/amount of your order, reducing the encumbered amount Ø Final Payment Indicator can be checked when approving an IR for encumbered payments to un-encumber the remaining balance, this check box is located on the line level detail of the IR Ø Release Encumbrance e. Form can be used to release all the remaining funds associated on an order Ø Release Encumbrance Request Form can be submitted to the Customer Service Desk to release the encumbrance, however, you will need to supply the REF (Release Encumbrance e. Form) number Page - 11

Release Encumbrance e. Form: Process Overview Activity will need to be completed by Finance and Accounting Page - 12

Agenda q Welcome / Introduction q Review: Year End Processes Ø Certified Forward Ø Payables Ø Reducing/Releasing Encumbrances Ø Disbursement Transaction Override Ø Available Reports and Job Aids q 1% Fee Exemption Process q Training Update Punchout Catalogs q Vendor Updates q SPURS Sunset q Wrap-Up! Page - 13

Disbursement Transaction Override q During disbursement processing, the disbursement transaction type may be changed from encumbered to unencumbered disbursement, or unencumbered to encumbered disbursement by checking or unchecking the ‘Encumber Funds’ checkbox q Customers assigned the “Invoicing” group will have the ability to override the disbursement type q The ‘Encumber Funds’ checkbox is at the split accounting level and must be updated for each split accounting line (Note: All transactions must be the same type) q If the disbursement transaction type is changed from encumbered to unencumbered, it may be necessary to use the Release Encumbrance e. Form to release the remaining encumbrance amount Page - 14

Agenda q Welcome / Introduction q Review: Year End Processes Ø Certified Forward Ø Payables Ø Reducing/Releasing Encumbrances Ø Disbursement Transaction Override Ø Available Reports and Job Aids q 1% Fee Exemption Process q Training Update q Punchout Catalogs q Vendor Updates q SPURS Sunset q Wrap-Up! Page - 15

Reports q There are several My. Florida. Market. Place reports that are generated for use by agencies and posted to the DMS Web site (http: //dms-purchasing-ftp. state. fl. us/xx 00/) q A job aid is also available on the DMS Web site (in the MFMP Toolkit) that lists the available reports along with a description of each Note: this document is currently being updated (http: //dms. myflorida. com/business_operations/state_purchasing/myflori da_marketplace/buyers/myflorida_marketplace_toolkit) Page - 16

Suggested Year End Reports The following reports (from the DMS Web site) should be helpful in year end processing: IRs With Last Approver q Primarily used by Finance & Accounting to monitor the status and activity of IRs to ensure prompt payment processing q Lists Invoice Reconciliations (IRs) in Reconciling and Approving status Ø This includes IRs generated from the Ariba Supplier Network (ASN) (Purchasing Unit Indicator (PUI): 9999) and IRs that failed Central FLAIR Ø IRs that failed Central FLAIR will list the approving invoice manager by name and will remain in Approving status until resolved Ø This excludes IRs that list FLAIR Integration as the active approver and does not list IRs in Paid status Ø Customers whose queue the IR is currently active will be listed § This also includes IRs routed to the Invoice Administrator. This only applies to ASN invoices Page - 17

Suggested Year End Reports Invoice Reconciliation Report q Will assist Finance and Accounting in determining outstanding invoices by budget to determine what action needs to be taken when budgets change q Lists all non-ASN IRs in an Approving, Reconciling or Rejecting status POs Without IRs q Is primarily used by Finance & Accounting to identify Orders where IRs were not created through My. Florida. Market. Place q Lists Commodity POs in a Receiving or Received status q Service POs in Ordered Status All Received Orders Report q Is primarily used by Finance and Accounting to identify purchase orders containing commodities to determine if invoices have been received and processed q Lists Orders in a Received status Page - 18

Suggested Year End Reports All Open Orders Report q Is primarily used by Finance and Accounting to identify all “Open” POs to determine if invoices have been received and processed. This is also used by Purchasing personnel to determine if the purchase order needs to be changed, canceled or closed for future receiving q Lists POs in Ordering, Ordered and Receiving status All Orders Report q Is the same as the All Open Orders Report but includes Orders in Received status PR’s in Submitted Status q Displays intended PR obligation by organizational code before the money is committed through a direct order. Managers are able to review spending plans before the agency is committed to an expenditure q List the latest version of a PR in a Submitted status Page - 19

Suggested Year End Reports Punchout vs Non. Catalogs q Used by Finance and Accounting and Purchasing. F&A will be able to view the Orders being placed against Punchout vendors, resulting in an e. Invoice and Purchasing will be able to determine if the Punchout features are being utilized q Vendors being captured § Dell Marketing L. P. § Hewlett-Packard Company § VF Imagewear, Inc. § Lenovo Inc. § Grainger Industrial Supply § Fisher Scientific Company LLC § Office Depot BSD (pull only Non-Catalog Requisitions) q Lists Orders in Ordered, Ordering, and Received status Page - 20

Agenda q Welcome / Introduction q Review: Year End Processes Ø Certified Forward Ø Payables Ø Reducing/Releasing Encumbrances Ø Disbursement Transaction Override Ø Available Reports and Job Aids q 1% Fee Exemption Process [ Eric Swanson] q Training Update q Punchout Catalogs q Vendor Updates q SPURS Sunset q Wrap-Up! Page - 21

Transaction Fee Exemptions The 1% Transaction Fee applies to all transactions that are not specifically exempted in Rule 60 A-1. 032 of the FAC. The table below explains the three levels that a vendor or specific purchase can be exempt from the 1% Transaction Fee: Level Description Vendor If a vendor is a non-profit or government entity, they are generally exempt from the Transaction Fee. If the vendor is not required to register in My. Florida. Market. Place or is reluctant to register, the vendor may be exempt from the Transaction Fee. The reluctant vendor registration can only be processed if the reason meets specifications outlined in Rule 60 A-1. 030 of the FAC Contract An exemption that applies to all transactions (purchase orders or disbursements) conducted with a vendor for a specific contract within an agency. An agency must flag a contract as exempt from the 1% transaction fee by completing the Contract Exemption electronic form Transaction Allows agencies to indicate that all or a portion of the transaction is exempt from the Transaction Fee. When a transaction is exempt, the agency must check the Fee Eligible checkbox of the requisition/invoice and select the appropriate reason code Page - 22

Transaction Fee Exemption Review q We are beginning a new process to review the transaction fee exemptions q DMS reviews a monthly report that details all transaction fee exemptions at the transaction level by all agencies, including Ø Vendors registered with the incorrect business designation Ø Approved transactions that do not follow F. A. C. 60 A-1. 032 q The exemptions highlighted compare the vendor to the specific exemption q Our goal is to assist the agencies in selecting the most appropriate exemption Page - 23

Agenda q Welcome / Introduction q Review: Year End Processes Ø Certified Forward Ø Payables Ø Reducing/Releasing Encumbrances Ø Disbursement Transaction Override Ø Available Reports and Job Aids q 1% Fee Exemption Process q Training Update [Kasey Bickley] q Punchout Catalogs q Vendor Updates q SPURS Sunset q Wrap-Up! Page - 24

Training Update q To date in FY 08/09, MFMP trained 551 customers with an average evaluation score of 4. 7 (on a scale from 1 to 5) q Training attendance has been increasing Ø Outlook invitations are now sent as confirmations Ø Reminder emails are also sent the day prior to the training q To receive a certificate for any course, you must attend over half of the training q February 16 th-19 th we held Train the Trainer training: Ø All aspects of the system were covered (Requesting, Invoicing, etc. ), as well as advanced topics including CR 36, FLAIR Integration, etc. Ø We plan to offer at least two Train the Trainer trainings next FY Page - 25

Training Update q We have scheduled our trainings for April and May: Ø In April we will be offering only New Requester and Invoicing Training Ø In May, we will be offering New Requester, Invoicing, Analysis, and Secure Reports q We will not be conducting trainings in June and July in order for customers to focus on Year End q If 2 -3 business days prior to the training we have less than 5 registered customers, we will cancel and reschedule the session Page - 26

Training Updates: Survey Action Items q Completed Training Survey Action Items include: Ø Ø Ø Updated Buyer FAQs Eliminated DMS printing for individual training sessions Created and distributed hot topics, specifically: - On. Demand Training tool - Sandbox information - Buyer toolkit information Added a page onto the Buyer Toolkit for “Working with Vendors” to tailor vendor information from a buyer perspective Created and posted the following job aids: - How to Create a Non-Catalog Requisition - Vendor Registration - Receiving Made Simple Page - 27

Agenda q Welcome / Introduction q Review: Year End Processes Ø Certified Forward Ø Payables Ø Reducing/Releasing Encumbrances Ø Disbursement Transaction Override Ø Available Reports and Job Aids q 1% Fee Exemption Process q Training Update q Punchout Catalogs [Kasey Bickley] q Vendor Updates q SPURS Sunset q Wrap-Up! Page - 28

Punchout Catalogs q The following Punchout Catalogs are available in MFMP: Ø Office Depot Ø Grainger (both hand tools and WSCA) Ø Fisher Scientific Ø Dell – PCs, laptops and monitors Ø Dell – Network Infrastructure Ø HP Ø Lenovo Ø VF Imagewear q Take advantage of e. Invoicing with these vendors - complete your purchase through their Punchout catalog Page - 29

Agenda q Welcome / Introduction q Review: Year End Processes Ø Certified Forward Ø Payables Ø Reducing/Releasing Encumbrances Ø Disbursement Transaction Override Ø Available Reports and Job Aids q 1% Fee Exemption Process q Training Update q Punchout Catalogs q Vendor Updates [Eric Swanson] q SPURS Sunset q Wrap-Up! Page - 30

Vendor Updates e. Invoicing q BT Conferencing and Compellent are now e. Invoicing in MFMP q We will continue to communicate with the buyer community as new vendors begin to e. Invoice q We are working with several other large vendors to begin e. Invoicing q A list of current e. Invoicing vendors is available off of the buyer toolkit, http: //dms. myflorida. com/buyertoolkit Page - 31

Vendors Currently e. Invoicing with MFMP Office Depot VF Imagewear, Inc. Grainger Industrial Supply, Inc. Information Builders, Inc. Compellent, Inc. BT Conferencing, Inc. Colamco, Inc. Law Enforcement Targets, Inc. Alston & Bird, LLP Lewis Digital, Inc. BMC Software Distribution, Inc. Thermal Tech, Inc. Hayes e. Government Resources, Inc. Marpan Supply Co. , Inc. Stanbio Laboratory MSC Industrial Supply The Canopy of Technology, Inc. The Classic Printing Company Gulf Ice Systems, Inc. Computer Tutors USA Sysco Food Services of South Florida KC Integrated Systems, Inc. Stew Leonard III Children’s Charities Dell Marketing L. P. Bay Systems, Inc. Paterson Pope, Inc. TYBRIN Corp. Extensys, Inc. Leitz & Reed Office Products, Inc. Page - 32

Agenda q Welcome / Introduction q Review: Year End Processes Ø Certified Forward Ø Payables Ø Reducing/Releasing Encumbrances Ø Disbursement Transaction Override Ø Available Reports and Job Aids q 1% Fee Exemption Process q Training Update q Punchout Catalogs q Vendor Updates q SPURS Sunset [Walt Bikowitz] q Wrap-Up! Page - 33

SPURS Sunset q We’ve come a long way with sunsetting SPURS Ø Agencies are not purchasing through SPURS Ø All agency permissions in SPURS are now removed except for PCard vendor adds Ø SPURS access reduced from 2237 to 293 q There is no funding for SPURS after July 1, 2009 q When SPURS is shutdown SPURS data will no longer be available Ø DMS DIVTEL (CITS) can create an Access database for each agency (offers searching capability) q Communication distributed and is posted on the buyer bulletin board at http: //dms. myflorida. com/mfmp Page - 34

SPURS Sunset: Vendor Add Application q We have been working very hard with the Department of Financial Services over the last few months to develop the new Vendor Add Application in FLAIR q Designs are complete and development work underway Page - 35

SPURS Sunset: Vendor Add Application q DMS/DFS MOU: Ø MOU addresses commitment between DMS and DFS to build the Vendor Add application Ø The new vendor-add application will contain edits/enhancements needed by DFS to meet Internal Revenue Service requirements and prepare for the 3% withholding law (Note: Federal stimulus delayed but did not remove requirements) Ø Employee Interchange Agreement – staff being hired Page - 36

SPURS Sunset q Phase I: Ø Ø Ø Development of a batch interface between MFMP and FLAIR for the addition and update of MFMP registered vendors to the FLAIR vendor file Development of a FLAIR online application for vendor maintenance Allows agencies to add vendors which will be used only in the FLAIR Purchasing Card subsystem Allows DFS / Accounting and Auditing (A&A) to add and maintain vendors which may be used in any agency transaction Development of an annual process for DFS to provide MFMP with information to inactivate “B” notice vendors (Note: first annual “B” Notice process successfully completed in December 2008) Page - 37

SPURS Sunset q Phase II: Ø MFMP will develop an online W-9 form within the MFMP Vendor Registration System Ø MFMP intends to enhance the batch interface between MFMP and FLAIR to transmit the W-9 data Ø DFS intends to enhance the batch interface between MFMP and FLAIR to set MFMP Vendors to a “pending” status until a W-9 has been received and validated by DFS/ A&A Ø DFS intends to alter FLAIR to prevent all non-MFMP Vendor payments from processing if the Statewide Vendor record is in a “pending” status q Phase III: Ø Enhancement to the MFMP Vendor Registration System to standardize and validate address formats Ø Enhancement to the FLAIR Vendor application (online and batch interface) to standardize and validate address formats Page - 38

SPURS Sunset Related Change Requests: CR 47 & CR 51 q CR 47 - Line Item Description Currently, MFMP extracts purchase order data nightly for importing into SPURSView. However, MFMP does not send the PO line item description information with the PO data. With CR 47, MFMP will send line item description to DMS, displaying the data with the DO information within SPURSView. Ø Implemented because SPURS data will no longer be available Ø Prospectively going forward Page - 39

SPURS Sunset Related Change Requests: q CR 51 - Inactivation Reason Code During SPURS sunset discussions, DFS requested that MFMP add an inactivation reason code in the Vendor Registration System to indicate the reason a vendor's registration (or location) is inactivated. This inactivation reason code will be passed to FLAIR in the nightly MFMP to FLAIR vendor interface for updates on the statewide vendor file. Ø DFS provided a list of inactivation reasons, including: (1) DFS request – no IRS match; (2) vendor request, no reason; (3) vendor request – duplicate registration; and (4) DMS request – vendor went out of business. Page - 40

Agenda q Welcome / Introduction q Review: Year End Processes Ø Certified Forward Ø Payables Ø Reducing/Releasing Encumbrances Ø Disbursement Transaction Override Ø Available Reports and Job Aids q 1% Fee Exemption Process q Training Update q Punchout Catalogs q Vendor Updates q SPURS Sunset q Wrap-Up! Page - 41

Wrap - Up q Questions / Comments Page - 42