Enterprise Resource Planning (ERP) (edit)
Tìm nguồn mở cho SQL Server: https://www.findbestopensource.com/tagged/sql-server
1) Backend: https://github.com/bitwarden/server/releases
The core infrastructure backend (API, database, Docker, etc)
2) SQL Server
https://www.findbestopensource.com/product/sqlbuddy
https://www.findbestopensource.com/product/bideploy
https://www.findbestopensource.com/product/cp-sqltoolbox
https://www.findbestopensource.com/product/getmssqldump
https://www.findbestopensource.com/product/ktaranov-sqlserver-kit
https://github.com/ktaranov/sqlserver-kit (HAY)
Phần mềm nguồn mở ERP: Odoo > ERPNext > MixERP > VIENNA Advantage
https://www.goodfirms.co/blog/11-best-free-and-open-source-erp-software-solutions
https://solutionsreview.com/enterprise-resource-planning/top-15-free-and-open-source-erp-solutions/
- VIENNA Advantage (C# + SQL Server)
- VIENNA Advantage - Best open source ERP CRM
- Languages: C#, ASP.NET, Oracle
- Enterprise Resource Planning (ERP)
- Customer Relationship Management (CRM)
- Document Management System (DMS)
- MixERP: Open Source ERP, HRM, MRP, MPS (.NET + C# + MS SQL Server)
- MixERP 2.x: C#, JavaScript, ASP.NET, SQL Server
- MixERP 1.x: C#, JavaScript, ASP.NET, PostgreSQL (pgsql)
VIENNA Advantage
https://github.com/ViennaAdvantage/ERP-CMR-DMS/tree/master/ViennaAdvantageWeb
https://github.com/erp-crm-viennaadvantage/ViennaAdvantageWeb
https://github.com/313767875/ViennaAdvantageWeb
https://github.com/VIENNA-Advantage-ERP-CRM/official-VAFramework-ERP-CRM/
https://github.com/ViennaAdvantage/ERP-CMR-DMS
https://sourceforge.net/projects/erp-crm-advant/
Compare between ERPs (https://www.selecthub.com/manufacturing-software/)
Phần mềm quản lý chung cư: https://fbs.com.vn/
Phần mềm ERP giá tốt: https://www.singsys.com/dotnet-erp-software-solution-development.php
OpenERP - Enterprise Resource Planning in Python
DotNetERP - Enterprise Resource Planning in C#: https://www.singsys.com/dotnet-erp-software-solution-development.php
INFOR ERP - ERP ở Việt Nam
Key functional requirements
https://www.selecthub.com/enterprise-resource-planning/key-erp-functional-requirements/
- financial and analytic accounting,
- sales and purchase management,
- e-commerce integration,
- warehouse and inventory management,
- point of sales (POS) functionality,
- human resource management system,
- marketing campaign,
- customer and supplier relations management,
- workflow systems,
- association management,
- retailing & distribution,
- tasks automation,
- document management,
- help desk,
https://quintagroup.com/cms/python/openerp
How to choose the right type of database for your enterprise?
- Relational database management systems (Oracle, MySQL, MS SQL Server, PostgreSQL)
- Document store (MongoDB, Couchbase)
- Key-value store (Redis, Memcached)
- Wide-column store (Cassandra, HBase)
- Search engine (Elasticsearch)
Số hóa & Chuyển đổi số là gì?
Nhìn vào bức tranh trên chúng ta thấy Số hóa & Chuyển đổi số trong sản xuất là tất cả về việc chuyển đổi nhiệm vụ thủ công và trên giấy của nhà máy của bạn thành các chức năng tự động, kỹ thuật số, dựa trên phần mềm. Mặc dù các nhà máy có hệ thống điều khiển cho chức năng điều khiển quá trình, vẫn có rất nhiều nhiệm vụ thủ công trong nhà máy liên quan đến bảo trì, độ tin cậy, tính toàn vẹn, hiệu quả năng lượng, an toàn nhân sự và sản xuất.
Số hóa & Chuyển đổi số trong sản xuất là về tự động hóa các tác vụ thủ công. Hầu hết có thể được thực hiện tại cơ sở (On Premise - có nghĩa là tất cả các công nghệ và chuyên môn được chứa trong nhà máy, do đó không yêu cầu kết nối với Internet hoặc lưu trữ dữ liệu trên đám mây).
ERP Functional Requirements
There are a few things every ERP should contain. You can think of functional ERP system requirements as the benefits and experiences an ERP system provides.
Centralized Modules
These allow users to manage grouped tasks without switching applications or screens. All information needed for a certain operation should be housed in the same part of the system.
ERP Database
ERP systems rely on a central database from which all applications retrieve information. This provides all users with a single source of truth, ensuring all departments and teams work with the same set of information.
Integration
ERP applications are fully integrated and should work together seamlessly. This means users should be able to go from one part of the system to another without feeling completely lost or like it’s a different application. This also means the applications should freely share information with one another in real time. ERPs work to eliminate redundancies in your system and provide up-to-the-minute information.
ERP Modules and Functions
Manufacturing (MRP)
Before ERP, there was MRP, or manufacturing resource planning.
Accounting (ACCT)
Accounting
Human Resources (HRM)
Human Resources (HR)
Customer Relationship Management (CRM)
Customer relationship management (CRM)
Inventory Management (IM)
Inventory Management
Distribution
Distribution
Business Intelligence (BI)
Business intelligence (BI)
