Accounting document automatic transmission method, device, equipment and medium

Abstract

The invention provides an accounting document automatic transmission method and device, equipment and a medium, and belongs to the technical field of financial automation, and the method comprises the steps: extracting accounting documents to be transmitted from a document management system at regular intervals, and storing the accounting documents to an intermediate database table; according to an auxiliary accounting item requirement of a financial management system, executing multi-level priority derivation logic conversion on the extracted accounting document data, and storing the accounting document data into a target table; determining a voucher merging dimension and a merging number N, searching target accounting vouchers meeting requirements according to the voucher merging dimension, merging the target accounting vouchers according to a mode that every N accounting vouchers are merged into one, and creating a virtual voucher number for the merged accounting vouchers; and transmitting the merged accounting document information to a financial management system, generating an accounting document number, and establishing association with the virtual document number. According to the invention, the efficiency and accuracy of accounting document transmission are improved, the error risk caused by manual intervention is reduced, the system load is reduced by combining the documents, and the overall transmission efficiency is improved.

Description

TECHNICAL FIELD

[0001] The application belongs to the technical field of financial automation, and particularly relates to a method and device for automatically transmitting accounting vouchers, equipment and a medium. BACKGROUND

[0002] In group enterprise financial management, the voucher management system and the financial management system usually operate independently, and there are significant differences between the two in field definition of accounting vouchers, auxiliary accounting items (such as departments and counterparties) and business logic. The traditional way of voucher transmission relies on manual checking and conversion of each item, which is inefficient and prone to data errors due to human intervention, affecting the accuracy and timeliness of financial statements.

[0003] In addition, multi-dimensional financial statements (such as consolidated statements) require that voucher data be complete and consistent, and the traditional method cannot automatically handle the following problems: First, there are difficulties in mapping auxiliary accounting items, such as converting supplier codes to P codes recognized by the financial management system, accurately matching customer information to the corresponding revenue account, and associating department information to the correct cost center. Second, special business logic is difficult to automatically adapt, such as splitting input tax invoices, forcibly adjusting profit and loss account direction (such as expense accounts must be debited), and often requiring manual intervention. Third, batch transmission efficiency is difficult to guarantee, and in high-frequency voucher transmission scenarios, lack of effective consolidation processing methods will significantly increase system load, thereby affecting overall efficiency.

[0004] In summary, existing solutions lack a unified automated platform and are difficult to meet the stringent requirements of group enterprises for real-time and accurate financial data. SUMMARY

[0005] In a first aspect, the embodiments of the application provide a method for automatically transmitting accounting vouchers, comprising the following steps: S1. periodically extracting accounting vouchers to be transmitted from the voucher management system, and storing the extracted accounting voucher data in an intermediate database table; S2. performing multi-level priority derivation logic conversion on the extracted accounting voucher data in the intermediate database table according to the requirements of the auxiliary accounting items of the financial management system, and storing the converted accounting voucher data in a target table; S3. determining the voucher consolidation dimension and the consolidation quantity N, and finding the target accounting vouchers that meet the requirements according to the voucher consolidation dimension for the converted accounting voucher data in the target table, merging the target accounting vouchers according to every N vouchers into one, and creating a virtual voucher number for each merged accounting voucher; S4. transmitting the merged accounting voucher information in the target table to the financial management system, generating an accounting voucher number, and establishing an association with the virtual voucher number.

[0006] Further, the step S1 comprises the following steps: S11. configuring an automatic extraction task in the voucher management system, setting a task period, and writing a SQL query statement according to a required accounting voucher type; the accounting voucher type comprises a manual voucher, an invoice verification voucher, an asset voucher, and an audit voucher; S12. creating an intermediate database table, and setting a field in the intermediate database table according to a voucher basic information in the voucher management system; S13. executing the automatic extraction task according to the task period, obtaining accounting voucher data of the corresponding accounting voucher type through the SQL query statement, and storing the accounting voucher data into a corresponding field of the intermediate database table.

[0007] Further, the step S2 comprises the following steps: S21. determining a required auxiliary accounting item in the financial management system; the auxiliary accounting item comprises a supplier, a customer, a department, and a profit and loss subject; S22. obtaining the extracted accounting voucher data from the intermediate database table, extracting a supplier from a wage association subject, a voucher line, a purchase order, and a reference code in sequence and converting the supplier into a P code format; S23. obtaining the extracted accounting voucher data from the intermediate database table, extracting a customer from a voucher line or an association field and converting the customer into a P code format; S24. obtaining the extracted accounting voucher data from the intermediate database table, obtaining a department number from a cost center, a profit center, or a distribution field in sequence according to a priority in a three-level fault-tolerant manner; S25. obtaining the extracted accounting voucher data from the intermediate database table, forcibly adjusting a debit and credit direction of the profit and loss subject according to a configuration table, and completing a reverse accounting processing; S26. saving the derived and converted accounting voucher data into a target table.

[0008] Further, the auxiliary accounting item in the step S21 further comprises a research and development project; The derived logic conversion of the research and development project is as follows: Firstly, checking a reference code field of the accounting voucher, if the field contains a valid project number, directly using the number as a company project; If the reference code is invalid, according to a business document number in the accounting voucher, querying a corresponding project number through an association between the business document and the project mapping table; If the accounting voucher is not associated with the business document, obtaining an associated business document from a remaining line project and querying the project number; If the project number is not obtained through the above manners, using a preset common project number or a system default project number.

[0009] Further, the auxiliary accounting item in step S21 further includes a bank subject; the bank subject includes a bank account and a cash flow code; The derivation logic of the bank subject is as follows: According to the opening account identifier in the extracted accounting voucher data, the corresponding bank account is obtained from the SAP bank configuration table; According to the cash flow code in the extracted accounting voucher data, the cash flow code recognized by the financial management system is converted through a preset mapping table.

[0010] Further, the voucher merging dimension in S3 includes a company code, a year, a merging period, and a voucher type.

[0011] Further, before the merged accounting voucher information is transmitted to the financial management system in step S4, a tax amount splitting logic verification is further performed: Verify whether the number of tax subject rows is less than the number of invoices; If yes, split the tax amount according to the invoice number and reassign the line item amount, and adjust the difference to the estimated tax payable item; If no, do not perform tax amount splitting; In step S4, the merged accounting voucher information in the interface target table is transmitted to the financial management system.

[0012] In a second aspect, the embodiments of the present application further provide a device for automatic transmission of accounting vouchers, comprising: An accounting voucher extraction module is configured to periodically extract accounting vouchers to be transmitted from a voucher management system, and store the extracted accounting voucher data to an intermediate database table; An accounting voucher derivation module is configured to perform multi-level priority derivation logic conversion on the extracted accounting voucher data in the intermediate database table according to the requirements of the auxiliary accounting items of the financial management system, and store the converted accounting voucher data to a target table; An accounting voucher merging module is configured to determine a voucher merging dimension and a merging number N, find target accounting vouchers that meet the requirements according to the voucher merging dimension in the converted accounting voucher data in the target table, merge the target accounting vouchers in a manner of merging every N pieces into one piece, and create a virtual voucher number for each merged accounting voucher; An accounting voucher transmission module is configured to transmit the merged accounting voucher information in the target table to the financial management system, generate an accounting voucher number, and establish an association with the virtual voucher number.

[0013] In a third aspect, the embodiments of the present application further provide an electronic device, comprising a memory, a processor, and a computer program stored on the memory and executable on the processor, wherein the processor implements the steps of the method for automatic transmission of accounting vouchers according to the first aspect when executing the program.

[0014] In a fourth aspect, the embodiments of the present application further provide a storage medium having a computer program stored thereon, wherein the computer program, when executed by a processor, implements the steps of the method for automatic transmission of accounting vouchers according to the first aspect.

[0015] From the above technical solutions, the present application has the following advantages: The method, system, device and medium for automatic transmission of accounting vouchers provided by the present application realize automatic and intelligent transmission of accounting vouchers from a voucher management system to a financial management system, solve the problems of high human intervention, data errors and low efficiency through regular extraction, multi-level priority derivation logic conversion, merging processing and associated transmission, improve the accuracy and timeliness of financial statements, reduce the system load, meet the stringent requirements of group enterprises on the real-time and accuracy of financial data, improve the efficiency of financial work, and provide a data basis for financial decision-making. BRIEF DESCRIPTION OF DRAWINGS

[0016] In order to more clearly illustrate the technical solutions of the present application, the drawings required to be used in the description will be briefly introduced as follows. Obviously, the drawings in the following description are only some embodiments of the present application, and other drawings can be obtained by those skilled in the art without creating any creative labor on the basis of these drawings.

[0017] Figure 1 The flowchart of the method for automatic transmission of accounting vouchers of the present application.

[0018] Figure 2 The schematic diagram of the device for automatic transmission of accounting vouchers of the present application. DETAILED DESCRIPTION

[0019] In the following detailed description of the specific steps of the method for automatic transmission of accounting vouchers, various embodiments of the present disclosure will be described more fully. The present disclosure can have various embodiments, and adjustments and changes can be made therein. However, it should be understood that there is no intention to limit various embodiments of the present disclosure to the specific embodiments disclosed herein, but the present disclosure should be understood to cover all adjustments, equivalents and / or alternatives falling within the spirit and scope of various embodiments of the present disclosure.

[0020] Exemplarily, in the financial management of group enterprises, the voucher management system and the financial management system usually operate independently, and there are significant differences between the two in the field definition of accounting vouchers, auxiliary accounting items (such as departments and counterparties) and business logic. The traditional way of voucher transmission relies on manual checking and conversion one by one, which is low in efficiency and prone to data errors due to human intervention, affecting the accuracy and timeliness of financial statements.

[0021] In addition, multi-dimensional financial statements (such as consolidated statements) require that the voucher data be complete and consistent, and the traditional method cannot automatically process the following problems: First, there are problems in the mapping of auxiliary accounting items, such as the conversion of supplier codes to P codes recognized by the financial management system, the accurate matching of customer information to the corresponding revenue account, and the association of department information to the correct cost center. Second, special business logic is difficult to automatically adapt, such as splitting of input tax invoices, mandatory adjustment of profit and loss account direction (such as expense accounts must be debited) and other operations, which often require manual intervention. Third, batch transmission efficiency is difficult to guarantee, and in high-frequency voucher transmission scenarios, lack of effective consolidation processing will significantly increase system load, thereby affecting overall operational efficiency.

[0022] In summary, the existing solutions lack a unified automated platform and are difficult to meet the stringent requirements of group enterprises for real-time and accurate financial data.

[0023] To solve the above problems, the present embodiment provides a method for automatic transmission of accounting vouchers.

[0024] The technical solutions in the embodiments of the present application will be described clearly and completely below with reference to the drawings in the embodiments of the present application. Obviously, the described embodiments are only a part of the embodiments of the present application, not all embodiments. Based on the embodiments in the present application, all other embodiments obtained by those of ordinary skill in the art without creative labor are within the scope of protection of the present application.

[0025] Please refer to Figure 1 Fig. 1 is a flowchart of a method for automatic transmission of accounting vouchers in a specific embodiment, the method comprising the following steps: S1. periodically extract the accounting vouchers to be transmitted from the voucher management system, and store the extracted accounting voucher data in an intermediate database table; It should be noted that by setting a periodic extraction task, the accounting vouchers in the voucher management system can be discovered and extracted in a timely manner, thereby ensuring the timeliness of subsequent processing; storing the extracted accounting voucher data in an intermediate database table provides a stable data source for subsequent data conversion and processing; S2. According to the requirements of the auxiliary accounting items of the financial management system, perform multi-level priority derivation logic conversion on the extracted accounting voucher data in the intermediate database table, and store the converted accounting voucher data in the target table; It should be noted that according to the auxiliary accounting item requirements of the financial management system, the multi-level priority derivation logic conversion is performed on the extracted accounting voucher data, which can accurately convert the voucher data into the format required by the financial management system, ensuring the consistency and integrity of the data; the converted accounting voucher data is stored in the target table, providing direct data support for subsequent merging and transmission operations; S3. Determine the voucher merging dimension and the merging number N, and find the target accounting voucher in the converted accounting voucher data in the target table according to the voucher merging dimension, merge the target accounting voucher according to the way of merging every N pieces into one piece, and create a virtual voucher number for each merged accounting voucher; It should be noted that determining the voucher merging dimension and the merging number N can flexibly merge the vouchers according to the actual needs of the enterprise, effectively reducing the number of vouchers transmitted to the financial management system; by creating a virtual voucher number for each merged accounting voucher, it is convenient to identify and trace the vouchers in the subsequent transmission and management process; S4. Transmit the merged accounting voucher information in the target table to the financial management system, generate an accounting voucher number, and establish an association with the virtual voucher number; It should be noted that seamless connection of voucher data between two systems is achieved, which facilitates unified management and query of voucher data, while ensuring the integrity and traceability of data.

[0026] The embodiment extracts voucher data regularly, obtains the latest voucher information in the voucher management system in a timely manner, ensures the timeliness of the data; multi-level priority derivation logic conversion can accurately convert the voucher data into the format required by the financial management system, ensuring the consistency and integrity of the data; determining the voucher merging dimension and the number and merging can effectively reduce the number of vouchers transmitted to the financial management system, reduce system load, and improve transmission efficiency; finally, by establishing an association with the virtual voucher number, it is convenient to trace and manage the voucher data, providing a data basis for subsequent financial report generation operations.

[0027] Further, as a refinement and extension of the above embodiment, in order to completely describe the specific implementation process in the embodiment, another method for automatically transmitting accounting vouchers is provided, which comprises the following steps: S1. Extract the accounting vouchers to be transmitted from the voucher management system regularly, and store the extracted accounting voucher data in the intermediate database table; the specific steps of S1 are as follows: S11. Configure an automatic extraction task in the voucher management system, set the task period, and write SQL query statements according to the required accounting voucher types; the accounting voucher types include manual vouchers, invoice verification vouchers, asset vouchers, and audit vouchers; S12. Create an intermediate database table and set fields in the intermediate database table according to the basic information of the vouchers in the voucher management system; S13. Perform an automatic extraction task according to a task period, obtain accounting voucher data of a corresponding accounting voucher type through an SQL query statement, and store the data to corresponding fields of the intermediate database table; It should be noted that, by configuring the automatic extraction task in the voucher management system, setting the task period, and writing the SQL query statement, the extraction task is more operational and targeted; creating the intermediate database table and setting the fields according to the basic information of the vouchers in the voucher management system provides a standardized data structure for subsequent data storage and processing; by performing the automatic extraction task according to the task period, the timely updating and storage of data are ensured; S2. According to the requirements of the auxiliary accounting items of the financial management system, perform multi-level priority derivation logic conversion on the extracted accounting voucher data in the intermediate database table, and store the converted accounting voucher data to the target table; the specific steps of step S2 are as follows: S21. Determine the auxiliary accounting items required in the financial management system; the auxiliary accounting items include suppliers, customers, departments, and profit and loss subjects; S22. Obtain the extracted accounting voucher data from the intermediate database table, and extract the supplier from the wage association subject, the voucher line, the purchase order, and the reference code in sequence and convert it to P code format; S23. Obtain the extracted accounting voucher data from the intermediate database table, and extract the customer from the voucher line or the association field and convert it to P code format; S24. Obtain the extracted accounting voucher data from the intermediate database table, and obtain the department number from the cost center, the profit center, or the distribution field in sequence according to the priority in a three-level fault-tolerant manner; Specifically, first, obtain the department number from the cost center; If successful, end; If failed, go to the next step; Obtain the department number from the profit center; If successful, end; If failed, go to the next step; Obtain the department number from the distribution field; If failed, report an error; S25. Obtain the extracted accounting voucher data from the intermediate database table, forcibly adjust the debit and credit direction of the profit and loss subject according to the configuration table, and complete the reverse accounting processing; S26. Save the derived and converted accounting voucher data to the target table; It should be noted that the required auxiliary accounting items in the financial management system are determined, and a derived logic conversion method is designed for each item; the multi-level priority derived logic conversion can obtain data from multiple channels, improving the reliability and accuracy of data acquisition; the three-level fault-tolerant mode acquires the department number strategy, fully considers the storage characteristics and correlation of different voucher data, and ensures the accuracy and integrity of the department number; the loss and profit subjects are processed by reverse accounting, which ensures the correctness of the subject debit and credit direction, and meets the accounting rules of the financial management system and the requirements of financial statement preparation; S3. Determine the voucher merging dimension and the merging number N, and find the target accounting voucher data according to the voucher merging dimension in the target table; the target accounting voucher is merged according to every N pieces of data, and a virtual voucher number is created for each piece of merged accounting voucher; the voucher merging dimension in step S3 includes company code, year, merging period and voucher type; It should be noted that the voucher merging dimension is determined, which provides a basis for enterprises to flexibly set merging rules according to their business characteristics and management needs; by merging according to company code, year, merging period and voucher type, the voucher data with similar characteristics can be integrated together, improving the rationality and accuracy of merging, and improving the transmission efficiency and the convenience of data management; S4. The merged accounting voucher information in the target table is transmitted to the financial management system to generate an accounting voucher number and establish an association with the virtual voucher number; before the merged accounting voucher information is transmitted to the financial management system in step S4, tax amount splitting logic verification is also performed: Verify whether the number of tax subject rows is less than the number of invoices; If yes, split the tax amount according to the invoice number and redistribute the line item amount, and adjust the difference to the payable estimated item; If not, do not perform tax amount splitting; In step S4, the merged accounting voucher information in the interface target table is transmitted to the financial management system; It should be noted that the tax amount splitting logic verification is performed before transmission, which can timely discover and process data problems related to input tax invoices, and avoid inaccurate financial data caused by tax amount allocation errors; the difference is adjusted to the payable estimated item, which ensures the balance and integrity of the voucher data, and meets the specification requirements of financial management; the merged accounting voucher information is transmitted through the interface, which realizes the seamless connection of data between different systems, improves the integration of the system and the stability of data transmission.

[0028] In one embodiment of the present application, different from the previous embodiment, the auxiliary accounting items in step S21 also include research and development projects; The derived logic conversion of the research and development project is as follows: First, check the reference code field of the accounting voucher. If the field contains a valid project number, use the number as the company project directly; If the reference code is invalid, query the corresponding project number from the business document and project mapping table according to the business document number in the accounting voucher; If the accounting voucher is not associated with a business document, obtain the associated business document from the remaining line items and query the project number; If the project number is not obtained through the above methods, use the default public project number or the system default project number; For example, a certain technology-oriented subsidiary records a research and development expense voucher in the voucher management system. The voucher number is YF202503001. The reference code field of the voucher contains a valid project number "RD2025-001", which corresponds to the new intelligent equipment research and development project. When the derived logic conversion is performed, "RD2025-001" is directly used as the company project, which is included in the research and development project auxiliary accounting item, so that the research and development project can be collected and accounted for in the financial management system. The research and development project can accurately calculate the research and development input cost, and provide accurate data support for subsequent research and development project benefit evaluation and decision-making; If the reference code is invalid, such as another research and development expense voucher, the reference code is invalid due to input error, but the voucher is associated with a business document number "BJ2025-002". The corresponding project number "RD2025-002" is queried through the association of business document and project mapping table, so that the research and development expenditure can be correctly allocated to the corresponding project, and the accuracy of research and development project cost accounting is ensured; For accounting vouchers that are not associated with business documents, such as a newly added research and development material procurement voucher with a voucher number of CG202504001, there is no associated business document, but the associated business document "BJ2025-003" can be obtained from the remaining line items, and the project number "RD2025-003" is queried, which realizes the accurate identification and accounting of the corresponding research and development project for the procurement expenditure; If the project number is not obtained through the above methods, such as a certain temporary research and development test expense voucher with a voucher number of LS202504002, there is no valid reference code and no associated business document, and there is no remaining line item to obtain the associated business document. At this time, the default public project number "RD-PUB001" or the system default project number is used to ensure that the expense can be temporarily collected under the public research and development project, so as to avoid data loss. After the complete information is supplemented later, further subdivision accounting can be carried out; It should be noted that the research and development project is included in the auxiliary accounting item, and the corresponding derived logic conversion is designed, which further expands the application scope of the derived logic, meets the needs of enterprises for research and development project accounting and management, and ensures the accuracy and integrity of the research and development project data through multiple ways of querying the project number, so as to provide data support for the research and development cost accounting and management of enterprises. The auxiliary accounting item in step S21 also includes bank subjects; the bank subjects include bank account numbers and cash flow codes; The derived logic conversion of the bank subject is as follows: According to the opening identification in the extracted accounting voucher data, the corresponding bank account number is obtained from the SAP bank configuration table; According to the cash flow code in the extracted accounting voucher data, the cash flow code recognized by the financial management system is converted through the preset mapping table; For example, a certain enterprise records a bank deposit interest income voucher in the voucher management system, the voucher number is LX202504001, which contains the opening identification "XXXX-001", indicating that the bank account opening behavior XXX bank corresponds to this business; through this opening identification, the corresponding bank account number "XXXXXXXXXXXX" is obtained from the SAP bank configuration table, realizing the accurate conversion and recognition of the bank account number, providing accurate data for the automatic checking of the bank deposit journal in the financial management system and the generation of the bank balance adjustment table, so as to facilitate the enterprise to master the bank fund flow and balance in real time; At the same time, the cash flow code in the voucher is "CXXF-01", which is converted into the cash flow code "CXRW-01" (indicating cash inflow of financing activities) recognized by the financial management system according to the preset mapping table, so that the bank deposit interest income can be accurately classified into the corresponding project of the cash flow table in the financial management system, improving the accuracy and automation degree of the cash flow table compilation, and facilitating the enterprise to analyze and make decisions on fund flow; It should be noted that the bank subject is included in the auxiliary accounting item, and the corresponding derived logic conversion is designed, which perfects the function of the derived logic and meets the needs of enterprises for bank subject accounting and management; by obtaining the bank account number from the SAP bank configuration table and converting the cash flow code, the accurate conversion of the bank account number and the cash flow code is realized, the management and monitoring of the bank fund of the enterprise are realized, and the quality and usability of the financial data are improved.

[0029] It should be understood that the size of the serial number of each step in the above embodiment does not mean the order of execution, and the execution order of each process should be determined according to its function and inherent logic, and should not constitute any limitation on the implementation process of the embodiment of the present application.

[0030] As Figure 2As shown, the following is an embodiment of the accounting document automatic transmission device provided by the embodiment of the present disclosure. The system belongs to the same inventive concept as the accounting document automatic transmission method of each embodiment described above. Details not described in the accounting document automatic transmission device embodiment can be referred to the embodiments of the accounting document automatic transmission method.

[0031] The device comprises: An accounting document extraction module is configured to periodically extract the accounting document to be transmitted from the document management system, and store the extracted accounting document data to an intermediate database table. An accounting document derivation module is configured to perform a multi-level priority derivation logic conversion on the extracted accounting document data in the intermediate database table according to the auxiliary accounting item requirements of the financial management system, and store the converted accounting document data to a target table. An accounting document merging module is configured to determine the document merging dimension and the merging number N, find the target accounting document in the target table according to the document merging dimension, merge the target accounting document in the manner of one N, and create a virtual document number for each merged accounting document. An accounting document transmission module is configured to transmit the merged accounting document information in the target table to the financial management system, generate an accounting document number, and establish an association with the virtual document number.

[0032] The embodiment realizes the full-process automatic processing of the accounting document from extraction to transmission through the interaction and cooperation of the accounting document extraction module, the accounting document derivation module, the accounting document merging module, and the accounting document transmission module. The accounting document extraction module guarantees the timely acquisition of data, the derivation module ensures the accurate conversion of data, the merging module improves the transmission efficiency, and the transmission module realizes the successful delivery and association management of data.

[0033] The accounting document automatic transmission method provided by the embodiment of the present application can be applied to an electronic device. Those skilled in the art can understand that the electronic device structure involved in the embodiment of the present application does not constitute a limitation on the electronic device. The electronic device can include more or fewer components than the illustration, or combine certain components, or different component arrangements. In the embodiment of the present application, the electronic device includes but is not limited to a laptop computer, a desktop computer, a workstation, a personal digital assistant, a server, a blade server, a mainframe computer, and other suitable computers. The electronic device can also represent various forms of mobile devices, such as personal digital processing, cellular phones, smart phones, wearable devices, and other similar computing devices. The components shown herein, their connections and relationships, and their functions are merely examples and are not intended to limit the implementation of the embodiments of the present application described herein and / or claimed.

[0034] The electronic device can include a processor, an external memory interface, an internal memory, a universal serial bus (USB) interface, a charging management module, a power management module, a battery, a wireless communication module, an audio module, a speaker, a microphone, a sensor module, a key, a camera, a display screen, and a SIM card interface, and the like.

[0035] It can be understood that the structure illustrated in the embodiments of the present application does not constitute a specific limitation on the electronic device. In other embodiments of the present application, the electronic device can include more or fewer components than the illustration, or combine certain components, or split certain components, or different arrangement of components. The illustrated components can be implemented in hardware, software, or a combination of software and hardware.

[0036] The processor can include one or more processing units, such as: the processor can include a central processing unit (CPU), an application processor (AP), a modem processor, a graphics processing unit (GPU), an image signal processor (ISP), a controller, a memory, a video codec, a digital signal processor (DSP), a baseband processor, and / or a neural-network processing unit (NPU), and the like. Among them, different processing units can be independent devices, or can be integrated in one or more processors.

[0037] Among them, the processor can be the nerve center and command center of the electronic device. The controller can generate operation control signals according to instruction operation codes and timing signals, and complete the control of fetching and executing instructions.

[0038] The memory can also be provided in the processor for storing instructions and data. In some embodiments, the memory in the processor is a cache memory. The memory can save instructions or data that the processor has just used or repeatedly uses. If the processor needs to use the instructions or data again, it can directly call from the memory. Avoiding repeated access, reducing the waiting time of the processor, thus improving the efficiency of the system.

[0039] The electronic device realizes the technical scheme of the method for automatically transmitting accounting vouchers, periodically extracts accounting vouchers to be transmitted from a voucher management system, and stores the extracted accounting voucher data to an intermediate database table; according to the requirements of the auxiliary accounting items of the financial management system, performs multi-level priority derivation logic conversion on the accounting voucher data extracted in the intermediate database table, and stores the converted accounting voucher data to a target table; determines the voucher merging dimension and the merging number N, finds the target accounting vouchers meeting the requirements in the target table according to the voucher merging dimension, merges the target accounting vouchers in the manner of merging every N vouchers into one, and creates a virtual voucher number for each merged accounting voucher; and transmits the merged accounting voucher information in the target table to the financial management system, generates an accounting voucher number, and establishes an association with the virtual voucher number, thereby improving the efficiency and accuracy of the accounting voucher transmission through the automatic process, reducing the error risk caused by manual intervention, and reducing the system load through the merged vouchers and improving the overall transmission efficiency.

[0040] In the storage medium provided in the present application, a program product capable of realizing the method for automatically transmitting accounting vouchers is stored.

[0041] The method for automatically transmitting accounting vouchers comprises: periodically extracting accounting vouchers to be transmitted from a voucher management system, and storing the extracted accounting voucher data to an intermediate database table; according to the requirements of the auxiliary accounting items of the financial management system, performing multi-level priority derivation logic conversion on the accounting voucher data extracted in the intermediate database table, and storing the converted accounting voucher data to a target table; determining the voucher merging dimension and the merging number N, finding the target accounting vouchers meeting the requirements in the target table according to the voucher merging dimension, merging the target accounting vouchers in the manner of merging every N vouchers into one, and creating a virtual voucher number for each merged accounting voucher; and transmitting the merged accounting voucher information in the target table to the financial management system, generating an accounting voucher number, and establishing an association with the virtual voucher number.

[0042] In some possible implementation manners, the method for automatically transmitting accounting vouchers of the present disclosure can be implemented in the form of a program product, which includes program codes for causing a terminal device to perform the steps according to various exemplary embodiments of the present disclosure described in the above “Exemplary Method” section of the present specification when the program product is running on the terminal device.

[0043] The storage medium of the present disclosure can employ any combination of one or more computer-readable media. The computer-readable media can be a computer- readable signal medium or a computer-readable storage medium. A computer-readable storage medium can be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any suitable combination of the foregoing. More specific examples (a non-exhaustive list) of the computer-readable storage medium include the following: an electrical connection having one or more wires, a portable disc, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or Flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.

[0044] The foregoing description of the disclosed embodiments enables a person skilled in the art to implement or use the invention. Various modifications to these embodiments will be apparent to those skilled in the art, and the generic principles defined herein can be applied to other embodiments without departing from the spirit or scope of the invention. Accordingly, the present invention is not intended to be limited to the embodiments shown herein but is to be accorded the widest scope consistent with the principles and novel features disclosed herein.

Claims

1. A method for automatic transmission of accounting documents, characterized in that, Comprise the following steps: S1. Regularly extract the accounting vouchers to be transmitted from the voucher management system, and store the extracted accounting voucher data to the intermediate database table; S2. According to the auxiliary accounting item requirements of the financial management system, perform multi-level priority derivation logic conversion on the extracted accounting voucher data in the intermediate database table, and store the converted accounting voucher data to the target table; S3. Determine the voucher merging dimension and the merging number N, find the target accounting voucher in the converted accounting voucher data in the target table according to the voucher merging dimension, merge the target accounting voucher according to every N pieces into one piece, and create a virtual voucher number for each merged accounting voucher; S4. Transmit the merged accounting voucher information in the target table to the financial management system, generate an accounting voucher number, and establish an association with the virtual voucher number.

2. The method for automatic transmission of accounting documents according to claim 1, characterized in that, The specific steps of step S1 are as follows: S11. Configure an automatic extraction task in the voucher management system, set the task period, and write SQL query statements according to the types of accounting vouchers that need to be extracted; The accounting voucher types include manual vouchers, invoice verification vouchers, asset vouchers, and audit vouchers; S12. Create an intermediate database table, and set fields in the intermediate database table according to the basic information of the vouchers in the voucher management system; S13. Execute the automatic extraction task according to the task period, obtain the accounting voucher data of the corresponding accounting voucher type through the SQL query statement, and store it to the corresponding field of the intermediate database table.

3. The method for automatic transmission of accounting documents according to claim 2, characterized in that, The specific steps of step S2 are as follows: S21. Determine the auxiliary accounting items required in the financial management system; The auxiliary accounting items include suppliers, customers, departments, and profit and loss subjects; S22. Obtain the extracted accounting voucher data from the intermediate database table, and extract the supplier from the wage association subject, voucher line, purchase order, and reference code in turn and convert it to P code format; S23. Obtain the extracted accounting voucher data from the intermediate database table, extract the customer from the voucher line or the associated field, and convert it to P code format; S24. Obtain the extracted accounting voucher data from the intermediate database table, and obtain the department number from the cost center, profit center, or distribution field in turn according to the priority in a three-level fault-tolerant manner; S25. Obtain the extracted accounting voucher data from the intermediate database table, and adjust the debit and credit direction of the profit and loss subject according to the configuration table to complete the reverse accounting processing; S26. Save the derived and converted accounting voucher data to the target table.

4. The method for automatic transmission of accounting documents according to claim 3, characterized in that, The auxiliary accounting items in step S21 also include research and development projects; The derivation logic conversion of the research and development project is as follows: First, check the reference code field of the accounting voucher. If the field contains a valid project number, use the number as the company project directly; If the reference code is invalid, query the corresponding project number through the association of business documents and project mapping table according to the business document number in the accounting voucher; If the accounting voucher does not associate a business document, obtain the associated business document from the remaining line project and query the project number; If the project number is not obtained through the above methods, use the preset public project number or the system default project number.

5. The method for automatic transmission of accounting documents according to claim 3, characterized in that, The auxiliary accounting item in step S21 further includes a bank subject; the bank subject includes a bank account and a cash flow code; The derivation logic of the bank subject is as follows: According to the opening account identifier in the extracted accounting voucher data, the corresponding bank account is obtained from the SAP bank configuration table; According to the cash flow code in the extracted accounting voucher data, the cash flow code recognized by the financial management system is converted through a preset mapping table.

6. The method for automatic transmission of accounting documents according to claim 1, characterized in that, The voucher merging dimension in S3 includes company code, year, merging period, and voucher type.

7. The method for automatic transmission of accounting documents according to claim 1, characterized in that, Before the merged accounting voucher information is transmitted to the financial management system in step S4, a tax amount splitting logic verification is further performed: Verify whether the number of tax subject rows is less than the number of invoices; If yes, split the tax amount according to the invoice number and redistribute the line item amount, and adjust the difference to the payable estimated amount item; If no, do not perform tax amount splitting; In step S4, the merged accounting voucher information in the interface target table is transmitted to the financial management system.

8. An apparatus for automatic transmission of accounting documents, characterized in that, It includes: An accounting voucher extraction module for periodically extracting accounting vouchers to be transmitted from the voucher management system, and storing the extracted accounting voucher data in an intermediate database table; An accounting voucher derivation module for performing multi-level priority derivation logic conversion on the extracted accounting voucher data in the intermediate database table according to the requirements of the auxiliary accounting items of the financial management system, and storing the converted accounting voucher data in a target table; An accounting voucher merging module for determining the voucher merging dimension and the merging number N, finding the target accounting vouchers in the target table according to the voucher merging dimension, merging the target accounting vouchers according to every N pieces into one piece, and creating a virtual voucher number for each merged accounting voucher; An accounting voucher transmission module for transmitting the merged accounting voucher information in the target table to the financial management system, generating an accounting voucher number, and establishing an association with the virtual voucher number.

9. An electronic device, comprising: It includes a memory, a processor, and a computer program stored on the memory and executable on the processor, characterized in that the processor executes the program to implement the steps of the accounting voucher automatic transmission method according to any one of claims 1 to 7.

10. A storage medium having stored thereon a computer program, characterized in that The computer program is executed by the processor to implement the steps of the accounting voucher automatic transmission method according to any one of claims 1 to 7.

Images