A method, device, equipment and medium for generating an aging analysis report of current accounts

Abstract

The present application discloses a method, device, equipment and medium for generating an aging analysis report of accounts payable and receivable, and the method comprises: obtaining an initial template of an aging analysis report of accounts payable and receivable; determining the aging analysis requirement information of accounts payable and receivable according to the aging interval field and the analysis dimension field in the initial template; establishing the association relationship between the accounts payable and receivable document information, the voucher auxiliary information and the auxiliary balance information, and generating an aging data source of accounts payable and receivable; establishing a data statistics view of the aging data source of accounts payable and receivable according to the aging analysis requirement information of accounts payable and receivable; and determining the aging data acquisition information of accounts payable and receivable according to the aging analysis requirement information of accounts payable and receivable; semantically encapsulating the aging data acquisition information of accounts payable and receivable according to the data statistics view, and generating a semantic object of the aging data acquisition information of accounts payable and receivable; determining the data acquisition formula corresponding to the aging data acquisition information of accounts payable and receivable; parsing the data acquisition formula through the semantic object, and acquiring the aging data of accounts payable and receivable, so as to generate an aging analysis report of accounts payable and receivable. The efficiency of generating the aging analysis report of accounts payable and receivable can be improved.

Description

Technical Field

[0001] The present application relates to the field of data management technology, and in particular to a method, device, equipment and medium for generating an aging analysis report of accounts receivable and payable. Background Art

[0002] Accounts receivable is an important part of corporate financial management, including accounts receivable and accounts payable. The age of an account generally refers to the length of time that a company has not yet recovered or paid out accounts receivable. According to statistics, the older the account, the higher the possibility that it will become a bad debt.

[0003] In enterprise management software, aging analysis of accounts receivable and other current accounts can clarify the company's receivables situation and extract a corresponding proportion of bad debt reserves based on the aging of the accounts, so as to truly and accurately reflect the company's financial status.

[0004] At present, with the increase of account age, the difficulty of statistics also increases accordingly. When generating the accounts receivable aging analysis report, it is difficult to improve work efficiency through the traditional manual calculation processing method. In addition, when the account age data source changes, the entire process needs to be re-executed, resulting in low efficiency in generating the accounts receivable aging analysis report. Summary of the invention

[0005] The embodiments of the present application provide a method, device, equipment and medium for generating an aging analysis report of accounts receivable and payable, which are used to solve the problem of low efficiency in generating an aging analysis report of accounts receivable and payable.

[0006] The present application embodiment adopts the following technical solutions:

[0007] On the one hand, an embodiment of the present application provides a method for generating an aging analysis report of accounts receivable and payable, the method comprising: obtaining an initial template of an aging analysis report of accounts receivable and payable; determining the aging analysis demand information of a user according to an aging interval field and an analysis dimension field in the initial template; obtaining the accounts receivable and payable document information, voucher auxiliary information and auxiliary balance information of the user, establishing an association relationship between the accounts receivable and payable document information, the voucher auxiliary information and the auxiliary balance information, and generating an aging data source of accounts receivable and payable based on the business date; establishing a data system of the accounts receivable and payable data source according to the aging analysis demand information of the accounts receivable and payable a statistical view; and according to the demand information for aging analysis of accounts receivable, determining the information for obtaining the aging of accounts receivable; the information for obtaining the aging of accounts receivable includes the fields for obtaining the aging of accounts receivable, the fields for analyzing the dimensionality of the aging of accounts receivable and the conditions for obtaining the aging of accounts receivable; according to the data statistical view, semantically encapsulating the information for obtaining the aging of accounts receivable and receivable, generating a semantic object for the information for obtaining the aging of accounts receivable and receivable; determining the formula for obtaining the information for obtaining the aging of accounts receivable and receivable; parsing the formula for obtaining the formula through the semantic object to obtain the aging of accounts receivable and receivable data in the data statistical view, and generating the aging of accounts receivable and receivable analysis report according to the aging of accounts receivable and receivable data and the initial template.

[0008] In one example, parsing the data retrieval formula through the semantic object to obtain the accounts receivable aging data in the data statistical view specifically includes: reading the data retrieval formula, parsing the data retrieval logic of the data retrieval formula through the semantic object, and determining a data query statement including the data retrieval field, the data retrieval analysis dimension field, and the data retrieval condition; querying the data statistical view through the data query statement to obtain the accounts receivable aging data.

[0009] In one example, after querying the data statistics view through the data query statement to obtain the accounts receivable aging data, the method further includes: writing the accounts receivable aging data into the data storage table of the accounts receivable aging analysis report according to the data retrieval information in the data retrieval formula and the row-column correspondence in the accounts receivable aging analysis report; generating the accounts receivable aging analysis report according to the accounts receivable aging data and the initial template specifically includes: obtaining the user's accounts receivable aging analysis report loading request, writing the accounts receivable aging data in the data storage table into the initial template, generating the accounts receivable aging analysis report, and sending the accounts receivable aging analysis report to the client.

[0010] In one example, the method of determining the data extraction formula corresponding to the data extraction information of the age of accounts receivable specifically includes: at the corresponding position of the initial template, by referencing the semantic object, selecting the data extraction field and the data extraction analysis dimension field, and setting the data extraction conditions to determine the data extraction formula corresponding to the data extraction information of the age of accounts receivable.

[0011] In one example, the information on the aging of accounts receivable is semantically encapsulated according to the data statistical view to generate a semantic object of the information on the aging of accounts receivable, specifically including: encapsulating the retrieval fields, the dimension fields and the field expressions corresponding to the retrieval conditions for different aging intervals into semantic fields according to the data statistical view; and determining the field attributes corresponding to the semantic fields to generate a semantic object of the information on the aging of accounts receivable.

[0012] In one example, the data statistics view includes aging data sources for different aging ranges. After generating the accounts receivable aging analysis report based on the aging data, the method further includes: within the aging range, if the accounts receivable document information is updated, automatically updating the accounts receivable aging data source so as to automatically update the data statistics view.

[0013] In one example, if the accounts receivable document information is updated within the aging interval, the accounts receivable aging data source is automatically updated, specifically including: determining the changed accounts receivable document information within the aging interval; sending the changed accounts receivable document information to the user; receiving feedback information from the user, and determining whether the changed accounts receivable document information is abnormal based on the feedback information; if not, automatically updating the accounts receivable aging data source.

[0014] On the other hand, an embodiment of the present application provides a device for generating an aging analysis report of accounts receivable and payable, the device comprising: a first acquisition module, which acquires an initial template of an aging analysis report of accounts receivable and payable; a first determination module, which determines the user's aging analysis demand information of accounts receivable and payable according to the aging interval field and the analysis dimension field in the initial template; a second acquisition module, which acquires the user's accounts receivable and payable document information, voucher auxiliary information and auxiliary balance information, establishes an association relationship between the accounts receivable and payable document information, the voucher auxiliary information and the auxiliary balance information, and generates an aging data source based on the business date; an establishment module, which establishes the accounts receivable and payable data source according to the aging analysis demand information of the accounts receivable and payable a data statistical view of the data source; and determining the information on aging of accounts receivable based on the demand information for aging analysis of accounts receivable; the information on aging of accounts receivable includes aging fields, dimensional fields for aging analysis and aging conditions for different aging intervals; an encapsulation module, according to the data statistical view, semantically encapsulates the aging of accounts receivable information and generates a semantic object for the aging of accounts receivable information; a second determination module, determining the aging formula corresponding to the aging of accounts receivable information; a parsing module, parsing the aging formula through the semantic object to obtain the aging of accounts receivable data in the data statistical view, and generating the aging of accounts receivable analysis report based on the aging of accounts receivable data and the initial template.

[0015] On the other hand, an embodiment of the present application provides a device for generating an aging analysis report of accounts receivable and payable, the device comprising: at least one processor; and a memory communicatively connected to the at least one processor; wherein the memory stores instructions executable by the at least one processor, the instructions being executed by the at least one processor so that the at least one processor can: obtain an initial template for an aging analysis report of accounts receivable and payable; determine the user's aging analysis demand information of accounts receivable and payable based on the aging interval field and analysis dimension field in the initial template; obtain the user's accounts receivable and payable document information, voucher auxiliary information and auxiliary balance information, establish an association relationship between the accounts receivable and payable document information, the voucher auxiliary information and the auxiliary balance information, and Based on the date, generate an age data source of accounts receivable; according to the age analysis demand information of accounts receivable, establish a data statistical view of the age data source of accounts receivable; and according to the age analysis demand information of accounts receivable, determine the age data acquisition information of accounts receivable; the age data acquisition information of accounts receivable includes the acquisition fields, acquisition analysis dimension fields and acquisition conditions of different age intervals; according to the data statistical view, semantically encapsulate the age data acquisition information of accounts receivable, and generate the semantic object of the age data acquisition information of accounts receivable; determine the acquisition formula corresponding to the age data acquisition information of accounts receivable; parse the acquisition formula through the semantic object to obtain the age data of accounts receivable in the data statistical view, and generate the age analysis report of accounts receivable according to the age data of accounts receivable and the initial template.

[0016] On the other hand, an embodiment of the present application provides a non-volatile computer storage medium for generating an aging analysis report of accounts receivable and payable, storing computer executable instructions, wherein the computer executable instructions are configured to: obtain an initial template for an aging analysis report of accounts receivable and payable; determine the aging analysis demand information of a user according to an aging interval field and an analysis dimension field in the initial template; obtain the accounts receivable and payable document information, voucher auxiliary information, and auxiliary balance information of the user, establish an association relationship between the accounts receivable and payable document information, the voucher auxiliary information, and the auxiliary balance information, and generate an aging data source of accounts receivable and payable based on the business date; according to the aging analysis demand information of accounts receivable and payable, Establish a data statistical view of the accounts receivable age data source; and determine the accounts receivable age data acquisition information based on the accounts receivable age analysis demand information; the accounts receivable age data acquisition information includes acquisition fields, acquisition analysis dimension fields and acquisition conditions for different account age intervals; according to the data statistical view, semantically encapsulate the accounts receivable age data acquisition information to generate a semantic object for the accounts receivable age data acquisition information; determine the data acquisition formula corresponding to the accounts receivable age data acquisition information; parse the data acquisition formula through the semantic object to obtain the accounts receivable age data in the data statistical view, and generate the accounts receivable age analysis report based on the accounts receivable age data and the initial template.

[0017] At least one of the above technical solutions adopted in the embodiments of the present application can achieve the following beneficial effects:

[0018] By parsing the data extraction formula through semantic objects, the accounts receivable aging data in the data statistics view is obtained. According to the accounts receivable aging data and the initial template, the accounts receivable aging analysis report is generated to achieve automatic generation of accounts receivable aging analysis report, which can effectively reduce the difficulty of implementing accounts receivable aging analysis and improve the generation efficiency of accounts receivable aging analysis report.

[0019] Furthermore, by establishing an association between accounts receivable document information, voucher auxiliary information and auxiliary balance information, relevant accounts receivable aging data can be updated in real time according to changes in document information, further improving the efficiency of generating accounts receivable aging analysis reports. BRIEF DESCRIPTION OF THE DRAWINGS

[0020] In order to more clearly illustrate the technical solution of the present application, some embodiments of the present application will be described in detail below in conjunction with the accompanying drawings, in which:

[0021] Figure 1 A flowchart of a method for generating an aging analysis report of accounts receivable and payable provided in an embodiment of the present application;

[0022] Figure 2 A schematic diagram of setting a data acquisition formula provided in an embodiment of the present application;

[0023] Figure 3 A schematic diagram of the structure of a device for generating an aging analysis report for current accounts receivable provided in an embodiment of the present application;

[0024] Figure 4 A schematic diagram of the structure of a device for generating an aging analysis report of accounts receivable and payable provided in an embodiment of the present application. DETAILED DESCRIPTION

[0025] In order to make the purpose, technical solution and advantages of the present application clearer, the technical solution of the present application will be clearly and completely described below in conjunction with specific embodiments and corresponding drawings. Obviously, the described embodiments are only part of the embodiments of the present application, not all of the embodiments. Based on the embodiments in the present application, all other embodiments obtained by ordinary technicians in the field without creative work are within the scope of protection of the present application.

[0026] Some embodiments of the present application are described in detail below with reference to the accompanying drawings.

[0027] Figure 1 A schematic diagram of a flow chart of a method for generating an aging analysis report of accounts receivable provided in an embodiment of the present application. Certain input parameters or intermediate results in the process allow manual intervention and adjustment to help improve accuracy.

[0028] The analysis method involved in the embodiments of the present application can be implemented by a terminal device or a server, and the present application does not impose any special restrictions on this. For the convenience of understanding and description, the following embodiments are described in detail by taking a server as an example.

[0029] It should be noted that the server may be a single device or a system consisting of multiple devices, that is, a distributed server, and this application does not make any specific limitation on this.

[0030] Figure 1 The process in may include the following steps:

[0031] S101: Obtain an initial template for an aging analysis report of accounts receivable.

[0032] In some embodiments of the present application, developers pre-set the initial template of the accounts receivable aging analysis report on the server through the financial report tool according to the needs of users, and set the format of the accounts receivable aging analysis report. Among them, the initial template includes an aging interval field and an analysis dimension field. For example, the aging interval field is 0-6 months, 7-12 months, 1-2 years, etc., and the analysis dimension field is the analysis dimension of the accounts receivable unit, total receivables, project, contract, department, etc., which can realize multi-dimensional analysis. Among them, the dimension and aging interval columns are set in the report change row to display data of multiple accounts receivable units and statistical dimensions.

[0033] S102: Determine the user's account aging analysis requirement information according to the account aging interval field and the analysis dimension field in the initial template.

[0034] In some embodiments of the present application, since the developer sets the initial template based on the needs of the user, the server can extract the current user's account aging analysis demand information through the initial template information. In other words, the account aging demand information refers to the account aging data of the user that needs to be understood in which aging intervals and which analysis dimensions.

[0035] S103: Acquire the user's transaction document information, voucher auxiliary information and auxiliary balance information, establish an association relationship between the transaction document information, the voucher auxiliary information and the auxiliary balance information, and generate a transaction aging data source based on the transaction date.

[0036] In some embodiments of the present application, all historical business data involved in the accounts receivable aging analysis report can realize the data input of analysis dimensions such as the accounts receivable aging, business date and amount through the initial entry function of the accounts receivable document. The accounts receivable aging data of the current period (non-historical business data) can realize the data entry of analysis dimensions such as the accounts receivable aging, business date and amount through the auxiliary information of the accounting voucher.

[0037] Since the user's account receivable document information is changing, in order to obtain the changed account receivable document information in time, the account receivable document information, voucher auxiliary information and auxiliary balance information are associated, so that the user's actual account receivable age data can be understood in time, that is, the user's actual account receivable amount can be understood in time.

[0038] S104: According to the demand information for aging analysis of accounts receivable, a data statistical view of the data source of the aging of accounts receivable is established; and according to the demand information for aging analysis of accounts receivable, information for obtaining data of aging of accounts receivable is determined; the information for obtaining data of aging of accounts receivable includes fields for obtaining data of different aging intervals, fields for obtaining data of analysis dimensions, and conditions for obtaining data. The information for obtaining data of aging of accounts receivable is used to provide a basis for extracting corresponding aging data from the data statistical view.

[0039] In some embodiments of the present application, the data statistics view is a transformation of the original database data and another way to view the data in the table. We can regard the view as a moving window from which we can see the data of interest.

[0040] Therefore, the server reorganizes the aging data source and establishes a data statistical view of the accounts receivable aging data source to meet the user's needs for accounts receivable aging analysis. For example, a data statistical view with different aging ranges, different accounts receivable units and periods as dimensions is established, which can flexibly organize the accounts receivable document information and auxiliary balance information together, and organize and classify the information according to different years and periods.

[0041] S105: According to the data statistics view, semantically encapsulate the information on the aging of the accounts receivable and payable, and generate a semantic object of the information on the aging of the accounts receivable and payable.

[0042] In some embodiments of the present application, the server will encapsulate the field expressions corresponding to the retrieval fields, dimension fields and retrieval conditions of different account age intervals into semantic fields based on the data statistics view, and then determine the field attributes corresponding to the semantic fields, complete the expression and field attribute settings of the semantic fields, so as to generate the semantic objects of the aging retrieval information of the accounts receivable and payable. Through the setting of the semantic fields, the flexible expansion of the account age retrieval fields in the account age intervals and the on-demand setting of the dimension fields and retrieval condition fields are realized, thereby realizing the flexible expansion of the account age intervals, providing a customized description for the retrieval formula setting, and establishing the basis and standards for the retrieval formula.

[0043] S106: Determine the formula for extracting data corresponding to the information on extracting data of the current account age, wherein the formula for extracting data refers to selecting a value within a specific range.

[0044] In some embodiments of the present application, at the corresponding position of the initial template, by referencing the semantic object, selecting the data field and the data analysis dimension field, and setting the data conditions, the data formula corresponding to the data information of the current account age can be determined. By defining the data formula, the logic of data acquisition of the current account age can be flexibly configured.

[0045] More intuitively, Figure 2 A schematic diagram of setting a data acquisition formula provided in an embodiment of the present application.

[0046] exist Figure 2 In the example, the data retrieval object (semantic object) is set to General for retrieval of accounts payable age, the data retrieval field is Borrowing direction, the analysis dimension fields include Accounts payable unit number, Accounts payable unit name, Total aging amount, and Accounts aging interval is within 6 months. The data retrieval conditions are shown in the figure and will not be described further.

[0047] S107: parsing the data extraction formula through the semantic object to obtain the accounts receivable aging data in the data statistics view, and generating the accounts receivable aging analysis report according to the accounts receivable aging data and the initial template.

[0048] In some embodiments of the present application, the server activates and calls the data retrieval formula parsing engine, reads the data retrieval formula through the data retrieval formula parsing engine, parses the data retrieval logic of the data retrieval formula through semantic objects, determines the data query statement including the data retrieval field, the data retrieval analysis dimension field and the data retrieval condition, queries the data statistical view through the data query statement, and obtains the accounts receivable and payable aging data.

[0049] Furthermore, the server writes the accounts receivable aging data into the data storage table of the accounts receivable aging analysis report according to the data extraction information in the data extraction formula and the corresponding relationship between the rows and columns in the accounts receivable aging analysis report.

[0050] When generating an aging analysis report for current accounts payable, obtain the user's request to load the aging analysis report for current accounts payable, write the aging data of current accounts payable in the data storage table into the initial template, generate an aging analysis report for current accounts payable, and send the aging analysis report for current accounts payable to the client, so that it can be displayed and output in the client table. It also provides auxiliary functions such as export and printing.

[0051] In some embodiments of the present application, since the association relationship between the accounts receivable and payable document information, the voucher auxiliary information and the auxiliary balance information is pre-established, after generating the accounts receivable and payable aging analysis report, within the aging interval, if the accounts receivable and payable document information is updated, the accounts receivable and payable aging data source is automatically updated so as to automatically update the data statistics view.

[0052] It is possible to set up data statistics views and monitor changes in account documents with the same age in real time through flexible age ranges, and update relevant account age data in real time according to changes in the document information, so as to effectively improve the efficiency of generating account age analysis reports.

[0053] Furthermore, in order to ensure the credibility of the changed information of the accounts receivable and payable, the changed information of the accounts receivable and payable is determined within the account age range, the changed information of the accounts receivable and payable is sent to the user, and the user's feedback information is received. It is determined whether the changed information of the accounts receivable and payable is abnormal based on the feedback information. If not, the accounts receivable and payable aging data source is automatically updated. If so, the updating of the accounts receivable and payable aging data source is stopped.

[0054] pass Figure 1 The method uses semantic object parsing and data extraction formula to obtain the accounts receivable aging data in the data statistics view, and generates an accounts receivable aging analysis report based on the accounts receivable aging data and the initial template, so as to achieve automatic generation of accounts receivable aging analysis report, which can effectively reduce the difficulty of implementing accounts receivable aging analysis and improve the generation efficiency of accounts receivable aging analysis report.

[0055] Furthermore, by establishing an association between the accounts receivable document information, the voucher auxiliary information and the auxiliary balance information, the relevant accounts receivable aging data can be updated in real time according to the changes in the document information, thereby further improving the efficiency of generating the accounts receivable aging analysis report.

[0056] It should be noted that although the embodiments of the present application are based on Figure 1 Steps S101 to S107 are described in sequence, but this does not mean that steps S101 to S107 must be performed in a strict order. Figure 1 The order shown in the figure is to introduce and explain step S101 to step S107 in sequence, in order to facilitate those skilled in the art to understand the technical solution of the embodiment of the present application. In other words, in the embodiment of the present application, the order between step S101 to step S107 can be appropriately adjusted according to actual needs.

[0057] Based on the same idea, some embodiments of the present application also provide devices, equipment and non-volatile computer storage media corresponding to the above method.

[0058] Figure 3 A schematic diagram of a structure of a device for generating an aging analysis report of current accounts provided in an embodiment of the present application, the device comprising:

[0059] The first acquisition module 301 acquires an initial template of an aging analysis report of current accounts receivable;

[0060] A first determination module 302 determines the user's account aging analysis requirement information according to the account aging interval field and the analysis dimension field in the initial template;

[0061] The second acquisition module 303 acquires the user's transaction document information, voucher auxiliary information and auxiliary balance information, establishes an association relationship between the transaction document information, the voucher auxiliary information and the auxiliary balance information, and generates a transaction aging data source based on the transaction date;

[0062] Establishing module 304, establishing a data statistical view of the accounts receivable and payable aging data source according to the accounts receivable and payable aging analysis demand information; and determining accounts receivable and payable aging data acquisition information according to the accounts receivable and payable aging analysis demand information; the accounts receivable and payable aging data acquisition information includes acquisition fields of different aging intervals, acquisition analysis dimension fields and acquisition conditions;

[0063] The encapsulation module 305 performs semantic encapsulation on the aging data of the accounts receivable and payable information according to the data statistical view, and generates a semantic object of the aging data of the accounts receivable and payable information;

[0064] The second determination module 306 determines the data extraction formula corresponding to the data extraction information of the current account age;

[0065] The parsing module 307 parses the data extraction formula through the semantic object to obtain the accounts receivable aging data in the data statistics view, and generates the accounts receivable aging analysis report according to the accounts receivable aging data and the initial template.

[0066] Figure 4 A schematic diagram of a device for generating an aging analysis report of current accounts provided in an embodiment of the present application, the device comprising:

[0067] at least one processor; and,

[0068] a memory communicatively connected to the at least one processor; wherein,

[0069] The memory stores instructions executable by the at least one processor, the instructions being executed by the at least one processor to enable the at least one processor to:

[0070] Get the initial template of the Accounts Receivable and Payable aging analysis report;

[0071] Determine the user's account aging analysis requirement information according to the account aging interval field and the analysis dimension field in the initial template;

[0072] Acquire the user's transaction document information, voucher auxiliary information and auxiliary balance information, establish an association relationship between the transaction document information, the voucher auxiliary information and the auxiliary balance information, and generate a transaction account aging data source based on the transaction date;

[0073] According to the demand information for aging analysis of accounts receivable, a data statistical view of the data source for aging of accounts receivable is established; and according to the demand information for aging analysis of accounts receivable, information for obtaining data for aging of accounts receivable is determined; the information for obtaining data for aging of accounts receivable includes fields for obtaining data of different aging intervals, fields for obtaining data analysis dimensions, and conditions for obtaining data;

[0074] According to the data statistics view, the information on the aging of the accounts receivable and payable is semantically encapsulated to generate a semantic object of the information on the aging of the accounts receivable and payable;

[0075] Determine the data extraction formula corresponding to the data extraction information of the current account age;

[0076] The data extraction formula is parsed through the semantic object to obtain the accounts receivable aging data in the data statistics view, and the accounts receivable aging analysis report is generated based on the accounts receivable aging data and the initial template.

[0077] Some embodiments of the present application provide a non-volatile computer storage medium for generating an aging analysis report of accounts receivable and payable, storing computer executable instructions, wherein the computer executable instructions are configured to:

[0078] Get the initial template of the Accounts Receivable and Payable aging analysis report;

[0079] Determine the user's account aging analysis requirement information according to the account aging interval field and the analysis dimension field in the initial template;

[0080] Acquire the user's transaction document information, voucher auxiliary information and auxiliary balance information, establish an association relationship between the transaction document information, the voucher auxiliary information and the auxiliary balance information, and generate a transaction account aging data source based on the transaction date;

[0081] According to the demand information for aging analysis of accounts receivable, a data statistical view of the data source for aging of accounts receivable is established; and according to the demand information for aging analysis of accounts receivable, information for obtaining data for aging of accounts receivable is determined; the information for obtaining data for aging of accounts receivable includes fields for obtaining data of different aging intervals, fields for obtaining data analysis dimensions, and conditions for obtaining data;

[0082] According to the data statistics view, the information on the aging of the accounts receivable and payable is semantically encapsulated to generate a semantic object of the information on the aging of the accounts receivable and payable;

[0083] Determine the data extraction formula corresponding to the data extraction information of the current account age;

[0084] The data extraction formula is parsed through the semantic object to obtain the accounts receivable aging data in the data statistics view, and the accounts receivable aging analysis report is generated based on the accounts receivable aging data and the initial template.

[0085] Each embodiment in this application is described in a progressive manner, and the same or similar parts between the embodiments can be referred to each other, and each embodiment focuses on the differences from other embodiments. In particular, for the device, equipment and medium embodiments, since they are basically similar to the method embodiments, the description is relatively simple, and the relevant parts can be referred to the partial description of the method embodiment.

[0086] The apparatus, equipment and medium provided in the embodiments of the present application correspond one-to-one to the method. Therefore, the apparatus, equipment and medium also have similar beneficial technical effects as the corresponding methods. Since the beneficial technical effects of the methods have been described in detail above, the beneficial technical effects of the apparatus, equipment and medium will not be repeated here.

[0087] Those skilled in the art will appreciate that embodiments of the present invention may be provided as methods, systems, or computer program products. Therefore, the present invention may take the form of a complete hardware embodiment, a complete software embodiment, or an embodiment combining software and hardware. Moreover, the present invention may take the form of a computer program product implemented on one or more computer-usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) containing computer-usable program code.

[0088] The present invention is described with reference to flowcharts and / or block diagrams of methods, devices (systems), and computer program products according to embodiments of the present invention. It should be understood that each process and / or block in the flowchart and / or block diagram, as well as the combination of processes and / or blocks in the flowchart and / or block diagram, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, a special-purpose computer, an embedded processor, or other programmable data processing device to produce a machine, so that the instructions executed by the processor of the computer or other programmable data processing device generate instructions for implementing the processes in the flowchart and / or block diagram. Figure 1 A process or multiple processes and / or boxes Figure 1 A device that provides the functions specified in a block or multiple blocks.

[0089] These computer program instructions may also be stored in a computer-readable memory capable of directing a computer or other programmable data processing device to operate in a specific manner, so that the instructions stored in the computer-readable memory produce an article of manufacture comprising an instruction device, which implements the process Figure 1 A process or multiple processes and / or boxes Figure 1A function specified in one or more boxes.

[0090] These computer program instructions can also be loaded onto a computer or other programmable data processing device so that a series of operating steps are executed on the computer or other programmable device to produce a computer-implemented process, thereby providing instructions for implementing the process. Figure 1 A process or multiple processes and / or boxes Figure 1 The steps for the functions specified in one or more boxes.

[0091] In a typical configuration, a computing device includes one or more processors (CPU), input / output interfaces, network interfaces, and memory.

[0092] The memory may include non-permanent storage in a computer-readable medium, random access memory (RAM) and / or non-volatile memory in the form of read-only memory (ROM) or flash RAM. The memory is an example of a computer-readable medium.

[0093] Computer readable media include permanent and non-permanent, removable and non-removable media that can be implemented by any method or technology to store information. Information can be computer readable instructions, data structures, program modules or other data. Examples of computer storage media include, but are not limited to, phase change memory (PRAM), static random access memory (SRAM), dynamic random access memory (DRAM), other types of random access memory (RAM), read-only memory (ROM), electrically erasable programmable read-only memory (EEPROM), flash memory or other memory technology, compact disk read-only memory (CD-ROM), digital versatile disk (DVD) or other optical storage, magnetic cassettes, magnetic tape magnetic disk storage or other magnetic storage devices or any other non-transmission media that can be used to store information that can be accessed by a computing device. As defined herein, computer readable media does not include temporary computer readable media (transitory media), such as modulated data signals and carrier waves.

[0094] It should also be noted that the terms "include", "comprises" or any other variations thereof are intended to cover non-exclusive inclusion, so that a process, method, commodity 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, commodity or device. In the absence of more restrictions, the elements defined by the sentence "comprises a ..." do not exclude the existence of other identical elements in the process, method, commodity or device including the elements.

[0095] The above is only an embodiment of the present application and is not intended to limit the present application. For those skilled in the art, the present application may have various changes and variations. Any modification, equivalent replacement, improvement, etc. made within the technical principle of the present application should all fall within the protection scope of the present application.

Claims

1. A method for generating an aging analysis report of current accounts receivable and payable, It is characterized in that The method comprises: Get the initial template of the Accounts Receivable and Payable aging analysis report; Determine the user's account aging analysis requirement information according to the account aging interval field and the analysis dimension field in the initial template; Acquire the user's transaction document information, voucher auxiliary information and auxiliary balance information, establish an association relationship between the transaction document information, the voucher auxiliary information and the auxiliary balance information, and generate a transaction account aging data source based on the transaction date; According to the demand information for aging analysis of accounts receivable, a data statistical view of the data source for aging of accounts receivable is established; and according to the demand information for aging analysis of accounts receivable, information for obtaining data for aging of accounts receivable is determined; the information for obtaining data for aging of accounts receivable includes fields for obtaining data of different aging intervals, fields for obtaining data analysis dimensions, and conditions for obtaining data; According to the data statistics view, the information on the aging of the accounts receivable and payable is semantically encapsulated to generate a semantic object of the information on the aging of the accounts receivable and payable; Determine the data extraction formula corresponding to the data extraction information of the current account age; The data extraction formula is parsed through the semantic object to obtain the accounts receivable aging data in the data statistics view, and the accounts receivable aging analysis report is generated based on the accounts receivable aging data and the initial template.

2. The method according to claim 1, It is characterized in that The step of parsing the data extraction formula through the semantic object to obtain the current account age data in the data statistics view specifically includes: Read the data acquisition formula, parse the data acquisition logic of the data acquisition formula through the semantic object, and determine a data query statement including the data acquisition field, the data acquisition analysis dimension field, and the data acquisition condition; The data statistical view is queried through the data query statement to obtain the accounts receivable and payable aging data.

3. The method according to claim 2, It is characterized in that After querying the data statistical view through the data query statement to obtain the account aging data, the method further includes: According to the data extraction information in the data extraction formula and the row-column correspondence in the accounts receivable and payable aging analysis report, the accounts receivable and payable aging data is written into the data storage table of the accounts receivable and payable aging analysis report; The generating the accounts receivable aging analysis report according to the accounts receivable aging data and the initial template specifically includes: Obtain the user's request to load the accounts receivable aging analysis report, write the accounts receivable aging data in the data storage table into the initial template, generate the accounts receivable aging analysis report, and send the accounts receivable aging analysis report to the client.

4. The method according to claim 1, It is characterized in that The formula for determining the corresponding information on the aging of accounts receivable and payable specifically includes: At the corresponding position of the initial template, by referencing the semantic object, selecting the data retrieval field and the data retrieval analysis dimension field, and setting the data retrieval condition, the data retrieval formula corresponding to the data retrieval information of the accounts receivable age is determined.

5. The method according to claim 1, It is characterized in that The step of semantically encapsulating the information on the aging of accounts payable and receivable according to the data statistics view to generate a semantic object of the information on the aging of accounts payable and receivable specifically includes: According to the data statistics view, the number fields of different account age intervals, the dimension fields, and field expressions corresponding to the number-taking conditions are encapsulated as semantic fields; Determine the field attribute corresponding to the semantic field to generate the semantic object of the accounts receivable aging data acquisition information.

6. The method according to claim 1, It is characterized in that The data statistics view includes aging data sources of different aging intervals. After generating the current account aging analysis report according to the aging data, the method further includes: Within the aging interval, if the account receivable document information is updated, the account receivable aging data source is automatically updated so as to automatically update the data statistics view.

7. The method according to claim 6, It is characterized in that Within the aging interval, if the account-receivable document information is updated, the account-receivable aging data source is automatically updated, specifically including: Determine the transaction document information that has changed within the aging range; Sending the changed transaction document information to the user; receiving feedback information from the user, and determining whether the changed transaction document information is abnormal according to the feedback information; If not, the accounts receivable aging data source is automatically updated.

8. A device for generating an aging analysis report of current accounts receivable and payable, It is characterized in that The device comprises: The first acquisition module acquires the initial template of the current account aging analysis report; A first determination module determines the user's account aging analysis requirement information according to the account aging interval field and the analysis dimension field in the initial template; The second acquisition module acquires the user's transaction document information, voucher auxiliary information and auxiliary balance information, establishes an association relationship between the transaction document information, the voucher auxiliary information and the auxiliary balance information, and generates a transaction aging data source based on the transaction date; Establishing a module, establishing a data statistical view of the accounts receivable and payable aging data source according to the accounts receivable and payable aging analysis demand information; and determining accounts receivable and payable aging data acquisition information according to the accounts receivable and payable aging analysis demand information; the accounts receivable and payable aging data acquisition information includes acquisition fields of different aging intervals, acquisition analysis dimension fields and acquisition conditions; An encapsulation module, which performs semantic encapsulation on the information on the aging of accounts payable and receivable according to the data statistical view, and generates a semantic object for the information on the aging of accounts payable and receivable; A second determination module determines a formula for obtaining data corresponding to the information on the age of current accounts receivable; The parsing module parses the data extraction formula through the semantic object to obtain the accounts receivable aging data in the data statistics view, and generates the accounts receivable aging analysis report according to the accounts receivable aging data and the initial template.

9. A device for generating an aging analysis report of current accounts receivable, It is characterized in that The device comprises: at least one processor; and, a memory communicatively connected to the at least one processor; wherein, The memory stores instructions executable by the at least one processor, the instructions being executed by the at least one processor to enable the at least one processor to: Get the initial template of the Accounts Receivable and Payable aging analysis report; Determine the user's account aging analysis requirement information according to the account aging interval field and the analysis dimension field in the initial template; Acquire the user's transaction document information, voucher auxiliary information and auxiliary balance information, establish an association relationship between the transaction document information, the voucher auxiliary information and the auxiliary balance information, and generate a transaction account aging data source based on the transaction date; According to the demand information for aging analysis of accounts receivable, a data statistical view of the data source for aging of accounts receivable is established; and according to the demand information for aging analysis of accounts receivable, information for obtaining data for aging of accounts receivable is determined; the information for obtaining data for aging of accounts receivable includes fields for obtaining data of different aging intervals, fields for obtaining data analysis dimensions, and conditions for obtaining data; According to the data statistics view, the information on the aging of the accounts receivable and payable is semantically encapsulated to generate a semantic object of the information on the aging of the accounts receivable and payable; Determine the data extraction formula corresponding to the data extraction information of the current account age; The data extraction formula is parsed through the semantic object to obtain the accounts receivable aging data in the data statistics view, and the accounts receivable aging analysis report is generated based on the accounts receivable aging data and the initial template.

10. A non-volatile computer storage medium for generating an aging analysis report of current accounts payable, storing computer executable instructions, It is characterized in that The computer executable instructions are configured to: Get the initial template of the Accounts Receivable and Payable aging analysis report; Determine the user's account aging analysis requirement information according to the account aging interval field and the analysis dimension field in the initial template; Acquire the user's transaction document information, voucher auxiliary information and auxiliary balance information, establish an association relationship between the transaction document information, the voucher auxiliary information and the auxiliary balance information, and generate a transaction account aging data source based on the transaction date; According to the account aging analysis requirement information, a data statistics view of the account aging data source is established; and determining the data acquisition information of the aging of accounts receivable and payable according to the demand information of the aging analysis of accounts receivable and payable; the data acquisition information of the aging of accounts receivable and payable includes the data acquisition fields of different aging intervals, the data acquisition analysis dimension fields and the data acquisition conditions; According to the data statistics view, the information on the aging of the accounts receivable and payable is semantically encapsulated to generate a semantic object of the information on the aging of the accounts receivable and payable; Determine the data extraction formula corresponding to the data extraction information of the current account age; The data extraction formula is parsed through the semantic object to obtain the accounts receivable aging data in the data statistics view, and the accounts receivable aging analysis report is generated based on the accounts receivable aging data and the initial template.

Images