VIETNAM NATIONAL UNIVERSITY, HANOI INTERNATIONAL SCHOOL GRADUATION PROJECT PROJECT NAME: ERP research and application for business financial management Student’s name: Bui Manh Tung Hanoi, 2023 VIETNAM NATIONAL UNIVERSITY, HANOI INTERNATIONAL SCHOOL GRADUATION PROJECT PROJECT NAME: ERP research and application for business financial management SUPERVISOR: Nguyen Doan Dong STUDENT: Bui Manh Tung STUDENT ID: 18071540 SUBJECT CODE: INS401401 MAJOR: Informatics and Computer Engineering CLASS: ICE2018A Hanoi, 2023 2 ACKNOWLEDGEMENT I want to start by thanking Mr. Nguyen Doan Dong, who provided me with direct guidance as I created my graduation project. He gave me some great suggestions and ideas for my project. Without your support and assistance, completing a graduation project would be quite challenging.
I have the chance to study and advance in my major by working on and finishing my graduation project. While working on my graduation thesis, I expanded my understanding of related skill, code, and other topics in addition to learning how to implement and create an ERP system. In order to better accomplish my graduation project, I have consulted, learnt from, and gotten assistance from my brothers and friends. Each of them has provided me with priceless knowledge, experience, and abilities.
Even so, it is certain that I won't be able to avoid all the flaws and certain restrictions in better completing the graduation project. As a result, I hope the teachers can comment and offer ideas to improve the project's quality in order to better improve the project and help me further in the future build a strong foundation in the major. Finally, I want to express my gratitude to my instructors, family, and friends. for always accompanying, supporting, and supporting me to complete and bring good things together.
Sincerely, Bui Manh Tung 3 PROMISE I hereby declare that the Graduation Project: “ERP research and application for business financial management” is my graduation project and has never been published in any research work. any other rescue. In the process of implementing this thesis, I have strictly implemented research ethics; All data and content contained in this project are the results of my research and survey, and the references in this project are cited as prescribed. I would like to take full responsibility before the department, faculty, and school for this commitment.
Hanoi, 2023 Bui Manh Tung 4 Table of Contents ACKNOWLEDGEMENT .4 List Of Figure.1 Identify the issue .2 Research scope and methods .3 Contributions to the project.12 CHAPTER 2: TECHNOLOGY FOR DEVELOPING ERP SYSTEM .15 CHAPTER 3: SYSTEM DESSIGN .30 CHAPTER 4: INSTALLATION OF PRODUCTS AND TEST CASE .53 5 List of Figure FIGURE 3.1 : SEQUENCE DIAGRAM FOR ADMIN .2 SEQUENCE DIAGRAM FOR MANAGER.3 : SEQUENCE DIAGRAM FOR STORE .8 ATTRIBUTE_VALUE TABLE .14 ORDERS_ITEM TABLE .18 USERS_GROUP TABLE .23 UPDATE/DELETE USER .1 Identify the issue In recent years, ERP (Enterprise Resource Planning) systems have grown in popularity as more companies use them to manage their financial operations. ERP systems offer a complete solution for combining different business operations into one system, including finance, accounting, inventory management, human resources, and customer relationship management. Businesses may manage their financial data more effectively and efficiently thanks to this connectivity. Many studies have examined the advantages and difficulties of implementing ERP systems for financial administration, which has been the focus of substantial study on ERP systems.
Researchers have looked into how ERP systems affect financial performance, what influences their acceptance, what problems come with putting them into place, and how they improve financial reporting and decision-making. Numerous companies actively use ERP systems for financial management in addition to research. ERP systems offer an automated and centralized financial management solution that can boost financial performance, cut expenses, and guarantee regulatory compliance. However, putting in place an ERP system may be a difficult process that needs careful management and preparation.
ERP systems are an essential tool for any fast-growing business because they help organizations to streamline and integrate their business processes. With an ERP system in place, companies can manage their operations more efficiently and effectively, improving productivity and reducing costs. ERP systems give businesses more visibility into the requirements and preferences of their customers, which can help them increase customer satisfaction. Additionally, ERP systems offer immediate access to vital information through the usage of a centralized database, allowing businesses to make better business decisions.
Despite the numerous advantages of ERP systems, there are still some difficulties and problems that organizations run into while putting them into use. The complexity of 9 ERP systems, which can make them challenging to adopt and adjust, is one frequent issue. Additionally, the resources and investment needed for ERP systems may be prohibitive for smaller firms. The requirement for continuing care and maintenance, which may be expensive and time-consuming, is another obstacle.
Finally, there are issues with data security and privacy, as ERP systems frequently hold sensitive data about the activities and clients of a firm. These difficulties underline how crucial it is to carefully build, install, and maintain ERP systems in order to guarantee their efficacy and security. In the future, there is really a need for improvement of ERP systems. As organizations continue to develop and expand in a business environment that is continually changing, there is a demand for increased flexibility and scalability in ERP systems.
Additionally, there is a need for enhanced reporting and data analytics capabilities, as well as better interaction with cutting-edge technologies. Last but not least, continual efforts to improve the security and compliance of ERP systems are required in light of the growing significance of data security and privacy in order to safeguard against cyber-attacks and guarantee compliance with data privacy requirements. To satisfy the changing needs of enterprises and assure their continuous success in the future, ERP systems must be continually improved. The topic of "ERP research and application for business financial management" examines the advantages and difficulties of deploying ERP systems for financial management, as well as the variables affecting adoption and the best techniques for doing so.
Businesses can better grasp the possible advantages and difficulties of ERP systems by looking at these issues, and they can then decide whether to implement them for financial management.2 Research scope and methods This project provides research solutions in the ERP for business financial management. The study will examine the advantages and difficulties of putting ERP systems in place for financial management, the variables affecting acceptance and success of ERP systems, and the best practices for putting ERP systems in place and 10 managing them in the financial context. The study will also look at how ERP systems affect financial performance, financial reporting, and business decision-making. The main functions of the project are as follows: • Deploy the ERP • Add groups and grant them permission to access the system.
• Add users to access the ERP also as view, update, and remove information. • Adding new stores to place separate products in. • Adding new products with many attributes. • Placing and managing each order from each customer.
• Printing the order to ensure that the customer receives the correct products and quantities • View the total amount of sales represented on the graphical chart or by number based on monthly basis. • Update the company information. This includes company name, address, phone, message, VAT charge, service charge, and more. • View the information of the users that had access to the system.
• Update the information of the users. The main method used in the research project: The research will assess the effects of ERP systems on financial performance, financial reporting, and decision-making by analyzing the financial performance data of the companies that have used them for financial management. In the analysis, the financial performance of the companies will be compared both before and after the implementation of the ERP system, as well as between those companies that have adopted ERP systems and those who have not. In conclusion, this study will provide insights on the advantages and difficulties of using ERP systems for financial management in organizations as well as the variables affecting the uptake and effectiveness of these systems.
Additionally, it will advance knowledge of how ERP systems affect firm financial performance, financial reporting, and decision-making.3 Contributions to the project Build system for the project. Interface design for the project. Making a coding system from scratch. 12 CHAPTER 2: TECHNOLOGY FOR DEVELOPING ERP SYSTEM 2.
MAMP MAMP is a solution stack composed of free and open-source and proprietary commercial software used together to develop and run dynamic websites on Apple Macintosh computers. MAMP consists of the PHP scripting language, MySQL database management system, and Apache web server. Without a dedicated web server or hosting service, MAMP enables developers to build and test web applications on their personal computer. MAMP is a well-liked tool among web developers for PHP development and testing due to its user-friendly interface and predefined settings.
For developers aiming to simplify their web development workflow, its simplicity and convenience make it a great asset. One of the primary advantages of MAMP is its convenience. A local web server environment is straightforward to set up and manage with MAMP's user-friendly interface. Web developers who want to test their web apps locally before deploying them to a live server may find this to be of great interest.
MAMP is a cost-effective option for developers who are just starting out with web development because it is also free to download and use. However, one of the primary disadvantages of MAMP is its limited scalability. MAMP is a helpful tool for local web development and testing, but it might not be appropriate for web applications that need to be highly performant and scalable on a wide scale. MAMP might not provide as much customization as other web development tools, too.
Although MAMP comes with default Apache, MySQL, and PHP configurations, certain developers might need advanced customization options.2 PHP programing PHP is a popular server-side scripting language used for web development. It is an open-source language that is well-liked by developers of all levels since it is made to be straightforward, adaptable, and quick to learn. PHP is a powerful programming language that can be used to build a variety of web applications, from straightforward websites to intricate web-based platforms. Dynamic online applications that need to interface with databases and other web services are especially well suited for it.
PHP is a flexible option for web developers because it works with a variety of web servers, such as Apache, Nginx, and IIS. PHP is known for its performance. It is a compiled language, which means that it runs faster than interpreted languages like JavaScript. Additionally, PHP provides several caching mechanisms, such as APC and OpCache, which help to improve performance by reducing the number of requests to the database and the amount of time spent processing code.
Another benefit of PHP is its flexibility. PHP is a flexible option for web developers since it works with many databases, including MySQL, PostgreSQL, and Oracle. A number of web frameworks, including Laravel, CodeIgniter, and Symfony, can be used with PHP to provide functionality and streamline the development process.3 Bootstrap Bootstrap is a popular open-source front-end development framework that is widely used for creating responsive, mobile-first web applications. It offers a variety of pre-built components and features that make it simple for developers to rapidly and simply create high-quality, aesthetically pleasing web apps.
We will examine the key attributes of Bootstrap and its advantages for web development in this overview. Bootstrap provides a range of pre-built components and tools that make it easy for developers to create high-quality, responsive web applications. It features a variety of user interface elements, including buttons, forms, alerts, and navigation menus, all of 14 which are created to function flawlessly on a variety of devices and screen sizes. Bootstrap also offers a grid framework that makes it simple for programmers to generate responsive layouts that adjust to various screen sizes.