Data processing method and device, equipment and storage medium

Abstract

The application discloses a data processing method and device, equipment and a storage medium, and belongs to the technical field of data processing. The method comprises the following steps: a processing device acquires business data and financial data; a first account balance corresponding to any subject is acquired according to the financial data, and a first inventory balance corresponding to any subject is acquired according to the business data; in the case where the first account balance and the first inventory balance are inconsistent, change records of each material corresponding to any subject are acquired; and based on the change records of each material, a business voucher with an abnormality is determined to exist. The method realizes the consistency check of the business data and the financial data, and in the case where the business data and the financial data are inconsistent, the business voucher with the abnormality is determined to exist through the change records, so that at least one of the business data and the financial data can be updated correspondingly, and the accuracy of data processing is improved.

Description

Technical Field

[0001] This application relates to the field of data processing technology, and in particular to a data processing method, apparatus, device, and storage medium. Background Technology

[0002] With the development of data processing technology, the integrated business and financial operation model has gradually become the mainstream in the financial management industry. This model refers to the automatic generation of business and financial data based on the business vouchers involved in a transaction, thus achieving the integration of business and financial data. Summary of the Invention

[0003] This application provides a data processing method, apparatus, device, and storage medium, which can be used to improve the accuracy of data processing under an integrated business and financial operation model. The technical solution is as follows:

[0004] On the one hand, a data processing method is provided, the method comprising:

[0005] The processing equipment acquires business data and financial data. The business data includes the inventory balances corresponding to multiple materials, and the financial data includes the account balances corresponding to multiple accounts, with each account corresponding to at least one material.

[0006] For any one of the multiple accounts, the processing device obtains the first account balance corresponding to the account based on the financial data, and obtains the first inventory balance corresponding to the account based on the business data. The first inventory balance is the sum of the inventory balances of each material corresponding to the account.

[0007] If the first account balance is inconsistent with the first inventory balance, the processing device obtains the change records of each material corresponding to any one of the accounts. The change records include at least one set of change information. Each set of change information includes the change amount, change coefficient and the balance before the change. One set of change information corresponds to one business voucher.

[0008] The processing device determines abnormal business vouchers based on the change records of each material, and the abnormal business vouchers are used to update at least one of the business data and the financial data.

[0009] On the other hand, a data processing apparatus is provided, which is applied to a processing device, the apparatus comprising:

[0010] The first acquisition module is used to acquire business data and financial data. The business data includes the inventory balances corresponding to multiple materials, and the financial data includes the account balances corresponding to multiple accounts, with each account corresponding to at least one material.

[0011] The second acquisition module is used to, for any one of the plurality of accounts, obtain the first account balance corresponding to the first account based on the financial data, and obtain the first inventory balance corresponding to the first account based on the business data, wherein the first inventory balance is the sum of the inventory balances of each material corresponding to the first account;

[0012] The third acquisition module is used to acquire change records of each material corresponding to any one of the accounts when the first account balance is inconsistent with the first inventory balance. The change record includes at least one set of change information. Each set of change information includes the change amount, change coefficient and balance before change. One set of change information corresponds to one business voucher.

[0013] The determination module is used to determine abnormal business vouchers based on the change records of each material, and the abnormal business vouchers are used to update at least one of the business data and the financial data.

[0014] On the other hand, a computer device is also provided, the computer device including a processor and a memory, the memory storing at least one computer program, the at least one computer program being loaded and executed by the processor to enable the computer device to implement the data processing method described in any of the above aspects.

[0015] On the other hand, a computer-readable storage medium is also provided, wherein at least one computer program is stored therein, the at least one computer program being loaded and executed by a processor to enable a computer to implement the data processing method described in any of the preceding aspects.

[0016] On the other hand, a computer program product or computer program is also provided, the computer program product or computer program including computer instructions stored in a computer-readable storage medium. A processor of a computer device reads the computer instructions from the computer-readable storage medium, and the processor executes the computer instructions, causing the computer device to perform the data processing method described in any of the preceding aspects.

[0017] The technical solution provided in this application has at least the following beneficial effects:

[0018] The technical solution provided in this application compares the inventory balance of the same account in the business data with the account balance in the financial data to achieve consistency verification between financial data and business data. Furthermore, by obtaining change records, it enables the identification of abnormal business vouchers when financial data and business data are inconsistent. Based on these abnormal business vouchers, at least one of the business data and financial data can be updated accordingly, promoting the integration of business data and financial data and improving the accuracy of data processing. Attached Figure Description

[0019] To more clearly illustrate the technical solutions in the embodiments of this application, the accompanying drawings used in the description of the embodiments will be briefly introduced below. Obviously, the accompanying drawings described below are only some embodiments of this application. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0020] Figure 1 This is a schematic diagram of the implementation environment of a data processing method provided in an embodiment of this application;

[0021] Figure 2 This is a flowchart of a data processing method provided in an embodiment of this application;

[0022] Figure 3 This is a schematic diagram of the structure of a data processing device provided in an embodiment of this application;

[0023] Figure 4 This is a schematic diagram of the structure of a server provided in an embodiment of this application;

[0024] Figure 5 This is a schematic diagram of the structure of a terminal provided in an embodiment of this application. Detailed Implementation

[0025] To make the objectives, technical solutions, and advantages of this application clearer, the embodiments of this application will be described in further detail below with reference to the accompanying drawings.

[0026] It should be noted that the terms "first," "second," etc. (if applicable) used in the specification of this application are used to distinguish similar objects and are not necessarily used to describe a specific order or sequence. It should be understood that such data can be interchanged where appropriate so that the embodiments of this application described herein can be implemented in orders other than those illustrated or described herein. The implementations described in the following exemplary embodiments do not represent all implementations consistent with this application. Rather, they are merely examples of apparatuses and methods consistent with some aspects of this application.

[0027] As enterprise management becomes increasingly complex, the integration of business and financial data has become a necessity for enterprise IT infrastructure development. The disconnect between business and financial data increases the difficulty of data verification and integration, leading to inconsistencies and decision-making errors. Therefore, the integrated business and financial management model is gradually becoming mainstream in the financial management industry. This model refers to the automatic generation of business and financial data based on business vouchers when transactions occur, thereby achieving integrated management of both data.

[0028] This application provides a data processing method that can improve the accuracy of data processing under an integrated business and financial operation model. Please refer to... Figure 1 The diagram illustrates the implementation environment of the data processing method provided in this embodiment. This implementation environment may include: computer device 101.

[0029] In this application embodiment, the product form of the computer device 101 is not limited. Regardless of the product form, the computer device 101 can execute the data processing method provided in this application embodiment. Optionally, the computer device 101 can be a terminal or a server. The terminal can be any electronic product that can interact with the user through one or more methods such as a keyboard, touchpad, touch screen, remote control, voice interaction, or handwriting device, such as PC (Personal Computer), mobile phone, smartphone, PDA (Personal Digital Assistant), wearable device, PPC (Pocket PC), tablet computer, smart car system, smart TV, smart speaker, etc. The server can be a single server, a server cluster composed of multiple servers, or a cloud computing service center.

[0030] Those skilled in the art should understand that the computer device 101, terminal, and server described above are merely examples. Other existing or future computer devices 101, terminals, or servers that are applicable to this application should also be included within the scope of protection of this application, and are hereby incorporated by reference.

[0031] This application provides a data processing method, taking the execution of the method by a processing device as an example, see [link to example]. Figure 2 , Figure 2 This is a flowchart illustrating a data processing method provided in an embodiment of this application. This method can be applied to... Figure 1 The implementation environment shown, for example, the processing device can be Figure 1 The computer device 101 shown is an example. Figure 2As shown, the data processing method includes, but is not limited to, the following steps 201-204.

[0032] Step 201: The processing equipment acquires business data and financial data. The business data includes the inventory balances corresponding to multiple materials, and the financial data includes the account balances corresponding to multiple accounts. Each account corresponds to at least one material.

[0033] In this embodiment, the processing device acquires business data and financial data by receiving entered business vouchers when a business transaction occurs, and generating corresponding business data and financial data through a business model. Optionally, the business model can be a pre-trained machine model or an imported template, etc. This embodiment does not limit the business model, as long as it can automatically generate the business data and financial data corresponding to the business voucher. The business voucher includes relevant information about the business transaction, such as, but not limited to, the time of the business transaction, the type of business, the amount of the business transaction, etc. Alternatively, the processing device can also acquire business data and financial data by receiving entered business data and financial data when a business transaction occurs.

[0034] The business data refers to the relevant data of materials stored in the warehouse, including the inventory balances corresponding to multiple materials. A material can be a single item or a set of items; for example, a material can be a notebook, or a combination of a notebook and a ballpoint pen. Materials can be flexibly defined according to specific application processes. The inventory balances corresponding to multiple materials represent the value of each material. In addition to using the balance to represent the value of materials, other representation methods such as price can also be used. This application embodiment uses the balance as an example for description. Optionally, the inventory balance can be a single numerical value or the product of quantity and unit price.

[0035] Financial data refers to the material-related data recorded in the financial ledger, including the account balances corresponding to multiple accounts. An account is a category used to classify and account for the specific contents of different materials. In this embodiment, different materials are classified into different accounts, so each account corresponds to at least one material, and the account balance of any account is related to the inventory balance of the materials belonging to that account. The correspondence between accounts and materials can be set based on experience or flexibly adjusted according to the application scenario; this embodiment does not impose any limitations.

[0036] After the processing equipment acquires business data and financial data, it can store the business data and financial data. This application embodiment does not limit the storage format of the business data and financial data; for example, they can be stored in the form of tables. Taking a material inventory value balance sheet as the table storing business data and a financial account balance sheet as the table storing financial data as an example, the financial account balance sheet can be shown in Table 1, and the material inventory value balance sheet can be shown in Table 2.

[0037] When the processing equipment stores a material inventory value balance sheet and a financial account balance sheet, the processing equipment can directly retrieve business data from the material inventory value balance sheet and financial data from the financial account balance sheet when it retrieves business data and financial data again. This application embodiment illustrates the implementation process of retrieving financial data from the financial account balance sheet and business data from the material inventory value balance sheet.

[0038] Referring to Table 1, the financial account balance sheet includes account names and account balances. Account names indicate different accounts, and account balances indicate the account balances of different accounts, meaning multiple accounts correspond to separate account balances. In addition, the financial account balance sheet may also include account codes and statistical time information to improve the completeness of the information.

[0039] Table 1

[0040]

[0041] For example, the account name is "Account 1," the account code is 1401001, and the account balance is 300. The statistical period for the account balance of 300 is August 1, 2023. After obtaining the financial account balance sheet, the processing device can retrieve financial data through keyword search. The keyword can be the account name or account code, etc. For example, by searching for the keyword "Account 1," the device can find the account balance in the same row as the account name "Account 1" in the financial account balance sheet; this is the account balance corresponding to Account 1.

[0042] Referring to Table 2, the material inventory value balance sheet includes material names and inventory balances, i.e., the inventory balances corresponding to multiple materials. In addition, the material inventory value balance sheet also includes information such as account name, inventory quantity, inventory location, and the statistical time of the inventory balance, to improve the completeness of the information. The material inventory value balance sheet allows for the acquisition of the inventory balance of at least one material corresponding to different accounts. For ease of explanation, this embodiment uses business data of multiple materials corresponding to a first account as an example. There can be multiple material inventory value balance sheets, and each material may be recorded on different material inventory balance sheets. This can also be understood as materials corresponding to the same account being recorded in different material inventory value balance sheets. The processing device can obtain business information of multiple materials corresponding to the same account from different material inventory balance sheets to facilitate verification and analysis of an account.

[0043] Table 2

[0044]

[0045] For example, the first item includes three materials: ballpoint pens, notebooks, and fountain pens. The ballpoint pens are stored in the first warehouse, with a quantity of 5 and a balance of 10; the notebooks are stored in the second warehouse, with a quantity of 10 and a balance of 30; and the fountain pens are stored in the first warehouse, with a quantity of 10 and a balance of 260. After obtaining the material inventory value balance sheet, the processing equipment can retrieve business data through keyword queries, where keywords can include material names, etc.

[0046] In summary, the processing device can acquire business data and financial data, and then verify the consistency of the business data and financial data to improve their accuracy. In this embodiment, steps 202-204 illustrate the process of verifying the consistency of business data and financial data.

[0047] Optionally, the triggering conditions for the verification process of steps 202-204 performed by the processing device are not limited in this embodiment. For example, the processing device can perform consistency verification on business data and financial data at regular intervals. This embodiment does not limit the interval time; for example, the interval could be a month, a day, or half a day. Alternatively, the processing device can receive external operation instructions to trigger the consistency verification of business data and financial data. This embodiment does not limit the external operation instructions; for example, the operation instruction could be a user clicking an entity's verification operation button, or a user clicking a soft switch for the verification operation.

[0048] Step 202: For any one of the multiple accounts, the processing device obtains the first account balance corresponding to any one account based on financial data and obtains the first inventory balance corresponding to any one account based on business data. The first inventory balance is the sum of the inventory balances of each material corresponding to any one account.

[0049] When the processing equipment acquires business data and financial data, it can determine the first account balance and the first inventory balance corresponding to any account by extracting information from the business data and financial data.

[0050] For example, taking any subject as the first subject shown in Tables 1 and 2, the processing device obtains the first account balance corresponding to the first subject, i.e., 300, according to the financial account balance sheet. This application embodiment does not limit the type referred to by the first subject. For example, the first subject can be office supplies, then the first account balance of the first subject represents the value recorded by the first subject in the financial data in the financial field, i.e., the value of the first subject in Table 1 at the end of August 1, 2023. The setting of the statistical time can be flexibly adjusted according to specific circumstances. For example, if the statistical time is set to 12:00 noon on the date, then the corresponding first account balance is the value at 12:00 noon on the date. This application embodiment does not limit the precision of the statistical time. For example, the statistical time may include year, month, day, and specific time.

[0051] The processing equipment can obtain the first inventory balance corresponding to the first item based on the material inventory value balance table. The processing equipment needs to query the inventory balance of materials belonging to the first item from the material inventory value balance table; the inventory balance represents the current value of each material belonging to the first item in the business domain. Alternatively, the processing equipment can iterate through all material inventory value balance tables, sequentially determining each material corresponding to the first item, thereby establishing the material set corresponding to the first item.

[0052] As shown in Table 2, the materials corresponding to the first item include ballpoint pens, notebooks and fountain pens. The inventory balance of ballpoint pens is 10, the inventory balance of notebooks is 30 and the inventory balance of fountain pens is 260. The sum of the inventory balances of all materials corresponding to the first item is 10 + 30 + 260 = 300, that is, the first inventory balance is 300.

[0053] By comparing the first account balance and the first inventory balance, the processing device can determine whether the business area and the financial area are consistent in terms of the inventory value balance. If they are consistent, it indicates that there are no data problems. For example, in the embodiments of this application, both the first account balance and the first inventory balance are 300, which means they are consistent. If they are inconsistent, it indicates that there may be problems such as data entry errors or data update errors, requiring further analysis and processing.

[0054] Step 203: If the first account balance is inconsistent with the first inventory balance, the processing device obtains the change records of each material corresponding to any account. The change record includes at least one set of change information. Each set of change information includes the change amount, change coefficient and balance before change. Each set of change information corresponds to a business voucher.

[0055] If the first account balance and the first inventory balance obtained in step 202 are inconsistent, the processing equipment needs to obtain the change records of each material to locate the abnormal data, update the abnormal data, eliminate errors, and improve data accuracy.

[0056] For each data update of each material, there is a set of change information. This set of change information indicates the change amount, change factor, and pre-change balance for that change. The change amount refers to the change in value of the material corresponding to the change. The change factor indicates the relationship between the change in value and the change. The pre-change balance indicates the value of the material before the change occurred. For example, a change amount of 30 indicates that the value of the material affected by the change is 30; a change factor of -1 indicates that the value of the material affected by the change is decreasing; and a pre-change balance of 100 indicates that the value of the material before the change was 100.

[0057] For example, the change factor can be determined through the borrowing and lending status of materials. If a change to a material is recorded as a debit (borrowing), the value of the corresponding material increases; if it is recorded as a credit (loaning), the value of the corresponding material decreases. A set of change information is generated from a business voucher. For example, a business voucher for the issuance of a ballpoint pen is uploaded to the processing device, which can automatically generate a set of change information based on the business voucher.

[0058] For example, in the change record of ballpoint pens on August 5th, the change amount is 30, the change coefficient is -1, and the balance before the change is 70. This means that before the change on August 5th, the value of the ballpoint pens was 70, and after the change on August 5th, the value of the ballpoint pens decreased from 70 to 40. This embodiment of the application does not limit the reason for the change in the value of the materials; for example, it could be that a department requisitioned ballpoint pens or that the ballpoint pens were sold.

[0059] Step 204: The processing equipment determines the abnormal business vouchers based on the change records of each material. The abnormal business vouchers are used to update at least one of the business data and financial data.

[0060] Since the change records for each material document both the pre-change and post-change status, inconsistencies can be identified based on these records. This allows for the identification of one or more sets of abnormal change information, and the determination of one or more corresponding abnormal business vouchers. The processing equipment can determine the abnormality of a set of change information in various ways, such as checking if the change amount is too large or too small, if the change time is reasonable, or if there are any contradictions with other change information.

[0061] In this embodiment, the method for determining whether a set of change information is abnormal is as follows: Calculate the product of the change amount and the change coefficient of the set of change information; then calculate the sum of this product and the balance before the change to obtain the balance after the change; compare the balance after the change with the target balance; if they are inconsistent, the set of change information is considered abnormal. The target balance refers to the balance before the change in the next set of change information following the first set of change information, or the inventory balance of any material. For example, if the balance after the change calculated from this set of change information is 20, then the balance before the change in the next set of change information should be 20. If the balance before the change in the next change record of this set of change information is not 20, it indicates that the set of change information is abnormal.

[0062] This application does not limit the causes of anomalies, such as data input errors, processing equipment update problems, or other abnormal situations. By locating and processing abnormal change records, the accuracy of material inventory value can be improved, and consistency between financial and operational records regarding inventory value can be ensured.

[0063] For example, the change records include at least one set of change information arranged in chronological order of the changes. The process of determining the abnormal business voucher based on the change records of each material includes, for any set of change information in the change records of any material, obtaining the post-change balance corresponding to any set of change information based on the change amount, change coefficient, and pre-change balance in any set of change information. If the post-change balance is inconsistent with the target balance, then the business voucher corresponding to any set of change information is determined to be an abnormal business voucher, and the target balance is the pre-change balance in the next set of change information after any set of change information or the inventory balance of any material.

[0064] The process of arranging at least one set of change information in the change record according to the order of the changes may include the processing device obtaining the change time or the serial number of the business voucher corresponding to any set of change information, and sorting the change information according to the change time or serial number. The change time refers to the time when the change corresponding to each set of change information occurred, and the serial number can be a serial number generated sequentially from the business vouchers, meaning one business voucher corresponds to one set of change information. This application embodiment does not limit the type of business voucher; for example, the business voucher can be an invoice or a receipt.

[0065] After the change log includes at least one set of change information arranged in chronological order, each set of change information can be viewed one by one. The post-change balance for any set of change information can be obtained based on the change amount, change coefficient, and pre-change balance. During the iteration, if the post-change balance for any set of change information is inconsistent with the target balance, then that set of change information is identified as having an anomaly, and the voucher corresponding to the anomaly set of change information is identified as an anomaly business voucher.

[0066] For example, the formula for calculating the balance after the change can be: Change amount * Change coefficient + Balance before change = Balance after change. For instance, if the change amount is 30, the change coefficient is -1, and the balance before change is 70, then the balance after change will be 40.

[0067] Furthermore, the abnormal set of change information can be further analyzed to determine the specific cause of the anomaly and take corresponding measures to address it. For example, the business voucher corresponding to the abnormal set of change information can be identified by the voucher serial number. The contents of the business voucher record can be queried, and the change amount, change coefficient, and pre-change balance corresponding to the business voucher can be re-determined. The abnormal set of change information can then be updated based on the re-determined change amount, change coefficient, and pre-change balance corresponding to the business voucher.

[0068] In one possible implementation, the change coefficient corresponds to the debit / credit status, the change amount corresponds to the amount, and the balance before the change corresponds to the inventory amount before posting. Therefore, any set of change information can include the material name, debit / credit status, update rule, plant information, amount, inventory amount before posting, and voucher serial number. The material name field indicates the name of the material corresponding to any set of change information. Whenever the value of a material changes, the name of that material is recorded. By traversing the change records, it is possible to determine which material has changed.

[0069] The borrowing / credit information indicates the increase or decrease of materials corresponding to any set of change information. "Borrowing" refers to borrowing in, meaning an increase in the material inventory balance; "Credit" refers to lending out, meaning a decrease in the material inventory balance. By analyzing the borrowing / credit information, it's possible to determine whether the value of materials is increasing or decreasing, thus providing a better understanding of inventory dynamics. The update rule indicates the receipt / payment type of materials corresponding to any set of change records. The receipt / payment type refers to the business operation that caused the change, such as purchase receipt, sales shipment, or production consumption. The plant information indicates the field showing the purchasing plant information for the materials corresponding to any change record. Plant information may include the plant's name, location, contact information, etc., and can be used to track the source and procurement channels of materials.

[0070] For example, both business data and financial data are generated from business vouchers uploaded to the processing equipment. The process of generating corresponding financial and inventory data from business vouchers can be as follows: financial accounting vouchers are generated from the original business vouchers, and corresponding balance sheets of financial accounts and material inventory value balance sheets are generated from the financial accounting vouchers. The original business vouchers are the initial records of business transactions, such as purchase orders and sales invoices, recording basic information about the business transaction and serving as the basis for subsequent accounting processing. Financial accounting vouchers are corresponding vouchers prepared by accounting personnel based on the original business vouchers, recording changes in financial accounts and amounts related to the business transaction.

[0071] To analyze each change in inventory balance, i.e., to obtain the change record for each material, this application introduces a material inventory value change log table and a material value consumption update rule table. A material inventory value change log table corresponds to a set of change information in the change records; the material inventory value change log table is a table that records each change in the material inventory value. Whenever the value of a material changes, a corresponding material inventory value change log table is generated, including information such as the change time and change amount. The material value consumption update rule table defines the update rules for material value consumption, including how the consumption of material value is represented in different business scenarios. For example, expenditures correspond to material sales and issuance, and revenue corresponds to purchased materials.

[0072] For example, see Table 3 for a material inventory value change flow table.

[0073] Table 3

[0074]

[0075] The material recorded in the inventory value change log is a ballpoint pen, with the corresponding material code 100001. The financial posting date, i.e., the change date, is July 1, 2022. The factory code is A001. The serial number of the business voucher corresponding to this change is 123456. The amount involved in this change is 30, the debit / credit status is debit, the inventory amount before posting, i.e., the balance before the change, is 10, the consumption indicator is no, that is, this change is not a consumption, and the update rule corresponds to revenue.

[0076] Therefore, the processing equipment can obtain the change records of each material through the material inventory value change log, and then determine the abnormal business vouchers based on the change records of each material, so as to achieve consistency verification of business data and financial data. In the embodiments of this application, in addition to the data processing for consistency verification based on the obtained change records of different materials, different data processing can also be performed based on the change records. Optionally, other data processing scenarios based on change records include, but are not limited to, the following.

[0077] Scenario 1: Determine the revenue or expenditure amount of any material within any given time period by using change records.

[0078] In this scenario, any set of change information also includes the change time and update rules, where the update rules indicate revenue or expenditure. The method also includes: obtaining the change record for any one of multiple materials; and obtaining the revenue or expenditure amount for any material within a given time period based on its change record. The revenue amount is the sum of the change amounts in the change information indicating revenue according to the update rules within the change record of any material for that time period, and the expenditure amount is the sum of the change amounts in the change information indicating expenditure according to the update rules within the change record of any material for that time period.

[0079] For each set of change information acquired, in addition to the change amount, change coefficient, and balance before the change, it also includes the change time and update rule. The change time refers to the specific point in time when the value of the material changed, which can be in the form of a date or timestamp. The update rule indicates whether the change is an income or expenditure type. Thus, the income and expenditure status of any material within a certain period can be determined. After acquiring at least one set of change information for any one of multiple materials within a certain time period, the processing equipment can perform further analysis. It can determine the income type and expenditure type change information for any material within a certain time period. The processing equipment sums the change amounts for each set of change information corresponding to the income type to obtain the total income amount for any material within that period. The processing equipment sums the change amounts for each set of change information corresponding to the expenditure type to obtain the total expenditure amount for any material within that period.

[0080] Scenario 2: Determine the amount of any material incurred within any given time period by using change records.

[0081] In this second scenario, any set of change information also includes the change time. The method also includes obtaining the change record of any material among multiple materials; calculating the amount of change for any material within a certain time period based on the change record of any material, where the amount of change is the sum of the product of the change amount and the change coefficient in the change information of any material within a certain time period in the change record of any material.

[0082] The transaction amount refers to the total amount of all transactions involving a single entity on the debit or credit side within a certain period. The processing equipment multiplies the change amount and change coefficient of each group of all change information for any material within a certain period, and sums the products of each group to obtain the transaction amount for any material during that period.

[0083] Scenario 3: Determine the consumption trend of any material by changing records.

[0084] In this third scenario, any set of change information also includes change time and consumption identifier, with the consumption identifier indicating yes or no. The method further includes: obtaining the change record of any material from a set of multiple materials; obtaining multiple sets of consumption change information with the consumption identifier indicating yes from the change record of any material; and determining the consumption trend of any material based on the change time and change amount in the multiple sets of consumption change information.

[0085] The consumption identifier indicates whether the material corresponding to a certain change has been consumed. The consumption identifier may be a field or a label used to mark the consumption status of the material. Every set of change information contains a consumption identifier. Whenever the value of a material changes, in addition to recording the time of the change, the remaining balance, and other information, it also records whether the material has been consumed.

[0086] After sorting at least one change information for any material according to the change order, the consumption change information is determined. Consumption change information refers to change information where the consumption flag is set to "yes." That is, the material change corresponding to the consumption change information is whether it has been used or consumed. For example, change information where the consumption flag is "no" might be a revenue record.

[0087] Once consumption change information is identified, since this information is ordered by change time or serial number, the consumption trend of any material can be determined based on this information. Consumption trend refers to information such as the rate at which a material is consumed. For example, is the consumption rate stable, or are there sudden increases or decreases? Consumption trend can provide reference information for inventory management, procurement planning, and other purposes.

[0088] For example, if the consumption rate of a certain material suddenly increases recently, it may be necessary to increase the inventory of that material to avoid a shortage. Or, if a certain material has not been consumed for an extended period, it may be necessary to check whether that material needs to continue to be stored.

[0089] Furthermore, any material can be categorized, meaning a material's level can be determined. The level indicates the material's importance, and different monitoring measures are applied to materials of different importance. For example, ABC analysis, also known as Pareto analysis, is a classification method designed based on the Pareto optimality principle. It's a technique for determining inventory levels and is used in materials management, also known as selective inventory control. ABC classification can differentiate and categorize products, reflecting the impact of each product category's value on the total value of inventory, sales, and costs. Based on importance, materials are defined into three levels (A, B, and C). Level A materials are strictly controlled and accurately recorded; Level B materials are slightly less controlled and well-recorded; and Level C materials are simply controlled and minimally recorded.

[0090] In summary, the data processing method provided in this application compares the inventory balance of the same account in the business data with the account balance in the financial data, thereby achieving consistency verification between financial data and business data. Furthermore, by acquiring change records, it enables the identification of abnormal business vouchers when financial data and business data are inconsistent. Based on these abnormal business vouchers, at least one of the business data and financial data can be updated accordingly, promoting the integration of business data and financial data and improving the accuracy of data processing.

[0091] Furthermore, this method includes update rules for any set of change information in any change record. These update rules indicate whether the change is a revenue type or an expenditure type, allowing for the calculation of the total revenue or expenditure for any material over a given period. This enables the assessment of the material's value change during that period based on the total revenue or expenditure. By summing the products of the change amount and the change coefficient over a period, this method determines the amount incurred for any material over that period, thus identifying the material's value change and providing a basis for subsequent inventory adjustments.

[0092] In this method, any set of change information in any change record also includes a consumption identifier. The consumption identifier indicates whether the change of the corresponding material is a consumption, thereby determining the consumption trend of any material over a period of time, and thus enabling the prediction of the consumption of any material at a certain time in the future.

[0093] See Figure 3 , Figure 3This is a schematic diagram of the structure of a data processing device provided in an embodiment of this application, as shown below. Figure 3 As shown, the device is used in a processing apparatus, and the device includes:

[0094] The first acquisition module 301 is used to acquire business data and financial data. The business data includes the inventory balance corresponding to multiple materials, and the financial data includes the account balance corresponding to multiple accounts. Each account corresponds to at least one material.

[0095] The second acquisition module 302 is used to obtain the first account balance corresponding to any one of the multiple accounts based on financial data and the first inventory balance corresponding to any one of the accounts based on business data. The first inventory balance is the sum of the inventory balances of each material corresponding to any one of the multiple accounts.

[0096] The third acquisition module 303 is used to acquire the change records of each material corresponding to any account when the first account balance is inconsistent with the first inventory balance. The change record includes at least one set of change information. Each set of change information includes the change amount, change coefficient and balance before change. One set of change information corresponds to one business voucher.

[0097] The determination module 304 is used to determine the abnormal business vouchers based on the change records of each material. The abnormal business vouchers are used to update at least one of the business data and financial data.

[0098] In one possible implementation, the change record includes at least one set of change information arranged in the order of the changes; the determination module 304 is used to obtain the post-change balance corresponding to any set of change information in the change record of any material among all materials, based on the change amount, change coefficient and pre-change balance in any set of change information; if the post-change balance is inconsistent with the target balance, then the business voucher corresponding to any set of change information is determined to be an abnormal business voucher, and the target balance is the pre-change balance in the next set of change information after any set of change information or the inventory balance of any material.

[0099] In one possible implementation, module 304 is used to obtain the product of the change amount and the change coefficient; and to determine the sum of the product and the balance before the change as the balance after the change.

[0100] In one possible implementation, any set of change information also includes change time and update rules, whereby the update rules indicate revenue or expenditure; the third acquisition module 303 is further configured to acquire change records for any one of the multiple materials; and to acquire the revenue amount or expenditure amount of any material within any time period based on the change record of any material, wherein the revenue amount is the sum of the change amounts in the change information indicating revenue in any time period according to the update rules in the change record of any material, and the expenditure amount is the sum of the change amounts in the change information indicating expenditure in any time period according to the update rules in the change record of any material.

[0101] In one possible implementation, any set of change information also includes the change time; the third acquisition module 303 is also used to acquire the change record of any material among multiple materials; and to calculate the amount of any material in any time period based on the change record of any material, wherein the amount of any material is the sum of the product of the change amount and the change coefficient in the change information of any material in any time period.

[0102] In one possible implementation, any set of change information also includes change time and consumption identifier, with the consumption identifier indicating yes or no; the third acquisition module 303 is further used to acquire the change record of any material among multiple materials; acquire multiple sets of consumption change information in the change record of any material where the consumption identifier indicates yes; the determination module 304 is further used to determine the consumption trend of any material based on the change time and change amount in the multiple sets of consumption change information.

[0103] In summary, the data processing apparatus provided in this application compares the inventory balance of the same account in the business data with the account balance in the financial data, thereby achieving consistency verification between financial data and business data. Furthermore, by acquiring change records, it enables the identification of abnormal business vouchers when financial data and business data are inconsistent. Based on these abnormal business vouchers, at least one of the business data and financial data can be updated accordingly, promoting the integration of business data and financial data and improving the accuracy of data processing.

[0104] Furthermore, any set of change information in any change record within this device includes update rules. These rules indicate whether the change is of revenue type or expenditure type, enabling the calculation of the total revenue or expenditure for any material over a given period. This allows for the assessment of the material's value change during that period based on the total revenue or expenditure. By summing the products of change amounts and change coefficients over a period, the device determines the transaction amount for any material over that period, thus identifying the material's value change and providing a basis for subsequent adjustments to the material's inventory.

[0105] The device also includes a consumption identifier in any set of change information in any change record. The consumption identifier indicates whether the change of the corresponding material is a consumption, thereby determining the consumption trend of any material over a period of time and thus predicting the consumption of any material at a certain time in the future.

[0106] It should be noted that the above Figure 3 The data processing apparatus provided in the embodiments is illustrated only by the division of the above-described functional modules. In actual operation, the functions can be assigned to different functional modules as needed, that is, the internal structure of the device can be divided into different functional modules to complete all or part of the functions described above. Furthermore, the apparatus and method embodiments provided in the above embodiments belong to the same concept, and their specific implementation process can be found in the method embodiments.

[0107] Figure 4 This is a schematic diagram of a server structure provided in an embodiment of this application. The server can vary significantly due to differences in configuration or performance. It may include one or more processors 401 and one or more memories 402. The one or more memories 402 store at least one computer program, which is loaded and executed by the one or more processors 401 to enable the server to implement the data processing methods provided in the various method embodiments described above. Of course, the server may also have wired or wireless network interfaces, a keyboard, and input / output interfaces for input and output. The server may also include other components for implementing device functions, which will not be elaborated upon here.

[0108] Figure 5 This is a schematic diagram of the structure of a terminal provided in an embodiment of this application. The terminal may be, for example, a smartphone, tablet computer, media player, laptop computer, or desktop computer. The terminal may also be referred to as user equipment, portable terminal, laptop terminal, desktop terminal, or other names.

[0109] Typically, a terminal includes a processor 501 and a memory 502.

[0110] Processor 501 may include one or more processing cores, such as a quad-core processor, an octa-core processor, etc. Processor 501 may be implemented using at least one hardware form selected from DSP (Digital Signal Processing), FPGA (Field-Programmable Gate Array), and PLA (Programmable Logic Array). Processor 501 may also include a main processor and a coprocessor. The main processor, also known as a CPU (Central Processing Unit), is used to process data in the wake-up state; the coprocessor is a low-power processor used to process data in the standby state. In some embodiments, processor 501 may integrate a GPU (Graphics Processing Unit), which is responsible for rendering and drawing the content to be displayed on the screen. In some embodiments, processor 501 may also include an AI (Artificial Intelligence) processor, which is used to handle computational operations related to machine learning.

[0111] The memory 502 may include one or more computer-readable storage media, which may be non-transitory. The memory 502 may also include high-speed random access memory and non-volatile memory, such as one or more disk storage devices or flash memory devices. In some embodiments, the non-transitory computer-readable storage media in the memory 502 are used to store at least one instruction, which is executed by the processor 501 to cause the terminal to implement the data processing method provided in the method embodiments of this application.

[0112] In some embodiments, the terminal may also optionally include: a peripheral device interface 503 and at least one peripheral device. The processor 501, memory 502, and peripheral device interface 503 can be connected via a bus or signal line. Each peripheral device can be connected to the peripheral device interface 503 via a bus, signal line, or circuit board. Specifically, the peripheral device includes at least one of: a radio frequency circuit 504, a display screen 505, a camera assembly 506, an audio circuit 507, and a power supply 508.

[0113] Peripheral device interface 503 can be used to connect at least one I / O (Input / Output) related peripheral device to processor 501 and memory 502. In some embodiments, processor 501, memory 502 and peripheral device interface 503 are integrated on the same chip or circuit board; in some other embodiments, any one or two of processor 501, memory 502 and peripheral device interface 503 can be implemented on separate chips or circuit boards, which is not limited in this embodiment.

[0114] The radio frequency (RF) circuit 504 is used to receive and transmit RF (Radio Frequency) signals, also known as electromagnetic signals. The RF circuit 504 communicates with communication networks and other communication devices via electromagnetic signals. The RF circuit 504 converts electrical signals into electromagnetic signals for transmission, or converts received electromagnetic signals back into electrical signals. Optionally, the RF circuit 504 includes: an antenna system, an RF transceiver, one or more amplifiers, a tuner, an oscillator, a digital signal processor, a codec chipset, a user identity module card, etc. The RF circuit 504 can communicate with other terminals through at least one wireless communication protocol. This wireless communication protocol includes, but is not limited to: metropolitan area networks (MANs), various generations of mobile communication networks (2G, 3G, 4G, and 5G), wireless local area networks (WLANs), and / or WiFi (Wireless Fidelity) networks. In some embodiments, the RF circuit 504 may also include circuitry related to NFC (Near Field Communication), which is not limited in this application.

[0115] Display screen 505 is used to display a UI (User Interface). This UI may include graphics, text, icons, video, and any other combination thereof. When display screen 505 is a touch display screen, it also has the ability to collect touch signals on or above its surface. These touch signals can be input as control signals to processor 501 for processing. In this case, display screen 505 can also be used to provide virtual buttons and / or a virtual keyboard, also known as soft buttons and / or a soft keyboard. In some embodiments, there may be one display screen 505, disposed on the front panel of the terminal; in other embodiments, there may be at least two display screens, disposed on different surfaces of the terminal or in a folded design; in still other embodiments, display screen 505 may be a flexible display screen, disposed on a curved or folded surface of the terminal. Furthermore, display screen 505 may be configured as a non-rectangular, irregular shape, i.e., a non-rectangular screen. Display screen 505 may be made of materials such as LCD (Liquid Crystal Display) or OLED (Organic Light-Emitting Diode).

[0116] The camera assembly 506 is used to acquire images or videos. Optionally, the camera assembly 506 includes a front-facing camera and a rear-facing camera. Typically, the front-facing camera is located on the front panel of the terminal, and the rear-facing camera is located on the back of the terminal. In some embodiments, there are at least two rear-facing cameras, which are any one of a main camera, a depth-sensing camera, a wide-angle camera, and a telephoto camera, to achieve background blurring by fusion of the main camera and the depth-sensing camera, panoramic shooting by fusion of the main camera and the wide-angle camera, VR (Virtual Reality) shooting, or other fusion shooting functions. In some embodiments, the camera assembly 506 may also include a flash. The flash can be a single-color temperature flash or a dual-color temperature flash. A dual-color temperature flash refers to a combination of a warm-light flash and a cool-light flash, which can be used for light compensation at different color temperatures.

[0117] The audio circuit 507 may include a microphone and a speaker. The microphone is used to collect sound waves from the user and the environment, converting them into electrical signals that are input to the processor 501 for processing, or to the radio frequency circuit 504 for voice communication. For stereo sound acquisition or noise reduction purposes, multiple microphones may be used, each positioned at a different location on the terminal. The microphone may also be an array microphone or an omnidirectional microphone. The speaker is used to convert electrical signals from the processor 501 or the radio frequency circuit 504 into sound waves. The speaker may be a traditional film speaker or a piezoelectric ceramic speaker. When the speaker is a piezoelectric ceramic speaker, it can convert electrical signals not only into audible sound waves but also into inaudible sound waves for purposes such as distance measurement. In some embodiments, the audio circuit 507 may also include a headphone jack.

[0118] Power supply 508 is used to power the various components in the terminal. Power supply 508 can be AC ​​power, DC power, a disposable battery, or a rechargeable battery. When power supply 508 includes a rechargeable battery, the rechargeable battery can support wired or wireless charging. The rechargeable battery can also be used to support fast charging technology.

[0119] In some embodiments, the terminal further includes one or more sensors 509. The one or more sensors 509 include, but are not limited to: an accelerometer 510, a gyroscope 511, a pressure sensor 512, an optical sensor 513, and a proximity sensor 514.

[0120] Accelerometer 510 can detect the magnitude of acceleration along the three axes of a coordinate system established by the terminal. For example, accelerometer 510 can be used to detect the components of gravitational acceleration along the three axes. Processor 501 can control display screen 505 to display the user interface in either a landscape or portrait view based on the gravitational acceleration signal acquired by accelerometer 510. Accelerometer 510 can also be used for games or for acquiring user motion data.

[0121] The gyroscope sensor 511 can detect the terminal's orientation and rotation angle. The gyroscope sensor 511, in conjunction with the accelerometer sensor 510, can collect the user's 3D movements on the terminal. Based on the data collected by the gyroscope sensor 511, the processor 501 can perform the following functions: motion sensing (e.g., changing the UI based on the user's tilt), image stabilization during shooting, game control, and inertial navigation.

[0122] The pressure sensor 512 can be installed on the side bezel of the terminal and / or on the lower layer of the display screen 505. When the pressure sensor 512 is installed on the side bezel of the terminal, it can detect the user's grip signal on the terminal, and the processor 501 can perform left / right hand recognition or quick operation based on the grip signal collected by the pressure sensor 512. When the pressure sensor 512 is installed on the lower layer of the display screen 505, the processor 501 can control the operable controls on the UI interface based on the user's pressure operation on the display screen 505. The operable controls include at least one of button controls, scroll bar controls, icon controls, and menu controls.

[0123] An optical sensor 513 is used to collect ambient light intensity. In one embodiment, the processor 501 can control the display brightness of the display screen 505 based on the ambient light intensity collected by the optical sensor 513. Specifically, when the ambient light intensity is high, the display brightness of the display screen 505 is increased; when the ambient light intensity is low, the display brightness of the display screen 505 is decreased. In another embodiment, the processor 501 can also dynamically adjust the shooting parameters of the camera assembly 506 based on the ambient light intensity collected by the optical sensor 513.

[0124] The proximity sensor 514, also known as a distance sensor, is typically installed on the front panel of the terminal. The proximity sensor 514 is used to detect the distance between the user and the front of the terminal. In one embodiment, when the proximity sensor 514 detects that the distance between the user and the front of the terminal is gradually decreasing, the processor 501 controls the display screen 505 to switch from a screen-on state to a screen-off state; when the proximity sensor 514 detects that the distance between the user and the front of the terminal is gradually increasing, the processor 501 controls the display screen 505 to switch from a screen-off state to a screen-on state.

[0125] Those skilled in the art will understand that Figure 5 The structure shown does not constitute a limitation on the terminal and may include more or fewer components than shown, or combine certain components, or use different component arrangements.

[0126] In an exemplary embodiment, a computer device is also provided, comprising a processor and a memory storing at least one computer program. The at least one computer program is loaded and executed by one or more processors to enable the computer device to implement any of the data processing methods described above.

[0127] In an exemplary embodiment, a computer-readable storage medium is also provided, which stores at least one computer program that is loaded and executed by a processor of a computer device to enable the computer to implement any of the above-described data processing methods.

[0128] In one possible implementation, the aforementioned computer-readable storage medium may be a read-only memory (ROM), a random access memory (RAM), a compact disc read-only memory (CD-ROM), magnetic tape, floppy disk, and optical data storage device, etc.

[0129] In an exemplary embodiment, a computer program product or computer program is also provided, which includes computer instructions stored in a computer-readable storage medium. A processor of a computer device reads the computer instructions from the computer-readable storage medium and executes the computer instructions, causing the computer device to perform any of the data processing methods described above.

[0130] It should be noted that all information (including but not limited to user device information, user personal information, etc.), data (including but not limited to data used for analysis, stored data, displayed data, etc.), and signals involved in this application have been authorized by the user or fully authorized by all parties, and the collection, use, and processing of related data must comply with the relevant laws, regulations, and standards of the relevant countries and regions. For example, the business data and financial data involved in this application were obtained with full authorization.

[0131] It should be understood that "multiple" as used in this article refers to two or more. "And / or" describes the relationship between related objects, indicating that three relationships can exist. For example, A and / or B can represent: A alone, A and B simultaneously, or B alone. The character " / " generally indicates that the preceding and following related objects have an "or" relationship.

[0132] The above description is merely an exemplary embodiment of this application and is not intended to limit this application. Any modifications, equivalent substitutions, improvements, etc., made within the principles of this application should be included within the protection scope of this application.

Claims

1. A data processing method, characterized by, The method comprises: The processing device acquires business data and financial data, the business data comprising inventory balances of a plurality of materials respectively, and the financial data comprising account balances of a plurality of subjects respectively, one subject corresponding to at least one material; For any subject in the plurality of subjects, the processing device acquires a first account balance corresponding to the subject according to the financial data, and acquires a first inventory balance corresponding to the subject according to the business data, the first inventory balance being a sum of inventory balances of each material corresponding to the subject; In a case where the first account balance is inconsistent with the first inventory balance, the processing device acquires change records of each material corresponding to the subject, the change records comprising at least one set of change information, any set of change information comprising a change amount, a change coefficient, and a pre-change balance, and one set of change information corresponding to one business voucher; The processing device determines an abnormal business voucher based on the change records of each material, the abnormal business voucher being used to update at least one of the business data and the financial data.

2. The method of claim 1, wherein, The at least one set of change information in the change records is arranged in an order of change time; and the processing device determines the abnormal business voucher based on the change records of each material, comprising: For any set of change information in the change records of any material of the each material, the processing device acquires a post-change balance corresponding to the any set of change information according to the change amount, the change coefficient, and the pre-change balance in the any set of change information; If the post-change balance is inconsistent with a target balance, the processing device determines that a business voucher corresponding to the any set of change information is the abnormal business voucher, the target balance being a pre-change balance in a next set of change information after the any set of change information or an inventory balance of the any material.

3. The method of claim 2, wherein, The processing device acquires a post-change balance corresponding to the any set of change information according to the change amount, the change coefficient, and the pre-change balance in the any set of change information, comprising: The processing device acquires a product value of the change amount and the change coefficient; The processing device determines that a sum of the product value and the pre-change balance is the post-change balance.

4. The method according to any of claims 1 to 3, characterized in that, The any set of change information further comprises a change time and an update rule, and the update rule indicates income or expenditure; and the method further comprises: The processing device acquires change records of any material of the plurality of materials; The processing device acquires an income amount or an expenditure amount of the any material in any time period according to the change records of the any material, the income amount being a sum of change amounts in change information indicating income in the any time period in the change records of the any material, and the expenditure amount being a sum of change amounts in change information indicating expenditure in the any time period in the change records of the any material.

5. The method according to any one of claims 1 to 3, characterized in that, The any set of change information further comprises a change time; and the method further comprises: The processing device acquires change records of any material of the plurality of materials; The processing device calculates the occurrence amount of the any material in any time period according to the change record of the any material, and the occurrence amount is the sum of the product of the change amount and the change coefficient in the change information in the change record of the any material in the any time period.

6. The method according to any one of claims 1 to 3, characterized in that, The any group of change information further comprises a change time and a consumption identifier, and the consumption identifier indicates yes or no; the method further comprises: The processing device acquires the change record of the any material in the plurality of materials; The processing device acquires, in the change record of the any material, a plurality of groups of consumption change information whose consumption identifiers indicate yes; The processing device determines the consumption trend of the any material according to the change time and the change amount in the plurality of groups of consumption change information.

7. A data processing apparatus, characterized by, The device is applied to a processing device, and the device comprises: The first acquisition module is configured to acquire business data and financial data, the business data comprising a plurality of material balances corresponding to a plurality of materials respectively, and the financial data comprising a plurality of account balances corresponding to a plurality of subjects respectively, one subject corresponding to at least one material; The second acquisition module is configured to, for any subject in the plurality of subjects, acquire a first account balance corresponding to the any subject according to the financial data, and acquire a first material balance corresponding to the any subject according to the business data, the first material balance being the sum of the material balances of the materials corresponding to the any subject; The third acquisition module is configured to, in the case that the first account balance is inconsistent with the first material balance, acquire change records of the materials corresponding to the any subject, the change records comprising at least one group of change information, any group of change information comprising a change amount, a change coefficient, and a pre-change balance, and one group of change information corresponding to one business voucher; The determination module is configured to determine an abnormal business voucher based on the change records of the materials, the abnormal business voucher being used to update at least one of the business data and the financial data.

8. The apparatus of claim 7, wherein, The at least one group of change information in the change records is arranged in the order of change time; and the determination module is configured to, for any group of change information in the change record of any material in the materials, acquire a post-change balance corresponding to the any group of change information according to the change amount, the change coefficient, and the pre-change balance in the any group of change information; If the post-change balance is inconsistent with a target balance, the business voucher corresponding to the any group of change information is determined as the abnormal business voucher, and the target balance is the pre-change balance in the next group of change information after the any group of change information or the material balance of the any material.

9. A computer device, comprising: The computer device comprises a processor and a memory, and the memory stores at least one computer program, the at least one computer program is loaded and executed by the processor, so that the computer device implements the data processing method according to any one of claims 1-6.

10. A computer-readable storage medium, characterized in that, The computer readable storage medium stores at least one computer program, and the at least one computer program is loaded and executed by the processor, so that the computer implements the data processing method according to any one of claims 1-6.

Images