Business report generation method, electronic device and storage medium

Abstract

The present invention discloses a business report generation method, an electronic device and a storage medium, which are used to solve the technical problem that the existing method of generating business reports through calculation views occupies a large amount of memory and easily causes system freeze or dump. The present invention comprises: receiving a deadline for a preset target business input by a user; obtaining a calculation view framework corresponding to the target business; obtaining business data based on the deadline and the calculation view framework, and extracting at least one business data table from the business data; generating a business report of the business data based on the business data table.

Description

Technical Field

[0001] The present invention relates to the technical field of report generation, and in particular to a business report generation method, electronic equipment and storage medium. Background Art

[0002] HANA (High-Performance Analytic Appliance) is a combination of software and hardware that enables enterprises to analyze business operations based on a large amount of ever-changing detailed information. Users can browse and analyze business transaction data from any data source. When business occurs, these transaction data will be synchronized to HANA's in-memory database, and users can use very flexible views to present the information results of these analyses. Based on HANA, enterprises can analyze the operation of the business based on a large amount of detailed information during business operations, and can also explore and analyze transaction data and analytical data from all data sources. Operational data can be obtained in memory as it is generated, and corresponding business reports can be generated in real time through flexible views to present analytical information to users.

[0003] However, HANA stipulates that the upper limit of memory for each calculation view is 50GB. Once the view exceeds this limit, the view will be dumped (also known as dump) to protect the effective occupancy of system memory and avoid system freezes or even dumps.

[0004] At present, a commonly used method is to implement logic by writing statements to break the memory limit of a single calculation view. Although there is no memory limit for writing statements, it will still occupy the required memory. If the logic is complex and the amount of data is large, it will still occupy a large amount of system memory, causing system freezes or dumps. Summary of the invention

[0005] The present invention provides a business report generation method, an electronic device and a storage medium, which are used to solve the technical problem that the existing method of generating business reports by calculating views occupies a large amount of memory and easily causes system freeze or dump.

[0006] The present invention provides a method for generating a business report, comprising:

[0007] Receiving a deadline for a preset target business input by a user;

[0008] Obtaining a calculation view framework corresponding to the target business;

[0009] Acquire business data based on the deadline and the calculation view framework, and extract at least one business data table from the business data;

[0010] A business report of the business data is generated based on the business data table.

[0011] Optionally, the step of generating a business report of the business data based on the business data table includes:

[0012] When the target business is an accounts receivable business, using the business data table to generate financial accounts receivable information of at least one customer;

[0013] Acquire the base currency information of the financial accounts receivable information, and generate first associated data by combining the base currency information and the financial accounts receivable information;

[0014] Calculate the aging information of the financial accounts receivable information based on the first associated data, and generate second associated data by combining the aging information and the first associated data;

[0015] acquiring exchange rate information of the financial accounts receivable information based on the second associated data, and obtaining third associated data by combining the exchange rate information and the second associated data;

[0016] Calculate the base currency amount of the unpaid items of the financial accounts receivable information based on the third associated data, and generate fourth associated data by combining the base currency amount of the unpaid items and the third associated data;

[0017] Acquire customer information based on the fourth associated data, and generate fifth associated data by combining the customer information and the fourth associated data;

[0018] A business report is generated based on the fifth associated data.

[0019] Optionally, the step of using the business data table to generate financial accounts receivable information of at least one customer includes:

[0020] Obtaining the prepayment target data table, the financial actual receipt data table and the financial master data table from the business data table;

[0021] Matching the actual financial data table with the financial master data table to obtain actual financial business data;

[0022] The actual financial business data and the prepayment target data table are matched to generate financial accounts receivable information of at least one customer.

[0023] Optionally, the step of acquiring the base currency information of the financial accounts receivable information and generating the first associated data by combining the base currency information and the financial accounts receivable information includes:

[0024] Extracting the pre-stored table of base currency information from the business data table;

[0025] Matching the functional currency information of the financial accounts receivable information in the functional currency information pre-stored table;

[0026] The base currency information and the financial accounts receivable information are associated to generate first associated data.

[0027] Optionally, the step of calculating the aging information of the financial accounts receivable information based on the first associated data, and generating second associated data by combining the aging information and the first associated data includes:

[0028] Extracting a financial data table from the business data table;

[0029] Extracting the payment start date and payment due date of the financial accounts receivable information from the financial data table;

[0030] Matching the payment start date and the payment due date in the first associated data to generate aging information of the financial accounts receivable information;

[0031] The account aging information and the first associated data are associated to generate second associated data.

[0032] Optionally, the step of acquiring the exchange rate information of the financial accounts receivable information based on the second associated data, and obtaining third associated data by combining the exchange rate information and the second associated data includes:

[0033] Obtaining an exchange rate table, a currency table and an exchange rate factor table from the business data table;

[0034] Matching the second associated data with the exchange rate table to obtain exchange rate data of the financial accounts receivable information, and associating the second associated data with the exchange rate data to generate sixth associated data;

[0035] Matching the sixth associated data with the currency table to obtain currency information of the financial accounts receivable information, and associating the currency information with the sixth associated data to generate seventh associated data;

[0036] Matching the seventh associated data with the exchange rate factor table to obtain exchange rate factor information of the financial accounts receivable information;

[0037] Generate exchange rate information of the financial accounts receivable information using the exchange rate data, the currency information and the exchange rate factor information;

[0038] The exchange rate information and the second related data are associated with each other to generate third related data.

[0039] Optionally, the step of calculating the base currency amount of the unpaid items of the financial accounts receivable information based on the third associated data, and generating fourth associated data in combination with the base currency amount of the unpaid items and the third associated data includes:

[0040] Extract the original currency amount of the unpaid items corresponding to the financial accounts receivable information;

[0041] Calculating the base currency amount of the unpaid item corresponding to the financial account information by using the third associated data and the original currency amount of the unpaid item;

[0042] The base currency amount of the unpaid item is associated with the third associated data to generate fourth associated data.

[0043] Optionally, the step of acquiring customer information based on the fourth associated data, and generating fifth associated data by combining the customer information and the fourth associated data includes:

[0044] Acquire customer attribute information and customer consumption information of each customer from the business data table;

[0045] The customer attribute information, the customer consumption information and the fourth associated data are associated to generate fifth associated data.

[0046] The present invention also provides an electronic device, the device comprising a processor and a memory:

[0047] The memory is used to store program code and transmit the program code to the processor;

[0048] The processor is used to execute the business report generation method as described in any one of the above items according to the instructions in the program code.

[0049] The present invention also provides a computer-readable storage medium, wherein the computer-readable storage medium is used to store program code, and the program code is used to execute the business report generation method as described in any one of the above items.

[0050] It can be seen from the above technical scheme that the present invention has the following advantages: the present invention receives the deadline for the preset target business input by the user to determine the required calculation view framework according to the selected target business, thereby obtaining the corresponding business data according to the calculation view framework and deadline corresponding to the current target business, and extracts at least one business data table from a large amount of business data of the target business, and uses multiple business data tables to participate in the business process of processing the target business respectively, and decomposes the overall business process of the target business into multiple stages for data processing, which can not only alleviate the calculation pressure of processing the overall business data of the target business, but also realize the efficient controllability of each data processing stage, reduce the amount of data involved in a single calculation, thereby reducing the memory usage in the process of generating the calculation view for the target business, ensuring the smoothness of business report generation, and avoiding the processing system jam or dump of the target business. BRIEF DESCRIPTION OF THE DRAWINGS

[0051] 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 of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative labor.

[0052] Figure 1 A flowchart of a method for generating a business report according to an embodiment of the present invention;

[0053] Figure 2 A flowchart of a method for generating a business report according to another embodiment of the present invention;

[0054] Figure 3 A schematic diagram of a calculation view of a method for generating a business report provided by an embodiment of the present invention;

[0055] Figure 4 A structural block diagram of a business report generation device provided by an embodiment of the present invention. DETAILED DESCRIPTION

[0056] The embodiments of the present invention provide a business report generation method, an electronic device and a storage medium, which are used to solve the technical problem that the existing method of generating business reports by calculating views occupies a large amount of memory and easily causes system freeze or dump.

[0057] In order to make the purpose, features and advantages of the present invention more obvious and easy to understand, the technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the embodiments described below 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 creative work are within the scope of protection of the present invention.

[0058] See also Figure 1 , Figure 1 A flowchart of a method for generating a business report according to an embodiment of the present invention.

[0059] The present invention provides a method for generating a business report, which may specifically include the following steps:

[0060] Step 101, receiving a deadline for a preset target business input by a user;

[0061] In the embodiment of the present invention, the target business refers to the business for which a report needs to be generated. The deadline of the target business refers to the date given by the user for determining the time period to be queried; the deadline is combined with the date of generation of the business to obtain the time period to be queried by the user.

[0062] In actual applications, the deadline of the business target can be set according to actual query needs. For example, assuming that the target business is settled on the 15th of each month, the deadline can be the 15th of each month.

[0063] Step 102, obtaining a calculation view framework corresponding to the target business;

[0064] The calculation view is a multi-level structure. According to the components of the business report to be generated by the target business and the relationship between different components, the calculation view has a corresponding number of levels. At the same time, the data processing logic of each level and the processing order of each component in the business report are different.

[0065] The calculation view framework is a pre-built logical architecture of the calculation view based on the data processing logic required to generate business reports for the target business. It defines the hierarchical structure of the calculation view to be adopted by the target business and the data processing logic at each level.

[0066] In the specific implementation, the structure of the calculation view can be designed according to the relevant content involved in the business report to be generated by the target business, so as to break down the process of obtaining the data required for the report into multiple stages for data processing. This can not only alleviate the calculation pressure of processing the overall business data of the target business, but also achieve efficient control of each data processing stage, reduce the amount of data involved in a single calculation during the business data processing process, thereby reducing the memory usage in the process of generating the calculation view, ensuring the smoothness of business report generation, and avoiding the target business processing system from freezing or dumping.

[0067] It should be noted that, since the calculation logic for generating corresponding business reports for different target businesses is different, different target businesses need to use different calculation views. If the calculation view needs to be rebuilt according to the business report to be generated when the target business is determined, it will increase the labor cost and the operation is more cumbersome. Therefore, in an embodiment of the present invention, a calculation view framework of the calculation view corresponding to each target business is pre-built, so that after the target business is determined, the corresponding calculation view can be automatically generated based on the calculation view framework to complete the corresponding calculation according to the calculation view, thereby reducing the cumbersomeness of data processing and reducing labor costs.

[0068] In the embodiment of the present invention, HANA calculation view can be used as the calculation view selected by the target business. HANA calculation view is an information view that supports complex calculations, and its data foundation can include tables, column views, analysis views, and calculation views. When processing target businesses with large amounts of data, HANA calculation view has a higher memory limit, which can effectively reduce the memory pressure during data processing and avoid freezing or dumping of the processing system of the target business.

[0069] Step 103, acquiring business data based on the deadline and the calculation view framework, and extracting at least one business data table from the business data;

[0070] In the embodiment of the present invention, business data refers to data generated by the target business before the deadline. Taking the accounts receivable business as an example, the business data can be a series of information such as the amount of payment and collection, payment time, etc. generated by the corresponding customer during the business process.

[0071] A business data table refers to a form generated by extracting target data from business data based on specific conditions.

[0072] After obtaining the deadline of the target business and the required calculation view framework, you can obtain the business data before the deadline for building the calculation view. And extract at least one business data table from the business data. Different business data tables are used to participate in the calculation of calculation views at different stages.

[0073] In an example, assuming that the calculation view framework defines that the bottom layer of the calculation view is used to calculate financial accounts receivable information, the business data table corresponding to the calculation of financial accounts receivable information can be obtained, so that the corresponding business data table can be processed through the data processing logic of the bottom layer of the calculation view to obtain the financial accounts receivable information. Similarly, according to the data processing logic of different levels of the calculation view set by the calculation view framework, the corresponding business data table can be obtained for data processing. Among them, the processing of business data tables at different levels may include Projection, Union and Join. Projection represents the mapping of the underlying data, which can generally be understood as data stored in its internal fields. Union represents the combination of the associated non-repetitive two-by-two data; Join represents the association relationship of the data, and the data can be filtered, matched, etc. in the association, depending on the specific process. The calculation view at this level can establish a connection between the output results of the previous level and the corresponding business data table through view functions such as Projection, Union and Join, so as to provide a data basis for data processing at this level.

[0074] It should be noted that since the embodiment of the present invention extracts business data tables from business data to perform calculation views, the amount of data involved in the calculation is smaller than that of the calculation using the underlying business data, which can effectively reduce the memory occupied during the calculation process.

[0075] Step 104: Generate a business report of the business data based on the business data table.

[0076] Business reports refer to statistical analysis tables of business content and data. Since the nature and content of business vary from industry to industry, there is no uniform format and content for business reports.

[0077] In an embodiment of the present invention, there may be more than one business data table extracted from the business data, and each business data table can represent real-time business data at different stages in the operation of the business process, that is, each business data table can represent different types of data and can independently participate in the data processing process of the overall business operation. Therefore, after obtaining multiple business data tables, different types of business data tables can be called in the process of processing the target business according to the calculation logic of the calculation view framework, so that the data in multiple business data tables can participate in the overall process of processing the target business, and finally generate a business report that can represent the overall business data of the target business.

[0078] The present invention receives a deadline for a preset target business input by a user to determine the required calculation view framework according to the selected target business, thereby obtaining corresponding business data according to the calculation view framework and the deadline corresponding to the current target business, and extracts at least one business data table from a large amount of business data of the target business, and utilizes multiple business data tables to participate in the business process of processing the target business respectively, and disassembles the overall business process of the target business into multiple stages for data processing, which can not only alleviate the calculation pressure of processing the overall business data of the target business, but also achieve efficient controllability of each data processing stage, reduce the amount of data involved in a single calculation in the process of business data processing, thereby reducing memory usage in the process of generating calculation views, ensuring the smoothness of business report generation, and avoiding the processing system freeze or dump of the target business.

[0079] See also Figure 2 , Figure 2 A flowchart of a method for generating a business report is provided in another embodiment of the present invention. The method may specifically include the following steps:

[0080] Step 201, receiving a deadline for a preset target business input by a user;

[0081] Step 202, obtaining a calculation view framework corresponding to the target business;

[0082] Step 203, acquiring business data based on the deadline and the calculation view framework, and extracting at least one business data table from the business data;

[0083] Steps 201-203 are the same as steps 101-103. For details, please refer to the description of steps 101-103, which will not be repeated here.

[0084] Step 204, when the target business is an accounts receivable business, generating financial accounts receivable information of at least one customer using the business data table;

[0085] In the embodiment of the present invention, when the target business is an accounts receivable business, the deadline may be an aging deadline, wherein the accounts receivable business refers to a business for which the customer has not completed payment by the aging deadline.

[0086] Financial accounts receivable information refers to the information related to the business that customers have not paid for, including customer information, unpaid amount, base currency, original currency and exchange rate.

[0087] In actual applications, when the business target is accounts receivable business, the business data table can be used to generate financial accounts receivable information of at least one customer.

[0088] In one example, the step of generating financial accounts receivable information of at least one customer using a business data table may include:

[0089] S41, obtaining the prepayment target data table, the finance actual receipt data table and the finance master data table from the business data table;

[0090] S42, matching the actual financial data table and the financial master data table to obtain the actual financial business data;

[0091] S43, matching the actual financial business data with the prepayment target data table to generate financial accounts receivable information of at least one customer.

[0092] In the embodiment of the present invention, the pre-collection target data table refers to a table recording the accounts receivable generated before the deadline and not yet fully received by the customer. The financial master data table refers to a table recording the financial data of all customers of the payee. The financial actual receipt data table refers to a table recording the accounts receivable information received within the time period up to the deadline.

[0093] By matching the actual financial receipt data table with the financial master data table, you can filter out all the customer data that have not received all the accounts receivable information, that is, the actual financial business data. Then, by matching the actual financial business data with the pre-collected target data table, you can filter out the customer data that have not received all the accounts receivable and the related accounts receivable information, that is, the financial accounts receivable information of each customer.

[0094] Step 205, obtaining the base currency information of the financial accounts receivable information, and generating first associated data by combining the base currency information and the financial accounts receivable information;

[0095] The base currency refers to the main currency that a country's laws stipulate as the price standard.

[0096] In actual applications, due to the influence of the customer's place of origin, settlement regulations, etc., different customers use different currencies for settlement. At the same time, the currencies used for settlement between the payee and the customer may also be different. Therefore, the payee and the customer need to perform corresponding exchange rate conversion so that the payee can know the base currency amount of the actual accounts receivable. Therefore, in the embodiment of the present invention, it is necessary to obtain the base currency information of the payee from the business data.

[0097] In one example, the step of obtaining the base currency information of the financial accounts receivable information and generating the first associated data by combining the base currency information and the financial accounts receivable information may include:

[0098] S51, extracting the pre-stored table of base currency information from the business data table;

[0099] S52, matching the base currency information of the financial accounts receivable information in the base currency information pre-stored table;

[0100] S53, associating the base currency information with the financial accounts receivable information to generate first associated data.

[0101] In practical applications, if exchange rate conversion is required, it is necessary to obtain the base currency information of the payee and the payee. In an embodiment of the present invention, the base currency information of the payee can be directly set by the payee. The base currency information of the payee (i.e., the customer) can be obtained by matching the customer information in the financial accounts receivable information with a pre-set base currency information pre-stored table. The base currency information pre-stored table can be a pre-set table that stores the base currency information of all customers.

[0102] After obtaining the base currency information of the payee and the base currency information of the customer, they may be associated with the financial accounts receivable information, thereby obtaining first associated data including the base currency information.

[0103] Step 206, calculating the aging information of the financial accounts receivable information based on the first associated data, and generating second associated data by combining the aging information and the first associated data;

[0104] Account age refers to the length of time between the customer payment start date and the payment deadline.

[0105] In the embodiment of the present invention, the account age can be calculated based on the relevant data of each customer in the first associated data and the business data table.

[0106] In one example, the step of calculating the aging information of the financial accounts receivable information based on the first associated data may include:

[0107] S61, extracting a financial data table from a business data table;

[0108] S62, extracting the payment start date and payment due date of the financial accounts receivable information from the financial data table;

[0109] S63, matching the payment start date and the payment due date in the first associated data to generate aging information of financial accounts receivable information;

[0110] S64, associating the account age information with the first associated data to generate second associated data.

[0111] In a specific implementation, the business data table may include a financial data table, which records the payment start date and payment due date of all customers of the payee. The payment start date represents the starting date on which the customer needs to make payment. The payment due date represents the final payment date agreed with the customer. If payment is made after this date, liquidated damages or late payment fees may be incurred.

[0112] By matching the first associated data with the payment start date and payment due date in the financial data table, the payment start date and payment due date of each customer's financial accounts payable information in the acquired business data within the deadline can be obtained, thereby further obtaining the aging information of the financial accounts payable information. After obtaining the aging information of the financial accounts receivable information, it can be associated with the first associated data, thereby obtaining the second associated data including the aging information and the first associated data.

[0113] Step 207, acquiring exchange rate information of the financial accounts receivable information based on the second associated data, and combining the exchange rate information and the second associated data to obtain third associated data;

[0114] In the embodiment of the present invention, the exchange rate information refers to the conversion relationship between the base currency actually used by the payee and the base currency actually used by the customer.

[0115] After the second associated data is obtained, the exchange rate information of the financial accounts receivable information can be calculated according to the base currency information of the financial accounts receivable information and the base currency information of the customer advance payment currency contained in the second associated data, and the actual exchange rate on the deadline.

[0116] In one example, the step of acquiring the exchange rate information of the financial accounts receivable information based on the second associated data, and combining the exchange rate information and the second associated data to obtain the third associated data may include:

[0117] S71, obtaining an exchange rate table, a currency table and an exchange rate factor table from the business data table;

[0118] S72, matching the second associated data with the exchange rate table to obtain exchange rate data of the financial accounts receivable information, and associating the second associated data with the exchange rate data to generate sixth associated data;

[0119] S73, matching the sixth associated data with the currency table to obtain currency information of the financial accounts receivable information, and associating the currency information with the sixth associated data to generate seventh associated data;

[0120] S74, matching the seventh associated data with the exchange rate factor table to obtain exchange rate factor information of financial accounts receivable information;

[0121] S75, generating exchange rate information of financial accounts receivable information using the exchange rate data, currency information and exchange rate factor information;

[0122] S76, associating the exchange rate information and the second associated data to generate third associated data.

[0123] In the embodiment of the present invention, the business data table may also include an exchange rate table, a currency table and an exchange rate factor table, wherein the exchange rate information between currencies of various countries, currency information and exchange rate factors affecting the exchange rate between two countries are recorded in the exchange rate table, currency table and exchange rate factor table respectively.

[0124] In a specific implementation, the second associated data and the exchange rate table may be first matched through a calculation view to obtain the exchange rate data between the payee and the customer in the financial accounts receivable information; and the second associated data and the exchange rate data may be associated to obtain sixth associated data including the second associated data and the exchange rate data.

[0125] Then, the sixth associated data can be matched with the currency table to obtain the currency information of each customer in the financial accounts receivable information; and the currency information can be associated with the sixth associated data to obtain the seventh associated data including the currency information and the sixth associated data.

[0126] Then, the seventh associated data may be matched with the exchange rate factor table to obtain the exchange rate factor affecting the exchange rate between the payee and the customer in the financial accounts receivable information.

[0127] Finally, the exchange rate data, currency information and exchange rate factor corresponding to the financial accounts receivable information are integrated to obtain the exchange rate information of the financial accounts receivable information, and the exchange rate information is associated with the second associated data to obtain the third associated information including the exchange rate information and the second associated information, which is convenient for subsequent exchange rate conversion operations.

[0128] Step 208, calculating the base currency amount of the unpaid items of the financial accounts receivable information based on the third associated data, and generating fourth associated data by combining the base currency amount of the unpaid items and the third associated data;

[0129] In the embodiment of the present invention, the base currency amount of the unpaid item refers to the amount of the unpaid amount of the customer converted into the base currency of the payee.

[0130] Since the third associated data records the exchange rate information between the payee and the customer, the unpaid base currency amount of the financial accounts receivable information can be calculated based on the exchange rate information in the third associated data; and the fourth associated data is generated by combining the unpaid base currency amount and the third associated data.

[0131] In one example, the step of calculating the base currency amount of the unpaid items of the financial accounts receivable information based on the third associated data and generating the fourth associated data by combining the base currency amount of the unpaid items and the third associated data may include:

[0132] S81, extracting the original currency amount of the unpaid items corresponding to the financial accounts receivable information;

[0133] S82, calculating the base currency amount of the unpaid item corresponding to the financial account information using the third associated data and the original currency amount of the unpaid item;

[0134] S83, associating the base currency amount of the unpaid item with the third associated data to generate fourth associated data.

[0135] The original currency amount of unpaid items refers to the unpaid amount calculated using the customer's base currency as the measurement unit.

[0136] In practical applications, the original currency amount of the customer's unpaid items can first be obtained from the financial accounts receivable information. Then, the exchange rate information between the payee and the customer is used to calculate the base currency amount of the unpaid items in combination with the original currency amount of the unpaid items. Finally, by associating the base currency amount of the unpaid items with the third associated data, fourth associated data including the third associated data and the base currency amount of the unpaid items can be generated.

[0137] Step 209, acquiring customer information based on the fourth associated data, and generating fifth associated data by combining the customer information and the fourth associated data;

[0138] In order to make the final generated report reflect the customer information more clearly, in the embodiment of the present invention, the customer information of the customer involved in the fourth associated data can also be obtained, and the fifth associated data can be generated by combining the customer information and the fourth associated data. Among them, the customer information may include but is not limited to customer attribute information and customer consumption information. Customer attribute information may include information such as customer name, customer address, contact information, etc. Customer consumption information may include shopping receipts, invoices, store data, etc. Customer attribute information can be used to divide the customer's place of origin and the importance of the customer; customer consumption information can be used to analyze the customer's consumption situation.

[0139] In one example, the step of acquiring customer information based on the fourth associated data and generating fifth associated data by combining the customer information and the fourth associated data may include:

[0140] S91, obtaining customer attribute information and customer consumption information of each customer from the business data table;

[0141] S92, associating the customer attribute information, the customer consumption information and the fourth associated data to generate fifth associated data.

[0142] In actual applications, the business data table may include a consumption information table that records the customer's consumption receipts and invoices, and a customer attribute information table. Among them, the store data where the customer made consumption can be obtained from the customer's consumption receipts and invoices. The customer's attribute information table records attribute information such as the customer name, customer address, and contact information. By associating the consumption information table and the attribute information table with the fourth associated data, the fifth associated data including the customer information and the fourth associated data can be obtained.

[0143] Step 210: Generate a business report based on the fifth associated data.

[0144] In an embodiment of the present invention, the fifth associated data records the above-mentioned financial accounts receivable information, aging information, exchange rate information, the original currency amount of unpaid items, the base currency amount of unpaid items, customer information, and the aging days calculated based on the payment start date and deadline, so that a business report containing the above information can be output based on the fifth associated data.

[0145] The present invention receives a deadline for accounts receivable business input by a user to obtain a calculation view framework corresponding to the accounts receivable business and corresponding business data for generating business reports corresponding to the accounts receivable business before the deadline; and extracts at least one business data table from a large amount of business data of the accounts receivable business, utilizes multiple business data tables to respectively participate in the business process of processing the accounts receivable business, and decomposes the accounts receivable business process into multiple stages for data processing, which can not only alleviate the calculation pressure of processing the overall business data of the accounts receivable business, but also achieve efficient controllability of each data processing stage, reduce the amount of data involved in a single calculation in the process of business data processing, thereby reducing memory usage in the process of generating calculation views, ensuring the smoothness of business report generation, and avoiding freezing or dumping of the processing system of the accounts receivable business.

[0146] For ease of understanding, the embodiments of the present invention are described below by using specific examples:

[0147] See also Figure 3 , Figure 3 A schematic diagram of a calculation view of a business report generation method provided in an embodiment of the present invention.

[0148] Among them, Projection represents the mapping of the underlying data and indicates that data is stored in its internal fields; Join represents the association relationship of the data, in which the data can be filtered and matched, and the specific processing process can be selected according to actual needs; Union represents the combination of the associated non-duplicate pairs of data.

[0149] In the calculation view, the calculation process of each stage is as follows:

[0150] First, according to the deadline entered by the user, related forms are extracted from the business data, including prepayment target data table, financial actual receipt data table, financial master data table, base currency information pre-stored table, financial data table, exchange rate table, currency table, exchange rate factor table, customer information table and other forms.

[0151] UNION_1 and the following modules are used to integrate the financial accounts receivable information within the deadline. Specifically, Join_13 associates and filters the data in the financial actual receipt data table and the financial master data table to obtain the financial actual business data. UNION_1 is used to match the financial actual business data stored in Join_13 with the pre-collected target data table to obtain the financial accounts receivable information of at least one customer.

[0152] Join_1 associates the pre-stored table of base currency information with UNION_1 to obtain the base currency information of the financial accounts receivable information, and combines the financial accounts receivable information and the base currency information to generate the first associated data. The base currency information of the financial accounts receivable information can be used for subsequent exchange rate calculations.

[0153] Join_2 is used to associate Join_1 with the financial data table to calculate the aging information by associating it with the payment start date and payment due date corresponding to each customer's financial accounts receivable. The second associated data is generated by combining the first associated data and the financial accounts receivable information, that is, the second associated data is stored in Join_2.

[0154] Join_3 associates the exchange rate table with Join_2 to obtain exchange rate data. Specifically, the conversion of exchange rates can include forward matching and reverse matching. Among them, Join_3 performs forward matching. Forward matching is to match the exchange rate relationship in a fixed direction. For example, if the exchange rate relationship in the financial accounts receivable information is A to B, then the exchange rate table is matched to see whether there is an exchange rate relationship from A to B.

[0155] Considering that there may be a situation where the forward matching cannot match the desired exchange rate relationship, the reverse matching process is introduced here. Reverse matching refers to matching the exchange rate relationship from B to A in the exchange rate table and adjusting it to the exchange rate relationship from A to B. Join_5 associates projection-Join3 with the exchange rate data in the exchange rate table and performs reverse matching. Thus, the matching of exchange rate data is improved by combining the forward matching process. Projection-Join_3 is generated after filtering the data of Join_3 and then mapping and importing it into the Projection view.

[0156] Then, Join_5 is filtered to obtain Projection-Join_5, and Projection-Join_5 is associated with the currency table to obtain Join_8 (forward match); Join_8 is associated with the currency in the currency table to obtain Join_9 (reverse match); Join_9 is associated with the exchange rate factor in the exchange rate factor table to generate Join_4. Thus, the exchange rate information of the financial accounts receivable information is obtained at Join_4, and the third association data including the second association data and the exchange rate information is obtained.

[0157] It should be noted that the embodiment of the present invention does not limit the order of forward matching and reverse matching. The above process of forward matching first and then reverse matching is only an example provided by the embodiment of the present invention. Those skilled in the art can change the order of forward matching and reverse matching according to actual needs.

[0158] Then, by filtering Join_4, Projection-Join_4 can be obtained in the form of a table to reduce the memory usage of subsequent calculations. At the same time, the data in Join_4 includes the payment start date, deadline, exchange rate information, and the original currency amount of the customer's unpaid items. Therefore, the aging days of the customer's unpaid account information and the customer's unpaid item base currency amount obtained after the exchange rate conversion can be calculated, and the fourth associated data including the aging days, the original currency amount of the unpaid items, and the base currency amount of the unpaid items can be obtained.

[0159] Then, Projection-Join_4 is associated with the customer master data table to generate Join_6, which can obtain the customer attribute information of the customer corresponding to the financial accounts payable information, including customer name, customer address, contact information, etc. Obtaining the customer attribute information of the customer corresponding to the financial accounts payable information is helpful for categorizing customers, including categorizing by location, etc.

[0160] Join_6 is associated with the bill information table containing information such as consumption receipts and invoices to obtain Join_7, which obtains the customer's invoice header. Join_7 is associated with the customer attribute summary data to obtain the customer attributes to which Join_7 belongs, and finally Join_10 is obtained.

[0161] Join_11 associates Form 1 for the invoice number of the transaction invoicing and Form 2 for querying the invoice number. By associating Join_11 with Join_10, Join_12 containing the invoice information can be obtained.

[0162] By summarizing the data in the form recording the amount of financial bad debts, the amount of financial bad debts of all customers of the payee can be obtained. By associating it with Join_12 to generate Join_14, the amount of financial bad debts of each customer corresponding to the financial accounts receivable information can be obtained, so as to determine the actual aging amount of the customer's unpaid items based on the customer's payment and non-payment status. The data stored in Join_14 is the fifth associated data.

[0163] Finally, the data in Join_14 is summarized to obtain the final business report data to be displayed. Users can use business reports to understand various information such as customer information, base currency information, exchange rate information, payment start date, payment due date, aging days, unpaid original currency amount, unpaid aging amount, etc.

[0164] See also Figure 4 , Figure 4 A structural block diagram of a business report generation device provided by an embodiment of the present invention.

[0165] An embodiment of the present invention provides a business report generation device, including:

[0166] The deadline receiving module 401 is used to receive the deadline for the preset target business input by the user;

[0167] A calculation view framework 402 is used to obtain a calculation view framework corresponding to a target business;

[0168] A business data table extraction module 403 is used to obtain business data based on the deadline and the calculation view framework, and extract at least one business data table from the business data;

[0169] The business report generation module 404 is used to generate a business report of the business data based on the business data table.

[0170] In the embodiment of the present invention, the business report generation module 404 includes:

[0171] A financial accounts receivable information generation submodule, for generating financial accounts receivable information of at least one customer using a business data table when the target business is an accounts receivable business;

[0172] A first associated data generating submodule, used to obtain the base currency information of the financial accounts receivable information, and generate the first associated data by combining the base currency information and the financial accounts receivable information;

[0173] A second associated data generating submodule, configured to calculate the aging information of the financial accounts receivable information based on the first associated data, and generate the second associated data by combining the aging information and the first associated data;

[0174] A third associated data generating submodule, configured to obtain exchange rate information of financial accounts receivable information based on the second associated data, and to obtain third associated data by combining the exchange rate information and the second associated data;

[0175] A fourth associated data generating submodule, configured to calculate the base currency amount of the unpaid items of the financial accounts receivable information based on the third associated data, and generate fourth associated data in combination with the base currency amount of the unpaid items and the third associated data;

[0176] a fifth associated data generating submodule, configured to obtain customer information based on the fourth associated data, and generate fifth associated data by combining the customer information and the fourth associated data;

[0177] The business report generation submodule is used to generate a business report based on the fifth associated data.

[0178] In an embodiment of the present invention, the financial accounts receivable information generation submodule includes:

[0179] The target data table, the financial actual received data table and the financial master data table acquisition unit is used to acquire the pre-collected target data table, the financial actual received data table and the financial master data table from the business data table;

[0180] A financial actual business data generation unit is used to match the financial actual received data table with the financial master data table to obtain the financial actual business data;

[0181] The financial accounts receivable information generating unit is used to match the actual financial business data with the prepayment target data table to generate the financial accounts receivable information of at least one customer.

[0182] In an embodiment of the present invention, the first associated data generating submodule includes:

[0183] A base currency information pre-stored table extraction unit, used to extract the base currency information pre-stored table from the business data table;

[0184] The base currency information matching unit is used to match the base currency information of the financial accounts receivable information in the base currency information pre-stored table;

[0185] The first associated data generating unit is used to associate the base currency information with the financial accounts receivable information to generate first associated data.

[0186] In an embodiment of the present invention, the second associated data generating submodule includes:

[0187] A financial data table extraction unit, used for extracting a financial data table from a business data table;

[0188] A payment start date and payment due date extraction unit is used to extract the payment start date and payment due date of financial accounts receivable information from the financial data table;

[0189] An aging information generating unit, used to match the payment start date and the payment due date in the first associated data to generate aging information of financial accounts receivable information;

[0190] The second associated data generating unit is used to associate the account aging information with the first associated data to generate second associated data.

[0191] In the embodiment of the present invention, the third associated data generating submodule includes:

[0192] An exchange rate table, currency table and exchange rate factor table acquisition unit, used to acquire the exchange rate table, currency table and exchange rate factor table from the business data table;

[0193] a sixth associated data generating unit, configured to match the second associated data with the exchange rate table, obtain exchange rate data of the financial accounts receivable information, and associate the second associated data with the exchange rate data to generate sixth associated data;

[0194] a seventh associated data generating unit, configured to match the sixth associated data with the currency table, obtain currency information of the financial accounts receivable information, and associate the currency information with the sixth associated data to generate seventh associated data;

[0195] An exchange rate factor information acquisition unit, used for matching the seventh associated data with the exchange rate factor table to obtain the exchange rate factor information of the financial accounts receivable information;

[0196] An exchange rate information acquisition unit, used to generate exchange rate information of financial accounts receivable information using exchange rate data, currency information and exchange rate factor information;

[0197] The third associated data generating unit is configured to associate the exchange rate information with the second associated data to generate third associated data.

[0198] In the embodiment of the present invention, the fourth associated data generating submodule includes:

[0199] The unpaid item original currency amount extraction unit is used to extract the unpaid item original currency amount corresponding to the financial accounts receivable information;

[0200] An unpaid item base currency amount calculation unit, used to calculate the unpaid item base currency amount corresponding to the financial account information by using the third associated data and the unpaid item original currency amount;

[0201] The fourth associated data generating unit is used to associate the base currency amount of the unpaid item with the third associated data to generate fourth associated data.

[0202] In the embodiment of the present invention, the fifth associated data generating submodule includes:

[0203] A customer attribute information and customer consumption information acquisition unit, used to acquire customer attribute information and customer consumption information of each customer from a business data table;

[0204] The fifth associated data generating unit is used to associate the customer attribute information, the customer consumption information and the fourth associated data to generate fifth associated data.

[0205] An embodiment of the present invention further provides an electronic device, the device comprising a processor and a memory:

[0206] The memory is used to store the program code and transmit the program code to the processor;

[0207] The processor is used to execute the business report generation method of the embodiment of the present invention according to the instructions in the program code.

[0208] The embodiment of the present invention further provides a computer-readable storage medium, which is used to store program codes, and the program codes are used to execute the business report generation method of the embodiment of the present invention.

[0209] Those skilled in the art can clearly understand that, for the convenience and brevity of description, the specific working processes of the systems, devices and units described above can refer to the corresponding processes in the aforementioned method embodiments and will not be repeated here.

[0210] The various embodiments in this specification are described in a progressive manner, and each embodiment focuses on the differences from other embodiments. The same or similar parts between the various embodiments can be referenced to each other.

[0211] It will be appreciated by those skilled in the art that the embodiments of the present invention may be provided as methods, devices, or computer program products. Therefore, the embodiments of 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 embodiments of 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 codes.

[0212] The embodiments of the present invention are described with reference to the flowcharts and / or block diagrams of the methods, terminal devices (systems), and computer program products according to the 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 the 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 terminal device to generate a machine, so that the instructions executed by the processor of the computer or other programmable data processing terminal 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.

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

[0214] These computer program instructions can also be loaded onto a computer or other programmable data processing terminal device so that a series of operating steps are executed on the computer or other programmable terminal device to produce a computer-implemented process, thereby providing instructions for executing on the computer or other programmable terminal device to implement 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.

[0215] Although the preferred embodiments of the present invention have been described, those skilled in the art may make additional changes and modifications to these embodiments once they have learned the basic creative concept. Therefore, the appended claims are intended to be interpreted as including the preferred embodiments and all changes and modifications that fall within the scope of the embodiments of the present invention.

[0216] Finally, 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 terminal 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 terminal device. In the absence of further restrictions, the elements defined by the sentence "comprise a ..." do not exclude the existence of other identical elements in the process, method, article or terminal device including the elements.

[0217] As described above, the above embodiments are only used to illustrate the technical solutions of the present invention, rather than to limit the same. Although the present invention has been described in detail with reference to the aforementioned embodiments, those skilled in the art should understand that the technical solutions described in the aforementioned embodiments may still be modified, or some of the technical features thereof may be replaced by equivalents. However, these modifications or replacements do not deviate the essence of the corresponding technical solutions from the spirit and scope of the technical solutions of the embodiments of the present invention.

Claims

1. A method for generating a business report, characterized in that: include: Receiving a deadline for a preset target business input by a user; Obtaining a calculation view framework corresponding to the target business; Acquire business data based on the deadline and the calculation view framework, and extract at least one business data table from the business data; Generate a business report of the business data based on the business data table; Wherein, the step of generating a business report of the business data based on the business data table includes: When the target business is an accounts receivable business, using the business data table to generate financial accounts receivable information of at least one customer; Acquire the base currency information of the financial accounts receivable information, and generate first associated data by combining the base currency information and the financial accounts receivable information; Calculate the aging information of the financial accounts receivable information based on the first associated data, and generate second associated data by combining the aging information and the first associated data; acquiring exchange rate information of the financial accounts receivable information based on the second associated data, and obtaining third associated data by combining the exchange rate information and the second associated data; Calculate the base currency amount of the unpaid items of the financial accounts receivable information based on the third associated data, and generate fourth associated data by combining the base currency amount of the unpaid items and the third associated data; Acquire customer information based on the fourth associated data, and generate fifth associated data by combining the customer information and the fourth associated data; A business report is generated based on the fifth associated data.

2. The method according to claim 1, characterized in that The step of using the business data table to generate financial accounts receivable information of at least one customer comprises: Obtaining the prepayment target data table, the financial actual receipt data table and the financial master data table from the business data table; Matching the actual financial data table with the financial master data table to obtain actual financial business data; The actual financial business data and the prepayment target data table are matched to generate financial accounts receivable information of at least one customer.

3. The method according to claim 1, characterized in that The step of obtaining the base currency information of the financial accounts receivable information and generating the first associated data by combining the base currency information and the financial accounts receivable information includes: Extracting the pre-stored table of base currency information from the business data table; Matching the functional currency information of the financial accounts receivable information in the functional currency information pre-stored table; The base currency information and the financial accounts receivable information are associated to generate first associated data.

4. The method according to claim 1, characterized in that: The step of calculating the aging information of the financial accounts receivable information based on the first associated data, and generating second associated data by combining the aging information and the first associated data, comprises: Extracting a financial data table from the business data table; Extracting the payment start date and payment due date of the financial accounts receivable information from the financial data table; Matching the payment start date and the payment due date in the first associated data to generate aging information of the financial accounts receivable information; The account aging information and the first associated data are associated to generate second associated data.

5. The method according to claim 1, characterized in that The step of acquiring the exchange rate information of the financial accounts receivable information based on the second associated data, and obtaining the third associated data by combining the exchange rate information and the second associated data, comprises: Obtaining an exchange rate table, a currency table and an exchange rate factor table from the business data table; Matching the second associated data with the exchange rate table to obtain exchange rate data of the financial accounts receivable information, and associating the second associated data with the exchange rate data to generate sixth associated data; Matching the sixth associated data with the currency table to obtain currency information of the financial accounts receivable information, and associating the currency information with the sixth associated data to generate seventh associated data; Matching the seventh associated data with the exchange rate factor table to obtain exchange rate factor information of the financial accounts receivable information; Generate exchange rate information of the financial accounts receivable information using the exchange rate data, the currency information and the exchange rate factor information; The exchange rate information and the second related data are associated with each other to generate third related data.

6. The method according to claim 1, characterized in that The step of calculating the base currency amount of the unpaid items of the financial accounts receivable information based on the third associated data, and generating fourth associated data by combining the base currency amount of the unpaid items and the third associated data, comprises: Extract the original currency amount of the unpaid items corresponding to the financial accounts receivable information; Calculating the amount of the unpaid item in the functional currency corresponding to the financial accounts receivable information by using the third associated data and the amount of the unpaid item in the original currency; The base currency amount of the unpaid item is associated with the third associated data to generate fourth associated data.

7. The method according to claim 6, characterized in that The step of acquiring the customer information based on the fourth associated data and generating the fifth associated data by combining the customer information and the fourth associated data includes: Acquire customer attribute information and customer consumption information of each customer from the business data table; The customer attribute information, the customer consumption information and the fourth associated data are associated to generate fifth associated data.

8. An electronic device, characterized in that: The device comprises a processor and a memory: The memory is used to store program code and transmit the program code to the processor; The processor is used to execute the business report generation method described in any one of claims 1-7 according to the instructions in the program code.

9. A computer-readable storage medium, characterized in that: The computer-readable storage medium is used to store program codes, and the program codes are used to execute the business report generation method according to any one of claims 1 to 7.

Images