BASIC ERP ARCHITECTURE Skorkovsk KPH ESF MU Brno

BASIC ERP ARCHITECTURE Skorkovský, KPH, ESF MU, Brno 4. 3. 2021

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 4. 3. 2021 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 analysis SWOT (basic and advanced) MRP, MRP-II, CONWIP, Advanced Planning and scheduling Linear programming Methods of quality management

What could be controlled… 4. 3. 2021

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 Customers Customer Orders Production Planning Quality Management Marketing & Sales Islands Quality Management Island Sales Representatives 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) Klientská vrstva Databáze a aplikace

Architecture 3 -tier (3 -vrstvy) Klientská vrstva Střední vrstva (servers) Databáze 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 4. 3. 2021

Technological pyramid 4. 3. 2021

Integrated homogeneous solution ISVs Development Tools Customer Relationship Management 4. 3. 2021 Supply Chain Management Financial Management Analytics

Unique architecture Integrated Development Environment Database GUI (Windows) Zaměstnanci Commerce Portal C G om at m ew er ay ce (B 2 B ) 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 4. 3. 2021 See live systém NAV

Main form (menu, toolbar, forms) 4. 3. 2021

Main forms (card, list, form->sub-form) 4. 3. 2021

Main forms (card, list, form->sub-form) 4. 3. 2021

Main forms (card, list, form->sub-form) Partner What 4. 3. 2021

Table->Form principle Form (Card, Window), which is object as well and it is used to display data stored in the Table (object) Specification of fields in Table (object) 4. 3. 2021

Table x->Table y relations X= Customer Y=Post Code 4. 3. 2021

Relations among tables I 4. 3. 2021

Relations among tables II 4. 3. 2021

One table and its relations I 4. 3. 2021

One table (Sales Line) and its relations II ERP NAV 4. 3. 2021

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 4. 3. 2021

Balance, Payments, . . Business Case Principles Sales Entry in database Customer Table (Type Invoice) Sales Order Header F 11=post Item Chair 4 pcs 30 EURO Item Table 1 pcs 100 EURO Item Table 4. 3. 2021 Availability, Costs, … Entries in General Ledger Item Ledger Entries in database (Type Sales) F 11 = posting, booking to G/L, …

Thanks for your attention 4. 3. 2021