Management and generation method based on detail account multi-dimensional classification report

Abstract

The invention discloses a management and generation method of a multi-dimensional classification report based on a detail account. The method comprises the following steps: S100, defining a classification account; s200, multi-dimensional balance query of the ledger; s300, converting a display mode; s400, exporting an Excel file or a Csv file on the basis of requirements; s500, providing a joint-check detail voucher, a joint-check accounting flow and a joint-check detail account based on demands; s600, displaying a query result; s700, calculating a report result; s800, carrying over the account; classifying the data according to use scenes; during multi-dimensional balance query, classification can be selected in a targeted mode for query, memory occupation is reduced, and query efficiency is improved; data layer-by-layer tracking and joint checking are supported; distributed batch running in a cluster environment is supported, and the multi-dimensional balance calculation efficiency is improved; and the account transfer is carried out aiming at the business scene, and other accounts are not influenced.

Description

Technical Field

[0001] The present invention relates to the technical field of general ledger report generation, and in particular to a management and generation method based on detailed ledger multi-dimensional classification reports. Background Art

[0002] In order to adapt to different accounting standards and to efficiently and accurately classify and analyze data, it is necessary to build a multi-dimensional ledger platform with flexible configuration, classified storage, high credibility, comprehensiveness and easy operation. The existing multi-dimensional ledger is based on the form of multi-dimensional balance sheet of accounts, which is different from the design logic and storage architecture of the new multi-dimensional ledger. Specifically, it is manifested as follows:

[0003] Multi-dimensional balance table: Based on the voucher table, balance table, and auxiliary table, the beginning, occurrence, and ending balance data under the required conditions are calculated through associated queries;

[0004] Multi-dimensional ledger: Through classification definition, different business scenarios such as basic general ledger, product + channel general ledger, deposit sub-account, loan sub-account, bill sub-account, value-added tax general ledger, etc. can be defined as different categories. Each category has its own management and analysis dimension and data permissions. According to different categories, the background is stored as multiple sets of tables, and different tables do not affect each other. At the same time, the presentation layer has also made comprehensive and more user-friendly optimizations to the settings of query parameters and output parameters.

[0005] Therefore, it is necessary to design a management and generation method based on multi-dimensional classification reports of detailed accounts. Summary of the invention

[0006] The purpose of the present invention is to provide a management and generation method based on multi-dimensional classification reports of detailed accounts to solve the problems raised in the above-mentioned background technology.

[0007] In order to solve the above technical problems, the present invention provides the following technical solutions:

[0008] A method for managing and generating a multi-dimensional classification report based on a detailed account includes the following steps:

[0009] S100, ledger definition: create PD / PM tables based on the subject system and dimensions of the content recorded in the account;

[0010] S200, multi-dimensional balance query of ledger: query based on parameters set in multiple dimensions;

[0011] S300, display mode conversion: changing the display mode based on the number of clicks;

[0012] S400, can export Excel file or Csv file based on demand;

[0013] S500, can provide joint inquiry detailed vouchers, joint inquiry accounting flow and joint inquiry detailed accounts based on demand;

[0014] S600, query result display: by default, it is displayed by subject level, and can be converted to display by institution level, and supports lazy loading mode;

[0015] S700, report result calculation: calculate the PD table and PM table based on multi-dimensional data;

[0016] S800 Account Transfer: When checking balance or transferring amount, select PD+PM corresponding to different categories according to business scenarios to calculate balance and transfer.

[0017] According to the above technical solution, the specific steps of S100 are as follows:

[0018] S101. Configure multiple sets of classifications as needed. Classifications can be defined as general ledger, taxation, and sub-accounts. Different classifications can specify different account systems.

[0019] S102. Different categories can define the management and analysis dimensions of the report, as well as the priorities of different dimensions;

[0020] S103. Different categories can define the organization authority, subject authority, and other data authority of this category;

[0021] S104. Create a PD / PM table for this classification according to the classification code.

[0022] According to the above technical solution, the specific steps of S200 are as follows:

[0023] S201. Select the report category and a query parameter input box will pop up. You can enter the institution, account, currency, date, and dimension query conditions. The input parameters support precise query, fuzzy query, and interval query.

[0024] S202: Query parameter dimensions and output parameter dimensions may be defined.

[0025] According to the above technical solution, the specific steps of S300 are as follows:

[0026] S301, when a display button is clicked, three display modes are displayed in rotation according to the number of clicks;

[0027] S302, the default display is code plus name, and the code is displayed when the display button is clicked for the first time;

[0028] S303. Click the second time to display the name, and click the third time to return to the code plus name.

[0029] According to the above technical solution, the specific steps of S400 are as follows:

[0030] S401, the export button group has two sub-buttons: export Excel file and export Csv file;

[0031] S402, when exporting an Excel file, calling the server side according to the query conditions to re-query all matching data to generate an Excel file and download it to the front end;

[0032] S403: When exporting a CSV file, the server is called according to the query conditions to re-query all matching data to generate a CSV file and download it to the front end.

[0033] According to the above technical solution, the specific steps of S500 are as follows:

[0034] S501, the joint query button group provides three sub-options: joint query of detailed vouchers, joint query of accounting records, and joint query of detailed accounts;

[0035] S502. When you select a record and click to query the detailed voucher, the system automatically opens the detailed voucher node, selects the record dimensions including but not limited to the account, account book, and auxiliary segment, queries the detailed voucher, and displays it;

[0036] S503. When you select a record and click on the joint query accounting flow, the system automatically opens the accounting flow node, selects the dimensions of the record including but not limited to the account, account book, and auxiliary segment, queries the accounting flow, and displays it;

[0037] S504. When you select a record and click on the joint query detailed account, the system automatically opens the detailed account node, selects the dimensions of the record including but not limited to the account, account book, and auxiliary segment, queries the detailed voucher, and displays the beginning and end information of each transaction in the order of serial number.

[0038] According to the above technical solution, the specific steps of S600 are as follows:

[0039] S601, query the first-level account by default. There is an expand button in the account cell of the display interface. Click the button to dynamically load the balance data of the second-level account. And so on, all the account level data can be displayed step by step.

[0040] S602. When querying a designated institution, if the institution is not the last level, the balance sheet data of the subordinate institutions of the current institution can be queried in lazy loading mode by clicking the expand button.

[0041] According to the above technical solution, the specific steps of S700 are as follows:

[0042] S701, quasi-real-time and real-time access of transaction-level general ledger to peripheral system flow data;

[0043] S702, the accounting engine performs quasi-real-time analysis of the transaction flow to generate corresponding accounting entries;

[0044] S703, when the accounting engine parses the entries, it updates the PD table data of different categories in real time;

[0045] S704. Calculate report data based on PD table data at the end of the day;

[0046] S705. The multi-dimensional balance query of the ledger calculates the result data based on PM+PD.

[0047] Compared with the prior art, the beneficial effects achieved by the present invention are:

[0048] 1. Data is classified according to usage scenarios;

[0049] 2. When inquiring about multi-dimensional balances, you can select targeted categories for inquiry to reduce memory usage and improve inquiry efficiency;

[0050] 3. Support data tracking and joint inquiry layer by layer;

[0051] 4. Support distributed batch running in cluster environment to improve the efficiency of multi-dimensional balance calculation;

[0052] 5. Account transfer is carried out according to business scenarios and has no impact on other accounts and tables. BRIEF DESCRIPTION OF THE DRAWINGS

[0053] Figure 1 It is a flowchart of the present invention. DETAILED DESCRIPTION

[0054] The following will be combined with the embodiments of the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without making creative work are within the scope of protection of the present invention.

[0055] like Figure 1 As shown, the present invention provides a technical solution: a management and generation method based on a detailed account multi-dimensional classification report, comprising the following steps:

[0056] S100, ledger definition: create PD / PM tables based on the subject system and dimensions of the content recorded in the account;

[0057] S200, multi-dimensional balance query of ledger: query based on parameters set in multiple dimensions;

[0058] S300, display mode conversion: changing the display mode based on the number of clicks;

[0059] S400, can export Excel file or Csv file based on demand;

[0060] S500, can provide joint inquiry detailed vouchers, joint inquiry accounting flow and joint inquiry detailed accounts based on demand;

[0061] S600, query result display: by default, it is displayed by subject level, and can be converted to display by institution level, and supports lazy loading mode;

[0062] S700, report result calculation: calculate the PD table and PM table based on multi-dimensional data;

[0063] S800 Account Transfer: When checking balance or transferring amount, select PD+PM corresponding to different categories according to business scenarios to calculate balance and transfer.

[0064] Specifically, the specific steps of S100 are as follows:

[0065] S101. Configure multiple sets of classifications as needed. Classifications can be defined as general ledger, taxation, and sub-accounts. Different classifications can specify different account systems.

[0066] S102. Different categories can define the management and analysis dimensions of the report, as well as the priorities of different dimensions;

[0067] S103. Different categories can define the organization authority, subject authority, and other data authority of this category;

[0068] S104. Create a PD / PM table for this classification according to the classification code.

[0069] Specifically, the specific steps of S200 are as follows:

[0070] S201. Select the report category and a query parameter input box will pop up. You can enter the institution, account, currency, date, and dimension query conditions. The input parameters support precise query, fuzzy query, and interval query.

[0071] S202: Query parameter dimensions and output parameter dimensions may be defined.

[0072] Specifically, the specific steps of S300 are as follows:

[0073] S301, when a display button is clicked, three display modes are displayed in rotation according to the number of clicks;

[0074] S302, the default display is code plus name, and the code is displayed when the display button is clicked for the first time;

[0075] S303. Click the second time to display the name, and click the third time to return to the code plus name.

[0076] Specifically, the specific steps of S400 are as follows:

[0077] S401, the export button group has two sub-buttons: export Excel file and export Csv file;

[0078] S402, when exporting an Excel file, calling the server side according to the query conditions to re-query all matching data to generate an Excel file and download it to the front end;

[0079] S403: When exporting a CSV file, the server is called according to the query conditions to re-query all matching data to generate a CSV file and download it to the front end.

[0080] Specifically, the specific steps of S500 are as follows:

[0081] S501, the joint query button group provides three sub-options: joint query of detailed vouchers, joint query of accounting records, and joint query of detailed accounts;

[0082] S502. When you select a record and click to query the detailed voucher, the system automatically opens the detailed voucher node, selects the record dimensions including but not limited to the account, account book, and auxiliary segment, queries the detailed voucher, and displays it;

[0083] S503. When you select a record and click on the joint query accounting flow, the system automatically opens the accounting flow node, selects the dimensions of the record including but not limited to the account, account book, and auxiliary segment, queries the accounting flow, and displays it;

[0084] S504. When you select a record and click on the joint query detailed account, the system automatically opens the detailed account node, selects the dimensions of the record including but not limited to the account, account book, and auxiliary segment, queries the detailed voucher, and displays the beginning and end information of each transaction in the order of serial number.

[0085] Specifically, the specific steps of S600 are as follows:

[0086] S601, query the first-level account by default. There is an expand button in the account cell of the display interface. Click the button to dynamically load the balance data of the second-level account. And so on, all the account level data can be displayed step by step.

[0087] S602. When querying a designated institution, if the institution is not the last level, the balance sheet data of the subordinate institutions of the current institution can be queried in lazy loading mode by clicking the expand button.

[0088] Specifically, the specific steps of S700 are as follows:

[0089] S701, quasi-real-time and real-time access of transaction-level general ledger to peripheral system flow data;

[0090] S702, the accounting engine performs quasi-real-time analysis of the transaction flow to generate corresponding accounting entries;

[0091] S703, when the accounting engine parses the entries, it updates the PD table data of different categories in real time;

[0092] S704. Calculate report data based on PD table data at the end of the day;

[0093] S705. The multi-dimensional balance query of the ledger calculates the result data based on PM+PD.

[0094] It should be noted that, in this article, relational terms such as first and second, etc. are only used to distinguish one entity or operation from another entity or operation, and do not necessarily require or imply any such actual relationship or order between these entities or operations. Moreover, the terms "include", "comprise" or any other variants thereof are intended to cover non-exclusive inclusion, so that a process, method, article or device including a series of elements includes not only those elements, but also other elements not explicitly listed, or also includes elements inherent to such process, method, article or device.

[0095] Finally, it should be noted that the above description is only a preferred embodiment of the present invention and is not intended to limit the present invention. Although the present invention has been described in detail with reference to the aforementioned embodiments, those skilled in the art can still modify the technical solutions described in the aforementioned embodiments or replace some of the technical features therein by equivalents. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present invention shall be included in the protection scope of the present invention.

Claims

1. A method for managing and generating multi-dimensional classification reports based on detailed accounts, characterized in that: The following steps are involved: S100, ledger definition: create PD / PM tables based on the subject system and dimensions of the content recorded in the account; S200, multi-dimensional balance query of ledger: query based on parameters set in multiple dimensions; S300, display mode conversion: changing the display mode based on the number of clicks; S400, can export Excel file or Csv file based on demand; S500, can provide joint inquiry detailed vouchers, joint inquiry accounting flow and joint inquiry detailed accounts based on demand; S600, query result display: by default, it is displayed by subject level, and can be converted to display by institution level, and supports lazy loading mode; S700, report result calculation: calculate the PD table and PM table based on multi-dimensional data; S800 Account Transfer: When checking balance or transferring amount, select PD+PM corresponding to different categories according to business scenarios to calculate balance and transfer.

2. A method for managing and generating multi-dimensional classification reports based on detailed accounts according to claim 1, characterized in that: The specific steps of S100 are as follows: S101. Configure multiple sets of classifications as needed. Classifications can be defined as general ledger, taxation, and sub-accounts. Different classifications can specify different account systems. S102. Different categories can define the management and analysis dimensions of the report, as well as the priorities of different dimensions; S103. Different categories can define the organization authority, subject authority, and other data authority of this category; S104. Create a PD / PM table for this classification according to the classification code.

3. A method for managing and generating multi-dimensional classification reports based on detailed accounts according to claim 1, characterized in that: The specific steps of S200 are as follows: S201. Select the report category and a query parameter input box will pop up. You can enter the institution, account, currency, date, and dimension query conditions. The input parameters support precise query, fuzzy query, and interval query. S202: Query parameter dimensions and output parameter dimensions may be defined.

4. A method for managing and generating multi-dimensional classification reports based on detailed accounts according to claim 1, characterized in that: The specific steps of S300 are as follows: S301, when a display button is clicked, three display modes are displayed in rotation according to the number of clicks; S302, the default display is code plus name, and the code is displayed when the display button is clicked for the first time; S303. Click the second time to display the name, and click the third time to return to the code plus name.

5. According to claim 1, a method for managing and generating multi-dimensional classification reports based on detailed accounts is characterized in that: The specific steps of S400 are as follows: S401, the export button group has two sub-buttons: export Excel file and export Csv file; S402, when exporting an Excel file, calling the server side according to the query conditions to re-query all matching data to generate an Excel file and download it to the front end; S403: When exporting a CSV file, the server is called according to the query conditions to re-query all matching data to generate a CSV file and download it to the front end.

6. According to claim 1, a method for managing and generating multi-dimensional classification reports based on detailed accounts is characterized in that: The specific steps of S500 are as follows: S501, the joint query button group provides three sub-options: joint query of detailed vouchers, joint query of accounting records, and joint query of detailed accounts; S502. When you select a record and click to query the detailed voucher, the system automatically opens the detailed voucher node, selects the record dimensions including but not limited to the account, account book, and auxiliary segment, queries the detailed voucher, and displays it; S503. When you select a record and click on the joint query accounting flow, the system automatically opens the accounting flow node, selects the dimensions of the record including but not limited to the account, account book, and auxiliary segment, queries the accounting flow, and displays it; S504. When you select a record and click on the joint query detailed account, the system automatically opens the detailed account node, selects the dimensions of the record including but not limited to the account, account book, and auxiliary segment, queries the detailed voucher, and displays the beginning and end information of each transaction in the order of serial number.

7. According to claim 1, a method for managing and generating multi-dimensional classification reports based on detailed accounts is characterized in that: The specific steps of S600 are as follows: S601, query the first-level account by default. There is an expand button in the account cell of the display interface. Click the button to dynamically load the balance data of the second-level account. And so on, all the account level data can be displayed step by step. S602. When querying a designated institution, if the institution is not the last level, the balance sheet data of the subordinate institutions of the current institution can be queried through the lazy loading mode by clicking the expand button.

8. According to claim 1, a method for managing and generating multi-dimensional classification reports based on detailed accounts is characterized in that: The specific steps of S700 are as follows: S701, quasi-real-time and real-time access of transaction-level general ledger to peripheral system flow data; S702, the accounting engine performs quasi-real-time analysis of the transaction flow to generate corresponding accounting entries; S703, when the accounting engine parses the entries, it updates the PD table data of different categories in real time; S704. Calculate report data based on PD table data at the end of the day; S705. The multi-dimensional balance query of the ledger calculates the result data based on PM+PD.

Images