Transcript basic erp architecture

BASIC ERP ARCHITECTURE
Skorkovský, KPH, ESF MU,Brno
24. 3. 2017
Simplified schema of ERP usage
ERP
Transaction- entries
Partners
DB
Enterprise
ERP
Reports
Trends
Information
(trends)
Information
Decision
Knowledge of methods applied for process management
Key decisions
24. 3. 2017
Key knowledge
Methods
•
•
•
•
•
•
•
•
•
•
•
Theory of constraint
Critical chain
DBR
Ishikawa Fishbone Diagram
Boston matrix and PLC
Magic Matrix (Gartner)
Use of ERP analytic tools
Pareto
SWOT (basic and advanced)
MRP,MRP-II,CONWIP,
Advanced Planning and scheduling
• ….
What could be controlled…
24. 3. 2017
ERP
The main objective of Enterprise Resource Planning, or ERP, is to
integrate all departments and functions across a company into a
single system by using a common database, the value of which is to
be able to have only one correct set of data.
Steel Service Center Vertical
Isolated Data Islands
Marketing
Accounting
Island
Management
Production
Island
Accounting
Marketing
& Sales
Islands
Customer
Orders
Sales
Representatives
Customers
Production
Planning
Quality Management
Quality
Management
Island
Island of
Deliveries
Inventory and Production
6
Steel Service Center Vertical
One Solution
One Database
Management
All Microsoft
Marketing
Inventory and Production
Customer
support
Internal Sales
One Company
Database
Accounting
Sales
Representatives
Customers
Quality
Production
management
Planning
7
ISLAND SYSTEMS
For example, records about inventory levels may be found in one
database, while customer information may be found in its own separate
database. Furthermore, these databases may be "island systems"
(operating independently from each other and having no
integration with other databases).
Architecture 2-tier (2-vrstvy)
Architecture 3-tier (3-vrstvy)
The second tier is the multithreaded
middle tier. This is the service
tier that is based on Web services.
From hell to paradise –ERP (see meaning)
You can change a business
in order to copy rigid functions
of the software ERP
Programming
You can change a software
in order to support your
business
Parameter
setup
24. 3. 2017
Technological pyramid
24. 3. 2017
Integrated homogeneous solution
ISVs
Development Tools
Customer
Relationship
Management
24. 3. 2017
Supply Chain
Management
Financial
Management
Analytics
Unique architecture
Integrated Development Environment
Database
GUI (Windows)
Zaměstnanci
Commerce
Portal
Zákazníci
& obchodní partneři
Microsoft Navision
Database Server
Application
Server
Microsoft SQL
Server 2000
Worldwide Generic Objects
Country-specific Objects
Externí aplikace
Customer-specific Objects
Vertical Solutions Objects
24. 3. 2017
Relations among tables I
24. 3. 2017
Relations among tables II
24. 3. 2017
One table and its relations I
24. 3. 2017
One table (Sales Line) and its relations II
ERP NAV
24. 3. 2017
Microsoft Dynamics NAV Sweet Points
•
•
•
•
•
•
Windows compatible (menu, command, mutual relations to MS Office,..)
Security (ID, passwords, roles, protocols)
Menu and basic modules
Shorthand keys and HELP
Multilanguage
Navigate and calculation (flow) fields, finding the reason why any
document was created
• Reports
• Entries, dimensions
24. 3. 2017
Calculation field and entries (transactions related to cards- tables)
Example : Field Amount =
Invoice
Credit Note
Payment
Example :E.G.
One million
of entries
Balance
Customer Card
ERP
Item Card
Main form (menu, toolbar, forms)
24. 3. 2017
Main forms (card, list, form->sub-form)
24. 3. 2017
Main forms (card, list, form->sub-form)
24. 3. 2017
Main forms (card, list, form->sub-form)
Partner
What
24. 3. 2017
Table->Form principle
24. 3. 2017
Table x->Table y relations
X= Customer
Y=Post Code
24. 3. 2017
Balance, Payments,..
Business Case Principles
Sales Entry in database
Customer table
(Type Invoice)
Sales Order
F11
Header
Item Chair 4 pcs 30 EURO
Item Table 1 pcs 100 EURO
Item Table
Entries in General Ledger
Item Ledger Entries
in database
Item Table
24. 3. 2017
Availability, Costs,…
(Types Sales)
F11 = posting, booking to G/L,…
Thanks for your attention
24. 3. 2017