商业企业的购销存管理信息系统的设计与实现

商业企业的购销存管理信息系统的设
计与实现
1
2
商业企业的购销存管理信息系统的设计与实现
摘要
随着信息技术的发展和计算机网络的普及,越来越多的企业开
始认可并实施ERP系统,作为ERP系统重要组成部分的管理系统与企业的生存发展密不可分。

当今世界,信息流已经成为企业中继实物流、现金流之后的第三大流动资源,利用科学设计的管理系统中信息流的畅通,来实现企业营业活动中物流的快速整合以及现金流的充分流动和利用,从而加快企业资源流动,适应快速变化的宏观环境和日益需要进行变革的企业内部环境,更好地提高企业的效率。

现如今,各企业十分重视企业管理系统的建设,而且以此作为企业获取竞争优势的工具和基础。

然而对于实力本就不足的中小企业来说,购买整个ERP系统不但是一笔巨大开支,而且整个ERP系统的能够应用的方面太多,更重要的是系统不能够很好地契合企业的现状,因此购买决策是一种浪费。

因此,根据企业所处的产业环境和自身特点,把管理系统的核心能力抽取出来,研究并实现商业企业的购销存管理信息系统,具有重要的现实意义。

本购销存管理信息系统从企业业务运营流程出发,对流程中的
需求进行详细分析,利用计算机信息技术实现对各类企业基础信息
I
的存储、查询、统计,实现企业流程核心——进货、销售和库存的一体化,以适应新的管理要求。

因此,本系统目标是设计并实现一个能够完成中小企业进货、销售和库存一体化的管理系统。

本系统能够使企业管理工作更科学更高效,业务处理更突出,从而达到提高工作效率的目的。

结合所要开发的系统的特点,软件设计采用Visual basic6.0作为开发工具,数据库为Microsoft SQL server。

整个系统操作简便,能够快速准确的处理相关业务,适合中小企业使用。

关键词:购销存管理系统,中小企业,商品销售,库存管理,Visual
basic6.0,Microsoft SQL server
II
THE DESIGN AND IMPLEMETATION OF PURCHASE-SELL-STOCK MANAGEMENT SYSTEM
ABSTRACT
With the development of information technology and the popularity of computer network, more and more enterprises begin to accept and implement the ERP system. As an important part of the EPR system, management system is closely related to an enterprise’ survival and development. Nowadays, information flow has become the third flow resource after physicals flow and capitals flow. By using the unblocked information flow in a scientific designed management system, the system can realize the fast integration of logistics in business activities and the full flowing and using of cash flows, and then fasten materials flow. And the efficiency of an enterprise can improve better if it can adapt the changing macro-environment and inner environment in an enterprise. As a result, every enterprise pays much attention to the construction of the management system, and takes it as the instrument and basis to gain competitive advantage.
III
However, it is really a big cost to buy the whole ERP system for a medium-sized and small enterprise.W hat’s more,the whole ERP system can apply to too many aspects and at the same time, it can not conform to the situation of the enterprise very well, so it’s a little waste to buy an whole ERP system. Therefore, according to the profession environment and the exterior environment of a corporation, extracting the core competence of the management system, then studying and implementing of the purchase-sell-stock management system in a commercial enterprise have the important practical significance.
This purchase-sell-stock management system begins with enterprise business operation processes, and then analyses the requirement in the procedure detailedly. At last by taking advantage of the computer information technology, the system can realize the function of storage, search and statistics of basic information in a corporation, bring about the integration of core process—purchasing, selling, and stocking, fit the demand of new management.
Therefore, the goal of this graduation design is to work out a management system that can complete the task of managing the purchasing, sales and storage of a minor enterprise. With the use of this
IV
system, the management work will be more efficient, and the business flows are going to be more effective and the work efficiency is bound to be improved. Considering all the characteristics of this system, the development tool is Visual basic6.0, and the database is SQL server. The whole system is easy to manipulate, and it can deal with the related works quickly, so it is especially useful for some medium-sized and small-scale enterprises.
KEY WORDS:purchase-sell-stock management system, Small and Medium Enterprise, commodity sales, inventory control, Visual basic6.0,Microsoft SQL server
V。