A dynamic expansion method for warehouse inventory management dimensions

Abstract

The present invention provides a method for dynamically expanding the dimensions of warehouse inventory management, including: setting the extended dimensions in the existing inventory management system, and after the setting is completed, the extended dimensions automatically cover the whole process management from material arrival, shelf storage, in-warehouse movement, inventory counting to material delivery; every time the document takes effect, the background queries the inventory quantity according to the set extended dimensions, if there is a key attribute of "yes" and the input control is enabled, the original batch management dimension and the corresponding attribute name in the existing inventory management system are used as the inventory dimension to determine the unique inventory information, otherwise the original batch management dimension is used as the inventory dimension to determine the inventory information; if the queried inventory information does not exist, the inventory information is added according to the corresponding inventory dimension. This technical solution introduces batch attributes as a new dimension that can be dynamically expanded for inventory management, so that inventory management can more accurately track and control the flow of products, thereby improving the level of refinement of inventory management.

Description

Technical Field

[0001] The present application belongs to the technical field of warehouse inventory management, and specifically relates to a method for dynamically expanding a warehouse inventory management dimension. Technical Background

[0002] There are many inventory management systems on the market, but most systems only support single-dimensional data management and query. For example, when dealing with material storage and retrieval, they often rely on simple storage location management and material attribute records. Since its inventory management dimensions cannot be customized and expanded according to the actual management mode, and in actual projects, warehouse inventory management dimensions are often more than these, materials need to record other attributes in inventory management, such as gross weight, quality grade, specifications, number of packages, and other dimensions. Therefore, the current inventory management system cannot meet the multi-dimensional requirements in complex business scenarios, and when faced with large amounts of data, the processing efficiency is low and it is difficult to meet the requirements of real-time and accuracy.

[0003] Existing solutions mostly focus on hardware upgrades or single-dimensional data optimization, which are difficult to meet complex and changing business needs, especially in terms of material batch management, traceability, and inventory optimization. Therefore, an innovative method is urgently needed to flexibly and efficiently expand the dimensions of inventory management and improve data processing capabilities without significantly increasing hardware costs. Summary of the invention

[0005] In view of the above-mentioned shortcomings and deficiencies of the prior art, the present invention provides a method for dynamic expansion of warehouse inventory management dimensions, allowing users to dynamically add, modify or delete data attributes, and through the adaptation of the entire process from material arrival, shelving and warehousing, movement within the warehouse, inventory counting to material delivery, multi-dimensional management and flexible expansion of data are achieved, thereby improving the efficiency, traceability and accuracy of inventory management.

[0006] In order to achieve the above object, the main technical solutions adopted by the present invention include:

[0007] An extended dimension is set in the existing inventory management system. The fields of the extended dimension include: attribute code, attribute name, whether it is a key attribute, whether input control is enabled, outbound control and inbound control. After the setting is completed, the extended dimension automatically covers the whole process management from material arrival, shelf storage, in-warehouse movement, inventory counting to material outbound;

[0008] Whenever a document becomes effective, the backend queries the inventory quantity according to the set extended dimension. If the key attribute is "yes" and the input control is enabled, the original batch management dimension and the corresponding attribute name in the existing inventory management system are used as the inventory dimension to determine the unique inventory information. Otherwise, the original batch management dimension is used as the inventory dimension to determine the inventory information. If the queried inventory information does not exist, the inventory information is added according to the corresponding inventory dimension.

[0009] After the document is entered into the warehouse and the inventory data is updated synchronously, the inbound and outbound flow information corresponding to the inventory dimension is generated.

[0010] Optionally, after the extended dimension configuration is completed, if the input control is enabled, the corresponding attribute name field will be automatically enabled in the relevant inbound and outbound documents and displayed in the corresponding workflow view page; the field can be hidden as needed.

[0011] Optionally, the extended dimension setting scenarios for otherwise determining inventory information by using the original batch management dimension as the inventory dimension include: the key attribute is "yes" and the input control is disabled, the key attribute is "no" and the input control is enabled, and the key attribute is "no" and the input control is disabled.

[0012] Optionally, the method also includes modifying the extended dimension fields, wherein the modifiable fields are only the attribute name, input control, outbound control and inbound control.

[0013] Optionally, the modification of the extended dimension field includes:

[0014] S100, obtaining historical key attribute information, determining whether it needs to be updated or adjusted, and if so, jumping to step S110;

[0015] S110. If the attribute name needs to be changed, a formal modification is made based on the original attribute name; if the input control needs to be changed to disabled, it is determined whether to dynamically summarize the inventory according to the original batch management dimension; if the input control needs to be changed to enabled, the corresponding attribute name is displayed in the relevant document, and the operation logic set by the outbound control and inbound control is executed; if the outbound control and inbound control need to be modified, only the outbound control and inbound control fields whose corresponding key attributes are no and are of numerical type can be selected;

[0016] S111. Update the original inventory information, inbound and outbound documents, quantity on hand and related fields of transaction information.

[0017] Optionally, the operating condition settings of the incoming control and the outgoing control include accumulation, deduction, manual accumulation, manual deduction, and none; when the key attribute of a certain attribute code is yes, the incoming control and the outgoing control corresponding to the attribute code are both set to none by default.

[0018] Optionally, when the outbound control and the inbound control are set to accumulation, manual accumulation, deduction or manual deduction and the corresponding input control is enabled, the system automatically accumulates, deducts or directly overwrites the corresponding inventory information when the material is put in and out of the warehouse; if the input control is disabled, the logical operations set by the outbound control and inbound control will not be performed on the material when it is put in and out of the warehouse.

[0019] Optionally, when the corresponding inventory information is accumulated, deducted or directly overwritten when the material is put into or taken out of the warehouse, the data filled in by the user needs to be verified. If the inventory is insufficient to support the input data, the system automatically prompts.

[0020] Optionally, when a field of the extended dimension needs to be deleted, the inventory is dynamically summarized according to the original batch management dimension, and the relevant inventory information, inbound and outbound documents, on-hand quantity and flow information are updated.

[0021] Optionally, the original batch management dimensions include materials, batch information, warehouses and cargo locations.

[0022] In summary, the technical solution of the present application introduces batch attributes as a new dynamically expandable dimension of inventory management, so that inventory management can more accurately track and control the flow of products, thereby improving the level of refinement of inventory management; by making full use of batch attribute information in the process links such as incoming warehouse management, outgoing warehouse management, and inventory management, the inventory management process is optimized to achieve efficient management and control of inventory, thereby improving the efficiency, traceability and accuracy of inventory management. BRIEF DESCRIPTION OF THE DRAWINGS

[0024] Figure 1 An interface for setting an extended dimension in a method for dynamically extending a warehouse inventory management dimension provided by an embodiment of the present invention;

[0025] Figure 2 An example diagram of the use of an extended dimension in a method for dynamically extending a warehouse inventory management dimension provided by an embodiment of the present invention;

[0026] Figure 3 A schematic diagram of a process of modifying an extended dimension in a dynamic extension method of a warehouse inventory management dimension provided by an embodiment of the present invention;

[0027] Figure 4A schematic diagram of the background automatic execution process after the entry order takes effect in a dynamic expansion method of a warehouse inventory management dimension provided by an embodiment of the present invention. DETAILED DESCRIPTION

[0028] In order to make the above-mentioned objects, features and advantages of the present invention more obvious and easy to understand, the specific embodiments of the present invention are described in detail below in conjunction with the accompanying drawings. Although certain embodiments of the present invention are shown in the accompanying drawings, it should be understood that the present invention can be implemented in various forms and should not be interpreted as being limited to the embodiments described herein. On the contrary, these embodiments are provided to provide a more thorough and complete understanding of the present invention. It should be understood that the drawings and embodiments of the present invention are only for exemplary purposes and are not intended to limit the scope of protection of the present invention.

[0029] It should be understood that the various steps described in the method embodiments of the present invention may be performed in different orders and / or in parallel. In addition, the method embodiments may include additional steps and / or omit the steps shown. The scope of the present invention is not limited in this respect.

[0030] The term "including" and its variations used in this document are open inclusions, that is, "including but not limited to". The term "based on" means "based at least in part on". The term "one embodiment" means "at least one embodiment"; the term "another embodiment" means "at least one other embodiment"; the term "some embodiments" means "at least some embodiments"; the term "optionally" means "optional embodiments". Relevant definitions of other terms will be given in the following description. It should be noted that the concepts of "first", "second", etc. mentioned in the present invention are only used to distinguish different devices, modules or units, and are not used to limit the order or interdependence of the functions performed by these devices, modules or units.

[0031] It should be noted that the modifications of "one" and "plurality" mentioned in the present invention are illustrative rather than restrictive, and those skilled in the art should understand that, unless otherwise clearly indicated in the context, it should be understood as "one or more".

[0032] With reference to the accompanying drawings, an embodiment of the present invention provides a method for dynamically expanding a warehouse inventory management dimension, including:

[0033] S1. Set up extended dimensions in the existing inventory management system. The fields of the extended dimensions include: attribute code, attribute name, whether it is a key attribute, whether to enable input control, outbound control and inbound control. After the setting is completed, the extended dimension automatically covers the whole process management from material arrival, shelf storage, in-warehouse movement, inventory counting to material outbound.

[0034] In this embodiment, the extended dimension is set as a batch attribute addition interface. The required batch attributes can be configured on site through this page. Clicking the Add or Modify button in the batch attribute management list view will pop up the page. In the batch attribute addition / modification page, the attribute code is a unique identifier and is associated with the existing system custom field; the attribute name is ordinary text to facilitate users to identify different batch attribute fields. Input control includes enable and disable, which are used to control whether the system is enabled to execute the inbound control and outbound control logic, and to control whether the corresponding attribute name is displayed in the relevant documents. Whether the key attribute is used to determine whether the field is used as a data refinement dimension when generating inventory on hand information. Outbound control and inbound control are specific operations that need to be performed when inventory is in and out of the warehouse. The operating condition settings for inbound control and outbound control include accumulation, deduction, manual accumulation, manual deduction, and none.

[0035] S2. Whenever a document takes effect, the background queries the inventory quantity according to the set extended dimension. If there is a key attribute with a value of "yes" and the input control is enabled, the original batch management dimension and the corresponding attribute name in the existing inventory management system are used as the inventory dimension to determine the unique inventory information. Otherwise, the original batch management dimension is used as the inventory dimension to determine the inventory information. If the queried inventory information does not exist, the inventory information is added according to the corresponding inventory dimension.

[0036] The original batch management dimension includes materials, batch information, warehouses, and storage locations. The situations where the original batch management dimension is used as the inventory dimension to determine inventory information include: the key attribute is "yes" and the input control is disabled, the key attribute is "no" and the input control is enabled, and the key attribute is "no" and the input control is disabled.

[0037] Specifically, the logical relationship between the remaining fields of the extended dimension is as follows:

[0038] (1) Between key attributes and inbound / outbound control: When the key attribute is set to "Yes", since this field is used as an inventory dimension to determine the unique inventory data when updating inventory information, rather than being used to record inventory data, the inbound / outbound control logic cannot be set at the same time. That is, the corresponding inbound control and outbound control are both set to None by default. Figure 2 Taking the attribute code uniqueAttr and the attribute name "Specification" as an example, the key attribute is set to "Yes", the input control is enabled, and the inbound control and outbound control corresponding to the attribute code are both set to None by default.

[0039] (2) Between input control and attribute name: After the extended dimension configuration is completed, if input control is enabled, the corresponding attribute name field will be automatically enabled in the related inbound and outbound documents and displayed in the corresponding workflow view page; the field can be hidden as needed; if input control is disabled, the corresponding attribute name will not be automatically added to the related documents.

[0040] (3) Between input control and outbound / inbound control: When input control is enabled, the system automatically executes the operation logic of outbound control and inbound control. For example, when outbound control and inbound control are set to accumulation, manual accumulation, deduction, or manual deduction and the corresponding input control is enabled, the system automatically accumulates, deducts, or directly overwrites the corresponding inventory information when the material enters or leaves the warehouse. When input control is disabled, the logical operations set by outbound control and inbound control are not performed on the material when it enters or leaves the warehouse.

[0041] Here, we take the attribute name field "outer packaging" with input control enabled and key attribute "yes" as an example to explain in detail. When the purchased goods are put into storage, the backend will match the existing inventory data according to the "material + batch number + warehouse + storage location + outer packaging" in the storage information as the matching condition. If the match is successful, the quantity of the matched inventory data will be added to the quantity of this storage. Otherwise, a new inventory data with the quantity of this storage will be created based on the current storage data. When stock is transferred, the "material + batch number + target warehouse + target storage location + outer packaging" in the transfer information will be used as the matching condition to match the inventory data of the target warehouse. If the match is successful, the quantity of the matched inventory data will be added to the quantity of this transfer storage. Otherwise, a new inventory data with the quantity of this storage will be created based on the current transfer storage data. The possible situations here are as follows: if there is inventory with the same material, batch number, warehouse, and storage location, but the outer packaging of the inventory is "paper packaging box", and the outer packaging of the storage data is "plastic film". When selling out, the "material + batch number + warehouse + storage location + outer packaging" in the outbound information will be used as the matching condition to match the existing inventory data. If the match is successful, the quantity of the matched inventory data will be subtracted from the quantity of this outbound shipment, otherwise it will prompt "Insufficient inventory".

[0042] For another example, take the batch attribute field such as "block number" with input control enabled and non-key attributes, and set the incoming control to accumulation and the outgoing control to deduction as an example: when the purchased goods are put into the warehouse, the "material + batch number + warehouse + storage location" in the incoming information will be used as the matching condition to match with the existing inventory data. If the match is successful, the block number of the matched inventory data will be accumulated with the number of this incoming warehouse (for example, the number of blocks in the inventory data is 10, and the number of blocks in the current incoming warehouse data is 1, then the number of blocks in the inventory data will be updated to 11 after the successful entry); otherwise, a new inventory data with the inventory quantity being the current incoming warehouse quantity and the block number being the block number of the current incoming warehouse data will be created based on the current incoming warehouse data. When selling out, the "material + batch number + warehouse + storage location" in the outbound information will be used as the matching condition to match the existing inventory data. If the match is successful, the number of blocks of the matched inventory data will be subtracted from the number of blocks of the outbound data this time (for example, the number of blocks of the inventory data is 10, and the number of blocks of the outbound data this time is 1, then the number of blocks of the inventory data will be updated to 9 after the outbound is successful). If the number of blocks of the inventory data is less than the number of blocks of the outbound data this time, a prompt will be displayed saying "Insufficient inventory blocks for outbound!".

[0043] S3. After the document is entered into the warehouse and the inventory data is updated synchronously, the inbound and outbound flow information containing the corresponding inventory dimensions is generated.

[0044] Of course, the technical solution of this embodiment also supports the modification and deletion of extended dimension fields. To ensure that the data is valid and reliable, users are only supported to modify the attribute names and input controls to reduce the possibility of dirty data generation.

[0045] Modifications to the extended dimension fields include:

[0046] S100, obtaining historical key attribute information, determining whether it needs to be updated or adjusted, and if so, jumping to step S110.

[0047] The historical key attribute information here includes inventory information determined by the original batch management dimension and inventory information determined by the original batch management dimension and attribute name.

[0048] S110. If the attribute name needs to be changed, make formal modifications based on the original attribute name; if the input control needs to be changed to disabled, determine whether to dynamically summarize the inventory according to the original batch management dimension; if the input control needs to be changed to enabled, display the corresponding attribute name in the relevant document, and execute the operation logic of the outbound control and inbound control settings; if the outbound control and the inbound control need to be modified, only the outbound control and inbound control fields whose corresponding key attributes are no and are of numerical type can be selected.

[0049] Specifically, the formal modification of the attribute name does not involve substantial changes. For example, the original attribute name is "outer packaging", which is modified to "packaging method". The modification of the attribute name does not affect the inventory dimension and whether it is necessary to determine whether new inventory information data needs to be added based on the inventory dimension. When the input control is changed from the original enable to disable, it is necessary to determine whether the inventory data will be affected. For example, before deactivation, there are two pieces of data that only differ in the outer packaging, one is film packaging and the other is plastic packaging. When the outer packaging field is deactivated, these two pieces of inventory data need to be merged. For another example, for the inbound / outbound control field with the key attribute of "yes", the default is none, so it cannot be modified; for the inbound / outbound control field with the key attribute of "no" and the attribute format is numeric, you can choose to change to none, accumulation, deduction and other operations.

[0050] S111. Update the original inventory information, inbound and outbound documents, quantity on hand and related fields of transaction information.

[0051] Deletion of extended dimension fields includes: dynamically aggregating inventory based on the original batch management dimension, updating related inventory information, inbound and outbound documents, quantity on hand, and transaction information.

[0052] In particular, if multiple batch attribute fields are used at the same time, when updating inventory information, the background will determine the unique inventory information based on all enabled batch attribute fields and grouping by whether they are key attributes, using materials, batch information, warehouses, storage locations, and all batch attribute fields that are key attributes. If the inventory data does not exist, a new piece of data will be added, and the remaining non-key attribute batch attribute fields and other data will be recorded in the inventory data. When the user wants to modify the inbound and outbound control logic of non-key attribute batch attribute fields, he only needs to modify the logic of inbound control and outbound control to the required logic on the batch attribute management page. After that, the inventory data will be updated according to the new logic when inbound and outbound.

[0053] Although the present invention is disclosed as above, the protection scope of the present invention is not limited thereto. Those skilled in the art may make various changes and modifications without departing from the spirit and scope of the present invention, and these changes and modifications will fall within the protection scope of the present invention.

Claims

1. A dynamic expansion method for warehouse inventory management dimensions, characterized in that include: An extended dimension is set in the existing inventory management system. The fields of the extended dimension include: attribute code, attribute name, whether it is a key attribute, whether input control is enabled, outbound control and inbound control. After the setting is completed, the extended dimension automatically covers the whole process management from material arrival, shelf storage, in-warehouse movement, inventory counting to material outbound; Whenever a document becomes effective, the backend queries the inventory quantity according to the set extended dimension. If the key attribute is "yes" and the input control is enabled, the original batch management dimension and the corresponding attribute name in the existing inventory management system are used as the inventory dimension to determine the unique inventory information. Otherwise, the original batch management dimension is used as the inventory dimension to determine the inventory information. If the queried inventory information does not exist, the inventory information is added according to the corresponding inventory dimension. After the document is entered into the warehouse and the inventory data is updated synchronously, the inbound and outbound flow information corresponding to the inventory dimension is generated.

2. A method for dynamically expanding warehouse inventory management dimensions as claimed in claim 1, characterized in that After the extended dimension configuration is completed, if the input control is enabled, the corresponding attribute name field will be automatically enabled in the relevant inbound and outbound documents and displayed in the corresponding workflow view page; the field can be hidden as needed.

3. A method for dynamically expanding the warehouse inventory management dimension as claimed in claim 1, characterized in that Otherwise, the extended dimension setting scenarios for determining inventory information by using the original batch management dimension as the inventory dimension include: the key attribute is "yes" and the input control is disabled, the key attribute is "no" and the input control is enabled, and the key attribute is "no" and the input control is disabled.

4. A method for dynamically expanding a warehouse inventory management dimension as claimed in claim 1, characterized in that The method also includes modifying the extended dimension fields, wherein the modifiable fields are only the attribute name, input control, the outbound control and the inbound control.

5. A method for dynamically expanding the warehouse inventory management dimension as claimed in claim 4, characterized in that The modification of the extended dimension field includes: S100, obtaining historical key attribute information, determining whether it needs to be updated or adjusted, and if so, jumping to step S110; S110. If the attribute name needs to be changed, a formal modification is made based on the original attribute name; if the input control needs to be changed to disabled, it is determined whether to dynamically summarize the inventory according to the original batch management dimension; if the input control needs to be changed to enabled, the corresponding attribute name is displayed in the relevant document, and the operation logic set by the outbound control and inbound control is executed; if the outbound control and inbound control need to be modified, only the outbound control and inbound control fields whose corresponding key attributes are no and are of numerical type can be selected; S111. Update the original inventory information, inbound and outbound documents, quantity on hand and related fields of transaction information.

6. A method for dynamically expanding warehouse inventory management dimensions as claimed in claim 1, characterized in that The operating condition settings of the inbound control and outbound control include accumulation, deduction, manual accumulation, manual deduction, and none; when the key attribute of a certain attribute code is yes, the inbound control and the outbound control corresponding to the attribute code are both set to none by default.

7. A method for dynamically expanding warehouse inventory management dimensions as claimed in claim 6, characterized in that When the outbound control and the inbound control are set to accumulation, manual accumulation, deduction or manual deduction and the corresponding input control is enabled, the system automatically accumulates, deducts or directly overwrites the corresponding inventory information when the material is put in and out of the warehouse; if the input control is disabled, the logical operations set by the outbound control and inbound control will not be performed on the material when it is put in and out of the warehouse.

8. A method for dynamically expanding warehouse inventory management dimensions as claimed in claim 7, characterized in that When the corresponding inventory information is accumulated, deducted or directly overwritten when the material is put into or out of the warehouse, the data filled in by the user needs to be verified. If the inventory is insufficient to support the input data, the system will automatically prompt.

9. A method for dynamically expanding warehouse inventory management dimensions as claimed in claim 1, characterized in that When it is necessary to delete a field of the extended dimension, the inventory is dynamically summarized according to the original batch management dimension, and the relevant inventory information, inbound and outbound documents, on-hand quantity and flow information are updated.

10. A method for dynamically expanding a warehouse inventory management dimension as described in any one of claims 1 to 9, characterized in that The original batch management dimensions include materials, batch information, warehouses and cargo locations.

Images