JDE Consignment Introduction and Demo February 21, 2012

1. JDE Consignment Introduction and Demo February 21, 2012

2. JDE Consignment Introduction and Demo February 21, 2012 • Scope Definition • Functionality Highlights • Demonstration • Next Steps

3. JDE Consignment Introduction and Demo February 21, 2012 • Scope Review • Replace the current “Magic” spreadsheet solution • Create billing, replenishment, sample, return, and new product orders from within the JDE application for consignment customers and trunk employees • Allow for real-time access to consignment inventory levels and immediate order creation • Introduce immediate validation on Customers, Ship-To’s, PO Numbers, Product Numbers and [ER] equivalents, Quantities, and Expiration Dates • Allow quick access to Customers, Lots, Products, and recently created orders • Ability to support the unique requirements for the US and EU consignment and trunk processing

4. JDE Consignment Introduction and Demo February 21, 2012 • Functionality Highlights • Default Branch based on your user ID and menu • Consignment Customer, Location, Lot, and Product Search • Product search will accept “ER” or non-”ER” versions • Integration to the JDE Name Search program • Default Branch and Search Type options (C or E) • Ability to display Available inventory or Committed inventory • Simple Item selection and de-selection for processing • Similar screen for order processing • One time entry of Ship-To, PO Number, and Print Messages • Simple entry of quantities to Bill, Replenish/Return, or Sample • Ability to Add new products into Consignment • Automated product substitutions (“ER” vsnon-”ER”)

5. JDE Consignment Introduction and Demo February 21, 2012 • Functionality Highlights (Cont…) • Ability to bill or sample a Trunk transaction and replenish the Trunk employee simultaneously • Ability to select Returns branch • Instant quantity totaling • Instant Error checking and validations (see next slide) • Invoice Total display • Direct access to orders and PO’s • Consistency between direct and consignment orders • Future integration to the Schedule A

6. JDE Consignment Introduction and Demo February 21, 2012 • Functionality Highlights (Cont…) • Error Codes: • 5500 – Consignment locations differ • 5501 – Consignment code not setup for customer • 5503 – Replenishment order is on hold • 5504 – General Consignment Error • 5505 – No Quantities entered • 5506 – Sample > Avail – Billed + Replenishment • 5507 – No Samples for Consignment customers • 5508 – Lot on hold • 5509 – Product is Use-Up • 5510 – Warning, locations differ for trunk ship-to • 5511 – Locations differ • 5512 – Consignment replenishment substitute found • 5513 – Substitute Item is Use-Up • 5514 – Substitute Item is Obsolete • 5515 – Product has less than 6 month shelf life remaining • 5516 – No Replenishment allowed for Trunk • 5517 – Replenishment Qty <> BillQty

7. JDE Consignment Introduction and Demo February 21, 2012 • Functionality Highlights (Cont…) • Error Codes: • 5518 – Bad expiration date in lot master • 5519 – Lot Master does not exist • 5520 – Committed Qty Displaying – (Can’t add lines) • 5521 – Nothing to Remove • 5522 – Returns must be processed independently • 5523 – Ship-To Customer does not have a consignment location setup in the Who’s Who. • 5524 – Billing order to trunk ship-to invalid • 5525 – A duplicate EDI order exists • 5526 – Returns not allowed. • 5527 – Warning: Sample for Consignment Customer • 5528 – Enter a valid Returns Branch • 5529 – Item not found on Attachment A • 5530 – Quantity to Add > Quantity on Attachment A • 5531 – Invalid Return Branch

8. JDE Consignment Introduction and Demo February 21, 2012 • Demonstration • Search for Consignment Customer or Trunk Employee • Search for Product • Select and De-select Products • Create Consignment Billing and Replenishment Order • View Orders • Create Trunk Sample Order • Create Consignment Return Order • Add products to Consignment Customer

9. JDE Consignment Introduction and Demo February 21, 2012 • Next Steps • User Acceptance Testing Now – Feb 29 • Complete Enhancements Feb 27 • Go-Live March 1 • Other • Existing Order Conversions Feb 29 • Multi-Branch allocations Costa Rica