Product sub-owner management method, system, computer equipment and storage medium

Abstract

The present invention relates to the field of warehouse management technology, and discloses a product owner management method, system, computer equipment and storage medium, the method comprising: obtaining the first owner information in the product sales order, the first product attribute information of the product to be allocated on the preset pallet and the corresponding first pallet code; matching the first owner information, the first pallet code and the first product attribute information with the second pallet code in the preset pallet owner comparison relationship table, the second product attribute information and the second owner information corresponding to the second pallet code to obtain a matching result; obtaining the allocation result of the product to be allocated according to the matching result, the allocation result comprising allocating the product to be allocated to the corresponding owner or modifying the preset pallet owner comparison relationship table, and allocating the product to be allocated to the corresponding owner according to the modified preset pallet owner comparison relationship table. The present invention achieves the purpose of accurate matching between online systems and offline physical products.

Description

Technical Field

[0001] The present invention relates to the technical field of warehouse management, and in particular to a method, system, computer equipment and storage medium for managing product cargo owners. Background Art

[0002] Under the current warehouse logistics operation management, if the company's physical products are managed by different entities (different entities management is also called different cargo owners management), there will be three main types of problems:

[0003] 1. Storage capacity issues:

[0004] 1. Single warehouse function positioning: At present, relevant enterprises adopt the third-party logistics outsourcing model to streamline the departmental business structure and personnel composition in order to concentrate resources on the development of core business. After the third-party logistics company receives the product storage warehouse, it does not carry out functional positioning of the warehouse, that is, normal products and abnormal products are stored in the same warehouse at the same time, or even in the same warehouse area, which is not conducive to the implementation of physical entity management.

[0005] 2. The level of warehouse management personnel is relatively low: because the company's warehousing business is outsourced, third-party logistics companies only passively provide logistics services and lack subjective initiative; and the current logistics operation levels of various logistics companies are uneven, the management process is extensive, and there are large differences in informatization, palletization and barcoding levels, which brings great obstacles to the realization of warehouse informatization management.

[0006] 3. Limitations of warehouse types and storage area: Currently, there are two main types of warehouses: high-rise shelf warehouses and single-layer flat warehouses. With the support of a warehouse management system, high-rise shelf warehouses can achieve refined fixed-position management, and it is relatively easier to implement separate entity management of physical products than single-layer flat warehouses.

[0007] However, most third-party logistics companies currently use single-layer warehouses. For warehouses, some products are piled on the ground. Even with the support of a system, to achieve separate entity management, it is necessary to plan and layout the warehouse, and to achieve fixed positioning and batch attribute management for products. This is also one of the main difficulties faced by logistics companies.

[0008] 4. No unified information system support: At present, most of the company's warehousing operations are still basically completed by manual operations, the overall information level is low, and the logistics company's information system is not connected with the enterprise's information system. When transactions occur between companies, the physical information and financial information in the warehouse cannot be shared in real time.

[0009] (II) Conflict between accounting and physical management:

[0010] 1. The system account and the physical object cannot be associated one-to-one: The warehouse operation management of the company's products is fixed to a certain warehouse in the SAP (System Applications and Products, a computer system-based warehouse management software) system, without further division of warehouse areas and warehouse locations, and not located on specific pallets. Secondly, batch attribute management is not implemented, and only a certain product item can be locked, and a one-to-one association with a specific batch of a specific product cannot be achieved, so that the sub-subject management of the product remains at the quantitative level of the system account. In addition, because the company's products include normal and abnormal products (i.e. damaged, wet, returned, quality, quality inspection and other frozen products, and zero-bottle products, etc.), if the physical sub-subject management of abnormal products is carried out separately, it will increase the difficulty of implementing the physical sub-subject management of products.

[0011] 2. Multiple entities exist for the same material at the same time: In the existing factory system of the SAP system, there are 75 factories holding product inventories. Because the company allows the same product material (basic material) to be sold by multiple sales units, there are multiple entities for the same material in the warehouse. Among the existing 4,254 materials and 75 factories, product materials with multiple entities at the same time account for 43.9% of the total number of materials. In this case, strictly stacking and managing the physical products according to the ownership of the entities will inevitably lead to an exponential increase in the storage area, which will increase inventory costs and reduce storage utilization.

[0012] (III) Issues regarding inter-company transactions:

[0013] 1. Multiple positions and multiple processes for inter-company transactions: As mentioned above, each sales system purchases products for sale through inter-company transactions with the corresponding upstream entities in accordance with its own needs. When the inventory under the name of its own factory cannot meet the sales demand, it is necessary to submit a purchase application to the upstream again. When submitting a purchase application, the sales system needs to apply for purchase funds from the corresponding finance department, and the system process can only be submitted after the approval of the company leader. This application work is expected to pass through 3 positions. When the product inventory of the upstream company entity cannot meet the procurement needs of the sales system, it will also purchase from the upstream company entity through the process. The overlapping of inter-company transaction processes affects the efficiency of sales order response.

[0014] 2. Increase the cost of scanning and moving: According to the existing inter-company transaction and warehousing operation mode, the physical warehouse is managed by different entities. From the transaction of a product from the 1100 company to the final delivery, each inter-company transaction will incur a scanning and moving fee of 0.13 yuan. If the company has many subsidiaries and brand companies, and the transactions between companies are frequent, the physical warehouse is managed by different entities according to the existing warehousing physical delivery mode, and the scanning and moving costs will increase exponentially, which is not conducive to the implementation of the management by different entities. In summary, combined with the current warehousing management model for different entities, the cost of scanning and moving will be greatly increased.

[0015] In summary, the company's warehousing ownership model is based on the principle of brand ownership. Each brand company rents a warehouse from a logistics company based on its own sales needs to store existing products. For products stored in the corresponding warehouse, there are multiple sales systems selling the same material at the same time. If the sales system purchases the product but does not ship it out, the system account will show that it has been allocated to the corresponding sales factory, but the physical inventory has not changed. In terms of physical products, third-party logistics companies are affected by the warehouse area and warehouse equipment and facilities and cannot manage the product corresponding to the factory by state or stacking.

[0016] Therefore, there is an urgent need for a method for managing sub-consignors that can solve the problem of rough sub-consignor management leading to the inability to accurately allocate products during the sales process. Summary of the invention

[0017] In view of this, the present invention provides a product sub-consignor management method, system, computer device and storage medium to solve the problem that rough sub-consignor management leads to the inability to accurately match the online system with the offline physical products during the sales process.

[0018] In a first aspect, the present invention provides a method for managing product owners by category, the method comprising:

[0019] Obtaining the first owner information in the product sales order, the first product attribute information of the product to be allocated on the preset pallet, and the corresponding first pallet code;

[0020] Matching the first owner information, the first pallet code and the first product attribute information with the second pallet code, the second product attribute information and the second owner information corresponding to the second pallet code in the preset pallet owner comparison relationship table to obtain a matching result;

[0021] The allocation result of the product to be allocated is obtained according to the matching result, and the allocation result includes allocating the product to be allocated to the corresponding consignee or modifying the preset pallet consignor comparison relationship table, and allocating the product to be allocated to the corresponding consignee according to the modified preset pallet consignor comparison relationship table.

[0022] The product owner management method provided by the present invention obtains a matching result by matching the first owner information, the first pallet code and the first product attribute information with the second pallet code in the preset pallet owner comparison relationship table, the second product attribute information and the second owner information corresponding to the second pallet code, and obtains the allocation result of the product to be allocated according to the matching result, and the allocation result includes allocating the product to be allocated to the corresponding owner or modifying the preset pallet owner comparison relationship table, and allocating the product to be allocated to the corresponding owner according to the modified preset pallet owner comparison relationship table, and allocating the product to the corresponding owner based on the updated preset pallet owner comparison relationship table, so as to achieve the purpose of using the product to distinguish the owner, and realize the purpose of accurately matching the online system with the offline physical product. The method can accurately allocate products to the corresponding owners in the sales process, the granularity of the owner management is down to the pallet level, and the owner information is bound to the pallet to realize the refined owner management, which solves the problem that the online system cannot accurately match the offline physical product in the sales process due to the rough owner management.

[0023] In an optional implementation, the first owner information, the first pallet code and the first product attribute information are matched with the second pallet code, the second product attribute information and the second owner information corresponding to the second pallet code in the preset pallet owner comparison relationship table to obtain a matching result, including:

[0024] When the first pallet code and the second pallet code are consistent, the first owner information and the second owner information are consistent, and the first product attribute information and the second attribute information are consistent, the matching result is consistent;

[0025] When any two of the first pallet code and the second pallet code, the first consignor information and the second consignor information, and the first product attribute information and the second attribute information are inconsistent, the matching result is inconsistent matching.

[0026] The product sub-owner management method provided by the present invention has a matching result of consistent matching when the first pallet code and the second pallet code are consistent, the first owner information and the second owner information are consistent, and the first product attribute information and the second attribute information are consistent; when any two of the first pallet code and the second pallet code, the first owner information and the second owner information, and the first product attribute information and the second attribute information are inconsistent, the matching result is inconsistent matching. The obtained matching result provides a reference basis for subsequently allocating products to corresponding owners, thereby indirectly realizing refined management of sub-owners.

[0027] In an optional implementation, obtaining the allocation result of the product to be allocated according to the matching result includes:

[0028] When the matching result is consistent, a matching result is obtained in which the product to be allocated is allocated to the corresponding consignor.

[0029] The product sub-owner management method provided by the present invention allocates the to-be-allocated products to the corresponding owners according to the matching results, thereby improving the allocation efficiency of the products to the corresponding owners and further improving the speed of refined management of the sub-owners.

[0030] In an optional implementation, obtaining the allocation result of the product to be allocated according to the matching result further includes:

[0031] When the matching result is inconsistent, the second owner information corresponding to the second pallet code in the preset pallet owner comparison table is modified, and the matching result of allocating the to-be-allocated products to the corresponding owners is obtained according to the modified second owner information.

[0032] The product distribution owner management method provided by the present invention modifies the second owner information corresponding to the second pallet code in the preset pallet owner comparison relationship table according to the matching result that the match is inconsistent, and distributes the to-be-distributed products to the corresponding owners according to the modified second owner information, so that the physical ownership of the pallet does not need to be changed, and the second owner information corresponding to the second pallet code in the preset pallet owner comparison relationship table is directly modified, the first owner information and the second owner information as well as the first product attribute information and the second product attribute are accurately matched, and the to-be-distributed products are distributed to the corresponding owners according to the modified second owner information, and the products are accurately distributed to the corresponding owners, which saves the distribution time, improves the distribution efficiency, and provides a background modification basis for the refined management of distribution.

[0033] In an optional implementation, the method for managing product sub-consignors further includes:

[0034] Get product stock transfer orders;

[0035] Before the product is transferred, the second owner information corresponding to the second pallet code in the preset pallet owner comparison table is updated based on the inventory transfer order;

[0036] After the product has been transferred, the corresponding consignor return operation is carried out based on the inventory transfer order.

[0037] The method for managing products by different owners provided by the present invention updates the second owner information corresponding to the second pallet code in the preset pallet owner comparison relationship table based on the inventory transfer order before the product is transferred, thereby achieving the purpose of modifying the product inventory and the corresponding owner information in real time, and providing a basis for improving the accuracy of product inventory counting. After the product has been transferred, the corresponding owner return operation is performed based on the inventory transfer order, and corresponding operations are performed according to whether the physical product has been transferred or not, which is conducive to accurate inventory counting of product inventory and provides an inventory basis for refined management of different owners.

[0038] In an optional implementation, the second product attribute information includes product inventory, and the product sub-consignor management method further includes:

[0039] Compare the product inventory corresponding to the second owner information in the preset pallet owner comparison table with the corresponding physical product inventory to see if they are consistent;

[0040] If the comparison is inconsistent, the inventory difference between the product inventory corresponding to the second owner information and the corresponding physical product inventory is calculated, and the product is allocated to the corresponding owner based on the inventory difference.

[0041] The product sub-owner management method provided by the present invention is based on whether the product inventory corresponding to the second owner information in the preset pallet owner comparison relationship table is consistent with the corresponding physical product inventory. If the comparison is inconsistent, the inventory difference between the product inventory corresponding to the second owner information and the corresponding physical product inventory is calculated, and the product is allocated to the corresponding owner based on the inventory difference, so that the product inventory corresponding to the second owner information in the preset pallet owner comparison relationship table and the physical product inventory corresponding to the physical owner are kept consistent in real time, thereby achieving the purpose of keeping the online system consistent with the offline physical product inventory.

[0042] In an optional embodiment, the product sub-owner management method also includes: when internal transfer is performed between any two second consignor information in the preset pallet owner comparison relationship table, adjusting the product inventory corresponding to any two second consignor information in the preset pallet owner comparison relationship table, so that the product inventory corresponding to any two second consignor information can be internally transferred.

[0043] The method for managing sub-owners of products provided by the present invention adjusts the product inventory corresponding to any two second owner information in the preset pallet owner comparison relationship table when internal transfer is performed between any two second owner information in the preset pallet owner comparison relationship table, thereby realizing automatic transfer between sub-owners at the online system level, improving the transfer efficiency between sub-owners, thereby improving the corresponding efficiency of sales orders, and saving the scanning cost of offline physical products.

[0044] In a second aspect, the present invention provides a product sub-consignor management system, the sub-consignor management system comprising:

[0045] A code scanning device, used to obtain first product attribute information and a corresponding first pallet code of a product to be distributed on a preset pallet;

[0046] The warehouse inventory subsystem is used to obtain the first owner information in the product sales order;

[0047] The warehouse management subsystem is connected to the code scanning device and the warehouse inventory subsystem respectively, and is used to match the first owner information, the first pallet code and the first product attribute information with the second pallet code in the preset pallet owner comparison relationship table, and the second product attribute information and the second owner information corresponding to the second pallet code to obtain a matching result; according to the matching result, an allocation result of the to-be-allocated product is obtained, and the allocation result includes allocating the to-be-allocated product to the corresponding owner or modifying the preset pallet owner comparison relationship table, and allocating the to-be-allocated product to the corresponding owner according to the modified preset pallet owner comparison relationship table.

[0048] In a third aspect, the present invention provides a computer device comprising: a memory and a processor, the memory and the processor being communicatively connected to each other, the memory storing computer instructions, and the processor executing the method for managing products by different consignors according to the first aspect or any corresponding embodiment thereof by executing the computer instructions.

[0049] In a fourth aspect, the present invention provides a computer-readable storage medium having computer instructions stored thereon, the computer instructions being used to enable a computer to execute the method for managing products by sub-consignor according to the first aspect or any corresponding embodiment thereof. BRIEF DESCRIPTION OF THE DRAWINGS

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

[0051] Figure 1 is a flowchart of a method for managing product cargo owners according to an embodiment of the present invention;

[0052] Figure 2 is a flow chart of a method for managing cargo owners of another product according to an embodiment of the present invention;

[0053] Figure 3 is a flowchart of a method for managing cargo owners of another product according to an embodiment of the present invention;

[0054] Figure 4 is a schematic diagram of allocating products after modifying a preset pallet owner comparison relationship table according to an embodiment of the present invention;

[0055] Figure 5 is a schematic diagram of allocating products after a modified preset pallet owner comparison table according to an embodiment of the present invention;

[0056] Figure 6is a schematic diagram of product transfer between two cargo owners according to an embodiment of the present invention;

[0057] Figure 7 is a schematic diagram of interaction between a warehouse management software system and a warehouse management execution system according to an embodiment of the present invention;

[0058] Figure 8 is a structural block diagram of a product distribution owner management system according to an embodiment of the present invention;

[0059] Fig. 9 It is a schematic diagram of the hardware structure of a computer device according to an embodiment of the present invention. DETAILED DESCRIPTION

[0060] In order to make the purpose, technical solution and advantages of the embodiments of the present invention clearer, the technical solution in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments are part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative work are within the scope of protection of the present invention.

[0061] The current warehouse management system has initially realized the management of cargo owners at the online system level, but it cannot be fully realized at the product physical level. It is impossible to accurately match the online system with the offline physical products. When inter-company transactions occur, the company's financial system performs accounting processing, and the SAP (System Applications and Products, a computer-based warehouse management software) system changes the main attributes of the corresponding products based on the transaction information. Because the SAP system cannot achieve precise positioning management down to the specific pallet and specific batch, inter-company transactions remain at the accounting transaction level, and there is no direct correlation between the number of products traded and the physical objects. When inter-company transactions occur: According to the existing transaction path, moving the physical objects will incur a lot of costs. Therefore, the physical products do not move with the online system accounts, resulting in the inability to clearly distinguish the cargo owners of the products. An embodiment of the present invention provides a method for managing product owners by different owners, by matching first owner information, a first pallet code and first product attribute information with a second pallet code in a preset pallet owner comparison relationship table, and second product attribute information and second owner information corresponding to the second pallet code, to obtain a matching result, and obtain an allocation result of the to-be-allocated product based on the matching result, the allocation result including allocating the to-be-allocated product to a corresponding owner or modifying the preset pallet owner comparison relationship table, and allocating the to-be-allocated product to a corresponding owner according to the modified preset pallet owner comparison relationship table, thereby achieving an effect of accurate matching between an online system and an offline physical product.

[0062] According to an embodiment of the present invention, an embodiment of a method for managing sub-consignors of a product is provided. It should be noted that the steps shown in the flowchart of the accompanying drawings can be executed in a computer system such as a set of computer executable instructions, and although a logical order is shown in the flowchart, in some cases, the steps shown or described can be executed in an order different from that shown here.

[0063] In this embodiment, a method for managing product sub-consignors is provided. Figure 1 is a flow chart of a method for managing product cargo owners according to an embodiment of the present invention. Figure 1 As shown, the process includes the following steps:

[0064] Step S101, obtaining first owner information in a product sales order, first product attribute information of a product to be allocated on a preset pallet, and a corresponding first pallet code.

[0065] Specifically, the warehouse management system ERP / EWM (ERP stands for Enterprise Resource Planning, Enterprise Resource Planning Warehouse Inventory System, abbreviated as ERP; EWM stands for Extended Warehouse Management, Warehouse Management System, abbreviated as EWM) based on the enterprise resource planning warehouse inventory system is used to obtain product sales orders, among which the ERP system is the issuing end of warehouse control instructions, and the EWM system is the warehouse execution end of control instructions.

[0066] The product sales order is obtained through the ERP system, and the product assignment task is created based on the sales order and issued to the EWM system. The sales order includes the order number, customer number, first owner information, product material number, product quantity and product unit, etc.

[0067] In the physical warehouse, the physical products to be distributed are all located on the corresponding pallets in the physical warehouse. The pallet is a medium that transforms static physical products into dynamic physical products. It is a cargo platform and an active platform, or a movable ground. Each pallet is printed with its own pallet code, that is, the pallet corresponds to the pallet code one by one. When the EWM system receives the product sales order, it will recommend the best delivery plan from the warehouse based on the first owner information (in the form of digital number) in the customer's sales order, the product material number, product quantity and product unit.

[0068] Based on the optimal delivery plan, the physical product to be allocated on the preset pallet is found, and the physical product to be allocated on the preset pallet is scanned by a scanning device to obtain the first product attribute information and the corresponding first pallet code of the product to be allocated on the preset pallet. The first product attribute information of the product to be allocated includes the first material number, the first batch number, the first production plant number (the same as the digital number of the first owner information), the first warehouse number and the first storage location number, the first product inventory quantity, the first product unit, etc.

[0069] It should be noted that: Figure 7 As shown, in order to avoid the risk of arbitrarily changing the owner of the physical goods during the scanning process, only the outbound delivery order driving function is set for the scanning device.

[0070] For example, Figure 4 As shown in the figure, take the sales order number 60000001, customer XX, and the purchase material number A01 40PC from the first owner information 1403 obtained by the EWM system as an example. After the EWM system obtains the sales order, the EWM system recommends the optimal delivery plan based on the sales order: delivery from warehouse 8014 bin L01-01-05. According to the optimal delivery plan, scan the physical product of warehouse 8014 bin L01-01-05 to obtain the first pallet code CT01-0005 and the first product information attributes (the first batch number is 2018111201, the first production plant is 1403, the first product inventory quantity is 40, and the first product unit is PC).

[0071] Step S102, matching the first owner information, the first pallet code and the first product attribute information with the second pallet code, the second product attribute information corresponding to the second pallet code and the second owner information in the preset pallet owner comparison relationship table to obtain a matching result.

[0072] Specifically, the preset pallet owner comparison table is stored in the ERP system, including the second pallet code, the second product attribute information corresponding to the second pallet code, and the second owner information. Among them, the second product attribute information corresponding to the second pallet code includes the second material number, the second batch number, the second production plant number, the second warehouse number and the second storage location number, the inventory quantity, the second product unit, etc. Taking a certain product as an example, its preset pallet owner comparison table is shown in Table 1 below.

[0073] Table 1

[0074]

[0075] In the above Table 1, PC is a capacity unit.

[0076] The first consignor information, the first pallet code and the first product attribute information (the first material number, the first batch number, the first production plant number, the first warehouse number and the first location number of the product, the quantity of products sold, and the first product unit) are matched with the second pallet code in the preset pallet owner comparison table, the second product attribute information corresponding to the second pallet code (the second material number, the second batch number, the second production plant number, the second warehouse number and the second location number, the second product unit, and whether the product inventory quantity is greater than or equal to the quantity of products sold), and the second consignor information to obtain a consistent matching result or an inconsistent matching result.

[0077] For example, taking the sales order number 60000001, customer XX, and the purchase material number A01 40PC from the first consignor information 1403 obtained by the EWM system as an example, when the first consignor information 1403, the first pallet code CT01-0005 and the first product information attributes (the first batch number is 2018111201, the first production plant is 1403, the first product inventory quantity is 40, and the first product unit is PC) are obtained, the EWM system matches the first consignor information 1403, the first pallet code CT01-0005 and the first product information attributes (the first batch number is 2018111201, the first production plant is 1403, the first product inventory quantity is 40, and the first product unit is PC) in the preset pallet owner comparison relationship table.

[0078] Step S103, obtaining the allocation result of the product to be allocated according to the matching result, the allocation result includes allocating the product to be allocated to the corresponding owner or modifying the preset pallet owner comparison relationship table, and allocating the product to be allocated to the corresponding owner according to the modified preset pallet owner comparison relationship table.

[0079] For example, the sales order number obtained by the EWM system is 60000001, the customer is XX, and the material number A01 40PC is purchased from the first owner information 1403. When the shuttle channel is used in the 8014 warehouse, Figure 4 As shown, CT01-0002 is the easiest pallet to pick up, but there is obviously no product with the first owner information 1403 in the preset pallet owner comparison table in the bin L01-01-05, that is, the matching result is inconsistent, so the operation of modifying the preset pallet owner comparison table is performed, and the products to be allocated are allocated to the corresponding owners according to the modified preset pallet owner comparison table. Figure 5 As shown, the preset pallet owner comparison relationship table is modified until the matching result is consistent, and the products to be allocated are allocated to the corresponding owners according to the modified preset pallet owner comparison relationship table.

[0080] It should be noted that the physical placement principles of products in the warehouse are as follows: 1. Store the same minimum stock keeping unit SKU (Stock Keeping Unit, SKU for short) and the same batch of products in one shuttle channel or one flat warehouse. 2. Try to put one SKU (minimum stock keeping unit, SKU for short) and one batch of products on one pallet. For unavoidable mixed placement, a separate zero-pallet area needs to be planned for separate storage.

[0081] The product owner management method provided in this embodiment obtains a matching result by matching the first owner information, the first pallet code and the first product attribute information with the second pallet code in the preset pallet owner comparison relationship table, the second product attribute information and the second owner information corresponding to the second pallet code, and the allocation result of the product to be allocated is obtained according to the matching result. The allocation result includes allocating the product to be allocated to the corresponding owner or modifying the preset pallet owner comparison relationship table, and allocating the product to be allocated to the corresponding owner according to the modified preset pallet owner comparison relationship table, and allocating the product to the corresponding owner based on the updated preset pallet owner comparison relationship table, so as to achieve the purpose of using the product to distinguish the owner, and realize the purpose of accurately matching the online system with the offline physical product. In the sales process, the product can be accurately allocated to the corresponding owner, the granularity of the owner management is down to the pallet level, and the owner information is bound to the pallet to realize the refined owner management, which solves the problem that the online system cannot accurately match the offline physical product in the sales process due to the rough owner management.

[0082] In this embodiment, a method for managing product sub-consignors is provided. Figure 2 is a flow chart of a method for managing product cargo owners according to an embodiment of the present invention. Figure 2 As shown, the process includes the following steps:

[0083] Step S201, obtain the first owner information in the product sales order, the first product attribute information of the product to be allocated on the preset pallet and the corresponding first pallet code. Figure 1 Step S101 of the illustrated embodiment will not be described in detail here.

[0084] Step S202, matching the first owner information, the first pallet code and the first product attribute information with the second pallet code, the second product attribute information corresponding to the second pallet code and the second owner information in the preset pallet owner comparison relationship table to obtain a matching result.

[0085] Specifically, the above step S202 includes:

[0086] Step S2021, when the first pallet code and the second pallet code are consistent, the first owner information and the second owner information are consistent, and the first product attribute information and the second attribute information are consistent, the matching result is a consistent match.

[0087] For example, taking the sales order number 60000001, customer XX, and the purchase material number A01 40PC from the first owner information 1403 obtained by the EWM system, the EWM system recommends the optimal delivery plan based on the sales order: delivery from warehouse 8014 location L01-01-05.

[0088] When the first consignee information is 1403, the first pallet code CT01-0005 and the first product information attributes (the first batch number is 2018111201, the first production plant is 1403, the first product inventory quantity is 40, and the first product unit is PC) are obtained, the EWM system matches the first consignee information 1403, the first pallet code CT01-0005 and the first product information attributes (the first batch number is 2018111201, the first production plant is 1403, the first product inventory quantity is 40, and the first product unit is PC) in the preset pallet owner comparison relationship table.

[0089] When the first pallet code CT01-0005 is consistent with the second pallet code CT01-0005 in the preset pallet owner comparison table, the first owner information 1403 is consistent with the second owner information 1403 in the preset pallet owner comparison table, and the first product information attribute (the first batch number is 2018111201, the first production plant is 1403, the first product inventory quantity is 40, and the first product unit is PC) is consistent with the second product attribute information (the second batch number is 2018111201, the second production plant is 1403, the second product inventory quantity is 40, and the second product unit is PC) in the preset pallet owner comparison table, the matching result is a consistent match.

[0090] Step S2022: When any two of the first pallet code and the second pallet code, the first consignor information and the second consignor information, and the first product attribute information and the second attribute information are inconsistent, the matching result is inconsistent.

[0091] Exemplarily, when the first pallet code CT01-0005 is inconsistent with the second pallet code CT01-0005 in the preset pallet owner comparison table, or the first owner information 1403 is inconsistent with the second owner information 1216 in the preset pallet owner comparison table, or the first product information attribute (the first batch number is 2018111201, the first production plant is 1403, the first product inventory quantity is 40, and the first product unit is PC) is inconsistent with the second product attribute information in the preset pallet owner comparison table (the second batch number is 2018111201, the second production plant is 1216, the second product inventory quantity is 40, and the second product unit is PC), the matching result is inconsistent matching.

[0092] Step S203, obtaining the allocation result of the product to be allocated according to the matching result, the allocation result includes allocating the product to be allocated to the corresponding owner or modifying the preset pallet owner comparison relationship table, and allocating the product to be allocated to the corresponding owner according to the modified preset pallet owner comparison relationship table.

[0093] Specifically, the above step S203 includes:

[0094] Step S2031, when the matching result is consistent, a matching result is obtained in which the product to be allocated is allocated to the corresponding owner.

[0095] For example, when the matching result is a consistent match, such as Figure 4 As shown, the physical product with the pallet code CT01-0005 is shipped out of warehouse 8014 bin L01-01-05 and allocated to the consignee with the consignee information 1403.

[0096] Step S2032, when the matching result is inconsistent, obtain the second owner information corresponding to the second pallet code in the preset pallet owner comparison relationship table, and allocate the to-be-allocated products to the corresponding owners according to the modified second owner information.

[0097] For example, when the matching result is inconsistent, Figure 5 As shown, pallet code CT01-0002 is the first pallet taken, but obviously there is no product of owner 1403 in the preset pallet owner comparison relationship table in warehouse location L01-01-05. In order to overcome the defect of mismatch between the physical product and the owner information, the second owner information 1216 and the second owner information 1403 in the preset pallet owner comparison relationship table are replaced. According to the replaced preset pallet owner comparison relationship table, the physical product with pallet code CT01-0002 is shipped out and removed from the shelf in warehouse location L01-01-05 of warehouse 8014, and the physical product is allocated to the owner with owner information 1403.

[0098] It should be noted that when replacing the second owner information corresponding to the second pallet codes in the preset pallet owner comparison table, the second material number, second batch number, second product inventory quantity and second product unit must be consistent before the owner information can be replaced.

[0099] The product sub-owner management method provided in this embodiment is that when the first pallet code and the second pallet code are consistent, the first owner information and the second owner information are consistent, and the first product attribute information and the second attribute information are consistent, the matching result is a consistent match; when any two of the first pallet code and the second pallet code, the first owner information and the second owner information, and the first product attribute information and the second attribute information are inconsistent, the matching result is an inconsistent match. The obtained matching result provides a reference basis for subsequently allocating products to corresponding owners, thereby indirectly realizing the refined management of sub-owners. According to the matching result being an inconsistent match, the preset pallet owner is modified. The second owner information corresponding to the second pallet code in the comparison relationship table is used, and the products to be allocated are allocated to the corresponding owners according to the modified second owner information, so that the physical ownership of the pallet does not need to be changed. The second owner information corresponding to the second pallet code in the preset pallet owner comparison relationship table is directly modified, and the first owner information is accurately matched with the second owner information and the first product attribute information and the second product attribute. According to the modified second owner information, the products to be allocated are allocated to the corresponding owners, and the products are accurately allocated to the corresponding owners, which saves allocation time, improves allocation efficiency, and provides a background modification basis for refined management of distribution.

[0100] In this embodiment, a method for managing product sub-consignors is provided. Figure 3 is a flow chart of a method for managing product cargo owners according to an embodiment of the present invention. Figure 3 As shown, the process includes the following steps:

[0101] Step S301, obtain the first owner information in the product sales order, the first product attribute information of the product to be allocated on the preset pallet and the corresponding first pallet code. Figure 2 Step S201 of the illustrated embodiment will not be described in detail here.

[0102] Step S302, matching the first owner information, the first pallet code and the first product attribute information with the second pallet code, the second product attribute information corresponding to the second pallet code and the second owner information in the preset pallet owner comparison relationship table to obtain a matching result. Figure 2 Step S202 of the illustrated embodiment will not be described in detail here.

[0103] Step S303, obtain the allocation result of the product to be allocated according to the matching result, and the allocation result includes allocating the product to be allocated to the corresponding owner or modifying the preset pallet owner comparison relationship table, and allocating the product to be allocated to the corresponding owner according to the modified preset pallet owner comparison relationship table. For details, please refer to Figure 2 Step S203 of the illustrated embodiment will not be described in detail here.

[0104] Step S304, obtaining a product inventory transfer order; before the product is transferred, updating the second owner information corresponding to the second pallet code in the preset pallet owner comparison relationship table based on the inventory transfer order; after the product has been transferred, performing a corresponding owner return operation based on the inventory transfer order.

[0105] Specifically, the online EWM system obtains the product inventory transfer order from the order maker. In order to ensure that the second product inventory quantity corresponding to the second owner information in the preset pallet owner comparison table in the online EWM system is the same as the physical product inventory quantity, when performing the offset accounting operation in the online EWM system, it is necessary to ensure that the operation is performed before the physical product is transferred. That is, before the product is transferred, the second owner information corresponding to the second pallet code in the preset pallet owner comparison table is updated based on the inventory transfer order, so that the second product inventory quantity corresponding to the second owner information remains consistent.

[0106] If the product has been transferred, the corresponding consignor return operation is performed based on the inventory transfer order. The preset pallet owner reference relationship table cannot be directly modified to perform account offset operations.

[0107] Step S305, the second product attribute information includes product inventory, and the product inventory corresponding to the second owner information in the preset pallet owner comparison table is compared with the corresponding physical product inventory to see if they are consistent; if the comparison is inconsistent, the inventory difference between the product inventory corresponding to the second owner information and the corresponding physical product inventory is calculated, and the product is allocated to the corresponding owner based on the inventory difference.

[0108] Specifically, the warehouse inventory system ERP based on enterprise resource planning issues inventory checks every day, compares the second product inventory quantity in the warehouse management system EWM with the physical inventory of the product. If the second product inventory quantity corresponding to the second owner information in the warehouse management system EWM is inconsistent with the physical inventory of the product, the inventory difference between the product inventory corresponding to the second owner information and the corresponding physical product inventory is calculated, and the product is allocated to the corresponding owner based on the inventory difference. It is also necessary to further modify the second product inventory quantity corresponding to the second owner information so that the second product inventory quantity corresponding to the second owner information is always consistent with the physical inventory of the product.

[0109] Step S306, when internal transfer is performed between any two second consignor information in the preset pallet consignor reference relationship table, the product inventory corresponding to any two second consignor information in the preset pallet consignor reference relationship table is adjusted so that the product inventory corresponding to any two second consignor information is internally transferred.

[0110] Specifically, the current transaction inventory location between cargo owners is not selected according to the actual delivery inventory location, resulting in the logistics company needing to perform a one-step transfer business in the EWM system when delivering goods, and exchange the second cargo owner information of any two second product inventories in the warehouse corresponding to the preset pallet cargo owner comparison relationship table. According to the ERP system (a computer-based warehouse inventory system) publishing transaction business, the warehouse management system EWM automatically changes the preset pallet cargo owner comparison relationship table through data matching of the corresponding pallet.

[0111] It should be noted that in addition to internal transfers, cargo owners can also conduct internal transactions, such as Figure 6 As shown, in the link of requesting the delivery pool ATP (Available to Promise, ATP for short), the internal transaction principle is: conduct internal transactions between cargo owners based on the priority of warehouse location selection (such as checking whether the own inventory of the same warehouse location under the same production plant is sufficient, whether the sum of the inventory of multiple cargo owners under the same warehouse location is sufficient, and whether the sum of the inventory of multiple warehouse locations is sufficient, and then choose to trade between any two cargo owners in this order). Take the example of selling 70PC of A01 product from the 1100 production plant to the 1200 production plant. When the order maker creates a purchase order between cargo owners (also known as between companies) in the ERP system and saves it, the EWM system automatically checks the pallet and cargo owner comparison table to see if there are two full pallets with a total of 70PC. Through the inspection, it is found that only the sum of the two pallets CT-01-0001 and CT-01-0002, 79PC, can meet the demand. The preset pallet owner comparison relationship table before the transaction between cargo owners is shown in Table 2:

[0112] Table 2

[0113]

[0114] After the transaction order between the shippers is created in the ERP system, the preset pallet shipper comparison table is shown in Table 3 below:

[0115] Table 3

[0116]

[0117] When the order clerk completes the posting of transactions between cargo owners in the ERP system, the preset pallet cargo owner comparison table is updated as shown in Table 4 below:

[0118] Table 4

[0119]

[0120] In Tables 3 and 4, STO stands for Stock Transfer Order (STO for short).

[0121] The product sub-owner management method provided in this embodiment, before the product is transferred, updates the second owner information corresponding to the second pallet code in the preset pallet owner comparison relationship table based on the inventory transfer order, achieves the purpose of real-time modification of product inventory and corresponding owner information, and provides a basis for improving the accuracy of product inventory counting. After the product has been transferred, the corresponding owner return operation is performed based on the inventory transfer order, and the corresponding operation is performed according to whether the physical product is transferred or not, which is conducive to accurate inventory counting of product inventory and provides an inventory basis for refined management of sub-owners. Products are allocated to corresponding owners based on inventory differences, so that the product inventory corresponding to the second owner information in the preset pallet owner comparison relationship table and the physical product inventory corresponding to the physical owner are kept consistent in real time, achieving the purpose of keeping the online system consistent with the offline physical product inventory. When any two second owner information in the preset pallet owner comparison relationship table are internally transferred, the product inventory corresponding to any two second owner information in the preset pallet owner comparison relationship table is adjusted, so that the online system level automatically realizes the transfer between sub-owners, improves the transfer efficiency between sub-owners, thereby improving the corresponding efficiency of sales orders and saving the scanning cost of offline physical products. According to the product owner management method provided in this embodiment, the inventory counting accuracy can reach 100%.

[0122] In this embodiment, a product distribution owner management system is also provided, which is used to implement the above-mentioned embodiments and preferred implementation modes, and will not be repeated hereafter. As used below, the term "module" can be a combination of software and / or hardware that implements a predetermined function. Although the system described in the following embodiments is preferably implemented in software, the implementation of hardware, or a combination of software and hardware, is also possible and conceivable.

[0123] This embodiment provides a product distribution owner management system, such as Figure 8 As shown, including:

[0124] The code scanning device 801 is used to obtain first product attribute information and a corresponding first pallet code of a product to be distributed on a preset pallet.

[0125] The warehouse inventory subsystem 802 is used to obtain the first consignor information in the product sales order.

[0126] The warehouse management subsystem 803 is connected to the code scanning device and the warehouse inventory subsystem respectively, and is used to match the first owner information, the first pallet code and the first product attribute information with the second pallet code in the preset pallet owner comparison relationship table, and the second product attribute information and the second owner information corresponding to the second pallet code to obtain a matching result; according to the matching result, an allocation result of the to-be-allocated product is obtained, and the allocation result includes allocating the to-be-allocated product to the corresponding owner or modifying the preset pallet owner comparison relationship table, and allocating the to-be-allocated product to the corresponding owner according to the modified preset pallet owner comparison relationship table.

[0127] In some optional implementations, the warehouse management subsystem 803 includes:

[0128] The first matching module is used to determine that when the first pallet code and the second pallet code are consistent, the first owner information and the second owner information are consistent, and the first product attribute information and the second attribute information are consistent, the matching result is a consistent match.

[0129] The second matching module is used for, when any two of the first pallet code and the second pallet code, the first consignor information and the second consignor information, and the first product attribute information and the second attribute information are inconsistent, the matching result is inconsistent.

[0130] The first allocation module is used to obtain a matching result of allocating the product to be allocated to the corresponding consignor when the matching result is consistent.

[0131] The second allocation module is used to obtain the second owner information corresponding to the second pallet code in the preset pallet owner comparison relationship table when the matching result is inconsistent, and allocate the to-be-allocated products to the corresponding owners according to the modified second owner information.

[0132] The product distribution master management system also includes:

[0133] The write-off return subsystem is used to obtain the product inventory transfer order; before the product is transferred, the second owner information corresponding to the second pallet code in the preset pallet owner comparison relationship table is updated based on the inventory transfer order; after the product has been transferred, the corresponding owner return operation is performed based on the inventory transfer order.

[0134] The comparison subsystem is used to compare whether the product inventory corresponding to the second owner information in the preset pallet owner comparison table is consistent with the corresponding physical product inventory; if the comparison is inconsistent, the inventory difference between the product inventory corresponding to the second owner information and the corresponding physical product inventory is calculated, and the product is allocated to the corresponding owner based on the inventory difference.

[0135] The internal transfer subsystem is used to adjust the product inventory corresponding to any two second consignor information in the preset pallet owner comparison table when internal transfer is performed between any two second consignor information in the preset pallet owner comparison table, so that the product inventory corresponding to any two second consignor information can be internally transferred.

[0136] The further functional description of each of the above subsystems and modules is the same as that of the above corresponding embodiments and will not be repeated here.

[0137] The product distribution owner management system in this embodiment is presented in the form of functional modules, where the modules refer to ASIC (Application Specific Integrated Circuit) circuits, processors and memories that execute one or more software or fixed programs, and / or other devices that can provide the above functions.

[0138] The embodiment of the present invention also provides a computer device having the above Figure 8 The sub-consignor management system for the products shown.

[0139] See also Fig. 9 , Fig. 9 is a schematic diagram of the structure of a computer device provided by an optional embodiment of the present invention, such as Fig. 9 As shown, the computer device includes: one or more processors 10, a memory 20, and interfaces for connecting various components, including high-speed interfaces and low-speed interfaces. Various components are connected to each other using different buses for communication, and can be installed on a common mainboard or installed in other ways as needed. The processor can process the instructions executed in the computer device, including instructions stored in or on the memory to display the graphical information of the GUI on an external input / output device (such as, a display device coupled to the interface). In some optional embodiments, if necessary, multiple processors and / or multiple buses can be used together with multiple memories and multiple memories. Similarly, multiple computer devices can be connected, and each device provides some necessary operations (for example, as a server array, a group of blade servers, or a multi-processor system). Fig. 9 A processor 10 is taken as an example.

[0140] The processor 10 may be a central processing unit, a network processor or a combination thereof. The processor 10 may further include a hardware chip. The hardware chip may be a dedicated integrated circuit, a programmable logic device or a combination thereof. The programmable logic device may be a complex programmable logic device, a field programmable gate array, a general purpose array logic or any combination thereof.

[0141] The memory 20 stores instructions executable by at least one processor 10, so that the at least one processor 10 executes the method shown in the above embodiment.

[0142] The memory 20 may include a program storage area and a data storage area, wherein the program storage area may store an operating system, an application required for at least one function; the data storage area may store data created according to the use of the computer device, etc. In addition, the memory 20 may include a high-speed random access memory, and may also include a non-transient memory, such as at least one disk storage device, a flash memory device, or other non-transient solid-state storage device. In some optional embodiments, the memory 20 may optionally include a memory remotely arranged relative to the processor 10, and these remote memories may be connected to the computer device via a network. Examples of the above-mentioned network include, but are not limited to, the Internet, an intranet, a local area network, a mobile communication network, and combinations thereof.

[0143] The memory 20 may include a volatile memory, such as a random access memory; the memory may also include a non-volatile memory, such as a flash memory, a hard disk or a solid state drive; the memory 20 may also include a combination of the above types of memory.

[0144] The computer device also includes an input device 30 and an output device 40. The processor 10, the memory 20, the input device 30 and the output device 40 may be connected via a bus or other means. Fig. 9 The example of connecting through bus is taken in the following.

[0145] The input device 30 can receive input digital or character information, and generate key signal input related to the user settings and function control of the computer device, such as a touch screen, a keypad, a mouse, a track pad, a touch pad, an indicator bar, one or more mouse buttons, a trackball, a joystick, etc. The output device 40 may include a display device, an auxiliary lighting device (e.g., an LED) and a tactile feedback device (e.g., a vibration motor), etc. The above-mentioned display device includes but is not limited to a liquid crystal display, a light emitting diode, a display and a plasma display. In some optional embodiments, the display device may be a touch screen.

[0146] The embodiment of the present invention also provides a computer-readable storage medium. The method according to the embodiment of the present invention can be implemented in hardware, firmware, or can be implemented as a computer code that can be recorded in a storage medium, or can be implemented as a computer code that is originally stored in a remote storage medium or a non-temporary machine-readable storage medium and will be stored in a local storage medium through a network download, so that the method described herein can be stored in such software processing on a storage medium using a general-purpose computer, a dedicated processor, or programmable or dedicated hardware. Among them, the storage medium can be a magnetic disk, an optical disk, a read-only storage memory, a random access memory, a flash memory, a hard disk or a solid-state hard disk, etc.; further, the storage medium can also include a combination of the above types of memories. It can be understood that a computer, a processor, a microprocessor controller, or programmable hardware includes a storage component that can store or receive software or computer code. When the software or computer code is accessed and executed by a computer, a processor, or hardware, the method shown in the above embodiment is implemented.

[0147] Although the embodiments of the present invention have been described in conjunction with the accompanying drawings, those skilled in the art may make various modifications and variations without departing from the spirit and scope of the present invention, and such modifications and variations are all within the scope defined by the appended claims.

Claims

1. A method for managing product owners by category, characterized in that: The method comprises: Obtaining the first owner information in the product sales order, the first product attribute information of the product to be allocated on the preset pallet, and the corresponding first pallet code; Matching the first owner information, the first pallet code and the first product attribute information with the second pallet code and the second product attribute information and the second owner information corresponding to the second pallet code in the preset pallet owner comparison relationship table to obtain a matching result; Obtaining allocation results of the products to be allocated according to the matching results, the allocation results including allocating the products to be allocated to corresponding owners or modifying a preset pallet owner comparison relationship table, and allocating the products to be allocated to corresponding owners according to the modified preset pallet owner comparison relationship table; The method further includes: when internal transfer is performed between any two second consignor information in the preset pallet consignor comparison relationship table, adjusting the product inventory corresponding to any two second consignor information in the preset pallet consignor comparison relationship table, so that the product inventory corresponding to any two second consignor information is internally transferred.

2. The method according to claim 1, characterized in that The first owner information, the first pallet code and the first product attribute information are matched with the second pallet code and the second product attribute information and the second owner information corresponding to the second pallet code in the preset pallet owner comparison relationship table to obtain a matching result, including: When the first pallet code and the second pallet code are consistent, the first owner information and the second owner information are consistent, and the first product attribute information and the second attribute information are consistent, the matching result is consistent; When any two of the first pallet code and the second pallet code, the first consignor information and the second consignor information, and the first product attribute information and the second attribute information are inconsistent, the matching result is inconsistent matching.

3. The method according to claim 2, characterized in that Obtaining the allocation result of the product to be allocated according to the matching result includes: When the matching result is consistent, a matching result is obtained in which the product to be allocated is allocated to the corresponding consignor.

4. The method according to claim 2, characterized in that: Obtaining the allocation result of the product to be allocated according to the matching result also includes: When the matching result is inconsistent, the second owner information corresponding to the second pallet code in the preset pallet owner comparison table is modified, and the matching result of allocating the to-be-allocated products to the corresponding owners is obtained according to the modified second owner information.

5. The method according to claim 1, characterized in that The method further comprises: Get product stock transfer orders; Before the product is transferred, the second owner information corresponding to the second pallet code in the preset pallet owner comparison table is updated based on the inventory transfer order; After the product has been transferred, the corresponding owner will perform a return operation based on the inventory transfer order.

6. The method according to claim 1, characterized in that The second product attribute information includes product inventory, and the method further includes: Compare whether the product inventory corresponding to the second owner information in the preset pallet owner comparison table is consistent with the corresponding physical product inventory; If the comparison is inconsistent, the inventory difference between the product inventory corresponding to the second owner information and the corresponding physical product inventory is calculated, and the product is allocated to the corresponding owner based on the inventory difference.

7. A product distribution owner management system, characterized in that: The cargo distribution master management system includes: A code scanning device, used to obtain first product attribute information and a corresponding first pallet code of a product to be distributed on a preset pallet; The warehouse inventory subsystem is used to obtain the first owner information in the product sales order; The warehouse management subsystem is connected to the code scanning device and the warehouse inventory subsystem respectively, and is used to Matching the first owner information, the first pallet code and the first product attribute information with the second pallet code and the second product attribute information and the second owner information corresponding to the second pallet code in the preset pallet owner comparison relationship table to obtain a matching result; Obtaining allocation results of the products to be allocated according to the matching results, the allocation results including allocating the products to be allocated to corresponding owners or modifying a preset pallet owner comparison relationship table, and allocating the products to be allocated to corresponding owners according to the modified preset pallet owner comparison relationship table; It also includes: when internal transfer is performed between any two second consignor information in the preset pallet owner comparison relationship table, adjusting the product inventory corresponding to any two second consignor information in the preset pallet owner comparison relationship table, so that the product inventory corresponding to any two second consignor information can be internally transferred.

8. A computer device, characterized in that: include: A memory and a processor, wherein the memory and the processor are communicatively connected to each other, the memory stores computer instructions, and the processor executes the product consignor management method according to any one of claims 1 to 6 by executing the computer instructions.

9. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores computer instructions, and the computer instructions are used to enable a computer to execute the product consignor management method according to any one of claims 1 to 6.

Images