Inventory management system and electronic equipment

Abstract

According to the inventory management system and the electronic equipment provided by the invention, the function module is arranged, and the function module is used for recording at least one piece of operation flow data corresponding to the commodity under the management operation in the data table based on the management operation of any operation type executed on the commodity by the user, the operation flow data at least comprises the corresponding operation flow data, recorded by the two function units, of the commodities under the management operations of different operation types, and different management operations of all the commodities can be written into the same data table, so that the management process of the commodities is comprehensively recorded; according to the invention, different inventory operations do not need to be written into different data tables, so that during commodity management, various data tables do not need to be called, the commodity management efficiency and accuracy are improved, and the management cost of an enterprise can be reduced.

Description

Technical Field

[0001] The present application belongs to the technical field of commodity management, and in particular, relates to an inventory management system and electronic equipment. Background Art

[0002] In traditional material management methods, material operation information often relies on manual recording and management. This method has many limitations, such as incomplete and inaccurate information recording, low query and analysis efficiency, and difficulty in achieving real-time monitoring and traceability of the material management process. In order to solve this problem, some material management systems are provided in the relevant technology. The material management system records different inventory management operations in corresponding data tables. For example, the receiving operation is recorded in one data table, the scrapping operation is recorded in one data table, and the inventory transfer and movement operations are recorded in one corresponding data table. When commodity management is required, different data tables are usually needed to be called for analysis and statistics, which is cumbersome and inefficient. Summary of the invention

[0003] In response to the above-mentioned problems, the embodiments of the present application provide an inventory management system and an electronic device to solve the problem of cumbersome operations in inventory management in the related art.

[0004] In a first aspect, an embodiment of the present application provides an inventory management system, the system comprising a functional module, the functional module being used to record, in a data table, at least one operation flow data corresponding to the commodity under any operation type of management operation performed by a user on the commodity, so as to obtain operation flow data corresponding to the commodity under management operations of different operation types recorded by at least two functional units; wherein,

[0005] The data table includes multiple fields, different fields are used to indicate different information of the commodity, any functional unit is associated with at least one first field and a second field among the multiple fields, the at least one first field associated with different functional units is the same, and the second field is different, and the operation flow data recorded by any functional unit includes at least information indicated by the at least one first field and information indicated by the second field.

[0006] In some embodiments, the functional module includes: a first functional unit, the management operation is used to change the inventory quantity of the product, and the first functional unit is used to record in the data table an operation flow data corresponding to the product under the management operation based on the management operation.

[0007] In some embodiments, the management operation is a first management operation, the first management operation is used to instruct the commodity to be put into storage, and the first functional unit is used to obtain the type information of the warehouse receiving the commodity and the property rights settlement information of the commodity, wherein the property rights settlement information includes: the type information of the warehouse for settling property rights; the first functional unit is used to determine the property rights information of the commodity based on the type information of the warehouse and the type information of the warehouse for settling property rights; and is used to record the operation flow data corresponding to the commodity under the first management operation in the data table based on the property rights information.

[0008] In some embodiments, the warehouse for settling property rights is on a preset warehousing path, and the first functional unit is specifically configured to perform the following steps:

[0009] In the case where the type information of the warehouse matches the type information of the warehouse for settling property rights, determining that the property rights information of the commodity is the property rights of the buyer's company;

[0010] In the case where the type information of the warehouse does not match the type information of the warehouse for settling property rights, the property rights information of the goods is determined based on the position of the warehouse on the warehousing path.

[0011] In some embodiments, the first functional unit is specifically used to: when the position is before the warehouse for settling property rights, determine that the property rights information of the commodity is the property rights of the seller's company; when the position is after the warehouse for settling property rights, determine that the property rights information of the commodity is the property rights of the buyer's company.

[0012] In some embodiments, the functional module also includes: a second functional unit, when the management operation is a preset type of management operation, the second functional unit is used to generate at least two adjacent rows of the operation flow data in the data table based on the management operation, wherein the preset type of management operation includes: a management operation for changing the warehouse where the goods are located, a management operation for changing the storage form of the goods, a management operation for changing the commodity status of the goods, and at least one of the management operations for changing the property rights of the goods, one row of operation flow data is at least used to record the quantity of the changed goods, and another row of operation flow data is at least used to record the information of the changed goods.

[0013] In some embodiments, the inventory management system further comprises:

[0014] A first output module, configured to output configuration options in response to obtaining a configuration operation of the data table, wherein the configuration options at least include: an add field option and a delete field option;

[0015] A generating module is used to configure the data table in response to the operation on the configuration option and generate the data table.

[0016] In some embodiments, the first field includes: a product number field, and the second field includes: at least one of: product storage form, product status, warehouse information, and property rights information.

[0017] In some embodiments, the inventory management system further comprises:

[0018] A screening module, configured to respond to a trigger operation of a pre-configured target screening option and screen the operation flow data corresponding to the target screening option from the data table;

[0019] The second output module is used to output the operation flow data corresponding to the target screening option.

[0020] In some embodiments, the inventory management system further comprises:

[0021] The statistics module is used to respond to the trigger operation of the pre-configured target statistical option, collect statistics on the data corresponding to the target statistical option in the data table, and generate a statistical report.

[0022] In a second aspect, an embodiment of the present application provides an electronic device, including: the inventory management system provided in the first aspect.

[0023] Compared with the prior art, the embodiments of the present invention have the following beneficial effects:

[0024] The inventory management system provided by the embodiment of the present application sets a functional module, which is used to record at least one operation flow data corresponding to the commodity under any operation type of management operation performed by the user on the commodity in a data table, so as to obtain operation flow data corresponding to the commodity under different operation types of management operations recorded by at least two functional units. Different management operations for all commodities can be written into the same data table, so that the management process of the commodity is fully recorded, and there is no need to write different inventory operations to different data tables respectively. Therefore, when managing commodities, there is no need to call multiple data tables, thereby improving the efficiency and accuracy of commodity management, thereby reducing the management cost of the enterprise.

[0025] It can be understood that the beneficial effects of the second aspect mentioned above can be found in the relevant description of the first aspect mentioned above, and will not be repeated here. BRIEF DESCRIPTION OF THE DRAWINGS

[0026] In order to more clearly illustrate the technical solutions in the embodiments of the present application, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present application. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative labor.

[0027] Figure 1 A development diagram of an inventory management system provided in the related art;

[0028] Figure 2 A schematic diagram of the structure of an inventory management system provided by the present application;

[0029] Figure 3 A schematic diagram of the development of an inventory management system provided in an embodiment of the present application;

[0030] Figure 4 A schematic diagram of a data table provided in an embodiment of the present application;

[0031] Figure 5 A schematic diagram of operation flow data corresponding to a receiving operation in which a commodity storage form is a material box provided in an embodiment of the present application;

[0032] Figure 6 A schematic diagram of operation flow data corresponding to a warehousing operation based on the commodity form provided in an embodiment of the present application;

[0033] Figure 7 A schematic diagram of operation flow data corresponding to a scrap management operation provided in an embodiment of the present application;

[0034] Figure 8 A schematic diagram of operation flow data in a data table for a management operation for changing a warehouse where a commodity is located and a management operation for changing a storage form of a commodity provided in an embodiment of the present application;

[0035] Fig. 9 A schematic diagram of operation flow data corresponding to a management operation for changing the storage form of a commodity provided in an embodiment of the present application;

[0036] Fig.10 A schematic diagram of a management operation for a commodity provided in an embodiment of the present application, which is freezing corresponding operation flow data;

[0037] Fig.11 A schematic diagram of the structure of an electronic device provided in an embodiment of the present application. DETAILED DESCRIPTION

[0038] In the following description, specific details such as specific system structures, technologies, etc. are provided for the purpose of illustration rather than limitation, so as to provide a thorough understanding of the embodiments of the present application. However, it should be clear to those skilled in the art that the present application may also be implemented in other embodiments without these specific details. In other cases, detailed descriptions of well-known systems, devices, circuits, and methods are omitted to prevent unnecessary details from obstructing the description of the present application.

[0039] It should be understood that when used in the present specification and the appended claims, the term "comprising" indicates the presence of described features, wholes, steps, operations, elements and / or components, but does not exclude the presence or addition of one or more other features, wholes, steps, operations, elements, components and / or combinations thereof.

[0040] It should also be understood that the term “and / or” used in the specification and appended claims refers to any and all possible combinations of one or more of the associated listed items, and includes these combinations.

[0041] As used in the specification of this application and the appended claims, the term "if" can be interpreted as "when" or "uponce" or "in response to determining" or "in response to detecting" depending on the context. Similarly, the phrases "if it is determined" or "if it is detected" can be interpreted as meaning "uponce it is determined" or "in response to determining" or "uponce detected" or "in response to detecting" depending on the context.

[0042] In addition, in the description of the present application specification and the appended claims, the terms "first", "second", "third", etc. are only used to distinguish the descriptions and cannot be understood as indicating or implying relative importance.

[0043] References to "one embodiment" or "some embodiments" etc. described in the specification of this application mean that one or more embodiments of the present application include specific features, structures or characteristics described in conjunction with the embodiment. Therefore, the phrases "in one embodiment", "in some embodiments", "in some other embodiments", "in some other embodiments", etc. appearing in different places in this specification do not necessarily refer to the same embodiment, but mean "one or more but not all embodiments", unless otherwise specifically emphasized in other ways.

[0044] Before introducing the embodiments of the present application, a brief introduction to the related technologies is given. Figure 1 A development diagram of an inventory management system provided in the related art, such as Figure 1As shown, when developing a traditional inventory management system, the requirements are usually clarified first, such as which inventory management operations are there for goods (such as receiving goods, scrapping, and inventory transfer), and the inventory management operations are listed one by one. Then, the business requirements of each operation are clarified, and different [functional modules] are developed respectively. Different functional modules correspond to different data tables. For example, receiving goods corresponds to a functional module 1, and functional module 1 corresponds to a data table. The data table corresponding to functional module 1 is used to record the operation flow data of management operations related to receiving goods. Scrapping corresponds to functional module 2, and functional module 2 corresponds to a data table. The data table corresponding to functional module 2 is used to record the operation flow data related to scrapping management operations. Inventory transfer corresponds to functional module 3, and functional module 3 corresponds to a data table. The data table corresponding to functional module 3 is used to record the operation flow data related to inventory transfer. Inventory transfer sales corresponds to function module 4, function module 4 corresponds to a data table, material box palletizing corresponds to function module 5, function module 5 corresponds to a data table, and so on. When an inventory management operation of a commodity is detected, the operation will be identified and then stored in the corresponding data table through different function modules. For example, when the management operation of receiving goods is identified, function module 1 is called to store the operation flow data in the data table corresponding to function module 1. The management operations of other operation types are similar. When commodity management is required, different data tables are usually required to be called for analysis and statistics, which makes the operation cumbersome and the management efficiency low.

[0045] Based on the technical problems of the related technology, an embodiment of the present application provides an inventory management system, wherein each module included in the system and each unit included in each module can be implemented by a processor in a computer device; of course, it can also be implemented by a specific logic circuit; in the implementation process, the processor can be a central processing unit (CPU, Central Processing Unit), a microprocessor (MPU, Microprocessor Unit), a digital signal processor (DSP, Digital Signal Processing) or a field programmable gate array (FPGA, Field Programmable Gate Array), etc.

[0046] Specifically, the inventory management system can be deployed in an electronic device, and the inventory management system can be a WEB system or an APP installed in the electronic device. Alternatively, the user can access the inventory management system through a website.

[0047] The present application embodiment provides an inventory management system. Figure 2 A schematic diagram of the structure of an inventory management system provided in an embodiment of the present application is shown in FIG. Figure 2As shown, the system includes a function module. The function module is used to record at least one operation flow data corresponding to the commodity under any operation type management operation performed by the user on the commodity in a data table, so that the data table at least includes at least one operation flow data corresponding to the commodity under different operation types of management operations; wherein the data table includes multiple fields, different fields are used to indicate different information of the commodity, the operation flow data at least includes information indicated by at least one first field and information indicated by a second field among the multiple fields, and the operation flow data corresponding to different operation types of management operations include the same at least one first field, and different second fields.

[0048] As an example, Figure 2 The functional module shown may include multiple functional units ( Figure 2 Only two functional units are used as an example), one of the functional units corresponds to a management operation of one operation type performed by a user on a commodity, and different functional units correspond to management operations of different operation types; wherein any of the functional units is used to record at least one operation flow data corresponding to the commodity under the management operation in a data table based on the management operation performed by the user on the commodity, so that the data table includes at least two operation flow data corresponding to the commodity under management operations of different operation types recorded by the functional units; wherein,

[0049] The data table includes multiple fields, different fields are used to indicate different information of the commodity, any functional unit is associated with at least one first field and a second field among the multiple fields, the at least one first field associated with different functional units is the same, and the second field is different, and the operation flow data recorded by any functional unit includes at least information indicated by the at least one first field and information indicated by the second field.

[0050] In an embodiment of the present application, the functional unit is used to record the operation flow data corresponding to the commodity under the management operations of different operation types in the same data table. For example, functional unit 1 is used to record at least one operation flow data corresponding to the commodity under the management operation of operation type 1 in the data table, wherein functional module 1 corresponds to the management operation of operation type 1. Functional module 2 is used to record at least one operation flow data corresponding to the commodity under the management operation of operation type 2 in the data table, wherein functional module 2 corresponds to the management operation of operation type 2. In this way, if the user triggers the management operation of operation type 1 and the management operation of operation type 2 for the commodity respectively, then at least 2 operation flow data will be recorded in the data table, wherein 1 operation flow data corresponds to the management operation of operation type 1, and the other operation flow data corresponds to the management operation of operation type 2.

[0051] As an example, one operation flow data in the embodiment of the present application may occupy a row in the data table, and each of the first field and the second field may occupy a column.

[0052] In the embodiment of the present application, the commodity may be a material, which refers to various raw materials, parts, semi-finished products or finished products required in the production or operation process. For example, in the automobile manufacturing industry, materials may include steel, electronic components, mechanical parts, etc.

[0053] The following uses commodities as materials as an example to explain that management operations refer to various types of operation events that occur during inventory management, production processes, or logistics processes. Operation types can include: warehousing, outbound, transfer, scrapping, relocation, changing storage status, changing material status, changing property rights, etc. Operation types can also be called movement types. Storage status can include: pallet storage, material box storage, loose parts storage, etc. Storage status can also be called material form, and material status can include: available, frozen, quality inspection, etc.

[0054] In the embodiment of the present application, the inventory management system can obtain the management operation of the material, and the inventory management system can monitor the operation events of the material in real time and automatically capture the management operation. The management operation can also be obtained by manual input, scanning a bar code or a QR code, etc.

[0055] For example, taking scanning a barcode for storage as an example, a user can generate a management operation for material storage by operating the QR code on the material. For example, the management operation for the material is: Zhang San stores 100 pieces of material X in warehouse A to shelf B.

[0056] In the embodiment of the present application, the management operations performed on the commodity during the inventory management process of the material can be obtained regularly or in real time, so as to record at least one operation flow data corresponding to the commodity under the management operation.

[0057] In the embodiment of the present application, a data table is a structure used to store and manage data in a database. It is usually composed of rows and columns, where each row represents an operation flow data. A data table is used to record and manage the operation flow data corresponding to all management operations of a material. A data table may contain one or more fields, and different fields indicate different contents.

[0058] For example, Figures 4 to 10 In the data table shown, the multiple fields may include material number, material storage form, material status, warehouse information, property information, etc. In some embodiments, the multiple fields may also include: operation time, account voucher, etc. The multiple fields of the data table may include all attributes involved in inventory management.

[0059] In the embodiment of the present application, the material number is a code or number that uniquely identifies a material. The material number is used to uniquely identify a material in a data table for easy query and management. The material storage form refers to the physical state or form of the material in storage, for example, it can be: pallet storage, material box storage, and bulk storage. The material status refers to the current status of the material in inventory management. The material status may include: available, unavailable / frozen, quality inspection, scrapped, etc. Warehouse information includes the specific location of commodity storage, which may include information such as company, warehouse number, warehouse area, and warehouse location. For example, warehouse information may be: warehouse number A, warehouse area B, and warehouse location C. Property rights information refers to the ownership or property rights status of the material. The property rights information is used to indicate the owner of the material, such as company property rights, supplier property rights (VMI, Vendor Managed Inventory), etc. Supplier property rights can also be called: partner property rights, supplier assets, supplier property rights, supplier assets, etc., and company property rights can also be called company assets.

[0060] In the embodiment of the present application, any changes in any field will be recorded in the data table.

[0061] In the embodiment of the present application, after obtaining the management operation performed by the user on the commodity, the inventory management system will identify the management operation and call different functional units according to the operation type of the management operation to record the management operation in the data table, thereby obtaining an operation flow data. The inventory management system can parse the management operation and then insert the parsed information into the data table. For example, the parsed information may include: the material number, operation type, material status, material storage form, etc. of the material, and the newly recorded operation flow data will be added to the data table.

[0062] In an embodiment of the present application, management operations of different operation types correspond to different functional units. For example, a management operation of operation type receiving corresponds to a receiving functional unit, a management operation of operation type transferring warehouse corresponds to a transferring warehouse functional unit, and a management operation of operation type scrapping corresponds to a scrapping functional unit. The operation flow data recorded by different management units are all written into the data table. Figure 3 A schematic diagram of the development of an inventory management system provided in an embodiment of the present application is shown in FIG. Figure 3 As shown, a functional module is developed for receiving, scrapping, inventory transfer, palletizing, and inventory operations. This functional module corresponds to a data table, and a large table data structure is used to record all inventory operations without distributed development in different table structures.

[0063] Take commodities as materials as an example. Figure 4 A schematic diagram of a data table provided in an embodiment of the present application, such as Figure 4 As shown, the data table records the operation flow data of all management operations of the same material. Each row in the data table represents an operation flow data corresponding to a management operation performed on the material. It can be seen that the change of commodity form, quantity, commodity status, movement type, property right, and storage location of the material (such as material number P001AA) will record the operation flow data in the data table.

[0064] In the embodiment of the present application, the first field includes: a product number field, and the second field includes: at least one of: product storage form, product status, warehouse information, and property rights information. In the embodiment of the present application, in the data table, the column corresponding to the product number field records the product number, the column corresponding to the product storage form field records the product storage form, the column corresponding to the product status field records the product status, and so on. The columns corresponding to each field are used to record corresponding information.

[0065] In the embodiment of the present application, the at least one first field associated with different functional units is the same, and the second field is different. For example, the second field corresponding to the receiving functional unit can be warehousing, the second field corresponding to the scrapping functional unit can be scrapping, the second field corresponding to the transfer functional unit can be transfer, and so on.

[0066] The inventory management system provided in the embodiment of the present application is used to obtain management operations of any operation type performed by a user on a product through a functional module, and record at least one operation flow data corresponding to the product under the management operation in a data table, so that the data table at least includes at least one operation flow data corresponding to the product under management operations of different operation types. Different management operations for all products can be written into the same data table, so that the management process of the product is fully recorded, and there is no need to write different inventory operations to different database tables respectively. Therefore, when managing products, there is no need to call multiple data tables, thereby improving the efficiency and accuracy of product management, thereby reducing the management cost of the enterprise.

[0067] In some embodiments, the functional unit includes: a first functional unit, wherein the management operation is used to change the inventory quantity of the commodity, and the first functional unit is used to record in the data table, based on the management operation, an operation flow data corresponding to the commodity under the management operation. The management operation is used to change the inventory quantity of the commodity, and the first functional unit is used to record in the data table, based on the management operation, an operation flow data corresponding to the commodity under the management operation.

[0068] In an embodiment of the present application, the management operations for changing the inventory quantity of the goods may include: warehousing, outbound, increasing or decreasing inventory quantity, scrapping and other management operations. Warehousing can also be called receiving goods. Correspondingly, the first functional unit can also be more specifically called a warehousing management unit, an outbound management unit, an inventory quantity management unit, a scrapping unit, etc.

[0069] In the embodiment of the present application, the inventory management system can identify which management operations will cause a change in the inventory quantity of a commodity, and can do so by detecting the type of management operation. When it is identified that the management operation of a commodity is a management operation for changing the inventory quantity of the commodity, a row of operation flow data is generated in the data table based on the management operation.

[0070] For example, for an increase in inventory from zero to one, such as receiving goods, a row of data is generated. Figure 5 A schematic diagram of operation flow data corresponding to a receiving operation of a material storage form as a material box provided in an embodiment of the present application, such as Figure 5As shown, the table records the movement type as receipt, and records the warehouse information, material form, material number, operation time, account voucher number, etc. As can be seen from the figure, in the two operation flow data, there are the same [related document number] ASN001, two different [material box numbers] HU001 and HU011, each material box number has 100 pieces of materials, and the materials are in the warehouse code CK1, [warehouse area] code KQ1, [warehouse location] code KW1. Two independent management operations are performed on two material boxes respectively, so the [operation time] is different and the [account voucher number] is also different. Similarly, for the reduction of inventory from existence to non-existence, such as scrapping and return, a row of operation flow data is also formed.

[0071] For a pallet with the material form as pallet, the operation flow data in the data table can show the same related document number ASN002, the same pallet number TP001, four different material box numbers HU002 to HU005, and 100 pieces of materials in each material box number. The materials are in the warehouse code CK1, the warehouse area code KQ1, and the storage location code KW1. The operation flow data can be recorded through this information. Figure 6 A schematic diagram of operation flow data corresponding to a warehousing operation based on material form provided in an embodiment of the present application, such as Figure 6 As shown, each independent storage operation generates a row of operation flow data.

[0072] For another example, taking the management operation of changing the inventory quantity of the material as a scrap management operation, Figure 7 A schematic diagram of operation flow data corresponding to a scrap management operation provided in an embodiment of the present application, such as Figure 7 As shown, at this time, an operation flow data is recorded in the data table, and it can be seen that [Movement Type] is scrapped. In some embodiments, [Related Document Number] = "Scrap 001", some columns can be added to describe the scrapping reason, and financial related information such as cost center required for scrapping account can also be filled in.

[0073] In some embodiments, the management operation is a first management operation, the first management operation is used to instruct the commodity to be put into storage, and the first functional unit is used to obtain the type information of the warehouse receiving the commodity and the property rights settlement information of the commodity, wherein the property rights settlement information includes: the type information of the warehouse for settling property rights; the first functional unit is used to determine the property rights information of the commodity based on the type information of the warehouse and the type information of the warehouse for settling property rights, and is used to record the operation flow data corresponding to the commodity under the first management operation in the data table based on the property rights information.

[0074] In some embodiments, the warehouse for settlement of property rights is on a preset warehousing path, and the first functional unit is specifically used to perform the following steps: when the type information of the warehouse matches the type information of the warehouse for settlement of property rights, determine that the property information of the commodity is the property of the buyer's company; when the type information of the warehouse does not match the type information of the warehouse for settlement of property rights, determine the property information of the commodity based on the position of the warehouse on the warehousing path.

[0075] In some embodiments, the first functional unit is specifically used to: when the position is before the warehouse for settling property rights, determine that the property rights information of the commodity is the property rights of the seller's company; when the position is after the warehouse for settling property rights, determine that the property rights information of the commodity is the property rights of the buyer's company.

[0076] In the embodiment of the present application, the preset warehousing path refers to the entire process of materials starting from the supplier, passing through a series of warehouses or logistics nodes, and finally arriving at the designated warehouse of the buyer company. This path is usually pre-set based on various factors such as supply chain strategy, logistics efficiency, and cost considerations. For example, the warehousing path is: off-site warehouse, on-site warehouse, workshop production line warehouse, and goods receipt settlement virtual warehouse.

[0077] In the embodiment of the present application, the warehouse type information can be directly compared. If the type information of the warehouse is the same as the type information of the warehouse of the settlement property right, the match is successful.

[0078] In some embodiments, matching can be performed based on the similarity of warehouse type information, and a fuzzy algorithm (such as cosine similarity, Jaccard similarity, etc.) can be used to calculate the similarity of two warehouse type information. When the similarity reaches a preset threshold, the match is considered successful.

[0079] In some embodiments, a machine learning-based matching method may be used to train a model using a machine learning algorithm to automatically match warehouse type information.

[0080] In the embodiment of the present application, detailed information of the material, including the storage path and the property rights settlement point, can be obtained from the system by scanning the barcode or QR code on the material or manually entering the material number, and the specific storage location of the material in the warehouse can be determined at the same time.

[0081] In an embodiment of the present application, material information, property rights information, storage location and storage information (such as storage time, quantity, and operator) can be integrated together to generate a line of operation flow data.

[0082] The inventory management system provided in the embodiment of the present application records and manages the warehousing events of goods through data tables, ensures the accuracy and consistency of the property rights information and product information of the goods, and can provide reliable data support for subsequent inventory management and property rights management.

[0083] In some embodiments, the functional module also includes: a second functional unit, when the management operation includes a preset type of management operation, the second functional unit is used to generate at least two adjacent rows of operation flow data in the data table based on the management operation, wherein the preset type of management operation includes: a management operation for changing the warehouse where the goods are located, a management operation for changing the storage form of the goods, a management operation for changing the commodity status of the goods, and at least one of the management operations for changing the property rights of the goods, one row of operation flow data is at least used to record the quantity of the changed goods, and another row of operation flow data is at least used to record the information of the changed goods.

[0084] In an embodiment of the present application, when the management operation includes one of the management operation for changing the warehouse where the goods are located, the management operation for changing the storage form of the goods, the management operation for changing the commodity status of the goods, and the management operation for changing the property rights of the goods, two operation flow data are generated. When the management operation includes at least two of the management operation for changing the warehouse where the goods are located, the management operation for changing the storage form of the goods, the management operation for changing the commodity status of the goods, and the management operation for changing the property rights of the goods, two operation flow data can be generated, one operation flow data is used to record the commodity information before the operation occurs, and the other operation flow data is used for the commodity information after the operation occurs. In some embodiments, two operation flow data can also be generated for each type of operation management operation. If there are 2 types of operation management operations, 4 operation flow data will be generated. If there are 3 types of operation management operations, 6 operation flow data will be generated, and so on. By generating two operation flow data for each type of operation management operation, the entire operation process of the goods can be recorded in detail, so as to facilitate subsequent analysis and management.

[0085] In the embodiment of the present application, the first line of operation flow data is often used to record the commodity information before the operation occurs, including the commodity number, the quantity before the operation, the warehouse before the operation, the storage form before the operation, the commodity status before the operation, the property right information before the operation, etc. The second line of operation flow data is used to record the commodity information after the operation occurs, including the commodity number, the quantity after the operation (which may be different from the quantity before the operation), the warehouse after the operation (if applicable), the storage form after the operation (if applicable), the commodity status after the operation (if applicable), the property right information after the operation (if applicable), etc.

[0086] In the embodiment of the present application, the first row of operation flow data includes the number of commodities that have been reduced, and the second row at least includes the number of commodities that have been increased.

[0087] In an embodiment of the present application, the management operation for changing the warehouse where the goods are located may be a management operation for transferring goods across companies, factories, or warehouses; the management operation for changing the storage form of the goods may include: disassembling pallets into boxes, assembling boxes into pallets, etc.; the management operation for changing the commodity status of the goods may include: management operations from available to frozen, from frozen to available, etc.; the management operation for changing the property rights of the goods may include: management operations for transferring VMI property rights to company property rights.

[0088] The following example uses commodities as materials and two operation flow data corresponding to multiple management operations. Figure 8 A schematic diagram of operation flow data in a data table for a management operation for changing a warehouse where a material is located and a management operation for changing a storage form of a material provided in an embodiment of the present application, such as Figure 8 As shown, a box of materials is taken out from the pallet separately. It is not only removed from the pallet, but also transferred from KW1 to KW2. It can be seen that for the material object box number HU005, the material form is a pallet, and the pallet number is TP001, this line of operation flow data has a movement type of warehouse transfer, and the quantity is -100 to reduce the inventory quantity at the warehouse location KW1; at the same time, the quantity of the material box status is +100, which occurs at the warehouse location KW2. The operation time and the voucher number are consistent because it is the same operation, and the same operation forms two lines of operation flow data with "one increase and the other decrease". For another example, Fig. 9 A schematic diagram of operation flow data corresponding to a management operation for changing the storage form of a material provided in an embodiment of the present application, such as Fig. 9 As shown in the figure, there is a box of material that was originally a box, but it was changed to a loose piece by changing the Movement Type to "Break". At this time, two lines of operation flow data are used to record it. For another example, Fig.10 A schematic diagram of a material management operation provided in an embodiment of the present application is to freeze the corresponding operation flow data, such as Fig.10 As shown, 10 pieces of materials with the logistics form of loose parts are changed from [Material Status] Available to Frozen, and [Movement Type] is Frozen. At this time, two lines of operation flow data are used to record. For another example, suppose the attribute of [Warehouse] CK1 is an off-site warehouse, then [Property Rights] is VMI. Suppose the attribute of [Warehouse] CK2 is an in-site warehouse, and the part is configured as a property rights settlement point in the in-site warehouse, then when the material box is transferred from the off-site warehouse to the in-site warehouse, [Property Rights] is also changed to "Company", and two lines of operation flow data are also used to record.

[0089] In the related technologies, there are great limitations in the design of data structure and adaptability to scenario changes. Once the scenario changes, the inventory management system must be changed. At the same time, when adding new companies, factories, and warehouses, it is often not possible to implement it directly through configuration, but changes must be made for the newly added entities. This results in high development costs and long development cycles, which will occupy the project process time of enterprise development.

[0090] In order to solve this problem, the inventory management system provided in the embodiment of the present application also includes: a first output module, used to output configuration options in response to obtaining a configuration operation of the data table, wherein the configuration options include at least one of: an add field option and a delete field option; a generation module, used to configure the data table in response to the operation of the configuration options and generate the data table.

[0091] In an embodiment of the present application, the inventory management system can provide an interactive interface or mechanism to allow the user to configure the data table as needed. Configuration involves adding or deleting fields, because fields are an important part of the data table structure and define the content of each column in the table. The user triggers the configuration operation of the data table by clicking a button, selecting a menu item, etc. After receiving this operation request, the first output module displays the configuration options. The user configuration option can be selected by adding a new field to the data table. When adding a new field, a new column is added to the data table, or a column that is no longer needed is removed from an existing table. The user can also enter or select additional information such as the name, data type, and whether it is allowed to be empty for the new column. Then, the structure of the data table is updated according to the user's operation. If the user adds a new column, the system will insert a new column in the header of the data table and may initialize all the rows of the column to empty or default values. If the user deletes a column, the system will remove the corresponding item from the header and delete all the data in the column. After the configuration is completed, the generation module generates or updates the display of the data table to reflect the changes made.

[0092] The inventory management system provided in the embodiment of the present application is used to output configuration options in response to the configuration operation of the data table obtained through the first output module, wherein the configuration options include at least one of the following: adding a field option and deleting a field option; the generation module is used to configure the data table in response to the operation of the configuration option and generate the data table, and the user can flexibly adjust the structure of the data table to adapt to the ever-changing data requirements and business processes. The configurability of the inventory management subject attributes can arbitrarily add companies, factories, and warehouses, and is applicable to any subject of the enterprise that needs to perform inventory management.

[0093] The inventory management system provided in the embodiment of the present application can meet the needs of any entity such as a company, a factory, a warehouse (including the two levels of warehouse areas and warehouse locations subdivided under the warehouse) to directly add, create, maintain or delete in the system, making inventory management universal and configurable and extensible, thereby reducing development costs and shortening development cycles.

[0094] In some embodiments, the inventory management system also includes: a screening module for responding to a trigger operation of a pre-configured target screening option to screen the operation flow data corresponding to the target screening option from the data table; and a second output module for outputting the operation flow data corresponding to the target screening option.

[0095] In an embodiment of the present application, some filtering conditions can be pre-saved as target filtering options, and the filtering conditions can be based on any field in the data table, for example, one or more of storage form, product status, and property rights information.

[0096] In the embodiment of the present application, each screening condition can be a simple value match (such as equal to, not equal to), a range query (such as greater than, less than, between), or a more complex logical expression (such as AND, OR combination).

[0097] In an embodiment of the present application, a user triggers one or more pre-configured target filtering options by clicking a button, selecting a drop-down menu item, etc. After the filtering module receives this trigger operation, it executes the filtering logic. The filtering module can extract qualified operation flow data from the data table according to the filtering options triggered by the user. The second output module can output the filtered operation flow data to the user. The output to the user can include displaying a data table, a list or a chart in a graphical user interface (GUI), or exporting the data as a file.

[0098] The inventory management system provided by the embodiment of the present application allows users to easily filter the operation flow data in the data table according to their needs, thereby more effectively analyzing and utilizing the data.

[0099] In some embodiments, the inventory management system further includes: a statistical module for, in response to a trigger operation of a pre-configured target statistical option, performing statistics on the data corresponding to the target statistical option in the data table and generating a statistical report.

[0100] In the embodiment of the present application, the user can set a statistical task as a target statistical option.

[0101] In the embodiment of the present application, the user triggers one or more pre-set statistical options by clicking a button, selecting a menu item, etc. After receiving the trigger signal, the statistical module is ready to perform the corresponding statistical task. The statistical module can organize the statistical results into a report form, which may include tables, charts, summary information, etc. Then it can be directly displayed through a graphical user interface (GUI) or sent to the user by email, message notification, etc.

[0102] For example, if the target statistical option is to count the inventory quantity, the current inventory of the product can be obtained by statistics.

[0103] In some embodiments, when formulating a statistical task, a filtering condition may also be set. For example, if the storage location is used as a filtering condition, statistical data corresponding to the storage location may be counted.

[0104] The inventory management system provided by the embodiment of the present application can facilitate the management and analysis of user products.

[0105] The commodity management device provided in the embodiment of the present application can be a software unit, a hardware unit, or a combination of software and hardware units built into an existing electronic device, or it can be integrated into the electronic device as an independent pendant, or it can exist as an independent terminal device.

[0106] It should be noted that the information interaction, execution process, etc. between the above-mentioned devices / units are based on the same concept as the method embodiment of the present application. Their specific functions and technical effects can be found in the method embodiment part and will not be repeated here.

[0107] The technicians in the relevant field can clearly understand that for the convenience and simplicity of description, only the division of the above-mentioned functional units and modules is used as an example for illustration. In practical applications, the above-mentioned function allocation can be completed by different functional units and modules as needed, that is, the internal structure of the device can be divided into different functional units or modules to complete all or part of the functions described above. The functional units and modules in the embodiment can be integrated in a processing unit, or each unit can exist physically separately, or two or more units can be integrated in one unit. The above-mentioned integrated unit can be implemented in the form of hardware or in the form of software functional units. In addition, the specific names of the functional units and modules are only for the convenience of distinguishing each other, and are not used to limit the scope of protection of this application. The specific working process of the units and modules in the above-mentioned system can refer to the corresponding process in the aforementioned method embodiment, which will not be repeated here.

[0108] Fig.11 This is a schematic diagram of the structure of an electronic device provided in an embodiment of the present application. Fig.11 As shown, the electronic device 3 of this embodiment may include: at least one processor 30 ( Fig.11 Only one processor 30 is shown in the figure), a memory 31, and a computer program 32 stored in the memory 31 and executable on at least one processor 30. When the processor 30 executes the computer program 32, the functions of each module / unit in the above-mentioned device embodiments are implemented.

[0109] Exemplarily, the computer program 32 may be divided into one or more modules / units, one or more modules / units are stored in the memory 31, and are executed by the processor 30 to complete the present application. One or more modules / units may be a series of computer program 32 instruction segments capable of completing specific functions, and the instruction segments are used to describe the execution process of the computer program 32 in the electronic device 3.

[0110] In the above embodiments, the description of each embodiment has its own emphasis. For parts that are not described or recorded in detail in a certain embodiment, reference can be made to the relevant descriptions of other embodiments.

[0111] Those of ordinary skill in the art will appreciate that the units and algorithm steps of each example described in conjunction with the embodiments disclosed herein can be implemented in electronic hardware, or a combination of computer software and electronic hardware. Whether these functions are performed in hardware or software depends on the specific application and design constraints of the technical solution. Professional and technical personnel can use different methods to implement the described functions for each specific application, but such implementation should not be considered to be beyond the scope of this application.

[0112] In the embodiments provided in the present application, it should be understood that the disclosed devices / network equipment and methods can be implemented in other ways. For example, the device / network equipment embodiments described above are merely schematic. For example, the division of the modules or units is only a logical function division. There may be other division methods in actual implementation, such as multiple units or components can be combined or integrated into another system, or some features can be ignored or not executed. Another point is that the mutual coupling or direct coupling or communication connection shown or discussed can be through some interfaces, indirect coupling or communication connection of devices or units, which can be electrical, mechanical or other forms.

[0113] The units described as separate components may or may not be physically separated, and the components shown as units may or may not be physical units, that is, they may be located in one place or distributed on multiple network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution of this embodiment.

[0114] The embodiments described above are only used to illustrate the technical solutions of the present application, rather than to limit them. Although the present application has been described in detail with reference to the aforementioned embodiments, a person skilled in the art should understand that the technical solutions described in the aforementioned embodiments may still be modified, or some of the technical features may be replaced by equivalents. Such modifications or replacements do not deviate the essence of the corresponding technical solutions from the spirit and scope of the technical solutions of the embodiments of the present application, and should all be included in the protection scope of the present application.

[0115] The relevant user personal information that may be involved in the various embodiments of this application is strictly in accordance with the requirements of laws and regulations, following the principles of legality, legitimacy and necessity, based on the reasonable purposes of business scenarios, to process the personal information that users actively provide during the use of products / services or generated due to the use of products / services, as well as the personal information obtained with the user's authorization.

[0116] The user personal information processed by the applicant will vary depending on the specific product / service scenario, and shall be based on the specific scenario in which the user uses the product / service, which may involve the user's account information, device information, driving information, vehicle information or other related information. The applicant will treat the user's personal information and its processing with a high degree of diligence.

[0117] The Applicant attaches great importance to the security of user personal information and has adopted reasonable and feasible security protection measures that comply with industry standards to protect user information and prevent personal information from being accessed, disclosed, used, modified, damaged or lost without authorization.

Claims

1. An inventory management system, characterized in that: The system includes a function module, which is used to record at least one operation flow data corresponding to the commodity under any operation type management operation performed by the user on the commodity in a data table, so that the data table at least includes at least one operation flow data corresponding to the commodity under different operation types of management operations; wherein, The data table includes multiple fields, different fields are used to indicate different information of the product, the operation flow data includes at least information indicated by at least one first field and information indicated by a second field among the multiple fields, and the operation flow data corresponding to management operations of different operation types include at least one first field that is the same, and the second fields that are different.

2. The inventory management system according to claim 1, characterized in that: The functional module includes: a first functional unit, the management operation is used to change the inventory quantity of the commodity, and the first functional unit is used to record in the data table, based on the management operation, an operation flow data corresponding to the commodity under the management operation.

3. The inventory management system according to claim 2, characterized in that: The management operation is a first management operation, and the first management operation is used to instruct the commodity to be put into storage. The first functional unit is used to obtain type information of the warehouse receiving the commodity and property rights settlement information of the commodity, wherein the property rights settlement information includes: type information of the warehouse settling the property rights; The first functional unit is used to determine the property rights information of the commodity based on the type information of the warehouse and the type information of the warehouse for settling property rights, and to record the operation flow data corresponding to the commodity under the first management operation in the data table based on the property rights information.

4. The inventory management system according to claim 3, characterized in that: The warehouse for settling property rights is on a preset warehousing path, and the first functional unit is specifically used to perform the following steps: In the case where the type information of the warehouse matches the type information of the warehouse for settling property rights, determining that the property rights information of the commodity is the property rights of the buyer's company; In the case where the type information of the warehouse does not match the type information of the warehouse for settling property rights, the property rights information of the goods is determined based on the position of the warehouse on the warehousing path.

5. The inventory management system according to claim 4, characterized in that: The first functional unit is specifically used to: when the position is before the warehouse for settling property rights, determine that the property rights information of the commodity is the property rights of the seller's company; when the position is after the warehouse for settling property rights, determine that the property rights information of the commodity is the property rights of the buyer's company.

6. The inventory management system according to any one of claims 1 to 5, characterized in that: The functional module also includes: a second functional unit, when the management operation is a preset type of management operation, the second functional unit is used to generate at least two adjacent rows of the operation flow data in the data table based on the management operation, wherein the preset type of management operation includes: a management operation for changing the warehouse where the goods are located, a management operation for changing the storage form of the goods, a management operation for changing the commodity status of the goods, and a management operation for changing the property rights of the goods. At least one of the following, one row of operation flow data is used to record at least the quantity of the changed goods, and another row of operation flow data is used to record at least the information of the changed goods.

7. The inventory management system according to any one of claims 1 to 5, characterized in that: The inventory management system also includes: A first output module, configured to output configuration options in response to obtaining a configuration operation of the data table, wherein the configuration options at least include: an add field option and a delete field option; A generating module is used to configure the data table in response to the operation on the configuration option and generate the data table.

8. The inventory management system according to any one of claims 1 to 5, characterized in that: The first field includes: a product number field, and the second field includes: at least one of: product storage form, product status, warehouse information, and property rights information.

9. The inventory management system according to any one of claims 1 to 5, characterized in that: The inventory management system also includes: A screening module, configured to respond to a trigger operation of a pre-configured target screening option and screen the operation flow data corresponding to the target screening option from the data table; The second output module is used to output the operation flow data corresponding to the target screening option.

10. The inventory management system according to any one of claims 1 to 5, characterized in that: The inventory management system also includes: The statistics module is used to respond to the trigger operation of the pre-configured target statistical option, collect statistics on the data corresponding to the target statistical option in the data table, and generate a statistical report.

11. An electronic device, characterized in that: The electronic device comprises an inventory management system as claimed in any one of claims 1 to 10.

Images