CN114139975A - Life cycle data processing method, device, equipment and medium for metering materials - Google Patents
Life cycle data processing method, device, equipment and medium for metering materials Download PDFInfo
- Publication number
- CN114139975A CN114139975A CN202111464184.3A CN202111464184A CN114139975A CN 114139975 A CN114139975 A CN 114139975A CN 202111464184 A CN202111464184 A CN 202111464184A CN 114139975 A CN114139975 A CN 114139975A
- Authority
- CN
- China
- Prior art keywords
- list
- materials
- data items
- data
- comparison result
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 239000000463 material Substances 0.000 title claims abstract description 177
- 238000003672 processing method Methods 0.000 title claims abstract description 17
- 238000000034 method Methods 0.000 claims abstract description 26
- 238000005259 measurement Methods 0.000 claims abstract description 21
- 238000012545 processing Methods 0.000 claims abstract description 20
- 230000014759 maintenance of location Effects 0.000 claims description 57
- 238000012937 correction Methods 0.000 claims description 7
- 230000010354 integration Effects 0.000 claims description 5
- 238000004590 computer program Methods 0.000 claims description 3
- 238000004519 manufacturing process Methods 0.000 description 10
- 230000006870 function Effects 0.000 description 7
- 238000004458 analytical method Methods 0.000 description 5
- 238000010586 diagram Methods 0.000 description 5
- 230000003287 optical effect Effects 0.000 description 4
- 230000000694 effects Effects 0.000 description 3
- 230000008520 organization Effects 0.000 description 3
- 230000008569 process Effects 0.000 description 3
- 238000002407 reforming Methods 0.000 description 3
- 238000009825 accumulation Methods 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 230000002093 peripheral effect Effects 0.000 description 2
- 230000007306 turnover Effects 0.000 description 2
- 238000012935 Averaging Methods 0.000 description 1
- 238000003491 array Methods 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 238000012423 maintenance Methods 0.000 description 1
- 230000008707 rearrangement Effects 0.000 description 1
- 230000000717 retained effect Effects 0.000 description 1
- 238000007619 statistical method Methods 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 238000012546 transfer Methods 0.000 description 1
- 238000012795 verification Methods 0.000 description 1
- 239000002699 waste material Substances 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0631—Resource planning, allocation, distributing or scheduling for enterprises or organisations
- G06Q10/06311—Scheduling, planning or task assignment for a person or group
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0633—Workflow analysis
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
- G06Q10/103—Workflow collaboration or project management
Landscapes
- Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- Engineering & Computer Science (AREA)
- Strategic Management (AREA)
- Entrepreneurship & Innovation (AREA)
- Economics (AREA)
- Tourism & Hospitality (AREA)
- Marketing (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Game Theory and Decision Science (AREA)
- Development Economics (AREA)
- Educational Administration (AREA)
- Data Mining & Analysis (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The embodiment of the invention discloses a life cycle data processing method, a life cycle data processing device, life cycle data processing equipment and a computer readable storage medium for metering materials. The method comprises the steps of obtaining measurement material standing book information in a marketing system as a first list; acquiring measurement material real object ledger information obtained by checking by field workers as a second list; acquiring financial standing book information of a financial system as a third list; according to the first list, the second list and the third list, data item matching is carried out to correct data items in the lists until the data items of accounts, materials and finance are matched consistently.
Description
Technical Field
The embodiment of the invention relates to a computer data processing technology, in particular to a life cycle data processing method, a life cycle data processing device, life cycle data processing equipment and life cycle data processing media for metering materials.
Background
The traditional measurement material full life cycle management and control means mainly utilizes a system to export data and perform later-stage integration, and carries out statistical analysis on measurement materials such as account card material consistency, inventory quota ratio, account real spot check, account real consistency, to-be-identified, to-be-scrapped and the like.
At present, the existing metering material life cycle management and control scheme cannot perform data accumulation statistics, and a data system is not communicated and is not updated timely, so that data inconsistency among systems is often caused, and in the face of mass data, workers cannot perform accurate analysis on the data one by one, so that the consistency of three account data is ensured, and the bottleneck restricting the metering full life cycle management and control is formed.
Disclosure of Invention
The embodiment of the invention provides a method, a device, equipment and a medium for processing life cycle data of a metering material, so as to realize the accuracy and comprehensiveness of life cycle management and control of the metering material.
In a first aspect, an embodiment of the present invention provides a life cycle data processing method for a measured material, including:
acquiring measurement material standing book information in a marketing system as a first list;
acquiring measurement material real object ledger information obtained by checking by field workers as a second list;
acquiring financial standing book information of a financial system as a third list;
and according to the first list, the second list and the third list, performing data item matching to correct the data items in the lists until the data items of accounts, materials and finance are matched and consistent.
In a second aspect, an embodiment of the present invention further provides a life cycle data processing apparatus for metering materials, including:
the first acquisition module is used for acquiring the measurement material standing book information in the marketing system as a first list; the second acquisition module is used for acquiring the real-object ledger information of the measured materials, which is obtained by checking by field workers, and taking the real-object ledger information as a second list;
the third acquisition module is used for acquiring the financial standing book information of the financial system as a third clear list; and the first correction module is used for matching data items according to the first list, the second list and the third list so as to correct the data items in the lists until the data items of accounts, materials and finances are matched and consistent.
In a third aspect, an embodiment of the present invention further provides an electronic device, where the electronic device includes:
one or more processors;
a memory for storing one or more programs;
when executed by the one or more processors, cause the one or more processors to implement the method of processing life cycle data for metering supplies as described in the first aspect.
In a fourth aspect, an embodiment of the present invention further provides a computer-readable storage medium, on which a computer program is stored, where the computer program, when executed by a processor, implements the life cycle data processing method for metering materials as described in the first aspect.
The embodiment of the invention obtains the measurement material standing book information in the marketing system as a first list; acquiring measurement material real object ledger information obtained by checking by field workers as a second list; acquiring financial standing book information of a financial system as a 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 lists until the data items of accounts, materials and finance are matched consistently, the technical problems that the time consumption is long, the management and control of the whole life cycle of the current measured materials are complex, more hands are needed to carry out sorting and analysis, inconsistency cannot be found timely are solved, the accuracy rate of identification problem data in the measured materials is high, the speed is high, and the labor cost is effectively reduced are achieved.
Drawings
Fig. 1 is a flowchart of a life cycle data processing method for measuring materials according to an embodiment of the present invention;
fig. 2 is a flowchart of a life cycle data processing method for measuring materials according to a second embodiment of the present invention;
fig. 3 is a flowchart of a life cycle data processing method for measuring materials according to a third embodiment of the present invention;
fig. 4 is a schematic structural diagram of a life cycle data processing apparatus for measuring materials according to a fourth embodiment of the present invention;
fig. 5 is a schematic structural diagram of an electronic device according to a fifth embodiment of the present invention.
Detailed Description
In order to make the technical solutions of the present invention better understood, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
It should be noted that the terms "first," "second," and the like in the description and claims of the present invention and in the drawings described above are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used is interchangeable under appropriate circumstances such that the embodiments of the invention described herein are capable of operation in sequences other than those illustrated or described herein. Furthermore, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed, but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.
Example one
Fig. 1 is a flowchart of a life cycle data processing method for metering materials according to an embodiment of the present invention, where the present embodiment is applicable to a scenario of metering materials management and control, the method may be executed by a life cycle data processing apparatus for metering materials, the apparatus may be implemented by software and/or hardware, and may be generally integrated in an electronic device with a computing function, such as a server, and specifically includes the following steps:
s110, acquiring measurement material standing book information in a marketing system as a first list;
s120, acquiring the real object ledger information of the measured materials, which is obtained by checking by field workers, and taking the real object ledger information as a second list;
s130, acquiring financial standing book information of the financial system as a third list.
It should be noted that the marketing system is a dynamic system for supervising the production process and the sales process of the enterprise. The field worker refers to a person who can verify the information of actual materials in the warehouse, and optionally, the verification mode can be manual counting or clearing by means of a machine. The financial system is an operation system for recording the account information of the enterprise such as inventory, purchase, sale and the like.
And S140, according to the first list, the second list and the third list, data item matching is carried out so as to correct the data items in the lists until the data items of accounts, materials and finance are matched and consistent.
In an embodiment of the present invention, specifically, data items of the first list and the second list are compared to obtain a first comparison result; the data items for comparison are contained in the first list and the second list at the same time, and are at least one of information such as asset codes, power supply units, equipment states, warehouse names, equipment types, specifications, filing dates and manufacturers. The data item that chooses in this application covers the wide range, and is multiple in kind, and strong adaptability can follow less data acquisition contrast result, also can improve the accuracy through comprehensive data to the card thing uniformity of measurement goods and materials has been guaranteed.
S150, if the first comparison result is that the data items are different or the data values of the data items are different, correcting the data items of the first list and the second list, and re-executing the operation of obtaining the first comparison result until the first comparison result is the same;
specifically, when the first comparison result indicates that the data items are different, deleting redundant data items in the first list or the second list, and re-executing the operation of obtaining the first comparison result until the first comparison result is the same;
and when the first comparison result is that the data values of the data items are different, the data items stored in the marketing system are obtained again, so that the current first list is updated, and the first comparison result is obtained again. And if the first comparison result is still different, the field staff checks the real object account information again, then updates the current second list and obtains the first comparison result again. And if the first comparison result is still different, generating and displaying an alarm signal for changing the material standing book information in the marketing system, and changing the material standing book information in the marketing system into updated second list information.
S160, if the first comparison result is that the data items and the data values of the data items are the same, comparing the data items of the first list and the data items of the third list to obtain a second comparison result;
s170, if the second comparison result is that the data items are different or the data values of the data items are different, correcting the contents of the first list and the third list, and re-executing the operation of obtaining the second comparison result until the second comparison result is the same.
Specifically, when the second comparison result is that the data items are different, deleting redundant data items in the first list or the second list, and re-executing the operation of obtaining the second comparison result until the second comparison result is the same;
and when the second comparison result is that the data values of the data items are different, the field staff checks the physical standing book information again, updates the current second list and obtains the second comparison result again. If the second comparison result is still different, the data items in the financial system are recalculated, the current third list is updated, and the second comparison result is acquired again. And if the second comparison result is still different, generating and displaying an alarm signal for changing the financial standing book information in the financial system, and changing the financial standing book information in the financial system into updated third inventory information.
And S180, generating and displaying an alarm signal of data integration completion.
Optionally, when the alarm signal of the material standing book information in the marketing system is changed and the alarm signal of the financial standing book information in the financial system is changed, the alarm lamp is displayed in yellow, and when the alarm signal of data integration completion is displayed, the alarm lamp is displayed in green.
According to the technical scheme of the embodiment, metering material standing book information in a marketing system is obtained and used as a first list; acquiring measurement material real object ledger information obtained by checking by field workers as a second list; acquiring financial standing book information of a financial system as a 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 lists until the data items of accounts, materials and finance are matched consistently, the technical problems that the time consumption is long, the management and control of the whole life cycle of the current measured materials are complex, more hands are needed to carry out sorting and analysis, inconsistency cannot be found timely are solved, the accuracy rate of identification problem data in the measured materials is high, the speed is high, and the labor cost is effectively reduced are achieved.
Example two
Fig. 2 is a flowchart of a life cycle data processing method for metering materials according to an embodiment of the present invention, which is optimized based on the foregoing embodiment, and specifically includes the following steps:
s210, acquiring measurement material standing book information in a marketing system as a first list;
and S220, acquiring quota standing book information of the measured material inventory as a fourth list.
It should be noted that the inventory quota ledger information is a reasonable inventory quantity determined to ensure that the enterprise production and operation activities are performed normally.
S230, comparing the data items of the first list and the fourth list to obtain a third comparison result;
s240, if the third comparison result is that the data value of the first list is smaller than or equal to the data value of the fourth list, judging whether the data value of the first list falls within the range of 80% -100% of the data value of the fourth list; if yes, executing S250, otherwise executing S260;
s250, if yes, generating a primary alarm signal of insufficient inventory;
and S260, if not, generating a secondary alarm signal with sufficient inventory.
In an embodiment of the invention, it can be understood that the measured material standing account information and the inventory quota in the marketing system are compared, and if the actual material quantity is less than the quota standing account information, it indicates that the actual material quantity is less than the quantity required by daily production and operation of an enterprise, the actual material quantity is insufficient, and the inventory has a risk of being lower than the quota quantity. Furthermore, if the actual material quantity belongs to the range of 80% -100% of the rated standing book information, in order to avoid the situation that the supply of the enterprise material is short of the demand, a first-level alarm signal is sent to remind related personnel, and therefore the inventory is increased to a reasonable level.
S270, if the third comparison result shows that the data value of the first list is larger than the data value of the fourth list, generating a three-level alarm signal for consuming material instructions as soon as possible;
s280, verifying and executing the material consumption command as soon as possible, and re-executing the operations of obtaining the first list and the second list and comparing to obtain the third comparison result until the third comparison result is that the data value of the first list is smaller than or equal to the data value of the fourth list.
In an embodiment of the invention, it can be understood that the measured material standing account information and the inventory quota in the marketing system are compared, if the actual material quantity is greater than the quota standing account information, it is indicated that the actual inventory is greater than the quantity required by daily production and operation of an enterprise, and at this time, in order to avoid the accumulation of inventory materials, a three-level alarm signal is generated to prompt related personnel to consume the materials as soon as possible. After the command of consuming the materials as soon as possible is verified and executed, the information of the stock materials and the quota materials is obtained again and compared, and the finally achieved result that the numbers of the stock materials and the quota materials are balanced is ensured. Optionally, the material consumption instruction as soon as possible is generated by software or hardware, and the material consumption instruction as soon as possible may be executed by a computer or by related personnel.
For example, suppose that the quantity of the measured material inventory standing accounts and the quantity of the quota acquired by company a are respectively 90 ten thousand and 100 ten thousand, it is seen that the quantity of the inventory is less than the quantity of the quota, and the quantity of the inventory is 90% of the quantity of the quota, which is in the range of 80% -100%, which indicates that there is a risk that the normal operation of the enterprise production and operation activities cannot be guaranteed, at this time, the alarm lamp turns yellow, and the manager coordinates the production personnel to accelerate the production speed, or fills the inventory through other channels, so as to increase the quantity of the inventory to a reasonable quantity.
For example, suppose that the quantity of the measured material inventory standing accounts and the quantity of the measured material inventory standing accounts acquired by company B are 110 ten thousand and 100 ten thousand respectively, that is, the inventory quantity is greater than the quantity of the measured material inventory, which indicates that a part of materials in the inventory have a risk of being retained, and inevitably occupies a large amount of funds when the inventory quantity of the measured material inventory is excessive, so that the fund transfer speed is reduced, the loan interest expenditure of an enterprise bank is increased, the expenses of storage fees, insurance fees, maintenance fees and the like are increased, great difficulty is brought to the turnover of the enterprise liquidity funds, and normal production and operation activities of the enterprise and difficulty in controlling the inventory cost are influenced to a certain extent. At the moment, the alarm lamp is changed into red, a computer generates a material consumption instruction as soon as possible, relevant personnel make a relevant scheme after checking and determining and execute the scheme, and the alarm lamp is changed into green after the number of the inventory accounts is smaller than the quota number of 100 thousands, so that the current inventory number is reasonable.
EXAMPLE III
Fig. 3 is a flowchart of a life cycle data processing method for metering materials according to a third embodiment of the present invention, which is optimized based on the foregoing embodiments and specifically includes the following steps:
s310, performing data perspective classification on the first list, and extracting and obtaining a list of the retention time of the measured materials to be identified and the retention time of the measured materials to be scrapped as a fifth list;
in one embodiment of the present invention, it should be noted that the data perspective classification refers to statistical summarization of source data through different combinations of data rows or columns, and the summarization includes, but is not limited to, summation, counting, averaging, and the like. The measured materials to be identified can be classified into measured materials to be scrapped or normal stock after being identified. The measured materials to be scrapped are returned materials which are determined to have no use value through the use value identification of the organization of the material use management department, engineering excess materials which are determined to have no use value through the organization identification of the material department, idle materials which are determined to have no use value through the organization identification of the material department and reserve materials which reach the rotation period.
S320, identifying according to the measured materials to be identified and the retention time of the measured materials to be scrapped in the fifth list to determine whether retention conditions are met; if the retention time of the measured materials to be identified is longer than or equal to a first set time or the retention time of the measured materials to be scrapped is longer than or equal to a second set time, determining that the retention condition is met; and the first set time length is less than the second set time length.
S330, if the retention condition is met, generating a starting order correcting instruction;
and S340, verifying and executing the order starting and modifying instruction, and re-executing the operation of extracting and identifying the fifth list until the fifth list does not meet the retention condition, and generating a normal alarm signal.
And S350, if the retention condition is determined not to be met, identifying whether the fifth list meets the retention early warning condition. Wherein, the retention early warning condition is as follows: the retention time of the to-be-identified metering material is within a range of two to three months or the retention time of the to-be-scrapped metering material is within a range of five to six months; if the delay early warning condition is met, a delay early warning signal is generated, otherwise, a normal warning signal is generated.
Optionally, the first set duration and the second set duration may be durations preset according to normal material life cycles of different enterprises.
It can be obtained that when the residence time of the metering materials to be identified is longer than or equal to the first set time, or the residence time of the metering materials to be scrapped is longer than or equal to the second set time, it shows that the residence time of the metering materials to be identified in the stock is too long, so that the stock is accumulated, and the warehouse is occupied, and the production, operation and turnover operation of a company are not facilitated. At the moment, a computer generates a single rectification instruction, the alarm lamp displays red, related personnel verify the quantity of the materials and rectify the materials, and the measured materials to be authenticated are identified as normal stock materials or materials to be scrapped as soon as possible. Redundant discarded materials in the warehouse can be identified in time, the discarded materials in the accumulated inventory materials can be reduced, and the analysis efficiency of the measured materials is improved.
Further, the detention time of the measured materials to be identified belongs to the range of two to three months or the detention time of the measured materials to be scrapped belongs to the range of five to six months, which shows that the detention time of the measured materials to be identified or the measured materials to be scrapped is longer, but the normal production and operation of a company are not influenced, and at the moment, the alarm lamp displays yellow. After relevant personnel verify and correct the materials to be identified or the materials to be discarded, or the retention time of the measured materials to be identified is less than two months or the retention time of the measured materials to be discarded is less than five months, the alarm lamp displays green, which indicates that the retention time of the measured materials to be identified or the measured materials to be discarded is short, and excessive newspaper waste materials cannot be generated in the time range to occupy too much inventory space, so that the relevant personnel do not need to be reminded, and the materials are treated according to the conventional flow.
According to the technical scheme of the embodiment, the quantitative standing book information of the measured material inventory is obtained and used as a fourth statement; 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, judging whether the data value of the first list falls within the range of 80% -100% of the data value of the fourth list; if yes, generating a primary alarm signal of insufficient inventory; if not, a secondary alarm signal with sufficient inventory is generated. Performing data perspective classification on the first list, and extracting and obtaining a retention time list of the measured materials to be identified and the retention time list of the measured materials to be scrapped as a fifth list; identifying according to the retention time of the measured materials to be identified and the measured materials to be scrapped in the fifth list to determine whether retention conditions are met; if the retention condition is met, generating a starting order correction instruction; verifying and executing the order starting and reforming instruction, and re-executing the operation of extracting and identifying the fifth list until the fifth list does not meet the retention condition, generating a normal alarm signal, efficiently and automatically extracting the inventory quota ratio data, quickly identifying the retention materials to be identified and scrapped, and generating a problem reforming task to carry out reforming for related workers; besides, the inventory threshold quota proportion and the residence time tolerance value can be set, an early warning line is set, the function of a red, yellow and green light is identified, and the effective management and control of the work management personnel on the full life cycle of the measured materials are promoted.
Example four
Fig. 4 is a schematic structural diagram of a life cycle data processing apparatus for measuring materials according to a fourth embodiment of the present invention, which is capable of executing the life cycle data processing method for measuring materials according to any embodiment of the present invention, and has functional modules and beneficial effects corresponding to the execution method. The device includes: a first obtaining module 410, a second obtaining module 420, a third obtaining module 430, and a first modifying module 440.
The first obtaining module 410 is configured to obtain measurement material standing book information in the marketing system as a first list; the second obtaining module 420 is configured to obtain material object account information of the measurement materials, which is obtained by checking by field workers, and serve as a second list; a third obtaining module 430, configured to obtain financial standing book information of the financial system as a third statement; and the first correcting module 440 is configured to perform data item matching according to the first list, the second list and the third list, so as to correct data items in the lists until the data items of the account, the material and the finance are matched and consistent.
According to the technical scheme of the embodiment, metering material standing book information in a marketing system is obtained and used as a first list; acquiring measurement material real object ledger information obtained by checking by field workers as a second list; acquiring financial standing book information of a financial system as a 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 lists until the data items of accounts, materials and finance are matched consistently, the technical problems that the time consumption is long, the management and control of the whole life cycle of the current measured materials are complex, more hands are needed to carry out sorting and analysis, inconsistency cannot be found timely are solved, the accuracy rate of identification problem data in the measured materials is high, the speed is high, and the labor cost is effectively reduced are achieved.
Optionally, on the basis of the above technical solution, the apparatus further includes:
the first comparison module is 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 different or the data values of the data items are different, correcting the data items of the first list and the second list, and re-executing the operation of obtaining the first comparison result until the first comparison result is the same;
the second comparison module is used for comparing the data items of the first list and 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;
and if the second comparison result is that the data items are different or the data values of the data items are different, correcting the contents of the first list and the third list, and re-executing the operation of obtaining the second comparison result until the second comparison result is the same.
Further, the alarm module is used for generating and displaying an alarm signal after data integration is completed.
Further, a fourth obtaining module, configured to obtain quantitative standing book information of the measured material inventory as a fourth statement;
the third comparison module is 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, judging whether the data value of the first list falls within the range of 80% -100% of the data value of the second list;
the alarm module is further used for generating a primary 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; if the data value of the first list falls within the range of 80% -100% of the data value of the second list, a secondary alarm signal of sufficient inventory is generated.
The alarm module is further configured to generate a three-level alarm signal for consuming material instructions as soon as possible and causing severe shortage of inventory if the third comparison result indicates that the data value of the first list is greater than the data value of the fourth list;
and the second correction module is used for verifying and executing the material consumption instruction as soon as possible, and re-executing the operations of obtaining the first list and the second list and comparing to obtain the third comparison result until the third comparison result is that the data value of the first list is smaller than or equal to the data value of the fourth list.
Further, a fifth obtaining module, configured to perform data perspective classification on the first list, and extract and obtain a list of retention time periods of the measured materials to be identified and the measured materials to be scrapped as a fifth list;
further, the fourth comparison module is used for identifying according to the retention time of the measured materials to be identified and the measured materials to be scrapped in the fifth list so as to determine whether retention conditions are met;
if the retention condition is met, generating a starting order correction instruction;
and the third correction module is used for verifying and executing the order starting and modifying instruction, and re-executing the operation of extracting and identifying the fifth list until the fifth list does not meet the retention condition, and generating a normal alarm signal.
If the retention time of the measured materials to be identified is longer than or equal to a first set time or the retention time of the measured materials to be scrapped is longer than or equal to a second set time, determining that the retention condition is met; and the first set time length is less than the second set time length.
Further, the fifth comparison module is configured to, if it is determined that the retention condition is not met, identify whether the fifth list meets a retention early warning condition; wherein, the retention early warning condition is as follows: the retention time of the to-be-identified metering material is within a range of two to three months or the retention time of the to-be-scrapped metering material is within a range of five to six months;
the alarm module is also used for generating a retention early warning signal if the retention early warning condition is met, or generating a normal alarm signal if the retention early warning condition is not met.
The life cycle data processing device for measuring materials can execute the life cycle data processing method for measuring materials provided by any embodiment of the invention, and has corresponding functional modules and beneficial effects of the execution method. For details of the technology not described in detail in this embodiment, reference may be made to the method for processing life cycle data of the measured material according to any embodiment of the present invention.
EXAMPLE five
Fig. 5 is a schematic structural diagram of an electronic device according to a fifth embodiment of the present invention. Fig. 5 illustrates a block diagram of a terminal 512 that is suitable for use in implementing embodiments of the present invention. The terminal 512 shown in fig. 5 is only an example and should not bring any limitation to the functions and the scope of use of the embodiments of the present invention.
As shown in fig. 5, the terminal 512 is represented in the form of a general purpose computing device, and has functions of saving pictures by taking pictures, screenshots, and the like, and translating. 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 that couples the various system components including the storage device 528 and the processors 516.
The terminal 512 typically includes a variety of computer system readable media. Such media can be any available media that is accessible by terminal 512 and includes both volatile and nonvolatile media, removable and non-removable media.
The terminal 512 may also communicate with one or more external devices 514 (e.g., keyboard, pointing device, camera, display 524, etc.), with one or more devices that enable a user to interact with the terminal 512, and/or with any devices (e.g., network card, modem, etc.) that enable the terminal 512 to communicate with one or more other computing devices. Such communication may occur via input/output (I/O) interfaces 522. Also, the terminal 512 may communicate with one or more networks (e.g., a Local Area Network (LAN), a Wide Area Network (WAN), and/or a public network, such as the internet) via the network adapter 520. As shown, the network adapter 520 communicates with the other modules of the terminal 512 via a bus 518. It should be appreciated that although not shown, 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, among others.
The processor 516 executes programs stored in the storage device 528 to execute various functional applications and data processing, for example, implementing the life cycle data processing method for metering materials provided by the above-described embodiment of the present invention.
EXAMPLE six
An embodiment of the present invention further provides a storage medium containing computer-executable instructions, which when executed by a computer processor, perform a method for processing lifecycle data for metering supplies, the method including:
acquiring measurement material standing book information in a marketing system as a first list;
acquiring measurement material real object ledger information obtained by checking by field workers as a second list;
acquiring financial standing book information of a financial system as a third list;
and according to the first list, the second list and the third list, performing data item matching to correct the data items in the lists until the data items of accounts, materials and finance are matched and consistent.
Of course, the storage medium provided by the embodiments of the present invention contains computer-executable instructions, and the computer-executable instructions are not limited to the operations of the method described above, and may also perform related operations in the lifecycle data processing method for metering supplies provided by any embodiments of the present invention.
From the above description of the embodiments, it is obvious for those skilled in the art that the present invention can be implemented by software and necessary general hardware, and certainly, can also be implemented by hardware, but the former is a better embodiment in many cases. Based on such understanding, the technical solutions of the present invention may be embodied in the form of a software product, which can be stored in a computer-readable storage medium, such as a floppy disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a FLASH Memory (FLASH), a hard disk or an optical disk of a computer, and includes several instructions for enabling a computer device (which may be a personal computer, a server, or a network device) to execute the methods according to the embodiments of the present invention.
It should be noted that, in the embodiment of the above search apparatus, each included unit and module are merely divided according to functional logic, but are not limited to the above division as long as the corresponding functions can be implemented; in addition, specific names of the functional units are only for convenience of distinguishing from each other, and are not used for limiting the protection scope of the present invention.
It is to be noted that the foregoing is only illustrative of the preferred embodiments of the present invention and the technical principles employed. It will be understood by those skilled in the art that the present invention is not limited to the particular embodiments described herein, but is capable of various obvious changes, rearrangements and substitutions as will now become apparent to those skilled in the art without departing from the scope of the invention. Therefore, although the present invention has been described in greater detail by the above embodiments, the present invention is not limited to the above embodiments, and may include other equivalent embodiments without departing from the spirit of the present invention, and the scope of the present invention is determined by the scope of the appended claims.
Claims (11)
1. A life cycle data processing method for metering materials is characterized by comprising the following steps:
acquiring measurement material standing book information in a marketing system as a first list;
acquiring measurement material real object ledger information obtained by checking by field workers as a second list;
acquiring financial standing book information of a financial system as a third list;
and according to the first list, the second list and the third list, performing data item matching to correct the data items in the lists until the data items of accounts, materials and finance are matched and consistent.
2. The method of claim 1, wherein matching data items according to the first manifest, the second manifest, and the third manifest to correct data items in the manifest until reaching a consistent matching of data items for accounts, materials, and finances comprises:
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 different or the data values of the data items are different, correcting the data items of the first list and the second list, and re-executing 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, comparing the data items of the first list and the data items of the third list to obtain a second comparison result;
and if the second comparison result is that the data items are different or the data values of the data items are different, correcting the contents of the first list and the third list, and re-executing the operation of obtaining the second comparison result until the second comparison result is the same.
3. The method of claim 2, wherein after obtaining the second comparison result as the same, further comprising:
and generating and displaying an alarm signal of data integration completion.
4. The method of claim 1, further comprising:
acquiring quota ledger information of the measured material inventory as a fourth statement;
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, judging whether the data value of the first list falls within the range of 80% -100% of the data value of the second list;
if yes, generating a primary alarm signal of insufficient inventory; if not, a secondary alarm signal with sufficient inventory is generated.
5. The method of claim 4, wherein comparing the data items of the first manifest and the fourth manifest to obtain a third comparison result further comprises:
if the third comparison result is that the data value of the first list is larger than the data value of the fourth list, generating a three-level alarm signal for consuming material instructions as soon as possible and seriously lacking inventory;
and verifying and executing the material consumption command as soon as possible, and re-executing the operations of acquiring the first list and the second list and comparing 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 that of the fourth list.
6. The method of claim 4, further comprising:
performing data perspective classification on the first list, and extracting and obtaining a retention time list of the measured materials to be identified and the retention time list of the measured materials to be scrapped as a fifth list;
identifying according to the retention time of the measured materials to be identified and the measured materials to be scrapped in the fifth list to determine whether retention conditions are met;
if the retention condition is met, generating a starting order correction instruction;
and verifying and executing the order-starting and modifying instruction, and re-executing the operation of extracting and identifying the fifth list until the fifth list does not meet the retention condition, and generating a normal alarm signal.
7. The method of claim 6, wherein identifying based on the retention periods of the metered materials to be authenticated and the metered materials to be discarded in the fifth list to determine whether the retention condition is satisfied comprises:
if the retention time of the measured materials to be identified is longer than or equal to a first set time or the retention time of the measured materials to be scrapped is longer than or equal to a second set time, determining that the retention condition is met; and the first set time length is less than the second set time length.
8. The method of claim 6, wherein after determining whether a retention condition is satisfied, further comprising:
if the fact that the retention condition is not met is determined, whether the fifth list meets the retention early warning condition or not is identified; wherein, the retention early warning condition is as follows: the retention time of the to-be-identified metering material is within a range of two to three months or the retention time of the to-be-scrapped metering material is within a range of five to six months;
if the delay early warning condition is met, a delay early warning signal is generated, otherwise, a normal warning signal is generated.
9. A life cycle data processing apparatus for metering materials, comprising:
the first acquisition module is used for acquiring the measurement material standing book information in the marketing system as a first list;
the second acquisition module is used for acquiring the real-object ledger information of the measured materials, which is obtained by checking by field workers, and taking the real-object ledger information as a second list;
the third acquisition module is used for acquiring the financial standing book information of the financial system as a third clear list;
and the first correction module is used for matching data items according to the first list, the second list and the third list so as to correct the data items in the lists until the data items of accounts, materials and finances are matched and consistent.
10. An electronic device, characterized in that the device comprises:
one or more processors;
a memory for storing one or more programs;
when executed by the one or more processors, cause the one or more processors to implement the method of life cycle data processing for metering supplies of any of claims 1-8.
11. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out a method for life cycle data processing of a metered asset as claimed in any one of claims 1 to 8.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111464184.3A CN114139975A (en) | 2021-12-03 | 2021-12-03 | Life cycle data processing method, device, equipment and medium for metering materials |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111464184.3A CN114139975A (en) | 2021-12-03 | 2021-12-03 | Life cycle data processing method, device, equipment and medium for metering materials |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN114139975A true CN114139975A (en) | 2022-03-04 |
Family
ID=80387433
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111464184.3A Pending CN114139975A (en) | 2021-12-03 | 2021-12-03 | Life cycle data processing method, device, equipment and medium for metering materials |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114139975A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115022382A (en) * | 2022-08-10 | 2022-09-06 | 广东电网有限责任公司 | Metering information interaction platform and method based on asynchronous queue |
Citations (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2002073960A (en) * | 2000-08-29 | 2002-03-12 | Obic Business Consultants Ltd | Work software process control device |
| JP2004051374A (en) * | 2002-05-28 | 2004-02-19 | Japan Logistic Systems Inc | Seamless commodity physical distribution information system |
| JP2004094943A (en) * | 2002-08-16 | 2004-03-25 | Ai Japan Kk | Integrated management information management system |
| JP2007249276A (en) * | 2006-03-13 | 2007-09-27 | Nec Commun Syst Ltd | Asset management system, asset management server, asset management method and asset management program |
| CN105096050A (en) * | 2015-08-12 | 2015-11-25 | 中国南方电网有限责任公司 | Asset whole life cycle management system and method |
| CN108053294A (en) * | 2017-12-30 | 2018-05-18 | 淄博赢信达知识产权咨询服务有限公司 | The method that net purchase commercial product identification uniqueness is proved by order contents |
| CN108109062A (en) * | 2017-12-06 | 2018-06-01 | 广东电网有限责任公司惠州供电局 | Electric system power transmission and transformation kind equipment is intelligently converted into financial system account for assets method |
| CN109447553A (en) * | 2018-10-31 | 2019-03-08 | 国网河北省电力有限公司电力科学研究院 | A kind of checking method of inventory, system and terminal device |
| CN109492961A (en) * | 2018-09-12 | 2019-03-19 | 中国科学院电子学研究所 | A kind of goods and material handling method, system and computer readable storage medium |
| CN109559010A (en) * | 2018-10-15 | 2019-04-02 | 平安科技（深圳）有限公司 | Goods and materials distribution method, device, computer equipment and storage medium |
| CN112735010A (en) * | 2020-12-12 | 2021-04-30 | 深圳供电局有限公司 | Metering warehouse material checking system and checking method thereof |
-
2021
- 2021-12-03 CN CN202111464184.3A patent/CN114139975A/en active Pending
Patent Citations (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2002073960A (en) * | 2000-08-29 | 2002-03-12 | Obic Business Consultants Ltd | Work software process control device |
| JP2004051374A (en) * | 2002-05-28 | 2004-02-19 | Japan Logistic Systems Inc | Seamless commodity physical distribution information system |
| JP2004094943A (en) * | 2002-08-16 | 2004-03-25 | Ai Japan Kk | Integrated management information management system |
| JP2007249276A (en) * | 2006-03-13 | 2007-09-27 | Nec Commun Syst Ltd | Asset management system, asset management server, asset management method and asset management program |
| CN105096050A (en) * | 2015-08-12 | 2015-11-25 | 中国南方电网有限责任公司 | Asset whole life cycle management system and method |
| CN108109062A (en) * | 2017-12-06 | 2018-06-01 | 广东电网有限责任公司惠州供电局 | Electric system power transmission and transformation kind equipment is intelligently converted into financial system account for assets method |
| CN108053294A (en) * | 2017-12-30 | 2018-05-18 | 淄博赢信达知识产权咨询服务有限公司 | The method that net purchase commercial product identification uniqueness is proved by order contents |
| CN109492961A (en) * | 2018-09-12 | 2019-03-19 | 中国科学院电子学研究所 | A kind of goods and material handling method, system and computer readable storage medium |
| CN109559010A (en) * | 2018-10-15 | 2019-04-02 | 平安科技（深圳）有限公司 | Goods and materials distribution method, device, computer equipment and storage medium |
| CN109447553A (en) * | 2018-10-31 | 2019-03-08 | 国网河北省电力有限公司电力科学研究院 | A kind of checking method of inventory, system and terminal device |
| CN112735010A (en) * | 2020-12-12 | 2021-04-30 | 深圳供电局有限公司 | Metering warehouse material checking system and checking method thereof |
Non-Patent Citations (1)
| Title |
|---|
| 吴恩: "钢贸企业进销存管理系统的设计与实现", 中国优秀硕士学位论文全文数据库信息科技辑, no. 5, 15 May 2014 (2014-05-15) * |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115022382A (en) * | 2022-08-10 | 2022-09-06 | 广东电网有限责任公司 | Metering information interaction platform and method based on asynchronous queue |
| CN115022382B (en) * | 2022-08-10 | 2023-01-20 | 广东电网有限责任公司 | Metering information interaction platform and method based on asynchronous queue |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Monroy et al. | Activity based costing, time-driven activity based costing and lean accounting: Differences among three accounting systems’ approach to manufacturing | |
| CN111401777B (en) | Enterprise risk assessment method, enterprise risk assessment device, terminal equipment and storage medium | |
| CN108734561A (en) | Electronic device, order data processing method and computer readable storage medium | |
| CN108415917B (en) | Visual report generation method and visual report generation device | |
| CN111695979A (en) | Method, device and equipment for analyzing relation between raw material and finished product | |
| CN105245351A (en) | Charging method and device | |
| CN114139975A (en) | Life cycle data processing method, device, equipment and medium for metering materials | |
| CN114840531A (en) | Data model reconstruction method, device, equipment and medium based on blood relationship | |
| Guo | [Retracted] Enterprise Management Decision and Financial Management Based on Dynamic Cost Volume Profit Model | |
| CN116777652A (en) | Risk evaluation model-based financial analysis method | |
| WO2019196502A1 (en) | Marketing activity quality assessment method, server, and computer readable storage medium | |
| CN113435746B (en) | User workload scoring method and device, electronic equipment and storage medium | |
| CN114066209A (en) | Service distribution method, device, equipment and computer storage medium | |
| CN113298530A (en) | Transaction configuration method, device, equipment and medium based on market data classification | |
| CN113034258A (en) | Tax data processing method and device, electronic equipment and storage medium | |
| TWI634498B (en) | Business operations analysis system and method | |
| CN115392206B (en) | Method, device and equipment for quickly querying data based on WPS/EXCEL and storage medium | |
| Johnson et al. | Current replacement costs: a qualified opinion | |
| Allahaim et al. | Developing a risk-based cost contingency estimation model based on the influence of cost overrun causes | |
| CN109872163A (en) | The recognition methods of abnormal production enterprise and device | |
| CN116150438B (en) | Data processing method and device based on transaction map | |
| TWI550531B (en) | Enterprise resource planning performance evaluation system and method | |
| TW201101205A (en) | Manufacturing cost analysis system | |
| CN114254905A (en) | Resource efficiency parameter evaluation method, device, equipment and storage medium | |
| CN115204679A (en) | Intelligent analysis method and device for research and development project effect, electronic equipment and medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |