Dynamic and automatic accounting entry method, platform, equipment and medium
By configuring documents, business scenarios and voucher templates, using primary keys to connect to the business system or financial intermediate library, dynamically generate accounting vouchers, solving the problem of low efficiency in accounting voucher generation after docking with different systems in the existing technology, realizing automatic voucher generation, and improving the efficiency and accuracy of financial processing.
Patent Information
- Application Number
- CN202510033220.2
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2025-01-09
- Publication Date
- 2025-05-30
AI Technical Summary
It is difficult for the prior art to achieve docking with different systems, and automatically generate the desired accounting vouchers, resulting in financial personnel needing to manually enter business information, which is inefficient and complex.
By configuring documents, business scenarios and voucher templates, using the primary key to connect to the business system or financial intermediate library, accounting vouchers are dynamically generated.
It realizes rapid docking with different systems and automatically generates accounting vouchers, reducing the workload and error rate of financial personnel, and improving efficiency and accuracy rate.
Smart Images

Figure CN120068829A_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the field of computer technology, and particularly to an accounting dynamic automatic posting method, platform, device and medium. Background Art
[0002] Currently, the work of generating vouchers in most units is basically completed manually by financial personnel. For vouchers connected to other systems, financial personnel not only need to understand the information of the accounting system but also trace back to different systems to view the information of corresponding documents. This results in relatively low efficiency in manually generating vouchers.
[0003] In view of the development trend of financial intelligence, customers want to get rid of the inefficient manual bookkeeping method of traditional accounting, especially when docking with different systems. Due to the diverse docking methods and account matching rules, the bookkeeping process is complex. Customers hope to automatically generate the desired vouchers through a small amount of configuration and quickly complete the bookkeeping process.
[0004] Chinese Invention Patent No. CN110717321A discloses an accounting voucher generation method, which relates to the technical field of financial software and solves the problem of the relatively troublesome need for financial personnel to manually enter relevant business information. It includes: Step S100: Construct a first database of business types, corresponding business accounting voucher templates, and calculation formulas involved in corresponding types of business; Step S200: Query the business accounting voucher module and corresponding calculation formula that match the corresponding business type in the first database based on the business type as the query object; Step S300: Obtain the document data of the corresponding business type and fill it into the accounting voucher template through corresponding calculations to generate accounting vouchers; Step S400: Instantly display the accounting vouchers to the user and store them in the user's cloud server. The present invention enables the data processing processes between business and finance to be interconnected, saves manpower and time by automatically generating accounting vouchers. However, this invention requires constructing a dedicated calculation formula to achieve, which is difficult to be used by ordinary users, with low freedom and insufficient generality. Summary of the Invention
[0005] The technical problem to be solved by the present invention is to provide an accounting dynamic automatic posting method, platform, device and medium, which can be docked with different systems through a small amount of configuration, dynamically and automatically generate the desired vouchers, quickly complete the bookkeeping process, and users can customize business scenarios with high freedom and generality.
[0006] In a first aspect, the present invention provides an accounting dynamic automatic posting method, including:
[0007] Document configuration stage: By linking to the data source, read the table structure of the document database, perform document configuration according to the table structure, and specify the primary key for each document; a document consists of multiple tables, and the structure of a single table includes field identifier, field name, whether it is a primary key, foreign key value, and data; the primary key is the unique identifier of the document, used to interface with business forms, and the primary key is a single field or a combination of multiple fields;
[0008] Business scenario definition stage: Provide a document business scenario definition page for users to define the business scenario of the document and set whether to generate a budget according to requirements; each document can define at least one business scenario, and each business scenario corresponds to at least one applicable rule formula;
[0009] Voucher template configuration stage: Provide a voucher configuration page for users to configure the basic information and entry details of the voucher template; the voucher data involved in the basic information and entry details can be dynamically obtained and displayed by directly selecting the data of the document;
[0010] Association configuration stage: Associate a voucher template with a business scenario;
[0011] Voucher generation through docking stage: Include directly docking with the business system to generate vouchers and generating vouchers through the financial intermediate library;
[0012] The direct docking with the business system to generate vouchers includes the following steps:
[0013] S11. Read the business form information on the business system and pass in the primary key of the document;
[0014] S12. Obtain the document information according to the primary key;
[0015] S13. Screen the business scenario to which the document belongs according to the document information;
[0016] S14. Read the voucher template information corresponding to the business scenario;
[0017] S15. Generate accounting vouchers according to the business form information, the voucher template information, and the document information;
[0018] The steps for generating vouchers through the financial intermediate library are as follows:
[0019] S21. When the financial intermediate library is initialized, it defaults to complete the document configuration stage, the business scenario definition stage, the voucher template configuration stage, and the association configuration stage;
[0020] S22. Read the business form information of the financial intermediate library and pass in the primary key of the document;
[0021] S23. Read the document information of the financial intermediate library according to the primary key of the document;
[0022] S24. Screen the business scenarios to which they belong according to the document information;
[0023] S25. Read the voucher template information corresponding to the business scenario;
[0024] S26. Generate accounting vouchers according to the business form information, the voucher template information and the document information.
[0025] In a second aspect, the present invention provides an accounting dynamic automatic posting platform, including:
[0026] A document configuration module, which is used to read the table structure of the document database by linking to the data source, perform document configuration according to the table structure, and agree on the primary key of each document; the document is composed of multiple tables, and the single table structure includes field identification, field name, whether it is a primary key, foreign key value and data; the primary key is the unique identifier of the document and is used to connect to the business form, and the primary key is a single field or a combination of multiple fields;
[0027] A business scenario definition module, which is used to provide a document business scenario definition page for users to define the business scenario of the document and set whether to generate a budget according to their needs; each document can define at least one business scenario, and each business scenario corresponds to at least one applicable rule formula;
[0028] A voucher template configuration module, which is used to provide a voucher configuration page for users to configure the basic information and entry details of the voucher template; the voucher data involved in the basic information and entry details can be dynamically obtained and displayed by directly selecting the data of the document;
[0029] An association module, which is used to associate a voucher template with a business scenario;
[0030] A docking and generating voucher module, which is used to directly dock the business system to generate vouchers and generate vouchers through the financial intermediate library;
[0031] The direct docking of the business system to generate vouchers includes the following steps:
[0032] S11. Read the business form information on the business system and pass in the primary key of the document;
[0033] S12. Obtain the document information according to the primary key;
[0034] S13. Screen the business scenarios to which they belong according to the document information;
[0035] S14. Read the voucher template information corresponding to the business scenario;
[0036] S15. Generate accounting vouchers according to the business form information, the voucher template information and the document information;
[0037] The steps for generating vouchers through the financial intermediate database are as follows:
[0038] S21. During the initialization of the financial intermediate database, the document configuration stage, the business scenario definition stage, the voucher template configuration stage, and the association configuration stage are default completed;
[0039] S22. Read the business form information of the financial intermediate database and pass in the primary key of the document;
[0040] S23. Read the document information of the financial intermediate database according to the primary key of the document;
[0041] S24. Screen the belonging business scenario according to the document information;
[0042] S25. Read the voucher template information corresponding to the business scenario;
[0043] S26. Generate accounting vouchers according to the business form information, the voucher template information, and the document information.
[0044] In a third aspect, the present invention provides an electronic device, including a memory, a processor, and a computer program stored on the memory and executable on the processor. When the processor executes the program, the method described in the first aspect is implemented.
[0045] In a fourth aspect, the present invention provides a computer-readable storage medium, on which a computer program is stored. When the program is executed by a processor, the method described in the first aspect is implemented.
[0046] One or more technical solutions provided by the present invention have at least the following technical effects or advantages: The document configuration is pre-performed according to the table structure of the document database of the data source (business system or financial intermediate database), and the primary key is agreed. Then, the business scenario configuration and the voucher template configuration are associated. After the configuration is completed, after docking with the business system or the financial intermediate database, the corresponding accounting vouchers can be generated by passing in the primary key, thereby reducing the workload and error rate of financial personnel. And the configured content can be reused after being saved, greatly improving the efficiency. When configuring the business scenario, the constituent conditions of the business scenario itself can be arbitrarily added, deleted, and modified, so as to meet more personalized needs and have a high degree of freedom. The accounting personnel can achieve it only through a small amount of configuration, and it has strong versatility. And when configuring the voucher template, the voucher data can be dynamically obtained and displayed by directly selecting the data of the document. Therefore, through the configured form data, it is possible to view in real time whether the business data and the voucher data are consistent, which is convenient for accounting data and traceability, and improves the accuracy rate.
[0047] The above description is only an overview of the technical solution of the present invention. In order to better understand the technical means of the present invention, it can be implemented according to the content of the description. And in order to make the above and other objects, features, and advantages of the present invention more obvious and understandable, the specific embodiments of the present invention are specifically exemplified below. Description of the Drawings
[0048] The present invention will be further described below with reference to the drawings in conjunction with embodiments.
[0049] Figure 1 It is a flowchart of the method in Embodiment 1 of the present invention;
[0050] Figure 2 It is a schematic diagram of the business scenario definition page in the embodiment of the present invention;
[0051] Figure 3 It is a schematic diagram of the voucher configuration page in the embodiment of the present invention;
[0052] Figure 4 It is a schematic diagram of the subject rule configuration page in the embodiment of the present invention;
[0053] Figure 5 It is a schematic diagram of the status of reusing subject rules on the voucher configuration page in the embodiment of the present invention;
[0054] Figure 6 It is a flowchart of directly docking with the business system to generate vouchers in the embodiment of the present invention;
[0055] Figure 7 It is a flowchart of generating vouchers through the financial intermediate library in the embodiment of the present invention;
[0056] Figure 8 It is a schematic diagram of the structure of the device in Embodiment 2 of the present invention;
[0057] Figure 9 It is a schematic diagram of the structure of the electronic device in Embodiment 3 of the present invention;
[0058] Figure 10 It is a schematic diagram of the structure of the medium in Embodiment 4 of the present invention. Detailed Embodiments
[0059] By providing an accounting dynamic automatic posting method, platform, device, and medium in the embodiments of the present application, it is only necessary to perform a small amount of configuration to dock with different systems, dynamically and automatically generate the desired vouchers, and quickly complete the accounting process. Users can customize business scenarios with high freedom and high versatility.
[0060] The overall idea of the technical solution in the embodiments of this application is as follows: First, perform document configuration according to the table structure of the document database of the data source (business system or financial intermediate library), and agree on the primary key. Then, perform business scenario configuration and associated voucher template configuration. After the configuration is completed and after docking with the business system or financial intermediate library, the corresponding accounting vouchers can be generated by passing in the primary key, thereby reducing the workload and error rate of financial personnel. Moreover, the configured content can be reused after being saved, greatly improving efficiency. When configuring the business scenario, the constituent conditions of the business scenario itself can be arbitrarily added, deleted, and modified, so as to meet more personalized needs and have a high degree of freedom. Accounting personnel can achieve this through only a small amount of configuration, with strong versatility. And when configuring the voucher template, the voucher data can be dynamically obtained and displayed by directly selecting the data of the document. Therefore, through the configured form data, it is possible to view in real time and dynamically whether the business data and voucher data are consistent, which is convenient for accounting data and traceability, and improves the accuracy rate.
[0061] Embodiment 1
[0062] As Figure 1 shown, this embodiment provides a method for dynamic automatic accounting entry of accounting, including:
[0063] Document configuration stage: By linking to the data source, read the table structure of the document database, perform document configuration according to the table structure, and agree on the primary key for each document;
[0064] Documents (such as incoming documents, reimbursement documents, etc.) are composed of multiple tables. The structure of a single table includes field identifier, field name, whether it is a primary key, foreign key value, and data; the primary key is the unique identifier of the document and is used to dock with the business form. The primary key is a single field or a combination of multiple fields;
[0065] The structure of a single table is as follows:
[0066]
[0067] Business scenario definition stage: Provide a business scenario definition page for documents, for users to define the business scenario of the document and set whether to generate a budget according to their needs; Each document can define at least one business scenario, and each business scenario corresponds to at least one applicable rule formula;
[0068] The setting of the business scenario depends on the needs of the customer. The business scenario can also set a hierarchical relationship. For example, the upper-level business scenario of the reimbursement document can be divided into two lower-level business scenarios: ordinary reimbursement document and business trip reimbursement document. The applicable rule formula for each business scenario can be set to one or more, and the constituent factors in the applicable rule formula are any content item in the document.
[0069] As Figure 2 shown, when configuring the applicable rule formula for a reimbursement document: The following three rule formulas are configured:
[0070] 1. Source of funds = 1 && Expense type in (Union funds, Handling fees) && Department type in (1, 2, 3);
[0071] 2. Source of funds = 4 && Expense type in (Union funds, Handling fees) && Department type in (1, 2, 3);
[0072] 3. Source of funds = 1 && Expense type in (Union funds, Handling fees) && Department type in (4)...;
[0073] As long as any one of the above three rule formulas is satisfied, this business scenario can be used.
[0074] When configuring the applicable rule formula on the document business scenario definition page, input boxes and dropdown boxes are provided, greatly improving the configuration efficiency.
[0075] When multiple business scenarios are set for a document, the document business scenario definition page also provides a business scenario priority setting. During the voucher generation stage, it automatically generates based on the business scenario with the highest priority. Therefore, users can screen the business scenario for voucher generation by adjusting the priority of the business scenario.
[0076] The business scenario definition module provides functions for adding, deleting, modifying, and querying each business scenario and its constituent conditions.
[0077] Voucher template configuration stage: As Figure 3 and Figure 4 shown, a voucher configuration page is provided for users to configure the basic information and entry details of the voucher template;
[0078] The basic information includes the voucher maker, posting date, business date, voucher type, and number of attachments;
[0079] The entry details include the abstract, subject source, subject rule configuration, subject configuration, debit / credit side, and amount value;
[0080] As Figure 4 shown, each subject rule needs to be configured separately. After the configured subject rule is saved, it will be displayed in the dropdown box of the subject rule configuration item for viewing, selection, and reuse.
[0081] As Figure 5 shown, it is a schematic diagram of the subject rule configuration page.
[0082] For example: Department type = 4, matching code name is 5101, source of funds = 1, matching code name is 01, expense name = Handling fees, matching code name is 0204, then the matching code name of the subject is: 5101010204. Then the template is selected and can be reused later.
[0083] The voucher data involved in the basic information and entry details can be dynamically obtained and displayed by directly selecting the data of the document, so that it is possible to check in real time whether the business data and voucher data are consistent through the configured form data, which is convenient for accounting data and traceability, and improves the accuracy rate.
[0084] Association configuration stage: associate a voucher template with a business scenario; among them, as Figure 3 shown, associating a voucher template with a business scenario can be carried out on the voucher configuration page.
[0085] Docking and generating vouchers stage: including directly docking with the business system to generate vouchers and generating vouchers through the financial intermediate library;
[0086] When the platform of the present invention directly docks with the business system, the platform can be called through the business system to generate vouchers. As Figure 6 shown, the steps of directly docking with the business system to generate vouchers include the following:
[0087] S11. Read the business form information on the business system and pass in the primary key of the document;
[0088] For example, it is agreed that the fields main_id and hbdwbh (merged unit number) in the form structure are the primary keys, the meaning of hbdwbh refers to the merged unit number, and the form identifier is er, then the passed-in format is:
[0089] Business form type: er, primary key pair: main_id:XXXX, hbdwbh: 3509020101.
[0090] S12. Obtain the document information according to the primary key;
[0091] S13. Screen the applicable business scenario according to the document information, that is, obtain the applicable rule formula according to the document information, and judge which business scenario the applicable rule formula belongs to;
[0092] S14. Read the voucher template information corresponding to the business scenario;
[0093] S15. Generate accounting vouchers according to the business form information, the voucher template information and the document information.
[0094] As Figure 7 shown, the steps of generating vouchers through the financial intermediate library are as follows:
[0095] S21. Pass the business form that needs to generate vouchers into the intermediate library. The financial intermediate library initializes and defaults to complete the document configuration stage, the business scenario definition stage, the voucher template configuration stage and the association configuration stage;
[0096] S22. Read the business form information in the financial intermediate database and pass in the primary key of the document.
[0097] S23. Read the document information in the financial intermediate database according to the primary key of the document.
[0098] S24. Screen the applicable business scenarios according to the document information, that is, obtain the applicable rule formula according to the document information, and judge which business scenario the applicable rule formula belongs to.
[0099] S25. Read the voucher template information corresponding to the business scenario; for example, accounting entry configuration, entry auxiliary configuration, whether to directly generate budget entries, accounting subject rules, posting directions, posting amounts, custom abstracts, etc.
[0100] S26. Generate accounting vouchers according to the business form information, the voucher template information, and the document information.
[0101] If it is directly connected to the business system, the documents need to be configured according to the document table structure of the business system. For example, a purchase order consists of a purchase main table and a purchase detail table to form a document. The financial intermediate database can directly configure the documents without connecting to the data source. After the configuration of the documents, business scenarios, voucher templates, and associated configurations, the configuration results are written into the initialization file. After the initialization of the intermediate database, the financial intermediate database has the function of generating vouchers like the platform. After the user passes in the business form to be generated into the intermediate database, the financial intermediate database can generate the corresponding vouchers by itself.
[0102] During the process of generating vouchers, it is possible to dynamically view in real time on the voucher generation page whether the business data and voucher data are consistent, which is convenient for data verification and traceability and improves the accuracy rate. For the generated vouchers, it is possible to analyze the generation process of the accounting entry rules, thereby ensuring transparency during use. At the same time, vouchers can be generated in real time through the document primary key to verify the usability of the scenario.
[0103] Embodiment 2
[0104] Based on the same inventive concept, the present application also provides an apparatus corresponding to the method in Embodiment 1, as detailed in Embodiment 2.
[0105] As Figure 8 shown, in this embodiment, an accounting dynamic automatic posting platform is provided, including a document configuration module, a business scenario definition module, a voucher template configuration module, an association module, and a docking and generating voucher module.
[0106] The document configuration module is used to read the table structure of the document database by linking to the data source, configure the documents according to the table structure, and specify the primary key for each document; a document consists of multiple tables, and the structure of a single table includes field identifier, field name, whether it is a primary key, foreign key value, and data; the primary key is the unique identifier of the document, used to interface with the business form, and the primary key can be a single field or a combination of multiple fields.
[0107] The structure of a single table is as follows:
[0108]
[0109] The business scenario definition module is used to provide a document business scenario definition page for users to define the business scenarios of the documents and set whether to generate a budget according to their needs; each document can define at least one business scenario, and each business scenario corresponds to at least one applicable rule formula.
[0110] The setting of business scenarios depends on the needs of the customers. Hierarchical relationships can also be set for business scenarios. For example, the upper-level business scenario of the reimbursement form can be divided into two lower-level business scenarios: ordinary reimbursement form and business trip reimbursement form. The applicable rule formula for each business scenario can be set to one or more.
[0111] As Figure 2 shown, when configuring the applicable rule formula for a reimbursement form: the following three rule formulas are configured:
[0112] 1. Source of funds = 1 && Expense type in (union funds, handling fees) && Department type in (1, 2, 3);
[0113] 2. Source of funds = 4 && Expense type in (union funds, handling fees) && Department type in (1, 2, 3);
[0114] 3. Source of funds = 1 && Expense type in (union funds, handling fees) && Department type in (4)...;
[0115] As long as the above three rule formulas are met, this business scenario can be used.
[0116] When a document is set with multiple business scenarios, the document business scenario definition page also provides a business scenario priority setting. During the voucher generation stage, it will automatically generate according to the business scenario with the highest priority.
[0117] The business scenario definition module provides functions for adding, deleting, modifying, and querying each business scenario and the constituent conditions of the business scenario.
[0118] The voucher template configuration module is used to provide a voucher configuration page for users to configure the basic information and entry details of the voucher template; the voucher data involved in the basic information and entry details can be dynamically obtained and displayed by directly selecting the data of the document.
[0119] The basic information includes the voucher maker, the posting date, the business date, the voucher type, and the number of attachments.
[0120] The entry details include the summary, the account source, the account rule configuration, the account configuration, the debit / credit side, and the amount value.
[0121] Each account rule needs to be configured separately. After the configured account rule is saved, it will be displayed in the drop-down box of the account rule configuration item for viewing, selection, and reuse.
[0122] The association module is used to associate a voucher template with a business scenario.
[0123] The docking voucher generation module is set on the platform and is used to directly dock with the business system to generate vouchers, or write to the initialization file. After being initialized by the financial intermediate library, it has the same voucher generation function as the platform, so as to generate vouchers through the financial intermediate library.
[0124] When the platform of the present invention directly docks with the business system, the business system can call this platform to generate vouchers. As Figure 6 shown, the direct docking with the business system to generate vouchers includes the following steps:
[0125] S11. Read the business form information on the business system and pass in the primary key of the document.
[0126] For example, it is agreed that the fields main_id and hbdwbh (merged unit number) in the form structure are the primary keys, the meaning of hbdwbh is the merged unit number, and the form identifier is er. Then the passed-in format is:
[0127] Business form type: er, primary key pair: main_id: XXXX, hbdwbh: 3509020101.
[0128] S12. Obtain the document information according to the primary key.
[0129] S13. Screen the applicable business scenario according to the document information, that is, obtain the applicable rule formula according to the document information and judge which business scenario the applicable rule formula belongs to.
[0130] S14. Read the voucher template information corresponding to the business scenario.
[0131] S15. Generate accounting vouchers according to the business form information, the voucher template information, and the document information.
[0132] As Figure 7 shown, the steps of generating vouchers through the financial intermediate library are as follows:
[0133] S21. Transfer the business form that needs to generate vouchers to the intermediate library. The financial intermediate library is initialized and defaults to complete the document configuration stage, the business scenario definition stage, the voucher template configuration stage, and the association configuration stage;
[0134] S22. Read the business form information in the financial intermediate library and transfer the primary key of the document;
[0135] S23. Read the document information in the financial intermediate library according to the primary key of the document;
[0136] S24. Screen the applicable business scenario according to the document information, that is, obtain the applicable rule formula according to the document information and judge which business scenario the applicable rule formula belongs to;
[0137] S25. Read the voucher template information corresponding to the business scenario; for example, accounting entry configuration, entry auxiliary configuration, whether to directly generate budget entries, accounting subject rules, posting directions, posting amounts, custom abstracts, etc.;
[0138] S26. Generate accounting vouchers according to the business form information, the voucher template information, and the document information.
[0139] If directly docking with the business system, it is necessary to configure the documents according to the document table structure of the business system. For example, an inbound order consists of an inbound main table and an inbound detail table to form a document. The financial intermediate library can directly configure the documents without docking with the data source. After the configuration of documents, business scenarios, voucher templates, and associations, the configuration results are written into the initialization file. After the intermediate library is initialized, the financial intermediate library has the function of generating vouchers like the platform. Users only need to transfer the business form to be generated into the intermediate library, and the financial intermediate library can generate the corresponding vouchers by itself.
[0140] Since the device introduced in the second embodiment of the present invention is the device adopted for implementing the method of the first embodiment of the present invention, based on the method introduced in the first embodiment of the present invention, those skilled in the art can understand the specific structure and variations of the device, so it will not be elaborated here. Any device adopted for the method of the first embodiment of the present invention belongs to the scope to be protected by the present invention.
[0141] Embodiment Three
[0142] Based on the same inventive concept, this application provides an electronic device embodiment corresponding to Embodiment One. For details, see Embodiment Three.
[0143] This embodiment provides an electronic device, as Figure 9As shown, it includes a memory, a processor, and a computer program stored in the memory and executable on the processor. When the processor executes the computer program, any implementation manner in Embodiment 1 can be implemented.
[0144] Since the electronic device introduced in this embodiment is the device used to implement the method in Embodiment 1 of the present application, based on the method introduced in Embodiment 1 of the present application, those skilled in the art can understand the specific implementation manners and various variations of the electronic device in this embodiment. Therefore, the specific implementation of how this electronic device implements the method in the embodiments of the present application will not be described in detail here. As long as the device used by those skilled in the art to implement the method in the embodiments of the present application belongs to the scope protected by the present application.
[0145] Embodiment 4
[0146] Based on the same inventive concept, the present application provides a storage medium corresponding to Embodiment 1, as detailed in Embodiment 4.
[0147] This embodiment provides a computer-readable storage medium, as Figure 10 shown, on which a computer program is stored. When the computer program is executed by a processor, any implementation manner in Embodiment 1 can be implemented.
[0148] Although the specific implementation manners of the present invention have been described above, those skilled in the art should understand that the specific embodiments we described are illustrative rather than used to limit the scope of the present invention. Equivalent modifications and variations made by those skilled in the art in accordance with the spirit of the present invention should be covered by the scope protected by the claims of the present invention.
Claims
1. A method for dynamic automatic accounting entry, characterized by: include: Document configuration stage: by linking the data source, reading the table structure of the document database, configuring the document according to the table structure, and agreeing on the primary key of each document; A document is composed of multiple tables. The structure of a single table includes field identifier, field name, whether it is a primary key, foreign key value, and data. The primary key is the unique identifier of the document and is used to connect to the business form. The primary key is a single field or a combination of multiple fields. Business scenario definition stage: Provides a document business scenario definition page for users to define business scenarios for documents and set whether to generate budgets based on their needs; each document can define at least one business scenario, and each business scenario corresponds to at least one applicable rule formula; Voucher template configuration stage: a voucher configuration page is provided for users to configure the basic information and entry details of the voucher template; the voucher data involved in the basic information and entry details can be dynamically obtained and displayed by directly selecting the data of the document; Association configuration stage: associate the voucher template with a business scenario; The stage of connecting to generate vouchers: including directly connecting to the business system to generate vouchers and generating vouchers through the financial intermediate database; The direct connection to the business system to generate a voucher includes the following steps: S11. Read the business form information on the business system and pass in the primary key of the document; S12, obtaining document information according to the primary key; S13. Filter the business scenarios according to the document information; S14. Read the voucher template information corresponding to the business scenario; S15, generating an accounting voucher according to the business form information, the voucher template information and the document information; The steps of generating vouchers through the financial intermediate library are as follows: S21, the financial intermediate library is initialized, and the document configuration phase, the business scenario definition phase, the voucher template configuration phase and the association configuration phase are completed by default; S22, read the business form information of the financial intermediate library, and pass in the primary key of the document; S23, reading the document information in the financial intermediate database according to the primary key of the document; S24. Filter the business scenarios according to the document information; S25. Read the voucher template information corresponding to the business scenario; S26: Generate an accounting voucher according to the business form information, the voucher template information and the document information.
2. According to claim 1, a method for dynamic automatic accounting entry is characterized by: When a document is set with multiple business scenarios, the document business scenario definition page also provides business scenario priority settings. During the voucher generation stage, the document is automatically generated based on the business scenario with the highest priority.
3. The method for dynamic automatic accounting entry according to claim 1, characterized in that: Each business scenario and the conditions that constitute the business scenario have the functions of adding, deleting, modifying and checking.
4. The method for dynamic automatic accounting entry according to claim 3 is characterized by: The basic information includes the person who prepared the document, the accounting date, the business date, the document type and the number of attachments; The entry details include summary, account source, account rule configuration, account configuration, debit and credit, and amount value; Each account rule needs to be configured separately. After the configured account rule is saved, it will be displayed in the drop-down box of the account rule configuration item for viewing, selection and reuse.
5. An accounting dynamic automatic entry platform, characterized by: include: The document configuration module is used to read the table structure of the document database by linking to the data source, configure the document according to the table structure, and agree on the primary key of each document; A document is composed of multiple tables. The structure of a single table includes field identifier, field name, whether it is a primary key, foreign key value, and data. The primary key is the unique identifier of the document and is used to connect to the business form. The primary key is a single field or a combination of multiple fields. The business scenario definition module is used to provide a document business scenario definition page for users to define business scenarios for documents and set whether to generate budgets according to their needs; each document can define at least one business scenario, and each business scenario corresponds to at least one applicable rule formula; The voucher template configuration module is used to provide a voucher configuration page for users to configure the basic information and entry details of the voucher template; the voucher data involved in the basic information and entry details can be dynamically obtained and displayed by directly selecting the data of the document; The association module is used to associate a voucher template with a business scenario; The voucher generation module is used to directly connect to the business system to generate vouchers and to generate vouchers through the financial intermediate library; The direct connection to the business system to generate a voucher includes the following steps: S11. Read the business form information on the business system and pass in the primary key of the document; S12, obtaining document information according to the primary key; S13. Filter the business scenarios according to the document information; S14. Read the voucher template information corresponding to the business scenario; S15, generating an accounting voucher according to the business form information, the voucher template information and the document information; The steps of generating vouchers through the financial intermediate library are as follows: S21, the financial intermediate library is initialized, and the document configuration phase, the business scenario definition phase, the voucher template configuration phase and the association configuration phase are completed by default; S22, read the business form information of the financial intermediate library, and pass in the primary key of the document; S23, reading the document information in the financial intermediate database according to the primary key of the document; S24. Filter the business scenarios according to the document information; S25. Read the voucher template information corresponding to the business scenario; S26: Generate an accounting voucher according to the business form information, the voucher template information and the document information.
6. The dynamic automatic accounting entry platform according to claim 5 is characterized by: When a document is set with multiple business scenarios, the document business scenario definition page also provides business scenario priority settings. During the voucher generation stage, the document is automatically generated based on the business scenario with the highest priority.
7. The dynamic automatic accounting entry platform according to claim 5 is characterized by: The business scenario definition module provides add, delete, modify and query functions for each business scenario and the constituent conditions of the business scenario.
8. The dynamic automatic accounting entry platform according to claim 5 is characterized by: The basic information includes the person who prepared the document, the accounting date, the business date, the document type and the number of attachments; The entry details include summary, account source, account rule configuration, account configuration, debit and credit, and amount value; Each account rule needs to be configured separately. After the configured account rule is saved, it will be displayed in the drop-down box of the account rule configuration item for viewing, selection and reuse.
9. An electronic device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, characterized in that: When the processor executes the program, the method according to any one of claims 1 to 4 is implemented.
10. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the program is executed by a processor, the method according to any one of claims 1 to 4 is implemented.
Citation Information
Patent Citations
Accounting document generation method
CN110717321A