1 / 28

BASIC ERP ARCHITECTURE

BASIC ERP ARCHITECTURE. Skorkovský, KPH, ESF MU ,Brno. Simplified schema of ERP usage. DB. ERP. Transaction- entries. Partners. ERP. Information (trends). Information. Enterprise. Reports. Trends. Decision. Knowledge of methods applied for process management.

paul
Download Presentation

BASIC ERP ARCHITECTURE

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. BASIC ERP ARCHITECTURE Skorkovský, KPH, ESF MU,Brno

  2. Simplified schema of ERP usage DB ERP Transaction- entries Partners ERP Information (trends) Information Enterprise Reports Trends Decision Knowledge of methods applied for process management Key decisions Key knowledge 21. 10. 2019

  3. 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 Kepner-Tregoe Method for decision making Prospect Theory ….

  4. What could be controlled…

  5. ERP The main objective of Enterprise Resource Planning, or ERP, is to integrate alldepartments and functions across a company into a single system by using acommon database, the value of which is to be able to have only one correct set ofdata.

  6. Isolated Data Islands SteelService Center Vertical Marketing & Sales Islands Accounting Island Marketing Management Production Island Customer Orders Accounting Sales Representatives Island of Deliveries Customers Production Planning Quality Management Island Quality Management Inventory and Production 6

  7. Management Marketing Customer support Internal Sales One Company Database Accounting Customers Quality management Production Planning SteelService Center Vertical One Solution One Database All Microsoft Inventory and Production Sales Representatives 7

  8. ISLAND SYSTEMS For example, recordsabout inventory levels may be found in one database, while customer informationmay 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).

  9. Architecture 2-tier (2-vrstvy)

  10. Architecture 3-tier (3-vrstvy) The second tier is the multithreaded middle tier. This is the service tier that is based on Web services.

  11. 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

  12. Technological pyramid REPORTING & ANALYTICS MICROSOFT BUSINESS SOLUTIONS - NAVISION E- COMMERCE SCM CRM FM TECHNOLOGY

  13. ISVs Development Tools Integrated homogeneous solution Customer Relationship Management Supply Chain Management Financial Management Analytics

  14. Unique architecture Integrated Development Environment Database GUI (Windows) Zaměstnanci CommercePortal Microsoft Navision Database Server Zákazníci & obchodní partneři ApplicationServer Commerce Gateway (B2B) Microsoft SQLServer 2000 Worldwide Generic Objects Country-specific Objects Externí aplikace Customer-specific Objects VerticalSolutions Objects

  15. Relations among tables I

  16. Relations among tables II

  17. One table and its relations I

  18. One table (Sales Line) and its relations II ERP NAV

  19. 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

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

  21. Main form (menu, toolbar, forms)

  22. Main forms (card, list, form->sub-form)

  23. Main forms (card, list, form->sub-form)

  24. Main forms (card, list, form->sub-form) Partner What

  25. Table->Form principle

  26. Tablex->Table y relations X= Customer Y=Post Code

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

  28. Thanks for your attention

More Related