CN113312347A - Inventory management system and method - Google Patents
Inventory management system and method Download PDFInfo
- Publication number
- CN113312347A CN113312347A CN202011329250.1A CN202011329250A CN113312347A CN 113312347 A CN113312347 A CN 113312347A CN 202011329250 A CN202011329250 A CN 202011329250A CN 113312347 A CN113312347 A CN 113312347A
- Authority
- CN
- China
- Prior art keywords
- warehousing
- module
- documents
- data
- message data
- 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.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 23
- 239000000463 material Substances 0.000 claims abstract description 70
- 238000012423 maintenance Methods 0.000 claims abstract description 35
- 230000008859 change Effects 0.000 claims abstract description 22
- 238000012544 monitoring process Methods 0.000 claims abstract description 13
- 230000005540 biological transmission Effects 0.000 claims abstract description 10
- 238000012545 processing Methods 0.000 claims abstract description 8
- 238000004806 packaging method and process Methods 0.000 claims abstract description 5
- 238000007726 management method Methods 0.000 claims description 72
- 238000013524 data verification Methods 0.000 claims description 38
- 239000011232 storage material Substances 0.000 claims description 30
- 238000006243 chemical reaction Methods 0.000 claims description 12
- 230000008520 organization Effects 0.000 claims description 9
- 238000000429 assembly Methods 0.000 claims description 6
- 238000004364 calculation method Methods 0.000 claims description 6
- 230000000712 assembly Effects 0.000 claims description 4
- 230000002159 abnormal effect Effects 0.000 claims description 2
- 238000012795 verification Methods 0.000 claims description 2
- 238000013461 design Methods 0.000 abstract description 8
- 230000008569 process Effects 0.000 description 8
- 238000010586 diagram Methods 0.000 description 4
- 230000006870 function Effects 0.000 description 3
- 238000011161 development Methods 0.000 description 2
- 238000004590 computer program Methods 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2228—Indexing structures
- G06F16/2255—Hash tables
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/17—Details of further file system functions
- G06F16/1734—Details of monitoring file system events, e.g. by the use of hooks, filter drivers, logs
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/258—Data format conversion from or to a database
-
- 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
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Economics (AREA)
- Finance (AREA)
- Accounting & Taxation (AREA)
- Development Economics (AREA)
- Software Systems (AREA)
- Entrepreneurship & Innovation (AREA)
- Human Resources & Organizations (AREA)
- Marketing (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
Abstract
The invention provides an inventory management system and method, the system includes: the system comprises a client management module, a part type maintenance module, a BOM relationship maintenance module, an address maintenance module, a packaging code maintenance module, a material information maintenance module, a client information maintenance module, a message management module, a goods arrival notification module, an inventory return module, a sub-part change monitoring module, an assembly return module, an interface log module, an ASN exception recording module, an ASN ex-warehouse module and a mail recording module. The invention can transmit inventory change data in real time, reduces the intervention of manual operation, improves the data transmission timeliness and transmission quality, reduces the labor cost, effectively meets the requirements of respective product management of customers and suppliers by processing the assembly, can effectively monitor the change of the assembly or the information of the assembly through the design of the assembly change monitoring module and the assembly return module, and improves the accuracy of inventory management.
Description
Technical Field
The invention belongs to the field of logistics, and particularly relates to an inventory management system and method.
Background
With the rapid development of modern informatization, the introduction of networks and computers makes inventory management jump to a new development platform. The management of the enterprise will expand towards informatization, and the management of the inventory is particularly important for the enterprise. The inventory management system is an indispensable part of an enterprise, and the content of the inventory management system is crucial to decision makers and managers of the enterprise, so the inventory management system can provide sufficient information and a quick query means for clients. But have been managed in a traditional manual manner.
The traditional method of manually filling in documents and then inputting and recording the documents to a computer is generally adopted for the material warehouse-in/out, and the method has the defects that the workload is large, handwritten documents are easy to lose or fill in wrongly and are input to the computer, the time difference exists, the system stock and the material stock are asynchronous, and the accuracy of stock management is further reduced.
Disclosure of Invention
The embodiment of the invention aims to provide an inventory management system and method, and aims to solve the problem of low inventory management accuracy in the existing inventory management method.
The embodiment of the present invention is implemented as follows, and an inventory management system includes:
the client management module is used for managing the operation authorities corresponding to different clients;
the part type maintenance module is used for converting the information of the part type and issuing and returning the converted information;
the BOM relation maintenance module is used for processing the corresponding relation and the proportional relation between the assemblies and the sub-assemblies of the warehousing materials;
the address maintenance module is used for matching corresponding client information and address information according to the organization codes in the documents to be put in storage when the messages are returned;
the packaging code maintenance module is used for maintaining the corresponding relation between the materials and the packaging information;
the material information maintenance module is used for maintaining part codes, part types, sales organization codes and customer code information of materials and determining the corresponding sales organization codes and the customer code information according to the part codes and the part types;
the client information maintenance module is used for maintaining the client code and the client name information of the client;
the message management module is used for receiving the ASN information sent by the client and returning the original message of the client;
the delivery notification module is used for displaying the ASN information issued by the client;
the inventory passback module is used for displaying the message information returned to the client;
the sub-part change monitoring module is used for monitoring the change of the sub-part information;
the assembly returning module is used for returning the message information of the assembly;
the interface log module is used for recording the back transmission state of the interface log;
the ASN abnormity recording module is used for recording abnormal information when the warehoused materials are warehoused and the ASN information is not received;
the ASN ex-warehouse module is used for recording historical information of the materials from the cache position to the normal position;
and the mail recording module is used for notifying the mail to carry out warehousing of the materials and sending warehousing documents to the corresponding clients.
Further, the inventory management system further includes:
the warehousing check module is used for receiving warehousing documents and performing warehousing check on the warehousing documents;
the data verification module is used for carrying out format conversion on the warehousing documents to obtain warehousing message data and carrying out data verification on the warehousing message data if the warehousing verification of the warehousing documents is successful;
the address query module is used for acquiring a document identifier of the warehousing document and querying a client address according to the document identifier if the data verification of the warehousing message data is successful;
and the log storage module is used for sending the warehousing message data after data verification to the client address and generating a warehousing log according to the warehousing message data.
Further, the warehousing check module is further configured to:
acquiring the material type of the warehousing material in the warehousing receipt, and inquiring a warehousing address according to the material type;
acquiring the storage quantity of the storage materials corresponding to the warehousing address, and comparing the acquired storage quantity of the storage materials with the warehousing quantity of the warehousing materials in the warehousing documents;
if the storage quantity of the storage materials is the same as the warehousing quantity of the warehousing materials in the warehousing receipts, acquiring warehousing parameters of the warehousing materials;
inquiring storage parameters of the storage materials according to the parameter types of the warehousing parameters, and performing parameter comparison on the acquired storage parameters and the warehousing parameters;
and if the storage parameters are successfully compared with the parameters of the warehousing parameters, judging that warehousing check of the warehousing documents is successful.
Further, the data checking module is further configured to:
converting the warehousing documents into messages in an EDI format to obtain warehousing message data;
performing hash value calculation on the warehousing message data to obtain a warehousing hash value, and comparing the warehousing hash value with a preset hash value in the warehousing document;
if the warehousing hash value is successfully compared with the preset hash value, acquiring the data volume of the warehousing message data, and matching the data volume of the warehousing message data with a preset data volume range in the warehousing document;
and if the data volume of the warehousing message data is within the preset data volume range, judging that the data verification of the warehousing message data is successful.
Further, the warehousing check module is further configured to:
acquiring a combination proportion between an assembly and a sub-piece in the storage material, and comparing the combination proportion with a preset proportion in the warehousing document;
and if the combination proportion is not the same as the preset proportion, judging that the warehousing check of the warehousing documents is unsuccessful.
Another objective of an embodiment of the present invention is to provide an inventory management method, where the method includes:
receiving a warehousing bill, and performing warehousing check on the warehousing bill;
if the warehousing check of the warehousing documents is successful, carrying out format conversion on the warehousing documents to obtain warehousing message data, and carrying out data check on the warehousing message data;
if the data verification of the warehousing message data is successful, acquiring a document identification of the warehousing document, and inquiring a customer address according to the document identification;
and sending the warehousing message data after data verification to the client address, and generating a warehousing log according to the warehousing message data.
Further, the step of performing warehousing check on the warehousing documents comprises:
acquiring the material type of the warehousing material in the warehousing receipt, and inquiring a warehousing address according to the material type;
acquiring the storage quantity of the storage materials corresponding to the warehousing address, and comparing the acquired storage quantity of the storage materials with the warehousing quantity of the warehousing materials in the warehousing documents;
if the storage quantity of the storage materials is the same as the warehousing quantity of the warehousing materials in the warehousing receipts, acquiring warehousing parameters of the warehousing materials;
inquiring storage parameters of the storage materials according to the parameter types of the warehousing parameters, and performing parameter comparison on the acquired storage parameters and the warehousing parameters;
and if the storage parameters are successfully compared with the parameters of the warehousing parameters, judging that warehousing check of the warehousing documents is successful.
Further, the step of performing format conversion on the warehousing documents to obtain warehousing message data, and performing data verification on the warehousing message data comprises:
converting the warehousing documents into messages in an EDI format to obtain warehousing message data;
performing hash value calculation on the warehousing message data to obtain a warehousing hash value, and comparing the warehousing hash value with a preset hash value in the warehousing document;
if the warehousing hash value is successfully compared with the preset hash value, acquiring the data volume of the warehousing message data, and matching the data volume of the warehousing message data with a preset data volume range in the warehousing document;
and if the data volume of the warehousing message data is within the preset data volume range, judging that the data verification of the warehousing message data is successful.
Further, the step of performing warehousing check on the warehousing documents further comprises:
acquiring a combination proportion between an assembly and a sub-piece in the storage material, and comparing the combination proportion with a preset proportion in the warehousing document;
and if the combination proportion is not the same as the preset proportion, judging that the warehousing check of the warehousing documents is unsuccessful.
Further, the method further comprises:
if the warehousing check of the warehousing documents is unsuccessful, generating warehousing error records according to the warehousing documents;
and if the data verification of the warehousing message data is unsuccessful, generating a data verification error record according to the warehousing document.
The embodiment of the invention can transmit the inventory change data in real time, reduces the intervention of manual operation, improves the data transmission timeliness and transmission quality, reduces the labor cost, effectively meets the requirements of respective product management of customers and suppliers by processing the assembly, can effectively manage the operation authorities corresponding to different customers by the design of the customer management module, can effectively monitor the change of the assembly or the information of the assembly by the design of the sub-assembly change monitoring module and the assembly return module, and improves the accuracy of inventory management.
Drawings
Fig. 1 is a schematic structural diagram of an inventory management system according to a first embodiment of the present invention;
FIG. 2 is a schematic diagram of an inventory management system according to a second embodiment of the present invention;
FIG. 3 is a flow chart of a method for inventory management according to a third embodiment of the present invention;
the following detailed description will further illustrate the invention in conjunction with the above-described figures.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present invention more apparent, the technical solutions of the embodiments of the present invention will be described clearly and completely with reference to the accompanying drawings of the embodiments of the present invention, and it is obvious that the described embodiments are some, but not all embodiments of the present invention. All other embodiments, which can be obtained by a person skilled in the art without any inventive step based on the embodiments of the present invention, are within the scope of the present invention. Thus, the following detailed description of the embodiments of the present invention, presented in the figures, is not intended to limit the scope of the invention, as claimed, but is merely representative of selected embodiments of the invention. All other embodiments, which can be obtained by a person skilled in the art without any inventive step based on the embodiments of the present invention, are within the scope of the present invention.
Furthermore, the terms "first", "second" and "first" are used for descriptive purposes only and are not to be construed as indicating or implying relative importance or implicitly indicating the number of technical features indicated. Thus, a feature defined as "first" or "second" may explicitly or implicitly include one or more of that feature. In the description of the present invention, "a plurality" means two or more unless specifically defined otherwise.
In order to explain the technical means of the present invention, the following description will be given by way of specific examples.
Example one
Referring to fig. 1, a schematic structural diagram of an inventory management system 100 according to a first embodiment of the present invention is shown, including: a customer management module 10, a part type maintenance module 11, a BOM relationship maintenance module 12, an address maintenance module 13, a package code maintenance module 14, a material information maintenance module 15, a customer information maintenance module 16, a message management module 17, a delivery notification module 18, an inventory passback module 19, a sub-part change monitoring module 20, an assembly passback module 21, an interface log module 22, an ASN anomaly recording module 23, an ASN outbound module 24, and a mail recording module 25, wherein:
optionally, in this step, the client management module 10 may also be configured to perform operations such as adding, deleting, modifying, and querying user information.
The part type maintenance module 11 is configured to convert information of part types and issue and return converted information, where the part type maintenance module 11 is configured to convert information of part types in different languages into information of a preset language, where the preset language may be set according to requirements, and in this embodiment, the preset language is set to be chinese, that is, information of part types in different languages is all converted into chinese information, and the information converted into chinese is subjected to an operation of issuing and returning the information.
And the BOM (bill of material) relationship maintenance module 12 is used for processing the corresponding relationship and the proportional relationship between the assemblies and the sub-pieces of the warehousing materials, so that the management accuracy between the assemblies and the sub-pieces in the inventory management process is effectively improved.
The address maintenance module 13 is configured to match corresponding client information and address information according to the organization code in the document to be put in storage when returning the message, so as to effectively improve accuracy of querying the client information and the address information, and effectively improve accuracy of information returning based on the matched client information and address information.
The package code maintenance module 14 is configured to maintain a corresponding relationship between the material and the package information, where a package query list is stored in the package code maintenance module 14, and a corresponding relationship between different materials and corresponding package information is stored in the package query list, so that accuracy of matching query between the material and the package information is effectively improved based on the package code maintenance module 14.
And the material information maintenance module 15 is used for maintaining part codes, part types, sales organization codes and customer code information of materials, and determining the corresponding sales organization codes and the customer code information according to the part codes and the part types.
The client information maintenance module 16 is used for maintaining the client code and the client name information of the client, and the accuracy of client information maintenance in the inventory management process is effectively improved based on the client information maintenance module 16.
The message management module 17 is configured to receive ASN information (pre-delivery list) sent by a client and return an original message of the client, where based on the design of the message management module 17, the accuracy of ASN information and original message management is effectively improved.
The goods arrival notification module 18 is used for displaying the ASN information issued by the customer, wherein the ASN information issued by the customer is displayed, so that the staff can effectively and conveniently check the ASN information issued by the customer, and the inventory management efficiency is improved.
The inventory returning module 19 is used for displaying the message information returned to the client, wherein the returned message information is effectively and conveniently viewed by displaying the message information returned to the client.
And the sub-part change monitoring module 20 is used for monitoring the change of the sub-part information, wherein the accuracy of inventory management is effectively improved by monitoring the change of the sub-part information, and the change of the sub-part information can be timely processed.
The system comprises an assembly return module 21 for returning the message information of the assembly, an interface log module 22 for recording the return state of the interface log, an ASN exception recording module 23 for recording exception information when the warehousing material is warehoused and the ASN information is not received, an ASN warehouse-out module 24 for recording the history information of the material from the cache warehouse location to the normal warehouse location, and an email recording module 25 for notifying the warehousing of the material by email and sending warehousing documents to corresponding clients.
According to the embodiment, the inventory change data can be transmitted in real time, the intervention of manual operation is reduced, the data transmission timeliness and transmission quality are improved, the labor cost is reduced, the requirements of respective product management of customers and suppliers are effectively met by processing the assembly, the operation authorities corresponding to different customers can be effectively managed by the design of the customer management module, the change of the assembly or the information of the assembly can be effectively monitored by the design of the assembly change monitoring module and the assembly return module, and the accuracy of inventory management is improved.
Example two
Referring to fig. 2, a schematic structural diagram of an inventory management system 100a according to a second embodiment of the present invention is shown, and for the embodiment of fig. 1, the inventory management system 100a further includes:
and the warehousing check module 26 is used for receiving warehousing documents and performing warehousing check on the warehousing documents.
Wherein the warehousing check module 26 is further configured to: acquiring the material type of the warehousing material in the warehousing receipt, and inquiring a warehousing address according to the material type;
acquiring the storage quantity of the storage materials corresponding to the warehousing address, and comparing the acquired storage quantity of the storage materials with the warehousing quantity of the warehousing materials in the warehousing documents;
if the storage quantity of the storage materials is the same as the warehousing quantity of the warehousing materials in the warehousing receipts, acquiring warehousing parameters of the warehousing materials;
inquiring storage parameters of the storage materials according to the parameter types of the warehousing parameters, and performing parameter comparison on the acquired storage parameters and the warehousing parameters;
and if the storage parameters are successfully compared with the parameters of the warehousing parameters, judging that warehousing check of the warehousing documents is successful.
Optionally, the warehousing check module 26 is further configured to: acquiring a combination proportion between an assembly and a sub-piece in the storage material, and comparing the combination proportion with a preset proportion in the warehousing document;
and if the combination proportion is not the same as the preset proportion, judging that the warehousing check of the warehousing documents is unsuccessful.
And the data verification module 27 is configured to, if the warehousing check of the warehousing documents is successful, perform format conversion on the warehousing documents to obtain warehousing message data, and perform data verification on the warehousing message data.
Wherein the data checking module 27 is further configured to: converting the warehousing documents into messages in an EDI format to obtain warehousing message data;
performing hash value calculation on the warehousing message data to obtain a warehousing hash value, and comparing the warehousing hash value with a preset hash value in the warehousing document;
if the warehousing hash value is successfully compared with the preset hash value, acquiring the data volume of the warehousing message data, and matching the data volume of the warehousing message data with a preset data volume range in the warehousing document;
and if the data volume of the warehousing message data is within the preset data volume range, judging that the data verification of the warehousing message data is successful.
The address query module 28 is configured to, if the data verification of the warehousing message data is successful, obtain a document identifier of the warehousing document, and query a client address according to the document identifier;
and the log storage module 29 is configured to send the warehousing message data after data verification to the client address, and generate a warehousing log according to the warehousing message data.
Wherein, the log storage module 29 is further configured to: if the warehousing check of the warehousing documents is unsuccessful, generating warehousing error records according to the warehousing documents;
and if the data verification of the warehousing message data is unsuccessful, generating a data verification error record according to the warehousing document.
In the embodiment, the warehousing documents are received and warehoused according to the warehousing check module 26, so that whether the warehousing documents are correct or not can be effectively detected, the accuracy of warehousing materials in the inventory management process is improved, the warehousing message data is obtained by carrying out format conversion on the warehousing documents according to the data check module 27, the warehousing documents can be effectively converted into the preset format or language information, the warehousing documents are convenient to store, the accuracy of the warehousing message data can be effectively detected by carrying out data check on the warehousing message data, the accuracy of warehousing materials warehousing in the inventory management process is further improved, the identification of the warehousing documents is obtained according to the address query module 28, the client addresses are queried according to the document identification, the sending of the client address information and the returning of the information are effectively improved, the warehousing message data after data check is sent to the client addresses according to the log storage module 29, and the warehousing log is generated according to the warehousing message data, so that the warehousing message data and the warehousing message data issuing condition can be effectively recorded, and the management efficiency of inventory management is improved.
EXAMPLE III
Referring to fig. 3, a flowchart of an inventory management method according to a third embodiment of the present invention includes the steps of:
step S10, receiving the warehousing documents, and warehousing and checking the warehousing documents;
the warehousing documents are received and are subjected to warehousing check, whether the warehousing documents are correct or not can be effectively detected, and the accuracy of material warehousing in the inventory management process is improved.
Specifically, in this step, the step of performing warehousing check on the warehousing documents includes:
acquiring the material type of the warehousing material in the warehousing receipt, and inquiring a warehousing address according to the material type;
acquiring the storage quantity of the storage materials corresponding to the warehousing address, and comparing the acquired storage quantity of the storage materials with the warehousing quantity of the warehousing materials in the warehousing documents;
if the storage quantity of the storage materials is the same as the warehousing quantity of the warehousing materials in the warehousing receipts, acquiring warehousing parameters of the warehousing materials;
inquiring storage parameters of the storage materials according to the parameter types of the warehousing parameters, and performing parameter comparison on the acquired storage parameters and the warehousing parameters;
and if the storage parameters are successfully compared with the parameters of the warehousing parameters, judging that warehousing check of the warehousing documents is successful.
Further, in this step, the step of performing warehousing check on the warehousing documents further includes:
acquiring a combination proportion between an assembly and a sub-piece in the storage material, and comparing the combination proportion with a preset proportion in the warehousing document;
and if the combination proportion is not the same as the preset proportion, judging that the warehousing check of the warehousing documents is unsuccessful.
Step S20, if the warehousing check of the warehousing documents is successful, format conversion is carried out on the warehousing documents to obtain warehousing message data, and data check is carried out on the warehousing message data;
the warehousing documents are subjected to format conversion to obtain warehousing message data, the warehousing documents can be effectively converted into preset format or language information, the warehousing documents are convenient to store, the accuracy of the warehousing message data can be effectively detected through data verification of the warehousing message data, and the accuracy of material warehousing in the inventory management process is further improved.
Specifically, in this step, the step of performing format conversion on the warehousing documents to obtain warehousing message data, and performing data verification on the warehousing message data includes:
converting the warehousing documents into messages in an EDI format to obtain warehousing message data;
performing hash value calculation on the warehousing message data to obtain a warehousing hash value, and comparing the warehousing hash value with a preset hash value in the warehousing document;
if the warehousing hash value is successfully compared with the preset hash value, acquiring the data volume of the warehousing message data, and matching the data volume of the warehousing message data with a preset data volume range in the warehousing document;
and if the data volume of the warehousing message data is within the preset data volume range, judging that the data verification of the warehousing message data is successful.
Step S30, if the data verification of the warehousing message data is successful, acquiring a bill identification of the warehousing bill, and inquiring a customer address according to the bill identification;
the method and the device have the advantages that the bill identification of the documents put in storage is obtained, and the customer address is inquired according to the bill identification, so that the sending of the customer address information and the returning of the information are effectively improved.
And step S40, sending the warehousing message data after data verification to the client address, and generating a warehousing log according to the warehousing message data.
The warehousing message data after data verification is sent to the client address, and the warehousing log is generated according to the warehousing message data, so that the warehousing message data and the warehousing message data issuing condition can be effectively recorded, and the management efficiency of inventory management is improved.
Specifically, in this embodiment, the method further includes:
if the warehousing check of the warehousing documents is unsuccessful, generating warehousing error records according to the warehousing documents;
and if the data verification of the warehousing message data is unsuccessful, generating a data verification error record according to the warehousing document.
According to the embodiment, the inventory change data can be transmitted in real time, the intervention of manual operation is reduced, the data transmission timeliness and transmission quality are improved, the labor cost is reduced, the requirements of respective product management of customers and suppliers are effectively met by processing the assembly, the operation authorities corresponding to different customers can be effectively managed by the design of the customer management module, the change of the assembly or the information of the assembly can be effectively monitored by the design of the assembly change monitoring module and the assembly return module, and the accuracy of inventory management is improved.
Further, in the embodiment, by receiving the warehousing documents and performing warehousing check on the warehousing documents, whether the warehousing documents are correct or not can be effectively detected, so that the accuracy of warehousing materials in the inventory management process is improved, the warehousing message data is obtained by performing format conversion on the warehousing documents, the warehousing documents can be effectively converted into the preset format or language information, the storage of the warehousing documents is facilitated, the accuracy of the warehousing message data can be effectively detected by performing data check on the warehousing message data, the accuracy of warehousing materials in the inventory management process is further improved, the customer address is inquired according to the document identification by acquiring the document identification of the warehousing documents, the sending of the customer address information and the return of the information are effectively improved, the warehousing message data after data check is sent to the customer address, and a warehousing log is generated according to the warehousing message data, the method can effectively record the warehousing message data and the warehousing message data issuing condition, and improves the management efficiency of inventory management.
It will be apparent to those skilled in the art that, for convenience and brevity of description, only the above-mentioned division of the functional units and modules is used as an example, in practical applications, the above-mentioned function distribution may be performed by different functional units or modules according to needs, that is, the internal structure of the storage device is divided into different functional units or modules to perform all or part of the above-mentioned functions. Each functional unit and module in the embodiments may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit, and the integrated unit may be implemented in a form of hardware, or may be implemented in a form of software functional unit. In addition, specific names of the functional units and modules are only for convenience of distinguishing from each other, and are not used for limiting the protection scope of the present application.
Those skilled in the art will appreciate that the components shown in FIG. 2 are not intended to be limiting of the inventory management system of the present invention and may include more or fewer components than shown, or some components in combination, or a different arrangement of components, and that the inventory management method of FIG. 3 may also be implemented using more or fewer components than shown in FIG. 2, or some components in combination, or a different arrangement of components. The units, modules, etc. referred to herein are a series of computer programs capable of being executed by a processor (not shown) of the target inventory management system and functioning to perform certain functions, all of which may be stored in a storage device (not shown) of the target inventory management system.
The above description is only for the purpose of illustrating the preferred embodiments of the present invention and is not to be construed as limiting the invention, and any modifications, equivalents and improvements made within the spirit and principle of the present invention are intended to be included within the scope of the present invention.
Claims (10)
1. An inventory management system, the system comprising:
the client management module is used for managing the operation authorities corresponding to different clients;
the part type maintenance module is used for converting the information of the part type and issuing and returning the converted information;
the BOM relation maintenance module is used for processing the corresponding relation and the proportional relation between the assemblies and the sub-assemblies of the warehousing materials;
the address maintenance module is used for matching corresponding client information and address information according to the organization codes in the documents to be put in storage when the messages are returned;
the packaging code maintenance module is used for maintaining the corresponding relation between the materials and the packaging information;
the material information maintenance module is used for maintaining part codes, part types, sales organization codes and customer code information of materials and determining the corresponding sales organization codes and the customer code information according to the part codes and the part types;
the client information maintenance module is used for maintaining the client code and the client name information of the client;
the message management module is used for receiving the ASN information sent by the client and returning the original message of the client;
the delivery notification module is used for displaying the ASN information issued by the client;
the inventory passback module is used for displaying the message information returned to the client;
the sub-part change monitoring module is used for monitoring the change of the sub-part information;
the assembly returning module is used for returning the message information of the assembly;
the interface log module is used for recording the back transmission state of the interface log;
the ASN abnormity recording module is used for recording abnormal information when the warehoused materials are warehoused and the ASN information is not received;
the ASN ex-warehouse module is used for recording historical information of the materials from the cache position to the normal position;
and the mail recording module is used for notifying the mail to carry out warehousing of the materials and sending warehousing documents to the corresponding clients.
2. The inventory management system as recited in claim 1 further comprising:
the warehousing check module is used for receiving warehousing documents and performing warehousing check on the warehousing documents;
the data verification module is used for carrying out format conversion on the warehousing documents to obtain warehousing message data and carrying out data verification on the warehousing message data if the warehousing verification of the warehousing documents is successful;
the address query module is used for acquiring a document identifier of the warehousing document and querying a client address according to the document identifier if the data verification of the warehousing message data is successful;
and the log storage module is used for sending the warehousing message data after data verification to the client address and generating a warehousing log according to the warehousing message data.
3. The inventory management system of claim 2, wherein said warehousing check-up module is further configured to:
acquiring the material type of the warehousing material in the warehousing receipt, and inquiring a warehousing address according to the material type;
acquiring the storage quantity of the storage materials corresponding to the warehousing address, and comparing the acquired storage quantity of the storage materials with the warehousing quantity of the warehousing materials in the warehousing documents;
if the storage quantity of the storage materials is the same as the warehousing quantity of the warehousing materials in the warehousing receipts, acquiring warehousing parameters of the warehousing materials;
inquiring storage parameters of the storage materials according to the parameter types of the warehousing parameters, and performing parameter comparison on the acquired storage parameters and the warehousing parameters;
and if the storage parameters are successfully compared with the parameters of the warehousing parameters, judging that warehousing check of the warehousing documents is successful.
4. The inventory management system of claim 2, wherein said data verification module is further configured to:
converting the warehousing documents into messages in an EDI format to obtain warehousing message data;
performing hash value calculation on the warehousing message data to obtain a warehousing hash value, and comparing the warehousing hash value with a preset hash value in the warehousing document;
if the warehousing hash value is successfully compared with the preset hash value, acquiring the data volume of the warehousing message data, and matching the data volume of the warehousing message data with a preset data volume range in the warehousing document;
and if the data volume of the warehousing message data is within the preset data volume range, judging that the data verification of the warehousing message data is successful.
5. The inventory management system of claim 3, wherein said warehousing check-up module is further configured to:
acquiring a combination proportion between an assembly and a sub-piece in the storage material, and comparing the combination proportion with a preset proportion in the warehousing document;
and if the combination proportion is not the same as the preset proportion, judging that the warehousing check of the warehousing documents is unsuccessful.
6. An inventory management method, the method comprising:
receiving a warehousing bill, and performing warehousing check on the warehousing bill;
if the warehousing check of the warehousing documents is successful, carrying out format conversion on the warehousing documents to obtain warehousing message data, and carrying out data check on the warehousing message data;
if the data verification of the warehousing message data is successful, acquiring a document identification of the warehousing document, and inquiring a customer address according to the document identification;
and sending the warehousing message data after data verification to the client address, and generating a warehousing log according to the warehousing message data.
7. The inventory management method of claim 6, wherein said step of warehousing said warehoused documents comprises:
acquiring the material type of the warehousing material in the warehousing receipt, and inquiring a warehousing address according to the material type;
acquiring the storage quantity of the storage materials corresponding to the warehousing address, and comparing the acquired storage quantity of the storage materials with the warehousing quantity of the warehousing materials in the warehousing documents;
if the storage quantity of the storage materials is the same as the warehousing quantity of the warehousing materials in the warehousing receipts, acquiring warehousing parameters of the warehousing materials;
inquiring storage parameters of the storage materials according to the parameter types of the warehousing parameters, and performing parameter comparison on the acquired storage parameters and the warehousing parameters;
and if the storage parameters are successfully compared with the parameters of the warehousing parameters, judging that warehousing check of the warehousing documents is successful.
8. The inventory management method according to claim 6, wherein the step of performing format conversion on the warehousing documents to obtain warehousing message data, and performing data verification on the warehousing message data comprises:
converting the warehousing documents into messages in an EDI format to obtain warehousing message data;
performing hash value calculation on the warehousing message data to obtain a warehousing hash value, and comparing the warehousing hash value with a preset hash value in the warehousing document;
if the warehousing hash value is successfully compared with the preset hash value, acquiring the data volume of the warehousing message data, and matching the data volume of the warehousing message data with a preset data volume range in the warehousing document;
and if the data volume of the warehousing message data is within the preset data volume range, judging that the data verification of the warehousing message data is successful.
9. The inventory management method of claim 7, wherein said step of warehousing said warehoused documents further comprises:
acquiring a combination proportion between an assembly and a sub-piece in the storage material, and comparing the combination proportion with a preset proportion in the warehousing document;
and if the combination proportion is not the same as the preset proportion, judging that the warehousing check of the warehousing documents is unsuccessful.
10. The inventory management method of claim 6, wherein said method further comprises:
if the warehousing check of the warehousing documents is unsuccessful, generating warehousing error records according to the warehousing documents;
and if the data verification of the warehousing message data is unsuccessful, generating a data verification error record according to the warehousing document.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011329250.1A CN113312347B (en) | 2020-11-24 | 2020-11-24 | Inventory management system and method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011329250.1A CN113312347B (en) | 2020-11-24 | 2020-11-24 | Inventory management system and method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN113312347A true CN113312347A (en) | 2021-08-27 |
| CN113312347B CN113312347B (en) | 2024-08-06 |
Family
ID=77370365
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011329250.1A Active CN113312347B (en) | 2020-11-24 | 2020-11-24 | Inventory management system and method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113312347B (en) |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20030074284A1 (en) * | 2001-10-16 | 2003-04-17 | Sumitomo Corporation Of America | System and method for forecasting material requirements and managing the accessability of the materials |
| US20090254572A1 (en) * | 2007-01-05 | 2009-10-08 | Redlich Ron M | Digital information infrastructure and method |
| WO2011029343A1 (en) * | 2009-09-14 | 2011-03-17 | 中兴通讯股份有限公司 | Name-address mapping system and data transmission method of locator and identifier separation protocol (lisp) network |
| CN104574010A (en) * | 2014-12-16 | 2015-04-29 | 天津中远国际航空货运代理有限公司 | Customs warehousing and customs affair management system as well as customs warehousing and customs affair management method |
| CN107888409A (en) * | 2017-10-23 | 2018-04-06 | 南京南瑞集团公司 | A kind of communication network configuration data automatic synchronous method with self-healing ability |
| CN111813857A (en) * | 2020-07-02 | 2020-10-23 | 珑门汽车科技(上海)有限公司 | Detection data management system and method based on block chain technology |
-
2020
- 2020-11-24 CN CN202011329250.1A patent/CN113312347B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20030074284A1 (en) * | 2001-10-16 | 2003-04-17 | Sumitomo Corporation Of America | System and method for forecasting material requirements and managing the accessability of the materials |
| US20090254572A1 (en) * | 2007-01-05 | 2009-10-08 | Redlich Ron M | Digital information infrastructure and method |
| WO2011029343A1 (en) * | 2009-09-14 | 2011-03-17 | 中兴通讯股份有限公司 | Name-address mapping system and data transmission method of locator and identifier separation protocol (lisp) network |
| CN104574010A (en) * | 2014-12-16 | 2015-04-29 | 天津中远国际航空货运代理有限公司 | Customs warehousing and customs affair management system as well as customs warehousing and customs affair management method |
| CN107888409A (en) * | 2017-10-23 | 2018-04-06 | 南京南瑞集团公司 | A kind of communication network configuration data automatic synchronous method with self-healing ability |
| CN111813857A (en) * | 2020-07-02 | 2020-10-23 | 珑门汽车科技(上海)有限公司 | Detection data management system and method based on block chain technology |
Non-Patent Citations (3)
| Title |
|---|
| 云威;葛化敏;朱新龙;: "开源电商物流信息系统解决方案", 计算机技术与发展, no. 12, 10 December 2012 (2012-12-10) * |
| 张莉萍;: "库存管理系统", 考试周刊, no. 01 * |
| 高峰;: "商用数据库技术及其气象应用", 气象科技, no. 1, 15 December 2007 (2007-12-15) * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN113312347B (en) | 2024-08-06 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11836669B2 (en) | Disaggregation events and decommissioning events | |
| US9521104B2 (en) | Outgoing communications inventory | |
| US9268763B1 (en) | Automatic interpretive processing of electronic transaction documents | |
| US11010719B1 (en) | Systems and methods for detecting errors of asynchronously enqueued requests | |
| US11645263B2 (en) | Systems and methods for managing a highly available and scalable distributed database in a cloud computing environment | |
| KR20100127504A (en) | System and method for managing delivery of on-line shopping mall order commodities | |
| KR102523033B1 (en) | Systems and methods for breaking up select requests to streamline processes and improve scalability | |
| CN114757619A (en) | Package transportation state identification method and related equipment | |
| CN113312347A (en) | Inventory management system and method | |
| US20070156977A1 (en) | Automatic location data determination in an electronic document | |
| CN112434987A (en) | Material warehouse entry and exit management system | |
| CN114493159B (en) | Node position verification method and device based on MES system | |
| US20130300562A1 (en) | Generating delivery notification | |
| US11256714B1 (en) | Systems and methods for managing event storage | |
| CN113034030A (en) | Information acquisition method and device, computer readable storage medium and electronic equipment | |
| CN112862390A (en) | Warehouse inventory query method and device, electronic equipment and storage medium | |
| CN117056433A (en) | Data report management method, device, terminal equipment and storage medium | |
| CN115545838A (en) | Order data processing method and device, electronic equipment and storage medium | |
| CN116070892A (en) | Document processing flow monitoring method and device, electronic equipment and storage medium | |
| US20090276339A1 (en) | Receiving check and balance system | |
| CN116483880A (en) | Method, device, equipment and storage medium for allocating bill | |
| JP5078601B2 (en) | Product master comprehensive generation server and product master comprehensive generation system | |
| CN114254015A (en) | Service data checking method and device, electronic equipment and readable storage medium | |
| CN115756575A (en) | Submission record acquisition method, device, equipment and storage medium | |
| KR20220093036A (en) | Systems and methods to streamline the selection process to improve scalability |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |