Financial voucher generation method and device, server, storage medium and program product
Through automated and processed financial voucher generation methods, the problems of complex configuration and poor readability in the prior art are solved, and financial voucher generation that simplifies configuration and improves efficiency are achieved.
Patent Information
- Application Number
- CN202411562639.9
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-11-04
- Publication Date
- 2025-02-11
AI Technical Summary
When maintaining the new Insurance Contract Standard (IFRS17) sub-led integration solution, the existing technology needs to combine accounting accounts through nearly 10 dimensions, which are complex configurations, difficult to understand and maintain, have huge rules and poor readability.
Provide a method for generating financial vouchers, through automated and processed processing, obtain the metering output item transfer rules, extract the measurement result data, convert and summarize the financial data, and generate financial vouchers.
The configuration of the metered output item transfer rules is simplified, readability and maintenance are improved, manual intervention is reduced, efficiency and accuracy is improved, and financial vouchers can be generated more timely.
Smart Images

Figure CN119417629A_ABST
Abstract
Description
Technical Field
[0001] The present application relates to the field of data processing technology, and in particular to a method, device, server, storage medium and program product for generating financial vouchers. Background Art
[0002] At present, the sub-account integration solution of the new insurance contract standard (IFRS17) requires the maintenance of derivation rules such as accounting subjects and reasons for accounting changes in advance, and then aggregation and posting. When maintaining the derivation rules, it is necessary to derive accounting subjects through nearly 10 dimensions, involving many tables and many entry rules. The configuration is difficult to understand and maintain, the rules are huge, and the readability is poor. Summary of the invention
[0003] The present application provides a financial voucher generation method, device, server, storage medium and program product, which can generate financial vouchers more timely through automated and process-based processing.
[0004] In a first aspect, the present application provides a method for generating financial vouchers, which is applied to an accounting platform, and the method comprises:
[0005] Obtaining a measurement output item transfer rule corresponding to a project code used to refer to a target measurement scenario; the measurement output item transfer rule comprises a plurality of parameter items, and the plurality of parameter items comprises a project code, a description, a debit account, a credit account, a reason for accounting changes, an amount type, positive and negative processing, a voucher type, a consolidation type, and other auxiliary information;
[0006] Extracting metering result data related to the target metering scenario during the metering period from the metering platform;
[0007] Performing financial data conversion on the measurement result data to obtain converted measurement result data;
[0008] Based on the measurement output item transfer rules, the converted measurement result data is summarized and posted to obtain a financial voucher.
[0009] In some embodiments, extracting the metering result data related to the target metering scenario during the metering period from the metering platform includes:
[0010] When the status of the metering platform is a metering-completed extractable status, the status of the accounting platform is updated from never having been certified to having been certified;
[0011] The metering result data related to the target metering scenario during the metering period are extracted from the metering platform in batches according to multiple preset dimensions, and the metering result status table is written back.
[0012] In some embodiments, after extracting the metering result data related to the target metering scenario during the metering period from the metering platform, the method further includes:
[0013] Generate a version number of the measurement result data;
[0014] Determine whether the certificate status is empty. If it is empty, update the certificate status to start the transfer.
[0015] In some embodiments, the converting measurement result data is summarized and posted based on the measurement output item transfer rule to obtain a financial voucher, including:
[0016] According to the measurement output item transfer rule, the converted measurement result data is summarized to obtain summary data;
[0017] Write the summary sheet information back to the financial document;
[0018] Post the summary data to obtain financial vouchers.
[0019] In some embodiments, it also includes:
[0020] If the posting is successful, the voucher number will be written back and the voucher status will be recorded as successful posting;
[0021] If the posting fails, the certificate status will be recorded as posting error, and the error information will be recorded.
[0022] In some embodiments, it also includes:
[0023] The financial documents are checked against the measurement results, and the financial documents are checked against the accounting results to obtain a check result.
[0024] In some embodiments, it also includes:
[0025] If the verification result indicates that the financial document has incorrect data conversion and posting, the data recorded in the error log table will be re-converted and re-posted, and the incorrect batches in the measurement summary table will be re-posted;
[0026] If the verification result indicates that measurement error data conversion postings are made, the data recorded in the error log table and the errors in the measurement summary table shall be re-extracted and supplemented.
[0027] In some embodiments, it also includes:
[0028] When the metering platform needs to be re-measured, if the certificate status is successful posting or partial write-off, the wrong data that has been recorded will be rolled back;
[0029] The uncancelled voucher number is cancelled. If the cancellation is successful, the cancellation voucher and the certificate status are recorded as successful cancellation, and the status of the accounting platform is updated to uncertified; if the cancellation fails, the certificate status is recorded as cancellation error, and the error information is recorded.
[0030] In a second aspect, the present application provides a financial voucher generation device, which is arranged in an accounting platform, and the device comprises:
[0031] An acquisition module, used to acquire a metering output item transfer rule corresponding to a project code used to refer to a target metering scenario; the metering output item transfer rule includes multiple parameter items, and the multiple parameter items include a project code, description, debit account, credit account, accounting change reason, amount type, positive and negative processing, voucher type, consolidation type and other auxiliary information;
[0032] An extraction module, used to extract metering result data related to the target metering scenario during the metering period from the metering platform;
[0033] A conversion module, used for performing financial data conversion on the measurement result data to obtain converted measurement result data;
[0034] The posting module is used to summarize and post the converted measurement result data based on the measurement output item transfer rule to obtain a financial voucher.
[0035] In a third aspect, the present application provides an electronic device, comprising: a processor and a memory communicatively connected to the processor;
[0036] The memory stores computer-executable instructions;
[0037] The processor executes the computer-executable instructions stored in the memory to implement the financial voucher generation method as described in any one of the first aspects.
[0038] In a fourth aspect, the present application provides a computer-readable storage medium, wherein the computer-readable storage medium stores computer-executable instructions, and when the computer-executable instructions are executed by a processor, they are used to implement the financial voucher generation method described in any one of the first aspects.
[0039] In a fifth aspect, the present application provides a computer program product, including a computer program, which, when executed by a processor, implements the financial voucher generation method described in any one of the first aspects.
[0040] The financial voucher generation method, device, server, storage medium and program product provided by the present application have simple configuration of measurement output item transfer rules, good readability and easy maintenance. By automatically obtaining measurement output item transfer rules and applying them to the conversion and aggregation of measurement result data, manual intervention is reduced and efficiency and accuracy are improved. Through automated and process-based processing, financial vouchers can be generated more timely. BRIEF DESCRIPTION OF THE DRAWINGS
[0041] The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the present application and, together with the description, serve to explain the principles of the present application.
[0042] Figure 1 It is a schematic diagram of an application scenario provided by this application;
[0043] Figure 2 It is a flowchart of a method for generating financial vouchers provided by this application;
[0044] Figure 3 It is a flowchart of another method for generating financial vouchers provided by the present application;
[0045] Figure 4 It is a structural schematic diagram of a financial voucher generation device provided by the present application;
[0046] Figure 5 It is a structural diagram of a server provided by this application.
[0047] The above drawings have shown clear embodiments of the present application, which will be described in more detail later. These drawings and text descriptions are not intended to limit the scope of the present application in any way, but to illustrate the concept of the present application to those skilled in the art by referring to specific embodiments. DETAILED DESCRIPTION
[0048] Exemplary embodiments will be described in detail herein, examples of which are shown in the accompanying drawings. When the following description refers to the drawings, the same numbers in different drawings represent the same or similar elements unless otherwise indicated. The implementations described in the following exemplary embodiments do not represent all implementations consistent with the present application. Instead, they are merely examples of devices and methods consistent with some aspects of the present application as detailed in the appended claims.
[0049] It should be noted that the user information (including but not limited to user device information, user personal information, etc.) and data (including but not limited to data used for analysis, stored data, displayed data, etc.) involved in this application are all information and data authorized by the user or fully authorized by all parties, and the collection, use, processing, transmission, provision, disclosure and application of the relevant data comply with the relevant laws, regulations and standards of the relevant countries and regions, take necessary confidentiality measures, do not violate public order and good customs, and provide corresponding operation entrances for users to choose to authorize or refuse.
[0050] The current sub-account integration solutions for the new insurance contract standard (IFRS17) include:
[0051] 1. Configuration: It is necessary to maintain the derivation rules such as accounting subjects and reasons for accounting changes in advance.
[0052] 2. Integration: The integration of measurement sub-ledgers includes two steps: aggregation and posting. Aggregation refers to the aggregation of measurement results according to the accounting dimensions; posting refers to the certification operation of the aggregated data.
[0053] The main disadvantages of the prior art are as follows:
[0054] Complex configuration: When maintaining the derived rules for accounting subjects and accounting change reasons, it is necessary to derive accounting subjects through nearly 10 dimensions, involving hundreds of tables and tens of thousands of line item rules. The configuration is difficult to understand and maintain, the rules are huge, and the readability is poor.
[0055] Based on this, the present application proposes a financial voucher generation method, device, server, storage medium and program product, aiming to solve the above technical problems.
[0056] Figure 1 is a schematic diagram of an application scenario provided by this application. Figure 1 As shown, the application scenario includes: an accounting platform 10 and a metering platform 20. The accounting platform 10 and the metering platform 20 are provided with backend services by a server respectively. Optionally, the server is an independent physical server, or a server cluster or distributed system composed of multiple physical servers.
[0057] The execution subject of the financial voucher generation method provided in the present application is a financial voucher generation device, which is integrated in a server, and the server is a server for providing background services for the accounting platform 10.
[0058] The technical solution of the present application and how the technical solution of the present application solves the above-mentioned technical problems are described in detail below with specific embodiments. The following specific embodiments can be combined with each other, and the same or similar concepts or processes may not be repeated in some embodiments. The embodiments of the present application will be described below in conjunction with the accompanying drawings.
[0059] Figure 2 This is a flowchart of a method for generating financial vouchers provided by this application. Figure 2 As shown, the financial voucher generation method provided in this embodiment includes the following steps:
[0060] Step S101, obtain the measurement output item transfer rule corresponding to the project code used to refer to the target measurement scenario; the measurement output item transfer rule includes multiple parameter items, and the multiple parameter items include project code, description, debit account, credit account, accounting change reason, amount type, positive and negative processing, voucher type, consolidation type and other auxiliary information.
[0061] The target measurement scenario can be any business scenario that requires integrated certification, such as direct insurance, premium allocation approach (PAA), unexpired scenarios and pending scenarios of the general measurement model (GMM). The project code is used to refer to the measurement scenario to distinguish different measurement scenarios, that is, each measurement scenario has its own corresponding project code.
[0062] In this application, the measurement output item transfer rules define specific measurement scenarios and related financial voucher information for each project code. Financial voucher information includes project code, description, debit account, credit account, accounting change reason, amount type, positive and negative processing, voucher type, consolidation type, and other auxiliary information. Among them, the amount type represents the summary balance type, for example, the amount type is the beginning of the period to date (PTD) or the beginning of the year to date (YTD). Among them, other auxiliary information can be information such as business categories and cash flow types.
[0063] Step S102: extracting metering result data related to the target metering scenario during the metering period from the metering platform.
[0064] The measurement period (also known as the account opening period) may be a default time period or a manually set time period, which is not limited in this application. For example, the measurement period is "202402", which means the second quarter of 2024.
[0065] Step S103, converting the measurement result data into financial data to obtain converted measurement result data.
[0066] Step S104, based on the measurement output item transfer rules, the converted measurement result data is summarized and posted to obtain a financial voucher.
[0067] In this application, the measurement output item transfer rules ensure that the measurement result data output from the measurement platform can be accurately converted into the financial vouchers required by the accounting platform. During the voucher making process, the accounting platform automatically extracts the measurement result data from the measurement platform. According to the pre-configured measurement output item transfer rules, the accounting platform determines the financial voucher information corresponding to each measurement output item and generates the corresponding financial voucher based on this information.
[0068] Among them, changes in the rules for transferring measurement output items will directly affect the results of the certificate. If the rules for transferring measurement output items change, such as adjustments to debit and credit accounts, accounting change reasons, or consolidation types, the generated financial vouchers will also change accordingly.
[0069] The measurement output item transfer rules in this application are simple to configure, easy to read and maintain. By automatically obtaining the measurement output item transfer rules and applying them to the conversion and aggregation of measurement result data, manual intervention is reduced and efficiency and accuracy are improved. Through automated and streamlined processing, financial vouchers can be generated more timely.
[0070] Figure 3 It is a flowchart of another method for generating financial vouchers provided by this application, such as Figure 3 As shown, the financial voucher generation method provided in this embodiment is a further refinement of the financial voucher generation method provided in the previous embodiment of this application. The financial voucher generation method provided in this embodiment includes the following steps:
[0071] Step S201, obtaining a metering output item transfer rule corresponding to a project code used to refer to a target metering scenario.
[0072] In this embodiment, the implementation of step S201 is the same as the implementation of step S101 in the previous embodiment, and will not be repeated here.
[0073] After step S201, the metering result data related to the target metering scenario during the metering period is extracted from the metering platform, that is, step S102 is executed. In some embodiments, step S102 is specifically implemented as the following steps S202-S203.
[0074] Step S202: When the status of the metering platform is a metering-completed and extractable status, the status of the accounting platform is updated from never having been certified to having been certified.
[0075] In this application, the accounting platform and the metering platform each record their current status. For example, the status of the accounting platform is not yet certified (which can be represented as N) or has been certified (which can be represented as S); the status of the metering platform is not ready to be completed (which can be represented as N) or completed (which can be represented as S). When the status of the metering platform is completed, it can be understood that the metering platform is in a metering completed and extractable state at this time.
[0076] Specifically, when the status of the metering platform is a metering-completed and extractable status, the verification result status of each metering category is automatically obtained, and when the verification result status is passed, data is extracted from the metering platform.
[0077] It should be noted that when the accounting platform status is certified, the measurement platform shall not be re-run.
[0078] In this application, the accounting platform also maintains an accounting platform status table, which contains multiple status items, including measurement period, provincial company, measurement category, version, measurement platform status, accounting platform status (synchronous), certificate status (asynchronous measurement), measurement platform update time and account number, and accounting platform update time and account number. Exemplarily, the provincial company is identified by the provincial company code, for example, the provincial company code is 1100; the measurement category is direct insurance (which can be represented as 01) or period-end LRC (which can be represented as PAA); the version is identified by the version number, for example, the current version number is 001; the measurement platform status is not ready (which can be represented as N) or completed (which can be represented as S); the accounting platform status is not certified (which can be represented as N) or certified (which can be represented as S); the certification status is certificate transfer start (which can be represented as 100), certificate transfer failure (which can be represented as 101), certificate transfer success (which can be represented as 109), posting start (which can be represented as 200), posting failure (which can be represented as 201), posting success (which can be represented as 209), write-off start (which can be represented as 990), partial write-off (which can be represented as 991) or write-off success (which can be represented as 999).
[0079] Step S203: extracting metering result data related to the target metering scenario during the metering period from the metering platform in batches according to multiple preset dimensions, and writing back the metering result status table.
[0080] Among them, multiple preset dimensions include measurement category, organization scope, measurement number, etc. The purpose of batching is to synchronize large amounts of measurement result data from the measurement platform to the accounting platform with high concurrency.
[0081] Among them, the measurement result status table is used to track and manage the status and results of the measurement process. The measurement result status table is used to record the different stages and status of the measurement process. For example, from "not started" to "in progress", to "completed" or "certified", etc., this helps to ensure that the processing progress of each measurement batch is clear and visible. When processing large amounts of data, the measurement results may be divided into multiple batches. The measurement result status table can record the status and related information of each batch, such as measurement number, processing time, etc., for easy management and query. When the measurement is completed and the accounting platform status is updated to "certified", the measurement result status table will be written back to reflect the latest processing status. This write-back mechanism helps to keep all relevant data in the system synchronized.
[0082] In some embodiments, after extracting the metering result data related to the target metering scenario during the metering period from the metering platform, the financial voucher generation method provided in the present application further includes the following steps S204-S205.
[0083] Step S204: Generate a version number for the measurement result data.
[0084] The version number is used to indicate the current version of the measurement result data to support data adjustment and change. For example, the version number is initially 001. For example, the offset rollback action is controlled according to the version number. If the previous version has been offset, it can be re-extracted to generate a new version number.
[0085] Step S205, determine whether the certificate making status is empty, if it is empty, update the certificate making status to start of certificate transfer.
[0086] Among them, if the certificate production status is empty, it means that the certificate production has not started yet, then the certificate production status can be updated to the start of the transfer.
[0087] Step S206, converting the measurement result data into financial data to obtain converted measurement result data.
[0088] Optionally, financial data conversion is performed on the measurement result data according to multiple conversion dimensions to obtain the converted measurement result data; the multiple conversion dimensions include institution, insurance type, channel, account, debit and credit identification, reason for accounting change, voucher type, reinsurance type, contract group, contract combination, measurement method, expense type, amount original currency and base currency.
[0089] Optionally, in the process of converting the measurement result data into financial data, dimension checking and processing are also performed. Specifically, for each conversion dimension, according to the check item corresponding to the conversion dimension in the subject dimension check table, if the check item of the conversion dimension is set as required, it is determined whether there is a value for the conversion dimension in the measurement result data, and if not, an error is recorded; if the check item of the conversion dimension is set to clear, the value on the conversion dimension is cleared. It should be noted that errors in the financial data conversion process need to be recorded in the error log table and deleted from the conversion result table.
[0090] After step S206, based on the measurement output item transfer rules, the converted measurement result data is summarized and posted to obtain a financial voucher, that is, step S104 is executed. In some embodiments, step S104 is specifically implemented as steps S207 to S209.
[0091] Step S207, according to the measurement output item transfer rules, the converted measurement result data is summarized to obtain summary data.
[0092] Optionally, the converted measurement result data is automatically aggregated according to multiple aggregation dimensions to obtain aggregated data. Aggregated data refers to a data set after the converted measurement result data is sorted and merged according to specific dimensions. The purpose of this process is to retain the dimensions required for the main accounting, reduce the amount of data, ensure that the number of data entries does not exceed a specific limit (such as 900 rows) when posting, and give priority to ensuring the balance of debits and credits. Exemplarily, the multiple aggregation dimensions include voucher type, consolidation type, currency, and company code.
[0093] Step S208, writing the summary order information back to the financial document.
[0094] The summary sheet information refers to the documents or records generated based on the summary data, which need to be written back to the original measurement result document table (financial document). For example, the summary sheet information includes the summary results, such as the total amount, the total number of items, and other key dimension information related to financial accounting.
[0095] Step S209, posting the summary data to obtain financial vouchers.
[0096] Optionally, call the system preset posting program to post the summary data.
[0097] It should be noted that if there is no obvious compression between the summary data and the detailed data, the summary will not be considered and the detailed data will be directly posted according to the dimension organization.
[0098] In some embodiments, the financial voucher generation method provided by the present application also includes: if the posting is successful, writing back the voucher number and recording the voucher status as successful posting; if the posting fails, recording the voucher status as a posting error and recording the error information.
[0099] Exemplarily, the error information is recorded in an error log table.
[0100] In some embodiments, the financial voucher generation method provided in the present application also includes the following step S210.
[0101] Step S210, check the financial documents with the measurement results, and check the financial documents with the accounting results to obtain the check results.
[0102] Optionally, the financial documents and the measurement results are specifically implemented as follows: obtaining the financial documents and the relevant data of the measurement platform, and comparing the amounts according to the organization code and the output item code. It should be noted that since there is one debit and one credit in the financial documents, the debit side is obtained uniformly.
[0103] Optionally, the financial documents and accounting results are checked by obtaining financial documents and voucher tables, and comparing the amounts according to company codes, subjects, and reasons for changes.
[0104] This embodiment provides an automated data verification solution. Compared with the prior art in which data verification is inconvenient and the correctness verification of sub-account accounting results relies on manual verification of forms, which is inefficient and labor-intensive, this embodiment improves verification efficiency and saves labor costs.
[0105] In some embodiments, the financial voucher generation method provided by the present application further includes:
[0106] If the verification result indicates that the financial document has incorrect data conversion and posting, the data recorded in the error log table will be re-converted and re-posted, and the incorrect batches in the measurement summary table will be re-posted;
[0107] If the verification result indicates that measurement error data conversion postings are made, the data recorded in the error log table and the errors in the measurement summary table shall be re-extracted and supplemented.
[0108] For the conversion posting of incorrect data in financial documents or incorrect data in business documents, it is necessary to determine whether the document production status is successfully posted. If it is successfully posted, the error processing is locked for this provincial company and unlocked after the execution is completed.
[0109] If the wrong data in the financial document is converted and posted, two parts of data need to be supplemented and posted. One part is the data recorded in the error log table, which needs to be re-converted and re-posted; the other part is to re-post the wrong batch in the measurement summary table.
[0110] If the conversion posting is due to incorrect measurement data, you need to re-extract and supplement the posting of the above two parts of data. Specifically, extract each item individually according to the measurement number. For incorrectly posted data, you need to use a summary sheet to find the detailed measurement number for re-extraction.
[0111] It should be noted that before re-posting, you need to delete the records in the error log table as well as the financial documents and summary data with posting errors.
[0112] In some embodiments, the financial voucher generation method provided by the present application further includes:
[0113] When the measurement platform needs to be re-measured, if the certificate status is successful posting or partial write-off, the wrong data that has been recorded will be rolled back;
[0114] Cancel the uncancelled voucher number. If the cancellation is successful, record the cancellation voucher and certificate status as successful cancellation, and update the status of the accounting platform to uncancelled voucher. If the cancellation fails, record the certificate status as cancellation error, and record the error information.
[0115] Specifically, when the metering platform needs to be re-measured, the previously calculated erroneous data that has been recorded needs to be rolled back. The prerequisite for rollback is that the certificate making status is successfully posted or partially offset. At this time, all the corresponding unoffended voucher numbers under this batch are offset. If the offset is successful, the offset voucher is recorded and the certificate making status is updated to be a successful offset. At the same time, the status of the accounting platform is updated to no certificate; if the offset fails, the offset error is recorded and the certificate making status is updated to be a offset error; if the certificate making status is 999 (successful offset).
[0116] When the initial transfer is posted, if the certificate status is judged to be successfully offset, the version number is updated +1, the certificate status is updated to the start of the transfer, and the previous version data that has been offset is transferred to the archive table.
[0117] It can be seen that this embodiment provides a rollback and cancellation mechanism for erroneous data. Compared with the prior art in which no cancellation or rollback mechanism is designed when sub-account data is erroneous or entry is erroneous, manual error handling is required, and the technical problem of low efficiency is solved, this embodiment can automatically handle erroneous data and improve processing efficiency.
[0118] This application abstracts the business scenarios into data through customized and simplified configurations, flexibly splits batches according to the amount of data, and achieves rapid integration of small batches and high concurrency; through the synchronization and tracking of status tracks, the entire process is automated to achieve data conversion, certification and verification.
[0119] Figure 4 It is a structural diagram of a financial voucher generation device provided by the present application, such as Figure 4As shown, in this embodiment, the financial voucher generation device 30 can be set in a server, and the server is used to provide background services for the accounting platform. The financial voucher generation device 30 includes:
[0120] The acquisition module 301 is used to acquire the metering output item transfer rule corresponding to the project code used to refer to the target metering scenario; the metering output item transfer rule includes multiple parameter items, and the multiple parameter items include project code, description, debit account, credit account, accounting change reason, amount type, positive and negative processing, voucher type, consolidation type and other auxiliary information;
[0121] An extraction module 302, used to extract metering result data related to a target metering scenario during a metering period from a metering platform;
[0122] The conversion module 303 is used to convert the measurement result data into financial data to obtain the converted measurement result data;
[0123] The posting module 304 is used to summarize and post the converted measurement result data based on the measurement output item transfer rules to obtain financial vouchers.
[0124] In some embodiments, the extraction module 302 is used to:
[0125] When the status of the measurement platform is the measurement completed and extractable status, the status of the accounting platform is updated from never having been certified to having been certified;
[0126] The metering result data related to the target metering scenario during the metering period is extracted from the metering platform in batches according to multiple preset dimensions, and written back to the metering result status table.
[0127] In some embodiments, the extraction module 302 is further configured to, after extracting the metering result data related to the target metering scenario during the metering period from the metering platform:
[0128] The version number of the generated measurement result data;
[0129] Determine whether the certificate status is empty. If it is empty, update the certificate status to start the transfer.
[0130] In some embodiments, the posting module 304 is used to:
[0131] According to the transfer rules of measurement output items, the converted measurement result data are summarized to obtain the summary data;
[0132] Write the summary sheet information back to the financial document;
[0133] Post the summary data to obtain financial vouchers.
[0134] In some embodiments, the posting module 304 is further configured to:
[0135] If the posting is successful, the voucher number will be written back and the voucher status will be recorded as successful posting;
[0136] If the posting fails, the certificate status will be recorded as posting error, and the error information will be recorded.
[0137] In some embodiments, the posting module 304 is further configured to:
[0138] Compare the financial documents with the measurement results, and compare the financial documents with the accounting results to obtain the verification results.
[0139] In some embodiments, the posting module 304 is further configured to:
[0140] If the verification result indicates that the financial document has incorrect data conversion and posting, the data recorded in the error log table will be re-converted and re-posted, and the incorrect batches in the measurement summary table will be re-posted;
[0141] If the verification result indicates that measurement error data conversion postings are made, the data recorded in the error log table and the errors in the measurement summary table shall be re-extracted and supplemented.
[0142] In some embodiments, the posting module 304 is further configured to:
[0143] When the measurement platform needs to be re-measured, if the certificate status is successful posting or partial write-off, the wrong data that has been recorded will be rolled back;
[0144] Cancel the uncancelled voucher number. If the cancellation is successful, record the cancellation voucher and certificate status as successful cancellation, and update the status of the accounting platform to uncancelled voucher. If the cancellation fails, record the certificate status as cancellation error, and record the error information.
[0145] The financial voucher generation device 30 provided in this embodiment can execute the technical solution of the corresponding method embodiment. Its implementation principle and technical effect are similar to those of the corresponding method embodiment, and will not be repeated here.
[0146] The embodiment of the present application also provides a server. Figure 5 This is a schematic diagram of the structure of a server provided by this application. Figure 5 As shown, the server 40 includes: a processor 401 and a memory 402 communicatively connected to the processor 401 .
[0147] The memory 402 stores computer-executable instructions; the processor 401 executes the computer-executable instructions stored in the memory 402 to implement the financial voucher generation method provided in this application.
[0148] In the embodiment of the present application, the memory 402 and the processor 401 are connected via a bus. The bus may be an Industry Standard Architecture (ISA) bus, a Peripheral Component Interconnect (PCI) bus, or an Extended Industry Standard Architecture (EISA) bus, etc. The bus may be divided into an address bus, a data bus, a control bus, etc.
[0149] The components, their connections and relationships, and their functions shown herein are only examples and are not intended to limit the implementation of the present application described and / or required herein. The various components are interconnected using different buses and can be installed on a common motherboard or in other ways as needed.
[0150] In an exemplary embodiment, a computer-readable storage medium is also provided, in which computer-executable instructions are stored. When the computer-executable instructions are executed by a processor, they are used to implement the financial voucher generation method provided in the present application.
[0151] In an exemplary embodiment, a computer program product is also provided, including a computer program, which is used to implement the financial voucher generation method provided in the present application when the computer program in the computer program product is executed by a processor.
[0152] It should be noted that, for the aforementioned method embodiments, for the sake of simplicity, they are all expressed as a series of action combinations, but those skilled in the art should be aware that the present application is not limited by the described order of actions, because according to the present application, certain steps can be performed in other orders or simultaneously. Secondly, those skilled in the art should also be aware that the embodiments described in the specification are all optional embodiments, and the actions and modules involved are not necessarily required by the present application.
[0153] It should be further noted that, although the various steps in the flowchart are displayed in sequence according to the indication of the arrows, these steps are not necessarily executed in sequence in the order indicated by the arrows. Unless there is a clear description in this article, the execution of these steps is not strictly limited in order, and these steps can be executed in other orders. Moreover, at least a portion of the steps in the flowchart may include multiple sub-steps or multiple stages, and these sub-steps or stages are not necessarily executed at the same time, but can be executed at different times, and the execution order of these sub-steps or stages is not necessarily to be carried out in sequence, but can be executed in turn or alternately with other steps or at least a portion of the sub-steps or stages of other steps.
[0154] It should be understood that the above-mentioned device embodiments are only illustrative, and the device of the present application can also be implemented in other ways. For example, the division of units / modules in the above-mentioned embodiments is only a logical function division, and there may be other division methods in actual implementation. For example, multiple units, modules or components can be combined, or can be integrated into another system, or some features can be ignored or not executed.
[0155] In addition, unless otherwise specified, each functional unit / module in each embodiment of the present application may be integrated into one unit / module, each unit / module may exist physically separately, or two or more units / modules may be integrated together. The above-mentioned integrated unit / module may be implemented in the form of hardware or in the form of a software program module.
[0156] If the integrated unit / module is implemented in the form of hardware, the hardware may be a digital circuit, an analog circuit, etc. The physical implementation of the hardware structure includes but is not limited to transistors, memristors, etc. Unless otherwise specified, the processor may be any appropriate hardware processor, such as a central processing unit (CPU), a graphics processing unit (GPU), an application specific integrated circuit (ASIC), a digital signal processor (DSP), a programmable logic device (PLD), a field programmable gate array (FPGA), a controller, a microcontroller, a microprocessor or other electronic components. Unless otherwise specified, the memory can be implemented by any type of volatile or non-volatile storage device or a combination of them, such as a USB flash drive, random-access memory (RAM), static random-access memory (SRAM), dynamic random-access memory (DRAM), enhanced dynamic random-access memory (EDRAM), electrically erasable programmable read-only memory (EEPROM), erasable programmable read-only memory (EPROM), programmable read-only memory (PROM), read-only memory (ROM), high-bandwidth memory (HBM) or hybrid memory cube (HMC) and other media that can store program code.
[0157] If the integrated unit / module is implemented in the form of a software program module and sold or used as an independent product, it can be stored in a computer-readable memory. Based on this understanding, the technical solution of the present application is essentially or the part that contributes to the prior art or all or part of the technical solution can be embodied in the form of a software product, and the computer software product is stored in a memory, including a number of instructions for a server to execute all or part of the steps of the various embodiments of the present application.
[0158] In the above embodiments, the description of each embodiment has its own emphasis. For the part not described in detail in a certain embodiment, please refer to the relevant description of other embodiments. The technical features of the above embodiments can be combined arbitrarily. In order to make the description concise, all possible combinations of the technical features in the above embodiments are not described. However, as long as there is no contradiction in the combination of these technical features, they should be considered to be within the scope of this specification.
[0159] Those skilled in the art will readily appreciate other embodiments of the present application after considering the specification and practicing the invention disclosed herein. The present application is intended to cover any modification, use or adaptation of the present application, which follows the general principles of the present application and includes common knowledge or customary techniques in the art that are not disclosed in the present application. The specification and examples are intended to be exemplary only, and the true scope and spirit of the present application are indicated by the claims.
[0160] It should be understood that the present application is not limited to the precise structures that have been described above and shown in the drawings, and that various modifications and changes may be made without departing from the scope thereof. The scope of the present application is limited only by the appended claims.
Claims
1. A method for generating financial vouchers, characterized in that: Applied to an accounting platform, the method comprises: Obtaining a measurement output item transfer rule corresponding to a project code used to refer to a target measurement scenario; the measurement output item transfer rule comprises a plurality of parameter items, and the plurality of parameter items comprises a project code, a description, a debit account, a credit account, a reason for accounting changes, an amount type, positive and negative processing, a voucher type, a consolidation type, and other auxiliary information; Extracting metering result data related to the target metering scenario during the metering period from the metering platform; Performing financial data conversion on the measurement result data to obtain converted measurement result data; Based on the measurement output item transfer rules, the converted measurement result data is summarized and posted to obtain a financial voucher.
2. The method according to claim 1, characterized in that The extracting, from the metering platform, metering result data related to the target metering scenario during the metering period includes: When the status of the metering platform is a metering-completed extractable status, the status of the accounting platform is updated from never having been certified to having been certified; The metering result data related to the target metering scenario during the metering period are extracted from the metering platform in batches according to multiple preset dimensions, and the metering result status table is written back.
3. The method according to claim 1, characterized in that After extracting the metering result data related to the target metering scenario during the metering period from the metering platform, the method further includes: Generate a version number of the measurement result data; Determine whether the certificate status is empty. If it is empty, update the certificate status to start the transfer.
4. The method according to claim 1, characterized in that: Based on the measurement output item transfer rule, the converted measurement result data is summarized and posted to obtain a financial voucher, including: According to the measurement output item transfer rule, the converted measurement result data is summarized to obtain summary data; Write the summary sheet information back to the financial document; Post the summary data to obtain financial vouchers.
5. The method according to claim 4, characterized in that Also includes: If the posting is successful, the voucher number will be written back and the voucher status will be recorded as successful posting; If the posting fails, the certificate status will be recorded as posting error, and the error information will be recorded.
6. The method according to claim 4, characterized in that Also includes: The financial documents are checked against the measurement results, and the financial documents are checked against the accounting results to obtain a check result.
7. The method according to claim 6, characterized in that Also includes: If the verification result indicates that the financial document has incorrect data conversion and posting, the data recorded in the error log table will be re-converted and re-posted, and the incorrect batches in the measurement summary table will be re-posted; If the verification result indicates that measurement error data conversion postings are made, the data recorded in the error log table and the errors in the measurement summary table shall be re-extracted and supplemented.
8. The method according to claim 7, characterized in that Also includes: When the metering platform needs to be re-measured, if the certificate status is successful posting or partial write-off, the wrong data that has been recorded will be rolled back; The uncancelled voucher number is cancelled. If the cancellation is successful, the cancellation voucher and the certificate status are recorded as successful cancellation, and the status of the accounting platform is updated to uncertified; if the cancellation fails, the certificate status is recorded as cancellation error, and the error information is recorded.
9. A financial voucher generating device, characterized in that: Set in the accounting platform, the device includes: An acquisition module, used to acquire a metering output item transfer rule corresponding to a project code used to refer to a target metering scenario; the metering output item transfer rule includes multiple parameter items, and the multiple parameter items include a project code, description, debit account, credit account, accounting change reason, amount type, positive and negative processing, voucher type, consolidation type and other auxiliary information; An extraction module, used to extract metering result data related to the target metering scenario during the metering period from the metering platform; A conversion module, used for performing financial data conversion on the measurement result data to obtain converted measurement result data; The posting module is used to summarize and post the converted measurement result data based on the measurement output item transfer rule to obtain a financial voucher.
10. A server, characterized in that: include: A processor and a memory communicatively connected to the processor; The memory stores computer-executable instructions; The processor executes the computer-executable instructions stored in the memory to implement the financial voucher generation method according to any one of claims 1 to 8.
11. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores computer-executable instructions, which, when executed by a processor, are used to implement the financial voucher generation method according to any one of claims 1 to 8.
12. A computer program product, comprising a computer program, characterized in that When the computer program is executed by a processor, the financial voucher generation method according to any one of claims 1 to 8 is implemented.