CN104299094A - Enterprise purchase-sales-inventory management information system - Google Patents
Enterprise purchase-sales-inventory management information system Download PDFInfo
- Publication number
- CN104299094A CN104299094A CN201410558364.1A CN201410558364A CN104299094A CN 104299094 A CN104299094 A CN 104299094A CN 201410558364 A CN201410558364 A CN 201410558364A CN 104299094 A CN104299094 A CN 104299094A
- Authority
- CN
- China
- Prior art keywords
- information
- commodity
- module
- sales
- supplier
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/08—Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
- G06Q10/087—Inventory or stock management, e.g. order filling, procurement or balancing against orders
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0631—Resource planning, allocation, distributing or scheduling for enterprises or organisations
- G06Q10/06313—Resource planning in a project environment
Abstract
The invention relates to computer management systems, in particular to an enterprise purchase-sales-inventory management information system. The system is provided with a newly-added supplier module, a supplying management module, a new customer register module, a customer information management module, a newly-added commodity information module, a procurement and warehousing management module, a selling and ex-warehouse management module, a commodity inventory management module, a commodity warehousing statistics module and a commodity ex-warehouse statistics module under a Brower/Server network mode. The data flow of all the modules is defined through a data dictionary. A marketing information table, a supplier information table, a customer information table, a user information table, a warehousing information table and a commodity information table are built, and a database is connected through a JDBC-ODBC connection bridge for data access. Through the system, the workload of manpower can be reduced, management can be more logic and scientific, commodity data management is more modern, automatic and intelligent, then, economic benefits are increased, and work efficiency is improved.
Description
Technical field
The present invention relates to a kind of computer management system, specifically a kind of enterprise purchase, sales and stock management infosystem.
Background technology
In recent years, merchandise sales on market are very fierce and present perfervid state gradually, some well-known chains have very strong core competitiveness, they not only rely on traditional specialized operation, but also have oneself operation character and market orientation accurately, and computing machine has been used to manage.The enterprise of the chain industry of modern goods has singularity in unit price, purchase channel, information acquisition etc., thus has saved cost, improves profit.Also be the expansion in market and carry out next step development and lay the first stone, strengthen infotech further, construction network information intercourse platform, thus strengthen enterprise to the quick-reaction capability (QRC) of turn of the market, facilitate the development of enterprise, reduce cost.But existing information management imperfection, there is a lot of leak, efficiency is low as done, error of performance rate increases.And because greater chain enterprise both domestic and external constantly expands and annexs, various small enterprise's management states is increasingly difficult.The management philosophy that the supvr of most enterprise is outmoded, can not adapt to emerging product and shop.Visible, having used computing machine to carry out management to enterprise's goods entry, stock and sales is trend of the times.
Summary of the invention
The technical problem to be solved in the present invention is to provide a kind of enterprise purchase, sales and stock management infosystem, this system is for deficiencies such as enterprise's purchase, sales and stock management mode inefficiency, error of performance rate in prior art increase, there is provided one can realize logic, science, make commodity data manage more perfect enterprise's purchase, sales and stock management infosystem.
For solving the problems of the technologies described above, the technical solution used in the present invention is:
A kind of enterprise of the present invention purchase, sales and stock management infosystem, newly-increased supplier module, supplies management module, newly-set-up client enrollment module, client information management module, newly-increased merchandise news module, buying stock management module are set under Brower/Server network schemer, sell out database management module, commodity inventory control module, commodity warehouse-in statistical module and commodity ex-warehouse statistical module, defined by the data flow of data dictionary to above-mentioned each module; Set up marketing information table, supplier information table, customer information table, user message table, warehouse-in information table and merchandise news table, adopt the mode connection data storehouse of JDBC-ODBC connecting bridge to carry out data access.
Described newly-increased supplier module completes the interpolation function of supplier information, and supplier information comprises the name of supplier.
Described supplies management module completes deletion and the query function of supplier information, and user carries out deletion action to useless supplier information, carries out query manipulation by the name of supplier.
Described newly-set-up client enrollment completes the function of adding new customer information, and new customer information comprises client's card number, customer name, sex, the age, address, phone, identification card number information.
Described newly-increased merchandise news module completes the function of adding commodity essential information, and the essential information of commodity comprises, goods number, trade name, type, specification, model, unit, retail price information.
Described commodity information management module completes the function of the deletion of information, amendment and inquiry, and operator to modify operation to existing merchandise news, deletes, press the essential information of goods number inquiry commodity simultaneously to useless merchandise news.
Described procurement of commodities stock management module completes the function of enterprise's commodity warehouse-in, and operator selects the commodity of putting in storage, supplier, the purchase quantity of input commodity and unit price of procurement.
Described marketing function of selling out the complete merchandise news of database management module, the customer type of sale comprises dispersed customer and client, if client, the price buying commodity according to client adds up bonus point for client.
The function of the detailed warehouse situation of described commodity warehouse-in statistical module complete statistics commodity, each storage bill shows by system, checks for operating personnel.
Described commodity ex-warehouse statistical module completes the statistical function of merchandise sales information, and system shows all merchandise sales and goes out library information.
The present invention has following beneficial effect and advantage:
1. apply present system and can reduce artificial workload, and management can be made to become more orderly property, science, commodity data is made to manage modernization more, robotization, intellectuality, and then increase economic benefit and increase work efficiency, systemic-function is complete, and user interface is easily understood, fast simple to operation, security is stronger, achieves the standardization of enterprise information management, systematization and robotization, has certain practical commercial value.
2. present system is easy and simple to handle, interface is clear, utilization is flexible, security is high, completes the management to enterprise, mainly comprises the aspects such as the management of client, the management of commodity, the management of stocking up, the management of sale, the management of stock.System has and changes to the browsing of various information, additions and deletions functions such as looking into.In addition, can delete and then release disk space when these information records are useless time.
Accompanying drawing explanation
Fig. 1 is present system system functional block diagram;
Fig. 2 is present system business process map;
Fig. 3 is present system data stream one-level refinement flow graph;
Fig. 4 is present system supplier management secondary refinement flow graph;
Fig. 5 is present system customer account management secondary refinement flow graph;
Fig. 6 is present system merchandise control secondary refinement flow graph;
Fig. 7 is present system buying stock management secondary refinement flow graph;
Fig. 8 is that present system merchandise sales go out library management secondary refinement flow graph;
Fig. 9 is that present system commodity go out to put in storage statistical management secondary refinement flow graph;
Figure 10 is present system program flow diagram.
Embodiment
Below in conjunction with Figure of description, the present invention is further elaborated.
As shown in Figure 1, enterprise of system of the present invention purchase, sales and stock management infosystem, newly-increased supplier module, supplies management module, newly-set-up client enrollment module, client information management module, newly-increased merchandise news module, buying stock management module are set under Brower/Server network schemer, sell out database management module, commodity inventory control module, commodity warehouse-in statistical module and commodity ex-warehouse statistical module, defined by the data flow of data dictionary to above-mentioned each module; Set up marketing information table, supplier information table, customer information table, user message table, warehouse-in information table and merchandise news table, adopt the mode connection data storehouse of JDBC-ODBC connecting bridge to carry out data access.
The present embodiment business process map describes the process of the every business processing of current system, and by the number and mode etc. of the method for the collection that describes information data in business procession in conjunction with business process map in detail exactly, typing, propagation, storage, process, algorithm, output, it is the precondition and guarantee realizing system.Be below native system business process map as shown in Figure 2.
The logical model of data flow diagram trace system accurately, delineation information data in MIS from typing again through data mart modeling process, store the last all processes exported, the data flow diagram of present system, as shown in Fig. 3 ~ Fig. 9, be respectively present system data stream one-level refinement flow graph, supplier management secondary refinement flow graph, customer account management secondary refinement flow graph, merchandise control secondary refinement flow graph, purchase stock management secondary refinement flow graph, merchandise sales go out library management secondary refinement flow graph, commodity go out to put in storage statistical management secondary refinement flow graph.
Data dictionary is the information combination for data, namely to the set of the definition of all elements comprised in data flow diagram.The effect of data dictionary is the descriptor provided in the analysis and design process of software about data.
The definition of data stream is the path that data structure is transmitted in management system.Be that following content is generally included to the description of data stream: the title of data stream, describe, sequence number, data stream source, data diffluence, composition (data structure).
The data of present system, respectively shown in following table:
Supplier information data stream membership information data stream
Information of goods information data stream buying warehouse-in inter-area traffic interarea
Sell outbound inter-area traffic interarea statistical information data stream
The supplier data stream that the supplier data stream added is deleted
The membership information data stream that supplier's Query Information data stream is added
The membership information data stream member Query Information data stream of deleting
The information of goods information data stream that the information of goods information data stream added is deleted
The information of goods information data stream merchandise query inter-area traffic interarea of amendment
Warehouse-in statistical information data flows out storehouse statistical information data stream
First native system needs the authentication through user, after good authentication, enters the administration interface of native system, selects certain functional module to carry out various operation.The program flow diagram of native system as shown in Figure 10.
The operator of native system is mainly system manager, and native system forms primarily of 12 modules: newly-increased supplier module, supplier management module, newly-set-up client enrollment module, client information management module, newly-increased merchandise news module, commodity information management module, procurement of commodities enters library module, sell out database management module, commodity inventory control module, commodity warehouse-in statistical module, commodity ex-warehouse statistical module, password modified module.
Login page is the entrance of enterprise management system, and in order to ensure the safety of website and database, it is very necessary for carrying out authentication to the people entered, the especially background management system of website.The major function of this page carries out authentication to user exactly.Only have username and password all correctly just can enter background system.User inputs user name and password, click the function that " login " button completes login, after inputting correct user and password, system enters main interface, backstage, the design of system background adopts the structure of framework, and operator can select the function items on the left side to realize the management of some function.
In present system, newly-increased supplier module mainly completes the interpolation function of supplier information, and supplier information comprises the name of supplier.The information using supplier is needed when procurement of commodities; Supplies management module completes deletion and the query function of supplier information, and user can carry out deletion action to useless supplier information, can carry out query manipulation by the name of supplier; Newly-set-up client enrollment module completes the function of adding new customer information, and new customer information comprises client's card number, customer name, sex, the age, address, phone, the essential informations such as identification card number, and client has corresponding integration when buying the commodity of this enterprise; Client information management module block completes customer information and deletes and query function.Operator by the essential information of client's card number inquiry client, also can inquire about customer information; Newly-increased merchandise news module completes the function of adding commodity essential information, and commodity all need when purchasing warehouse-in and selling outbound the essential information using commodity.The essential information of commodity comprises, goods number, trade name, type, specification, model, unit, the information such as retail price; Commodity information management module completes the function of the deletion of information, amendment and inquiry, and operator can to modify operation to existing merchandise news, deletes, can inquire about the essential information of commodity simultaneously by goods number to useless merchandise news; Procurement of commodities stock management module completes the function of enterprise's commodity warehouse-in, and in this module, operator selects the commodity of putting in storage, supplier, and the purchase quantity of input commodity and unit price of procurement, complete the function of commodity warehouse-in; Sell out the marketing function of the complete merchandise news of database management module, the guest room type of sale can dispersed customer, also can client, if client, the price buying commodity according to client adds up bonus point for client; Commodity inventory control module completes the look facility of existing commodity stocks information, and operating personnel can inquire about by goods number; The function of the detailed warehouse situation of commodity warehouse-in statistical module complete statistics commodity, system can show each storage bill, checks for operating personnel; Commodity ex-warehouse statistical module completes the statistical function of merchandise sales information, and system shows all merchandise sales and goes out library information; Password modified module completes the modify feature of administrator's password.
One invention system can alleviate workload, increases work efficiency, and reduces labor intensity, and improves accuracy and the efficiency of management of information management.Manpower is saved in merchandise control process, alleviate workload, reduce cost and other disbursements, the efficiency of the equipment raising work that reasonable utilization is all, is improved the accuracy rate of data, reduces error by the utilization of system, the successful operation of new system, can realize, in enterprise management reason, from buying warehouse-in to the full-automatic management of merchandise sales, being realized fast query and the statistical function of information by computing machine.
Claims (10)
1. enterprise's purchase, sales and stock management infosystem, it is characterized in that: this system arranges newly-increased supplier module, supplies management module, newly-set-up client enrollment module, client information management module, newly-increased merchandise news module, buying stock management module, sells out database management module, commodity inventory control module, commodity warehouse-in statistical module and commodity ex-warehouse statistical module under Brower/Server network schemer, is defined by the data flow of data dictionary to above-mentioned each module; Set up marketing information table, supplier information table, customer information table, user message table, warehouse-in information table and merchandise news table, adopt the mode connection data storehouse of JDBC-ODBC connecting bridge to carry out data access.
2., by enterprise according to claim 1 purchase, sales and stock management infosystem, it is characterized in that: described newly-increased supplier module completes the interpolation function of supplier information, and supplier information comprises the name of supplier.
3. by enterprise according to claim 1 purchase, sales and stock management infosystem, it is characterized in that: described supplies management module completes deletion and the query function of supplier information, user carries out deletion action to useless supplier information, carries out query manipulation by the name of supplier.
4. by enterprise according to claim 1 purchase, sales and stock management infosystem, it is characterized in that: described newly-set-up client enrollment completes the function of adding new customer information, and new customer information comprises client's card number, customer name, sex, age, address, phone, identification card number information.
5. by enterprise according to claim 1 purchase, sales and stock management infosystem, it is characterized in that: described newly-increased merchandise news module completes the function of adding commodity essential information, and the essential information of commodity comprises, goods number, trade name, type, specification, model, unit, retail price information.
6. by enterprise according to claim 1 purchase, sales and stock management infosystem, it is characterized in that: described commodity information management module completes the function of the deletion of information, amendment and inquiry, operator to modify operation to existing merchandise news, useless merchandise news is deleted, presses the essential information of goods number inquiry commodity simultaneously.
7. by enterprise according to claim 1 purchase, sales and stock management infosystem, it is characterized in that: described procurement of commodities stock management module completes the function of enterprise's commodity warehouse-in, operator selects the commodity of putting in storage, supplier, the purchase quantity of input commodity and unit price of procurement.
8. by enterprise according to claim 1 purchase, sales and stock management infosystem, it is characterized in that: described marketing function of selling out the complete merchandise news of database management module, the customer type of selling comprises dispersed customer and client, if client, the price buying commodity according to client adds up bonus point for client.
9. by enterprise according to claim 1 purchase, sales and stock management infosystem, it is characterized in that: the function of the detailed warehouse situation of described commodity warehouse-in statistical module complete statistics commodity, each storage bill shows by system, checks for operating personnel.
10., by enterprise according to claim 1 purchase, sales and stock management infosystem, it is characterized in that: described commodity ex-warehouse statistical module completes the statistical function of merchandise sales information, system shows all merchandise sales and goes out library information.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410558364.1A CN104299094A (en) | 2014-10-21 | 2014-10-21 | Enterprise purchase-sales-inventory management information system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410558364.1A CN104299094A (en) | 2014-10-21 | 2014-10-21 | Enterprise purchase-sales-inventory management information system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN104299094A true CN104299094A (en) | 2015-01-21 |
Family
ID=52318815
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410558364.1A Pending CN104299094A (en) | 2014-10-21 | 2014-10-21 | Enterprise purchase-sales-inventory management information system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104299094A (en) |
Cited By (13)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104598594A (en) * | 2015-01-22 | 2015-05-06 | 中国石油技术开发公司 | Basic database subsystem of integration system for Internet of Things of drilling machine parts |
| CN105139160A (en) * | 2015-10-14 | 2015-12-09 | 盐城工学院 | B/S-based enterprise sales management system |
| CN105512827A (en) * | 2015-12-18 | 2016-04-20 | 苏州市享乐惠信息科技有限公司 | Supermarket management information system |
| CN106022667A (en) * | 2016-07-29 | 2016-10-12 | 梧州市自动化技术研究开发院 | Automatic rosin managing system |
| CN106600157A (en) * | 2016-12-22 | 2017-04-26 | 东莞华南设计创新院 | Integration method of informational data |
| CN106611319A (en) * | 2015-10-23 | 2017-05-03 | 镇江金软计算机科技有限责任公司 | A shopping mall customer relation management system |
| CN108052604A (en) * | 2017-12-13 | 2018-05-18 | 广州玟盈信息科技有限公司 | A kind of commodity information management system based on internet |
| CN108764647A (en) * | 2018-04-16 | 2018-11-06 | 中山大学 | The PMT device databases systems that online and offline are combined |
| CN109165884A (en) * | 2018-07-11 | 2019-01-08 | 安徽云图信息技术有限公司 | A kind of warehouse management system based on mobile terminal |
| CN109255530A (en) * | 2018-08-28 | 2019-01-22 | 河北七米科技发展有限公司 | A kind of purchase, sales and inventory management system |
| CN109493092A (en) * | 2018-11-09 | 2019-03-19 | 祺机(上海)信息科技有限公司 | Management system and method |
| CN109502218A (en) * | 2018-07-31 | 2019-03-22 | 上海贝壳供应链管理有限公司 | Intelligent hopper management method, system, electronic equipment and storage medium |
| CN111951081A (en) * | 2020-08-18 | 2020-11-17 | 安徽乐筑一站数据科技有限公司 | System for enabling each material to be attached with information attribute and constructing scene by using data |
-
2014
- 2014-10-21 CN CN201410558364.1A patent/CN104299094A/en active Pending
Non-Patent Citations (1)
| Title |
|---|
| 魏少辉: "宁波华盛汽车部件有限公司进销存管理系统的设计与实现", 《中国优秀博士学位论文全文数据库信息科技辑》 * |
Cited By (13)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104598594A (en) * | 2015-01-22 | 2015-05-06 | 中国石油技术开发公司 | Basic database subsystem of integration system for Internet of Things of drilling machine parts |
| CN105139160A (en) * | 2015-10-14 | 2015-12-09 | 盐城工学院 | B/S-based enterprise sales management system |
| CN106611319A (en) * | 2015-10-23 | 2017-05-03 | 镇江金软计算机科技有限责任公司 | A shopping mall customer relation management system |
| CN105512827A (en) * | 2015-12-18 | 2016-04-20 | 苏州市享乐惠信息科技有限公司 | Supermarket management information system |
| CN106022667A (en) * | 2016-07-29 | 2016-10-12 | 梧州市自动化技术研究开发院 | Automatic rosin managing system |
| CN106600157A (en) * | 2016-12-22 | 2017-04-26 | 东莞华南设计创新院 | Integration method of informational data |
| CN108052604A (en) * | 2017-12-13 | 2018-05-18 | 广州玟盈信息科技有限公司 | A kind of commodity information management system based on internet |
| CN108764647A (en) * | 2018-04-16 | 2018-11-06 | 中山大学 | The PMT device databases systems that online and offline are combined |
| CN109165884A (en) * | 2018-07-11 | 2019-01-08 | 安徽云图信息技术有限公司 | A kind of warehouse management system based on mobile terminal |
| CN109502218A (en) * | 2018-07-31 | 2019-03-22 | 上海贝壳供应链管理有限公司 | Intelligent hopper management method, system, electronic equipment and storage medium |
| CN109255530A (en) * | 2018-08-28 | 2019-01-22 | 河北七米科技发展有限公司 | A kind of purchase, sales and inventory management system |
| CN109493092A (en) * | 2018-11-09 | 2019-03-19 | 祺机(上海)信息科技有限公司 | Management system and method |
| CN111951081A (en) * | 2020-08-18 | 2020-11-17 | 安徽乐筑一站数据科技有限公司 | System for enabling each material to be attached with information attribute and constructing scene by using data |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104299094A (en) | Enterprise purchase-sales-inventory management information system | |
| US20200226618A1 (en) | Platform, method and device for tracing an object | |
| CN104463630B (en) | A kind of Products Show method and system based on net purchase insurance products characteristic | |
| CN105160567A (en) | Patent transaction system | |
| WO2013107376A1 (en) | Information processing method and system for network trading platform | |
| CN107346315B (en) | Object data association index system and construction and application method thereof | |
| CN106384266A (en) | Mobile internet-base fashion designer and buyer communion and trading system and method | |
| CN106326243A (en) | Data processing method and apparatus | |
| CN104318414A (en) | Commodity inventory management information system | |
| CN104318411A (en) | Enterprise inventory management system | |
| CN105279158A (en) | Hotel price ordering method based on complex query condition | |
| CN104299157A (en) | Fabric trading system and method | |
| CN104299139A (en) | Fabric trading system and method | |
| CN104299150A (en) | Fabric transaction system and method based on mobile client terminals | |
| CN110704486B (en) | Data processing method, device, system, storage medium and server | |
| CN107679889A (en) | The recognition methods of potential customers a kind of and terminal device | |
| CN112232733A (en) | Material introduction control method, system, terminal and storage medium | |
| US10504172B2 (en) | Systems and methods for collecting and updating online product content | |
| TWI609281B (en) | Cloud Instant Business Intelligence Module | |
| Ahmed et al. | The implementation Trends of Intelligence E-CRM in Business process | |
| US20190180223A1 (en) | Supply chain model generation system | |
| CN110910220A (en) | Electronic commerce system | |
| CN105279660A (en) | Method for realizing e-commerce platform for merchants in business circle | |
| Wang et al. | Optimization of asset management system based on computer aided technology of internet of things | |
| CN103455334A (en) | Invoicing system based on PHP-MySQL technology |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20150121 |