A voucher information generation method, device and equipment for a document scene and a medium

Abstract

The present application relates to computer software technology, disclose a kind of voucher information generation method of bill scene, comprising: according to business bill information table, construct multiple business models, according to the difference between each business model, define the conversion mark of voucher engine;According to the conversion mark, generate the grouping rule of business voucher, generate the merging rule of business voucher using voucher attribute, according to grouping rule, merging rule and template attribute, build engine template;According to business voucher type, select corresponding voucher template in engine template, according to voucher header item field, voucher line item field and data source, carry out template content configuration to voucher template, obtain voucher engine;According to voucher engine and business bill information table, generate voucher information.The present application also proposes a kind of voucher information generation device of bill scene, equipment and medium.The present application can improve the extensibility when generating voucher information.

Description

Technical Field

[0001] This invention relates to the field of computer software technology, and in particular to a method, apparatus, electronic device, and computer-readable storage medium for generating voucher information in a document-based scenario. Background Technology

[0002] With the implementation and advancement of shared financial services and digital transformation in major group enterprises, the transformation from financial accounting to management accounting, and the trend towards standardization, normalization, and automation of financial accounting are becoming increasingly apparent. To reduce the workload of finance personnel and free them from tedious and repetitive tasks, allowing them to engage in more specialized work, it is necessary to standardize business activities to convert business data into financial data.

[0003] Existing voucher information generation solutions encapsulate fixed voucher methods by streamlining business and financial voucher logic and then generate voucher information through document type configuration. In practice, voucher configuration requires multiple modifications. During configuration, only the method description is visible, not the mapping logic between business and financial data. This can lead to overly cumbersome voucher configuration when new business requirements arise, resulting in poor scalability for voucher information generation. Summary of the Invention

[0004] To address the aforementioned issues, embodiments of the present invention provide a method, apparatus, electronic device, and computer-readable storage medium for generating voucher information in a document-based scenario.

[0005] In a first aspect, embodiments of the present invention provide a method for generating voucher information in a document-based scenario, including:

[0006] Multiple business models are constructed based on a preset business document information table, and the conversion identifier of the voucher engine is defined based on the differences between each business model.

[0007] Generate a preset grouping rule for business vouchers based on the conversion identifier, generate a merging rule for the business vouchers using preset voucher attributes, and construct an engine template based on the grouping rule, the merging rule, and preset template attributes.

[0008] Select the corresponding voucher template in the engine template according to the preset business voucher type, and configure the template content of the voucher template according to the preset voucher header item fields, voucher line item fields and data source to obtain the voucher engine;

[0009] Voucher information is generated based on the voucher engine and the business document information table.

[0010] According to an embodiment of the present invention, the step of constructing multiple business models based on a preset business document information table includes:

[0011] Create multiple business model pages corresponding to the aforementioned business models using preset business types;

[0012] Select a business model on the business model page according to the business type;

[0013] The business document information table is classified according to the business type to obtain a classified document information table;

[0014] The classification document information table and preset field attributes are added to the corresponding fields of the business model to obtain the business model.

[0015] According to an embodiment of the present invention, the merging rule for generating the business voucher using preset voucher attributes includes:

[0016] According to the preset summary item nature, extract the entry voucher attribute and auxiliary voucher attribute from the voucher attributes, extract the entry field information corresponding to the entry voucher attribute, and extract the auxiliary field information corresponding to the auxiliary voucher attribute;

[0017] The journal voucher attributes are grouped and merged using a preset journal grouping and merging function to obtain merged journal voucher attributes. The journal field information is then merged using a preset journal field merging function to obtain merged journal field information.

[0018] The auxiliary voucher attributes are grouped and merged using a preset auxiliary grouping and merging function to obtain merged auxiliary voucher attributes. The auxiliary field information is then merged using a preset auxiliary field merging function to obtain merged auxiliary field information.

[0019] Based on the merged entry voucher attributes and the merged entry field information, voucher line entry merging rules are generated; based on the merged auxiliary voucher attributes and the merged auxiliary field information, voucher auxiliary accounting merging rules are generated.

[0020] The rules for merging the voucher line entries and the rules for merging the voucher auxiliary accounting entries are combined into the merging rules.

[0021] According to an embodiment of the present invention, the step of constructing an engine template based on the grouping rules, the merging rules, and preset template attributes includes:

[0022] The template number and template name in the engine template are determined according to the grouping rules;

[0023] The extended attributes in the engine template are determined according to the merging rules;

[0024] The template number, template name, extended attributes, and preset template attributes are filled into the page definition of the engine template to obtain the engine template.

[0025] According to an embodiment of the present invention, the step of configuring the template content of the voucher template according to preset voucher header item fields, voucher line item fields, and data source to obtain a voucher engine includes:

[0026] The first conversion rule for the voucher header in the voucher template is determined based on the voucher header item field, and the second conversion rule for the voucher entry in the voucher template is determined based on the voucher line item field.

[0027] The first data source table and the first data source column of the voucher header in the voucher template are determined according to the first conversion rule, and the second data source table and the second data source column of the voucher entries in the voucher template are determined according to the second conversion rule;

[0028] The voucher header in the voucher template is configured with the content based on the voucher header item fields, the first conversion rule, the data source, the first data source table, and the first data source column to obtain the voucher header template;

[0029] Based on the voucher line item field, the second conversion rule, the data source, the second data source table, and the second data source column, the content of the voucher entries in the voucher template is configured to obtain the voucher entry template.

[0030] The voucher header template and the voucher entry template are used as the voucher engine.

[0031] According to an embodiment of the present invention, generating voucher information based on the voucher engine and the business document information table includes:

[0032] Configure the preset voucher template configuration page to obtain the voucher template configured page;

[0033] Select the voucher engine on the voucher template configuration page according to the preset business type to obtain the business voucher engine;

[0034] The business document information table is converted into voucher information using the business voucher engine.

[0035] According to an embodiment of the present invention, the step of converting the business document information table into voucher information based on the business voucher engine includes:

[0036] The corresponding business document information in the business document information table is converted into preset accounting subject information according to the preset lookup table;

[0037] The business document information table is converted into the voucher information using the accounting subject information and the data source column in the business voucher engine.

[0038] Secondly, embodiments of the present invention provide a voucher information generation device for a document-based scenario, characterized in that it includes:

[0039] The conversion identifier definition module is used to construct multiple business models based on a preset business document information table, and define the conversion identifier of the voucher engine according to the differences between each business model;

[0040] The engine template construction module is used to generate a preset grouping rule for business vouchers based on the conversion identifier, generate a merging rule for the business vouchers using preset voucher attributes, and construct an engine template based on the grouping rule, the merging rule, and the preset template attributes.

[0041] The voucher engine configuration module is used to select the corresponding voucher template from the engine template according to the preset business voucher type, and configure the template content of the voucher template according to the preset voucher header item fields, voucher line item fields and data source to obtain the voucher engine;

[0042] The voucher information generation module is used to generate voucher information based on the voucher engine and the business document information table.

[0043] Thirdly, embodiments of the present invention provide an electronic device, which includes:

[0044] processor;

[0045] Memory used to store the processor's executable instructions;

[0046] The processor is configured to execute the instructions to implement a method for generating voucher information in a document-based scenario as described in the first aspect above.

[0047] Fourthly, embodiments of the present invention provide a computer-readable storage medium having a computer program stored thereon, which, when executed by a processor, implements a method for generating voucher information in a document-based scenario as described in the first aspect above.

[0048] Compared with the prior art, the above-mentioned technical solution of the present invention has the following beneficial effects:

[0049] The embodiments of this invention classify voucher engines and associate them with business documents through voucher engine definitions and engine template definitions. Through template content definitions, all voucher headers and voucher line item fields can be displayed, and conversion rules for each field can be set. The data source table and lookup table include all business data tables under the business model, covering all business information. When new business needs are added, the voucher engine can be directly configured. The fields displayed in the voucher engine configuration interface are configurable, and multiple voucher entries can be configured according to different situations, offering high flexibility and strong scalability, enabling voucher data conversion for new business requirements. The conversion logic of each field can be clearly seen through the voucher engine configuration interface, which can be adjusted at any time according to business needs. The interface language is simple and easy to understand, and the configuration interface is convenient to operate. Therefore, the voucher information generation method, device, electronic device, and computer-readable storage medium for document-based scenarios proposed in this invention can solve the problem of poor scalability when generating voucher information. Attached Figure Description

[0050] To more clearly illustrate the technical solutions in the embodiments of the present invention or the prior art, the drawings used in the description of the embodiments or the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present invention. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0051] Figure 1 The flowchart illustrates the process of generating voucher information in a document-based scenario according to Embodiment 1 of the present invention.

[0052] Figure 2 This diagram illustrates the business model page definition of Embodiment 1 of the present invention.

[0053] Figure 3 This diagram illustrates the definition of the business model content in Embodiment 1 of the present invention.

[0054] Figure 4 This diagram illustrates the definition of the credential engine page according to Embodiment 1 of the present invention.

[0055] Figure 5 This diagram illustrates the content definition of the engine template according to Embodiment 1 of the present invention.

[0056] Figure 6 This shows a schematic diagram illustrating the template definition of the voucher header and voucher entries in the voucher template of Embodiment 1 of the present invention;

[0057] Figure 7 A schematic diagram of the voucher template configuration according to Embodiment 1 of the present invention is shown;

[0058] Figure 8This is a schematic diagram showing the voucher page of Embodiment 1 of the present invention, including voucher header information and voucher entry information;

[0059] Figure 9 This diagram illustrates the definition of the reference table content in Embodiment 2 of the present invention;

[0060] Figure 10 A schematic diagram showing the business type and accounting subject mapping table of Embodiment 2 of the present invention is displayed;

[0061] Figure 11 A schematic diagram of the tax code configuration table according to Embodiment 2 of the present invention is shown;

[0062] Figure 12 This illustrates the intended configuration of the special general ledger flags in Embodiment 2 of the present invention;

[0063] Figure 13 The diagram shows the data flow of the credential engine function according to Embodiment 1 of the present invention;

[0064] Figure 14 This diagram illustrates the definition of the credential engine according to Embodiment 1 of the present invention.

[0065] Figure 15 This diagram shows the functional modules of the voucher information generation device in the document-based scenario according to Embodiment 3 of the present invention.

[0066] Figure 16 The diagram shows the composition of an electronic device that implements the document-based scenario voucher information generation method according to Embodiment 5 of the present invention. Detailed Implementation

[0067] The present disclosure will be further described below with reference to the embodiments shown in the accompanying drawings.

[0068] It should be noted that, unless otherwise specified, the embodiments and features described in this application can be combined with each other. The present invention will now be described in detail with reference to the accompanying drawings and embodiments.

[0069] This invention proposes a method for generating voucher information in a document-based scenario based on computer software technology. Based on data transformation theory and combined with template content definition methods, a voucher engine is constructed to realize the conversion of business data into financial data. Compared with traditional methods, the voucher information generation technology based on the document-based scenario has higher scalability and reduces the workload of practitioners, showing great potential and application prospects in the design and application of voucher engines in financial information systems.

[0070] Example 1

[0071] like Figure 1 As shown, this invention proposes a method for generating voucher information in a document-based scenario, comprising the following steps:

[0072] S1. Construct multiple business models based on a preset business document information table, and define the conversion identifier of the voucher engine based on the differences between each business model;

[0073] In this embodiment of the invention, the business document information table includes a general ledger business table, accounts receivable business table, accounts payable business table, asset business table, cost business table, etc. The business model primarily categorizes business documents and manages the business table information for each type of model. For example, if the business document information table includes expense reimbursement-application business data, then the business model is an expense reimbursement-application business model; if the business document information table includes expense budget business data, then the business model is an expense reimbursement-budget application model.

[0074] In this embodiment of the invention, constructing multiple business models based on a preset business document information table includes:

[0075] Create multiple business model pages corresponding to the aforementioned business models using preset business types;

[0076] Select a business model on the business model page according to the business type;

[0077] The business document information table is classified according to the business type to obtain a classified document information table;

[0078] The classification document information table and preset field attributes are added to the corresponding fields of the business model to obtain the business model.

[0079] In detail, the business model page includes a model number, model name, creation time, and modification time. The model number is a custom model number that cannot be modified after saving, such as FSS_BBDM_INFO. The model name is a custom model name that can be modified by double-clicking, and the model name corresponds to the model number; for example, the model name corresponding to the model number FSS_BBDM_INFO is "Reimbursement-Budget Application Model." The creation time is the time automatically recorded by the system, and the modification time is the time automatically recorded by the system. Figure 2 The diagram shown illustrates the definition of the business model page. The model number corresponds to different models, including ACPZModel, FSS_BBDM_INFO, FSS_BBXM_INFO, FSS_BCBM_INFO, and FSS_BJKM_INFO. The model name contains the corresponding name, including Accounting Voucher Model, Reimbursement-Budget Application Model, Reimbursement-Reimbursement Application Business Model, Expense Reporting-Cost Business Model, and Reimbursement-Loan Business Model. The creation and modification times are automatically recorded by the system.

[0080] Specifically, based on the business type, a business model can be selected on the business model page. For example, if the business type is "Reimbursement - Reimbursement Application," then the "Reimbursement - Reimbursement Application" model can be selected from the model names on the business model page. The business document information tables under the "Reimbursement - Reimbursement Application" business type include reimbursement application forms, document contract information, reimbursement application-related event applications, payment information, and reimbursement-accounts information, etc. Therefore, the business document information tables can be categorized according to the business type to obtain the business document information tables corresponding to different business types.

[0081] Furthermore, the selected business model is defined based on the business document information table. This means defining which business document table information is included in the model. The business model content definition page also includes field attributes, namely business model, content type, content ID, content name, parent content ID, and fact table. The business model is the business model that needs to be selected before definition; the model content definition is based on the business model selected on the business model page. The content type includes "document," "entry," and "details," which are selected based on the structure of the document information table. The content ID is manually entered; for example, the information is the business document table ID, business document table I... D is consistent with the object ID in the data object; the content name corresponds to the content ID. For example, the content name corresponding to the business document table ID FSS_BBXM_INFO is "Reimbursement Application Form". The parent ID is the parent content ID of this line's content. For example, if the content type is a document, its corresponding content ID is FSS_BBXM_INFO; when the content type is an entry, its corresponding content ID is FSS_BBXS_ZFXX, and its corresponding parent content ID is FSS_BBXM_INFO. The fact table is selected according to the search box, and the options are data object table information, such as reimbursement application information, document contract information, reimbursement application-payment information, etc. After populating the corresponding field content in the business model, the business model corresponding to different business types is obtained. For example... Figure 3 The diagram illustrates the definition of business model content. Model content is defined for each business model. For example, if the selected business model is the reimbursement-reimbursement application business model, content is populated under this model for content type, content ID, content name, parent content ID, and fact table to obtain the business model. The business document information table that can be selected when defining voucher content originates from this model content.

[0082] In this embodiment of the invention, the conversion identifier is used to define the conversion identifier of the voucher engine. When defining it, it needs to be associated with a model; businesses of the same type can be categorized into one class. The difference between each model refers to the different business types defined by different models. Based on the differences between each model, the conversion name of the voucher engine can be defined, and then the conversion identifier of the voucher engine can be defined based on the conversion name.

[0083] In detail, the page definition for the credential engine includes the transformation identifier, transformation name, and source model. The transformation identifier and transformation name are manually entered, while the source model is selected via a search box, with the search term being a predefined model. For example... Figure 4 The diagram illustrates the definition of the voucher engine page, including the conversion identifier, conversion name, and source model. For example, when the conversion name is "Reimbursement Voucher," the model corresponding to "Reimbursement" is selected from the source models based on the differences between different models, and the conversion identifier is defined as BXConvert-YXTJ. Similarly, when the conversion name is "Loan Voucher," the model corresponding to "Loan" is selected from the source models, and the conversion identifier is defined as JKConvert-YXTJ. Therefore, different conversion identifiers can be defined within the voucher engine according to different business types.

[0084] Furthermore, the engine template can be defined based on the conversion identifier of the credential engine. You need to select the conversion identifier first, and then define the engine template.

[0085] S2. Generate a preset grouping rule for business vouchers based on the conversion identifier, generate a merging rule for the business vouchers using preset voucher attributes, and construct an engine template based on the grouping rule, the merging rule, and preset template attributes.

[0086] In this embodiment of the invention, the grouping rule refers to grouping engine templates based on conversion identifiers; a single conversion identifier can have multiple engine templates. The business credentials are credentials generated for different business types.

[0087] In detail, if the conversion identifier is BXConvert-YXTJ, which is a reimbursement voucher, after selecting the conversion identifier corresponding to the reimbursement voucher, only engine templates related to reimbursement can be defined under this conversion identifier, such as expense reimbursement, domestic travel reimbursement, and overseas travel reimbursement. That is, the grouping rules for each business voucher are generated according to the conversion identifier, and the reimbursement business corresponding to the reimbursement voucher is grouped together, and the loan business corresponding to the loan voucher is grouped together.

[0088] In this embodiment of the invention, the voucher attribute refers to the corresponding field attribute in the business voucher, such as account number, posting code, etc.

[0089] In this embodiment of the invention, the step of generating the merging rule for the business voucher using preset voucher attributes includes:

[0090] According to the preset summary item nature, extract the entry voucher attribute and auxiliary voucher attribute from the voucher attributes, extract the entry field information corresponding to the entry voucher attribute, and extract the auxiliary field information corresponding to the auxiliary voucher attribute;

[0091] The journal voucher attributes are grouped and merged using a preset journal grouping and merging function to obtain merged journal voucher attributes. The journal field information is then merged using a preset journal field merging function to obtain merged journal field information.

[0092] The auxiliary voucher attributes are grouped and merged using a preset auxiliary grouping and merging function to obtain merged auxiliary voucher attributes. The auxiliary field information is then merged using a preset auxiliary field merging function to obtain merged auxiliary field information.

[0093] Based on the merged entry voucher attributes and the merged entry field information, voucher line entry merging rules are generated; based on the merged auxiliary voucher attributes and the merged auxiliary field information, voucher auxiliary accounting merging rules are generated.

[0094] The rules for merging the voucher line entries and the rules for merging the voucher auxiliary accounting entries are combined into the merging rules.

[0095] In detail, the nature of the summarized items is based on the fact that voucher line items in the existing voucher attributes have the property of being able to be summarized and displayed. For example, voucher line items with the same account number, the same posting code, or the same auxiliary accounting can be summarized and displayed. That is, from the voucher attributes, voucher attributes with the same account number and the same posting code that have the journal entry voucher attribute are extracted, and voucher attributes with the same auxiliary accounting that have the auxiliary voucher attribute are extracted. The journal entry field information is the account amount, and the auxiliary field information is the auxiliary accounting weight.

[0096] Specifically, the entry grouping and merging function is ReferColumn, used to define the grouping conditions for merging voucher lines; the entry field merging function is MergeColumn, used to define the field information for summarizing grouped entries; the auxiliary grouping and merging function is PartReferColumn, used to define the grouping conditions for auxiliary accounting; and the auxiliary field merging function is PartMergeColumn, used to define the field information for summarizing grouped auxiliary accounting. The merging rules include voucher line entry merging rules and voucher auxiliary accounting merging rules. The voucher line entry merging rules merge entries based on the grouping conditions, such as merging entries with the same account but different amounts. The voucher auxiliary accounting merging rules merge entries based on the grouping conditions of auxiliary accounting. For example, voucher line items with the same account number, the same posting code, and the same auxiliary accounting can be summarized and displayed; account amounts need to be summarized; and auxiliary accounting weights need to be summarized. Therefore, "ReferColumn" defines the account number and posting code, "PartReferColumn" defines the auxiliary accounting, "MergeColumn" defines the account amount, and "PartMergeColumn" defines the auxiliary accounting weight.

[0097] Furthermore, it is necessary to define the page and populate the page content of the engine template to obtain the engine template, which is used to populate the template content in the voucher engine later.

[0098] In this embodiment of the invention, the step of constructing an engine template based on the grouping rules, the merging rules, and preset template attributes includes:

[0099] The template number and template name in the engine template are determined according to the grouping rules;

[0100] The extended attributes in the engine template are determined according to the merging rules;

[0101] The template number, template name, extended attributes, and preset template attributes are filled into the page definition of the engine template to obtain the engine template.

[0102] In detail, the template page definition includes template number, template name, generation method, whether to merge entries, extended attributes, usage status, creation date, and update date. The template attributes include generation method, whether to merge entries, usage status, creation date, and update date. Specifically, the template number is manually entered and cannot be modified after saving; the template name is manually entered and can be modified after saving; the generation method is selected from a dropdown menu, including displaying data and direct saving. Displaying data shows the voucher data information in the voucher interface for confirmation; direct saving saves the table directly without displaying voucher information; whether to merge entries determines whether to merge voucher information during voucher generation. For example, a reimbursement form may have multiple rows of reimbursement details; after each row of details is converted into voucher data, it determines whether to display it row by row or after merging; the usage status defines whether this voucher template is used; the creation date is automatically recorded by the system; and the update date is automatically recorded by the system.

[0103] Specifically, the grouping rules are defined based on conversion identifiers. Under a conversion identifier, the template name and template number of the engine template can be defined. For example, if the conversion identifier is "reimbursement voucher," then expense reimbursement templates, domestic travel reimbursement templates, and overseas travel reimbursement templates can be defined based on the reimbursement voucher, with corresponding template numbers such as ER-BZ-002, ER-CL01-002, and ER-CL02-002. The extended attributes mainly configure the voucher merging rules, primarily including voucher line entry merging rules and voucher auxiliary accounting merging rules. Figure 5 The diagram illustrates the definition of an engine template. An engine template is defined, and multiple engine templates can exist under one transformation identifier. For example, template number ER-BZ-002 has the template name "Expense Reimbursement," the generation method is "Display Data," the option to merge entries is selected as "Yes," and the extended attributes are ReferColumn = f_KMBH,SAP_JZM, which summarizes and displays entries with the same account number and posting key. The usage status is selected as "Used," and both the creation and update dates are automatically recorded dates and times. Similarly, template number ER-CL01-002 and template ER-BZ-002 are configured with the same project fields to obtain the engine template.

[0104] Furthermore, the engine template allows users to select a voucher template and define its content for the complete construction of the voucher engine, enabling the generation of voucher information based on the voucher engine.

[0105] S3. Select the corresponding voucher template in the engine template according to the preset business voucher type, and configure the template content of the voucher template according to the preset voucher header item field, voucher line item field and data source to obtain the voucher engine;

[0106] In this embodiment of the invention, the business voucher types are categorized according to business operations, including expense reimbursement vouchers, loan vouchers, general ledger vouchers, accounts payable vouchers, cost vouchers, etc. Therefore, a corresponding voucher template can be selected from the previously created engine templates based on the business voucher type. For example, if the business voucher type is an expense reimbursement voucher, the voucher template selected in the engine templates is the expense reimbursement template.

[0107] In detail, after selecting the corresponding voucher template, the content of the voucher template needs to be defined. The template content definition includes two parts: voucher header and voucher entry definition. The configuration methods for the two parts are the same.

[0108] In this embodiment of the invention, the settings of the voucher header item field and the voucher line item field are derived from the data object LSPZXX accounting voucher information table. For example, if the header information in the accounting voucher information table includes voucher type, company code, posting period, currency exchange rate, etc., then the target field in the voucher header is set to the field corresponding to the header information according to the header information in the accounting voucher information table. For example, the target field set for voucher type is F_PZLX, the target field set for company code is BUKRS, the target field set for posting period is F_VDATE, and the target field set for currency exchange rate is CURRENCY. Similarly, the voucher line item field in the voucher entry and the voucher header item field in the voucher header are set in the same way.

[0109] In this embodiment of the invention, the step of configuring the voucher template content according to preset voucher header field, voucher line field, and data source to obtain the voucher engine includes:

[0110] The first conversion rule for the voucher header in the voucher template is determined based on the voucher header item field, and the second conversion rule for the voucher entry in the voucher template is determined based on the voucher line item field.

[0111] The first data source table and the first data source column of the voucher header in the voucher template are determined according to the first conversion rule, and the second data source table and the second data source column of the voucher entries in the voucher template are determined according to the second conversion rule;

[0112] The voucher header in the voucher template is configured with the content based on the voucher header item fields, the first conversion rule, the data source, the first data source table, and the first data source column to obtain the voucher header template;

[0113] Based on the voucher line item field, the second conversion rule, the data source, the second data source table, and the second data source column, the content of the voucher entries in the voucher template is configured to obtain the voucher entry template.

[0114] The voucher header template and the voucher entry template are used as the voucher engine.

[0115] In detail, the conversion rules configured for the target field are based on the field attributes of the target field. These conversion rules include source column formula conversion, conversion from details, constants, system environment variables, and direct lookup tables. Furthermore, the data source includes a source model, a target model, and conversion. The data source table is defined based on the table information in the model content definition of the source model corresponding to the voucher template; the data source columns are filtered based on the data source table, and their values ​​are all column information from that source table. Additionally, the voucher header and voucher entries also include data types, conversion source columns, lookup tables, lookup table target columns, and lookup table conditions. Data types include character and numeric values; the conversion source columns are the data source columns in the data source table; the lookup table is manually entered lookup table information; the lookup table target column is the value of the target field in the converted row, taken from the value of the target column in the lookup table; and the lookup table conditions are the association conditions between the source table and the lookup table, i.e., the conditions by which the two tables are associated.

[0116] Specifically, when the target field of the row is directly converted from the business document information table, a lookup table is used. The value is converted by associating the lookup table with the conditions. When the conversion rule is "constant," the data source is the conversion table, no data source table needs to be entered, and the data source column contains fixed values. The value of the target field in the row is converted based on these fixed values. When the conversion rule is "system environment variable," the conversion table for that system environment variable is selected in the data source table. The data source column is filtered according to the selected data source table, and finally, the value of the target field in the row is converted based on the value of the data source column. Common system environment variables include: personnel number, personnel name, system date, etc. When the conversion rule is "source column formula conversion," the data source table can optionally be the table information defined in the source model of the voucher template, and the data source column can contain conversion formulas. In the process of conversion, the system calculates the value of the target field for the row based on the business document information and the conversion formula of the data source column. When the conversion rule is "from details", the optional data source table is the table information defined in the source model of the voucher template, and the data source column is the field information of the selected data source table. Based on the selected data source table, the target field of the row is generated according to the field information of the data source column. When the conversion rule is "direct reference table", the target field of the row cannot be directly converted from the data source table. It needs to be matched with the reference table conditions based on the obtained data source column fields. Finally, the target field of the row obtains the value of the reference table target column that meets the conditions.

[0117] Furthermore, both the first and second data source tables are configured for transformation rules, and the first data source column is configured based on the first data source table, while the second data source column is configured based on the second data source table. Once the corresponding display fields in the voucher engine are configured, a voucher engine that can be used for voucher information generation is obtained. For example... Figure 6 The diagram illustrates the template definition of the voucher header and voucher entries in a voucher template. Configuration is achieved by setting the target fields, conversion rules, data source, data source table, data source column, data type, conversion source column, lookup table, lookup table target column, and lookup table conditions for each display field. Once configured, the voucher engine used for generating voucher information is obtained.

[0118] S4. Generate voucher information based on the voucher engine and the business document information table.

[0119] In this embodiment of the invention, when generating voucher information, it is necessary to query the business voucher information to be generated from the voucher template configuration page, and then convert the business document information table into financial data to generate voucher information.

[0120] In this embodiment of the invention, generating voucher information based on the voucher engine and the business document information table includes:

[0121] Configure the preset voucher template configuration page to obtain the voucher template configured page;

[0122] Select the voucher engine on the voucher template configuration page according to the preset business type to obtain the business voucher engine;

[0123] The business document information table is converted into voucher information using the business voucher engine.

[0124] In detail, the voucher template configuration page allows you to configure voucher templates based on the company code and document type. For example... Figure 7 The diagram illustrates the configuration of voucher templates. The page configuration includes company code, document type, business type code, and voucher template. The company code is a search term for company codes already configured and enabled in the system. When a document type is selected in the left-hand tree structure, the right side displays all sub-document types of the selected document type. Voucher templates are configured within the document types on the right. The business type code is a search term for all business types already configured and enabled in the system. If different business types for the same document use different voucher templates, the business type must be selected here. The voucher templates are all voucher templates defined in the "Engine Template Definitions".

[0125] Specifically, during voucher generation, the voucher template (i.e., the voucher engine) is first located based on the voucher template configuration. Then, depending on the business type, the corresponding voucher engine (i.e., the business voucher engine) is found. Finally, the business information is converted into voucher information based on the voucher template content definition. For example... Figure 8 The image shows a diagram of a voucher page that includes voucher header information and voucher entry information. The voucher header information is converted based on the voucher header field defined in the voucher template content definition, and the voucher entry information is displayed based on the voucher entry field defined in the voucher template content definition. Multiple rows can be defined according to business needs when defining voucher entries. When the voucher is finally generated, entry information with an amount of 0 is filtered out.

[0126] Example 2

[0127] To better understand the present invention, a second embodiment is provided below to further explain the situation where the target field cannot be directly converted into voucher information based on the data source table in the voucher engine.

[0128] In this embodiment of the invention, when a target field cannot be directly converted into voucher information based on the data source table, it is necessary to match the obtained data source column field with the conditions of the lookup table. Ultimately, the target field of that row obtains the value of the target column in the lookup table that meets the conditions. The lookup table includes a business type and accounting subject mapping table, a tax code configuration table, and a special general ledger flag configuration table.

[0129] In this embodiment of the invention, the step of converting the business document information table into voucher information according to the business voucher engine includes:

[0130] The corresponding business document information in the business document information table is converted into preset accounting subject information according to the preset lookup table;

[0131] The business document information table is converted into the voucher information using the accounting subject information and the data source column in the business voucher engine.

[0132] In detail, the business document information in the business document information table includes business type, settlement method, expense collection, invoice form, invoice type, account group, inventory category, etc. The business document information is converted into accounting account information according to the pre-configured business type and accounting account mapping table, tax code configuration table, and special general ledger flag configuration table. First, the lookup table must be defined. This table includes business type, settlement method, expense collection, invoice type, intra-group / external, account group, inventory category, accounting subject, posting code, and special general ledger identifier. The business type refers to the business types already enabled in each business document. When the settlement method, expense collection, invoice type, intra-group / external, account group, and inventory category are related to the voucher accounting subject, the search terms are the settlement method, expense collection, invoice type, intra-group / external, account group, and inventory category already configured and enabled in the system. The accounting subject is defined based on the accounting subject information corresponding to the business type, settlement method, expense collection, invoice type, and invoice type. The system will subsequently convert the business type and related business information entered in the document into accounting subjects. The posting code is the posting code already configured and enabled in the system, synchronized with the ERP system's posting code, and consistent with the ERP system's posting code. The special general ledger identifier is the special general ledger identifier already configured and enabled in the system, synchronized with the ERP system's special general ledger identifier. For example... Figure 9 The diagram shown is a schematic of the definition of the reference table content. When the business type is Administrative Office Expenses - Printing Expenses, the corresponding accounting subject is Expenses - Administrative Office Building, and the expenses are collected as Expenses. The definitions of other corresponding fields can be set according to the requirements.

[0133] Specifically, by combining accounting subject information with the data source columns in the voucher engine, the target fields are converted into financial data. For example, Figure 10 The diagram shown illustrates the mapping between business types and accounting subjects. It associates business types with accounting subjects; for example, if the business type is "Domestic Travel Expenses - Accommodation Expenses," the corresponding accounting subject is "Expenses - Travel Expenses." Figure 11 The image shows a schematic diagram of the tax code configuration table, including the tax code, tax code name, tax rate, tax type, financial system group code, invoice type, accounting subject, and subject name. For example, when the tax code is X12, the tax code name is "Output Tax -1%", the tax rate is 0.010000, the tax type is "Output Tax", the invoice type is "VAT Special Invoice", the accounting subject is 2221010212, and the subject name is "Taxes Payable - Output Tax -1%". Figure 12The diagram illustrates the configuration of special general ledger identifiers, including account type, special general ledger identifier, special general ledger identifier name, controlling account, general ledger account, and general ledger account name. For example, when the account type is K, the special general ledger identifier is 1, the special general ledger identifier name is Long-term borrowings - Unrecognized financing costs, the controlling account is 2202010001, the general ledger account is 2501030001, and the general ledger account name is Long-term borrowings - Unrecognized financing costs.

[0134] In this embodiment of the invention, the voucher engine primarily enables the conversion of business data into financial data, ensuring intelligent, automatic, efficient, and accurate data conversion, and automatically generating voucher information. For example... Figure 13 The diagram shows the data flow of the voucher engine function. The voucher engine is formed by the general ledger business, accounts receivable business, accounts payable business, asset business, cost business, etc. included in the business documents. The voucher engine is obtained by configuring the voucher header data rules, voucher entry data rules, business type and accounting subject mapping, tax code configuration, and special general ledger flag configuration. The business data is then converted into voucher data through the voucher engine, thereby automatically generating voucher information.

[0135] In detail, the definition of a credential engine includes the credential engine definition, engine template definition, and template content definition, such as... Figure 14 The diagram shows the definition of a voucher engine. The voucher engine definition is used to classify voucher engines and associate them with business document table information. The engine template definition mainly defines the grouping rules and merging rules for each template. The template content definition includes the configuration of the voucher header and voucher line items.

[0136] Example 3

[0137] like Figure 15 As shown in the figure, this embodiment also provides a functional module diagram of a voucher information generation device for a document-based scenario.

[0138] The voucher information generation device 100 for the document-based scenario described in this embodiment can be installed in an electronic device. Depending on the functions implemented, the voucher information generation device 100 for the document-based scenario may include a conversion identifier definition module 101, an engine template construction module 102, a voucher engine configuration module 103, and a voucher information generation module 104. The module described in this invention can also be called a unit, which refers to a series of computer program segments that can be executed by the processor of an electronic device and can perform a fixed function, and which are stored in the memory of the electronic device.

[0139] In this embodiment, the functions of each module / unit are as follows:

[0140] The conversion identifier definition module 101 is used to construct multiple business models based on a preset business document information table, and define the conversion identifier of the voucher engine based on the differences between each business model.

[0141] The engine template construction module 102 is used to generate a preset grouping rule for business vouchers based on the conversion identifier, generate a merging rule for the business vouchers using preset voucher attributes, and construct an engine template based on the grouping rule, the merging rule, and the preset template attributes.

[0142] The voucher engine configuration module 103 is used to select the corresponding voucher template in the engine template according to the preset business voucher type, and configure the template content of the voucher template according to the preset voucher header item field, voucher line item field and data source to obtain the voucher engine;

[0143] The voucher information generation module 104 is used to generate voucher information based on the voucher engine and the business document information table.

[0144] In detail, each module in the document-based voucher information generation device 100 described in the embodiments of the present invention adopts the same technical means as the document-based voucher information generation device method described in Embodiment 1 and Embodiment 2, and can produce the same technical effect, which will not be repeated here.

[0145] Example 4

[0146] like Figure 16 As shown, this embodiment also provides a computer electronic device, which may include a processor 10, a memory 11, a communication bus 12 and a communication interface 13, and may also include a computer program stored in the memory 11 and capable of running on the processor 10, such as a voucher information generation device program for a document-based scenario.

[0147] In some embodiments, the processor 10 may be composed of integrated circuits, such as a single packaged integrated circuit or multiple integrated circuits with the same or different functions, including combinations of one or more central processing units (CPUs), microprocessors, digital processing chips, graphics processors, and various control chips. The processor 10 is the control unit of the electronic device, connecting various components of the entire electronic device through various interfaces and lines. It executes programs or modules stored in the memory 11 (e.g., executing a voucher information generation device program in a document-based scenario) and calls data stored in the memory 11 to perform various functions of the electronic device and process data.

[0148] The memory 11 includes at least one type of readable storage medium, including flash memory, portable hard drive, multimedia card, card-type memory (e.g., SD or DX memory), magnetic memory, magnetic disk, optical disk, etc. In some embodiments, the memory 11 can be an internal storage unit of an electronic device, such as a portable hard drive. In other embodiments, the memory 11 can be an external storage device of the electronic device, such as a plug-in portable hard drive, Smart Media Card (SMC), Secure Digital (SD) card, Flash Card, etc. Furthermore, the memory 11 can include both internal and external storage units of the electronic device. The memory 11 can be used not only to store application software and various types of data installed on the electronic device, such as the code of a voucher information generation device program in a document-based scenario, but also to temporarily store data that has been output or will be output.

[0149] The communication bus 12 can be a peripheral component interconnect (PCI) bus or an extended industry standard architecture (EISA) bus, etc. This bus can be divided into an address bus, a data bus, a control bus, etc. The bus is configured to enable communication between the memory 11 and at least one processor 10, etc.

[0150] The communication interface 13 is used for communication between the aforementioned electronic device and other devices, including a network interface and a user interface. Optionally, the network interface may include a wired interface and / or a wireless interface (such as a Wi-Fi interface, Bluetooth interface, etc.), typically used to establish communication connections between the electronic device and other electronic devices. The user interface may be a display, an input unit (such as a keyboard), or, optionally, a standard wired or wireless interface. Optionally, in some embodiments, the display may be an LED display, a liquid crystal display, a touch-sensitive liquid crystal display, or an OLED (Organic Light-Emitting Diode) touchscreen, etc. The display may also be appropriately referred to as a screen or display unit, used to display information processed in the electronic device and to display a visual user interface.

[0151] The figure only shows an electronic device with components. Those skilled in the art will understand that the structure shown in the figure does not constitute a limitation on the electronic device and may include fewer or more components than shown, or combine certain components, or have different component arrangements.

[0152] For example, although not shown, the electronic device may also include a power supply (such as a battery) to power the various components. Preferably, the power supply can be logically connected to the at least one processor 10 through a power management device, thereby enabling functions such as charging management, discharging management, and power consumption management. The power supply may also include one or more DC or AC power supplies, recharging devices, power fault detection circuits, power converters or inverters, power status indicators, and other arbitrary components. The electronic device may also include various sensors, Bluetooth modules, Wi-Fi modules, etc., which will not be described in detail here.

[0153] It should be understood that the embodiments described are for illustrative purposes only and are not limited to this structure in the scope of the patent application.

[0154] The program for generating voucher information in a document-based scenario, stored in the memory 11 of the electronic device, is a combination of multiple instructions. When run in the processor 10, it can achieve the following:

[0155] Multiple business models are constructed based on a preset business document information table, and the conversion identifier of the voucher engine is defined based on the differences between each business model.

[0156] Generate a preset grouping rule for business vouchers based on the conversion identifier, generate a merging rule for the business vouchers using preset voucher attributes, and construct an engine template based on the grouping rule, the merging rule, and preset template attributes.

[0157] Select the corresponding voucher template in the engine template according to the preset business voucher type, and configure the template content of the voucher template according to the preset voucher header item fields, voucher line item fields and data source to obtain the voucher engine;

[0158] Voucher information is generated based on the voucher engine and the business document information table.

[0159] Specifically, the specific implementation method of the processor 10 for the above instructions can be referred to the description of the relevant steps in the corresponding embodiment of the accompanying drawings, and will not be repeated here.

[0160] Furthermore, if the modules / units integrated into the electronic device are implemented as software functional units and sold or used as independent products, they can be stored in a computer-readable storage medium. The computer-readable storage medium can be volatile or non-volatile. For example, the computer-readable medium may include: any entity or device capable of carrying the computer program code, a recording medium, a USB flash drive, a portable hard drive, a magnetic disk, an optical disk, a computer memory, or a read-only memory (ROM).

[0161] Example 5

[0162] This embodiment provides a storage medium storing a computer program. When the computer program is executed by a processor, it implements the steps of the voucher information generation method in the document-based scenario described above.

[0163] This program code can also be loaded onto a computer or other programmable data processing device, causing a series of operational steps to be executed on the computer or other programmable device to produce a computer-implemented process, thereby providing instructions that execute on the computer or other programmable device for implementing the process. Figure 1 Steps of a specified function in one or more processes.

[0164] Storage media include permanent and non-permanent, removable and non-removable media, and can be used to store information by any method or technology. Information can be computer-readable instructions, data structures, program modules, or other data. Examples of storage media include, but are not limited to, phase-change memory (PRAM), static random access memory (SRAM), dynamic random access memory (DRAM), other types of random access memory (RAM), read-only memory (ROM), electrically erasable programmable read-only memory (EEPROM), flash memory or other memory technologies, CD-ROM, digital versatile optical disc (DVD) or other optical storage, magnetic tape, disk storage or other magnetic storage devices, or any other non-transfer medium that can be used to store information accessible by computing devices.

[0165] It should be noted that the terminology used herein is for the purpose of describing particular implementations only and is not intended to limit the exemplary implementations according to this application. When the terms “comprising” and / or “including” are used in this specification, they indicate the presence of features, steps, operations, devices, components and / or combinations thereof.

[0166] It should be understood that the terms used in this way can be interchanged where appropriate so that the embodiments of this application described herein can be implemented, for example, in a sequence other than those illustrated or described herein.

[0167] In the several embodiments provided by this invention, it should be understood that the disclosed devices, apparatuses, and methods can be implemented in other ways. For example, the apparatus embodiments described above are merely illustrative; for instance, the division of modules is only a logical functional division, and other division methods may be used in actual implementation.

[0168] The modules described as separate components may or may not be physically separate. The components shown as modules may or may not be physical units; that is, they may be located in one place or distributed across multiple network units. Some or all of the modules can be selected to achieve the purpose of this embodiment according to actual needs.

[0169] Furthermore, the functional modules in the various embodiments of the present invention can be integrated into one processing unit, or each unit can exist physically separately, or two or more units can be integrated into one unit. The integrated unit can be implemented in hardware or in the form of hardware plus software functional modules.

[0170] It will be apparent to those skilled in the art that the present invention is not limited to the details of the exemplary embodiments described above, and that the present invention can be implemented in other specific forms without departing from the spirit or essential characteristics of the present invention.

[0171] Therefore, the embodiments should be considered exemplary and non-limiting in all respects, and the scope of the invention is defined by the appended claims rather than the foregoing description. Thus, all variations falling within the meaning and scope of equivalents of the claims are intended to be embraced within the invention. No appended diagram markings in the claims should be construed as limiting the scope of the claims.

[0172] The embodiments of this application can acquire and process relevant data based on artificial intelligence technology. Artificial intelligence (AI) refers to the theories, methods, technologies, and application systems that use digital computers or machines controlled by digital computers to simulate, extend, and expand human intelligence, perceive the environment, acquire knowledge, and use that knowledge to obtain optimal results.

[0173] Furthermore, it is clear that the word "comprising" does not exclude other units or steps, and the singular does not exclude the plural. Multiple units or devices recited in a system claim may also be implemented by a single unit or device through software or hardware. The terms "first," "second," etc., are used to indicate names and do not indicate any specific order.

[0174] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention and are not intended to limit it. Although the present invention has been described in detail with reference to preferred embodiments, those skilled in the art should understand that modifications or equivalent substitutions can be made to the technical solutions of the present invention without departing from the spirit and scope of the technical solutions of the present invention.

Claims

1. A method for generating voucher information of a documentarization scene, characterized in that, The method includes: Multiple business models are constructed based on a preset business document information table, and the conversion identifier of the voucher engine is defined based on the differences between each business model. Generate a preset grouping rule for business vouchers based on the conversion identifier, generate a merging rule for the business vouchers using preset voucher attributes, and construct an engine template based on the grouping rule, the merging rule, and preset template attributes. Select the corresponding voucher template in the engine template according to the preset business voucher type, and configure the template content of the voucher template according to the preset voucher header item fields, voucher line item fields and data source to obtain the voucher engine; Generate voucher information based on the voucher engine and the business document information table; The step of constructing an engine template based on the grouping rules, the merging rules, and preset template attributes includes: The template number and template name in the engine template are determined according to the grouping rules; The extended attributes in the engine template are determined according to the merging rules; The template number, template name, extended attributes, and preset template attributes are filled into the page definition of the engine template to obtain the engine template.

2. The method of claim 1, wherein, The construction of multiple business models based on a preset business document information table includes: Create multiple business model pages corresponding to the aforementioned business models using preset business types; Select a business model on the business model page according to the business type; The business document information table is classified according to the business type to obtain a classified document information table; The classification document information table and preset field attributes are added to the corresponding fields of the business model to obtain the business model.

3. The method of claim 1, wherein, The merging rules for generating the business vouchers using preset voucher attributes include: According to the preset summary item nature, extract the entry voucher attribute and auxiliary voucher attribute from the voucher attributes, extract the entry field information corresponding to the entry voucher attribute, and extract the auxiliary field information corresponding to the auxiliary voucher attribute; The journal voucher attributes are grouped and merged using a preset journal grouping and merging function to obtain merged journal voucher attributes. The journal field information is then merged using a preset journal field merging function to obtain merged journal field information. The auxiliary voucher attributes are grouped and merged using a preset auxiliary grouping and merging function to obtain merged auxiliary voucher attributes. The auxiliary field information is then merged using a preset auxiliary field merging function to obtain merged auxiliary field information. Based on the merged entry voucher attributes and the merged entry field information, voucher line entry merging rules are generated; based on the merged auxiliary voucher attributes and the merged auxiliary field information, voucher auxiliary accounting merging rules are generated. The rules for merging the voucher line entries and the rules for merging the voucher auxiliary accounting entries are combined into the merging rules.

4. The method for generating voucher information in a document-based scenario as described in claim 1, characterized in that, The step of configuring the voucher template content according to preset voucher header field, voucher line field, and data source to obtain the voucher engine includes: The first conversion rule for the voucher header in the voucher template is determined based on the voucher header item field, and the second conversion rule for the voucher entry in the voucher template is determined based on the voucher line item field. The first data source table and the first data source column of the voucher header in the voucher template are determined according to the first conversion rule, and the second data source table and the second data source column of the voucher entries in the voucher template are determined according to the second conversion rule; The voucher header in the voucher template is configured with the content based on the voucher header item fields, the first conversion rule, the data source, the first data source table, and the first data source column to obtain the voucher header template; Based on the voucher line item field, the second conversion rule, the data source, the second data source table, and the second data source column, the content of the voucher entries in the voucher template is configured to obtain the voucher entry template. The voucher header template and the voucher entry template are used as the voucher engine.

5. The method for generating voucher information in a document-based scenario as described in claim 1, characterized in that, The step of generating voucher information based on the voucher engine and the business document information table includes: Configure the preset voucher template configuration page to obtain the voucher template configured page; Select the voucher engine on the voucher template configuration page according to the preset business type to obtain the business voucher engine; The business document information table is converted into voucher information using the business voucher engine.

6. The method for generating voucher information in a document-based scenario as described in claim 5, characterized in that, The step of converting the business document information table into voucher information based on the business voucher engine includes: The corresponding business document information in the business document information table is converted into preset accounting subject information according to the preset lookup table; The business document information table is converted into the voucher information using the accounting subject information and the data source column in the business voucher engine.

7. A voucher information generation device for a document-based scenario, characterized in that, The device includes: The conversion identifier definition module is used to construct multiple business models based on a preset business document information table, and define the conversion identifier of the voucher engine according to the differences between each business model; The engine template construction module is used to generate a preset grouping rule for business vouchers based on the conversion identifier, generate a merging rule for the business vouchers using preset voucher attributes, and construct an engine template based on the grouping rule, the merging rule, and the preset template attributes. The step of constructing an engine template based on the grouping rules, the merging rules, and preset template attributes includes: The template number and template name in the engine template are determined according to the grouping rules; The extended attributes in the engine template are determined according to the merging rules; The template number, template name, extended attributes, and preset template attributes are filled into the page definition of the engine template to obtain the engine template; The voucher engine configuration module is used to select the corresponding voucher template from the engine template according to the preset business voucher type, and configure the template content of the voucher template according to the preset voucher header item fields, voucher line item fields and data source to obtain the voucher engine; The voucher information generation module is used to generate voucher information based on the voucher engine and the business document information table.

8. An electronic device comprising: processor; Memory used to store the processor's executable instructions; The processor is configured to execute the instructions to implement the voucher information generation method in the document-based scenario as described in any one of claims 1 to 6.

9. A computer-readable storage medium, characterized in that, It stores a computer program that, when executed by a processor, implements the method for generating voucher information in a document-based scenario as described in any one of claims 1 to 6.

Images