My Florida Market Place User Meeting April 12

My. Florida. Market. Place User Meeting April 12, 2005

Agenda q Welcome / Introduction q Action Plan Update from 3/08 User Meeting q Aspire Update q Status of SPURS Sunset q Certified Forward Discussion / End of Year Processing q Invoice Administrator Queue Discussion q Follow Up Discussion on Payment Against Master Agreements q Change Request Discussion q Next Meeting Time / Location 2

Agenda q Welcome / Introduction q Action Plan Update from 3/08 User Meeting q Aspire Update q Status of SPURS Sunset q Certified Forward Discussion / End of Year Processing q Invoice Administrator Queue Discussion q Follow Up Discussion on Payment Against Master Agreements q Change Request Discussion q Next Meeting Time / Location 3

Agenda q Welcome / Introduction q Action Plan Update from 3/08 User Meeting q Aspire Update q Status of SPURS Sunset q Certified Forward Discussion / End of Year Processing q Invoice Administrator Queue Discussion q Follow Up Discussion on Payment Against Master Agreements q Change Request Discussion q Next Meeting Time / Location 4

Aspire Update q Wave 1 Update: Ø Timeframe for Initial Agencies Ø Update on Replanning Effort q Blackout Period Update: Ø The team is in the process of finalizing activities that will happen during an agency’s “blackout” period prior to Aspire transition. Ø Details of the “blackout” period will be reviewed closer to the Wave 1 timeframe. q Encumbrance guidance prior to transition to Aspire: Ø Agencies are strongly encouraged to not process “unencumbered” transactions prior to transition to Aspire. Ø This will help to minimize agency workload impact during the transition to Aspire. 5

Aspire Update (cont. ) Entering Master Agreements Prior to Aspire Transition: Ø Option 1: Enter Master Agreement as ‘Unencumbered’: Agencies will then need to encumber using Aspire Accounting on the purchase order(s) or will issue an invoice(s) associated with that Master Agreement. If the Master Agreement is set up as ‘No Release Required, ” then it will be a requirement to encumber the Master Agreement. Ø Option 2: Enter Master Agreement as ‘Encumbered’: Upon transition to Aspire, agencies will need to update the Master Agreement with new Aspire Accounting information. Purchase Orders and/or Invoices generated from that Master Agreement will then include the Aspire Accounting Information going forward. 6

Agenda q Welcome / Introduction q Action Plan Update from 3/08 User Meeting q Aspire Update q Status of SPURS Sunset q Certified Forward Discussion / End of Year Processing q Invoice Administrator Queue Discussion q Follow Up Discussion on Payment Against Master Agreements q Change Request Discussion q Next Meeting Time / Location 7

Status of SPURS Sunset q Agencies are continuing to transition from the PO creation function in SPURS q 12 additional agencies will be transitioned from SPURS PO Creation during the month of May q PO and Requisition Functions are turned off for all agencies as of Friday, 7/29/05 q Blanket Purchase Orders for FY 2005 – 2006 should be created and maintained in My. Florida. Market. Place q Agencies will continue to have the ability to add P-card vendors and “non traditional” vendors to the statewide vendor file via SPURS 8

SPURS Sunset Update 1/10/05: Formal Memo to Agency Liaisons 11/2004: DMS & STO transitioned off SPURS PO Creation Nov ’ 04 1/14/05: DJJ, DOT, DVA, and Citrus transitioned off SPURS PO Creation Jan ‘ 05 Mar ‘ 05 During 3/05: Additional agencies transition off SPURS PO Creation May ‘ 05 During 5/05: All scheduled agencies transition off SPURS PO Creation Jul ‘ 05 As of 7/29/05: All SPURS PO functions shutoff Sep ‘ 05 Nov ‘ 05 Between now and 7/29: Agencies need to enter all multi-year purchase orders and/or contracts into My. Florida. Market. Place, and make sure that any open purchase orders that can be closed have been closed * * Exception is Wave 1 agencies for Aspire. There will be separate communications from the Aspire team regarding dates by which SPURS and My. Florida. Market. Place activity must be closed out. 9

SPURS Sunset: May Agency Transitions Agency SPURS Cutoff Date (Transition from PO Creation) Department of Education 5/2/05 Fish and Wildlife Conservation Commission 5/2/05 Department of Military Affairs 5/2/05 Department of Elder Affairs 5/2/05 Department of Revenue 5/2/05 Department of Community Affairs 5/16/05 Department of Corrections / Parole Commission 5/16/05 Public Service Commission 5/16/05 Department of Financial Services 5/16/05 Dept of Agriculture 5/16/05 Attorney General and Legal Affairs 5/16/05 Department of Environmental Protection 5/16/05 10

SPURS Sunset: Functionality Transition SPURS Function Transition Timeframe * q Purchase Order Creation q Agencies are being transitioned off of PO creation in a phased approach, with all agencies being transitioned by 5/16/05. q Purchase Order and Requisition Functionality q End date for this function is currently set for 7/29/05. q The exception is Wave 1 Aspire agencies. There will be separate communications from the Aspire team regarding dates by which SPURS and My. Florida. Market. Place activity must be closed out. q Purchase Order History q Transaction History will be available in SPURS and / or SPURSView. q Statewide Vendor File Updates q End date for this function is currently scheduled to be June 30, 2006. * As dates / timeframes change, these will be communicated to agencies 11

SPURS Sunset: Agency Activities q q Open Orders (including multi-year purchase orders): Ø Guidance: All purchase orders, including blanket purchase orders and multi-year purchase orders will be maintained in My. Florida. Market. Place going forward. For those orders that are currently open in SPURS, agencies should force receive/close by 7/29/05. Any purchase orders that will not be fully received and closed prior to 7/29/05 should be entered into My. Florida. Market. Place. Ø Agency Activity: Each agency should review and develop a “close out plan” for open orders. Identify any open orders that need to stay open past the end of the fiscal year and begin keying them into My. Florida. Market. Place. Wave 1 Aspire agencies should coordinate with their Aspire team contacts to confirm timeframe available for reviewing open orders. Blanket Purchase Orders: Ø Guidance: Blanket Purchase Orders for the current fiscal year that exist in SPURS can remain in SPURS (as the PO edit functionality will continue to exist until July 29 th for non Wave 1 Aspire agencies). New Blanket Purchase Orders that are being created for FY 2005 – 2006 will be entered in My. Florida. Market. Place. Ø Agency Activity: All Blanket Purchase Orders for the upcoming fiscal year should be created in My. Florida. Market. Place 12

Agenda q Welcome / Introduction q Action Plan Update from 3/08 User Meeting q Aspire Update q Status of SPURS Sunset q Certified Forward Discussion / End of Year Processing q Invoice Administrator Queue Discussion q Follow Up Discussion on Payment Against Master Agreements q Change Request Discussion q Next Meeting Time / Location 13

Certified Forwards / Year End Processing q As we approach the end of the fiscal year, agencies may have questions about common tasks such as: Ø Certified Forwards Ø Releasing Encumbrances Ø Disbursement Transaction Overrides q The following slides provide screen shots of some common processing that you may be doing at this time of year. q This information will also be posted as a job aid on the My. Florida. Market. Place Toolkit. q Please contact the Customer Service Desk at 1 -866 -352 -3776 or at Buyer. Help@myfloridamarketplace. com if you have specific questions or concerns about a process you are trying to complete. 14

Certified Forwards q Previously within FLAIR, agencies have had the option of either Ø Marking their encumbrances and payables with a ‘C’ in the CF (certified forward) field manually through FLAIR. Ø Or requesting that DFS mark the encumbrances and payables with a ‘C’ in the CF field on behalf of the agency on June 30 th. q With the implementation of My. Florida. Market. Place, agencies will have the option of either Ø Marking the encumbrances with a ‘C’ in the CF (certified forward) field through My. Florida. Market. Place. Ø Or requesting that DFS mark the encumbrances with a ‘C’ in the CF field. The encumbrances will also automatically be updated in My. Florida. Market. Place via a one-time batch process so that the accounting is reflected correctly in both systems. Date for this batch process is TBD- but is anticipated to be early-mid July. 15

Certified Forwards q If an agency elects to mark the encumbrances through My. Florida. Market. Place, the following steps should be followed 1. Initiate a change order to the appropriate Purchase Order. Users assigned the role of ‘CO No Workflow’ may complete a change order for accounting/encumbrance changes only without regenerating the workflow. 2. Update the accounting/encumbrance as appropriate and include a ‘C’ in the CF field. 3. Submit the change order – a subsequent PO version will be created. 4. A change encumbrance transaction (6 SU) will be sent to FLAIR to update the encumbrance record. q Similar to encumbered POs, encumbrances against Master Agreements may be updated through initiating a change against the Master Agreement Request or may be updated automatically if requested by DFS. 16

17

18

19

Payables q During the year-end process, the agency may also establish payables for those items that have been received but not yet invoiced q The establishment of a payable (TR 80/TR 81) against a My. Florida. Market. Place transaction will be completed directly in FLAIR Ø A modification has been completed in FLAIR to support the release of an ‘A’ encumbrance type for an encumbered payable (TR 81) q When appropriate, a payable disbursement (TR 53) will be completed in My. Florida. Market. Place for a My. Florida. Market. Place transaction 20

Payables q The following defines the steps which establish a payable and complete a payable disbursement for a My. Florida. Market. Place transaction 1. Identify the transaction in which a payable is to be established and document the encumbrance number and line numbers if an encumbered transaction 2. Establish the payable in FLAIR (TR 80/TR 81) referencing the encumbrance number and line numbers as appropriate. You may also release the encumbrance using the Release Encumbrance e. Form in lieu of a TR 81 3. During the disbursement process, the Exception Handler or Invoice Manager may select the ‘Payable’ checkbox on the Invoice Reconciliation to indicate that the disbursement is a payable disbursement 4. Two fields will be displayed to enter the payable number and payable line number (It is not necessary to include the prefix in the payable number field) 5. The ‘Payable’ checkbox is at the split accounting level and must be updated for each split accounting line 6. Final payment indicator is available for payable disbursements on the split accounting line 7. The accounting distribution may also be updated for each split accounting line at the time of disbursement. 21

22

Check the ‘Payable Disbursement’ checkbox to indicate that this transaction should be a payable disbursement. 23

Two additional fields ‘Payable Number’ and ‘Payable Line Number’ will be displayed. Enter in the payable number and payable line number and select that appropriate accounting distribution. When entering the payable number, it is not necessary to include the prefix in the number. For example, enter '897654' not 'P 897654 24

Release Encumbrance q The e. Form is available to all users with the following role: PUI: Invoice Manager q The release encumbrance e. Form may be used for requisitions/POs in the following statuses: Ø Ordered Ø Receiving Ø Cancelled q User must select the requisition in which to release the encumbrance q All encumbrance numbers and line numbers will be released for the selected requisition q No approvals are required for the Release Encumbrance e. Form 25

The Release Encumbrance e. Form may be found under the ‘Company e. Form’ link from the Home page. Clicking on the additional choices link ‘+’ will display all encumbered requisitions. 26

27

Upon submission of the Release Encumbrance e. Form, a delete encumbrance transaction (6 SUD) will be sent to FLAIR. 28

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 Users assigned the role of ‘Invoice Reconciliation Overwrite’ will have the ability to overwrite the disbursement type q The ‘Encumber Funds’ checkbox is at the split accounting level and must be updated for each split accounting line 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 29

Encumbered Disbursement Encumbrance number and line number defaulted from PO 30

Unchecking the ‘Encumber Funds’ checkbox will change the disbursement type to an unencumbered disbursement (TR 51) 31

Unencumbered Disbursement No encumbrance number and line number listed PO 32

By checking the ‘Encumber Funds’ checkbox, two additional fields will be displayed. F&A may enter the appropriate encumbrance number and line number to initiate a TR 70 33

Agenda q Welcome / Introduction q Action Plan Update from 3/08 User Meeting q Aspire Update q Status of SPURS Sunset q Certified Forward Discussion / End of Year Processing q Invoice Administrator Queue Discussion q Follow Up Discussion on Payment Against Master Agreements q Change Request Discussion q Next Meeting Time / Location 34

Invoice Administrator Queue Discussion q My. Florida. Market. Place has systematic roles that are used as a “catch all” queue in the case that the system is unable to appropriately identify the agency-specific approval flow (based upon missing information on the approvable). q The Invoice Administrator role is a “catch all” systematic role to which invalid invoices are routed when the PUI Invoice Manager is not able to be identified on the generated IR to generate the approval flow. q When a user generates an invoice, the supplier, order information (order number, line items, price, quantity, total amount, etc. ), accounting details, PUI and site code are all pulled from the direct order (DO) to be applied to the generated invoice reconciliation (IR); based on this information, the system will automatically generate the IR approval flow. q However if the invoice is NOT tied to a DO/MA, the system cannot identify the appropriate agency Exception Handler and Invoice Manager to route the invoice to; therefore, the invoice is deemed invalid - no agency approval flow is generated and the IR gets routed to the Invoice Administrator queue. q The project team is currently reaching out to agencies who have IRs routed to the Invoice Administrator queue based on the user tied to the Invoice e. Form. If invoice is received via ASN, the team may not have the necessary agency information, and so the team is reaching out to the vendor. 35

Invoice Administrator Queue Discussion q To prevent your agency from appearing on this report, the following should be followed for Invoice e. Forms: 1. When users are creating invoice eforms, they must search for and select the appropriate purchase order or master agreement for the paper invoice sent by the supplier. 2. Once the correct PO or MA is selected, the user must click the "Generate Invoice" button to display the line items contained on the matched document. Once these lines are displayed, the user will need to make sure the information from the invoice received matched the line item information displayed. If needed, the user can edit the description, quantity and price indicated for each line item. 3. Once the line items displayed on the eform match the actual invoice received, the user will need to continue to the Summary screen to attach the scanned image of the invoice received to the invoice eform. 4. After the invoice is attached, the user can then submit the invoice eform. Once submitted, the system will generate an invoice reconciliation request which will be routed to the appropriate user within the agency's PUI. 5. Completing these actions for an invoice eform will prevent the system from routing the resulting IR to the Invoice Administrator "catch-all" queue. 36

Invoice Administrator Queue Discussion q Copying an Invoice e. Form: When copying an invoice eform, the system will display the selected PO or MA which was linked to the original eform. However, it is necessary to click the 'Generate Invoice' button to re-establish the link to the selected PO or MA. If this button is not clicked and the eform is submitted, when the IR is generated it will not be linked to the request. The system will route the IR to the Invoice Administrator queue. q To prevent your agency from appearing on the report, the following should be followed for ASN invoices (i. e. Office Depot, Grainger, etc. ): If a change order is completed for an ASN supplier, the user MUST NOT select the option 'Do Not Send Purchase Order to Vendor'. When this option is selected the changed version of the purchase order is generated but it does NOT transmit to the supplier. If a supplier completes a PO Flip for the original version of the purchase order, when the system attempts to match the purchase order from the ASN invoice to a purchase order in Ariba and its not found, the system will route the invoice reconciliation to the Invoice Administrator queue. If a supplier has selected a preferred ordering method of 'Electronic Ordering', the option to not send the PO to the vendor should not be selected. 37

Agenda q Welcome / Introduction q Action Plan Update from 3/08 User Meeting q Aspire Update q Status of SPURS Sunset q Certified Forward Discussion / End of Year Processing q Invoice Administrator Queue Discussion q Follow Up Discussion on Payment Against Master Agreements q Change Request Discussion q Next Meeting Time / Location 38

Master Agreement Overview Types of Master Agreements Supplier Level Commodity Level Item Level Supplier Level is the broadest option and it allows orders to a specific supplier. Pricing terms defined in the agreement apply to all of the supplier's goods and/or services they offer to the State. May have percentage discounts or tiered pricing terms. Commodity Level allows orders of any commodities specified from a given supplier. Pricing terms defined in the agreement apply to specific commodity codes selected in the agreement. May have percentage discounts or tiered pricing terms. Multiple commodity codes may be within the same agreement and each commodity code within the agreement may have its own pricing terms. Item Level allows orders of only specific items from a specific supplier. Pricing terms defined in the agreement apply to specific items selected in the agreement. May have percentage discount, tiered, or fixed pricing terms. Multiple items may be within the same agreement and each item within the 39 agreement may have its own pricing terms.

Master Agreements: Comparison of ‘Release Required’ and ‘No Release Required’ Options Scenario Purchasing Involvement* F&A Involvement* n Create an Encumbered Master Agreement with Release Required n Set up Master Agreement Request and submit for approval n Manually encumber Master Agreement amount in FLAIR n Indicate ‘Release Required’ n Confirm Accounting Information with F&A and enter encumbrance number on Master Agreement n Enter / Review invoices tied to the purchase orders from this Master Agreement n Issue Purchase Orders for each purchase associated with the Master Agreement (Accounting Information will be automatically populated) n Create an Encumbered Master Agreement ‘No Release Required n Set up Master Agreement Request and submit for approval n Indicate ‘No Release Required’ n Confirm Accounting Information with F&A and enter encumbrance number on Master Agreement * These are suggested tasks. Task responsibility may vary by agency. n Manually encumber Master Agreement amount in FLAIR n Enter / Review invoices tied to this Master Agreement 40

Master Agreements: Comparison of ‘Release Required’ and ‘No Release Required’ Options Scenario Purchasing Involvement* F&A Involvement* n Create an Unencumbered Master Agreement with Release Required n Set up Master Agreement Request and submit for approval n Enter / Review invoices tied to the purchase orders from this Master Agreement n Indicate ‘Release Required’ n Issue Purchase Orders for each purchase associated with the Master Agreement n Accounting Information will need to be entered for each purchase order issued (not automatically populated) n Create an Unencumbered Master Agreement ‘No Release Required n Set up Master Agreement Request and submit for approval n Indicate ‘No Release Required’ * These are suggested tasks. Task responsibility may vary by agency. n Enter / Review invoices tied to this Master Agreement n Accounting Information will need to be updated for each invoice entered (not automatically populated) 41

Agenda q Welcome / Introduction q Action Plan Update from 3/08 User Meeting q Aspire Update q Status of SPURS Sunset q Certified Forward Discussion / End of Year Processing q Invoice Administrator Queue Discussion q Follow Up Discussion on Payment Against Master Agreements q Change Request Discussion q Next Meeting Time / Location 42

Change Request Discussion Change Request Process q q q Agency collects Change Requests initiated from agency users Agency will maintain an internal q list of all enhancements (i. e. , Change Requests) that are escalated by agency users. q Agencies are asked to document Change Request information using the CR Form. q Agencies are asked to provide details of business impact for each Change Request documented. DMS conducts Quarterly Change Request Meeting Logistics will be distributed to the agency liaisons for each agency. During this meeting, agencies will discuss their “Top 3” Change Requests (per agency). Agency Users in attendance will confirm priority of each Change Requests are Scheduled for Release q q q Project Team will review Change Requests and provide an estimate of work hours associated with each request. Change Requests will then be scheduled (taking priority and work hours into consideration). Users will receive an update on target dates for Change Requests to be implemented. 43

Agenda q Welcome / Introduction q Action Plan Update from 3/08 User Meeting q Aspire Update q Status of SPURS Sunset q Certified Forward Discussion / End of Year Processing q Invoice Administrator Queue Discussion q Follow Up Discussion on Payment Against Master Agreements q Change Request Discussion q Next Meeting Time / Location 44

Next Meeting Time / Location q Tuesday, May 10, 2005 q Carr Building, Room 170 q 9 a. m. – 11 a. m. q Meetings will include a monthly update of SPURS Sunset activities and an Aspire Update 45