Increasing the Business Value from your Line 500 System

1. Increasing the Business Value from your Line 500 System Sage User Network - Birmingham 11June 2009 Mike O’Riley; Anya Wagenaar

2. Sage Professional Services - who we are

3. Sage Professional Services - who we are Professional Services Group Manager – Mike O’Riley CRM & SLX S200 Construct Retail Complex Projects S1000 L500 BI UK and international focus 25 strong Staff in continental Europe and across the UK Over 200 years combined experience with Sage products and Services

4. Sage Professional Services – what we do • Reduce time to value and help you get the best from your Sage investment • Keep a long term relationship with you in whatever form you want • Jobs range from 1 day to multiple 100’s • Full System implementations, upgrades, migrations, enhancements, specific training, usage advice • Sage core product and customisation/personalisations, integrations to your in house systems, Sage added value modules, integration of selected 3rd party components • Use our Accelerator project methodology

5. Quick run through of 4 examples where customers have applied simple to complex changes to their L500 system to gain business advantage Highlight some other potential areas of benefit Please ask questions though time is tight, we can carry on discussion in the breaks Over to Anya…………… Tried and tested solutions - practical examples

6. Document Scanning Customer: VisitScotland - Edinburgh Profile: Scottish Tourist Board, offices and website Issue: Lack of accessibility to purchase invoices for sign off in decentralised purchasing department

7. Document Scanning The solution: • Central scanning and storage of documents for use by several hundred staff in head office and satellite offices • Actual invoice rather than posted item available for viewing/approval by invoice authorisers / budget holders • Phase 2 posting by authoriser / budget holder • Storage of documents in .pdf format • Functionality makes use of standard Line 500 TCR installation

8. Document Scanning

9. Document Scanning Development effort 2.5 weeks, comprising development, test, installation and training What did VisitScotland say? “We’re very happy with the solution that was delivered to us – it does exactly what it says on the tin” Derrick Thomson – Project Manager

10. Sales Order Pricelist Update Customer: Tosoh Bioscience N.V. - Belgium Profile: Multi-national developing reagents, instrumentation and software for the molecular biology industry Issue: Due to the nature of the industry, price fluctuations occur regularly, resulting in many pricelist and promotional price updates which were taking a lot of time using the standard pricelist maintenance program

11. Sales Order Pricelist Update The solution: • Significantly less keystrokes: no F8 Add or multi-select boxes • Enhanced stock information in product browse • Option to update price per product or product group • Retain product – customer relationship • Facilitate simpler promotional price entry • Automated updates to sales orders awaiting production

12. Sales Order Price List Update

13. Sales Order Pricelist Update Development effort 3 days, comprising development, test, installation and training What did Tosoh say? “We use this application every day, it makes life a lot easier!” Frank van Opstal – IT Manager Tosoh Bioscience

14. Purchase Order Receipts Automation Customer: R&D Systems Europe Ltd. - Abingdon Profile: European representative of R&D’s Biotech Division, distributor of biotechnology products Issue: Purchase order receipts are delivered to R&D on an Excel spreadsheet, hundreds of lines long, all of which were manually entered in Line 500 – a daily, arduous job.

15. Purchase Order Receipts Automation The solution: • Spreadsheet upload facility • Validation on product / customer / order line quantity • Provides feedback on missing items / discrepancies via report • Receives the correct order lines • Updates order with additional information such as lot numbers, datasheet information, and expiry dates (added to batch queue)

16. Purchase Order Receipts Automation

17. Purchase Order Receipts Automation Development effort 3 weeks, comprising development, test, installation and training What did R&D Systems say? “The automation saves us on average 18 hours each week !” Carole Donne – IT Manager

18. Formula Entry Customer: RPC Cobelplast N.V. – Belgium Profile: Part of the RPC Group; RPC Cobelplast is the world leader in co extrusion of multilayer sheet used for form–fill–seal applications Issue: RPC Group roll-out of Sage Line 500 would not have been possible without a facility to administrate product formulae and pricing structures based on Bill of Material / Route information.

19. Formula Entry The solution: • Product version controlled formula administration system • Automatic generation of Line 500 Bills of Material / Alternative BOM’s • Automatic generation of Line 500 Routes / Alternative Routes • Facility to calculate sales price for custom made products • Facility to produce formulae based on more than one bridge (link between machine and formula)

20. Example: Formula Entry

21. Formula Entry Development effort 6 weeks, comprising development, test, installation and training What did RPC say? “Our price calculation process would be incredibly complex and very time consuming without it, so we use it every day ” Philippe Mees – Project Manager

22. System Control Used by: SAGE Professional Services & Support To alleviate: Repetative implementation tasks, and provide enhanced system administration and setup checking facility

23. System Control The Solution: • Enhanced user activity functionality • System key compare facility • Cross server project copy & compare facility • Print to file facility to freeze & report on status • Simplified report copy functionality – across different servers • Database trigger & view control • Database sizing information

24. System Control

25. .. AND A FEW MORE EXAMPLES Purchase orders: • Purchase Order Price Control • POP Invoice Enquiry from Purchase Ledger Production & Manufacturing: • Works Order Archiving • Product Label Printing Sales Management: • QAS Integration Treasury and Cash: • Bank Statement File Format Conversion Tool

26. UK VAT Reporting functionality VAT reports per VAT Box in line with HMRC guidelines Flexible configuration to allow use of current VAT setup Compliant with European Tax project Available on all currently supported platform/database combinations Current delivery scheduled for this summer!

27. THANK YOU Hopefully this has stimulated your thinking Please catch up with us during the event Pack contains The slides Some useful information Some goodies A feedback form please complete before you leave, and return to us And finally if you’ve got any business issue or problem and would like to discuss further please contact us

28. Contacts Mike O’Riley mike.oriley@sage.com +44 (0) 7717 224 609 Anya Wagenaar anya.wagenaar@sage.com +44 (0) 7841 496 016 Arie Koppenhol arie.koppenhol@sage.com +31 653 878 724 Or mail: psgservices@sage.com

29. Was your interest peaked? Please provide contact details if you would like us to call you to discuss your requirement: Name: ………………………………………………… Company: ………………………………………………… Mail & tel.no: ………………………………………………… Interested in: SOP pricelist update System Control Auto POP receipts VAT reporting POP price control Scanning POP invoice enquiry Formula Entry WOP Archiving Label printing Cashbook file format tool QAS integration Other, pls specify ……………………………………………………

30. Increasing the Business Value from your Line 500 System Sage User Network - Birmingham 11June 2009 Mike O’Riley; Anya Wagenaar