Voucher number change synchronization business document implementation method and system

Abstract

The invention relates to the technical field of fund settlement, and provides a method and a system for realizing a voucher number change synchronization business document. The method comprises the following steps: constructing a change table according to a corresponding relation between a voucher inner code and a business document inner code based on the voucher inner code, a new voucher number, an old voucher number, a business document type and the business document inner code; if the business documents and the vouchers are in a one-to-many relationship, obtaining all voucher inner codes, new voucher numbers and old voucher numbers corresponding to each business document from the change table according to a paging rule, a business document type and business document inner codes, and constructing a temporary intermediate table according to the corresponding relationship between the business document inner codes and the voucher inner codes, and updating the voucher information corresponding to the business document according to the business document inner code. According to the method and the device, the business documents can be synchronously adjusted in batches, the workload is reduced, the data processing speed is increased, the data processing effect is improved, and the computer performance is improved.

Description

Technical Field

[0001] The present invention relates to the technical field of funds settlement, and in particular to a method and system for implementing business document synchronization with voucher number changes. Background Art

[0002] The statements in this section merely provide background information related to the present invention and do not necessarily constitute prior art.

[0003] Adjusting voucher numbers is a crucial step in financial management. To avoid duplicate numbers and maintain number continuity, all generated voucher numbers must be adjusted. This also requires adjusting the voucher numbers on all business documents containing the voucher numbers.

[0004] Considering the complex relationships between business documents and vouchers, which can range from one-to-one, one-to-many, and many-to-many, and the massive data volumes of many large projects, which can reach hundreds of thousands, adjusting voucher information individually can result in incomplete adjustment of the voucher numbers recorded in the business documents. This requires manual verification, which is not only labor-intensive but also subject to significant errors, resulting in inaccurate data in the adjusted business documents. Summary of the Invention

[0005] In order to solve the technical problems existing in the above-mentioned background technology, the present invention provides a method and system for synchronizing business documents with voucher number changes. The present invention converts data mainly based on voucher internal codes into data mainly based on business documents by constructing a change table, and can realize business document updates in multiple scenarios.

[0006] In order to achieve the above object, the present invention adopts the following technical solutions: A first aspect of the present invention provides a method for implementing business document synchronization with voucher number changes.

[0007] A method for implementing synchronized business documents for voucher number changes, comprising: Based on the voucher internal code, new voucher number, old voucher number, business document type, and business document internal code, a change table is constructed according to the correspondence between the voucher internal code and the business document internal code; If the relationship between business documents and vouchers is one-to-many, according to the paging rules, based on the business document type and the business document internal code, all voucher internal codes, new voucher numbers, and old voucher numbers corresponding to each business document are obtained from the change table. Based on the correspondence between the business document internal codes and the voucher internal codes, a temporary intermediate table is constructed to update the voucher information corresponding to the business document according to the business document internal code.

[0008] Furthermore, the paging rule is: extracting a set number of data items contained in each page from the change table.

[0009] Furthermore, when organizing business document information in each page, the business document internal code of the processed voucher information is recorded, and the business document internal code of the processed voucher information is no longer processed in a new page.

[0010] Furthermore, if the business document and voucher have a many-to-many relationship, the relationship is broken down into a one-to-many relationship between the business document and voucher.

[0011] Furthermore, before determining whether the business document and the voucher are in a one-to-many relationship, the method further includes: determining whether the business document and the voucher are in a one-to-one relationship; if so, updating the voucher document number according to the voucher content code.

[0012] Furthermore, the temporary intermediate table includes: the business document internal code, all voucher internal codes corresponding to the business document, and the new voucher number.

[0013] A second aspect of the present invention provides a system for implementing business document synchronization with voucher number changes.

[0014] A system for implementing synchronized business documents for voucher number changes, comprising: A change table construction module is configured to: construct a change table based on the voucher internal code, the new voucher number, the old voucher number, the business document type, and the business document internal code, according to the correspondence between the voucher internal code and the business document internal code; The business document update module is configured as follows: if there is a one-to-many relationship between a business document and a voucher, according to the paging rules, based on the business document type and the business document internal code, all voucher internal codes, new voucher numbers, and old voucher numbers corresponding to each business document are obtained from the change table; based on the correspondence between the business document internal code and the voucher internal code, a temporary intermediate table is constructed to update the voucher information corresponding to the business document according to the business document internal code.

[0015] A third aspect of the present invention provides a computer device, comprising: a processor adapted to execute a computer program; Computer-readable storage medium, in which a computer program is stored. When the computer program is executed by a processor, the steps in the method for implementing business documents for synchronizing voucher number changes as described in the first aspect above are implemented.

[0016] The fourth aspect of the present invention provides a computer-readable storage medium storing a computer program, which is suitable for being loaded by a processor and executing the steps in the method for implementing business documents for synchronizing voucher number changes as described in the first aspect above.

[0017] A fifth aspect of the present invention provides a computer program product or computer program.

[0018] The present invention provides a computer program product or computer program, comprising computer instructions stored in a computer-readable storage medium. A processor of a computer device reads the computer instructions from the computer-readable storage medium and executes the computer instructions, causing the computer device to perform the steps of the method for synchronizing business documents with voucher number changes as described in the first aspect above.

[0019] Compared with the prior art, the present invention has the following beneficial effects: The present invention provides a method and system for synchronizing business documents with voucher number changes. The method comprises: constructing a change table based on the voucher internal code, new voucher number, old voucher number, business document type, and business document internal code, according to the correspondence between the voucher internal code and the business document internal code; if the business document and the voucher have a one-to-many relationship, obtaining all voucher internal codes, new voucher numbers, and old voucher numbers corresponding to each business document from the change table according to paging rules, based on the business document type and the business document internal code; constructing a temporary intermediate table based on the correspondence between the business document internal code and the voucher internal code, and updating the voucher information corresponding to the business document according to the business document internal code. The present invention can synchronize business documents in batches, reducing workload while improving data processing speed and efficiency, and enhancing computer performance.

[0020] When the voucher number is adjusted, the business document can quickly synchronize the change of the voucher number through the voucher number change synchronization business document implementation method and system described in the present invention. This is very beneficial to the stable and efficient operation of the entire ERP system, and further provides greater value for enterprise users. BRIEF DESCRIPTION OF THE DRAWINGS

[0021] The accompanying drawings, which constitute a part of the present invention, are used to provide a further understanding of the present invention. The exemplary embodiments of the present invention and their descriptions are used to explain the present invention and do not constitute improper limitations on the present invention.

[0022] Figure 1 This is a flow chart of a method for implementing business document synchronization with voucher number changes according to an embodiment of the present invention; Figure 2 This is a schematic diagram of a specific implementation method for synchronizing business documents with voucher number changes according to an embodiment of the present invention; Figure 3 This is a structural diagram of a system for implementing synchronized business documents for voucher number changes according to an embodiment of the present invention; Figure 4 It is a structural diagram of a computer device shown in an embodiment of the present invention. DETAILED DESCRIPTION

[0023] The present invention will be further described below with reference to the accompanying drawings and embodiments.

[0024] It should be noted that the following detailed descriptions are illustrative and intended to provide further explanation of the present invention. Unless otherwise specified, all technical and scientific terms used herein have the same meanings as those commonly understood by those skilled in the art to which the present invention belongs.

[0025] It should be noted that the terms used herein are only for describing specific embodiments and are not intended to limit the exemplary embodiments according to the present invention. As used herein, unless the context clearly indicates otherwise, the singular form is intended to include the plural form. In addition, it should be understood that when the terms "comprise" and / or "include" are used in this specification, they indicate the presence of features, steps, operations, devices, components and / or combinations thereof.

[0026] In order to facilitate understanding of the technical solution of the present invention, some technical terms involved in the present invention are introduced below.

[0027] Business documents are the vouchers for recording transactions or operations during business activities, used to prove the authenticity of business transactions and clarify the relationship between rights and responsibilities. Whether in paper or electronic form, documents are used throughout all aspects of business processes, such as procurement, sales, inventory management, etc., and constitute the core information carrier of business operations. Vouchers are written documents used in financial accounting, mainly used to record economic transactions, clarify responsibilities, and serve as the basis for accounting and auditing.

[0028] Based on this, the present invention provides a fast and stable method and system for synchronizing business documents with voucher number changes, which synchronizes changes in voucher numbers caused by deleting vouchers to business documents by setting a scheduled task.

[0029] Figure 1 This is a flowchart of a method for implementing a synchronized business document with a voucher number change according to an embodiment of the present invention; Figure 1 , the method comprising: Based on the voucher internal code, new voucher number, old voucher number, business document type, and business document internal code, a change table is constructed according to the correspondence between the voucher internal code and the business document internal code; If the relationship between business documents and vouchers is one-to-many, according to the paging rules, based on the business document type and the business document internal code, all voucher internal codes, new voucher numbers, and old voucher numbers corresponding to each business document are obtained from the change table. Based on the correspondence between the business document internal codes and the voucher internal codes, a temporary intermediate table is constructed to update the voucher information corresponding to the business document according to the business document internal code.

[0030] In this embodiment, vouchers include: Original vouchers: filled out by the handling personnel, directly reflecting business facts, such as invoices, bank receipts, and contracts; Accounting vouchers: prepared by accounting personnel based on original vouchers and organized by accounting subjects, such as payment vouchers and receipt vouchers; General ledger vouchers: generated by summarizing multiple business vouchers and used for general ledger system accounting.

[0031] In some embodiments, the original voucher may generally include the following key fields: voucher name, filling date, voucher number, filling unit / person, receiving unit name, economic business content, business summary, quantity, unit price and amount, tax information, signature of the person in charge, payment method, additional terms or notes.

[0032] In some embodiments, the accounting voucher may generally include the following key fields: voucher number, filling date, business summary, accounting subject, amount information, number of attachments, responsible signature, unit information, and remarks.

[0033] In some embodiments, the general ledger voucher may typically include the following key fields: accounting organization, account book, voucher date, accounting period, voucher code, voucher number, summary, accounting subject, accounting dimension, currency, exchange rate, original currency amount, debit amount, credit amount, total, creator, reviewer, poster, reviewer, number of attachments, and whether cash flow items have been prepared.

[0034] In this embodiment, business documents include: (1) sales business documents: sales orders (recording customer needs), sales invoices (confirmation of transaction amounts); (2) procurement business documents: purchase orders (supplier agreements), purchase receipts (goods acceptance); (3) inventory business documents: inbound notes (receiving goods), outbound notes (distributing goods); (4) finance-related business documents: payment applications, expense reimbursement forms.

[0035] Business documents typically include the following key fields: document type, coupon rate, code, sales organization, bill number, maturity amount, collection date, sales department, currency, drawer, beneficiary organization, salesperson, exchange rate, acceptor, settlement organization, settlement status, issue date, acceptance agreement number, payee, face value, maturity date, acceptance date, payment period, face value, whether electronic invoice, whether with recourse, whether revocable, bank information, endorsement information, reference document, and other. Bank information specifically includes: beneficiary bank, paying bank, beneficiary bank account number, paying bank account number, beneficiary bank name, and paying bank name.

[0036] When the voucher number is adjusted, through this method, the business document can quickly synchronize the change of the voucher number, which is very beneficial to the stable and efficient operation of the entire ERP system, and further provides greater value for enterprise users.

[0037] In this embodiment, the data in the change table has a corresponding relationship, for example, the voucher internal code corresponds to the business document internal code it describes; the voucher internal code, new voucher number, business document type, and business document internal code are respectively stored in different fields of the same row of data in the change table.

[0038] In one or more embodiments, the paging rule is: extracting a set number of data items contained in each page from the change table.

[0039] In one or more embodiments, when organizing business document information in each page, the business document internal code of the processed voucher information is recorded, and the business document internal code of the processed voucher information is no longer processed in a new page.

[0040] In one or more embodiments, if the business document and the voucher are in a many-to-many relationship, the relationship is broken down into a one-to-many relationship between the business document and the voucher.

[0041] In one or more embodiments, before determining whether the business document and the voucher are in a one-to-many relationship, the process further includes: determining whether the business document and the voucher are in a one-to-one relationship; if so, updating the voucher document number according to the voucher content code.

[0042] In one or more embodiments, the temporary intermediate table includes: a business document internal code, all voucher internal codes corresponding to the business document, and a new voucher number.

[0043] Figure 2 This is a schematic diagram of a specific implementation method for implementing a business document synchronization method for a voucher number change according to an embodiment of the present invention; Figure 2 , the method comprising: Determine whether the relationship between business documents and vouchers is one-to-one; If yes, in a one-to-one business document and voucher scenario, synchronize the business document based on the voucher ID; Otherwise, in one-to-many or many-to-many scenarios between business documents and vouchers, data is extracted from the change table in paging mode; Determine whether the changed voucher can still be retrieved. If so, directly obtain the latest voucher information corresponding to the business document ID in the voucher change record if it does not exist in the temporary table. Store the obtained voucher information in the temporary table. After the current paging is completed, iteratively extract data from the changed table by paging. Otherwise, directly synchronize the business document based on the business document ID (business document internal code) in the temporary table and clear the temporary table.

[0044] The present invention addresses scenarios involving one-to-one, one-to-many, and many-to-many relationships between business documents and vouchers. First, the voucher party is required to store any changed vouchers in a separate data table, containing the voucher internal code, the old and new voucher numbers, and the business document type. Furthermore, for vouchers with a one-to-many relationship between a document and a voucher, the business document internal code must also be stored. This data table, called a change table, stores all changed voucher data. For a one-to-one relationship between a business document and a voucher, the voucher document number can be directly updated using the voucher internal code, since the document stores the voucher internal code. For a one-to-many relationship between a business document and a voucher, a temporary intermediate table is used. The intermediate table is organized using data retrieved from the change table. This table's function is to adjust the data in the change table, which primarily focuses on voucher information, to data primarily focused on business documents. The intermediate table records the document internal code, as well as information about all voucher internal codes and voucher numbers corresponding to the business document. This allows the voucher number to be directly updated based on the content of the business document. When the business document and voucher have a many-to-many relationship, they can be broken down into multiple many-to-one relationships for processing.

[0045] When organizing temporary intermediate tables, we utilize paging and caching mechanisms to ensure efficiency and stability. We process a portion of data at a time, caching useful information for reuse and reducing data interaction. We've verified that we currently use a page of 500 data items, fetching them from the database into the cache for processing. The specific steps are as follows: 1. Take out 500 pieces of data from the data for processing each time; 2. Find the corresponding business document information from the 500 data pages obtained, further obtain all the voucher information corresponding to the business document, and then organize the correspondence between the business document ID and the voucher and store it in a temporary table; 3. When organizing business document information on each page, record the business document ID of the processed voucher information and do not process the business document again in the new page; 4. After all voucher change information is processed, update the voucher information corresponding to the business document directly through the temporary table based on the business document ID. After processing is complete, delete the data in the temporary table.

[0046] For business payment requisitions, after a voucher is generated, the voucher ID and number are recorded on the document. If a previous voucher is deleted, a scheduled task is configured in the system to automatically synchronize the voucher number with the business document at a specific time each morning. This executes the synchronization logic described above for business payment requisitions, automatically updating the voucher number on the business document.

[0047] Through the above scheme, the present invention can efficiently and stably handle the scenario of business document synchronization voucher numbering. After using this method on the project, the server performance has been greatly released, and there is no longer a situation where the entire application is stuck due to the synchronization of voucher numbers, affecting user use.

[0048] Combination of the above Figure 1 、 Figure 2 The method for implementing synchronized business documents with voucher number changes provided by an embodiment of the present invention is introduced in detail. Next, the system for implementing synchronized business documents with voucher number changes provided by an embodiment of the present invention will be introduced with reference to the accompanying drawings.

[0049] Figure 3 This is a schematic diagram of the structure of the system for implementing the synchronization of voucher number changes in an embodiment of the present invention, referring to Figure 3 , the system of the present invention comprises: A change table construction module is configured to: construct a change table based on the voucher internal code, the new voucher number, the old voucher number, the business document type, and the business document internal code, according to the correspondence between the voucher internal code and the business document internal code; The business document update module is configured as follows: if there is a one-to-many relationship between a business document and a voucher, according to the paging rules, based on the business document type and the business document internal code, all voucher internal codes, new voucher numbers, and old voucher numbers corresponding to each business document are obtained from the change table; based on the correspondence between the business document internal code and the voucher internal code, a temporary intermediate table is constructed to update the voucher information corresponding to the business document according to the business document internal code.

[0050] In some embodiments, the paging rule is: extracting a set number of data items contained in each page from the change table.

[0051] In some embodiments, when organizing business document information in each page, the business document internal code of the processed voucher information is recorded, and the business document internal code of the processed voucher information is no longer processed in the new page.

[0052] In some embodiments, if the business document and the voucher are in a many-to-many relationship, the relationship is broken down into a one-to-many relationship between the business document and the voucher.

[0053] In some embodiments, before determining whether the business document and the voucher are in a one-to-many relationship, the method further includes: determining whether the business document and the voucher are in a one-to-one relationship; if so, updating the voucher document number according to the voucher content code.

[0054] In some embodiments, the temporary intermediate table includes: the business document internal code, all voucher internal codes corresponding to the business document, and the new voucher number.

[0055] When the voucher number is adjusted, the business document can quickly synchronize the change of the voucher number through the voucher number change synchronization business document implementation method and system described in the present invention. This is very beneficial to the stable and efficient operation of the entire ERP system, and further provides greater value for enterprise users.

[0056] According to an embodiment of the present invention, the system for implementing synchronous business documents for changing voucher numbers may correspond to the method described in the embodiment of the present invention, and the above and other operations and / or functions of each module of the system for implementing synchronous business documents for changing voucher numbers are respectively to implement Figure 1 For the sake of brevity, the corresponding processes of each method in are not repeated here.

[0057] See also Figure 4 The computer device shown in the figure includes a processor, a communication interface, and a computer-readable storage medium. The processor, communication interface, and computer-readable storage medium can be connected via a bus or other means. The communication interface is used to receive and send data. The computer-readable storage medium can be stored in the computer device's memory, which stores a computer program comprising program instructions. The processor is used to execute the program instructions stored in the computer-readable storage medium. The processor (also known as a CPU (Central Processing Unit)) is the computing and control core of the computer device and is adapted to execute one or more instructions, specifically loading and executing one or more instructions to implement the corresponding steps in the embodiment of the method for synchronizing business documents with voucher number changes.

[0058] This embodiment provides a computer-readable storage medium (Memory). This computer-readable storage medium is a memory device within a computer device that is used to store programs and data. It should be understood that the computer-readable storage medium herein may include both built-in storage media within the computer device and, of course, extended storage media supported by the computer device. The computer-readable storage medium provides storage space that stores the processing system of the computer device. Furthermore, the storage space also stores one or more instructions suitable for being loaded and executed by the processor. These instructions may be one or more computer programs (including program code). It should be noted that the computer-readable storage medium herein may be a high-speed RAM memory or a non-volatile memory, such as at least one disk storage device; alternatively, it may be at least one computer-readable storage medium located remotely from the processor.

[0059] In one embodiment, one or more instructions are stored in the computer-readable storage medium; the processor loads and executes the one or more instructions stored in the computer-readable storage medium to implement the corresponding steps in the above-mentioned embodiment of the method for implementing the synchronization of business documents with voucher number changes.

[0060] This embodiment provides a computer program product or computer program, which includes computer instructions stored in a computer-readable storage medium. A processor of a computer device reads the computer instructions from the computer-readable storage medium and executes the computer instructions, causing the computer device to perform the corresponding steps of the embodiment of the method for synchronizing business documents with voucher number changes.

[0061] Those skilled in the art will appreciate that embodiments of the present invention may be provided as methods, systems, or computer program products. Thus, the present invention may take the form of hardware embodiments, software embodiments, or embodiments combining software and hardware. Furthermore, 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 magnetic disk storage and optical storage, etc.) containing computer-usable program code.

[0062] The present invention is described with reference to flowcharts and / or block diagrams of methods, devices (systems), and computer program products according to embodiments of the present invention. It should be understood that each process and / or block in the flowcharts and / or block diagrams, as well as combinations of processes and / or blocks in the flowcharts and / or block diagrams, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, a special-purpose computer, an embedded processor, or other programmable data processing device to produce a machine, so that the instructions executed by the processor of the computer or other programmable data processing device generate instructions for implementing the processes in the flowcharts and / or block diagrams. 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.

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

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

[0065] Those skilled in the art will appreciate that all or part of the processes in the above-described method embodiments can be implemented by instructing the relevant hardware through a computer program. The program can be stored in a computer-readable storage medium. When executed, the program can include the processes in the above-described method embodiments. The storage medium can be a magnetic disk, an optical disk, a read-only memory (ROM), or a random access memory (RAM).

[0066] The foregoing description is merely a preferred embodiment of the present invention and is not intended to limit the present invention. Those skilled in the art will readily appreciate that various modifications and variations of the present invention are possible. Any modifications, equivalent substitutions, or improvements made within the spirit and principles of the present invention shall be included within the scope of protection of the present invention.

Claims

1. A method for implementing business document synchronization with voucher number changes, characterized in that: include: Based on the voucher internal code, new voucher number, old voucher number, business document type, and business document internal code, a change table is constructed according to the correspondence between the voucher internal code and the business document internal code; If the relationship between business documents and vouchers is one-to-many, according to the paging rules, based on the business document type and the business document internal code, all voucher internal codes, new voucher numbers, and old voucher numbers corresponding to each business document are obtained from the change table. Based on the correspondence between the business document internal codes and the voucher internal codes, a temporary intermediate table is constructed to update the voucher information corresponding to the business document according to the business document internal code.

2. The method for implementing synchronized business documents for voucher number changes according to claim 1, characterized in that: The paging rule is: extracting a set number of data items contained in each page from the change table.

3. The method for implementing synchronized business documents for voucher number changes according to claim 2, characterized in that: When organizing business document information on each page, the business document internal code of the processed voucher information is recorded. The business document internal code of the processed voucher information will not be processed again in the new page.

4. The method for implementing synchronized business documents for voucher number changes according to claim 1, characterized in that: If the relationship between business documents and vouchers is many-to-many, the relationship is split into one-to-many relationship between business documents and vouchers.

5. The method for implementing synchronized business documents for voucher number changes according to claim 1, characterized in that: Before determining whether the business document and the voucher are in a one-to-many relationship, the method further includes: determining whether the business document and the voucher are in a one-to-one relationship; if so, updating the voucher document number according to the voucher content code.

6. The method for implementing synchronized business documents for voucher number changes according to claim 1, characterized in that: The temporary intermediate table includes: the business document internal code, all voucher internal codes corresponding to the business document, and the new voucher number.

7. A system for implementing synchronized business documents for voucher number changes, characterized in that: include: A change table construction module is configured to: construct a change table based on the voucher internal code, the new voucher number, the old voucher number, the business document type, and the business document internal code, according to the correspondence between the voucher internal code and the business document internal code; The business document update module is configured as follows: if there is a one-to-many relationship between a business document and a voucher, according to the paging rules, based on the business document type and the business document internal code, all voucher internal codes, new voucher numbers, and old voucher numbers corresponding to each business document are obtained from the change table; based on the correspondence between the business document internal code and the voucher internal code, a temporary intermediate table is constructed to update the voucher information corresponding to the business document according to the business document internal code.

8. A computer device, characterized in that: a processor adapted to execute a computer program; A computer-readable storage medium having a computer program stored therein, wherein when the computer program is executed by the processor, the steps of the method for implementing business documents for synchronizing voucher number changes as described in any one of claims 1 to 6 are implemented.

9. A computer-readable storage medium, characterized in that The computer-readable storage medium stores a computer program, which is suitable for being loaded by a processor and executing the steps in the method for implementing business document synchronization with voucher number changes as described in any one of claims 1 to 6.

10. A computer program product, characterized in that The computer program product includes a computer program, and when the computer program is executed by a processor, the computer program implements the steps of the method for implementing business documents for synchronization of voucher number changes according to any one of claims 1 to 6.

Images