Method, device, equipment and medium for processing life cycle data of metering materials

Abstract

The embodiment of the present invention discloses a method, device, equipment and computer-readable storage medium for processing life cycle data of metering materials. The method obtains metering material ledger information in the marketing system as the first list; obtains the physical ledger information of metering materials obtained by the on-site staff as the second list; obtains the financial ledger information of the financial system as the third list; and matches the data items according to the first list, the second list and the third list to correct the data items in the list until the data items of the accounts, materials and finances are matched and consistent. The technical solution of the present invention gets rid of the traditional manual statistical method, can predict the problem in advance through data analysis, and arrange the work in advance, which greatly improves the efficiency of the status analysis of metering materials.

Description

Technical Field

[0001] The embodiments of the present invention relate to computer data processing technology, and more particularly to a method, device, equipment and medium for processing life cycle data of metered materials. Background Art

[0002] The traditional means of managing and controlling the entire life cycle of metering materials mainly involves using the system to export data and conduct subsequent integration, and conducting statistical analysis on metering materials such as consistency between accounts, cards and materials, inventory quota ratios, spot checks on accounts and actuals, consistency between accounts and actuals, materials awaiting identification and those awaiting scrapping.

[0003] At present, the existing life cycle management and control solutions for measurement materials are unable to perform cumulative statistics of data, and the data systems are not interconnected and updated untimely. Therefore, data inconsistencies between systems often occur. Faced with massive amounts of data, staff are unable to conduct accurate analysis of each piece of data to ensure consistency in the data in the three ledgers, which has become a bottleneck restricting the management and control of the entire life cycle of measurement. Summary of the invention

[0004] The embodiments of the present invention provide a method, device, equipment and medium for processing life cycle data of a metering material, so as to achieve accuracy and comprehensiveness in the management and control of the life cycle of a metering material.

[0005] In a first aspect, an embodiment of the present invention provides a method for processing life cycle data of a metered material, comprising:

[0006] Obtain the metered material ledger information in the marketing system as the first list;

[0007] Obtain the physical inventory information of measured materials obtained by on-site staff as the second list;

[0008] Obtain financial ledger information from the financial system as the third list;

[0009] According to the first list, the second list and the third list, data items are matched to correct the data items in the lists until the data items of accounts, materials and finances are matched and consistent.

[0010] In a second aspect, an embodiment of the present invention further provides a device for processing life cycle data of a metered material, comprising:

[0011] The first acquisition module is used to acquire the metered material ledger information in the marketing system as the first list; the second acquisition module is used to acquire the metered material physical ledger information obtained by the on-site staff as the second list;

[0012] The third acquisition module is used to obtain the financial ledger information of the financial system as the third list; the first correction module is used to match the data items according to the first list, the second list and the third list to correct the data items in the list until the data items of the accounts, materials and finances are matched.

[0013] In a third aspect, an embodiment of the present invention further provides an electronic device, the device comprising:

[0014] one or more processors;

[0015] A memory for storing one or more programs;

[0016] When the one or more programs are executed by the one or more processors, the one or more processors implement the method for processing life cycle data of metered materials as described in the first aspect.

[0017] In a fourth aspect, an embodiment of the present invention further provides a computer-readable storage medium having a computer program stored thereon, wherein when the computer program is executed by a processor, the method for processing life cycle data of a metering material as described in the first aspect is implemented.

[0018] The embodiment of the present invention obtains the metering material ledger information in the marketing system as the first list; obtains the physical metering material ledger information obtained by the on-site staff as the second list; obtains the financial ledger information of the financial system as the third list; and matches the data items according to the first list, the second list and the third list to correct the data items in the lists until the data items of the accounts, materials and finances are matched consistently, thereby solving the technical problems that the current full life cycle management of metering materials is time-consuming and complicated, requires a large number of people to organize and analyze, and cannot timely discover inconsistencies, and achieves the technical effect of high accuracy and fast speed in identifying problem data in metering materials and effectively reducing labor costs. BRIEF DESCRIPTION OF THE DRAWINGS

[0019] Figure 1 It is a flow chart of a method for processing life cycle data of a metered material provided in the first embodiment of the present invention;

[0020] Figure 2 It is a flow chart of a method for processing life cycle data of a metered material provided in the second embodiment of the present invention;

[0021] Figure 3 It is a flow chart of a method for processing life cycle data of a metered material provided in Embodiment 3 of the present invention;

[0022] Figure 4 It is a structural schematic diagram of a life cycle data processing device for measuring materials provided by a fourth embodiment of the present invention;

[0023] Figure 5 It is a structural schematic diagram of an electronic device provided in Embodiment 5 of the present invention. DETAILED DESCRIPTION

[0024] In order to enable those skilled in the art to better understand the scheme of the present invention, the technical scheme in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work should fall within the scope of protection of the present invention.

[0025] It should be noted that the terms "first", "second", etc. in the specification and claims of the present invention and the above-mentioned drawings are used to distinguish similar objects, and are not necessarily used to describe a specific order or sequence. It should be understood that the data used in this way can be interchanged where appropriate, so that the embodiments of the present invention described herein can be implemented in an order other than those illustrated or described herein. In addition, the terms "including" and "having" and any variations thereof are intended to cover non-exclusive inclusions, for example, a process, method, system, product or device that includes a series of steps or units is not necessarily limited to those steps or units that are clearly listed, but may include other steps or units that are not clearly listed or inherent to these processes, methods, products or devices.

[0026] Embodiment 1

[0027] Figure 1 This is a flow chart of a method for processing life cycle data of a metering material provided in the first embodiment of the present invention. This embodiment is applicable to the scenario of metering material management and control. The method can be executed by a life cycle data processing device for metering materials. The device can be implemented by software and / or hardware, and can generally be integrated in an electronic device with computing functions such as a server, and specifically includes the following steps:

[0028] S110, obtaining the metered material ledger information in the marketing system as the first list;

[0029] S120, obtaining physical ledger information of measured materials obtained by on-site staff as the second list;

[0030] S130. Obtain financial ledger information from the financial system as the third list.

[0031] It should be noted that the marketing system is a dynamic system used to supervise the production and sales processes of an enterprise. On-site staff refers to personnel who can verify the actual material information in the warehouse. The verification method can be manual counting or machine clearing. The financial system is an operating system that records the account information of the enterprise's inventory, procurement, sales, etc.

[0032] S140. Match the data items according to the first list, the second list and the third list to correct the data items in the lists until the data items of accounts, materials and finances are matched and consistent.

[0033] In one embodiment of the present invention, specifically, the data items of the first list and the second list are compared to obtain a first comparison result; wherein the data items used for comparison are included in both the first list and the second list, and are at least one of the information such as asset code, power supply unit, equipment status, warehouse name, equipment category, equipment type, specification, filing date, manufacturer, etc. The data items selected in this application cover a wide range, are complete in variety, and have strong adaptability, so that the comparison results can be obtained from less data, and the accuracy can be improved through comprehensive data, thereby ensuring the consistency of the card and the object of the metering material.

[0034] S150: If the first comparison result is that the data items are not the same or the data values ​​of the data items are not the same, modify the data items of the first list and the second list, and re-execute the operation of obtaining the first comparison result until the first comparison result is the same;

[0035] Specifically, when the first comparison result is that the data items are not identical, the redundant data items in the first list or the second list are deleted, and the operation of obtaining the first comparison result is performed again until the first comparison result is identical;

[0036] When the first comparison result is that the data value of the data item is different, the data item stored in the marketing system is re-acquired, and the current first list is updated to re-acquire the first comparison result. If the first comparison result is still different, the on-site staff will re-check the physical ledger information, and then update the current second list and re-acquire the first comparison result. If the first comparison result is still different, an alarm signal for changing the material ledger information in the marketing system is generated and displayed, and the material ledger information in the marketing system is changed to the updated second list information.

[0037] S160: If the first comparison result is that the data items and the data values ​​of the data items are the same, compare the data items of the first list and the third list to obtain a second comparison result;

[0038] S170. If the second comparison result is that the data items are not the same or the data values ​​of the data items are not the same, modify the contents of the first list and the third list, and re-execute the operation of obtaining the second comparison result until the second comparison result is the same.

[0039] Specifically, when the second comparison result is that the data items are not identical, the redundant data items in the first list or the second list are deleted, and the operation of obtaining the second comparison result is performed again until the second comparison result is identical;

[0040] When the second comparison result shows that the data value of the data item is different, the on-site staff will re-check the physical ledger information, then update the current second list, and re-obtain the second comparison result. If the second comparison result is still different, the data item in the financial system will be recalculated, and the current third list will be updated to re-obtain the second comparison result. If the second comparison result is still different, an alarm signal for changing the financial ledger information in the financial system will be generated and displayed, and the financial ledger information in the financial system will be changed to the updated third list information.

[0041] S180: Generate and display an alarm signal indicating that data integration is completed.

[0042] Optionally, when there is an alarm signal for changing the material ledger information in the marketing system, or when there is an alarm signal for changing the financial ledger information in the financial system, the alarm light is displayed in yellow, and when there is an alarm signal for displaying the completion of data integration, the alarm light is displayed in green.

[0043] The technical solution of this embodiment is to obtain the metering material ledger information in the marketing system as the first list; obtain the physical metering material ledger information obtained by the on-site staff as the second list; obtain the financial ledger information of the financial system as the third list; match the data items according to the first list, the second list and the third list to correct the data items in the list until the data items of the accounts, materials and finances are matched consistently, thereby solving the technical problems that the current full life cycle management of metering materials is time-consuming and complicated, requires a large number of people to organize and analyze, and cannot detect inconsistencies in time, and achieves the technical effect of high accuracy and fast speed in identifying problem data in metering materials and effectively reducing labor costs.

[0044] Embodiment 2

[0045] Figure 2 This is a flow chart of a method for processing life cycle data of a metered material provided in Embodiment 1 of the present invention. This embodiment is optimized based on the above-mentioned embodiment and specifically includes the following steps:

[0046] S210, obtaining the metered material ledger information in the marketing system as the first list;

[0047] S220. Obtain inventory quota ledger information of metered materials as the fourth list.

[0048] It should be noted that the inventory quota ledger information is the reasonable inventory quantity determined to ensure the normal production and operation activities of the enterprise.

[0049] S230, comparing the data items in the first list and the fourth list to obtain a third comparison result;

[0050] S240, if the third comparison result is that the data value of the first list is less than or equal to the data value of the fourth list, determine whether the data value of the first list falls within the range of 80%-100% of the data value of the fourth list; if so, execute S250; if not, execute S260;

[0051] S250: If yes, a level 1 alarm signal indicating insufficient inventory is generated;

[0052] S260: If not, a secondary alarm signal indicating sufficient inventory is generated.

[0053] In one embodiment of the present invention, it is understood that when the metered material ledger information in the marketing system is compared with the inventory quota, if the actual material quantity is less than the quota ledger information, it means that the actual material quantity is already less than the quantity required for the daily production and operation of the enterprise, the actual material quantity is not sufficient, and there is still a risk that the inventory is less than the quota quantity. Further, if the actual material quantity is within the range of 80%-100% of the quota ledger information, at this time, in order to avoid the situation where the enterprise's material supply is in short supply, a first-level alarm signal is issued to remind relevant personnel, so as to increase the inventory to a reasonable level.

[0054] S270: If the third comparison result is that the data value in the first list is greater than the data value in the fourth list, a third-level alarm signal for instructing to consume materials as soon as possible is generated;

[0055] S280, verify and execute the instruction to consume materials as soon as possible, and re-execute the operation of obtaining the first list and the second list, and comparing them to obtain the third comparison result, until the third comparison result is that the data value of the first list is less than or equal to the data value of the fourth list.

[0056] In one embodiment of the present invention, it is understandable that the metered material ledger information in the marketing system is compared with the inventory quota. If the actual material quantity is greater than the quota ledger information, it means that the actual inventory is greater than the number required for the daily production and operation of the enterprise. At this time, in order to avoid the accumulation of inventory materials, a three-level alarm signal is generated to prompt relevant personnel to consume the materials as soon as possible. After verifying and executing the instruction to consume materials as soon as possible, the inventory materials and quota material information are re-acquired and compared to ensure that the final result is a balance between the number of inventory materials and the quota materials. Optionally, the instruction to consume materials as soon as possible is generated by software or hardware, and the instruction to consume materials as soon as possible can be executed by a computer or by relevant personnel.

[0057] For example, assuming that the number of inventory ledgers and the quota number of metered materials obtained by Company A are 900,000 and 1 million respectively, it can be seen that the inventory number is less than the quota number, and the inventory number is 90% of the quota number, which is within the range of 80%-100%. This shows that there is a risk that the quantity of inventory materials cannot guarantee the normal production and operation activities of the enterprise. At this time, the alarm light turns yellow, and the management personnel coordinate with the production personnel to speed up production, or fill the inventory through other channels to increase the inventory to a reasonable amount.

[0058] For example, suppose that the inventory ledger number and quota number of measured materials obtained by Company B are 1.1 million and 1 million respectively, that is, the inventory number is greater than the quota number, which indicates that some materials in the inventory are at risk of being stranded. When the inventory of materials is too large, it will inevitably occupy a large amount of funds, reducing the speed of capital turnover, resulting in an increase in the company's bank loan interest expenses, storage fees, insurance premiums, maintenance fees and other expenses, which brings great difficulties to the company's working capital turnover, and to a certain extent affects the company's normal production and operation activities and difficulty in controlling inventory costs. At this time, the alarm light turns red, and the computer generates an instruction to consume materials as soon as possible. After verification and confirmation, the relevant personnel formulate and execute relevant plans until the inventory ledger number is less than the quota number of 1 million, and the alarm light turns green, indicating that the current inventory number is reasonable.

[0059] Embodiment 3

[0060] Figure 3 This is a flowchart of a method for processing life cycle data of a metered material provided in Embodiment 3 of the present invention. This embodiment is optimized based on the above-mentioned embodiment and specifically includes the following steps:

[0061] S310, performing data pivoting and classification on the first list, and extracting a list of the detention time of the metering materials to be identified and the detention time of the metering materials to be scrapped, as a fifth list;

[0062] In one embodiment of the present invention, it should be noted that data pivot classification refers to statistically summarizing source data through different combinations of data rows or columns, and the summarization includes but is not limited to summing, counting, averaging and other operations. The metering materials to be identified can be divided into metering materials to be scrapped or normal inventory after identification. Among them, metering materials to be scrapped refer to returned materials that have been identified as having no use value after the material use management department has organized a use value appraisal, and engineering surplus materials that have been identified as having no use value after the material department has organized an appraisal, idle materials that have been identified as having no use value after the material department has organized an appraisal, and reserve materials that have reached the rotation period.

[0063] S320. Identify the retention time of the metered materials to be identified and the metered materials to be scrapped in the fifth list to determine whether the retention conditions are met; if the retention time of the metered materials to be identified is greater than or equal to the first set time or the retention time of the metered materials to be scrapped is greater than or equal to the second set time, it is determined that the retention conditions are met; wherein the first set time is less than the second set time.

[0064] S330, if the retention condition is met, a rectification instruction is generated;

[0065] S340, verify and execute the order rectification instruction, and re-execute the operation of extracting the fifth list and identifying it until the fifth list does not meet the retention condition, and then generate a normal alarm signal.

[0066] S350: If it is determined that the retention condition is not met, then identify whether the fifth list meets the retention warning condition. The retention warning condition is: the retention time of the metering materials to be identified is within the range of two to three months or the retention time of the metering materials to be scrapped is within the range of five to six months; if the retention warning condition is met, a retention warning signal is generated, otherwise a normal alarm signal is generated.

[0067] Optionally, the first set time length and the second set time length may be pre-set time lengths based on normal material life cycles of different enterprises.

[0068] It can be obtained that when the retention time of the measurement materials to be identified is greater than or equal to the first set time, or the retention time of the measurement materials to be scrapped is greater than or equal to the second set time, it indicates that the retention time of the measurement materials to be identified in the inventory is too long, which will cause inventory accumulation, occupy the warehouse, and is not conducive to the company's production and operation turnover. At this time, the computer generates a rectification instruction, and the alarm light shows red. The relevant personnel verify the number of materials and rectify them, and identify the measurement materials to be identified as normal inventory materials or materials to be scrapped as soon as possible. Timely identification of redundant scrapped materials in the warehouse helps to reduce scrapped items in the accumulated inventory materials and improve the analysis efficiency of measurement materials.

[0069] Furthermore, if the retention time of the measurement materials to be identified is within the range of two to three months or the retention time of the measurement materials to be scrapped is within the range of five to six months, it indicates that the measurement materials to be identified or the measurement materials to be scrapped have been detained for a long time, but will not affect the normal production and operation of the company. At this time, the alarm light will be yellow. After the relevant personnel verify and rectify the measurement materials to be identified or the measurement materials to be scrapped, or the retention time of the measurement materials to be identified is less than two months or the retention time of the measurement materials to be scrapped is less than five months, the alarm light will be green, indicating that the retention time of the measurement materials to be identified or the measurement materials to be scrapped is short, and within this time range, there will not be too many scrapped materials to occupy too much inventory space. Therefore, there is no need to remind the relevant personnel, but the materials should be handled according to the normal process first.

[0070] The technical solution of this embodiment is to obtain the inventory quota ledger information of metered materials as the fourth list; compare the data items of the first list and the fourth list to obtain a third comparison result; if the third comparison result is that the data value of the first list is less than or equal to the data value of the fourth list, determine whether the data value of the first list falls within the range of 80%-100% of the data value of the fourth list; if so, generate a first-level alarm signal of insufficient inventory; if not, generate a second-level alarm signal of sufficient inventory. The first list is subjected to data pivoting and classification, and a list of detention times of metering materials to be identified and to be scrapped is extracted as the fifth list; identification is performed based on the detention times of metering materials to be identified and to be scrapped in the fifth list to determine whether the detention conditions are met; if the detention conditions are met, an order rectification instruction is generated; the order rectification instruction is verified and executed, and the operation of extracting the fifth list and identifying it is re-executed until the fifth list does not meet the detention conditions, in which case a normal alarm signal is generated, which can efficiently and automatically extract inventory quota ratio data, quickly identify stranded materials to be identified and to be scrapped, and generate problem rectification tasks for relevant staff to implement rectification; in addition, the inventory threshold quota ratio, detention time margin value, early warning line, and "red, yellow, and green" light functions can be set to enhance the effective control of the work management personnel over the entire life cycle of metering materials.

[0071] Embodiment 4

[0072] Figure 4This is a schematic diagram of the structure of a life cycle data processing device for measuring materials provided in the fourth embodiment of the present invention. The device can execute the life cycle data processing method for measuring materials provided in any embodiment of the present invention, and has the corresponding functional modules and beneficial effects of the execution method. This embodiment can be applied to the environment of statistical analysis of measuring materials. The device includes: a first acquisition module 410, a second acquisition module 420, a third acquisition module 430 and a first correction module 440.

[0073] Among them, the first acquisition module 410 is used to obtain the metered material ledger information in the marketing system as the first list; the second acquisition module 420 is used to obtain the physical ledger information of metered materials obtained by the on-site staff as the second list; the third acquisition module 430 is used to obtain the financial ledger information of the financial system as the third list; the first correction module 440 is used to match data items according to the first list, the second list and the third list to correct the data items in the list until the data items of accounts, materials and finances are matched.

[0074] The technical solution of this embodiment is to obtain the metering material ledger information in the marketing system as the first list; obtain the physical metering material ledger information obtained by the on-site staff as the second list; obtain the financial ledger information of the financial system as the third list; match the data items according to the first list, the second list and the third list to correct the data items in the list until the data items of the accounts, materials and finances are matched consistently, thereby solving the technical problems that the current full life cycle management of metering materials is time-consuming and complicated, requires a large number of people to organize and analyze, and cannot detect inconsistencies in time, and achieves the technical effect of high accuracy and fast speed in identifying problem data in metering materials and effectively reducing labor costs.

[0075] Optionally, based on the above technical solution, the device further includes:

[0076] A first comparison module, used for comparing the data items of the first list and the second list to obtain a first comparison result;

[0077] If the first comparison result is that the data items are not the same or the data values ​​of the data items are not the same, modify the data items of the first list and the second list, and re-execute the operation of obtaining the first comparison result until the first comparison result is the same;

[0078] a second comparison module, configured to compare the data items in the first list and the data items in the third list to obtain a second comparison result if the first comparison result is that the data items and the data values ​​of the data items are the same;

[0079] If the second comparison result is that the data items are not the same or the data values ​​of the data items are not the same, the contents of the first list and the third list are modified, and the operation of obtaining the second comparison result is re-executed until the second comparison result is the same.

[0080] Furthermore, the alarm module is used to generate and display an alarm signal indicating that data integration is completed.

[0081] Furthermore, a fourth acquisition module is used to obtain inventory quota ledger information of metered materials as a fourth list;

[0082] A third comparison module, used for comparing the data items of the first list and the fourth list to obtain a third comparison result;

[0083] If the third comparison result is that the data value of the first list is less than or equal to the data value of the fourth list, determining whether the data value of the first list falls within a range of 80%-100% of the data value of the second list;

[0084] The alarm module is also used to generate a first-level alarm signal of insufficient inventory if the data value of the first list falls within the range of 80%-100% of the data value of the second list; and to generate a second-level alarm signal of sufficient inventory if the data value of the first list falls within the range of 80%-100% of the data value of the second list.

[0085] The alarm module is further configured to generate a third-level alarm signal of an instruction to consume materials as soon as possible and a serious shortage of inventory if the third comparison result is that the data value of the first list is greater than the data value of the fourth list;

[0086] The second correction module is used to verify and execute the instruction to consume materials as soon as possible, and re-execute the operation of obtaining the first list and the second list and comparing them to obtain the third comparison result, until the third comparison result is that the data value of the first list is less than or equal to the data value of the fourth list.

[0087] Furthermore, a fifth acquisition module is used to perform data pivoting and classification on the first list, and extract a list of detention time of metering materials to be identified and a list of detention time of metering materials to be scrapped as a fifth list;

[0088] Furthermore, a fourth comparison module is used to identify the measurement materials to be identified and the measurement materials to be scrapped according to the retention time in the fifth list to determine whether the retention conditions are met;

[0089] If the detention conditions are met, a rectification order will be generated;

[0090] The third correction module is used to verify and execute the order rectification instruction, and re-execute the operation of extracting the fifth list and identifying it until the fifth list does not meet the retention condition, and then a normal alarm signal is generated.

[0091] If the retention time of the metered materials to be identified is greater than or equal to the first set time or the retention time of the metered materials to be scrapped is greater than or equal to the second set time, it is determined that the retention condition is met; wherein the first set time is less than the second set time.

[0092] Further, the fifth comparison module is used to identify whether the fifth list meets the detention warning condition if it is determined that the detention condition is not met; wherein the detention warning condition is: the detention time of the metering materials to be identified is within the range of two to three months or the detention time of the metering materials to be scrapped is within the range of five to six months;

[0093] The alarm module is also used to generate a detention warning signal if the detention warning condition is met, and otherwise generate a normal alarm signal.

[0094] The above-mentioned life cycle data processing device for measuring materials can execute the life cycle data processing method for measuring materials provided in any embodiment of the present invention, and has the corresponding functional modules and beneficial effects of the execution method. For technical details not described in detail in this embodiment, please refer to the life cycle data processing method for measuring materials provided in any embodiment of the present invention.

[0095] Embodiment 5

[0096] Figure 5 This is a schematic diagram of the structure of an electronic device provided in Embodiment 5 of the present invention. Figure 5 A block diagram of a terminal 512 suitable for implementing embodiments of the present invention is shown. Figure 5 The terminal 512 shown is only an example and should not bring any limitation to the functions and scope of use of the embodiments of the present invention.

[0097] like Figure 5 As shown, the terminal 512 is in the form of a general computing device and has the functions of saving pictures and translating by taking pictures, screenshots, etc. The components of the terminal 512 may include, but are not limited to: one or more processors 516, a storage device 528, and a bus 518 connecting different system components (including the storage device 528 and the processor 516).

[0098] Bus 518 represents one or more of several types of bus structures, including a memory bus or memory controller, a peripheral bus, an accelerated graphics port, a processor or a local bus using any of a variety of bus architectures. By way of example, these architectures include, but are not limited to, an Industry Standard Architecture (ISA) bus, a Micro Channel Architecture (MAC) bus, an Enhanced ISA bus, a Video Electronics Standards Association (VESA) local bus, and a Peripheral Component Interconnect (PCI) bus.

[0099] Terminal 512 typically includes a variety of computer system readable media. These media can be any available media that can be accessed by terminal 512, including volatile and non-volatile media, removable and non-removable media.

[0100] Storage device 528 may include computer system readable media in the form of volatile memory, such as random access memory (RAM) 530 and / or cache memory 532. Terminal 512 may further include other removable / non-removable, volatile / non-volatile computer system storage media. By way of example only, storage system 534 may be used to read and write non-removable, non-volatile magnetic media ( Figure 5 not shown, usually called a "hard drive"). Although Figure 5 Not shown, a disk drive for reading and writing to a removable non-volatile disk (e.g., a "floppy disk"), and an optical disk drive for reading and writing to a removable non-volatile optical disk (e.g., a CD-ROM, a DVD-ROM, or other optical media) may be provided. In these cases, each drive may be connected to the bus 518 via one or more data medium interfaces. The storage device 528 may include at least one program product having a set (e.g., at least one) of program modules that are configured to perform the functions of the various embodiments of the present invention.

[0101] A program 540 having a set (at least one) of program modules 542 may be stored, for example, in a storage device 528, such program modules 542 including, but not limited to, an operating system, one or more application programs, other program modules, and program data, each of which or some combination thereof may include an implementation of a network environment. The program modules 542 generally perform the functions and / or methods of the embodiments described herein.

[0102] The terminal 512 may also communicate with one or more external devices 514 (e.g., keyboards, pointing devices, cameras, displays 524, etc.), may communicate with one or more devices that enable a user to interact with the terminal 512, and / or may communicate with any device that enables the terminal 512 to communicate with one or more other computing devices (e.g., network cards, modems, etc.). Such communication may be performed via an input / output (I / O) interface 522. Furthermore, the terminal 512 may also communicate with one or more networks (e.g., local area networks (LANs), wide area networks (WANs), and / or public networks, such as the Internet) via a network adapter 520. As shown, the network adapter 520 communicates with other modules of the terminal 512 via a bus 518. It should be understood that, although not shown in the figure, other hardware and / or software modules may be used in conjunction with the terminal 512, including, but not limited to, microcode, device drivers, redundant processing units, external disk drive arrays, RAID systems, tape drives, and data backup storage systems.

[0103] The processor 516 executes various functional applications and data processing by running the programs stored in the storage device 528, such as implementing the life cycle data processing method of the metered material provided in the above embodiment of the present invention.

[0104] Embodiment 6

[0105] Embodiment 6 of the present invention further provides a storage medium comprising computer executable instructions, wherein the computer executable instructions are used to execute a method for processing life cycle data of a metered material when executed by a computer processor, the method comprising:

[0106] Obtain the metered material ledger information in the marketing system as the first list;

[0107] Obtain the physical inventory information of measured materials obtained by on-site staff as the second list;

[0108] Obtain financial ledger information from the financial system as the third list;

[0109] According to the first list, the second list and the third list, data items are matched to correct the data items in the lists until the data items of accounts, materials and finances are matched and consistent.

[0110] Of course, the storage medium containing computer executable instructions provided in an embodiment of the present invention is not limited to the method operations described above, and can also execute related operations in the life cycle data processing method for metering materials provided in any embodiment of the present invention.

[0111] Through the above description of the implementation methods, the technicians in the relevant field can clearly understand that the present invention can be implemented by means of software and necessary general hardware, and of course it can also be implemented by hardware, but in many cases the former is a better implementation method. Based on such an understanding, the technical solution of the present invention, in essence, or the part that contributes to the prior art, can be embodied in the form of a software product, and the computer software product can be stored in a computer-readable storage medium, such as a computer floppy disk, read-only memory (ROM), random access memory (RAM), flash memory (FLASH), hard disk or optical disk, etc., including a number of instructions for a computer device (which can be a personal computer, server, or network device, etc.) to execute the methods described in each embodiment of the present invention.

[0112] It is worth noting that in the embodiment of the above-mentioned search device, the various units and modules included are only divided according to functional logic, but are not limited to the above-mentioned division, as long as the corresponding functions can be achieved; in addition, the specific names of the functional units are only for the convenience of distinguishing each other, and are not used to limit the scope of protection of the present invention.

[0113] Note that the above are only preferred embodiments of the present invention and the technical principles used. Those skilled in the art will understand that the present invention is not limited to the specific embodiments described herein, and that various obvious changes, readjustments and substitutions can be made by those skilled in the art without departing from the scope of protection of the present invention. Therefore, although the present invention has been described in more detail through the above embodiments, the present invention is not limited to the above embodiments, and may include more other equivalent embodiments without departing from the concept of the present invention, and the scope of the present invention is determined by the scope of the appended claims.

Claims

1. A method for processing life cycle data of a metering material, characterized in that: include: Obtain the metered material ledger information in the marketing system as the first list; Obtain the physical inventory information of measured materials obtained by on-site staff as the second list; Obtain financial ledger information from the financial system as the third list; According to the first list, the second list and the third list, data items are matched to correct the data items in the list until the data items of accounts, materials and finance are matched and consistent; The matching of data items according to the first list, the second list and the third list to correct the data items in the lists until the data items of accounts, materials and finances are matched includes: Compare the data items of the first list and the second list to obtain a first comparison result; If the first comparison result is that the data items are not the same or the data values ​​of the data items are not the same, modify the data items of the first list and the second list, and re-execute the operation of obtaining the first comparison result until the first comparison result is the same; If the first comparison result is that the data items and the data values ​​of the data items are the same, then comparing the data items of the first list and the third list to obtain a second comparison result; If the second comparison result is that the data items are not the same or the data values ​​of the data items are not the same, modify the contents of the first list and the third list, and re-execute the operation of obtaining the second comparison result until the second comparison result is the same; Wherein, after the second comparison result obtained is the same, the method further includes: Generate and display alarm signals indicating data integration is complete; Wherein, the method further comprises: Obtain the inventory quota ledger information of metered materials as the fourth list; Comparing the data items in the first list and the fourth list to obtain a third comparison result; If the third comparison result is that the data value of the first list is less than or equal to the data value of the fourth list, determining whether the data value of the first list falls within a range of 80%-100% of the data value of the second list; If yes, a first-level alarm signal indicating insufficient inventory is generated; if no, a second-level alarm signal indicating sufficient inventory is generated; Wherein, after comparing the data items of the first list and the fourth list to obtain a third comparison result, the method further includes: If the third comparison result is that the data value of the first list is greater than the data value of the fourth list, a third-level alarm signal for instructing to consume materials as soon as possible is generated; Verify and execute the instruction to consume materials as soon as possible, and re-execute the operation of obtaining the first list and the fourth list and comparing them to obtain the third comparison result, until the third comparison result is that the data value of the first list is less than or equal to the data value of the fourth list.

2. The method according to claim 1, characterized in that Also includes: Pivot and classify the first list, and extract the retention time of the metering materials to be identified and the retention time of the metering materials to be scrapped as the fifth list; Identify the measurement materials to be identified and the measurement materials to be scrapped according to their retention time in the fifth list to determine whether the retention conditions are met; If the detention conditions are met, a rectification order will be generated; Verify and execute the order rectification instruction, and re-execute the operation of extracting the fifth list and identifying it until the fifth list does not meet the retention condition, then a normal alarm signal is generated.

3. The method according to claim 2, characterized in that Identify the measurement materials to be identified and the measurement materials to be scrapped according to the retention time in the fifth list to determine whether the retention conditions are met, including: If the retention time of the metered materials to be identified is greater than or equal to the first set time or the retention time of the metered materials to be scrapped is greater than or equal to the second set time, it is determined that the retention condition is met; wherein the first set time is less than the second set time.

4. The method according to claim 2, characterized in that: After determining whether the detention conditions are met, the method further includes: If it is determined that the retention condition is not met, then identifying whether the fifth list meets the retention warning condition; wherein the retention warning condition is: the retention time of the measurement materials to be identified is within the range of two to three months or the retention time of the measurement materials to be scrapped is within the range of five to six months; If the detention warning conditions are met, a detention warning signal is generated, otherwise a normal alarm signal is generated.

5. A life cycle data processing device for measuring materials, characterized in that: include: The first acquisition module is used to obtain the metered material ledger information in the marketing system as the first list; The second acquisition module is used to obtain the physical ledger information of the measured materials obtained by the on-site staff as the second list; The third acquisition module is used to obtain the financial ledger information of the financial system as the third list; A first correction module is used to match data items according to the first list, the second list and the third list to correct the data items in the list until the data items of accounts, materials and finances are matched and consistent; Wherein, the device further comprises: A first comparison module, used for comparing the data items of the first list and the second list to obtain a first comparison result; If the first comparison result is that the data items are not the same or the data values ​​of the data items are not the same, modify the data items of the first list and the second list, and re-execute the operation of obtaining the first comparison result until the first comparison result is the same; a second comparison module, configured to compare the data items in the first list and the data items in the third list to obtain a second comparison result if the first comparison result is that the data items and the data values ​​of the data items are the same; If the second comparison result is that the data items are not the same or the data values ​​of the data items are not the same, modify the contents of the first list and the third list, and re-execute the operation of obtaining the second comparison result until the second comparison result is the same; An alarm module is used to generate and display an alarm signal indicating that data integration is complete; The fourth acquisition module is used to obtain the inventory quota ledger information of the metered materials as the fourth list; A third comparison module, used for comparing the data items of the first list and the fourth list to obtain a third comparison result; If the third comparison result is that the data value of the first list is less than or equal to the data value of the fourth list, determining whether the data value of the first list falls within a range of 80%-100% of the data value of the second list; The alarm module is further configured to generate a first-level alarm signal indicating insufficient inventory if the data value of the first list falls within the range of 80%-100% of the data value of the second list; and generate a second-level alarm signal indicating sufficient inventory if the data value of the first list does not fall within the range of 80%-100% of the data value of the second list. The alarm module is further configured to generate a third-level alarm signal for instructing to consume materials as soon as possible if the third comparison result is that the data value of the first list is greater than the data value of the fourth list; The second correction module is used to verify and execute the instruction to consume materials as soon as possible, and re-execute the operation of obtaining the first list and the fourth list and comparing them to obtain the third comparison result, until the third comparison result is that the data value of the first list is less than or equal to the data value of the fourth list.

6. An electronic device, characterized in that: The device comprises: one or more processors; A memory for storing 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 life cycle data processing method for metering materials as described in any one of claims 1-4.

7. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the method for processing life cycle data of metered materials as described in any one of claims 1 to 4 is implemented.

Images