BASIC ERP ARCHITECTURE Skorkovsk KPH ESF MU Brno

BASIC ERP ARCHITECTURE Skorkovský, KPH, ESF MU, Brno 3. 10. 2020

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 3. 10. 2020 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, PRP-II. CONWIP, Advanced Planning and scheduling • ….

What could be controlled… 3. 10. 2020

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)

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 3. 10. 2020

Technological pyramid 3. 10. 2020

Integrated homogeneous solution ISVs Development Tools Customer Relationship Management 3. 10. 2020 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 3. 10. 2020

Relations among tables I 3. 10. 2020

Relations among tables II 3. 10. 2020

One table and its relations I 3. 10. 2020

One table (Sales Line) and its relations II ERP NAV 3. 10. 2020

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 3. 10. 2020

Calculation field and entries (transactions related to cards- tables) Example : Field Amount = Invoice Credit Note Payment Example : E. G. One million of entries Balance ERP Customer Card Item Card

Main form (menu, toolbar, forms) 3. 10. 2020

Main forms (card, list, form->sub-form) 3. 10. 2020

Main forms (card, list, form->sub-form) 3. 10. 2020

Main forms (card, list, form->sub-form) Partner What 3. 10. 2020

Table->Form principle 3. 10. 2020

Table x->Table y relations X= Customer Y=Post Code 3. 10. 2020

3. 10. 2020

Goodbay to all of you till the slide show 3. 10. 2020

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