Open-Source ERP-Solutions Open-Source ERP-Solutions - a new way for - - PowerPoint PPT Presentation

▶
open source erp solutions
SMART_READER_LITE
LIVE PREVIEW

Open-Source ERP-Solutions Open-Source ERP-Solutions - a new way for - - PowerPoint PPT Presentation

Oct 29, 2022 517 likes •1.09k views

Open-Source ERP-Solutions Open-Source ERP-Solutions - a new way for SMEs M.Sc. Falk Neubert, University of Osnabrck 1 Open-Source ERP-Solutions 30.10.2009, Dresden M.Sc. Falk Neubert Scientific Assistant in the Department

slide-1
SLIDE 1

30.10.2009, Dresden Open-Source ERP-Solutions 1

Open-Source ERP-Solutions

Open-Source ERP-Solutions - a new way for SMEs

M.Sc. Falk Neubert, University of Osnabrück

slide-2
SLIDE 2

30.10.2009, Dresden, Falk Neubert, University Osnabrück Open-Source ERP-Solutions 2

M.Sc. Falk Neubert

Scientific Assistant in the Department BWL/Produktions-Management and Wirtschaftsinformatik / University of Osnabrück Member of the competence center RECO (Osnabrück)

slide-3
SLIDE 3

30.10.2009, Dresden, Falk Neubert, University Osnabrück Open-Source ERP-Solutions 3

Structure of the network

  • The network exists from
  • 28 regional

competence center

  • 1 center for trade
  • 6 extern partners
  • 7 special projects
slide-4
SLIDE 4

30.10.2009, Dresden, Falk Neubert, University Osnabrück Open-Source ERP-Solutions 4

Structure of the network

  • Individual consulting
  • Events and “Road shows”
  • Guidelines, instructions and studies as well as entry-level CD-ROM on

the target areas:

  • Information Security
  • RFID
  • ERP
  • E-Billing, E-Invoicing
  • Femme Digitale
  • Yearly NEG-Website-Award
slide-5
SLIDE 5

30.10.2009, Dresden, Falk Neubert, University Osnabrück Open-Source ERP-Solutions 5

  • Some topics for the issue „ERP“
  • Freie Software / Open-Source
  • Open-Source ERP-Solutions
  • Next steps at the project

„ERP-Lösungen auf Basis Freier Software“

Outline

slide-6
SLIDE 6

30.10.2009, Dresden, Falk Neubert, University Osnabrück Open-Source ERP-Solutions 6

  • Companies have to optimize your business processes
  • Companies need flexible IT-Infrastructure
  • ERP-Software need interfaces to customers and suppliers
  • Webbased components are needed
  • Business Intelligence will be important in the future

Quelle: Der IT-Markt in Deutschland, 2007-2012 – 2. Quartal 2008, IDC Studie Befragung im Rahmen der „ERP- Initiative 2008

Topic on ERP

slide-7
SLIDE 7

30.10.2009, Dresden, Falk Neubert, University Osnabrück Open-Source ERP-Solutions 7

E-mail 99% (1%)

  • E-Procurement

45% (9%)

  • CRM

41% (7%)

  • Finance applications

38% (2%)

  • ERP

37% (3%)

  • Online Shop B2B

36% (5%)

  • Mobile Applications

33% (8%)

  • Online Shop B2C

33% (4%)

Coverage of E-Business- Applications

slide-8
SLIDE 8

30.10.2009, Dresden, Falk Neubert, University Osnabrück Open-Source ERP-Solutions 8

Quelle: Trendstudie Opensource 2009

Reasons for the application from OSS

slide-9
SLIDE 9

30.10.2009, Dresden, Falk Neubert, University Osnabrück Open-Source ERP-Solutions 9

Quelle: Trendstudie Opensource 2009

Reasons for the application from OSS

slide-10
SLIDE 10

30.10.2009, Dresden, Falk Neubert, University Osnabrück Open-Source ERP-Solutions 10

Quelle: Trendstudie Opensource 2009

Witch applications are used?

slide-11
SLIDE 11

30.10.2009, Dresden, Falk Neubert, University Osnabrück Open-Source ERP-Solutions 11

Benötige Funktion ist nicht verfügbar Mangelnde Weiterentwicklung Mangelnde Flexibilität Unzufriedenheit mit dem Support Hersteller nicht mehr verfügbar Mangelnde Bedienerfreundlichkeit Zu hohe Kosten 5 10 15 20 25 30

26,21 25,1 15,35 14,56 9,71 4,85 3,88 Quelle: ERP Trend Report 2009

Reasons for changing of ERP?

slide-12
SLIDE 12

30.10.2009, Dresden, Falk Neubert, University Osnabrück Open-Source ERP-Solutions 12

Functionality

slide-13
SLIDE 13

30.10.2009, Dresden, Falk Neubert, University Osnabrück Open-Source ERP-Solutions 13

Interfaces

slide-14
SLIDE 14

30.10.2009, Dresden, Falk Neubert, University Osnabrück Open-Source ERP-Solutions 14

  • Some topics for the issue „ERP“
  • Freie Software / Open-Source
  • Open-Source ERP-Solutions
  • Next steps at the project

„ERP-Lösungen auf Basis Freier Software“

Outline

slide-15
SLIDE 15

30.10.2009, Dresden, Falk Neubert, University Osnabrück Open-Source ERP-Solutions 15

„Free software, is a matter of liberty, not price. To understand the concept, you should think of „free“ as in „free speech“, not as in „free beer“.

Fres Software

slide-16
SLIDE 16

30.10.2009, Dresden, Falk Neubert, University Osnabrück Open-Source ERP-Solutions 16

Free software offers four essential freedoms:

  • The freedom to run the program, for any purpose.
  • The freedom to study how the program works, and change it to

make it do what you wish. Access to the source code is a precondition for this.

  • The freedom to redistribute copies.
  • The freedom to improve the program, and release your

improvements (and modified versions in general) to the public.

Free Software

slide-17
SLIDE 17

30.10.2009, Dresden, Falk Neubert, University Osnabrück Open-Source ERP-Solutions 17

  • Some topics for the issue „ERP“
  • Free Software / Open-Source
  • Open-Source ERP-Solutions
  • Next steps at the project

„ERP-Lösungen auf Basis Freier Software“

Outline

slide-18
SLIDE 18

30.10.2009, Dresden, Falk Neubert, University Osnabrück Open-Source ERP-Solutions 18

  • Overview about the OS ERP-solutions
  • Definition of some evaluation criteria
  • Evaluation of ERP-solutions
  • Test of some business workflows

Project – ERP solutions based on Free Software

slide-19
SLIDE 19

30.10.2009, Dresden, Falk Neubert, University Osnabrück Open-Source ERP-Solutions 19

  • If the solution is covering the definition of Open Source?
  • Which features offers the ERP-solution?
  • How active is the Community?
  • Requests per month?
  • Registered user?
  • Response time / Quality of service
  • Continued development in last years
  • Is the solution sufficiently documented?
  • Are there any professional support
  • Are there any erp-solutions installed at customers?

Evaluation Criteria

slide-20
SLIDE 20

30.10.2009, Dresden, Falk Neubert, University Osnabrück Open-Source ERP-Solutions 20

ERP-solutions based on Open Source

slide-21
SLIDE 21

30.10.2009, Dresden, Falk Neubert, University Osnabrück Open-Source ERP-Solutions 21

ERP-solutions based on Open Source

slide-22
SLIDE 22

30.10.2009, Dresden, Falk Neubert, University Osnabrück Open-Source ERP-Solutions 22

Open-Source ERP Overview

System Lizenz Ausrichtung Datenbank URL Bemerkung GPLv2 ERP, CRM GPL ERP5 GPL ERP, CRM www.erp5.com GPL ERP SQL-Datenbanken GPL ERP MPL 1.1 ERP GPL ERP, CRM GPL ERP CPAL1.0 ERP

  • penERP

GPL ERP, CRM GPLv2 ERP ADempiere Oracle, PostgreSQL www.adempiere.org Fork from Compiere Apache OFBiz Apache 2.0 License MySQL, PostgreSQL

  • fbiz.apache.org

Framework CAO-Faktura WaWi MySQL www.cao-faktura.de alle Datenbanken mit ODBC- Schnittstelle SaaS Modell Intars www.intars.at Limbas Max-DB, Adabas www.limbas.org Lx-Office GPL, Artistice Licence WaWi, CRM PostgreSQL www-lx-office.org Fork von SQL-Led- ger Openbravo Oracle, PostgreSQL www.openbravo.com Fork teilweise von Compiere Opentaps MySQL, PostreSQL www.opentaps.org SQL-Ledger Oracle, PostgreSQL sql-ledger.org XTuple PostgreSQL www.xtuple.com/openmfg PostgreSQL www.openerp.com webERP MySQL www.weberp.org

slide-23
SLIDE 23

30.10.2009, Dresden, Falk Neubert, University Osnabrück Open-Source ERP-Solutions 23

Linux GUI Web-Client Perl, PHP ERP 2.6.0 (CRM 1.4)

Technical Data

Operating System Database PostgreSQL Programming Language License GPL, Artistic License Actual Version

Lx-Office

slide-24
SLIDE 24

30.10.2009, Dresden, Falk Neubert, University Osnabrück Open-Source ERP-Solutions 24

slide-25
SLIDE 25

30.10.2009, Dresden, Falk Neubert, University Osnabrück Open-Source ERP-Solutions 25

slide-26
SLIDE 26

30.10.2009, Dresden, Falk Neubert, University Osnabrück Open-Source ERP-Solutions 26

Lx-Office

X X Personal X Stock X CRM X Functionality Lx-Office Purchase Sales Finance Production Documentmanagement Projectmanagement

slide-27
SLIDE 27

30.10.2009, Dresden, Falk Neubert, University Osnabrück Open-Source ERP-Solutions 27

Positiv / Negativ + very good documentation + Good adaptation to German financial accounting (SKR03, SKR04) + Datev-Interface

  • no production management
  • lack of human resources
  • it is only working on Linux

Lx-Office

slide-28
SLIDE 28

30.10.2009, Dresden, Falk Neubert, University Osnabrück Open-Source ERP-Solutions 28

Linux, Microsoft GUI Web-Client, GTK-Client Python, XSL GPL 5.0

Technical Data

Operating System Database PostgreSQL Programming Language License Actual Version

OpenERP (früher TinyERP)

slide-29
SLIDE 29

30.10.2009, Dresden, Falk Neubert, University Osnabrück Open-Source ERP-Solutions 29

ERP Systeme auf Basis von Freier Software für KMU

slide-30
SLIDE 30

30.10.2009, Dresden, Falk Neubert, University Osnabrück Open-Source ERP-Solutions 30

ERP Systeme auf Basis von Freier Software für KMU

slide-31
SLIDE 31

30.10.2009, Dresden, Falk Neubert, University Osnabrück Open-Source ERP-Solutions 31

OpenERP (formerly TinyERP)

  • penERP

X X X X Personal X X X Stock X X X X X CRM X X Functionality Lx-Office Purchase Sales Finance Production Documentmanagement Projectmanagement

slide-32
SLIDE 32

30.10.2009, Dresden, Falk Neubert, University Osnabrück Open-Source ERP-Solutions 32

Positiv / Negativ + Variety of reports available + Active community + Good variety of functions + Good separation between the DB server, application server and client

  • Financial needs to be adjusted

OpenERP (früher TinyERP)

slide-33
SLIDE 33

30.10.2009, Dresden, Falk Neubert, University Osnabrück Open-Source ERP-Solutions 33

Technische Daten

Linux, Windows, FreeBSD, Open Solaris GUI Web-Client Java, Javascript, PL/SQL GPL 2.40 Operating System Database Oracle, PostgreSQL

Middleware

Apache-Tomcat, Apache-Ant, Java 2 Platform Standard Edition Programming Language License Actual Version

Openbravo

slide-34
SLIDE 34

30.10.2009, Dresden, Falk Neubert, University Osnabrück Open-Source ERP-Solutions 34

ERP Systeme auf Basis von Freier Software für KMU

slide-35
SLIDE 35

30.10.2009, Dresden, Falk Neubert, University Osnabrück Open-Source ERP-Solutions 35

ERP Systeme auf Basis von Freier Software für KMU

slide-36
SLIDE 36

30.10.2009, Dresden, Falk Neubert, University Osnabrück Open-Source ERP-Solutions 36

Openbravo

  • penERP

X X X X X X Personal X X X X Stock X X X X X X X X CRM X X X Functionality Lx-Office Openbravo Purchase Sales Finance Production Documentmanagement Projectmanagement

slide-37
SLIDE 37

30.10.2009, Dresden, Falk Neubert, University Osnabrück Open-Source ERP-Solutions 37

Positive/ Negative + Good program documentation + Good Features + Good software architecture + CRM and business intelligence functionality are integrated

  • Lack SKR03/04, Datev interface

Openbravo

slide-38
SLIDE 38

30.10.2009, Dresden, Falk Neubert, University Osnabrück Open-Source ERP-Solutions 38

Linux, Windows Java GPL 1.4

Technical Data

Operating System Database DB2, MySQL, PostgreSQL, Oracle, SQL Server Programming Language License Actual Version

  • pentaps
slide-39
SLIDE 39

30.10.2009, Dresden, Falk Neubert, University Osnabrück Open-Source ERP-Solutions 39

ERP Systeme auf Basis von Freier Software für KMU

slide-40
SLIDE 40

30.10.2009, Dresden, Falk Neubert, University Osnabrück Open-Source ERP-Solutions 40

  • pentaps
  • penERP

X X X X X X X X Personal X X X X X Stock X X X X X X X X X X CRM X X X X Functionality Lx-Office Openbravo opentaps Purchase Sales Finance Production Documentmanagement Projectmanagement

slide-41
SLIDE 41

30.10.2009, Dresden, Falk Neubert, University Osnabrück Open-Source ERP-Solutions 41

Positiv / Negativ + Multi-level BOM are possible + Great variety of functions + Easy installation

  • Work plans are unclear up
  • Surface: it can not be simultaneously open multiple masks
  • pentaps
slide-42
SLIDE 42

30.10.2009, Dresden, Falk Neubert, University Osnabrück Open-Source ERP-Solutions 42

Linux, W indows, FreeBSD, Solaris Java GPL Technical Data Operating System Database Oracle, PostgreSQL Programming Language License Actual Version 3.4.0 „Emily“

ADempiere

slide-43
SLIDE 43

30.10.2009, Dresden, Falk Neubert, University Osnabrück Open-Source ERP-Solutions 43

ERP Systeme auf Basis von Freier Software für KMU

slide-44
SLIDE 44

30.10.2009, Dresden, Falk Neubert, University Osnabrück Open-Source ERP-Solutions 44

ERP Systeme auf Basis von Freier Software für KMU

slide-45
SLIDE 45

30.10.2009, Dresden, Falk Neubert, University Osnabrück Open-Source ERP-Solutions 45

ADempiere

  • penERP

X X X X X X X X X X Personal X X X X X X Stock X X X X X X X X X X X X X CRM X X X X Functionality Lx-Office Openbravo opentaps ADempiere Purchase Sales Finance Production Documentmanagement Projectmanagement

slide-46
SLIDE 46

30.10.2009, Dresden, Falk Neubert, University Osnabrück Open-Source ERP-Solutions 46

Positiv / Negativ + Clear Surface + Large variety of functions + Good customizing properties Large + Language + Active Community * System Architectur

ADempiere

slide-47
SLIDE 47

30.10.2009, Dresden, Falk Neubert, University Osnabrück Open-Source ERP-Solutions 47

Linux PHP GPL 3.10.1 Technical Data Operating System Database MySQL Programming Language License Actual Version

WebERP

slide-48
SLIDE 48

30.10.2009, Dresden, Falk Neubert, University Osnabrück Open-Source ERP-Solutions 48

ERP Systeme auf Basis von Freier Software für KMU

slide-49
SLIDE 49

30.10.2009, Dresden, Falk Neubert, University Osnabrück Open-Source ERP-Solutions 49

WebERP

  • penERP

X X X X X X X X X X X X Personal X X X X X X X Stock X X X X X X X X X X X X X X X CRM X X X X Functionality Lx-Office Openbravo

  • pentaps

ADempiere WebERP Purchase Sales Finance Production Documentmanagement Projectmanagement

slide-50
SLIDE 50

30.10.2009, Dresden, Falk Neubert, University Osnabrück Open-Source ERP-Solutions 50

Unix, Linux, W indows, Mac OS X Python GPL GUI Technical Data Operating System Database MySQL, PotsgreSQL, DB2 Programming Language License W ebinterface Architecture Based on Zope Application Server

ERP5

slide-51
SLIDE 51

30.10.2009, Dresden, Falk Neubert, University Osnabrück Open-Source ERP-Solutions 51

ERP5

  • pen

ERP5 X X X X X X X X X X X X X X Personal X X X X X X X X X Stock X X X X X X X X X X X X X X X X X X CRM X X X X X Functionality Lx-O Open

  • penADem

WebERP Purchase Sales Finance Production Documentmanagement Projectmanagement

slide-52
SLIDE 52

30.10.2009, Dresden, Falk Neubert, University Osnabrück Open-Source ERP-Solutions 52

  • Some topics for the issue „ERP“
  • Free Software / Open-Source
  • Open-Source ERP-Solutions
  • Next steps at the project

„ERP-Lösungen auf Basis Freier Software“

Outline

slide-53
SLIDE 53

30.10.2009, Dresden, Falk Neubert, University Osnabrück Open-Source ERP-Solutions 53

  • Analysis of existing Open Source Shops
  • Which solutions are suitable for

existing open source ERP systems?

  • Which interfaces provide the existing

Open-source ERP systems?

Shop-Integration

slide-54
SLIDE 54

30.10.2009, Dresden, Falk Neubert, University Osnabrück Open-Source ERP-Solutions 54

ERP und Schnittstellen

  • What interfaces offer

Open-source ERP systems?

  • How can
  • > Indentifikationsstandards,
  • > Classification Standards
  • > Catalog exchange formats,
  • > Transaction standards and
  • > Process Standards

be observed?

Interfaces

slide-55
SLIDE 55

30.10.2009, Dresden, Falk Neubert, University Osnabrück Open-Source ERP-Solutions 55

Einführungsstrategien für OS ERP-Systeme

  • How does the introduction

an open source ERP solution from a proprietary solution?

  • What are the "stumbling blocks" are aware of?
  • Develop a model for their own actions

Open Source ERP Systems

Implementation Strategy

slide-56
SLIDE 56

30.10.2009, Dresden, Falk Neubert, University Osnabrück Open-Source ERP-Solutions 56

M.Sc. Falk Neubert Universität Osnabrück BWL/Produktions-Management und Wirtschaftsinformatik Tel.: 0541 - 969 4824 Fax: 0541 - 969 3641 falk.neubert@uni-osnabrueck.de www.r-e-c-o.de www.ec-net.de Further information under: https://www.xing.com/net/erp-os

Thanks you!