Report processing method, device, computer equipment and storage medium
By automatically reading the numerical resource traffic identification based on the non-numerical resource-type accounts in the target voucher and filling in the numerical resource traffic items, the problem of low report processing efficiency in the existing technology is solved, and more efficient report processing is achieved.
Patent Information
- Application Number
- CN202210358741.1
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2022-04-07
- Publication Date
- 2025-03-18
- Estimated Expiration
- 2042-04-07
AI Technical Summary
In the prior art, when processing numerical resource reports, it is necessary to manually specify numerical resource traffic items, resulting in low report processing efficiency.
By reading the numerical resource traffic identifier in the account table based on the non-numerical resource account in the target voucher, and automatically filling in the numerical resource traffic item according to its corresponding relationship, adjusting the resource amount in the numerical resource report.
Improve the efficiency of report processing, reduce the steps of manual operation, and reduce the probability of errors occur.
Smart Images

Figure CN114781341B_ABST
Abstract
Description
Technical Field
[0001] The present application relates to the field of computer technology, and in particular to a report processing method, apparatus, computer equipment and storage medium. Background Art
[0002] When entering a voucher, if the voucher is a numerical resource (such as cash) voucher, the corresponding numerical resource flow item can be manually specified. When the numerical resource report (i.e., numerical resource flow table) is opened, the numerical resource report is processed based on the data summary of the resource amount and numerical resource flow item in the voucher. However, the solution of manually specifying the corresponding numerical resource flow item requires the numerical resource flow item to be specified in the voucher every time, resulting in the problem of low report processing efficiency. Summary of the invention
[0003] Based on this, it is necessary to provide a report processing method, apparatus, computer equipment and storage medium that can improve report processing efficiency in response to the above technical problems.
[0004] In a first aspect, the present application provides a method for processing a report. The method comprises:
[0005] Read the numerical resource flow identifier in the account table according to the non-numerical resource account in the target voucher;
[0006] According to the correspondence between the non-numerical resource subjects and the numerical resource flow items, the numerical resource flow identifier is filled into the numerical resource flow item corresponding to the target voucher;
[0007] Reading the resource amount corresponding to the numerical resource flow item in the target voucher;
[0008] Based on the resource amount corresponding to the numerical resource flow item and the numerical resource flow identifier, the corresponding resource amount in the numerical resource report is adjusted.
[0009] In one embodiment, the step of reading the numerical resource flow identifier in the table of accounts according to the non-numerical resource account in the target voucher includes:
[0010] Detecting whether there is a non-numerical resource account in the target voucher;
[0011] If there is a non-numerical resource account in the target voucher, then read the numerical resource flow identifier in the account table according to the non-numerical resource account;
[0012] The method further includes: if the non-numerical resource subject does not exist in the target voucher, then filling in a specified identifier in the numerical resource flow item corresponding to the numerical resource subject in the target voucher.
[0013] In one embodiment, adjusting the corresponding resource amount in the numerical resource report based on the resource amount corresponding to the numerical resource flow item includes:
[0014] Obtaining period information corresponding to the numerical resource flow item in the target voucher;
[0015] According to the period information and the numerical resource flow identifier, searching for the current period resource amount item and the current year resource amount item in the numerical resource report;
[0016] Based on the resource amount corresponding to the resource amount flow item, the resource amount in the current period resource amount item and the resource amount in the current year resource amount item are adjusted.
[0017] In one embodiment, the method further comprises:
[0018] Detecting a modification operation triggered on a target numerical resource flow item in the numerical resource report;
[0019] In response to the modification operation, displaying a modification confirmation window;
[0020] When the first modification control in the modification confirmation window is triggered and the credential pointed to by the target numerical resource flow item is the target credential, the numerical resource flow item in the target credential is modified according to the modification operation.
[0021] In one embodiment, the method further comprises:
[0022] When the second modification control in the modification confirmation window is triggered, the voucher associated with the target numerical resource flow item and the associated account in the account table are searched;
[0023] Modify the numerical resource flow item in the associated voucher;
[0024] The numerical resource flow item corresponding to the associated subject is modified.
[0025] In one embodiment, the method further comprises:
[0026] When receiving a credential saving request, determining a credential type corresponding to the target credential;
[0027] The method of reading the numerical resource flow identifier in the table of accounts according to the non-numerical resource account in the target voucher includes:
[0028] When it is determined that the target voucher is a numerical resource voucher based on the voucher type, the numerical resource flow identifier in the account table is read according to the non-numerical resource account in the target voucher.
[0029] In one of the embodiments, after filling the numerical resource flow identifier into the numerical resource flow item corresponding to the target credential, the method further includes: saving the target credential in a target database.
[0030] In a second aspect, the present application also provides a report processing device. The device comprises:
[0031] The reading module is used to read the numerical resource flow identifier in the account table according to the non-numerical resource account in the target voucher;
[0032] A filling module, used for filling the numerical resource flow identifier into the numerical resource flow item corresponding to the target voucher according to the corresponding relationship between the non-numerical resource category and the numerical resource flow item;
[0033] The reading module is further used to read the resource amount corresponding to the numerical resource flow item in the target voucher;
[0034] The adjustment module is used to adjust the corresponding resource amount in the numerical resource report based on the resource amount corresponding to the numerical resource flow item and the numerical resource flow identifier.
[0035] In one embodiment, the reading module is further used to detect whether there is a non-numerical resource account in the target voucher; if there is a non-numerical resource account in the target voucher, the numerical resource flow identifier in the account table is read according to the non-numerical resource account;
[0036] The filling module is further used to fill in a specified identifier in the numerical resource flow item corresponding to the numerical resource subject in the target voucher if the non-numerical resource subject does not exist in the target voucher.
[0037] In one embodiment, the device further comprises:
[0038] The determination module is further configured to determine the credential type corresponding to the target credential when a save operation of the target credential is detected;
[0039] A saving module is used to save the target credential in a target database.
[0040] In one embodiment, the device further comprises:
[0041] A determination module, configured to determine a credential type corresponding to a target credential when receiving a credential saving request;
[0042] The reading module is further configured to read the numerical resource flow identifier in the account table according to the non-numerical resource account in the target credential when it is determined that the target credential is a numerical resource credential based on the credential type.
[0043] In one embodiment, the adjustment module is used to obtain the period information corresponding to the numerical resource flow item in the target voucher; based on the period information and the numerical resource flow identifier, search for the current period resource amount item and the current year resource amount item in the numerical resource report; based on the resource amount corresponding to the resource amount flow item, adjust the resource amount in the current period resource amount item and the resource amount in the current year resource amount item.
[0044] In one embodiment, the device further comprises:
[0045] A detection module, used to detect a modification operation on a target numerical resource flow item triggered in the numerical resource report;
[0046] The modification module is used to modify the numerical resource flow item in the target certificate according to the modification operation when the first modification control in the modification confirmation window is triggered and the certificate pointed to by the target numerical resource flow item is the target certificate.
[0047] In one embodiment, the device further comprises:
[0048] A search module, used for searching for the voucher associated with the target numerical resource flow item and the associated account in the account table when the second modification control in the modification confirmation window is triggered;
[0049] The modification module is also used to modify the numerical resource flow item in the associated voucher; and to modify the numerical resource flow item corresponding to the associated subject.
[0050] In a third aspect, the present application further provides a computer device. The computer device includes a memory and a processor, the memory stores a computer program, and the processor implements the following steps when executing the computer program:
[0051] Read the numerical resource flow identifier in the account table according to the non-numerical resource account in the target voucher;
[0052] According to the correspondence between the non-numerical resource subjects and the numerical resource flow items, the numerical resource flow identifier is filled into the numerical resource flow item corresponding to the target voucher;
[0053] Reading the resource amount corresponding to the numerical resource flow item in the target voucher;
[0054] Based on the resource amount corresponding to the numerical resource flow item and the numerical resource flow identifier, the corresponding resource amount in the numerical resource report is adjusted.
[0055] In a fourth aspect, the present application further provides a computer-readable storage medium. The computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, the following steps are implemented:
[0056] Read the numerical resource flow identifier in the account table according to the non-numerical resource account in the target voucher;
[0057] According to the correspondence between the non-numerical resource subjects and the numerical resource flow items, the numerical resource flow identifier is filled into the numerical resource flow item corresponding to the target voucher;
[0058] Reading the resource amount corresponding to the numerical resource flow item in the target voucher;
[0059] Based on the resource amount corresponding to the numerical resource flow item and the numerical resource flow identifier, the corresponding resource amount in the numerical resource report is adjusted.
[0060] In a fifth aspect, the present application further provides a computer program product. The computer program product includes a computer program, and when the computer program is executed by a processor, the following steps are implemented:
[0061] Read the numerical resource flow identifier in the account table according to the non-numerical resource account in the target voucher;
[0062] According to the correspondence between the non-numerical resource subjects and the numerical resource flow items, the numerical resource flow identifier is filled into the numerical resource flow item corresponding to the target voucher;
[0063] Reading the resource amount corresponding to the numerical resource flow item in the target voucher;
[0064] Based on the resource amount corresponding to the numerical resource flow item and the numerical resource flow identifier, the corresponding resource amount in the numerical resource report is adjusted.
[0065] The above-mentioned report processing method, device, computer equipment, storage medium and computer program product read the numerical resource flow identifier in the account table according to the non-numerical resource account in the target voucher; fill the numerical resource flow identifier into the numerical resource flow item corresponding to the target voucher according to the corresponding relationship between the non-numerical resource account and the numerical resource flow item; read the resource amount corresponding to the numerical resource flow item in the target voucher; based on the resource amount corresponding to the numerical resource flow item and the numerical resource flow identifier, adjust the corresponding resource amount in the numerical resource report. Since the corresponding relationship between the non-numerical resource account and the numerical resource flow item is preset, when the numerical resource flow identifier corresponding to the non-numerical resource account is obtained, the numerical resource flow identifier can be automatically filled into the numerical resource flow item corresponding to the target voucher, thereby eliminating the need to manually specify the numerical resource flow item, thereby effectively improving the processing efficiency of the report. BRIEF DESCRIPTION OF THE DRAWINGS
[0066] Figure 1 An application environment diagram of a report processing method in an embodiment;
[0067] Figure 2 A flowchart of a method for processing a report in an embodiment;
[0068] Figure 3 A schematic diagram of a credential page in one embodiment;
[0069] Figure 4 is a flow chart of a method for processing a report in another embodiment;
[0070] Figure 5 A flowchart of steps for modifying a credential in one embodiment;
[0071] Figure 6 A schematic diagram of a report page in an embodiment;
[0072] Figure 7 A schematic diagram of a page showing a modification confirmation window on a report page in an embodiment;
[0073] Figure 8 A flowchart of steps for modifying a credential in another embodiment;
[0074] Fig. 9 is a structural block diagram of a report processing device in one embodiment;
[0075] Fig.10 is a structural block diagram of a report processing device in another embodiment;
[0076] Fig.11 FIG. 4 is a diagram showing the internal structure of a computer device in one embodiment. DETAILED DESCRIPTION
[0077] In order to make the purpose, technical solution and advantages of the present application more clearly understood, the present application is further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present application and are not used to limit the present application.
[0078] The embodiments of the present application can be applicable to various systems involving reports, including but not limited to enterprise resource planning (ERP) systems, production management systems, supply chain systems, personnel systems, financial systems, tax systems and audit systems.
[0079] The report processing method provided in the embodiment of the present application can be applied to Figure 1 In the application environment shown. Among them, the terminal 102 communicates with the server 104 through the network. The data storage system can store the data that the server 104 needs to process. The data storage system can be integrated on the server 104, or it can be placed on the cloud or other network servers. Among them, the terminal 102 can be but is not limited to various personal computers, laptops, smart phones, tablets, Internet of Things devices and portable wearable devices. The Internet of Things devices can be smart speakers, smart TVs, smart air conditioners, smart car-mounted devices, etc. Portable wearable devices can be smart watches, smart bracelets, head-mounted devices, etc. The server 104 can be implemented with an independent server or a server cluster consisting of multiple servers.
[0080] In one embodiment, Figure 2 As shown, a report processing method is provided, which can be Figure 1 The terminal 102 or the server 104 executes the method. Figure 1 The terminal 102 in the example is used as an example to illustrate, and the following steps are included:
[0081] S202, reading the numerical resource flow identifier in the account table according to the non-numerical resource account in the target voucher.
[0082] The target voucher may be a written proof containing numerical resources recorded when a business activity occurs or is completed. For example, an accounting voucher is a written proof that records the occurrence or completion of an economic activity. It is the basis for registering accounts and includes accounts (such as cash accounts) and amounts. The account may be an accounting account, which is an item for classifying and calculating the specific contents of accounting elements in economic activities. If the target voucher is a numerical resource voucher, the target voucher may contain numerical resource accounts, or may contain numerical resource accounts and non-numerical accounts.
[0083] The chart of accounts can be used to save the correspondence between accounts and numerical resource flow items, for example, to save the correspondence between non-numerical resource accounts and numerical resource flow items, including debit cash flow items and credit cash flow items, as shown in Table 1. In addition, newly added accounts are also automatically assigned designated debit cash flow items and credit cash flow items.
[0084] Table 1
[0085]
[0086] In one embodiment, before S202, the method may further include: when receiving a credential saving request, the terminal may determine the credential type corresponding to the target credential, and when the target credential is determined to be a numerical resource credential based on the credential type, reading the numerical resource flow identifier in the account table according to the non-numerical resource account in the target credential, so as to execute S206 and S208. Therefore, by distributing the data processing work of the numerical resource report to each credential saving operation, it is avoided that the report needs to be opened each time for data calculation and aggregation.
[0087] Among them, the voucher type includes numerical resource type and non-numerical resource type. For example, the numerical resource type can be a cash type, such as when handling cash accounts, bank accounts, cash and bank equivalent accounts, and digital currency accounts, the corresponding voucher is called a cash voucher; the non-numerical resource type can be a type other than cash and digital currency. Correspondingly, the target voucher includes numerical resource vouchers and non-numerical resource vouchers, such as cash vouchers and non-cash vouchers.
[0088] The cash equivalents mentioned above can refer to investments held by the enterprise with short term, high liquidity, easy conversion to known amount of cash and low risk of value change. Cash account is a property of account, which means that this type of account is used to account for cash inflow / outflow. Bank account is also a property of account, which means that this type of account is used to account for inter-bank fund transactions. Cash and bank equivalent account is also a property of account, which means that this type of account is used to account for cash and bank equivalents. Cash account refers to the general term for accounts with cash account, bank account, cash and bank equivalent account, etc.
[0089] In one embodiment, the terminal displays a credential page, displays the target credential on the credential page, and when a save operation of the target credential is detected, determines the credential type corresponding to the target credential, such as when a credential save request corresponding to the target credential is received, determines the credential type corresponding to the target credential. Figure 3 As shown, Figure 3It is a voucher page, in which a target voucher named accounting voucher is displayed. When an operation of a save button in the voucher page is detected, the voucher type corresponding to the target voucher is determined.
[0090] In one embodiment, when the target voucher is determined to be a numerical resource voucher based on the voucher type, the terminal detects whether there is a non-numerical resource account in the target voucher, and if there is a non-numerical resource account in the target voucher, the numerical resource flow identifier in the account table is read according to the non-numerical resource account. For example, when the target voucher is determined to be a cash voucher based on the voucher type, the terminal detects whether there is a non-cash account in the target voucher, and if there is a non-cash account in the target voucher, the cash flow identifier in the account table is read according to the non-cash account.
[0091] In another embodiment, if there is no non-numerical resource account in the target voucher, the terminal fills in a specified identifier in the numerical resource flow item corresponding to the numerical resource account in the target voucher. For example, if there is no non-cash account in the target voucher, the terminal sets the cash flow item corresponding to the cash account in the target voucher to 0.
[0092] S204, according to the correspondence between the non-numerical resource subjects and the numerical resource flow items, fill the numerical resource flow identifier into the numerical resource flow item corresponding to the target voucher.
[0093] Among them, the numerical resource flow item can be an item used to record the flow of numerical resources in the business activities of the enterprise, such as an item used to record the cash flow flow in the economic activities of the enterprise.
[0094] In one embodiment, the terminal obtains a table of accounts, determines the correspondence between non-numerical resource accounts and numerical resource flow items according to the table of accounts, and then fills the numerical resource flow identifier into the numerical resource flow item corresponding to the target voucher according to the correspondence between the non-numerical resource accounts and the numerical resource flow items. For example, the terminal determines the correspondence between non-cash accounts and cash flow items according to the table of accounts, and can refer to Table 1, and then fills the cash flow identifier into the cash flow item corresponding to the target voucher according to the correspondence between the non-cash accounts and the cash flow items. It should be pointed out that the cash flow item of the target voucher is not shown in the voucher page of Table 1.
[0095] In one embodiment, after the terminal fills the numerical resource flow identifier into the numerical resource flow item corresponding to the target credential, the terminal can also save the target credential in the target database, or save the target credential on the corresponding blockchain. By making the target credential persistent, the target credential can be obtained from the target database or blockchain when it is needed.
[0096] S206, reading the resource amount corresponding to the numerical resource flow item in the target voucher.
[0097] In one embodiment, after the numerical resource flow identifier is filled in with the corresponding numerical resource flow item, the terminal reads the resource amount corresponding to the numerical resource flow item from the target voucher, such as reading the amount corresponding to the cash flow item written in the cash flow identifier in S206 from the target voucher, specifically reading the debit amount or credit amount of the item written in the cash flow identifier.
[0098] S208: Based on the resource amount corresponding to the numerical resource flow item and the numerical resource flow identifier, adjust the corresponding resource amount in the numerical resource report.
[0099] In one embodiment, S208 may specifically include: obtaining the period information corresponding to the numerical resource flow item in the target voucher; searching for the current period resource amount item and the current year resource amount item in the numerical resource report based on the period information and the numerical resource flow identifier; and adjusting the resource amount in the current period resource amount item and the resource amount in the current year resource amount item based on the resource amount corresponding to the resource amount flow item.
[0100] Among them, the numerical resource report includes a cash flow statement, the numerical resource flow identifier includes a cash flow identifier, the numerical resource flow item includes a cash flow item, and the resource amount includes an amount. Therefore, the terminal obtains the period information corresponding to the cash flow item in the target voucher; based on the period information and the cash flow identifier, finds the current period amount item and the current year amount item in the cash flow statement; based on the amount corresponding to the cash flow item, adjusts the amount in the current period amount item and the amount in the current year amount item.
[0101] In order to understand the above technical solution more clearly and intuitively, Figure 4 The details are as follows:
[0102] After the correspondence between the accounts and cash flow items is preset in the account table, the report processing is performed through the report processing program. That is, the report processing program processes the report according to the correspondence between the accounts and cash flow items. The main processing principles are as follows:
[0103] like Figure 4As shown, when the voucher is saved, it is detected whether the current target voucher is a cash voucher. If so, it is further determined whether there are cash accounts, bank accounts, cash and bank equivalents accounts and non-cash accounts in the entries of the target voucher. If not, the cash flow items in each entry of the target voucher are set to 0; if so, the cash flow direction identifier (fcashflowid) corresponding to the non-cash account is filled in the cash flow item of the corresponding debit / credit side, and then the following information in the target voucher is read: period information (period), fcashflowid and corresponding amount (amount), and the amount is summed with the corresponding amount in the cash flow statement (tb_cashflowbal) according to fcashflowid, famount=famount+amount, and then the current period amount in the cash flow statement is updated; and the amount is summed into the current year cumulative amount fyearamount in the table (i.e. fyearamount=fyearamount+amount), as shown in Table 2, thereby completing the preservation of cash flow data and the processing of the cash flow statement. In addition, the target credential after filling in fcashflowid will also be saved.
[0104] Table 2
[0105] Period Information Cash flow items Amount of this period Cumulative amount this year 202108 1 100 100 202108 2 100 100 202109 1 100 200 202109 2 100 200
[0106] In the above embodiment, the numerical resource flow identifier in the account table is read according to the non-numerical resource account in the target voucher; the numerical resource flow identifier is filled into the numerical resource flow item corresponding to the target voucher according to the corresponding relationship between the non-numerical resource account and the numerical resource flow item; the resource amount corresponding to the numerical resource flow item in the target voucher is read; based on the resource amount corresponding to the numerical resource flow item and the numerical resource flow identifier, the corresponding resource amount in the numerical resource report is adjusted. Since the corresponding relationship between the non-numerical resource account and the numerical resource flow item is preset, when the numerical resource flow identifier corresponding to the non-numerical resource account is obtained, the numerical resource flow identifier can be automatically filled into the numerical resource flow item corresponding to the target voucher, so that there is no need to manually specify the numerical resource flow item, thereby effectively improving the processing efficiency of the report.
[0107] In one embodiment, the statements and vouchers may also be adjusted, such as Figure 5 As shown, the adjustment process is as follows:
[0108] S502: Detect a modification operation triggered on a target numerical resource flow item in a numerical resource report.
[0109] The target numerical resource flow item may refer to the numerical resource flow item that needs to be modified, such as Figure 6 As shown, if you need to modify the cash flow item for the 2021-04-30 period in the cash flow statement, you can trigger the modification operation on the cash flow item.
[0110] In one embodiment, the terminal displays a report page, in which a numerical resource report is displayed. When a user needs to modify a target numerical resource flow item in the numerical resource report, the terminal performs a modification operation on the target numerical resource flow item. When the terminal detects the modification operation on the target numerical resource flow item, on the one hand, the target numerical resource flow item in the numerical resource report can be modified, such as modifying the content in the target numerical resource flow item to obtain the target numerical resource flow identifier; on the other hand, a modification confirmation window can be displayed on the report page, such as Figure 7 shown.
[0111] S504: In response to the modification operation, a modification confirmation window is displayed.
[0112] Among them, two modification methods are displayed in the modification confirmation window, namely the first modification control and the second modification control. The first modification control corresponds to the first modification method, such as modifying the target numerical resource flow item only affects the current target certificate, that is, only modifies the target numerical resource flow item in the target certificate; the second modification control corresponds to the second modification method, such as affecting the current certificate and all newly added certificates in the future, such as modifying the target certificate and all related certificates.
[0113] In one embodiment, in response to the modification operation, the terminal displays a modification confirmation window including a first modification control and a second modification control on the report page, such as Figure 7 shown.
[0114] S506, when the first modification control in the modification confirmation window is triggered and the credential pointed to by the target numerical resource flow item is the target credential, the numerical resource flow item in the target credential is modified according to the modification operation.
[0115] Specifically, when the first modification control in the modification confirmation window is triggered and the credential pointed to by the target numerical resource flow item is the target credential, the terminal modifies the numerical resource flow item in the target credential to the target numerical resource flow identifier according to the modification operation.
[0116] S508, when the second modification control in the modification confirmation window is triggered, the voucher associated with the target numerical resource flow item and the associated account in the account table are searched.
[0117] S510, modifying the numerical resource flow item in the associated voucher; and modifying the numerical resource flow item corresponding to the associated subject.
[0118] In one embodiment, the terminal modifies the numerical resource flow item in the associated voucher to the target numerical resource flow identifier, and modifies the numerical resource flow item corresponding to the associated subject to the target numerical resource flow identifier.
[0119] As an example, Figure 8 As shown, when the user starts to adjust the cash flow items in the cash flow statement, the content of the cash flow item can be modified through the report adjustment program, such as changing "cash received from short-term investments, long-term bond investments and long-term equity investments" to "cash received from purchasing raw materials, goods, and receiving labor services". The corresponding cash flow items in the voucher can also be modified and the cash flow items associated with the updated account can be modified. For the modification of the cash flow items corresponding to the voucher and the cash flow items associated with the account, the following methods can be used: Display the modification confirmation window, such as Figure 7 As shown in the figure, the modification confirmation window contains two functional controls, as follows:
[0120] 1) One of the functional controls modifies the cash flow of a single voucher, that is, only updates the cash flow item of the current voucher;
[0121] 2) Another function control is used to modify all newly added vouchers in the current month and the following periods. When this function control is selected, all vouchers that meet the conditions can be queried according to the query condition: "Voucher period period>=Current period voucher entry account=Current account" and the cash flow item of the voucher can be updated;
[0122] In addition, you can also query the eligible accounts according to the query condition "fdebitcashflowid=current cash flow item orfcreditcashflowid=current cash flow item" and update the corresponding cash flow items.
[0123] Among them, the following Tables 3 and 4 are the process of modifying the corresponding cash flow items in the voucher (the cash flow items for the current month and subsequent periods are also processed similarly).
[0124] Before modification:
[0125] Table 3
[0126]
[0127] After modification:
[0128] Table 4
[0129]
[0130] Tables 5 and 6 below show the process of modifying the debit cash flow items corresponding to account 1101.
[0131] Before modification:
[0132]
[0133] After modification:
[0134]
[0135] In the above embodiment, the processing of adjusting the numerical resource items is unified in one interface, thereby improving the operation efficiency and reducing the complexity of the operation.
[0136] In addition to the above technical effects, the various embodiments of the present application may also have the following technical effects:
[0137] (1) Reduce workload, eliminating the workload of document entry personnel manually processing the relationship between current documents and cash flow;
[0138] (2) Automating the processing of cash flow items reduces human involvement and thus reduces the probability of errors;
[0139] (3) The cash flow statement can be opened quickly, and the data processing work of the cash flow statement is dispersed into each voucher saving operation, thus avoiding the work of data calculation and summary every time the voucher is opened;
[0140] (4) More intelligent, it can automatically calculate the data within the affected range according to the modification and update it in real time;
[0141] (5) It is more convenient and flexible. Operators can freely choose the cash flow items and ranges to be adjusted according to their needs.
[0142] It should be understood that, although the various steps in the flowcharts involved in the above-mentioned embodiments are displayed in sequence according to the indication of the arrows, these steps are not necessarily executed in sequence according to the order indicated by the arrows. Unless there is a clear explanation in this article, the execution of these steps does not have a strict order restriction, and these steps can be executed in other orders. Moreover, at least a part of the steps in the flowcharts involved in the above-mentioned embodiments can include multiple steps or multiple stages, and these steps or stages are not necessarily executed at the same time, but can be executed at different times, and the execution order of these steps or stages is not necessarily to be carried out in sequence, but can be executed in turn or alternately with other steps or at least a part of the steps or stages in other steps.
[0143] Based on the same inventive concept, the embodiment of the present application also provides a report processing device for implementing the report processing method involved above. The implementation scheme for solving the problem provided by the device is similar to the implementation scheme recorded in the above method, so the specific limitations in the embodiment of the one or more report processing devices provided below can refer to the limitations of the report processing method above, and will not be repeated here.
[0144] In one embodiment, Fig. 9 As shown, a report processing device is provided, including: a reading module 902, a filling module 904 and an adjustment module 906, wherein:
[0145] A reading module 902 is used to read the numerical resource flow identifier in the table of accounts according to the non-numerical resource account in the target voucher;
[0146] Filling module 904, used to fill the numerical resource flow identifier into the numerical resource flow item corresponding to the target voucher according to the corresponding relationship between the non-numerical resource category and the numerical resource flow item;
[0147] The reading module 902 is also used to read the resource amount corresponding to the numerical resource flow item in the target voucher;
[0148] The adjustment module 906 is used to adjust the corresponding resource amount in the numerical resource report based on the resource amount corresponding to the numerical resource flow item and the numerical resource flow identifier.
[0149] In one embodiment, the reading module 902 is further used to detect whether there is a non-numerical resource account in the target voucher; if there is a non-numerical resource account in the target voucher, the numerical resource flow identifier in the account table is read according to the non-numerical resource account;
[0150] The filling module 904 is also used to fill in a specified identifier in the numerical resource flow item corresponding to the numerical resource account in the target voucher if there is no non-numerical resource account in the target voucher.
[0151] In one embodiment, if Fig.10 As shown, the device also includes:
[0152] The determination module 908 is further configured to determine the credential type corresponding to the target credential when a save operation of the target credential is detected;
[0153] The saving module 910 is used to save the target credential in the target database.
[0154] In one embodiment, the device further comprises:
[0155] A determination module 908, configured to determine a credential type corresponding to a target credential when a credential saving request is received;
[0156] The reading module 902 is further used to read the numerical resource flow identifier in the account table according to the non-numerical resource account in the target voucher when it is determined based on the voucher type that the target voucher is a numerical resource voucher.
[0157] In one embodiment, the adjustment module 906 is used to obtain the period information corresponding to the numerical resource flow item in the target voucher; based on the period information and the numerical resource flow identifier, search for the current period resource amount item and the current year resource amount item in the numerical resource report; based on the resource amount corresponding to the resource amount flow item, adjust the resource amount in the current period resource amount item and the resource amount in the current year resource amount item.
[0158] In one embodiment, if Fig.10 As shown, the device also includes:
[0159] A detection module 912, used to detect a modification operation triggered on a target numerical resource flow item in a numerical resource report;
[0160] The modification module 914 is used to modify the numerical resource flow item in the target credential according to the modification operation when the first modification control in the modification confirmation window is triggered and the credential pointed to by the target numerical resource flow item is the target credential.
[0161] In one embodiment, if Fig.10 As shown, the device also includes:
[0162] A search module 916, used for searching the voucher associated with the target numerical resource flow item and the associated account in the account table when the second modification control in the modification confirmation window is triggered;
[0163] The modification module 914 is also used to modify the numerical resource flow items in the associated vouchers; and to modify the numerical resource flow items corresponding to the associated subjects.
[0164] Each module in the report processing device can be implemented in whole or in part by software, hardware, or a combination thereof. Each module can be embedded in or independent of a processor in a computer device in the form of hardware, or can be stored in a memory in a computer device in the form of software, so that the processor can call and execute operations corresponding to each module.
[0165] In one embodiment, a computer device is provided. The computer device may be a server or a terminal. In the subsequent embodiments, the computer device is described as a terminal. The internal structure diagram thereof may be as follows: Fig.11As shown. The computer device includes a processor, a memory, an input / output interface, a communication interface, a display unit and an input device. The processor, the memory and the input / output interface are connected via a system bus, and the communication interface, the display unit and the input device are connected to the system bus via the input / output interface. The processor of the computer device is used to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system and a computer program. The internal memory provides an environment for the operation of the operating system and the computer program in the non-volatile storage medium. The input / output interface of the computer device is used to exchange information between the processor and an external device. The communication interface of the computer device is used to communicate with an external terminal in a wired or wireless manner, and the wireless manner can be implemented through WIFI, a mobile cellular network, NFC (near field communication) or other technologies. When the computer program is executed by the processor, a method for processing a report is implemented. The display unit of the computer device is used to form a visually visible image, and can be a display screen, a projection device or a virtual reality imaging device. The display screen can be a liquid crystal display screen or an electronic ink display screen. The input device of the computer device can be a touch layer covered on the display screen, or a button, trackball or touchpad set on the computer device casing, or an external keyboard, touchpad or mouse, etc.
[0166] Those skilled in the art will understand that Fig.11 The structure shown in the figure is only a block diagram of a part of the structure related to the solution of the present application, and does not constitute a limitation on the computer device to which the solution of the present application is applied. The specific computer device may include more or fewer components than those shown in the figure, or combine certain components, or have a different arrangement of components.
[0167] In one embodiment, a computer device is provided, including a memory and a processor, wherein a computer program is stored in the memory, and the processor implements the following steps when executing the computer program: reading a numerical resource flow identifier in a table of accounts according to a non-numerical resource account in a target voucher; filling the numerical resource flow identifier into the numerical resource flow item corresponding to the target voucher according to the correspondence between the non-numerical resource account and the numerical resource flow item; reading the resource amount corresponding to the numerical resource flow item in the target voucher; and adjusting the corresponding resource amount in the numerical resource report based on the resource amount corresponding to the numerical resource flow item and the numerical resource flow identifier.
[0168] In one embodiment, when the processor executes the computer program, the following steps are also implemented: detecting whether there are non-numerical resource accounts in the target voucher; if there are non-numerical resource accounts in the target voucher, reading the numerical resource flow identifier in the account table according to the non-numerical resource accounts; if there are no non-numerical resource accounts in the target voucher, filling in the specified identifier in the numerical resource flow item corresponding to the numerical resource account in the target voucher.
[0169] In one embodiment, when the processor executes the computer program, the following steps are also implemented: obtaining the period information corresponding to the numerical resource flow item in the target voucher; searching for the current period resource amount item and the current year resource amount item in the numerical resource report based on the period information and the numerical resource flow identifier; and adjusting the resource amount in the current period resource amount item and the resource amount in the current year resource amount item based on the resource amount corresponding to the resource amount flow item.
[0170] In one embodiment, when the processor executes the computer program, the following steps are also implemented: detecting a modification operation on a target numerical resource flow item triggered in a numerical resource report; when the first modification control in the modification confirmation window is triggered and the credential pointed to by the target numerical resource flow item is the target credential, modifying the numerical resource flow item in the target credential according to the modification operation.
[0171] In one embodiment, when the processor executes the computer program, the following steps are also implemented: when the second modification control in the modification confirmation window is triggered, the voucher associated with the target numerical resource flow item and the associated account in the account table are searched; the numerical resource flow item in the associated voucher is modified; and the numerical resource flow item corresponding to the associated account is modified.
[0172] In one embodiment, when the processor executes the computer program, the following steps are also implemented: when a credential save request is received, the credential type corresponding to the target credential is determined; when the target credential is determined to be a numerical resource credential based on the credential type, the numerical resource flow identifier in the account table is read according to the non-numerical resource account in the target credential.
[0173] In one embodiment, when the processor executes the computer program, the following steps are also implemented: after the numerical resource flow identifier is filled into the numerical resource flow item corresponding to the target credential, the target credential is saved in the target database.
[0174] In one embodiment, a computer-readable storage medium is provided, on which a computer program is stored. When the computer program is executed by a processor, the following steps are implemented: reading a numerical resource flow identifier in a table of accounts according to a non-numerical resource account in a target voucher; filling the numerical resource flow identifier into the numerical resource flow item corresponding to the target voucher according to the correspondence between the non-numerical resource account and the numerical resource flow item; reading the resource amount corresponding to the numerical resource flow item in the target voucher; and adjusting the corresponding resource amount in the numerical resource report based on the resource amount corresponding to the numerical resource flow item and the numerical resource flow identifier.
[0175] In one embodiment, when the computer program is executed by the processor, the following steps are also implemented: detecting whether there are non-numerical resource accounts in the target certificate; if there are non-numerical resource accounts in the target certificate, reading the numerical resource flow identifier in the account table according to the non-numerical resource accounts; the method also includes: if there are no non-numerical resource accounts in the target certificate, filling in the specified identifier in the numerical resource flow item corresponding to the numerical resource account in the target certificate.
[0176] In one embodiment, when the computer program is executed by the processor, the following steps are also implemented: obtaining the period information corresponding to the numerical resource flow item in the target voucher; searching for the current period resource amount item and the current year resource amount item in the numerical resource report based on the period information and the numerical resource flow identifier; and adjusting the resource amount in the current period resource amount item and the resource amount in the current year resource amount item based on the resource amount corresponding to the resource amount flow item.
[0177] In one embodiment, when the computer program is executed by the processor, the following steps are also implemented: detecting a modification operation on a target numerical resource flow item triggered in a numerical resource report; when the first modification control in the modification confirmation window is triggered and the credential pointed to by the target numerical resource flow item is the target credential, modifying the numerical resource flow item in the target credential according to the modification operation.
[0178] In one embodiment, when the computer program is executed by the processor, the following steps are also implemented: when the second modification control in the modification confirmation window is triggered, the voucher associated with the target numerical resource flow item and the associated account in the account table are searched; the numerical resource flow item in the associated voucher is modified; and the numerical resource flow item corresponding to the associated account is modified.
[0179] In one embodiment, when the processor executes the computer program, the following steps are also implemented: when a credential save request is received, the credential type corresponding to the target credential is determined; when the target credential is determined to be a numerical resource credential based on the credential type, the numerical resource flow identifier in the account table is read according to the non-numerical resource account in the target credential.
[0180] In one embodiment, when the computer program is executed by the processor, the following steps are also implemented: after the numerical resource flow identifier is filled into the numerical resource flow item corresponding to the target credential, the target credential is saved in the target database.
[0181] In one embodiment, a computer program product is provided, including a computer program, which implements the following steps when executed by a processor: reading a numerical resource flow identifier in a table of accounts according to a non-numerical resource account in a target voucher; filling the numerical resource flow identifier into the numerical resource flow item corresponding to the target voucher according to the correspondence between the non-numerical resource account and the numerical resource flow item; reading the resource amount corresponding to the numerical resource flow item in the target voucher; and adjusting the corresponding resource amount in the numerical resource report based on the resource amount corresponding to the numerical resource flow item and the numerical resource flow identifier.
[0182] In one embodiment, when the computer program is executed by the processor, the following steps are also implemented: detecting whether there are non-numerical resource accounts in the target certificate; if there are non-numerical resource accounts in the target certificate, reading the numerical resource flow identifier in the account table according to the non-numerical resource accounts; the method also includes: if there are no non-numerical resource accounts in the target certificate, filling in the specified identifier in the numerical resource flow item corresponding to the numerical resource account in the target certificate.
[0183] In one embodiment, when the computer program is executed by the processor, the following steps are also implemented: obtaining the period information corresponding to the numerical resource flow item in the target voucher; searching for the current period resource amount item and the current year resource amount item in the numerical resource report based on the period information and the numerical resource flow identifier; and adjusting the resource amount in the current period resource amount item and the resource amount in the current year resource amount item based on the resource amount corresponding to the resource amount flow item.
[0184] In one embodiment, when the computer program is executed by the processor, the following steps are also implemented: detecting a modification operation on a target numerical resource flow item triggered in the numerical resource report; when the first modification control in the modification confirmation window is triggered and the credential pointed to by the target numerical resource flow item is the target credential, modifying the numerical resource flow item in the target credential according to the modification operation.
[0185] In one embodiment, when the computer program is executed by the processor, the following steps are also implemented: when the second modification control in the modification confirmation window is triggered, the voucher associated with the target numerical resource flow item and the associated account in the table of accounts are searched; the numerical resource flow item in the associated voucher is modified; and the numerical resource flow item corresponding to the associated account is modified.
[0186] In one embodiment, when the computer program is executed by the processor, the following steps are also implemented: when a credential save request is received, determining the credential type corresponding to the target credential; when the target credential is determined to be a numerical resource credential based on the credential type, reading the numerical resource flow identifier in the account table according to the non-numerical resource account in the target credential.
[0187] In one embodiment, when the computer program is executed by the processor, the following steps are also implemented: after the numerical resource flow identifier is filled into the numerical resource flow item corresponding to the target credential, the target credential is saved in the target database.
[0188] It should be noted that the user information (including but not limited to user device information, user personal information, etc.) and data (including but not limited to data used for analysis, stored data, displayed data, etc.) involved in this application are all information and data authorized by the user or fully authorized by all parties, and the collection, use and processing of relevant data must comply with relevant laws, regulations and standards of relevant countries and regions.
[0189] Those skilled in the art can understand that all or part of the processes in the above-mentioned embodiment methods can be completed by instructing the relevant hardware through a computer program, and the computer program can be stored in a non-volatile computer-readable storage medium. When the computer program is executed, it can include the processes of the embodiments of the above-mentioned methods. Among them, any reference to the memory, database or other medium used in the embodiments provided in the present application can include at least one of non-volatile and volatile memory. Non-volatile memory can include read-only memory (ROM), magnetic tape, floppy disk, flash memory, optical memory, high-density embedded non-volatile memory, resistive random access memory (ReRAM), magnetoresistive random access memory (MRAM), ferroelectric random access memory (FRAM), phase change memory (PCM), graphene memory, etc. Volatile memory can include random access memory (RAM) or external cache memory, etc. As an illustration and not limitation, RAM can be in various forms, such as static random access memory (SRAM) or dynamic random access memory (DRAM). The database involved in each embodiment provided in this application may include at least one of a relational database and a non-relational database. Non-relational databases may include distributed databases based on blockchains, etc., but are not limited to this. The processor involved in each embodiment provided in this application may be a general-purpose processor, a central processing unit, a graphics processor, a digital signal processor, a programmable logic device, a data processing logic device based on quantum computing, etc., but are not limited to this.
[0190] The technical features of the above embodiments may be combined arbitrarily. To make the description concise, not all possible combinations of the technical features in the above embodiments are described. However, as long as there is no contradiction in the combination of these technical features, they should be considered to be within the scope of this specification.
[0191] The above-described embodiments only express several implementation methods of the present application, and the descriptions thereof are relatively specific and detailed, but they cannot be understood as limiting the scope of the present application. It should be pointed out that, for a person of ordinary skill in the art, several variations and improvements can be made without departing from the concept of the present application, and these all belong to the protection scope of the present application. Therefore, the protection scope of the present application shall be subject to the attached claims.
Claims
1. A report processing method, characterized in that: The method comprises: Read the numerical resource flow identifier in the account table according to the non-numerical resource account in the target voucher; According to the correspondence between the non-numerical resource subjects and the numerical resource flow items, the numerical resource flow identifier is filled into the numerical resource flow item corresponding to the target voucher; Reading the resource amount corresponding to the numerical resource flow item in the target voucher; Based on the resource amount corresponding to the numerical resource flow item and the numerical resource flow identifier, the corresponding resource amount in the numerical resource report is adjusted.
2. The method according to claim 1, characterized in that The step of reading the numerical resource flow identifier in the table of accounts according to the non-numerical resource account in the target voucher includes: Detecting whether there is a non-numerical resource account in the target voucher; If there is a non-numerical resource account in the target voucher, then read the numerical resource flow identifier in the account table according to the non-numerical resource account; The method further includes: if the non-numerical resource subject does not exist in the target voucher, then filling in a specified identifier in the numerical resource flow item corresponding to the numerical resource subject in the target voucher.
3. The method according to claim 1 or 2, characterized in that: The adjusting the corresponding resource amount in the report based on the resource amount corresponding to the numerical resource flow item and the numerical resource flow identifier includes: Obtaining period information corresponding to the numerical resource flow item in the target voucher; According to the period information and the numerical resource flow identifier, searching for the current period resource amount item and the current year resource amount item in the numerical resource report; Based on the resource amount corresponding to the numerical resource flow item, the resource amount in the current period resource amount item and the resource amount in the current year resource amount item are adjusted.
4. The method according to claim 1 or 2, characterized in that: The method further comprises: Detecting a modification operation triggered on a target numerical resource flow item in the numerical resource report; In response to the modification operation, displaying a modification confirmation window; When the first modification control in the modification confirmation window is triggered and the credential pointed to by the target numerical resource flow item is the target credential, the numerical resource flow item in the target credential is modified according to the modification operation.
5. The method according to claim 4, characterized in that The method further comprises: When the second modification control in the modification confirmation window is triggered, the voucher associated with the target numerical resource flow item and the associated account in the account table are searched; Modify the numerical resource flow item in the associated voucher; The numerical resource flow item corresponding to the associated subject is modified.
6. The method according to claim 1 or 2, characterized in that: The method further comprises: When receiving a credential saving request, determining a credential type corresponding to the target credential; The method of reading the numerical resource flow identifier in the table of accounts according to the non-numerical resource account in the target voucher includes: When it is determined that the target voucher is a numerical resource voucher based on the voucher type, the numerical resource flow identifier in the account table is read according to the non-numerical resource account in the target voucher.
7. The method according to claim 6, characterized in that After the numerical resource flow identifier is filled into the numerical resource flow item corresponding to the target voucher, the method further includes: The target credentials are saved in a target database.
8. A cash flow statement processing device, characterized in that: The device comprises: The reading module is used to read the numerical resource flow identifier in the account table according to the non-numerical resource account in the target voucher; A filling module, used for filling the numerical resource flow identifier into the numerical resource flow item corresponding to the target voucher according to the corresponding relationship between the non-numerical resource category and the numerical resource flow item; The reading module is further used to read the resource amount corresponding to the numerical resource flow item in the target voucher; The adjustment module is used to adjust the corresponding resource amount in the numerical resource report based on the resource amount corresponding to the numerical resource flow item and the numerical resource flow identifier.
9. A computer device comprising a memory and a processor, wherein the memory stores a computer program, wherein: When the processor executes the computer program, the steps of the method according to any one of claims 1 to 7 are implemented.
10. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the steps of the method according to any one of claims 1 to 7 are implemented.
11. A computer program product, comprising a computer program, characterized in that When the computer program is executed by a processor, the steps of the method according to any one of claims 1 to 7 are implemented.
Citation Information
Patent Citations
Information processing method and terminal
CN111275436A
Financial report subject matching method and device, computer equipment and storage medium
CN113627351A