Dynamic dimension inventory management method, system and readable storage medium

Abstract

The present invention proposes a dynamic dimension inventory management method, system and readable storage medium. Among them, the dynamic dimension inventory management method includes: adding a new inventory dimension and configuring an inventory dimension mapping relationship; obtaining business data, and converting the business data into inventory data according to the inventory dimension mapping relationship; updating the inventory data of all inventory dimensions in the system; wherein the inventory dimension mapping relationship is a mapping relationship between the inventory data of the newly added inventory dimension and the inventory data of the historical inventory dimension. The dynamic dimension inventory management method provided by the present invention configures an inventory dimension mapping relationship, converts business data into inventory data according to the inventory dimension mapping relationship, forms inventory data of a new inventory dimension, and updates inventory data of all inventory dimensions in the system. Without modifying the code logic, business data is converted into inventory data according to user needs, which meets the user's usage requirements and reduces the workload of secondary development of the system.

Description

Technical Field

[0001] The present invention relates to the technical field of inventory management, and in particular to a dynamic dimensional inventory management method, a dynamic dimensional inventory management system and a readable storage medium. Background Art

[0002] In the related art, the inventory management system provides many dimensions and then meets the needs of different businesses through parameter options. However, the inventory dimensions in the existing inventory management system are fixed and cannot meet customer needs. Summary of the invention

[0003] The present invention aims to solve at least one of the technical problems existing in the prior art or related art.

[0004] To this end, the first aspect of the present invention is to propose a dynamic dimensional inventory management method.

[0005] The second aspect of the present invention is to propose a dynamic dimensional inventory management system.

[0006] A third aspect of the present invention provides a readable storage medium.

[0007] In view of this, according to a first aspect of the present invention, a dynamic dimension inventory management method is proposed, including: adding a new inventory dimension and configuring an inventory dimension mapping relationship; acquiring business data and converting the business data into inventory data according to the inventory dimension mapping relationship; updating the inventory data of all inventory dimensions in the system; wherein the inventory dimension mapping relationship is a mapping relationship between the inventory data of the newly added inventory dimension and the inventory data of the historical inventory dimension.

[0008] The dynamic dimension inventory management method provided by the present invention configures inventory dimension mapping relationships, converts business data into inventory data according to the inventory dimension mapping relationships, forms inventory data of new inventory dimensions, and updates inventory data of all inventory dimensions in the system. Without modifying the code logic, business data is converted into inventory data according to user needs, thereby satisfying the user's usage needs and reducing the workload of secondary development of the system.

[0009] Specifically, the stock dimension relationship is a mapping relationship between the stock data of the newly added stock dimension and the stock data of the historical stock dimension, that is, the stock data in the newly added stock dimension is calculated according to the preset mapping relationship based on the stock data in the existing stock dimensions in the system, without the need to add new code logic.

[0010] In addition, the dynamic dimension inventory management method in the above technical solution provided by the present invention may also have the following additional technical features:

[0011] In the above technical solution, further, the step of adding a new stock dimension specifically includes: using the stock custom item field as the new stock dimension field, and setting the data type of the new stock dimension; wherein the data type includes: one or a combination of text, number, date, enumeration, custom file and basic file.

[0012] In this technical solution, the inventory custom item field in the inventory management system is used as a newly added inventory dimension field, and the data type of the newly added inventory dimension is set according to the requirements. The data type can include text, value, date, enumeration, custom file and basic file, etc. By using the custom item field as a newly added inventory dimension field, because the custom item field is already the code logic written in the system, there is no need to add the code logic corresponding to the inventory dimension in the system, which reduces the workload of developers and avoids secondary development of the system.

[0013] In any of the above technical solutions, further, the step of converting business data into stock data according to the stock dimension mapping relationship specifically includes: determining the business document that affects the stock, and converting the business data in the business document into stock data according to the stock dimension mapping relationship.

[0014] In this technical solution, the business documents that currently affect the inventory are determined, the business data therein is extracted, and the business data is converted into inventory data according to the preset inventory dimension mapping relationship. Specifically, the business data in the business document corresponds to the existing inventory dimensions in the system, so the inventory data of the historical inventory dimensions can be converted into the inventory data of the newly added inventory dimensions according to the configured inventory dimension mapping relationship. By converting the business documents that affect the inventory into the inventory data in the inventory dimension, the problem of poor stability of the inventory data in the current system can be solved, and the personalized needs of users can be met at the same time.

[0015] In any of the above technical solutions, before the step of further determining the business document that affects the inventory, it also includes: putting the inventory dimension mapping relationship into the cache.

[0016] In this technical solution, before determining the business document that affects the inventory, the inventory dimension mapping relationship is first placed in the cache. When it is necessary to convert the inventory data of the historical inventory dimension into the inventory data of the newly added inventory dimension according to the configured inventory dimension mapping relationship, the cached inventory dimension mapping relationship can be directly called, thereby improving work efficiency.

[0017] In any of the above technical solutions, further, the step of converting business data into stock data according to the stock dimension mapping relationship also includes: converting business data into stock data according to the stock dimension mapping relationship and a preset formula.

[0018] In this technical solution, in the process of converting business data into stock data, in addition to the preset stock dimension mapping relationship, the conversion can also be performed according to a preset formula. Users can customize the formula according to actual conditions, where the formula can express the mathematical relationship between business data and stock data. By customizing the preset formula by the user, the user's usage needs can be met, while the accuracy of calculating stock data can be improved.

[0019] In any of the above technical solutions, further, the step of updating the inventory data of all inventory dimensions in the system specifically includes: based on outbound or inventory occupancy operations, checking and updating the inventory data of all inventory dimensions.

[0020] In this technical solution, according to the outbound or inventory occupation operations issued by the user, the inventory data of all inventory dimensions in the system are detected, and all inventory data after the user operation is recalculated and updated in the system. By responding to the user's outbound or inventory occupation operations, the inventory data in the system is checked and updated, ensuring the timeliness and accuracy of the inventory data in the system.

[0021] In any of the above technical solutions, further, the step of updating the inventory data of all inventory dimensions in the system also includes: updating the inventory data of all inventory dimensions based on warehousing or pre-warehousing operations.

[0022] In this technical solution, according to the storage or pre-storage operation issued by the user, all inventory data after the user operation is recalculated and updated in the system. By responding to the user's storage or pre-storage operation, the inventory data in the system is updated, ensuring the timeliness and accuracy of the inventory data in the system.

[0023] According to a second aspect of the present invention, a dynamic dimensional inventory management system is proposed, comprising: a memory storing a computer program; a processor, and the processor executes the dynamic dimensional inventory management method in any of the above technical solutions when executing the computer program. Therefore, the dynamic dimensional inventory management system has all the beneficial effects of the dynamic dimensional inventory management method proposed in the first aspect.

[0024] In addition, the dynamic dimension inventory management system in the above technical solution provided by the present invention may also have the following additional technical features:

[0025] In the above technical solution, further, the processor is connected to the distributed engine, and the distributed engine is used to implement a rollback operation based on a commit operation of the stock data when an exception occurs in a remote service call of the system.

[0026] In this technical solution, the processor is connected to the distributed engine to support distributed transactions of stock submission services. When the system makes a remote call, if a data anomaly occurs, the distributed engine can implement a rollback operation, thereby ensuring data consistency and improving the stability of system operation.

[0027] According to a third aspect of the present invention, a readable storage medium is provided, on which a program is stored, and when the program is executed by a processor, the dynamic dimensional inventory management method provided in the first aspect is performed. Therefore, the readable storage medium has all the beneficial effects of the dynamic dimensional inventory management method provided in the first aspect.

[0028] Additional aspects and advantages of the present invention will become apparent in the following description or may be learned by practice of the present invention. BRIEF DESCRIPTION OF THE DRAWINGS

[0029] In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, 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 invention. For ordinary technicians in this field, other drawings can be obtained based on the structures shown in these drawings without paying creative work.

[0030] Figure 1 A schematic diagram of a dynamic dimension inventory management method flow chart according to an embodiment of the present invention is shown;

[0031] Figure 2 A schematic diagram of a dynamic dimension inventory management method flow chart of another embodiment of the present invention is shown;

[0032] Figure 3 A schematic diagram of a dynamic dimension inventory management method according to another embodiment of the present invention is shown;

[0033] Figure 4 A schematic diagram of a dynamic dimension inventory management method flow chart of another embodiment of the present invention is shown;

[0034] Figure 5 A schematic diagram of a dynamic dimension inventory management method flow chart of another embodiment of the present invention is shown;

[0035] Figure 6 A schematic diagram of a dynamic dimensional inventory management device according to another embodiment of the present invention is shown.

[0036] The realization of the purpose, functional features and advantages of the present invention will be further explained in conjunction with embodiments and with reference to the accompanying drawings. DETAILED DESCRIPTION

[0037] In order to more clearly understand the above-mentioned purpose, features and advantages of the present invention, the present invention is further described in detail below in conjunction with the accompanying drawings and specific embodiments. It should be noted that the embodiments of the present invention and the features in the embodiments can be combined with each other without conflict.

[0038] In the following description, many specific details are set forth to facilitate a full understanding of the present invention. However, the present invention may also be implemented in other ways different from those described herein. Therefore, the protection scope of the present invention is not limited to the specific embodiments disclosed below.

[0039] The existing inventory update control is a code logic that has been set according to the fixed inventory dimension mode. When the system needs to add or redevelop a business document that affects the inventory, the code of the inventory update logic must be modified. The present invention generates a model of inventory objects based on the inventory dimension mapping relationship. When the system needs to add or redevelop a business document that affects the inventory, there is no need to modify the code.

[0040] Refer to the following Figures 1 to 6 A dynamic dimensional inventory management method, a dynamic dimensional inventory management system, and a readable storage medium according to some embodiments of the present invention are described.

[0041] Embodiment 1:

[0042] like Figure 1 As shown, according to an embodiment of the present invention, a dynamic dimension inventory management method is proposed, the method comprising:

[0043] Step 102, adding a new stock dimension and configuring the stock dimension mapping relationship;

[0044] Step 104, acquiring business data, and converting the business data into stock data according to the stock dimension mapping relationship;

[0045] Step 106, updating the inventory data of all inventory dimensions in the system.

[0046] Among them, the stock dimension mapping relationship is the mapping relationship between the stock data of the newly added stock dimension and the stock data of the historical stock dimension.

[0047] In this embodiment, the specific steps of adding a new stock dimension are: configuring a stock dimension mapping relationship, converting business data into stock data according to the stock dimension mapping relationship, forming stock data of a new stock dimension, and updating the stock data of all stock dimensions in the system. Without modifying the code logic, business data is converted into stock data according to user needs, which meets the user's usage needs and avoids secondary development of the system.

[0048] Specifically, the stock dimension mapping relationship is the mapping relationship between the stock data of the newly added stock dimension and the stock data of the historical stock dimension, that is, the stock data in the newly added stock dimension is calculated according to the preset mapping relationship based on the stock data in the existing stock dimensions in the system, without the need to add new code logic.

[0049] The preset inventory dimension mapping relationship needs to be stored in the database. In another specific embodiment, the inventory dimension mapping relationship may include a sequence number, a document object attribute, an inventory object attribute, whether it is an inventory dimension, and a calculation formula, etc. Table 1 is a specific example of an inventory dimension mapping relationship.

[0050] Serial number Document Object Properties Stock object properties Whether the dimension is inventory formula 1 Warehouse Warehouse 1 2 purchaseOrg org 1 3 item product 1 4 qty qty 0 (qty*this.rate) 5 Define1 Define1 1

[0051] Table 1

[0052] Embodiment 2:

[0053] According to an embodiment of the present invention, a dynamic dimension inventory management method is proposed. Step 102 is a step of adding an inventory dimension and configuring an inventory dimension mapping relationship, which specifically includes:

[0054] Use the inventory custom item field as a new inventory dimension field and set the data type of the new inventory dimension.

[0055] In this embodiment, the operation of adding a new inventory dimension can use the inventory custom item field in the inventory management system as the newly added inventory dimension field, and set the data type of the newly added inventory dimension according to the specific needs of the user. By using the custom item field as the newly added inventory dimension field, because the custom item field is already the code logic written in the system, there is no need to add the code logic corresponding to the inventory dimension in the system, which reduces the workload of developers and the task of secondary development of the system.

[0056] Specifically, data types may include text, value, date, enumeration, custom archive, basic archive, etc. The data type of the newly added inventory dimension may be defined or expanded according to actual conditions.

[0057] Embodiment 3:

[0058] According to an embodiment of the present invention, a dynamic dimension inventory management method is proposed. In step 104, the specific steps of converting business data into inventory data according to the inventory dimension mapping relationship specifically include:

[0059] Determine the business documents that affect the inventory, and convert the business data in the business documents into inventory data based on the inventory dimension mapping relationship.

[0060] In this embodiment, the business document that currently affects the inventory is determined, the business data therein is extracted, and the business data is converted into inventory data according to the preset inventory dimension mapping relationship. Specifically, the business data in the business document corresponds to the existing inventory dimension in the system, so the inventory data of the historical inventory dimension can be converted into the inventory data of the newly added inventory dimension according to the configured inventory dimension mapping relationship. By converting the business document that affects the inventory into the inventory data in the inventory dimension, the problem of poor stability of the inventory data in the current system can be solved, and the personalized needs of users can be met at the same time.

[0061] Embodiment 4:

[0062] like Figure 2 As shown, according to an embodiment of the present invention, a dynamic dimension inventory management method is proposed, the method comprising:

[0063] Step 202, adding a new stock dimension and configuring the stock dimension mapping relationship;

[0064] Step 204, putting the existing dimension mapping relationship into the cache;

[0065] Step 206, obtaining business data and determining business documents that affect inventory;

[0066] Step 208, converting the business data in the business document into stock data according to the stock dimension mapping relationship;

[0067] Step 210, updating the inventory data of all inventory dimensions in the system.

[0068] In this embodiment, after configuring the inventory dimension mapping relationship, before determining the business document that affects the inventory, the inventory dimension mapping relationship is first placed in the cache. When it is necessary to convert the inventory data of the historical inventory dimension into the inventory data of the newly added inventory dimension according to the configured inventory dimension mapping relationship, the cached inventory dimension mapping relationship can be directly called, thereby improving work efficiency.

[0069] Embodiment 5:

[0070] like Figure 3 As shown, according to an embodiment of the present invention, a dynamic dimension inventory management method is proposed, comprising:

[0071] Step 302, adding a new stock dimension and configuring the stock dimension mapping relationship;

[0072] Step 304, obtain business data and determine the business documents that affect the inventory;

[0073] Step 306, converting the business data into stock data according to the stock dimension mapping relationship and the preset formula;

[0074] Step 308: Update the inventory data of all inventory dimensions in the system.

[0075] In this embodiment, in the process of converting business data into stock data, the conversion can be performed according to the preset stock dimension mapping relationship and the preset formula. The user can customize the formula according to the actual situation. Among them, the formula can express the mathematical relationship between business data and stock data. By customizing the preset formula by the user, the user's usage needs can be met, and the accuracy of calculating the stock data can be improved.

[0076] Embodiment 6:

[0077] like Figure 4 As shown, according to an embodiment of the present invention, a dynamic dimension inventory management method is proposed, the method comprising:

[0078] Step 402, adding a new stock dimension and configuring the stock dimension mapping relationship;

[0079] Step 404, obtaining business data, and converting the business data into stock data according to the stock dimension mapping relationship;

[0080] Step 406: Based on the outbound or inventory occupancy operations, check and update the inventory data of all inventory dimensions.

[0081] In this embodiment, according to the outbound or inventory occupation operation issued by the user, the inventory data of all inventory dimensions in the system are detected, and all inventory data after the user operation is recalculated and updated in the system. By responding to the outbound or inventory occupation operation of the user, the inventory data in the system is checked and updated, thereby ensuring the timeliness and accuracy of the inventory data in the system.

[0082] Embodiment 7:

[0083] like Figure 5 As shown, according to an embodiment of the present invention, a dynamic dimension inventory management method is proposed, the method comprising:

[0084] Step 502, adding a new stock dimension and configuring a stock dimension mapping relationship;

[0085] Step 504, obtaining business data, and converting the business data into stock data according to the stock dimension mapping relationship;

[0086] Step 506: Based on the warehousing or pre-warehousing operations, update the inventory data of all inventory dimensions.

[0087] In this embodiment, according to the storage or pre-storage operation issued by the user, all inventory data after the user operation is recalculated and updated in the system. By responding to the user's storage or pre-storage operation, the inventory data in the system is updated, ensuring the timeliness and accuracy of the inventory data in the system.

[0088] Example 8

[0089] like Figure 6 As shown, according to one embodiment of the present invention, a dynamic dimension inventory management device 6 is proposed, which is used to implement the dynamic dimension inventory management method in any of the above embodiments, and the device includes:

[0090] Dimension extension unit 602, dimension extension unit 602 includes stock dimension activation module 6002 and stock dimension mapping relationship configuration module 6004. Among them, stock dimension activation module 6002 is responsible for the activation of new stock dimensions, and stock custom item fields can be used as new dimension fields. When enabling new stock dimensions, the data type of the dimension can be defined. The data type supports multiple types such as text, number, date, enumeration, custom file, basic file, etc. The stock dimension mapping relationship configuration module 6004 is used to configure the stock dimension mapping relationship;

[0091] Stock conversion unit 604, for business documents that affect stock, before updating the stock, business data needs to be converted into stock data. Stock conversion unit 604 completes the function of converting business data into stock data, and the conversion is based on the stock dimension mapping relationship. In order to improve efficiency, the stock conversion mapping relationship needs to be cached. The conversion process supports functions such as custom formulas, and supports formula calculation when processing data;

[0092] The inventory control submission unit 606 needs to check the available quantity and update the inventory information according to the inventory dimension for outbound or inventory occupation operations, and needs to update the inventory information according to the inventory dimension for inbound or pre-inbound operations.

[0093] At the same time, the stock submission service supports distributed transactions. When calling remotely across microservices, if the distributed transaction engine is responsible for the transaction exception, the rollback operation is implemented by rolling back the rollback interface of the stock submission, ensuring data consistency.

[0094] The present invention generates a model of stock objects based on the stock dimension mapping relationship. When the system needs to add or redevelop a business document that affects the stock, there is no need to modify the code.

[0095] Embodiment 9:

[0096] According to an embodiment of the second aspect of the present invention, a dynamic dimensional inventory management system is proposed, comprising: a memory storing a computer program; a processor, and the processor executes the dynamic dimensional inventory management method in any of the above embodiments when executing the computer program. Therefore, the dynamic dimensional inventory management system has all the beneficial effects of the dynamic dimensional inventory management method proposed in the first aspect.

[0097] Embodiment 10:

[0098] According to a specific embodiment of the present invention, another dynamic dimension inventory management system is proposed, which specifically includes: a processor connected to a distributed engine, and the distributed engine is used to implement a rollback operation based on a submission operation of inventory data when an exception occurs in a remote service call of the system.

[0099] In this embodiment, the processor is connected to the distributed engine to support distributed transactions of the stock commit service. When the system makes a remote call, if a data anomaly occurs, a rollback operation can be implemented through the distributed engine, thereby ensuring data consistency and improving the stability of system operation.

[0100] Embodiment 11:

[0101] According to an embodiment of the third aspect of the present invention, a computer-readable storage medium is provided, on which a program is stored, and when the program is executed by a processor, the dynamic dimension inventory management method provided in the first aspect is performed. Therefore, the computer-readable storage medium has all the beneficial effects of the dynamic dimension inventory management method provided in the first aspect, which will not be described in detail here.

[0102] In the description of this specification, the terms "first" and "second" are used for descriptive purposes only and cannot be understood as indicating or implying relative importance unless otherwise clearly specified and limited; the terms "connection", "installation", "fixation" and the like should be understood in a broad sense, for example, "connection" can be a fixed connection, a detachable connection, or an integral connection; it can be directly connected or indirectly connected through an intermediate medium. For ordinary technicians in this field, the specific meanings of the above terms in the present invention can be understood according to specific circumstances.

[0103] In the description of this specification, the description of the terms "one embodiment", "some embodiments", "specific embodiments", etc. means that the specific features, structures, materials or characteristics described in conjunction with the embodiment or example are included in at least one embodiment or example of the present invention. In this specification, the schematic representation of the above terms does not necessarily refer to the same embodiment or example. Moreover, the specific features, structures, materials or characteristics described can be combined in any one or more embodiments or examples in a suitable manner.

[0104] The above description is only a preferred embodiment of the present invention and is not intended to limit the present invention. For those skilled in the art, the present invention may have various modifications and variations. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present invention shall be included in the protection scope of the present invention.

Claims

1. A dynamic dimension inventory management method, characterized in that: include: Add stock dimensions and configure stock dimension mapping relationships; Acquire business data, and convert the business data into stock data according to the stock dimension mapping relationship; Update the inventory data of all inventory dimensions in the system; The stock dimension mapping relationship is a mapping relationship between the stock data of the newly added stock dimension and the stock data of the historical stock dimension; The step of adding a new stock dimension specifically includes: Use the inventory custom item field as a new inventory dimension field, and set the data type of the new inventory dimension; The data type includes: one or a combination of text, value, date, enumeration, custom file and basic file; The step of converting the business data into stock data according to the stock dimension mapping relationship specifically includes: Determine a business document that affects the inventory, and convert business data in the business document into inventory data according to the inventory dimension mapping relationship; Before determining the steps of business documents that affect inventory, it also includes: Put the existing dimension mapping relationship into a cache; The step of converting the business data into stock data according to the stock dimension mapping relationship further includes: The business data is converted into the stock data according to the stock dimension mapping relationship and a preset formula.

2. The dynamic dimension inventory management method according to claim 1, characterized in that: The steps to update the inventory data of all inventory dimensions in the system include: Based on outbound or inventory occupancy operations, check and update the inventory data of all inventory dimensions.

3. The dynamic dimension inventory management method according to claim 1, characterized in that: The step of updating the inventory data of all inventory dimensions in the system also includes: Based on warehousing or pre-warehousing operations, update the inventory data of all inventory dimensions.

4. A dynamic dimensional inventory management system, characterized in that: include: a memory storing a computer program; A processor, wherein when executing the computer program, the processor performs the dynamic dimensional inventory management method according to any one of claims 1 to 3.

5. The dynamic dimensional inventory management system according to claim 4, characterized in that: The processor is connected to a distributed engine, and the distributed engine is used to implement a rollback operation based on a commit operation of stock data when an exception occurs in a remote service call of the system.

6. A readable storage medium having a program stored thereon, characterized in that: When the program is executed by a processor, the dynamic dimensional inventory management method according to any one of claims 1 to 3 is performed.

Images