An asset inventory auditing method and device based on spatial difference detection

Abstract

The application discloses an asset inventory auditing method and device based on spatial difference detection. The method comprises the following steps: collecting original asset room original asset numbers, original areas, original layer heights and original functions, setting reference areas and reference layer heights, and acquiring original first weights and original second weights according to the original functions; collecting current asset room current asset numbers, current areas, current layer heights and current functions corresponding to the original asset rooms, acquiring current first weights and current second weights according to the current functions; judging whether the current asset room corresponds to the original asset room according to the original asset numbers and the current asset numbers; if not, triggering manual auditing; if yes, proceeding to the next step; calculating a dynamic deviation value; judging whether the dynamic deviation value is greater than a preset value, if not, recording the current asset room current asset numbers, current areas, current layer heights and current functions; if yes, triggering manual auditing. The method reduces the manual intervention range of inventory auditing.

Description

Technical Field

[0001] This invention relates to asset inventory auditing, and in particular to an asset inventory auditing method and apparatus based on spatial difference detection. Background Technology

[0002] As a core node in the supply chain, modern logistics parks are facing severe challenges due to the increasing complexity of asset management. The industry generally suffers from the following technical bottlenecks: lack of dynamic space management: 82% of logistics parks still use static two-dimensional plan management systems, which cannot cope with the daily average spatial layout change rate of 0.7% (such as partition wall renovation, floor height adjustment, etc.).

[0003] In specific scenarios such as Transfar Highway Port, the technical pain points become even more prominent: Diverse spatial forms: The six types of highway ports, including base type and station type, have different spatial structures (such as floor heights ranging from 4 to 12 meters and multi-story warehouses).

[0004] Frequent dynamic upgrades: To adapt to customer needs, a single highway port implements an average of 32 space upgrades per year (data source: Transfar Logistics 2022 Operation Report). However, the existing system lacks: an automatic recording mechanism for the upgrade process, an automatic calibration function for space data after changes, and a digital channel for remote review by headquarters.

[0005] Data credibility crisis: methods for verifying the authenticity of spatial data, traceable evidence of changes, and automated anomaly detection capabilities.

[0006] Existing inventory methods include (1) Traditional manual inventory: relying on manual visual inspection, paper records or basic electronic form registration. (2) RFID radio frequency identification technology: installing RFID tags on assets and identifying them in batches through readers. (3) QR code / barcode management: generating a unique code for each asset and registering them item by item through a barcode scanner. (4) Two-dimensional CAD drawing management system: establishing asset location mapping based on architectural CAD drawings.

[0007] The drawbacks of existing technology are: (1) Traditional manual inventory counts are subject to subjective judgment errors; (2) The asset change review process lacks an automated verification mechanism. Summary of the Invention

[0008] To address the aforementioned problems, this invention provides an asset inventory verification method and apparatus based on spatial difference detection.

[0009] This invention provides a method for asset inventory verification based on spatial difference detection, comprising the following steps: S1. Collect the original asset number, original area, original floor height and original function of the original asset room, and obtain the original first weight and original second weight based on the original function; S2. Collect the current asset number, current area, current floor height and current function of the current asset room corresponding to the original asset room, and obtain the current first weight and current second weight based on the current function; S3. Determine whether the current asset room corresponds to the original asset room based on the original asset number and the current asset number; if not, trigger manual review; if yes, proceed to step S4. S4. Calculate the dynamic deviation value based on the original area, original floor height, original first weight, original second weight, current area, current floor height, current first weight, and current second weight; S5. Determine if the dynamic deviation value is greater than the preset value. If not, record the current asset number, current area, current floor height, and current function of the current asset room. If yes, trigger manual review.

[0010] Further, the dynamic deviation value = α × (1 - max(original first weight × current first weight, original second weight × current second weight)) + β × (|current area - original area| ÷ original area| + |current floor height - original floor height| ÷ original floor height); Where α is the weight of functional changes and β is the weight of parameter changes, α+β=1, and α and β are determined based on the logistics park's management focus on asset rooms and the actual operating environment. If the original function and the current function are different, max(original first weight × current first weight, original second weight × current second weight) means taking the larger value between original first weight × current first weight and original second weight × current second weight; If the original function and the current function are the same, max(original first weight × current first weight, original second weight × current second weight) is 0.

[0011] Furthermore, the original and current functions include one or more of the following: receiving and temporary storage area, main storage area, sorting operation area, shipping and loading area, return processing area, equipment room, park office area, charging / maintenance area, cold chain area, and security / gatehouse.

[0012] Furthermore, it also includes step S6, outputting a report.

[0013] An asset inventory verification device based on spatial difference detection includes at least: The first data acquisition module is used to collect the original asset number, original area, original floor height and original function of the original asset room, and to obtain the original first weight and original second weight based on the original function. The second acquisition module is used to acquire the current asset number, current area, current floor height and current function of the current asset room corresponding to the original asset room, and to obtain the current first weight and current second weight based on the current function; The first judgment module is used to determine whether the current asset room corresponds to the original asset room based on the original asset number and the current asset number; if not, manual review is triggered; if yes, the calculation module is executed. The calculation module is used to calculate the dynamic deviation value based on the original area, original floor height, original first weight, original second weight, current area, current floor height, current first weight, and current second weight; The second judgment module is used to determine whether the dynamic deviation value is greater than the preset value. If not, it records the current asset number, current area, current floor height and current function of the current asset room; if so, it triggers manual review.

[0014] An electronic device, comprising: One or more processors; Memory, used to store one or more programs; When the one or more programs are executed by the one or more processors, the one or more processors perform the methods described above.

[0015] A computer-readable storage medium having computer instructions stored thereon, characterized in that the instructions, when executed by a processor, implement the steps of the method described above.

[0016] The beneficial effects of this invention are as follows: Based on the data collected from the current asset rooms during the inventory period, a dynamic deviation value is calculated according to the original asset room data. The dynamic deviation value is used for automatic calibration and is integrated with the manual review process to scientifically evaluate the assets. The setting of the dynamic deviation value forms an objective evaluation standard to prevent subjective judgment errors. Manual review is triggered when the dynamic deviation value is higher than the preset value, and no manual review is triggered when the dynamic deviation value is not higher than the preset value, thereby reducing the scope of human intervention in the inventory review. Attached Figure Description

[0017] Figure 1 This is a flowchart of an asset inventory audit method based on spatial difference detection according to the present invention; Figure 2 This is a block diagram of an asset inventory verification device based on spatial difference detection according to the present invention. Detailed Implementation

[0018] To further illustrate the technical means and effects of the present invention in achieving its intended purpose, the following detailed description of the specific implementation methods, structures, features and effects of the present invention, in conjunction with the accompanying drawings and preferred embodiments, is provided below.

[0019] This application shifts from static asset identification to a comprehensive anomaly scoring system based on changes in spatial parameters and functions, namely dynamic deviation values, thereby enabling the review of asset inventory based on these dynamic deviation values.

[0020] This invention is based on the data collected from the current asset room during the inventory cycle. It calculates the dynamic deviation value based on the original asset room data, and uses the dynamic deviation value for automatic calibration. It also integrates with the manual review process rules to scientifically evaluate the assets. Manual review is triggered for dynamic deviation values ​​that are higher than the preset value, while manual review is not triggered for dynamic deviation values ​​that are not higher than the preset value, thereby reducing the probability of manual intervention.

[0021] The embodiments of the present invention will be further described below with reference to several examples. Example

[0022] In this embodiment, the function and area change, but the floor height remains the same.

[0023] like Figure 1 An asset inventory verification method based on spatial difference detection includes the following steps: S1. Collect the original asset number, original area, original floor height and original function of the original asset room, and obtain the original first weight and original second weight based on the original function; The original first weight represents the original spatial storage attribute weight, and the original second weight represents the original operation / equipment attribute weight. The sum of the spatial storage attribute weight and the operation / equipment attribute weight ranges from [0, 1]. The sum of the spatial storage attribute weight and the operation / equipment attribute weight corresponding to the same function is 1. The principle is that the spatial storage attribute weight indicates that the function is sensitive to changes in area / floor height (changes will affect its use); the operation / equipment attribute weight indicates that the function is sensitive to equipment / operation type (changes will affect its use).

[0024] The spatial storage attribute weight is the spatial form sensitivity (whether changes in area / floor height affect the functional use), and the operation / equipment attribute weight is the equipment / operation sensitivity (whether changes in equipment / operation type affect the functional use). The criteria are functional definitions rather than mandatory mathematical conditions. They are adjusted by those skilled in the art based on the above criteria and in combination with expert scoring, analytic hierarchy process, historical data calibration, or entropy weighting. The adjusted weights are recorded in the functional attribute table and support iterative updates according to the inventory cycle, as shown in Table 1.

[0025] Table 1. Comparison of Original Function / Current Function with Space Storage Attribute Weights and Operation / Equipment Attribute Weights Receiving Temporary Storage Area 0.7 0.3 Frequent entry and exit, operations are carried out by manual labor and forklifts. Main storage area 0.85 0.15 Long-term storage, low job density Sorting area 0.2 0.8 Automated sorting with high work density Shipping and loading area 0.8 0.2 Frequent entry and exit, with loading and unloading as the main operations. Returns processing area 0.35 0.65 Manual processing + testing equipment Equipment room 0.1 0.9 Mainly automated equipment Park office area 0.1 0.9 Office staff, IT equipment Charging / Maintenance Area 0.5 0.5 Emphasis on both charging stations and maintenance work Cold Chain Zone 0.9 0.1 Temperature-sensitive, primarily for storage Security / Guard Room 0 1 Staff on duty, limited equipment In Table 1, both the equipment room and the park office area are 0.1 / 0.9, because both consume IT / office equipment resources but not space storage resources, and the classification logic is consistent.

[0026] When a feature type is not included, the administrator maintains the feature similarity matrix according to the preset process, or uses the default similarity.

[0027] In this embodiment, the original area is 45m². 2 The original floor height was 3m, and the original function was a receiving and temporary storage area. Its original first weight and original second weight were 0.7 and 0.3, respectively.

[0028] S2. Collect the current asset number, current area, current floor height and current function of the current asset room corresponding to the original asset room, and obtain the current first weight and current second weight based on the current function; The current first weight represents the current spatial storage attribute weight, and the current second weight represents the current job / device attribute weight.

[0029] The current area of ​​the room in this property is 70m². 2 The current floor height is 3m, the current function is equipment room, and its current first weight and current second weight are 0.1 and 0.9 respectively.

[0030] S3. Determine whether the current asset room corresponds to the original asset room based on the original asset number and the current asset number; if not, trigger manual review; if yes, proceed to step S4. In this embodiment, the original asset number corresponds to the current asset number, so step S4 is performed.

[0031] S4. Calculate the dynamic deviation value based on the original area, original floor height, original first weight of original function, original second weight of original function, current area, current floor height, current first weight of current function, and current second weight of current function; The dynamic deviation value = α × (1 - max(original first weight × current first weight, original second weight × current second weight)) + β × (|current area - original area| ÷ original area + |current floor height - original floor height| ÷ original floor height); Where α is the weight of functional changes and β is the weight of parameter changes, α+β=1, and α and β are determined based on the logistics park's management focus on asset rooms and the actual operating environment. In this embodiment, α=0.4 and β=0.6, emphasizing that parameter changes are more important than functional changes.

[0032] If the original function and the current function are different, max(original first weight × current first weight, original second weight × current second weight) means taking the larger value between original first weight × current first weight and original second weight × current second weight; If the original function and the current function are the same, max(original first weight × current first weight, original second weight × current second weight) is 0.

[0033] Dynamic deviation value = 0.4 × (1 - max(0.7 × 0.1, 0.3 × 0.9)) + 0.6 × (|70 - 45| ÷ 45 + |3 - 3| ÷ 3); Where max(0.7×0.1,0.3×0.9)=0.27, so the dynamic deviation value=0.4×(1-0.27)+0.6×0.556=0.6252.

[0034] S5. Determine if the dynamic deviation value is greater than the preset value. If not, record the current asset number, current area, current floor height, and current function of the current asset room. If yes, trigger manual review.

[0035] In this embodiment, the preset value is 0.5. If the dynamic deviation value is greater than the preset value, manual review is triggered. This preset value can be adjusted based on historical experience or pilot results. That is, based on a large number of manual review results, it is determined whether the preset value is accurate in triggering abnormal states, and the preset value is adjusted accordingly.

[0036] In some embodiments, step S6, outputting a report, is also included.

[0037] In this embodiment, based on the data collected from the current asset room during the inventory period, a dynamic deviation value is calculated according to the original asset room data. The dynamic deviation value is used for automatic calibration and is connected with the manual review process to scientifically evaluate the assets. The setting of the dynamic deviation value forms an objective evaluation standard to prevent subjective judgment errors. Manual review is triggered when the dynamic deviation value is higher than the preset value, and no manual review is triggered when the dynamic deviation value is not higher than the preset value, thereby reducing the probability of manual intervention.

[0038] Example 2 In this embodiment, the functionality remains the same, but the area and floor height change.

[0039] In this embodiment, the asset number, building, floor, and spatial coordinates of the original asset room and the current asset room are the same; the function of both is "receiving temporary storage area"; the area is adjusted from 45m² to 50m², while the floor height remains unchanged.

[0040] Specifically, the original asset number is R-101, the original area is 45m², the original floor height is 3m, the original function is a receiving temporary storage area, the original space storage attribute weight is 0.7, and the original operation / equipment attribute weight is 0.3. Current status: Asset number R-101, current area 50m², current floor height 3m, current function is receiving temporary storage area, current space storage attribute weight 0.7, current operation / equipment attribute weight 0.3; α = 0.4, β = 0.6; Dynamic deviation value = 0.4×(1−1) + 0.6×(|50−45|÷45 + |3−3|÷3) = 0 + 0.6×(0.1111 + 0) ≈ 0.0667; If the dynamic deviation value is less than 0.5, the mandatory audit conditions have not been triggered. The inventory count is marked as passed and recorded in the asset room table.

[0041] Example 3 In this embodiment, the function and area remain unchanged, but the floor height changes.

[0042] In this embodiment, the asset number, building, floor, and spatial coordinates of the original asset room and the current asset room are the same; the function of both is "receiving temporary storage area"; the area remains unchanged at 45m², and the floor height is increased from 3m to 5m.

[0043] Specifically, the original asset number is R-101, the original area is 45m², the original floor height is 3m, the original function is a receiving temporary storage area, the original space storage attribute weight is 0.7, and the original operation / equipment attribute weight is 0.3. Current status: Asset number R-101, current area 45m², current floor height 5m, current function is receiving temporary storage area, current space storage attribute weight 0.7, current operation / equipment attribute weight 0.3; α = 0.4, β = 0.6; Dynamic deviation value = 0.4×0 + 0.6×(|45−45|÷45 + |3−5|÷3) = 0 + 0.6×(0 +0.66667)≈0.4; If the dynamic deviation value is less than 0.5, the mandatory audit conditions have not been triggered. The inventory count is marked as passed and recorded in the asset room table.

[0044] Example 4 In this embodiment, the function changes, but the area and floor height remain the same.

[0045] In this embodiment, the asset numbers are consistent; the function is changed from "receiving temporary storage area" to "equipment room"; the area and floor height remain unchanged.

[0046] Specifically, the original area is 45m², the original floor height is 3m, the original function is a receiving temporary storage area, the original space storage attribute weight is 0.7, and the original operation / equipment attribute weight is 0.3. Current status: Current area 45m², current floor height 3m, current function is equipment room, current space storage attribute weight 0.1, current operation / equipment attribute weight 0.9; α = 0.4, β = 0.6; Dynamic deviation value = 0.4 × (1 − 0.27) + 0.6 × (|45 − 45| ÷ 45 + |3 − 3| ÷ 3) = 0.292; If the dynamic deviation value is less than 0.5, the mandatory audit conditions have not been triggered. The inventory count is marked as passed and recorded in the asset room table.

[0047] Example 5 In this embodiment, the functions, area, and floor height remain unchanged.

[0048] Dynamic deviation value = 0; If the dynamic deviation value is less than 0.5, the mandatory audit conditions have not been triggered. The inventory count is marked as passed and recorded in the asset room table.

[0049] This embodiment is used to calculate the baseline trigger rate and the false negative rate during the threshold calibration phase.

[0050] Example 6 In this embodiment, the original asset number R-301 does not appear in the current inventory, meaning that the current asset room does not correspond to the original asset room, and there are no matching items for building, floor, and spatial coordinates.

[0051] The number matching module determines that the number is missing and there is no spatially adjacent match. The mandatory review condition has been triggered (number missing); Dynamic deviation values ​​are no longer calculated; instead, an audit work order is directly generated and pushed to the administrator for manual review. The report fields include: missing number, original data, last inventory count period, spatial location, and suggested action (add / cancel / suspend).

[0052] Example 7 like Figure 2 An asset inventory verification device based on spatial difference detection includes: The first data acquisition module 1 is used to collect the original asset number, original area, original floor height and original function of the original asset room, and to obtain the original first weight and original second weight based on the original function. The second acquisition module 2 is used to acquire the current asset number, current area, current floor height and current function of the current asset room corresponding to the original asset room, and to obtain the current first weight and current second weight based on the current function; The first judgment module 3 is used to determine whether the current asset room corresponds to the original asset room based on the original asset number and the current asset number; if not, it triggers manual review; if yes, it performs the calculation module. Calculation module 4 is used to calculate the dynamic deviation value based on the original area, original floor height, original first weight, original second weight, current area, current floor height, current first weight, and current second weight; The second judgment module 5 is used to determine whether the dynamic deviation value is greater than the preset value. If not, it records the current asset number, current area, current floor height and current function of the current asset room; if so, it triggers manual review.

[0053] Regarding the apparatus in the above embodiments, the specific manner in which each module performs its operation has been described in detail in the embodiments related to the method, and will not be elaborated upon here.

[0054] For the device embodiments, since they basically correspond to the method embodiments, the relevant parts can be referred to in the description of the method embodiments. The device embodiments described above are merely illustrative. The units described as separate components may or may not be physically separate, and the components shown as units may or may not be physical units, that is, they may be located in one place or distributed across multiple network units. Some or all of the modules can be selected to achieve the purpose of this application according to actual needs. Those skilled in the art can understand and implement this without creative effort.

[0055] Accordingly, this application also provides an electronic device, including: One or more processors; Memory, used to store one or more programs; When the one or more programs are executed by the one or more processors, the one or more processors perform the methods described above.

[0056] Accordingly, this application also provides a computer-readable storage medium having computer instructions stored thereon, which, when executed by a processor, implement the steps of any of the above methods.

[0057] In the embodiments provided in this application, it should be understood that the disclosed methods and systems can also be implemented in other ways. The method and system embodiments described above are merely illustrative. For example, the flowcharts and block diagrams in the accompanying drawings illustrate the architecture, functionality, and operation of possible implementations of methods and systems, methods, and computer program products according to various embodiments of this application. In this regard, each block in a flowchart or block diagram may represent a module, segment, or portion of code containing one or more executable instructions for implementing a specified logical function. It should also be noted that in some alternative implementations, the functions marked in the blocks may occur in a different order than those marked in the drawings. For example, two consecutive blocks may actually be executed substantially in parallel, and they may sometimes be executed in reverse order, depending on the functions involved. It should also be noted that each block in a block diagram and / or flowchart, and combinations of blocks in block diagrams and / or flowcharts, can be implemented using a dedicated hardware-based system that performs the specified function or action, or using a combination of dedicated hardware and computer instructions.

[0058] In addition, the functional modules in the various embodiments of this application can be integrated together to form an independent part, or each module can exist independently, or two or more modules can be integrated to form an independent part.

[0059] On the other hand, a computer-readable storage medium stores computer instructions thereon, which, when executed by a processor, implement the steps of the above-described method. When the computer program is executed by the processor, it implements the method as described in any of the first aspects above. If the function is implemented as a software functional module and sold or used as an independent product, it can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of this application, in essence, or the part that contributes to the prior art, or a part of the technical solution, can be embodied in the form of a software product. This computer software product is stored in a storage medium and includes several instructions to cause a computer device (which may be a personal computer, a server, or a network device, etc.) to execute all or part of the steps of the methods described in the various embodiments of this application. The aforementioned storage medium includes various media capable of storing program code, such as a USB flash drive, a portable hard drive, a read-only memory (ROM), a random access memory (RAM), a magnetic disk, or an optical disk.

[0060] In this application, the dynamic deviation value is calculated by the original area, original floor height, original first weight, original second weight, current area, current floor height, current first weight, and current second weight. The above embodiments are only illustrative examples. The operation and maintenance personnel can adjust the space storage attribute weight and operation / equipment attribute weight of the original function and / or current function, as well as the function change weight α and parameter change weight β, according to the actual situation, so as to automatically / manually sort the review of various asset inventory status.

[0061] The above description is merely a preferred embodiment of the present invention and is not intended to limit the present invention in any way. Although the present invention has been disclosed above with reference to preferred embodiments, it is not intended to limit the present invention. Any person skilled in the art can make some modifications or alterations to the above-disclosed technical content to create equivalent embodiments without departing from the scope of the present invention. Any simple modifications, equivalent changes and alterations made to the above embodiments based on the technical essence of the present invention without departing from the scope of the present invention shall still fall within the scope of the present invention.

Claims

1. An asset inventory verification method based on spatial difference detection, characterized in that, Includes the following steps: S1. Collect the original asset number, original area, original floor height and original function of the original asset room, and obtain the original first weight and original second weight based on the original function; S2. Collect the current asset number, current area, current floor height and current function of the current asset room corresponding to the original asset room, and obtain the current first weight and current second weight based on the current function; S3. Determine whether the current asset room corresponds to the original asset room based on the original asset number and the current asset number; if not, trigger manual review; if yes, proceed to step S4. S4. Calculate the dynamic deviation value based on the original area, original floor height, original first weight, original second weight, current area, current floor height, current first weight, and current second weight; S5. Determine if the dynamic deviation value is greater than the preset value. If not, record the current asset number, current area, current floor height, and current function of the current asset room. If yes, trigger manual review.

2. The method according to claim 1, characterized in that, The dynamic deviation value = α × (1 - max(original first weight × current first weight, original second weight × current second weight)) + β × (|current area - original area| ÷ original area| + |current floor height - original floor height| ÷ original floor height); Where α is the weight of functional changes and β is the weight of parameter changes, α+β=1, and α and β are determined based on the logistics park's management focus on asset rooms and the actual operating environment. If the original function and the current function are different, max(original first weight × current first weight, original second weight × current second weight) means taking the larger value between original first weight × current first weight and original second weight × current second weight; If the original function and the current function are the same, max(original first weight × current first weight, original second weight × current second weight) is 0.

3. The method according to claim 1, characterized in that, The original and current functions include one or more of the following: receiving and temporary storage area, main storage area, sorting operation area, shipping and loading area, return processing area, equipment room, park office area, charging / maintenance area, cold chain area, and security / gatehouse.

4. The method according to claim 1, characterized in that, It also includes step S6 and outputting a report.

5. An asset inventory verification device based on spatial difference detection, characterized in that, At least including: The first data acquisition module is used to collect the original asset number, original area, original floor height and original function of the original asset room, and to obtain the original first weight and original second weight based on the original function. The second acquisition module is used to acquire the current asset number, current area, current floor height and current function of the current asset room corresponding to the original asset room, and to obtain the current first weight and current second weight based on the current function; The first judgment module is used to determine whether the current asset room corresponds to the original asset room based on the original asset number and the current asset number; if not, manual review is triggered; if yes, the calculation module is executed. The calculation module is used to calculate the dynamic deviation value based on the original area, original floor height, original first weight, original second weight, current area, current floor height, current first weight, and current second weight; The second judgment module is used to determine whether the dynamic deviation value is greater than the preset value. If not, it records the current asset number, current area, current floor height and current function of the current asset room; if so, it triggers manual review.

6. An electronic device, characterized in that, include: One or more processors; Memory, used to store one or more programs; When the one or more programs are executed by the one or more processors, the one or more processors implement the method as described in any one of claims 1-4.

7. A computer-readable storage medium storing computer instructions thereon, characterized in that, When executed by the processor, this instruction implements the steps of the method as described in any one of claims 1-4.

Images