A report merging method, intelligent terminal and storage medium
By constructing accounting and transaction data sets and introducing unreachable reversal adjustment data sets, flexible report merging is achieved, solving the problems of changes in merge requirements and repeated processing in the existing technology, and improving the merge efficiency and data details retention.
Patent Information
- Application Number
- CN202111175447.9
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2021-10-09
- Publication Date
- 2024-11-01
- Estimated Expiration
- 2041-10-09
AI Technical Summary
Existing report merging methods are difficult to meet the needs of variable range, multi-dimensional, and multi-level mergers with high elasticity, and the overall coordination and improvement costs are high when the merge requirements change, and repeated processing of transaction records leads to a large workload.
By obtaining the current accounting voucher data set and identification code set of the merged unit, the accounting data set and transaction data set are constructed, the unreachable reversal adjustment data set is introduced, the cumulative merged data set is constructed, and the target merged unit and cumulative data set is carried out according to the target merged unit and cumulative data set. Report merging to achieve flexible merge scope and dimensions.
It realizes high degree of automation report merging, reduces the intensity of merger work, supports multi-dimensional and multi-level merge needs, reduces duplicate processing, retains account data details, and stores merge results with structured data.
Smart Images

Figure CN113901767B_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the field of data processing technology, and in particular to a report merging method, an intelligent terminal and a storage medium. Background Art
[0002] In the existing methods, the consolidation of financial statements is highly dependent on the progress and quality of the preparation of financial statements by subordinate units. The scope and dimensions of the consolidation of financial statements need to be determined in advance, which makes it difficult to meet the needs of flexible, variable scope, multi-dimensional and multi-level consolidation. The overall coordination and improvement due to changes in consolidation requirements are difficult and costly. For some transactions, each subsequent consolidation work often requires repeated processing of relevant transaction records from the date of consolidation, resulting in a large amount of repetitive work. With the development of modern data technology, in order to promote the improvement of financial automation level, expand the application of intelligent financial technology, and meet the increasing requirements for data analysis in economic activities, improved financial statement consolidation technology has become increasingly important. Summary of the invention
[0003] The technical problem to be solved by the present invention is that, in view of the above-mentioned defects of the prior art, a report merging method, an intelligent terminal and a storage medium are provided, aiming to solve the problem that the existing report merging method is difficult to meet the needs of highly flexible variable range, multi-dimensional and multi-level merging.
[0004] The technical solution adopted by the present invention to solve the problem is as follows:
[0005] In a first aspect, an embodiment of the present invention provides a report merging method, wherein the method comprises:
[0006] Acquire a plurality of current accounting voucher data sets corresponding to each original merging unit in the merging unit set and a first identification code set corresponding to the merging unit set, and construct a current accounting data set and an inter-merging unit transaction data set according to each of the current accounting voucher data sets and the first identification code set;
[0007] Acquire the current uncollected write-off adjustment data set corresponding to the merged unit set, and construct a cumulative merged data set according to the current uncollected write-off adjustment data set, the current account data set and the inter-merged unit transaction data set;
[0008] A plurality of target merging units within the target merging range of the merging unit set is obtained, and report merging is performed according to the plurality of target merging units and the accumulated merging data set to realize report merging of the merging unit set within the target merging range.
[0009] The report merging method, wherein the step of constructing a current accounting data set and a merged inter-unit transaction data set based on each of the current accounting voucher data sets and the first identification code set comprises:
[0010] Marking each entry line in the current period accounting voucher data set according to the identification code pair of both transaction parties and the transaction code between the merging units, and constructing the current period accounting data set; wherein the identification code pair includes the identification code of the party and the identification code of the other party;
[0011] According to the first identification code set and the identification code pair, the entry lines whose identification code pairs satisfy the first preset condition are screened out from the entry lines of the current account data set, and a set consisting of the screened entry lines is used as the merged inter-unit transaction data set; wherein the first preset condition is that the other party's identification code belongs to the first identification code set and the other party's identification code is not equal to the other party's identification code.
[0012] The report consolidation method, wherein the step of constructing a cumulative consolidation data set based on the current uncollected write-off adjustment data set, the current account data set and the consolidation unit transaction data set comprises:
[0013] Constructing a current period uncollected adjustment data set and a current period restatement adjustment data set based on the current period uncollected write-off adjustment data set and the inter-merging unit transaction data set;
[0014] A cumulative consolidated data set is constructed based on the current accounting data set, the current uncollected write-off adjustment data set, the current uncollected adjustment data set, and the current restatement adjustment data set.
[0015] The method for merging financial statements, wherein the step of constructing a current period uncollected adjustment data set and a current period restatement adjustment data set based on the current period uncollected write-off adjustment data set and the inter-merging unit transaction data set comprises:
[0016] Constructing a current period uncollected adjustment data set according to the current period uncollected write-off adjustment data set and the inter-merger unit transaction data set;
[0017] A current period restatement adjustment data set is constructed according to the current period uncollected write-off adjustment data set, the inter-merging unit transaction data set and the current period uncollected adjustment data set.
[0018] The report consolidation method, wherein the step of constructing the current period uncollected adjustment data set based on the current period uncollected write-off adjustment data set and the inter-merging unit transaction data set comprises:
[0019] Merging the current uncollected write-off adjustment data set and the merged inter-unit transaction data set to obtain a merged data set;
[0020] An offset test is performed on the inter-merger unit transaction records in the merged data set according to the inter-merger unit transaction number, unreached inter-merger unit transaction records are supplemented according to the accounting rules, and the data set formed by the supplementation is determined as the current unreached adjustment data set corresponding to the merged unit set.
[0021] The method for merging financial statements, wherein the step of constructing a current period restatement adjustment data set based on the current period unreceived write-off adjustment data set, the inter-merging unit transaction data set and the current period unreceived adjustment data set comprises:
[0022] Merging the merged inter-unit transaction data set, the current unsatisfied adjustment data set, and the current unsatisfied write-off adjustment data set to obtain an unsatisfied adjusted merged inter-unit transaction data set;
[0023] Taking the inter-merger unit transaction number as a clue, the accounting records of each row in the unadjusted inter-merger unit transaction data set are restated to construct the current period restatement adjustment data set.
[0024] The method for merging financial statements, wherein the step of constructing a cumulative merged data set based on the current accounting data set, the current uncollected write-off adjustment data set, the current uncollected adjustment data set and the current restatement adjustment data set comprises:
[0025] Constructing a current period occurrence amount consolidated data set based on the current period accounting data set, the current period unreceived write-off adjustment data set, the current period unreceived adjustment data set and the current period restatement adjustment data set;
[0026] The previous period cumulative consolidated data set is obtained, and a cumulative consolidated data set is constructed according to the current period occurrence amount consolidated data set and the previous period cumulative consolidated data set.
[0027] The report merging method further comprises:
[0028] A unique identification code is set for each merging unit in the merging unit set and the associated transaction parties outside the first identification code set, and an associated party identification code set corresponding to the associated transaction parties outside the first identification code set is obtained.
[0029] The report merging method, wherein the step of merging reports according to the target merging units and the accumulated merging data sets to achieve report merging of the merging unit sets within the target merging range includes:
[0030] Acquire a plurality of second identification code sets corresponding to the target merged units, and construct a transaction query data set according to the second identification code sets and the current period accumulated merged data set;
[0031] A report preparation operation is performed on the data in the transaction query data set to generate a consolidated report, so as to realize report consolidation of the consolidated unit set within the target consolidation scope.
[0032] The report consolidation method, wherein the current period cumulative consolidated data set includes: the current period cumulative account data set, the current period cumulative unreceived write-off adjustment data set, the current period cumulative unreceived adjustment data set and the current period cumulative restatement adjustment data set; the transaction query data set includes: the current period consolidated query data set; the step of constructing the transaction query data set according to the second identification code set and the current period cumulative consolidated data set includes:
[0033] Filter out the entries whose own identification code meets the second preset condition and the other party identification code meets the third preset condition from the current period cumulative accounting data set, the current period cumulative unreceived write-off adjustment data set and the current period cumulative unreceived adjustment data set, and filter out the entries whose own identification code meets the second preset condition and the other party identification code meets the fourth preset condition from the current period cumulative restatement adjustment data set, and use the set of the filtered entries as the current period consolidated query data set; wherein, the second preset condition is that the own identification code belongs to the second identification code set, the third preset condition is that the other party identification code does not belong to the second identification code set or the other party identification code is equal to the own identification code, and the fourth preset condition is that the other party identification code belongs to the second identification code set and the other party identification code is not equal to the own identification code.
[0034] The report merging method, wherein the transaction query data set further includes: a transaction query data set between merged units in this period; the step of constructing the transaction query data set according to the second identification code set and the accumulated merged data set in this period further includes:
[0035] From the current period's accumulated accounting data set, the current period's accumulated uncollected write-off adjustment data set, and the current period's accumulated uncollected adjustment data set, select the entry lines whose identification codes satisfy the second preset condition and whose identification codes satisfy the fourth preset condition, and use the set of the selected entry lines as the current period's inter-merger unit transaction query data set.
[0036] The report merging method, wherein the transaction query data set further includes: an associated transaction data set; the step of constructing the transaction query data set according to the second identification code set and the current period cumulative merged data set further includes:
[0037] From the current period cumulative accounting data set, the current period cumulative uncollected write-off adjustment data set and the current period cumulative uncollected adjustment data set, select the entry lines whose own identification code meets the second preset condition and the other party identification code meets the fifth preset condition or the sixth preset condition, and use the set of the selected entry lines as the associated transaction data set; wherein the fifth preset condition is that the other party identification code does not belong to the second identification code set but belongs to the first identification code set, and the sixth preset condition is that the other party identification code belongs to the associated party identification code set.
[0038] In a second aspect, an embodiment of the present invention provides an intelligent terminal comprising a memory and one or more programs, wherein the one or more programs are stored in the memory and are configured to be executed by one or more processors, wherein the one or more programs include steps for executing a report merging method as described in any one of the above.
[0039] In a third aspect, an embodiment of the present invention provides a computer-readable storage medium. When the instructions in the storage medium are executed by a processor of an electronic device, the electronic device can perform the steps of the report consolidation method as described in any one of the above.
[0040] Beneficial effects of the present invention: The embodiment of the present invention first obtains several current accounting voucher data sets corresponding to each original merging unit in the merging unit set and the first identification code set corresponding to the merging unit set, and constructs a current accounting data set and an inter-merging unit transaction data set according to each of the current accounting voucher data sets and the first identification code set, and then obtains the current unreceived write-off adjustment data set corresponding to the merging unit set, and constructs a cumulative merged data set according to the current unreceived write-off adjustment data set, the current accounting data set and the inter-merging unit transaction data set, and finally, obtains several target merging units of the merging unit set within the target merging range, and performs report merging according to the several target merging units and the cumulative merging data set to realize the report merging of the merging unit set within the target merging range. The present invention realizes the report consolidation work by constructing the basic account data required for preparing the consolidated report, which fundamentally changes the method and logic of the existing conventional consolidated report technology. It does not rely on the preparation of individual reports of each consolidated unit and the analysis, summary and multilateral proofreading work carried out to offset the transactions between the consolidated units. There is no need to prepare a consolidated working draft. The consolidation work can be completed together with the period accounting processing work. It is not restricted by the predefined consolidation scope and consolidation level path, and the real-time consolidation results of variable consolidation scope and variable consolidation dimension can be quickly viewed; the consolidation process does not need to be summarized level by level, and the account data details are not lost. It provides standardized basic data with the finest granularity possible for the disclosure of report notes and multi-level and multi-dimensional consolidated report analysis. The consolidation process and consolidation result data are stored in standardized and rigorous structured data, which is conducive to data continuity and reuse. BRIEF DESCRIPTION OF THE DRAWINGS
[0041] In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments recorded in the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative work.
[0042] Figure 1 It is a flowchart of a report merging method provided by an embodiment of the present invention;
[0043] Figure 2 It is a block diagram of the internal structure principle of the intelligent terminal provided by an embodiment of the present invention. DETAILED DESCRIPTION
[0044] In order to make the purpose, technical solution and advantages of the present invention clearer and more specific, the present invention is further described in detail below with reference to the accompanying drawings and examples. It should be understood that the specific embodiments described herein are only used to explain the present invention and are not used to limit the present invention.
[0045] It should be noted that if the embodiments of the present invention involve directional indications (such as up, down, left, right, front, back, etc.), the directional indications are only used to explain the relative position relationship, movement status, etc. between the components under a certain specific posture (as shown in the accompanying drawings). If the specific posture changes, the directional indication will also change accordingly.
[0046] The existing financial statement consolidation is based on the data of individual statements of the consolidated members, which is highly dependent on the progress and quality of the report preparation work of the subordinate units. The overall coordination and improvement due to changes in the consolidation requirements are difficult, costly and time-consuming. The data aggregation, adjustment and offset of the consolidated statements are all completed in the consolidation working papers, which are highly dependent on the subjective judgment and manual adjustment of the consolidation staff. Moreover, the adjustment and offset data are all completed in the consolidation working papers and are not reflected in the financial accounting. There is a difference between the report numbers and the book numbers. The report consolidation process usually adopts a manual level-by-level aggregation mode, which is difficult to achieve a high degree of automation, the consolidation work efficiency is low, and it is difficult to ensure timeliness. The level-by-level aggregation operation process also leads to the loss of data details, which brings inconvenience to the analysis of consolidated statements. In the offsetting and adjustment of consolidated financial statements, it is difficult to ensure the requirements of financial standardization, it is difficult to maintain rigor in the use of accounts and auxiliary accounting, the auxiliary documents and data for report preparation are less standardized, and it is difficult to rigorously reflect the real business; the scope and dimensions of report consolidation need to be determined in advance and are highly rigid, and the report consolidation workflow and results are difficult to meet the highly flexible variable range, multi-dimensional and multi-level consolidation needs, and it is difficult to meet the growing analysis and management needs; for each subsequent consolidation work, some of the transactions involved in the consolidation working papers often need to be recompiled from the date of the consolidation, resulting in a large amount of repetitive work; the working paper data does not have the standardization and rigor of structured accounting data. If there is a gap in related management work, it will be unfavorable for the continuation and reuse of data.
[0047] In order to solve the problems of the prior art, this embodiment provides a report merging method, by which the automation degree of report merging can be improved, the report merging scope can be freely defined, the merging work intensity can be greatly reduced, and the multi-dimensional and multi-level report merging requirements can be realized. In the specific implementation, firstly, a number of current accounting voucher data sets corresponding to each original merging unit in the merging unit set and a first identification code corresponding to the merging unit set are obtained, and a current account data set and an inter-merging unit transaction data set are constructed according to each of the current accounting voucher data sets and the first identification code set, and then, a current unreceived write-off adjustment data set corresponding to the merging unit set is obtained, and a cumulative merged data set is constructed according to the current unreceived write-off adjustment data set, the current account data set and the inter-merging unit transaction data set, and finally, a number of target merging units of the merging unit set within the target merging scope are obtained, and report merging is performed according to the number of target merging units and the cumulative merged data set to realize the report merging of the merging unit set within the target merging scope. This method transforms complex and professional report consolidation work into a logically clear data set construction and query process, thereby creating favorable conditions for the introduction of automation technology, financial intelligence technology, etc., and achieving the purpose of high automation level, high degree of freedom, variable consolidation scope, multi-dimensional and multi-level report consolidation. This method reduces the burden of repeated processing of related previous transactions by introducing and applying the current period unreceived write-off adjustment data set.
[0048] Exemplary Methods
[0049] This embodiment provides a report merging method, which can be applied to smart terminals. Figure 1 As shown in , the method includes:
[0050] Step S100: obtaining a plurality of current accounting voucher data sets corresponding to each original merging unit in the merging unit set and a first identification code set corresponding to the merging unit set, and constructing a current accounting data set and an inter-merging unit transaction data set according to each of the current accounting voucher data sets and the first identification code set.
[0051] Specifically, the merged unit set is a set of merged units with the maximum merged scope, and the merged unit set includes several original merged units. The several current accounting voucher data sets GLS include: accounting voucher entry data, account summary table, account balance table, other similar data, and the summary, split or deformation of the aforementioned data. In order to merge the financial statements, in this embodiment, a unique identification code is set for each original merged unit in the merged unit set and the related transaction parties other than the first identification code set Cons.max, which are respectively denoted as unit.i and Rel.i. For example, as shown in Table 1, it is a merged unit set with the maximum merged scope, which includes 10 original merged units, and each original merged unit has its corresponding unique identification code. For example, the identification code of merged unit 01 is unit.1, and the identification code of merged unit 02 is unit.2. As shown in Table 2, a unique identification code is set for the related transaction parties outside the maximum consolidation scope, which includes 10 related parties. Each related party has its corresponding unique identification code. For example, the identification code of related unit 01 is rel.1, and the identification code of related unit 02 is rel.2. The meaning of the related party is consistent with the definition of the relevant rules of the consolidated financial statements.
[0052] Table 1 The merge unit set with the largest merge scope
[0053] Unique Identifier Original Merged Unit Company Name Product Line area Management Group …… unit.1 Merge Unit 01 Company 01 PL01 area01 M01 …… unit.2 Merge Unit 02 Company 02 PL01 area01 M01 …… unit.3 Merge Unit 03 Company 03 PL01 area01 M01 …… unit.4 Merge Unit 04 Company 04 PL02 area01 M01 …… unit.5 Merge Unit 05 Company 05 PL02 area01 M01 …… unit.6 Merge Unit 06 Company 06 PL02 area02 M01 …… unit.7 Merge Unit 07 Company 07 PL02 area02 M02 …… unit.8 Merge Unit 08 Company 08 PL03 area02 M02 …… unit.9 Merge Unit 09 Company 09 PL03 area02 M02 …… unit.10 Merge Unit 10 Company 10 PL03 area02 M02 ……
[0054] Table 2 Related party identification code set outside the maximum consolidation scope
[0055] Unique Identifier Related units Company Name …… Rel.1 Related Unit 01 Affiliated Company01 …… Rel.2 Related Unit 02 Affiliated Company02 …… Rel.3 Related Unit 03 Affiliated Company03 …… Rel.4 Related Unit 04 Affiliated Company04 …… Rel.5 Related Unit 05 Affiliated Company05 …… Rel.6 Related Unit 06 Affiliated Company06 …… Rel.7 Related Unit 07 Affiliated Company07 …… Rel.8 Related units 08 Affiliated Company08 …… Rel.9 Related units 09 Affiliated Company09 …… Rel.10 Related units 10 Related companies10 ……
[0056] The first identification code set Cons.max corresponding to the merged unit set is a set of identification codes corresponding to each original merged unit in the merged unit set. After setting a unique identification code for each original merged unit, several current accounting voucher data sets GLS corresponding to each original merged unit in the merged unit set and the first identification code set Cons.max corresponding to the merged unit set are obtained. For example, still taking Table 1 as an example, the first identification code set Cons.max is {unit.1, unit.2, unit.3, unit.4, unit.5, unit.6, unit.7, unit.8, unit.9, unit.10}, and then according to each of the current accounting voucher data sets GLS and the first identification code set Cons.max, the current accounting data set GL(n) and the inter-merged unit transaction data set intra(n) are constructed. In this embodiment, the report consolidation is based on the current accounting voucher data set GLS. Without reducing the details of the financial data, it can provide better support for the consolidated report data, introduce the maximum consolidation scope, and set a unique identification code for each consolidation unit within the maximum consolidation scope to achieve the necessary consistency arrangements for the accounting methods, data specifications, and work collaboration within the consolidation scope, and map the key work content and elements of the consolidated report to data processing work. By expanding and changing the above-mentioned identification code list, the continuous expansion or change of the maximum consolidation scope can be achieved.
[0057] In a specific implementation, the step of constructing the current accounting data set and the merged inter-unit transaction data set according to each of the current accounting voucher data sets and the first identification code set in step S100 specifically includes:
[0058] Step S110: Mark each entry line in the current accounting voucher data set according to the identification code pair of the two transaction parties and the transaction code between the merging units, and construct the current accounting data set; wherein the identification code pair includes the identification code of the party and the identification code of the other party;
[0059] Step S120: based on the first identification code set and the identification code pair, filter out the entry lines whose identification code pairs satisfy a first preset condition from the entry lines of the current period account data set, and use the set of the filter-out entry lines as the merged inter-unit transaction data set; wherein the first preset condition is that the other party's identification code belongs to the first identification code set and the other party's identification code is not equal to the own identification code.
[0060] Specifically, the marking according to the identification code pairs of the two parties to the transaction refers to obtaining the identification code of the transaction party directly marked in the transaction record or implicitly represented by the associated attributes and the identification code of the own party representing the own party in the transaction record, and identifying the account record, wherein the own party's identification code and the other party's identification code together constitute an identification code pair. For example, according to the relevant attribute values contained in the business document or the relevant attribute values of the financial entry line where they are located, such as the other party of the payment transaction, the investment subordinate party, the capital collection and payment party, the business purchase and sale party and other key values, the identification code pair is automatically generated according to predefined logic or manually analyzed and filled in; or the relationship between the transaction identification code pairs of each data row is replaced by directly using the other party's identification code, or by other column attributes on the entry line, or by other table column attributes that have an inter-table relationship with the entry line, so as to achieve a similar effect. The marking of the identification code pairs of the two transaction parties can be executed in batches according to predefined logic after the account data set is completed, or it can be executed as one of the basic data items while the account data set is formed; one of the identification code pairs of the two transaction parties always contains the identification code of the accounting subject, that is, the party itself, by default, so only marking the other party's identification code can still achieve the equivalent effect of identifying the paired identification codes of the two transaction parties mentioned above, and can achieve the above-mentioned purpose of identifying the transaction relationship and identifying the nature of the transaction in the form of paired identification codes; in the case of abandoning the merging requirements such as variable merging scope and multi-dimensional merging, the relationship between the two transaction parties is not clearly identified in the form of an identification code pair, but the value of other columns or relationship columns of each entry line of the accounting voucher is used to directly or indirectly express the paired transaction relationship. This method can also achieve the purpose of identifying the transaction relationship or transaction nature as described in the present invention, and is one of the methods for implementing the present invention. This embodiment marks the entry lines with the identification code pairs of the two parties to the transaction, converts complex transactions between merged units into low-coupling and highly structured financial record data, fundamentally simplifies the tedious intermediate work processes of inter-merger unit transaction identification, registration and offset in the report consolidation work, and reduces the complexity and difficulty of the work; the marking of the identification code pairs of the two parties to the transaction is not restricted by data processing technical conditions and specific forms, as long as it can meet the judgment of the transaction fact relationship in the query process, the marking of the identification code pairs of the two parties to the transaction can be completed synchronously in the accounting process, thereby supporting real-time acquisition of merged data.
[0061] The marking according to the inter-merging unit transaction code of the two parties of the transaction is to obtain the rule-based code for marking and identifying the inter-merging unit transaction in the first identification code set, and mark the records of the inter-merging unit transaction in the relevant merging unit, wherein different records of the same transaction involved in different merging units are marked with the same inter-merging unit transaction code. The inter-merging unit transaction code is shared by the merging units within the maximum merging range, and is accurately marked by the relevant merging units in the corresponding entry line. In order to simplify the data set construction, instead of giving a unique transaction code to each transaction, the inter-merging unit transactions are merged and then marked, which can also achieve the purpose of data set construction. By replacing the inter-unit transaction number with other column attributes on the inter-unit transaction entry line, or by replacing the inter-unit transaction number with the column attributes of other tables that have an inter-table relationship with the entry line, or by classifying, aggregating, splitting or deforming similar transactions in the inter-unit transaction entry line, marking different inter-unit transaction categories instead of the inter-unit transaction entry line itself, the inter-unit transaction is not identified by numbering or other methods, but the data line of the nature or transaction relationship of the inter-unit transaction is directly or indirectly identified by other attribute values of the accounting data or by external associations, the purpose of data set construction can also be achieved, all of which belong to the protection scope of the present invention. The transaction code of the inter-unit transaction is used to accurately mark the inter-unit transaction and its records across each merging unit within the maximum merging range. Since the inter-unit transaction code appears in pairs in the transaction-related merging units, the cross-period and complex inter-unit transaction financial records can be easily automatically tracked, checked, offset tested and restated under the assumption of accounting entity change through the transaction code.
[0062] After obtaining several current accounting voucher data sets GLS corresponding to each original merging unit in the merging unit set, this embodiment marks each entry line in the current accounting voucher data set GLS according to the identification code pair unit.ij of the two transaction parties recorded therein and the transaction code Intra.k between the merging units, and uses the marked current accounting voucher data set GLS as the current accounting data set GL(n), wherein the identification code pair unit.ij includes the own identification code unit.i and the other party identification code unit.j. For example, as shown in Table 3, the current accounting voucher data set GLS includes several entry lines, the own identification is marked with the identification code of the accounting subject, the other party identification is marked with the identification code of the transaction counterparty, and each entry line has its own corresponding identification unit.i and the other party identification unit.j, wherein the other party identification unit.j includes the identification code corresponding to each merging unit within the range of the first identification code set Cons.max and the identification code corresponding to the associated transaction company outside the range of the first identification code set Cons.max. For example, in the identification code pair corresponding to 20XX-3-20, voucher number 1, entry line 1, the identification code of the party is unit.1, and the identification code of the other party is unit.5. In this embodiment, the entry lines are marked in the form of identification code pairs unit.ij, and the complex inter-unit transaction expressions are converted into low-coupling and highly structured financial record data, which fundamentally simplifies the cumbersome intermediate work processes of inter-unit transaction identification, registration and offset in the report consolidation work, reduces the difficulty of work, and the marking of identification code pairs does not need to be restricted by data processing technical conditions and specific forms, as long as it can meet the judgment of transaction relationship facts in the query process. The marking of the identification code pairs unit.ij and the inter-unit transaction code Intra.k of the transaction parties can be completed during the accounting process, thereby supporting the real-time acquisition of consolidated data.
[0063] Table 3 Current accounting voucher data set
[0064]
[0065] After constructing the current accounting data set GL(n), further based on the first identification code set Cons.max and the identification code pair unit.ij, from each entry line of the current accounting data set GL(n), select each entry line whose identification code pair satisfies the first preset condition crt01, and use the set consisting of each selected entry line as the merged inter-unit transaction data set intra(n); wherein the first preset condition crt01 is that the other party's identification code unit.j belongs to the first identification code set Cons.max and the other party's identification code unit.j is not equal to the own identification code unit.i. For example, the first identification code set is Cons.max, the identification code pair is unit.ij, and the identification code pair unit.ij corresponding to each entry line is traversed, and the set consisting of each entry line is selected according to the first preset condition crt01 as the merged inter-unit transaction data set intra(n).
[0066] Step S200, obtaining the current uncollected write-off adjustment data set corresponding to the merged unit set, and constructing a cumulative merged data set according to the current uncollected write-off adjustment data set, the current account data set and the inter-merged unit transaction data set.
[0067] Specifically, after constructing the current accounting data set GL(n) and the merged inter-unit transaction data set intra(n), this embodiment obtains the current unreached write-off adjustment data set Pr(n) corresponding to the merged unit set, and then constructs the cumulative merged data set ConsoYTD(n) based on the current unreached write-off adjustment data set Pr(n), the current accounting data set GL(n) and the merged inter-unit transaction data set intra(n). This embodiment introduces the current unreached write-off adjustment data set Pr(n) in the merging process to solve the problem of period differences caused by the cross-period transaction records of the merged inter-unit transactions, converts the cross-period transaction offset test problem into the current transaction offset test work, and simplifies the workflow. Of course, other methods, such as repeatedly detecting the cross-period merged inter-unit transaction data to confirm and process the unreached transaction data, can also achieve the purpose of realizing the merged inter-unit transaction record offset test, all of which are within the protection scope of the present invention.
[0068] In a specific implementation, the step of constructing a cumulative merged data set according to the current uncollected write-off adjustment data set, the current account data set and the merged inter-unit transaction data set in step S200 specifically includes:
[0069] Step S210: construct a current-period uncollected adjustment data set and a current-period restatement adjustment data set according to the current-period uncollected write-off adjustment data set and the inter-merging unit transaction data set;
[0070] Step S220: construct a cumulative consolidated data set based on the current accounting data set, the current uncollected write-off adjustment data set, the current uncollected adjustment data set and the current restatement adjustment data set.
[0071] Specifically, when constructing the cumulative consolidated dataset ConsoYTD(n), in this embodiment, the current uncollected adjustment dataset P(n) and the current restatement adjustment dataset S(n) are first constructed based on the current uncollected write-off adjustment dataset Pr(n) and the inter-merger unit transaction dataset intra(n), and then the cumulative consolidated dataset ConsoYTD(n) is constructed based on the current account dataset GL(n), the current uncollected write-off adjustment dataset Pr(n), the current uncollected adjustment dataset P(n) and the current restatement adjustment dataset S(n).
[0072] In a specific implementation, the step of constructing the current uncollected adjustment data set and the current restatement adjustment data set according to the current uncollected write-off adjustment data set and the inter-merging unit transaction data set in step S210 specifically includes:
[0073] Step S211, constructing a current-period uncollected adjustment data set according to the current-period uncollected write-off adjustment data set and the merged inter-unit transaction data set;
[0074] Step S212: construct a current period restatement adjustment data set according to the current period uncollected write-off adjustment data set, the inter-merging unit transaction data set and the current period uncollected adjustment data set.
[0075] Specifically, when constructing the current uncollected adjustment dataset P(n) and the current restatement adjustment dataset S(n), this embodiment first constructs the current uncollected adjustment dataset P(n) based on the current uncollected write-off adjustment dataset Pr(n) and the merged inter-unit transaction dataset intra(n), and then constructs the current restatement adjustment dataset S(n) based on the current uncollected write-off adjustment dataset Pr(n), the merged inter-unit transaction dataset intra(n) and the current uncollected adjustment dataset P(n).
[0076] In a specific implementation, in step S211, the step of constructing the current uncollected adjustment data set according to the current uncollected write-off adjustment data set and the merged inter-unit transaction data set includes:
[0077] Step S2111: construct a current-period uncollected adjustment data set according to the current-period uncollected write-off adjustment data set and the merged inter-unit transaction data set;
[0078] Step S2112: construct a current period restatement adjustment data set based on the current period uncollected write-off adjustment data set, the inter-merging unit transaction data set and the current period uncollected adjustment data set.
[0079] Specifically, when constructing the current unreachable adjustment data set P(n), the embodiment first merges the inter-merging unit transaction data set intra(n) and the current unreachable offset adjustment data set Pr(n) to obtain a merged data set; then, the inter-merging unit transaction records in the merged data set are tested and offset according to the inter-merging unit transaction number Intra.k. If there are unreachable inter-merging unit transaction records, they are supplemented according to the accounting rules, and the supplemented data set is determined as the current unreachable adjustment data set P(n) corresponding to the merged unit set. In the process of supplementing according to the accounting rules, each entry line in the formed current unreachable adjustment data set P(n) simultaneously retains the transaction party identification code pair reflecting the actual transaction relationship and the inter-merging unit transaction code. The above-mentioned test offset of the inter-merging unit transaction records and supplementary recording according to the accounting rules can be completed synchronously or regularly in the daily accounting work of each merged unit of the group, or can be completed by subjective entry or automatic batch or one-by-one generation according to preset logic. On the basis of using automation technology and providing timeliness convenience, the possibility of obtaining consolidated report data in real time is greatly improved. In this embodiment, the unreachable adjustment data set P(n-1) of the previous period is reversed offset in the current period to construct the unreachable offset adjustment data set Pr(n) of the current period, or the unreachable adjustment data set P(n) of the current period is reversed offset in the next period to construct the unreachable offset adjustment data set Pr(n+1) of the next period, and the inter-unit transaction records in the merged data set are tested and offset by the inter-unit transaction codes, so that the cross-period and complex inter-unit transaction records can be easily automatically tracked, checked, offset tested and restated under the assumption of accounting entity change.
[0080] After constructing the current unreceived adjustment data set P(n), the merged inter-unit transaction data set intra(n), the current unreceived adjustment data set P(n) and the current unreceived write-off adjustment data set Pr(n) are merged to obtain the merged inter-unit transaction data set T(n) after unreceived adjustment. Then, based on the merged inter-unit transaction number Intra.k, the merged inter-unit transactions recorded in each entry line in the merged inter-unit transaction data set T(n) after unreceived adjustment are restated based on the assumption that the two parties of the merged inter-unit transaction are the same accounting entity to construct the current restatement adjustment data set S(n). In the process of restating the accounting vouchers, each entry line in the current restatement adjustment data set S(n) completely retains the transaction party identification code pair reflecting the actual transaction relationship and the merged inter-unit transaction code. The above method of restating accounting vouchers based on the assumption that both parties of the inter-merger unit transaction are the same accounting entity and constructing the current restatement adjustment data set S(n) converts the consolidation of inter-merger unit business into general accounting processing. In specific operations, the voucher entry preparation of this part of the inter-merger unit transaction business as the transaction occurred under the same accounting entity can be completed by referring to the general voucher preparation process, using subjective input or automatic batch or one-by-one generation according to preset logic. When restating accounting vouchers based on the inter-merger unit transaction number Intra.k as a clue, all inter-merger unit transactions should be correctly restated, and each entry line should be correctly marked with the transaction identification code pair, and the inter-merger unit transaction number Intra.k data. The purpose of restating the transaction data between the merged units can also be achieved by not setting the transaction number Intra.k between the merged units, or not using the transaction number Intra.k between the merged units as a clue, but directly restating the transaction account data between the merged units, or by merging the transaction business between the merged units and restating the transaction business between the merged units on the basis of the summary data. This method does not exclude any listed or unlisted forms, as long as the method can achieve the restatement of the transaction account data between the merged units, it belongs to the protection scope of the present invention. Similarly, the design scheme of avoiding the construction of the restatement data set of the transaction between the merged units by aggregating the transactions between the merged units and compiling the summary restatement entries according to the summary data also belongs to the protection scope of the present invention.
[0081] In a specific implementation, in step S220, the step of constructing a cumulative consolidated data set based on the current accounting data set, the current uncollected write-off adjustment data set, the current uncollected adjustment data set, and the current restatement adjustment data set includes:
[0082] Step S221, constructing a current period occurrence amount consolidated data set according to the current period accounting data set, the current period uncollected write-off adjustment data set, the current period uncollected adjustment data set and the current period restatement adjustment data set;
[0083] Step S222: Obtain the previous period cumulative merged data set, and construct the current period cumulative merged data set based on the current period occurrence amount merged data set and the previous period cumulative merged data set.
[0084] Specifically, after constructing the current period uncollected adjustment dataset P(n) and the current period restatement adjustment dataset S(n), this embodiment constructs the current period occurrence amount consolidated dataset ConsoP(n) according to the current period account dataset GL(n), the current period uncollected write-off adjustment dataset Pr(n), the current period uncollected adjustment dataset P(n) and the current period restatement adjustment dataset S(n).
[0085] In order to avoid repeated processing of previous transactions, in this embodiment, after constructing the current period's consolidated data set ConsoP(n), the previous period's cumulative consolidated data set ConsoYTD(n-1) corresponding to the consolidated unit set is further obtained, and the current period's cumulative consolidated data set ConsoYTD(n) is constructed based on the current period's consolidated data set ConsoP(n) and the previous period's cumulative consolidated data set ConsoYTD(n-1). The previous period cumulative consolidated data set ConsoYTD(n-1) includes the previous period cumulative account data set GLYTD(n-1), the previous period cumulative uncollected write-off adjustment data set PrYTD(n-1), the previous period cumulative uncollected adjustment data set PYTD(n-1) and the previous period cumulative restatement adjustment data set SYTD(n-1). When constructing the current period cumulative consolidated data set ConsoYTD(n) according to the current period occurrence amount consolidated data set ConsoP(n) and the previous period cumulative consolidated data set ConsoYTD(n-1), specifically, each subset in the current period occurrence amount consolidated data set ConsoP(n), namely, the current period account data set GL(n), the current period uncollected write-off adjustment data set Pr(n), the current period uncollected adjustment data set PYTD(n-1) and the previous period cumulative restatement adjustment data set SYTD(n-1) are combined. The data set P(n) and the current period restatement adjustment data set S(n) are respectively appended to the subsets of the previous period cumulative consolidated data set ConsoYTD(n-1), namely, the previous period cumulative accounting data set GLYTD(n-1), the previous period cumulative unreceived write-off adjustment data set PrYTD(n-1), the previous period cumulative unreceived adjustment data set PYTD(n-1) and the previous period cumulative restatement adjustment data set SYTD(n-1). Therefore, the constructed current period cumulative consolidated data set ConsoYTD(n) also includes the current period cumulative accounting data set GLYTD(n), the current period cumulative unreceived write-off adjustment data set PrYTD(n), the current period cumulative unreceived adjustment data set PYTD(n) and the current period cumulative restatement adjustment data set SYTD(n). This embodiment introduces the previous period cumulative consolidated data set ConsoYTD(n-1) in the report consolidation process, retains and fully utilizes the previous period consolidated account data results, and each period consolidation work only needs to construct the current period consolidated report account data on schedule, and there is no need to repeatedly rebuild the previous consolidated financial data from the consolidation date in the consolidation work, so the previous consolidation work will be properly utilized for a long time. Of course, even if the period is not distinguished, by directly constructing the cumulative data set from the consolidation date or the beginning of the period to the current period, although the above-mentioned advantage of properly utilizing the previous consolidation work cannot be obtained, the current period cumulative consolidated data set ConsoYTD(n) can still be constructed, so it also falls within the protection scope of the present invention.
[0086] Step S300: obtaining a plurality of target merging units within a target merging range of the merging unit set, and performing report merging according to the plurality of target merging units and the accumulated merging data set, so as to realize report merging of the merging unit set within the target merging range.
[0087] Specifically, the target consolidation range is obtained by customization within the maximum consolidation range corresponding to the consolidation unit set. When it is necessary to perform report consolidation on the consolidation unit set within the target range, several target consolidation units of the consolidation unit set within the target consolidation range are obtained. For example, as shown in Table 1, several target consolidation units are determined from the consolidation unit set according to the customized consolidation range (such as: product line P02 consolidation), namely, consolidation unit 04, consolidation unit 05, consolidation unit 06, and consolidation unit 07. Then, report consolidation is performed according to the several target consolidation units and the cumulative consolidation data set ConsoYTD(n) to realize report consolidation of the consolidation unit set within the target consolidation range. Similarly, there are other schemes for determining target merging unit combinations from the merging unit set for achieving different merging targets in the customized merging range. For example, when merging by area01, several target merging units are determined from the merging unit set as: merging unit 01, merging unit 02, merging unit 03, merging unit 04, merging unit 05; or when merging by management group M02, several target merging units are determined from the merging unit set as: merging unit 07, merging unit 08, merging unit 09, merging unit 10, etc. In this embodiment, the variable merging range can flexibly express the variable combination of multiple ranges, multiple levels, multiple dimensions, multiple calibers, etc. of each merging unit within the maximum merging range, thereby achieving the result output of multiple merging targets, combining the dynamic list of the actual merging range and the specific values of the transaction party identification code pairs in the entry rows of the cumulative data set of each period of the consolidated report, judging the transaction nature or transaction relationship of each entry data row, thereby converting the consolidated report work into a general data query, and realizing a report automation merging technical solution with high degree of freedom, multiple merging targets, and high real-time requirements.
[0088] In a specific implementation, in step S300, the step of performing report merging according to the target merging units and the accumulated merging data sets to achieve report merging of the merging unit sets within the target merging range includes:
[0089] Step S310: obtaining a second identification code set corresponding to a plurality of the target merging units, and constructing a transaction query data set according to the second identification code set and the current period accumulated merged data set;
[0090] Step S320: perform a report preparation operation on the data in the transaction query data set to generate a consolidated report, so as to realize report consolidation of the consolidated unit set within the target consolidation scope.
[0091] Specifically, it is mentioned in the above steps that each original merged unit has a unique identification code, so the target merged unit determined from each original merged unit also has a unique identification code that is consistent with the definition thereof, and the second identification code set Cons.sub is a set of identification codes corresponding to each target merged unit. For example, still taking Table 1 as an example, when several target merged units are merged unit 04, merged unit 05, merged unit 06, and merged unit 07, the second identification code set Cons.sub is {unit.4, unit.5, unit.6, unit.7}. In this embodiment, when performing report consolidation on a merged unit set within the target consolidation scope, first obtain the second identification code set Cons.sub corresponding to several of the target merged units, construct a transaction query data set based on the second identification code set Cons.sub and the current period cumulative merged data set ConsoYTD(n), and then execute the report preparation procedures such as rule adjustment, foreign currency conversion, and account matching on the data in the transaction query data set to generate a consolidated report, so as to realize the report consolidation of the merged unit set within the target consolidation scope.
[0092] In a specific implementation, the current period cumulative consolidated data set includes: the current period cumulative account data set, the current period cumulative uncollected write-off adjustment data set, the current period cumulative uncollected adjustment data set and the current period cumulative restatement adjustment data set; the transaction query data set includes: the current period consolidated query data set; in step S310, the step of constructing the transaction query data set according to the second identification code set and the current period cumulative consolidated data set includes:
[0093] Step S311, select from the current period cumulative accounting data set, the current period cumulative unreceived write-off adjustment data set and the current period cumulative unreceived adjustment data set each entry row whose own identification code meets the second preset condition and the other party identification code meets the third preset condition, and select from the current period cumulative restatement adjustment data set each entry row whose own identification code meets the second preset condition and the other party identification code meets the fourth preset condition, and use the set of selected entry rows as the current period merged query data set; wherein, the second preset condition is that the own identification code belongs to the second identification code set, the third preset condition is that the other party identification code does not belong to the second identification code set or the other party identification code is equal to the own identification code, and the fourth preset condition is that the other party identification code belongs to the second identification code set and the other party identification code is not equal to the own identification code.
[0094] Specifically, the current period cumulative consolidated data set ConsoYTD(n) includes the current period cumulative account data set GLYTD(n), the current period cumulative unreachable write-off adjustment data set PrYTD(n), the current period cumulative unreachable adjustment data set PYTD(n) and the current period cumulative restatement adjustment data set SYTD(n); the transaction query data set includes: the current period consolidated query data set ConsoSub(n); when constructing the transaction query data set, the present embodiment compares the identification code pairs corresponding to each entry line in the current period cumulative account data set GLYTD(n), the current period cumulative unreachable write-off adjustment data set PrYTD(n), the current period cumulative unreachable adjustment data set PYTD(n) and the current period cumulative restatement adjustment data set SYTD(n) with the second identification code set Cons.sub, and selects the own identification code u from the current period cumulative account data set GLYTD(n), the current period cumulative unreachable write-off adjustment data set PrYTD(n) and the current period cumulative unreachable adjustment data set PYTD(n). nit.i satisfies the second preset condition crt02 and the other party identification code unit.j satisfies the third preset condition crt03, and the entry lines whose own identification code satisfies the second preset condition crt02 and the other party identification code unit.j satisfies the fourth preset condition crt04 are screened out from the current period cumulative restatement adjustment data set SYTD(n), and the set consisting of the screened entry lines is used as the current period consolidated query data set ConsoSub(n); wherein, the second preset condition crt02 is that the own identification code unit.i belongs to the second identification code set Cons.sub, the third preset condition crt03 is that the other party identification code unit.j does not belong to the second identification code set Cons.sub or the other party identification code unit.j is equal to the own identification code unit.i, and the fourth preset condition crt04 is that the other party identification code unit.j belongs to the second identification code set Cons.sub and the other party identification code unit.j is not equal to the own identification code unit.i. In this embodiment, the transaction relationship or transaction nature contained in each entry line of the cumulative consolidated data set ConsoYTD(n) of this period is determined based on the identification code pair and the second identification code set Cons.sub, and the consolidated report work is converted into a general data query, realizing the automated consolidation of reports with high degree of freedom, multiple consolidation goals, and high real-time requirements.
[0095] In a specific implementation, the transaction query data set further includes: a current period merged inter-unit transaction query data set; in step S310, the step of constructing the transaction query data set according to the second identification code set and the current period accumulated merged data set further includes:
[0096] Step S312, filter out the entry rows whose identification codes satisfy the second preset condition and the identification codes of the other party satisfy the fourth preset condition from the current period cumulative accounting data set, the current period cumulative uncollected write-off adjustment data set and the current period cumulative uncollected adjustment data set, and use the set of the filtered entry rows as the current period inter-merger unit transaction query data set.
[0097] Specifically, after obtaining the current period cumulative consolidated data set ConsoYTD(n), this embodiment can also use the current period cumulative consolidated data set ConsoYTD(n) as the data basis to filter out the entries whose own identification code meets the second preset condition crt02 and the other party identification code meets the fourth preset condition crt04 from the current period cumulative account data set GLYTD(n), the current period cumulative uncollected offset adjustment data set PrYTD(n) and the current period cumulative uncollected adjustment data set PYTD(n), and use the set of the filtered entries as the current period consolidated inter-unit transaction query data set IntraSub(n). The second preset condition crt02 is that the own identification code unit.i belongs to the second identification code set Cons.sub, and the fourth preset condition crt04 is that the other party identification code unit.j belongs to the second identification code set Cons.sub and the other party identification code unit.j is not equal to the own identification code unit.i.
[0098] In a specific implementation, the transaction query data set further includes: an associated transaction data set; in step S310, the step of constructing the transaction query data set according to the second identification code set and the current period cumulative merged data set further includes:
[0099] Step S313, filter out the entry lines whose identification code of the party satisfies the second preset condition and the identification code of the other party satisfies the fifth preset condition or the sixth preset condition from the current period cumulative accounting data set, the current period cumulative uncollected write-off adjustment data set and the current period cumulative uncollected adjustment data set, and use the set of the filtered entry lines as the associated transaction data set; wherein the fifth preset condition is that the identification code of the other party does not belong to the first identification code set but belongs to the first identification code set, and the sixth preset condition is that the identification code of the other party belongs to the associated party identification code set.
[0100] Specifically, the related party identification code set Rel.ext refers to the identification code set corresponding to the related transaction parties other than the first identification code set Cons.max. The aforementioned steps mentioned setting a unique identification code for the related transaction parties other than the first identification code set Cons.max. After constructing the current period cumulative consolidated data set ConsoYTD(n), this embodiment can obtain the related party identification code set Rel.ext corresponding to the related transaction parties other than the first identification code set Cons.max, and compare the identification code pairs corresponding to each entry line in the current period cumulative account data set GLYTD(n), the current period cumulative unreceived write-off adjustment data set PrYTD(n) and the current period cumulative unreceived adjustment data set PYTD(n) with the first identification code set Cons.max, the second identification code set Cons.sub and the related party identification code set Rel.ext. The related transaction data set rel(n) is compared with the related transaction data set Rel.ext, and the entry lines whose identification code unit.i satisfies the second preset condition crt02 and the identification code unit.j of the other party satisfies the fifth preset condition crt05 or the sixth preset condition crt06 are screened out from the current period cumulative accounting data set GLYTD(n), the current period cumulative uncollected offset adjustment data set PrYTD(n) and the current period cumulative uncollected adjustment data set PYTD(n), and the set consisting of the screened entry lines is used as the related transaction data set rel(n); the fifth preset condition crt05 is that the identification code of the other party does not belong to the second identification code set Cons.sub but belongs to the first identification code set Cons.max, and the sixth preset condition crt06 is that the identification code unit.j of the other party belongs to the related party identification code set Rel.ext.
[0101] In addition, in this embodiment, the target consolidation scope can be adjusted as needed, and step S300 is re-executed according to the adjusted target consolidation scope. By updating the data query conditions, a consolidated report account data set under other consolidation schemes is formed, and then the report consolidation results, transaction records between consolidation units, and related transaction records are obtained, avoiding the necessity of pre-solidifying the consolidation scope and related workflows in existing consolidation work, and realizing multi-dimensional and multi-level report consolidation. In this embodiment, the consolidation process and consolidation result data can maintain a standardized and rigorous structured data form, and can be used, managed and stored together with the account data, which is conducive to the continuation and reuse of data and work results.
[0102] It can be seen that the embodiment of the present invention first obtains several current accounting voucher data sets GLS corresponding to each original merging unit in the merging unit set and the first identification code set Cons.max corresponding to the merging unit set, and constructs the current accounting data set GL(n) and the inter-merging unit transaction data set intra(n) according to each of the current accounting voucher data sets GLS and the first identification code set Cons.max. Then, obtains the current unreceived write-off adjustment data set Pr(n) corresponding to the merging unit set, and constructs the cumulative merged data set ConsoYTD(n) according to the current unreceived write-off adjustment data set Pr(n), the current accounting data set GL(n) and the inter-merging unit transaction data set intra(n). Finally, obtains several target merging units of the merging unit set within the target merging range, and performs report merging according to the several target merging units and the cumulative merging data set ConsoYTD(n) to realize the report merging of the merging unit set within the target merging range. The embodiment of the present invention is based on the current accounting voucher data set GLS, introduces the current unreceived write-off adjustment data set Pr(n) in the consolidation process, converts the cross-period transaction offset test problem into the current transaction offset test work, retains and fully utilizes the previous consolidated accounting data results, does not need to repeatedly process previous transactions, greatly reduces the intensity of consolidation work, can customize the consolidation scope, and realizes multi-dimensional and multi-level report consolidation needs.
[0103] Exemplary Devices
[0104] Based on the above embodiments, the present invention further provides an intelligent terminal, whose principle block diagram can be shown as follows: Figure 2 As shown. The intelligent terminal includes a processor, a memory, a network interface, a display screen, and a temperature sensor connected through a system bus. Among them, the processor of the intelligent terminal is used to provide computing and control capabilities. The memory of the intelligent terminal 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 network interface of the intelligent terminal is used to communicate with an external terminal through a network connection. When the computer program is executed by the processor, a report merging method is implemented. The display screen of the intelligent terminal can be a liquid crystal display screen or an electronic ink display screen, and the temperature sensor of the intelligent terminal is pre-set inside the intelligent terminal to detect the operating temperature of the internal device.
[0105] Those skilled in the art will understand that Figure 2The principle block diagram shown in the figure is only a block diagram of a partial structure related to the scheme of the present invention, and does not constitute a limitation on the smart terminal to which the scheme of the present invention is applied. The specific smart terminal may include more or fewer components than those shown in the figure, or combine certain components, or have a different arrangement of components.
[0106] In one embodiment, a smart terminal is provided, comprising a memory and one or more programs, wherein the one or more programs are stored in the memory and are configured to be executed by one or more processors, and the one or more programs include instructions for performing the following operations:
[0107] Acquire several current accounting voucher data sets GLS corresponding to each original merging unit in the merging unit set and the first identification code set Cons.max corresponding to the merging unit set, and construct the current accounting data set GL(n) and the inter-merging unit transaction data set intra(n) according to each current accounting voucher data set GLS and the first identification code set Cons.max;
[0108] Obtain the current uncollected write-off adjustment data set Pr(n) corresponding to the merged unit set, and construct a cumulative merged data set ConsoYTD(n) based on the current uncollected write-off adjustment data set Pr(n), the current account data set GL(n) and the merged unit inter-transaction data set intra(n);
[0109] A plurality of target merging units within the target merging range of the merging unit set is obtained, and report merging is performed according to the plurality of target merging units and the cumulative merging data set ConsoYTD(n) to realize report merging of the merging unit set within the target merging range.
[0110] 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 memory, storage, database or other media used in the embodiments provided by the present invention can include non-volatile and / or volatile memory. Non-volatile memory can include read-only memory (ROM), programmable ROM (PROM), electrically programmable ROM (EPROM), electrically erasable programmable ROM (EEPROM) or flash memory. Volatile memory can include random access memory (RAM) or external cache memory. As an illustration and not limitation, RAM is available in many forms, such as static RAM (SRAM), dynamic RAM (DRAM), synchronous DRAM (SDRAM), double data rate SDRAM (DDRSDRAM), enhanced SDRAM (ESDRAM), synchronous link (Synchlink) DRAM (SLDRAM), memory bus (Rambus) direct RAM (RDRAM), direct memory bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM).
[0111] In summary, the present invention discloses a method for report consolidation, related transaction identification, and inter-merger unit transaction identification and offset, an intelligent terminal, and a storage medium. The method includes: obtaining a number of current accounting voucher data sets GLS corresponding to each original merged unit in a merged unit set and a first identification code set Cons.max corresponding to the merged unit set, and constructing a current accounting data set GL(n) and an inter-merger unit transaction data set intra(n) according to each of the current accounting voucher data sets GLS and the first identification code set Cons.max; obtaining a current unreceived write-off adjustment data set Pr(n) corresponding to the merged unit set, and constructing a cumulative merged data set ConsoYTD(n) according to the current unreceived write-off adjustment data set Pr(n), the current accounting data set GL(n), and the inter-merger unit transaction data set intra(n); obtaining a number of target merged units within a target merged range of the merged unit set, and performing report consolidation according to the target merged units and the cumulative merged data set ConsoYTD(n) to realize report consolidation of the merged unit set within the target merged range. The present invention is based on the current accounting voucher data set GLS, introduces the current unreceived write-off adjustment data set Pr(n) in the consolidation process, converts the inter-period transaction offset test problem into the current transaction offset test work, retains and fully utilizes the previous consolidated accounting data results, does not need to repeatedly process previous transactions, greatly reduces the intensity of consolidation work, can customize the consolidation scope, and realizes multi-dimensional and multi-level report consolidation needs.
[0112] It should be understood that the application of the present invention is not limited to the above examples. For ordinary technicians in this field, improvements or changes can be made based on the above description. All these improvements and changes should fall within the scope of protection of the claims attached to the present invention.
Claims
1. A report merging method, characterized in that: The method comprises: Acquire a plurality of current accounting voucher data sets corresponding to each original merging unit in the merging unit set and a first identification code set corresponding to the merging unit set, and construct a current accounting data set and an inter-merging unit transaction data set according to each of the current accounting voucher data sets and the first identification code set; Acquire the current uncollected write-off adjustment data set corresponding to the merged unit set, and construct a cumulative merged data set according to the current uncollected write-off adjustment data set, the current account data set and the inter-merged unit transaction data set; Acquire a number of target merging units of the merging unit set within the target merging scope, and perform report merging according to the target merging units and the accumulated merging data set, so as to realize report merging of the merging unit set within the target merging scope; The step of constructing a current accounting data set and a merged inter-unit transaction data set according to each of the current accounting voucher data sets and the first identification code set comprises: Marking each entry line in the current period accounting voucher data set according to the identification code pair of both transaction parties and the transaction code between the merging units, and constructing the current period accounting data set; wherein the identification code pair includes the identification code of the party and the identification code of the other party; According to the first identification code set and the identification code pair, the entry lines whose identification code pairs meet the first preset condition are screened out from the entry lines of the current account data set, and the set consisting of the screened entry lines is used as the merged inter-unit transaction data set; wherein the first preset condition is that the other party's identification code belongs to the first identification code set and the other party's identification code is not equal to the own identification code.
2. The report merging method according to claim 1, characterized in that: The step of constructing a cumulative merged data set according to the current uncollected write-off adjustment data set, the current account data set and the merged inter-unit transaction data set comprises: Constructing a current period uncollected adjustment data set and a current period restatement adjustment data set according to the current period uncollected write-off adjustment data set and the inter-merging unit transaction data set; A cumulative consolidated data set is constructed based on the current period accounting data set, the current period uncollected write-off adjustment data set, the current period uncollected adjustment data set and the current period restatement adjustment data set.
3. The report merging method according to claim 2, characterized in that: The step of constructing a current period uncollected adjustment data set and a current period restatement adjustment data set according to the current period uncollected write-off adjustment data set and the inter-merging unit transaction data set comprises: Constructing a current period uncollected adjustment data set according to the current period uncollected write-off adjustment data set and the inter-merger unit transaction data set; A current period restatement adjustment data set is constructed according to the current period uncollected write-off adjustment data set, the inter-merging unit transaction data set and the current period uncollected adjustment data set.
4. The report merging method according to claim 3, characterized in that: The step of constructing the current period unreceived adjustment data set according to the current period unreceived write-off adjustment data set and the merged inter-unit transaction data set comprises: Merging the current uncollected write-off adjustment data set and the merged inter-unit transaction data set to obtain a merged data set; An offset test is performed on the inter-merger unit transaction records in the merged data set according to the inter-merger unit transaction number, unreached inter-merger unit transaction records are supplemented according to the accounting rules, and the data set formed by the supplementation is determined as the current unreached adjustment data set corresponding to the merged unit set.
5. The report merging method according to claim 3, characterized in that: The step of constructing a current period restatement adjustment data set according to the current period uncollected write-off adjustment data set, the inter-merger unit transaction data set and the current period uncollected adjustment data set comprises: Merging the merged inter-unit transaction data set, the current unsatisfied adjustment data set, and the current unsatisfied write-off adjustment data set to obtain an unsatisfied adjusted merged inter-unit transaction data set; Taking the inter-merger unit transaction number as a clue, the accounting records of each row in the unadjusted inter-merger unit transaction data set are restated to construct the current period restatement adjustment data set.
6. The report merging method according to claim 2, characterized in that: The step of constructing a cumulative consolidated data set according to the current accounting data set, the current uncollected write-off adjustment data set, the current uncollected adjustment data set and the current restatement adjustment data set comprises: Constructing a current period occurrence amount consolidated data set based on the current period accounting data set, the current period unreceived write-off adjustment data set, the current period unreceived adjustment data set and the current period restatement adjustment data set; The previous period cumulative consolidated data set is obtained, and a cumulative consolidated data set is constructed according to the current period occurrence amount consolidated data set and the previous period cumulative consolidated data set.
7. The report merging method according to claim 6, characterized in that: The method further comprises: A unique identification code is set for each original merging unit in the merging unit set and the associated transaction parties outside the first identification code set, and an associated party identification code set corresponding to the associated transaction parties outside the first identification code set is obtained.
8. The report merging method according to claim 7, characterized in that: The step of merging reports according to the target merging units and the accumulated merging data sets to realize the merging of reports of the merging unit sets within the target merging scope includes: Acquire a plurality of second identification code sets corresponding to the target merging units, and construct a transaction query data set according to the second identification code sets and the current period accumulated merged data set; A report preparation operation is performed on the data in the transaction query data set to generate a consolidated report, so as to realize report consolidation of the consolidated unit set within the target consolidation scope.
9. The report merging method according to claim 8, characterized in that: The cumulative combined data set for this period includes: The current period's accumulated accounting data set, the current period's accumulated uncollected write-off adjustment data set, the current period's accumulated uncollected adjustment data set, and the current period's accumulated restatement adjustment data set; the transaction query data set includes: the current period's consolidated query data set; the step of constructing the transaction query data set based on the second identification code set and the current period's accumulated consolidated data set includes: Filter out each entry line whose own identification code meets the second preset condition and the other party identification code meets the third preset condition from the current period cumulative accounting data set, the current period cumulative unreceived write-off adjustment data set and the current period cumulative unreceived adjustment data set, and filter out each entry line whose own identification code meets the second preset condition and the other party identification code meets the fourth preset condition from the current period cumulative restatement adjustment data set, and use the set consisting of each filtered entry line as the current period consolidated query data set; wherein, the second preset condition is that the own identification code belongs to the second identification code set, the third preset condition is that the other party identification code does not belong to the second identification code set or the other party identification code is equal to the own identification code, and the fourth preset condition is that the other party identification code belongs to the second identification code set and the other party identification code is not equal to the own identification code.
10. The report merging method according to claim 9, characterized in that: The transaction query data set also includes: The step of constructing a transaction query data set based on the second identification code set and the current period accumulated merged data set further includes: From the current period's accumulated accounting data set, the current period's accumulated uncollected write-off adjustment data set, and the current period's accumulated uncollected adjustment data set, select the entry lines whose identification codes satisfy the second preset condition and whose identification codes satisfy the fourth preset condition, and use the set of the selected entry lines as the current period's inter-merger unit transaction query data set.
11. The report merging method according to claim 9, characterized in that: The transaction query data set also includes: The step of constructing a transaction query data set according to the second identification code set and the current period accumulated merged data set further comprises: From the current period cumulative accounting data set, the current period cumulative uncollected write-off adjustment data set and the current period cumulative uncollected adjustment data set, select the entry lines whose identification code of the party satisfies the second preset condition and whose identification code of the other party satisfies the fifth preset condition or the sixth preset condition, and use the set of the selected entry lines as the associated transaction data set; wherein the fifth preset condition is that the identification code of the other party does not belong to the second identification code set but belongs to the first identification code set, and the sixth preset condition is that the identification code of the other party belongs to the associated party identification code set.
12. An intelligent terminal, characterized in that: It includes a memory and one or more programs, wherein the one or more programs are stored in the memory and are configured to be executed by one or more processors, and the one or more programs include steps for executing the report merging method as described in any one of claims 1-11.
13. A computer-readable storage medium, when the instructions in the storage medium are executed by a processor of an electronic device, the electronic device is enabled to execute the steps of the report consolidation method as described in any one of claims 1 to 11.
