CN118096011A - Inventory data updating method, updating device, equipment and medium - Google Patents
Inventory data updating method, updating device, equipment and medium Download PDFInfo
- Publication number
- CN118096011A CN118096011A CN202211428097.7A CN202211428097A CN118096011A CN 118096011 A CN118096011 A CN 118096011A CN 202211428097 A CN202211428097 A CN 202211428097A CN 118096011 A CN118096011 A CN 118096011A
- Authority
- CN
- China
- Prior art keywords
- data
- inventory
- current
- determining
- updating
- 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
- 238000000034 method Methods 0.000 title claims abstract description 45
- 239000000463 material Substances 0.000 claims abstract description 348
- 230000008859 change Effects 0.000 claims abstract description 298
- XLYOFNOQVPJJNP-UHFFFAOYSA-N water Substances O XLYOFNOQVPJJNP-UHFFFAOYSA-N 0.000 claims abstract description 52
- 230000002159 abnormal effect Effects 0.000 claims description 22
- 238000012163 sequencing technique Methods 0.000 claims description 9
- 230000004044 response Effects 0.000 claims description 8
- 238000004590 computer program Methods 0.000 claims description 4
- 238000010586 diagram Methods 0.000 description 6
- 238000004891 communication Methods 0.000 description 4
- 238000013461 design Methods 0.000 description 4
- 230000008878 coupling Effects 0.000 description 3
- 238000010168 coupling process Methods 0.000 description 3
- 238000005859 coupling reaction Methods 0.000 description 3
- 238000012545 processing Methods 0.000 description 3
- 230000005856 abnormality Effects 0.000 description 2
- 230000006870 function Effects 0.000 description 2
- 230000007246 mechanism Effects 0.000 description 2
- 238000006467 substitution reaction Methods 0.000 description 2
- 230000001360 synchronised effect Effects 0.000 description 2
- 238000012360 testing method Methods 0.000 description 2
- 238000012795 verification Methods 0.000 description 2
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000008569 process Effects 0.000 description 1
Classifications
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/30—Computing systems specially adapted for manufacturing
Abstract
The application provides an updating method, an updating device, equipment and a medium of inventory data, wherein the updating method comprises the following steps: determining a plurality of pieces of current inventory change information; acquiring a template to be filled and current inventory data corresponding to a material movement record table, and filling the template to be filled by utilizing the current inventory data and a plurality of pieces of current inventory change information to obtain a current material movement record table; generating a current material inventory balance table according to the inventory change type and the inventory change quantity recorded in the current material movement record table; acquiring a historical material flow water meter, and updating data in the historical material flow water meter according to a current material movement record table to generate a current material flow water meter; and acquiring a historical material statistics table, and updating the historical material statistics table according to the current material movement record table to obtain a current material day statistics table. According to the updating method and the updating device, the stock data can be updated, and meanwhile, statistics of income, emission and inventory related to the materials can be rapidly provided.
Description
Technical Field
The present application relates to the field of data processing, and in particular, to a method, an apparatus, a device, and a medium for updating inventory data.
Background
In inventory management software, the updated design of inventory is the core content. In order to ensure the real-time performance of the service, the synchronous updating of the data related to the inventory of a large amount of data under the multi-concurrency scene often occurs. The updating of the stock data has time sequence, and the updating operation can be carried out on the follow-up data after the previous data of the same material is updated.
Common problems that occur in conventional inventory update designs are: inconsistent inventory updating occurs, and time and labor are wasted in searching problem documents; the relevance of the data is strong, and the difficulty in adjusting the data is great; the report running speed of inventory statistics is slow, and outdated data influences the correctness and efficiency of business decisions.
Whether the inventory data is updated correctly or not directly relates to the consistency of service data and system data, and also tests the robustness and credibility of the product; inventory related data is also the key point of statistics and management of business and financial departments, and high requirements are put on the real-time performance of business statistics data.
Disclosure of Invention
In view of the above, the present application aims to provide a method, an apparatus, a device and a medium for updating inventory data, which can synchronously generate a material movement record table, an inventory balance table, a material flow water meter and a material day statistics table according to current inventory change information in each business of entering and exiting inventory, and can quickly provide statistics of income, emission and inventory related to materials while updating inventory data.
In a first aspect, an embodiment of the present application provides an updating method of inventory data, where the updating method includes:
Determining a plurality of pieces of current inventory change information in response to an input operation of the inventory change information by a user; the current inventory change information comprises a material name, an inventory location, an inventory change type, an inventory change quantity and an inventory change time, wherein the inventory change type comprises ex-warehouse and in-warehouse;
acquiring a template to be filled and current inventory data corresponding to a material movement record table, and filling the template to be filled by utilizing the current inventory data and the plurality of pieces of current inventory change information to obtain a current material movement record table;
Generating a current material inventory balance table according to the inventory change type and the inventory change number recorded in the current material movement record table;
acquiring a historical material flow water meter, and updating data in the historical material flow water meter according to the current material movement record table to generate a current material flow water meter;
and acquiring a historical material statistics table, and updating the historical material statistics table according to the current material movement record table to obtain a current material daily statistics table.
Further, the filling the template to be filled with the current inventory data and the plurality of pieces of current inventory change information to obtain a current material movement record table, including:
Determining a first quantity of the pieces of current inventory change information, and creating a plurality of first data rows corresponding to the first quantity in the template to be filled;
Sequencing the plurality of pieces of current inventory change information in time sequence by utilizing the inventory change time in each piece of current inventory change information in the plurality of pieces of current inventory change information to obtain an information sequence table;
determining data to be filled for filling the template from the current inventory change information by utilizing the data category of each item to be filled in the template to be filled aiming at each piece of current inventory change information;
Determining the order of the current stock change information in the information sequence table, and determining a target data row to which the current stock change information belongs from a plurality of first data rows according to the order;
Filling each item to be filled in the target data row in the template to be filled with the data to be filled, obtaining a filled template to be filled, and determining the filled template to be filled as the current material movement record table;
for a first one of a plurality of first data rows in the current material movement record table, adding the current inventory data to a pre-update quantity data item in the first one of the first data rows;
For each other data row of the plurality of first data rows in the current material movement record table except for the first data row, determining pre-update quantity data in the other data row by utilizing pre-update quantity data, inventory change type data and inventory change quantity data in a last data row positioned before the other data row, and adding the pre-update quantity data in the other data row to pre-update quantity data items in the other data row.
Further, the generating a current stock balance table according to the stock change type and the stock change number recorded in the current stock movement record table includes:
Acquiring inventory change type data, inventory change quantity data and pre-update quantity data in the last first data row in a plurality of first data rows in the current material movement record table;
determining current material inventory data by utilizing the inventory change type data, the inventory change quantity data and the pre-update quantity data in the last first data row;
And adding the current material inventory data, the material name data in the last first data row and the inventory location data in the last first data row into a balance table blank template to determine the current material inventory balance table.
Further, the step of obtaining the historical material flow water meter, updating the data in the historical material flow water meter according to the current material movement record table, and generating the current material flow water meter includes:
According to the second number of the data lines included in the current material movement record table, a plurality of second data lines corresponding to the second number are newly added in the historical material flow table;
And determining material movement data required for filling the second data row in the current material movement record table based on the sequence of the second data row in a plurality of second data rows for each second data row, and adding the material movement data into the second data row according to the data items included in the second data row to obtain the current material flow water meter.
Further, the updating the historical material statistics table according to the current material movement record table to obtain a current material day statistics table includes:
determining at least one inventory change date related to the plurality of pieces of current inventory change information and inventory change days corresponding to the at least one inventory change date according to the inventory change time recorded by each first data line in the current material movement record table;
According to the third number corresponding to the inventory change days, a third data row corresponding to the third number is newly added in the historical material statistics table, and the at least one inventory change date and the latest inventory update time in the inventory update time corresponding to each inventory change date are added into the third data row according to time sequence;
For each stock change date, determining at least one target first data row corresponding to the stock change date in the current material movement record table, determining the total ex-warehouse quantity, the total warehouse-in data and the current stock balance quantity corresponding to the stock change date according to the stock change type, the stock change quantity and the pre-update quantity data recorded in the at least one target first data row, and adding the total ex-warehouse quantity, the total warehouse-in quantity and the current stock balance quantity to a third data row corresponding to the stock change date;
and adding the material name data and the stock location data recorded in at least one target first data row to a third data row corresponding to the stock change date to obtain the current material day statistical table.
Further, the updating method further includes:
Determining at least one material statistics month related to the current material day statistics table by utilizing each inventory change date recorded in the current material day statistics table;
For each material counting month, determining a target third data row with the latest inventory change time and a last third data row positioned before the target third data row in a third data row corresponding to the material counting month in the current material daily statistics table;
determining a first inventory data amount to be compared corresponding to an inventory change date to which a target third data line belongs according to the current inventory balance number in the last third data line and the total ex-warehouse number and the total warehouse-in number in the target third data line;
If the first inventory data quantity to be compared is different from the current-day inventory balance data quantity recorded in the target third data line, determining an inventory change date corresponding to the third data line as a data update abnormal date;
determining a data row to be checked in the current material flow water meter according to the data updating abnormal date, and sequencing the data row to be checked in time sequence according to the inventory updating time recorded in each data row to be checked in the data row to be checked to obtain the material flow water meter to be checked;
for each data line to be checked, determining a second inventory data amount to be compared corresponding to the data line to be checked according to the quantity data before updating and the inventory change quantity in the data line to be checked;
And if the second inventory data quantity to be compared is different from the pre-update quantity data recorded in the next abnormal data row positioned behind the data row to be checked in the material flow table to be checked, determining that the data row to be checked is determined to be the abnormal data row.
Further, the updating method further includes:
responding to the selection operation of a user on the date range to be counted, and determining a target date range;
Determining a third data row to be counted corresponding to the target date range in the current material day counting table;
for each third data line to be counted, determining the ex-warehouse number and the in-warehouse number of the third data line to be counted according to the inventory change type and the inventory change number recorded in the third data line to be counted;
adding the ex-warehouse quantity corresponding to each third data row to be counted to obtain the total ex-warehouse quantity corresponding to the target date range, and adding the warehouse-in quantity corresponding to each third data row to be counted to obtain the total warehouse-in quantity corresponding to the target date range;
determining a first third data row to be counted with the earliest inventory updating time and a second third data row to be counted with the latest inventory updating time from the third data rows to be counted;
And determining the current day inventory balance quantity recorded in the first third data row to be counted as the initial inventory quantity corresponding to the target date range, and determining the current day inventory balance quantity recorded in the second third data row to be counted as the final inventory quantity corresponding to the target date range.
In a second aspect, an embodiment of the present application further provides an updating apparatus for inventory data, where the updating apparatus includes:
The inventory change information determining module is used for determining a plurality of pieces of current inventory change information in response to the input operation of the user on the inventory change information; the current inventory change information comprises a material name, an inventory location, an inventory change type, an inventory change quantity and an inventory change time, wherein the inventory change type comprises ex-warehouse and in-warehouse;
The mobile record table generation module is used for acquiring a template to be filled and current inventory data corresponding to the material mobile record table, and filling the template to be filled by utilizing the current inventory data and the plurality of pieces of current inventory change information to obtain a current material mobile record table;
The inventory balance table generation module is used for generating a current material inventory balance table according to the inventory change type and the inventory change quantity recorded in the current material movement record table;
The material flow water meter generating module is used for acquiring a historical material flow water meter, updating data in the historical material flow water meter according to the current material movement record table and generating a current material flow water meter;
And the material daily statistics table generation module is used for acquiring a historical material statistics table, and updating the historical material statistics table according to the current material movement record table to obtain a current material daily statistics table.
In a third aspect, an embodiment of the present application further provides an electronic device, including: a processor, a memory and a bus, the memory storing machine-readable instructions executable by the processor, the processor and the memory in communication via the bus when the electronic device is running, the machine-readable instructions when executed by the processor performing the steps of the inventory data updating method as described above.
The embodiments of the present application also provide a computer readable storage medium having stored thereon a computer program which, when executed by a processor, performs the steps of the method of updating inventory data as described above.
According to the method for updating the stock data, in each business of the in-out bill, the material movement record table, the stock balance table, the material flow water meter and the material daily statistics table are synchronously generated according to the current stock change information, the quantity before updating is recorded in each table, the quantity of the in-out bill, the quantity of the out-of-stock bill and the stock balance can be updated in real time, and the stock data can be updated, and meanwhile, statistics of income, emission and stock related to materials can be rapidly provided. And the data report can be verified at the end of the month, a real-time verification mechanism for the data report can be provided while the data report is updated rapidly, and the consistency and the correctness of the data are ensured.
In order to make the above objects, features and advantages of the present application more comprehensible, preferred embodiments accompanied with figures are described in detail below.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present application, the drawings that are needed in the embodiments will be briefly described below, it being understood that the following drawings only illustrate some embodiments of the present application and therefore should not be considered as limiting the scope, and other related drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.
FIG. 1 is a flowchart of a method for updating inventory data according to an embodiment of the present application;
FIG. 2 is a schematic diagram of an apparatus for updating inventory data according to an embodiment of the present application;
FIG. 3 is a second schematic diagram of an apparatus for updating inventory data according to an embodiment of the present application;
fig. 4 is a schematic structural diagram of an electronic device according to an embodiment of the present application.
Detailed Description
For the purpose of making the objects, technical solutions and advantages of the embodiments of the present application more apparent, the technical solutions of the embodiments of the present application will be clearly and completely described below with reference to the accompanying drawings in the embodiments of the present application, and it is apparent that the described embodiments are only some embodiments of the present application, not all embodiments. The components of the embodiments of the present application generally described and illustrated in the figures herein may be arranged and designed in a wide variety of different configurations. Thus, the following detailed description of the embodiments of the application, as presented in the figures, is not intended to limit the scope of the application, as claimed, but is merely representative of selected embodiments of the application. Based on the embodiments of the present application, every other embodiment obtained by a person skilled in the art without making any inventive effort falls within the scope of protection of the present application.
First, an application scenario to which the present application is applicable will be described. The application can be applied to the field of data processing.
In inventory management software, the updated design of inventory is the core content. In order to ensure the real-time performance of the service, the synchronous updating of the data related to the inventory of a large amount of data under the multi-concurrency scene often occurs. The updating of the stock data has time sequence, and the updating operation can be carried out on the follow-up data after the previous data of the same material is updated.
It has been found that common problems that occur in conventional inventory update designs are: inconsistent inventory updating occurs, and time and labor are wasted in searching problem documents; the relevance of the data is strong, and the difficulty in adjusting the data is great; the report running speed of inventory statistics is slow, and outdated data influences the correctness and efficiency of business decisions.
Whether the inventory data is updated correctly or not directly relates to the consistency of service data and system data, and also tests the robustness and credibility of the product; inventory related data is also the key point of statistics and management of business and financial departments, and high requirements are put on the real-time performance of business statistics data.
Based on the above, the embodiment of the application provides a method for updating inventory data, which can quickly provide statistics of income, emission and inventory related to materials while updating the inventory data.
Referring to fig. 1, fig. 1 is a flowchart of a method for updating inventory data according to an embodiment of the application. As shown in fig. 1, the method for updating inventory data provided by the embodiment of the application includes:
S101, determining a plurality of pieces of current inventory change information in response to the input operation of the inventory change information by a user.
The stock change information refers to change information related to the stock moving operation which is automatically input by the user when the stock moving operation is performed. Wherein the current inventory change information includes a material name, an inventory location, an inventory change type, an inventory change quantity, and an inventory change time. Here, the inventory change type includes ex-warehouse and in-warehouse.
For the above step S101, in implementation, when the inventory movement occurs, the user needs to autonomously upload the current inventory change information related to the inventory movement operation. The current stock change information may be change information in the same day or change information in different days, which is not particularly limited in the present application.
S102, acquiring a template to be filled and current inventory data corresponding to the material movement record list, and filling the template to be filled by utilizing the current inventory data and the plurality of pieces of current inventory change information to obtain the current material movement record list.
It should be noted that the current stock data refers to the amount of material remaining in the warehouse before the stock moving operation is performed. The material movement record list refers to a list for recording the current stock movement operation. And the template to be filled is pre-built, a blank table of the material movement record table is generated, and the template to be filled comprises data items which need to be filled by using the current stock change information.
For the step S102, in the implementation, a template to be filled and current inventory data corresponding to the material movement record table are obtained, and the template to be filled is filled by using the current inventory data and the pieces of current inventory change information obtained in the step S101, so as to obtain the current material movement record table.
Specifically, for the step S102, the filling the template to be filled with the current inventory data and the pieces of current inventory change information to obtain a current material movement record table includes:
Step 1021, determining a first number of the pieces of current inventory change information, and creating a plurality of first data lines corresponding to the first number in the template to be filled.
The first number refers to the number of pieces of current inventory change information acquired in step S101. The first data line refers to the data line which is created in the template to be filled and needs to be filled and corresponds to the first quantity.
For the above step 1021, in implementation, a first number of pieces of current inventory change information acquired in step S101 is determined, and then a plurality of first data lines corresponding to the first number are created in the template to be filled. For example, if 5 pieces of current inventory change information are acquired in step S101, 5 first data lines need to be created in the template to be filled.
Step 1022, using the stock change time in each piece of current stock change information in the pieces of current stock change information to time-sequentially sort the pieces of current stock change information, thereby obtaining an information sequence table.
It should be noted that the information sequence table refers to an information sequence table obtained after time sequencing of a plurality of pieces of current inventory change information.
For the above step 1022, in implementation, first, the inventory change time of each piece of current inventory change information in the plurality of pieces of current inventory change information is determined, and then the plurality of pieces of current inventory change information are sorted in time sequence by using the inventory change time, so as to obtain the information sequence table.
Step 1023, determining the data to be filled for filling the template from the current stock change information by using the data category of each item to be filled in the template to be filled according to each piece of current stock change information.
It should be noted that, the to-be-filled item refers to each to-be-filled data item in the to-be-filled template, for example, when the to-be-filled item may be a material name, a stock location, a stock change type, and the like. The data to be filled refers to data required for filling the item to be filled, for example, when the item to be filled is of stock change type, the data to be filled may be put in a warehouse, and when the item to be filled is of stock place, the data to be filled may be place a. The data category refers to a data category of data to be filled required to fill the item to be filled.
Here, it should be noted that the above examples of items to be filled, data categories, and data to be filled are merely examples, and in practice, the items to be filled, data categories, and data to be filled are not limited to the above examples.
For the step 1023, in implementation, for each piece of current inventory change information, the data category of each item to be filled in the template to be filled is utilized to determine the data to be filled for filling the template to be filled from the current inventory change information.
Step 1024, determining the order of the current inventory change information in the information sequence table, and determining the target data row to which the current inventory change information belongs from the plurality of first data rows according to the order.
And step 1025, filling each item to be filled in the target data row in the template to be filled with the data to be filled, so as to obtain a well filled template to be filled, and determining the well filled template to be filled as the current material movement record table.
For the above steps 1024 and 1025, when in implementation, the order of the current piece of inventory change information in the information sequence table is determined, and the target data row to which the current piece of inventory change information belongs is determined from the plurality of first data rows according to the order. For example, the order of the current inventory change information in the information sequence table is 2 nd, and the second data row in the plurality of first data rows is the target data row to which the current inventory change information belongs. And then, filling each item to be filled in the target data row in the template to be filled by using the determined data to be filled, obtaining a filled template to be filled, and determining the filled template to be filled as a current material movement record table.
Step 1026, for a first one of a plurality of first data rows in the current material movement record table, adding the current inventory data to the pre-update quantity data item in the first one of the first data rows.
Step 1027, for each other first data row except the first data row in the plurality of first data rows in the current material movement record table, determining pre-update quantity data in the other first data row by using pre-update quantity data, inventory change type data and inventory change quantity data in a last first data row located before the other first data row, and adding the pre-update quantity data in the other first data row to the pre-update quantity data item in the other first data row.
It should be noted that, the first data line refers to the data line located in the first line in the current material movement record table generated in step 1025. The other first data line refers to other data lines in the current material movement record table except the data line located in the first line. The last first data line refers to the data line of the current material movement record table located on the last line of the other data lines. The pre-update quantity data item refers to a data item in a material movement record table for recording the remaining stock quantity before a certain material movement operation.
For the steps 1026 and 1027, in implementation, the current inventory data acquired in step S102 is added to the pre-update quantity data item in the first data row for the first one of the plurality of first data rows in the current material movement record table generated in step 1025. For each other first data row of the plurality of first data rows in the current material movement record table generated in step 1025, determining pre-update quantity data in the other first data row using pre-update quantity data, inventory change type data, and inventory change quantity data in a last first data row preceding the other first data row, and adding the pre-update quantity data in the other first data row to the pre-update quantity data items in the other first data row. Specifically, if the inventory change type is out of stock, subtracting the inventory change quantity data from the quantity data before update in the previous first data row to obtain quantity data before update in the other first data row; if the stock change type is warehouse entry, the pre-update quantity data in the other first data rows is obtained by adding the pre-update quantity data in the last first data row and the stock change quantity data.
S103, generating a current material inventory balance table according to the inventory change type and the inventory change number recorded in the current material movement record table.
The material inventory balance table is a table for recording the amount of material remaining in the warehouse after the inventory movement operation is performed.
For the above step S103, in the implementation, after the current material movement record table in step S102 is generated, a current material inventory balance table is generated according to the inventory change type and the inventory change number recorded in the current material movement record table.
Specifically, for the step S103, the generating a current stock balance table according to the stock change type and the stock change number recorded in the current stock movement record table includes:
Step 1031, obtaining inventory change type data, inventory change quantity data and pre-update quantity data in a last first data row of a plurality of first data rows in the current material movement record table.
Step 1032, determining current stock data of the material by using the stock change type data, the stock change quantity data and the pre-update quantity data in the last first data line;
Step 1033, adding the current material inventory data, the material name data in the last first data row and the inventory location data in the last first data row to a balance table blank template, and determining the current material inventory balance table.
It should be noted that, the last first data line refers to the data line located in the last line in the current material movement record table generated in step S102. The current stock data refers to the amount of material remaining in the warehouse after the stock movement operation is performed. The balance list blank template refers to a blank table used for generating a material inventory balance list. The balance list blank template comprises data items which need to be filled by using the current stock change information.
For the above steps 1031 to 1033, in implementation, the stock change type data, the stock change quantity data, and the pre-update quantity data in the last first data row of the plurality of first data rows in the current material movement record table generated in step S102 are acquired. And determining the current material inventory data by utilizing the inventory change type data, the inventory change quantity data and the pre-update quantity data in the last first data row.
And adding the current material inventory data, the material name data in the last first data row and the inventory location data in the last first data row into a balance table blank template to determine the current material inventory balance table.
S104, acquiring a historical material flow water meter, and updating data in the historical material flow water meter according to the current material movement record table to generate a current material flow water meter.
It should be noted that the historical material flow water meter refers to a table for recording historical material flow before the material moving operation is performed. The current material flow water meter refers to a table for recording historical material flow water and current material flow water after material movement operation.
For the above step S104, in implementation, a historical material flow water meter is obtained, and the data in the historical material flow water meter is updated according to the current material movement record table generated in step S102, so as to generate the current material flow water meter.
Specifically, for the step S104, the step of obtaining the historical material flow meter, updating the data in the historical material flow meter according to the current material movement record table, and generating the current material flow meter includes:
step 1041, adding a plurality of second data lines corresponding to the second number in the historical material flow table according to the second number of the data lines included in the current material movement record table.
Step 1042, for each second data line, determining, in the current material movement record table, material movement data required for filling the second data line based on the order of the second data line in the plurality of second data lines, and adding the material movement data to the second data line according to the data items included in the second data line, to obtain the current material flow meter.
It should be noted that the second number refers to the number of data rows included in the current material movement record table. The second data line refers to the data line which is created in the historical material flow table and needs to be filled and corresponds to the second data line.
For the steps 1041 and 1042, in the implementation, according to the second number of data lines included in the current material movement record table, a plurality of second data lines corresponding to the second number are newly added in the historical material flow table. And determining material movement data required for filling the second data row in the current material movement record table based on the sequence of the second data row in the plurality of second data rows aiming at each newly added second data row in the historical material flow table, and adding the material movement data into the second data row according to the data items included in the second data row to obtain the current material flow water meter.
S105, acquiring a historical material statistics table, and updating the historical material statistics table according to the current material movement record table to obtain a current material day statistics table.
It should be noted that the historical material statistics table refers to a table for daily material update statistics before the material movement operation is performed. The current material statistics table refers to a table for daily material update statistics after the material movement operation is performed.
For the step S105, in the specific implementation, a historical material statistics table is obtained, and the historical material statistics table is updated according to the current material movement record table, so as to obtain a current material daily statistics table.
Specifically, for the step S105, the updating the historical material statistics table according to the current material movement record table to obtain a current material day statistics table includes:
Step 1051, determining at least one inventory change date related to the current inventory change information and an inventory change day corresponding to the at least one inventory change date according to the inventory change time recorded by each first data line in the current material movement record table.
The stock change date refers to the date when the material moving operation was performed. The number of days of stock change refers to the number of days of material movement operations involved in the current material movement record table.
For the above step 1051, in implementation, at least one inventory change date related to the plurality of pieces of current inventory change information and an inventory change day corresponding to the at least one inventory change date are determined according to the inventory change time recorded by each first data line in the current material movement record table.
Step 1052, adding a third data row corresponding to the third number in the historical material statistics table according to the third number corresponding to the inventory change days, and adding the at least one inventory change date and the latest inventory update time in the inventory update time corresponding to each inventory change date to the third data row according to the time sequence.
The third number refers to the number of days of the line material moving operation. The third data line refers to a data line corresponding to a third number added in the historical materials statistics table.
For the above step 1052, in implementation, according to the third number corresponding to the number of inventory change days, a third data row corresponding to the third number is newly added to the historical material statistics table, and at least one inventory change date and the latest inventory update time in the inventory update time corresponding to each inventory change date are added to the third data row according to the chronological order.
Step 1053, for each inventory change date, determining at least one target first data row corresponding to the inventory change date in the current material movement record table, determining the total number of outgoing warehouse, total warehouse-in data and the balance number of the current day corresponding to the inventory change date according to the inventory change type, the inventory change number and the pre-update number data recorded in the at least one target first data row, and adding the total number of outgoing warehouse, the total warehouse-in data and the balance number of the current day to a third data row corresponding to the inventory change date.
And 1054, adding the material name data and the stock location data recorded in at least one target first data row to a third data row corresponding to the stock change date to obtain the current material daily statistics table.
For the above steps 1053 and 1054, in implementation, for each inventory change date, at least one target first data row corresponding to the inventory change date is determined in the current material movement record table, and according to the inventory change type, the inventory change number and the pre-update quantity data recorded in the at least one target first data row, the total outgoing, total incoming and current inventory balance numbers corresponding to the inventory change date are determined, and the total outgoing, total incoming and current inventory balance numbers are added to the third data row corresponding to the inventory change date. Specifically, at least one target first data row corresponding to the inventory change date is determined in the current material movement record table, the data values corresponding to the data items with inventory change types being in warehouse-out are summed to obtain the total quantity in warehouse-out, and the data values corresponding to the data items with inventory change types being in warehouse-in are summed to obtain the total data quantity in warehouse-in. And then subtracting the total quantity of the warehouse-out products from the quantity data before updating, and adding the total quantity of the warehouse-in products to obtain the balance quantity of the inventory on the same day. And then, adding the material name data and the stock location data recorded in at least one target first data row to a third data row corresponding to the stock change date, thereby obtaining the current material day statistical table.
According to the embodiment provided by the application, after the current material day statistics table and the current material flow water meter are generated, all the certificate records of the day can be directly searched according to the date field, and the records are ordered according to the creation time of the certificates, and the inventory balance field of the last certificate of the day can be obtained, so that the history inventory of a certain day in the past can be obtained.
As an optional implementation manner, the method for updating inventory data provided by the embodiment of the application further includes:
A: and determining at least one material counting month related to the current material daily statistics table by utilizing each stock change date recorded in the current material daily statistics table.
The material statistics month refers to each month involved in the current material daily statistics table and subjected to logistics moving operation.
For the step A, when in implementation, at least one material statistics month related to the current material statistics table is determined by utilizing each inventory change date recorded in the current material statistics table.
B: for each material counting month, determining a target third data row with the latest inventory change time and a last third data row positioned before the target third data row in a third data row corresponding to the material counting month in the current material daily statistics table;
C: and determining a first inventory data amount to be compared corresponding to the inventory change date to which the target third data line belongs according to the current inventory balance number in the last third data line and the total ex-warehouse number and the total warehouse-in number in the target third data line.
D: and if the first inventory data quantity to be compared is different from the current-day inventory balance data quantity recorded in the target third data line, determining the inventory change date corresponding to the third data line as a data update abnormal date.
For the steps B to D, in the implementation, for each material statistics month, determining a target third data row with the latest inventory change time and a last third data row located before the target third data row in a third data row corresponding to the material statistics month in the current material daily statistics table. And determining a first inventory data quantity to be compared corresponding to the inventory change date to which the target third data row belongs according to the current inventory balance quantity in the last third data row and the total quantity of the outgoing and the total quantity of the incoming in the target third data row. Specifically, the first inventory data amount to be compared can be obtained by subtracting the total number of outgoing inventory in the target third data line from the current inventory balance in the last third data line and adding the total number of incoming inventory in the target third data line. And comparing the calculated first inventory data quantity to be compared with the current inventory balance data quantity actually recorded in the target third data line, and if the first inventory data quantity to be compared is different from the current inventory balance data quantity recorded in the target third data line, determining the inventory change date corresponding to the third data line as a data update abnormal date.
E: determining a data row to be checked in the current material flow water meter according to the data updating abnormal date, and sequencing the data row to be checked in time sequence according to the inventory updating time recorded in each data row to be checked in the data row to be checked, so as to obtain the material flow water meter to be checked.
F: for each data line to be checked, determining a second inventory data quantity to be compared corresponding to the data line to be checked according to the quantity data before updating and the inventory change quantity in the data line to be checked.
G: and if the second inventory data quantity to be compared is different from the pre-update quantity data recorded in the next abnormal data row positioned behind the data row to be checked in the material flow table to be checked, determining that the data row to be checked is determined to be the abnormal data row.
And E, aiming at the step E-step G, determining a data line to be checked in the current material flow water meter according to the data updating abnormal date in the concrete implementation, and sequencing the data lines to be checked in time sequence according to the inventory updating time recorded in each data line to be checked in the data lines to be checked to obtain the material flow water meter to be checked. For each data line to be checked in the material flow water meter to be checked, determining a second inventory data amount to be compared corresponding to the data line to be checked according to the quantity data before updating and the inventory change quantity in the data line to be checked. Specifically, the second inventory data amount to be compared may be calculated by: second stock data amount to be compared = pre-update number + stock change number (warehouse in = 1, warehouse out = -1). And comparing the calculated second inventory data quantity to be compared with the pre-update quantity data actually recorded in the next abnormal data row positioned behind the data row to be checked in the material flow table to be checked, and if the second inventory data quantity to be compared is different from the pre-update quantity data actually recorded, determining the data row to be checked as the abnormal data row.
In this way, at the end of each month for carrying out logistics operation, whether the data update of each month is correct or not can be confirmed through the data recorded in the current material daily statistics table, if not, the date of the inventory update abnormality can be positioned, and the process data corresponding to the date of the inventory update abnormality is checked, so that the incorrect data updated in the material flow table can be found.
As an optional implementation manner, the method for updating inventory data provided by the embodiment of the application further includes:
(1): and determining a target date range in response to the selection operation of the user on the date range to be counted.
(2): And determining a third data row to be counted corresponding to the target date range in the current material daily statistics table.
The target date range refers to a date range in which the user wants to make statistics. For example, the target date may range from 2022, 10, month, 05, to 2022, 10, month, 25, and the application is not particularly limited.
For the above steps (1) and (2), in a specific implementation, the target date range is determined in response to a user selection operation of the date range to be counted. And determining a third data row to be counted corresponding to the target date range in the current material daily statistics table.
(3): And determining the ex-warehouse quantity and the in-warehouse quantity of each third data row to be counted according to the inventory change type and the inventory change quantity recorded in the third data row to be counted.
(4): And adding the ex-warehouse quantity corresponding to each third data row to be counted to obtain the total ex-warehouse quantity corresponding to the target date range, and adding the warehouse-in quantity corresponding to each third data row to be counted to obtain the total warehouse-in quantity corresponding to the target date range.
For the steps (3) and (4), in the specific implementation, for each third data row to be counted, determining the ex-warehouse number and the in-warehouse number of the third data row to be counted according to the inventory change type and the inventory change number recorded in the third data row to be counted. Specifically, when the inventory update type is ex-warehouse, the inventory change number is the ex-warehouse number, and the warehouse-in number is 0; when the inventory update type is warehouse entry, the inventory change number is warehouse entry number, and the warehouse exit number is 0. And adding the ex-warehouse quantity corresponding to each third data row to be counted to obtain the total ex-warehouse quantity corresponding to the target date range, and adding the warehouse-in quantity corresponding to each third data row to be counted to obtain the total warehouse-in quantity corresponding to the target date range.
(5): And determining a first third data row to be counted with the earliest inventory updating time and a second third data row to be counted with the latest inventory updating time from the third data rows to be counted.
(6): And determining the current day inventory balance quantity recorded in the first third data row to be counted as the initial inventory quantity corresponding to the target date range, and determining the current day inventory balance quantity recorded in the second third data row to be counted as the final inventory quantity corresponding to the target date range.
For the steps (5) and (6), in the implementation, determining a first third data row to be counted with the earliest inventory update time and a second third data row to be counted with the latest inventory update time from the third data rows to be counted. And determining the quantity of the current-day inventory balance recorded in the first data line to be counted as the initial inventory quantity of the period corresponding to the target date range, and determining the quantity of the current-day inventory balance recorded in the second data line to be counted as the final inventory quantity of the period corresponding to the target date range.
Therefore, after the user determines the target date range to be counted, the total quantity of ex-warehouse, total quantity of warehouse-in, initial stock quantity of futures and final stock quantity of futures in the target date range can be counted according to the data in the target date range recorded in the current material daily statistics table, and the data is summarized from different dates, so that corresponding inquiry and analysis of inventory business are realized.
According to the method for updating the stock data, in each business of the in-out bill, the material movement record table, the stock balance table, the material flow water meter and the material daily statistics table are synchronously generated according to the current stock change information, the quantity before updating is recorded in each table, the quantity of the in-out bill, the quantity of the out-of-stock bill and the stock balance can be updated in real time, and the stock data can be updated, and meanwhile, statistics of income, emission and stock related to materials can be rapidly provided. And the data report can be verified at the end of the month, a real-time verification mechanism for the data report can be provided while the data report is updated rapidly, and the consistency and the correctness of the data are ensured.
Referring to fig. 2 and 3, fig. 2 is a schematic diagram of a device for updating inventory data according to an embodiment of the application, and fig. 3 is a schematic diagram of a device for updating inventory data according to an embodiment of the application. As shown in fig. 2, the updating apparatus 200 includes:
An inventory change information determining module 201, configured to determine a plurality of pieces of current inventory change information in response to an input operation of the inventory change information by a user; the current inventory change information comprises a material name, an inventory location, an inventory change type, an inventory change quantity and an inventory change time, wherein the inventory change type comprises ex-warehouse and in-warehouse;
the mobile record table generating module 202 is configured to obtain a template to be filled and current inventory data corresponding to a material mobile record table, and fill the template to be filled with the current inventory data and the plurality of pieces of current inventory change information to obtain a current material mobile record table;
an inventory balance table generating module 203, configured to generate a current inventory balance table according to the inventory change type and the inventory change number recorded in the current inventory movement record table;
The material flow list generating module 204 is configured to obtain a historical material flow list, update data in the historical material flow list according to the current material movement record list, and generate a current material flow list;
And the material day statistics table generating module 205 is configured to obtain a historical material statistics table, update the historical material statistics table according to the current material movement record table, and obtain a current material day statistics table.
Further, when the mobile record table generating module 202 is configured to populate the template to be filled with the current inventory data and the plurality of pieces of current inventory change information to obtain a current material mobile record table, the mobile record table generating module 202 is further configured to:
Determining a first quantity of the pieces of current inventory change information, and creating a plurality of first data rows corresponding to the first quantity in the template to be filled;
Sequencing the plurality of pieces of current inventory change information in time sequence by utilizing the inventory change time in each piece of current inventory change information in the plurality of pieces of current inventory change information to obtain an information sequence table;
determining data to be filled for filling the template from the current inventory change information by utilizing the data category of each item to be filled in the template to be filled aiming at each piece of current inventory change information;
Determining the order of the current stock change information in the information sequence table, and determining a target data row to which the current stock change information belongs from a plurality of first data rows according to the order;
Filling each item to be filled in the target data row in the template to be filled with the data to be filled, obtaining a filled template to be filled, and determining the filled template to be filled as the current material movement record table;
for a first one of a plurality of first data rows in the current material movement record table, adding the current inventory data to a pre-update quantity data item in the first one of the first data rows;
For each other data row of the plurality of first data rows in the current material movement record table except for the first data row, determining pre-update quantity data in the other data row by utilizing pre-update quantity data, inventory change type data and inventory change quantity data in a last data row positioned before the other data row, and adding the pre-update quantity data in the other data row to pre-update quantity data items in the other data row.
Further, when the inventory balance table generating module 203 is configured to generate a current inventory balance table according to the inventory change type and the inventory change number recorded in the current inventory movement record table, the inventory balance table generating module 203 is further configured to:
Acquiring inventory change type data, inventory change quantity data and pre-update quantity data in the last first data row in a plurality of first data rows in the current material movement record table;
determining current material inventory data by utilizing the inventory change type data, the inventory change quantity data and the pre-update quantity data in the last first data row;
And adding the current material inventory data, the material name data in the last first data row and the inventory location data in the last first data row into a balance table blank template to determine the current material inventory balance table.
Further, when the material flow table generating module 204 is configured to obtain a historical material flow water meter and update data in the historical material flow water meter according to the current material movement record table to generate a current material flow water meter, the material flow table generating module 204 is further configured to:
According to the second number of the data lines included in the current material movement record table, a plurality of second data lines corresponding to the second number are newly added in the historical material flow table;
And determining material movement data required for filling the second data row in the current material movement record table based on the sequence of the second data row in a plurality of second data rows for each second data row, and adding the material movement data into the second data row according to the data items included in the second data row to obtain the current material flow water meter.
Further, when the material daily statistics table generating module 205 is configured to update the historical material statistics table according to the current material movement record table to obtain a current material daily statistics table, the material daily statistics table generating module 205 is further configured to:
determining at least one inventory change date related to the plurality of pieces of current inventory change information and inventory change days corresponding to the at least one inventory change date according to the inventory change time recorded by each first data line in the current material movement record table;
According to the third number corresponding to the inventory change days, a third data row corresponding to the third number is newly added in the historical material statistics table, and the at least one inventory change date and the latest inventory update time in the inventory update time corresponding to each inventory change date are added into the third data row according to time sequence;
For each stock change date, determining at least one target first data row corresponding to the stock change date in the current material movement record table, determining the total ex-warehouse quantity, the total warehouse-in data and the current stock balance quantity corresponding to the stock change date according to the stock change type, the stock change quantity and the pre-update quantity data recorded in the at least one target first data row, and adding the total ex-warehouse quantity, the total warehouse-in quantity and the current stock balance quantity to a third data row corresponding to the stock change date;
and adding the material name data and the stock location data recorded in at least one target first data row to a third data row corresponding to the stock change date to obtain the current material day statistical table.
Further, as shown in fig. 3, the updating apparatus 200 further includes an abnormal data determining module 206, where the abnormal data determining module 206 is configured to:
Determining at least one material statistics month related to the current material day statistics table by utilizing each inventory change date recorded in the current material day statistics table;
For each material counting month, determining a target third data row with the latest inventory change time and a last third data row positioned before the target third data row in a third data row corresponding to the material counting month in the current material daily statistics table;
determining a first inventory data amount to be compared corresponding to an inventory change date to which a target third data line belongs according to the current inventory balance number in the last third data line and the total ex-warehouse number and the total warehouse-in number in the target third data line;
If the first inventory data quantity to be compared is different from the current-day inventory balance data quantity recorded in the target third data line, determining an inventory change date corresponding to the third data line as a data update abnormal date;
determining a data row to be checked in the current material flow water meter according to the data updating abnormal date, and sequencing the data row to be checked in time sequence according to the inventory updating time recorded in each data row to be checked in the data row to be checked to obtain the material flow water meter to be checked;
for each data line to be checked, determining a second inventory data amount to be compared corresponding to the data line to be checked according to the quantity data before updating and the inventory change quantity in the data line to be checked;
And if the second inventory data quantity to be compared is different from the pre-update quantity data recorded in the next abnormal data row positioned behind the data row to be checked in the material flow table to be checked, determining that the data row to be checked is determined to be the abnormal data row.
Further, as shown in fig. 3, the updating apparatus 200 further includes a data statistics module 207, where the data statistics module 207 is configured to:
responding to the selection operation of a user on the date range to be counted, and determining a target date range;
Determining a third data row to be counted corresponding to the target date range in the current material day counting table;
for each third data line to be counted, determining the ex-warehouse number and the in-warehouse number of the third data line to be counted according to the inventory change type and the inventory change number recorded in the third data line to be counted;
adding the ex-warehouse quantity corresponding to each third data row to be counted to obtain the total ex-warehouse quantity corresponding to the target date range, and adding the warehouse-in quantity corresponding to each third data row to be counted to obtain the total warehouse-in quantity corresponding to the target date range;
determining a first third data row to be counted with the earliest inventory updating time and a second third data row to be counted with the latest inventory updating time from the third data rows to be counted;
And determining the current day inventory balance quantity recorded in the first third data row to be counted as the initial inventory quantity corresponding to the target date range, and determining the current day inventory balance quantity recorded in the second third data row to be counted as the final inventory quantity corresponding to the target date range.
Referring to fig. 4, fig. 4 is a schematic structural diagram of an electronic device according to an embodiment of the application. As shown in fig. 4, the electronic device 400 includes a processor 410, a memory 420, and a bus 430.
The memory 420 stores machine-readable instructions executable by the processor 410, when the electronic device 400 is running, the processor 410 communicates with the memory 420 through the bus 430, and when the machine-readable instructions are executed by the processor 410, the steps of the method for updating inventory data in the method embodiment shown in fig. 1 can be executed, and the specific implementation is referred to the method embodiment and will not be described herein.
The embodiment of the present application further provides a computer readable storage medium, where a computer program is stored, and when the computer program is executed by a processor, the steps of the method for updating inventory data in the method embodiment shown in fig. 1 may be executed, and a specific implementation manner may refer to the method embodiment and will not be described herein.
It will be clear to those skilled in the art that, for convenience and brevity of description, specific working procedures of the above-described systems, apparatuses and units may refer to corresponding procedures in the foregoing method embodiments, and are not repeated herein.
In the several embodiments provided by the present application, it should be understood that the disclosed systems, devices, and methods may be implemented in other manners. The above-described apparatus embodiments are merely illustrative, for example, the division of the units is merely a logical function division, and there may be other manners of division in actual implementation, and for example, multiple units or components may be combined or integrated into another system, or some features may be omitted, or not performed. Alternatively, the coupling or direct coupling or communication connection shown or discussed with each other may be through some communication interface, device or unit indirect coupling or communication connection, which may be in electrical, mechanical or other form.
The units described as separate units may or may not be physically separate, and units shown as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution of this embodiment.
In addition, each functional unit in the embodiments of the present application may be integrated in one processing unit, or each unit may exist alone physically, or two or more units may be integrated in one unit.
The functions, if implemented in the form of software functional units and sold or used as a stand-alone product, may be stored in a non-volatile computer readable storage medium executable by a processor. Based on this understanding, the technical solution of the present application may be embodied essentially or in a part contributing to the prior art or in a part of the technical solution, in the form of a software product stored in a storage medium, comprising several instructions for causing a computer device (which may be a personal computer, a server, a network device, etc.) to perform all or part of the steps of the method according to the embodiments of the present application. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a Read-Only Memory (ROM), a random access Memory (Random Access Memory, RAM), a magnetic disk, or an optical disk, or other various media capable of storing program codes.
It should be noted that: like reference numerals and letters in the following figures denote like items, and thus once an item is defined in one figure, no further definition or explanation of it is required in the following figures, and furthermore, the terms "first," "second," "third," etc. are used merely to distinguish one description from another and are not to be construed as indicating or implying relative importance.
Finally, it should be noted that: the above examples are only specific embodiments of the present application, and are not intended to limit the scope of the present application, but it should be understood by those skilled in the art that the present application is not limited thereto, and that the present application is described in detail with reference to the foregoing examples: any person skilled in the art may modify or easily conceive of the technical solution described in the foregoing embodiments, or perform equivalent substitution of some of the technical features, while remaining within the technical scope of the present disclosure; such modifications, changes or substitutions do not depart from the spirit and scope of the technical solutions of the embodiments of the present application, and are intended to be included in the scope of the present application. Therefore, the protection scope of the application is subject to the protection scope of the claims.
Claims (10)
1. A method of updating inventory data, the method comprising:
Determining a plurality of pieces of current inventory change information in response to an input operation of the inventory change information by a user; the current inventory change information comprises a material name, an inventory location, an inventory change type, an inventory change quantity and an inventory change time, wherein the inventory change type comprises ex-warehouse and in-warehouse;
acquiring a template to be filled and current inventory data corresponding to a material movement record table, and filling the template to be filled by utilizing the current inventory data and the plurality of pieces of current inventory change information to obtain a current material movement record table;
Generating a current material inventory balance table according to the inventory change type and the inventory change number recorded in the current material movement record table;
acquiring a historical material flow water meter, and updating data in the historical material flow water meter according to the current material movement record table to generate a current material flow water meter;
and acquiring a historical material statistics table, and updating the historical material statistics table according to the current material movement record table to obtain a current material daily statistics table.
2. The updating method according to claim 1, wherein the filling the template to be filled with the current inventory data and the pieces of current inventory change information to obtain a current material movement record table comprises:
Determining a first quantity of the pieces of current inventory change information, and creating a plurality of first data rows corresponding to the first quantity in the template to be filled;
Sequencing the plurality of pieces of current inventory change information in time sequence by utilizing the inventory change time in each piece of current inventory change information in the plurality of pieces of current inventory change information to obtain an information sequence table;
determining data to be filled for filling the template from the current inventory change information by utilizing the data category of each item to be filled in the template to be filled aiming at each piece of current inventory change information;
Determining the order of the current stock change information in the information sequence table, and determining a target data row to which the current stock change information belongs from a plurality of first data rows according to the order;
Filling each item to be filled in the target data row in the template to be filled with the data to be filled, obtaining a filled template to be filled, and determining the filled template to be filled as the current material movement record table;
for a first one of a plurality of first data rows in the current material movement record table, adding the current inventory data to a pre-update quantity data item in the first one of the first data rows;
For each other data row of the plurality of first data rows in the current material movement record table except for the first data row, determining pre-update quantity data in the other data row by utilizing pre-update quantity data, inventory change type data and inventory change quantity data in a last data row positioned before the other data row, and adding the pre-update quantity data in the other data row to pre-update quantity data items in the other data row.
3. The updating method according to claim 2, wherein the generating a current stock balance table from the stock change type and the stock change number recorded in the current stock movement record table includes:
Acquiring inventory change type data, inventory change quantity data and pre-update quantity data in the last first data row in a plurality of first data rows in the current material movement record table;
determining current material inventory data by utilizing the inventory change type data, the inventory change quantity data and the pre-update quantity data in the last first data row;
And adding the current material inventory data, the material name data in the last first data row and the inventory location data in the last first data row into a balance table blank template to determine the current material inventory balance table.
4. The method of updating according to claim 1, wherein the obtaining the historical material flow meter, updating the data in the historical material flow meter according to the current material movement record table, and generating the current material flow meter, comprises:
According to the second number of the data lines included in the current material movement record table, a plurality of second data lines corresponding to the second number are newly added in the historical material flow table;
And determining material movement data required for filling the second data row in the current material movement record table based on the sequence of the second data row in a plurality of second data rows for each second data row, and adding the material movement data into the second data row according to the data items included in the second data row to obtain the current material flow water meter.
5. The method for updating according to claim 3, wherein updating the historical material statistics according to the current material movement record table to obtain a current material day statistics comprises:
determining at least one inventory change date related to the plurality of pieces of current inventory change information and inventory change days corresponding to the at least one inventory change date according to the inventory change time recorded by each first data line in the current material movement record table;
According to the third number corresponding to the inventory change days, a third data row corresponding to the third number is newly added in the historical material statistics table, and the at least one inventory change date and the latest inventory update time in the inventory update time corresponding to each inventory change date are added into the third data row according to time sequence;
For each stock change date, determining at least one target first data row corresponding to the stock change date in the current material movement record table, determining the total ex-warehouse quantity, the total warehouse-in data and the current stock balance quantity corresponding to the stock change date according to the stock change type, the stock change quantity and the pre-update quantity data recorded in the at least one target first data row, and adding the total ex-warehouse quantity, the total warehouse-in quantity and the current stock balance quantity to a third data row corresponding to the stock change date;
and adding the material name data and the stock location data recorded in at least one target first data row to a third data row corresponding to the stock change date to obtain the current material day statistical table.
6. The updating method according to claim 5, characterized in that the updating method further comprises:
Determining at least one material statistics month related to the current material day statistics table by utilizing each inventory change date recorded in the current material day statistics table;
For each material counting month, determining a target third data row with the latest inventory change time and a last third data row positioned before the target third data row in a third data row corresponding to the material counting month in the current material daily statistics table;
determining a first inventory data amount to be compared corresponding to an inventory change date to which a target third data line belongs according to the current inventory balance number in the last third data line and the total ex-warehouse number and the total warehouse-in number in the target third data line;
If the first inventory data quantity to be compared is different from the current-day inventory balance data quantity recorded in the target third data line, determining an inventory change date corresponding to the third data line as a data update abnormal date;
determining a data row to be checked in the current material flow water meter according to the data updating abnormal date, and sequencing the data row to be checked in time sequence according to the inventory updating time recorded in each data row to be checked in the data row to be checked to obtain the material flow water meter to be checked;
for each data line to be checked, determining a second inventory data amount to be compared corresponding to the data line to be checked according to the quantity data before updating and the inventory change quantity in the data line to be checked;
And if the second inventory data quantity to be compared is different from the pre-update quantity data recorded in the next abnormal data row positioned behind the data row to be checked in the material flow table to be checked, determining that the data row to be checked is determined to be the abnormal data row.
7. The updating method according to claim 5, characterized in that the updating method further comprises:
responding to the selection operation of a user on the date range to be counted, and determining a target date range;
Determining a third data row to be counted corresponding to the target date range in the current material day counting table;
for each third data line to be counted, determining the ex-warehouse number and the in-warehouse number of the third data line to be counted according to the inventory change type and the inventory change number recorded in the third data line to be counted;
adding the ex-warehouse quantity corresponding to each third data row to be counted to obtain the total ex-warehouse quantity corresponding to the target date range, and adding the warehouse-in quantity corresponding to each third data row to be counted to obtain the total warehouse-in quantity corresponding to the target date range;
determining a first third data row to be counted with the earliest inventory updating time and a second third data row to be counted with the latest inventory updating time from the third data rows to be counted;
And determining the current day inventory balance quantity recorded in the first third data row to be counted as the initial inventory quantity corresponding to the target date range, and determining the current day inventory balance quantity recorded in the second third data row to be counted as the final inventory quantity corresponding to the target date range.
8. An updating apparatus of stock data, characterized in that the updating apparatus comprises:
The inventory change information determining module is used for determining a plurality of pieces of current inventory change information in response to the input operation of the user on the inventory change information; the current inventory change information comprises a material name, an inventory location, an inventory change type, an inventory change quantity and an inventory change time, wherein the inventory change type comprises ex-warehouse and in-warehouse;
The mobile record table generation module is used for acquiring a template to be filled and current inventory data corresponding to the material mobile record table, and filling the template to be filled by utilizing the current inventory data and the plurality of pieces of current inventory change information to obtain a current material mobile record table;
The inventory balance table generation module is used for generating a current material inventory balance table according to the inventory change type and the inventory change quantity recorded in the current material movement record table;
The material flow water meter generating module is used for acquiring a historical material flow water meter, updating data in the historical material flow water meter according to the current material movement record table and generating a current material flow water meter;
And the material daily statistics table generation module is used for acquiring a historical material statistics table, and updating the historical material statistics table according to the current material movement record table to obtain a current material daily statistics table.
9. An electronic device, comprising: a processor, a memory and a bus, said memory storing machine readable instructions executable by said processor, said processor and said memory communicating via said bus when the electronic device is running, said machine readable instructions when executed by said processor performing the steps of the method of updating inventory data according to any one of claims 1 to 7.
10. A computer readable storage medium, characterized in that the computer readable storage medium has stored thereon a computer program which, when executed by a processor, performs the steps of the method of updating inventory data according to any of claims 1 to 7.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202211428097.7A CN118096011A (en) | 2022-11-15 | 2022-11-15 | Inventory data updating method, updating device, equipment and medium |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202211428097.7A CN118096011A (en) | 2022-11-15 | 2022-11-15 | Inventory data updating method, updating device, equipment and medium |
Publications (1)
Publication Number | Publication Date |
---|---|
CN118096011A true CN118096011A (en) | 2024-05-28 |
Family
ID=91162162
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN202211428097.7A Pending CN118096011A (en) | 2022-11-15 | 2022-11-15 | Inventory data updating method, updating device, equipment and medium |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN118096011A (en) |
-
2022
- 2022-11-15 CN CN202211428097.7A patent/CN118096011A/en active Pending
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN112100219B (en) | Report generation method, device, equipment and medium based on database query processing | |
CN107656955B (en) | Repayment data batch reporting method and device | |
CN115760258A (en) | Intelligent bid document generation method, system, computer device and storage medium | |
CN111178830B (en) | Cost accounting method, cost accounting device, computer equipment and storage medium | |
CN109544014B (en) | Anti-fraud method and device based on historical data playback | |
CN102496126A (en) | Custody asset transaction data monitoring equipment | |
CN111881252A (en) | Work report processing method and device, computer equipment and storage medium | |
CN114840527A (en) | Data processing method, device and computer readable storage medium | |
CN113420057A (en) | Account checking data processing method and related device | |
CN113360548A (en) | Data processing method, device, equipment and medium based on data asset analysis | |
CN117611371A (en) | Commission returning method, apparatus, computer-readable storage medium, and electronic device | |
CN111831817A (en) | Questionnaire generation and analysis method and device, computer equipment and readable storage medium | |
CN118096011A (en) | Inventory data updating method, updating device, equipment and medium | |
CN108429632B (en) | Service monitoring method and device | |
CN110275798A (en) | Block chain data processing method, device, server and storage medium | |
CN112800127B (en) | Data mining analysis method and device based on transaction bill | |
CN109324963A (en) | The method and terminal device of automatic test profitable result | |
CN110956552A (en) | Insurance problem processing method, device, equipment and storage medium | |
JP5252012B2 (en) | Data aggregation device and data aggregation program | |
CN117520313B (en) | Data backtracking method and device based on multidimensional associated data warehouse slice table | |
JP5252009B2 (en) | Data aggregation device and data aggregation program | |
CN111680111B (en) | Billing method and device, computer equipment and computer readable storage medium | |
CN117952620B (en) | Commission settlement method and system for restoring online rate of statement based on data processing | |
CN117332212B (en) | Intelligent risk exploration method and system based on chaotic engineering fault experiment | |
JP5252008B2 (en) | Data aggregation device and data aggregation program |
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 |