A supply chain financial business and financial integrated processing system and method

Abstract

The present invention discloses a system and method for processing business and finance integration of supply chain finance. The solution can adopt a microservice deployment mode, complete the docking of the supply chain finance system through simple secondary development and data maintenance of the Chinese-English comparison table of the document field, integrate financial and business data, and release the coupling of finance and business at the same time, keeping the two relatively independent. After the supply chain finance business occurs, the present invention supports matching the corresponding voucher entries in the template according to the business data and the configured voucher template to generate accounting vouchers. The present invention automatically obtains the original attachments required for voucher archiving, effectively improves financial work efficiency, and realizes digital financial management. Based on flexible template configuration, it supports different business logic scenarios to realize business and financial integration, and is suitable for supply chain systems with flexible business changes to realize business and financial integration, solving the problem of excessive financial constraints on business.

Description

Technical Field

[0001] The present invention belongs to the field of information processing, and specifically relates to a supply chain financial business and financial integrated processing system and method. Background Art

[0002] Digital transformation and reform are becoming the new direction of the global economy and the core driving force for my country's economic and social development. With the rapid development of informatization and digitalization, enterprises have begun to use digital transformation to empower business management. The financial management of many enterprises has chosen a more intelligent and information-based development direction, accelerating the pace of business and financial integration and innovation, reducing operating costs, liberating basic financial work, accelerating the transformation and upgrading of financial accounting to management accounting, and enhancing the decision-making basis of the leadership.

[0003] With the popularization of Internet technology, banks and other financial institutions have launched supply chain finance targeting the characteristics of small and medium-sized enterprises, which has achieved good social and economic benefits and solved the problems of credit enhancement, limited marketing, and funding for small and medium-sized enterprises. The business operation model of supply chain finance has also shown a trend of diversification. Taking the most common business model dominated by core enterprises as an example, the main industries and strengths of core enterprises are different, which may correspond to different business processes and logics, posing a great challenge to the realization of business and financial integration. At present, many supply chain financial systems only focus on their own business logic, and when connecting with third-party financial systems, they need to adopt the data interaction method of import and export. In the process, complex manual processing such as data format conversion is required, which seriously affects work efficiency and data accuracy; or although commonly used financial software integrates business and financial functions, its business processing logic cannot fully meet the needs of supply chain financial services, and the secondary development of enterprises is too dependent on third parties, which is costly. Summary of the invention

[0004] The present invention aims to provide a reference solution for supply chain finance to achieve business-finance integration and solve the problem that business and finance are independent and cannot be integrated. According to business data and configured voucher templates, accounting vouchers that meet financial requirements are automatically recorded and generated, and attachment information required for voucher archiving is obtained.

[0005] The objective of the present invention is achieved through the following technical solutions:

[0006] On one hand, the present invention provides a supply chain financial business and financial integrated processing system, including a supply chain platform and an accounting platform;

[0007] (1) Supply chain platform, including supply chain perception system and purchase, sales and inventory management system;

[0008] The supply chain perception system: users initiate business requests, which are reviewed by the supply chain management company and then forwarded to the purchase, sales and inventory management system;

[0009] The purchase, sales and inventory management system: receives business requests and generates business documents, and after review and approval, initiates a document generation request to the accounting platform; the document generation request includes the document type and document primary key;

[0010] (2) Accounting platform, including Chinese-English comparison table of document fields, automatic voucher switch, voucher template, voucher generation module and business-finance association module;

[0011] (2.1) The English-Chinese comparison table of document fields: used to translate and map the English fields of business data obtained through the document primary key query into Chinese fields with business common sense, and the Chinese fields are used to configure the voucher template information;

[0012] (2.2) The automatic voucher switch: for different document types, the on or off state is configured to control whether to call the voucher template to automatically generate the voucher after receiving the voucher generation request;

[0013] (2.3) The voucher template: includes template application conditions and voucher elements; the voucher elements include accounting entries, voucher influencing factors, comparison tables and attachments; the accounting entries include accounts or account classifications, summaries, amounts, and auxiliary accounting;

[0014] The template applicable conditions: for business documents of the same document type but different business logic, different voucher templates are set with fields reflecting different business logic as applicable conditions to meet the flexible requirements of different business scenarios requiring different accounting vouchers; after matching the voucher template that meets the applicable conditions, the voucher element configuration information corresponding to the voucher template is obtained;

[0015] The subjects can be directly configured as fixed subjects, or they can be configured as subject classifications according to voucher influencing factors;

[0016] The voucher influencing factor is the document field that affects the account entry;

[0017] The subject classification is a set of subject data confirmed according to the voucher influencing factor, comparison table and default subject;

[0018] The comparison table is the correspondence between the specific values ​​of the voucher impact factors and the fixed subjects;

[0019] The attachment includes two elements: the source of the attachment and the type of the attachment. The original attachment of the voucher is obtained from the business document according to the source and type for voucher review and archiving;

[0020] (2.4) The voucher generation module: obtains the data required for voucher generation according to the voucher element configuration fields in the voucher template and the queried business document information, and performs financial verification on the voucher data to generate an accounting voucher after passing the verification;

[0021] (2.5) The business-finance association module: updates the voucher association fields of the business document according to the primary key of the business document, thereby realizing the mutual query of business-finance data.

[0022] Furthermore, a default account is configured in the comparison table. If the specific value of the document field is not configured in the comparison table, or a fixed account is not matched in the comparison table, the default account is used.

[0023] Furthermore, if the business document matches multiple voucher templates, the voucher elements corresponding to each voucher template are obtained cyclically, and multiple accounting vouchers are generated.

[0024] Furthermore, in the voucher generation module, the financial verification is specifically: verifying whether the total amount of debits and credits is balanced, and verifying whether the auxiliary accounting value of the account exists in the corresponding file dictionary.

[0025] Furthermore, the processing system also includes a voucher generation interface, which, after receiving a voucher generation request, calls a voucher template to generate an accounting voucher according to the state of an automatic voucher switch.

[0026] Furthermore, the processing system also includes linkage with financial institutions; for payment and collection businesses with active accounts, the active account flow and receipt of the financial institution are obtained according to the enterprise account number as attachments to the payment and collection documents. According to the attachment source and attachment type configured in the template, when the voucher is generated, the attachment of the payment and collection document is used as an attachment to the voucher.

[0027] Furthermore, the processing system also includes a manual voucher module, which is used to manually trigger the generation of vouchers for business documents that have not generated vouchers when the automatic voucher switch is turned off.

[0028] Furthermore, the voucher template is also configured with a voucher aggregation method and an entry merging method; the voucher aggregation method supports aggregating multiple business document data to generate one voucher; the entry merging method supports merging multiple entries of the same subject into one entry.

[0029] Furthermore, the voucher element matching of the voucher template is specifically as follows: if the fields configured for the entry in the template include both the fields of the document dimension and the fields of the detail dimension, or are all the fields of the detail dimension, the data of the detail dimension is used to match the entry during matching, and a circular matching is performed when there are multiple details; if the fields configured for the entry in the template are all the fields of the document dimension, the document dimension data is used to match the entry only once; there may be one entry in the template, and multiple entries are generated correspondingly after matching with multiple details; the fields configured for the entry in the template are not supported to come from different details.

[0030] Furthermore, in the voucher generation module, the minimum available voucher number is obtained through the double cache of the database, specifically: first obtain N minimum available voucher numbers from the database and store them in cache A and cache B; obtain the minimum voucher number from A each time a new voucher is added, and then remove the voucher number from A; if the voucher number eventually successfully generates a voucher, the voucher number is removed from B; if the voucher number is eventually temporarily stored or not saved, and the voucher is not actually generated, the voucher number continues to be retained in B; if all the voucher numbers in A are removed, the remaining voucher numbers in B are added to A, and N minimum available voucher numbers are obtained from the database again and stored in A and B, thereby solving the deadlock and excessive voucher number jumping problems caused by low efficiency in obtaining voucher numbers during concurrency.

[0031] Furthermore, in the voucher generation module, for documents that require invoicing, it supports associating the invoice with the product detail dimension of the document. By selecting the document product and obtaining the invoice details of the product in the invoice list through the product name, the invoice association is written off after filling in the quantity of the product to be written off. The invoice write-off amount is the unit price on the invoice multiplied by the quantity of the product, and the invoiced amount of the product details is the unit price of the product details multiplied by the quantity of the product. This solves the problem of manually adjusting the voucher when the invoice unit price is inconsistent with the product unit price.

[0032] Another aspect of the present invention provides a processing method of a supply chain financial business-finance integrated processing system, the method comprising the following steps:

[0033] S1: The user initiates a business request through the supply chain perception system, which is reviewed by the supply chain management company and then forwarded to the purchase, sales and inventory management system;

[0034] S2: The purchase, sales and inventory management system receives the business request and generates a business document. After the document is reviewed and approved, it sends a document generation request to the accounting platform.

[0035] S3: The accounting platform queries the automatic voucher switch status according to the document type in the voucher generation request. If the switch is on, step S4 is automatically executed. Otherwise, the voucher needs to be generated manually.

[0036] S4: The accounting platform obtains the required business data according to the document type and document primary key of the voucher generation request, matches the voucher template corresponding to the document type according to the template applicable conditions, and obtains the voucher element configuration fields in the voucher template;

[0037] S5: Obtain the data required for voucher generation according to the voucher element configuration fields and the queried business document information, and perform financial verification on the voucher data. If it passes, an accounting voucher is generated;

[0038] S6: Update the corresponding voucher-related fields based on the business document primary key to achieve business and financial integration.

[0039] Compared with the prior art, the beneficial effects of the present invention include:

[0040] 1. The present invention supports the integration of business and finance by automatically generating vouchers through voucher template configuration according to the business characteristics of supply chain finance and the requirements of accounting standards. It is particularly suitable for the integration of business and finance in supply chain finance systems with flexible and complex business scenarios.

[0041] 2. According to the characteristics of business data and accounting requirements, the present invention maintains a Chinese-English comparison table of business document fields for configuring voucher templates, thereby releasing the coupling relationship between the financial and business systems, and can quickly realize the business-finance integration of different supply chain financial systems with minimal intrusion into the business system.

[0042] 3. The present invention automatically obtains various original voucher attachments for voucher archiving for the accounting platform according to the attachment source and attachment type configured in the voucher template, such as bank customer electronic receipts, contract attachments of original documents, etc., thereby greatly improving financial work efficiency and realizing digital financial management.

[0043] 4. The present invention supports the invoicing and cancellation of document commodity details in supply chain finance, and solves the problem of manual accounting adjustment of accounting vouchers when the document amount is inconsistent with the invoice amount due to inconsistency between the commodity document and the invoice document. BRIEF DESCRIPTION OF THE DRAWINGS

[0044] Figure 1 A block diagram of the supply chain financial business and financial integration processing system provided by the embodiment of the present invention;

[0045] Figure 2 A supply chain finance relationship diagram of a bank's procurement financing model provided in an embodiment of the present invention. DETAILED DESCRIPTION

[0046] In order to better understand the technical solution of the present application, the embodiments of the present application are described in detail below in conjunction with the accompanying drawings. It should be clear that the described embodiments are only part of the embodiments of the present application, rather than all of the embodiments. Based on the embodiments in the present application, all other embodiments obtained by ordinary technicians in this field without making creative work are within the scope of protection of this application.

[0047] The terms used in the embodiments of the present application are only for the purpose of describing specific embodiments, and are not intended to limit the present application. The singular forms "a", "said" and "the" used in the embodiments of the present application and the appended claims are also intended to include plural forms, unless the context clearly indicates other meanings.

[0048] The present invention provides a supply chain financial business and financial integrated processing system, including a supply chain platform and an accounting platform;

[0049] (1) Supply chain platform, including supply chain perception system and purchase, sales and inventory management system;

[0050] The supply chain perception system: users initiate business requests, which are reviewed by the supply chain management company and then forwarded to the purchase, sales and inventory management system;

[0051] The purchase, sales and inventory management system receives business requests and generates business documents. After the request is reviewed and approved, it initiates a document generation request to the accounting platform. The document generation request includes the document type and the document primary key.

[0052] (2) Accounting platform, including Chinese-English comparison table of document fields, automatic voucher switch, voucher template, voucher generation module and business-finance association module;

[0053] (2.1) The Chinese-English comparison table of document fields is used to translate and map the English fields of business data obtained through the document primary key query into Chinese fields with business common sense. The Chinese fields are used to configure the voucher template information, such as whether it is used for summary, amount or applicable conditions.

[0054] (2.2) The automatic voucher switch: for different document types, the on or off state is configured to control whether to call the voucher template to automatically generate the voucher after receiving the voucher generation request.

[0055] (2.3) The voucher template: includes template application conditions and voucher elements; the voucher elements include accounting entries, voucher influencing factors, comparison tables and attachments; the accounting entries include accounts or account classifications, summaries, amounts, and auxiliary accounting;

[0056] The template applicable conditions: for business documents of the same document type but different business logic, different voucher templates are set with fields reflecting different business logic as applicable conditions to meet the flexible requirements of different business scenarios requiring different accounting vouchers; after matching the voucher template that meets the applicable conditions, the voucher element configuration information corresponding to the voucher template is obtained;

[0057] The subjects can be directly configured as fixed subjects, or they can be configured as subject classifications according to voucher influencing factors;

[0058] The voucher influencing factor is the document field that affects the account entry;

[0059] The subject classification is a set of subject data confirmed according to the voucher influencing factor, comparison table and default subject;

[0060] The comparison table is the correspondence between the specific values ​​of the voucher influencing factors and the fixed accounts; a default account can be configured in the comparison table. If the specific value of the document field is not configured in the comparison table, or the fixed account is not matched in the comparison table, the default account is used;

[0061] The attachment includes two elements: the source of the attachment and the type of the attachment. The original attachment of the voucher is obtained from the business document according to the source and type for voucher review and archiving.

[0062] Specifically, the voucher template may also be configured with a voucher aggregation method and an entry merging method; the voucher aggregation method supports aggregating multiple business document data to generate one voucher; the entry merging method supports merging multiple entries of the same subject into one entry.

[0063] Specifically, the voucher element matching of the voucher template is as follows: if the fields configured for the entry in the template include both the fields of the document dimension and the fields of the detail dimension, or are all the fields of the detail dimension, the data of the detail dimension is used to match the entry during matching, and a circular matching is performed when there are multiple details; if the fields configured for the entry in the template are all the fields of the document dimension, the document dimension data is used to match the entry only once; there may be one entry in the template, and multiple entries are generated correspondingly after matching with multiple details; the fields configured for the entry in the template are not supported to come from different details.

[0064] (2.4) The voucher generation module: obtains the data required for voucher generation according to the voucher element configuration fields in the voucher template and the queried business document information, and performs financial verification on the voucher data to generate an accounting voucher; if the business document matches multiple voucher templates, the voucher elements corresponding to each voucher template are obtained in a loop, and multiple accounting vouchers are generated.

[0065] Specifically, the following financial verification methods can be used: verify whether the total amount of debits and credits is balanced, and verify whether the auxiliary accounting value of the account exists in the corresponding file dictionary.

[0066] Specifically, in the voucher generation module, for documents that require invoicing, it supports associating the invoice with the product detail dimension of the document. By selecting the document product and obtaining the invoice details of the product in the invoice list through the product name, the invoice association is written off after filling in the quantity of goods to be written off. The invoice write-off amount is the unit price on the invoice multiplied by the quantity of goods, and the invoiced amount of the product details is the unit price of the product details multiplied by the quantity of goods. This solves the problem of manually adjusting the voucher when the invoice unit price is inconsistent with the product unit price.

[0067] (2.5) The business-finance association module: updates the voucher association fields of the business document according to the primary key of the business document, thereby realizing the mutual query of business-finance data.

[0068] In one embodiment, the supply chain finance and business-finance integrated processing system provided by the present invention also includes a voucher generation interface, which, after receiving a voucher generation request, calls a voucher template to generate an accounting voucher according to the state of an automatic voucher switch.

[0069] In one embodiment, the supply chain finance and business-finance integrated processing system provided by the present invention also includes linkage with financial institutions; for payment and collection businesses with active accounts, the active account flow and receipt of the financial institution are obtained according to the enterprise account number as attachments to the payment and collection documents, and according to the attachment source and attachment type configured in the template, when the voucher is generated, the attachment of the payment and collection document is used as an attachment to the voucher.

[0070] In one embodiment, the supply chain finance business-finance integrated processing system provided by the present invention also includes a manual voucher module, which is used to manually trigger the generation of vouchers for business documents for which vouchers have not been generated when the automatic voucher switch is turned off.

[0071] The present invention also provides a processing method of the above supply chain financial business and financial integration processing system, such as Figure 1 As shown, the method comprises the following steps:

[0072] S1: The user initiates a business request through the supply chain perception system, which is reviewed by the supply chain management company and then forwarded to the purchase, sales and inventory management system;

[0073] S2: The purchase, sales and inventory management system receives the business request and generates a business document. After the document is reviewed and approved, it sends a document generation request to the accounting platform.

[0074] S3: The accounting platform queries the automatic voucher switch status according to the document type in the voucher generation request. If the switch is on, step S4 is automatically executed. Otherwise, the voucher needs to be generated manually.

[0075] S4: The accounting platform obtains the required business data according to the document type and document primary key of the voucher generation request, matches the voucher template corresponding to the document type according to the template applicable conditions, and obtains the voucher element configuration fields in the voucher template;

[0076] S5: Obtain the data required for voucher generation according to the voucher element configuration fields and the queried business document information, and perform financial verification on the voucher data. If it passes, an accounting voucher is generated;

[0077] S6: Update the corresponding voucher-related fields based on the business document primary key to achieve business and financial integration.

[0078] The specific implementation scheme of the present invention is further described below in conjunction with the procurement financing business process in a bank's supply chain financial service. Figure 2 shown.

[0079] The supplier initiates a procurement application in the enterprise banking platform. After being reviewed by the business personnel of the supply chain management company, the application information is forwarded to the procurement and sales system. The procurement and sales system receives the procurement application and automatically generates sales orders and purchase orders. At the same time, it generates the corresponding down payment, loan entrusted payment, payment for goods and other receivables / payables records for backup.

[0080] When the warehousing / outbound operation is completed, the business personnel enter the warehousing / outbound information in the Perception Enterprise Bank and push the information to the purchasing, sales and inventory backend to generate corresponding business documents such as purchase warehousing order / sales warehousing order, and automatically generate vouchers through the accounting platform during review.

[0081] The purchase, sales and inventory system automatically synchronizes bank flow information every day according to the account number configured in the bank platform system. Business personnel will make advance payment / advance payment slips from receivable / payable records and associate bank flow and receipt information, and automatically generate vouchers through the accounting platform after review.

[0082] The original documents that need to be recorded in the bank's procurement business include purchase receipts, sales delivery orders, advance payment orders, advance payment orders, receipts, payment orders, etc. In the bank's industrial chain financial service system, the integration of business and finance is mainly achieved by connecting the purchase, sales and inventory system to the accounting platform.

[0083] The accounting platform mainly includes six parts: Chinese-English comparison table of document fields, automatic voucher switch, manual voucher module, voucher template, voucher generation module and business-finance association module.

[0084] The Chinese-English comparison table of document fields maintains the archive information of each field, and whether it can be used as the configuration attribute of each voucher element, which is the basic function of the entire accounting platform. The main field names and field usage descriptions of this table are shown in Table 1. For business documents that realize business and financial integration, it is necessary to first maintain the Chinese-English comparison table of document fields, and then configure the voucher template with the Chinese name of the field according to the field attributes maintained in the comparison table. The template table in the database saves the English name corresponding to the Chinese field name. When matching the voucher, the system obtains the specific value from the data returned by the document query according to the template English name. According to the field type returned by each business document query service, the field maintenance includes document dimension fields and detail dimension fields. Document dimension information, such as the document number, creation date, supplier, customer, etc. of the purchase warehouse receipt, and detail dimension information, such as the detailed data returned together with the purchase warehouse receipt, such as the product name, unit price, and product specifications of the product details. When configuring the voucher template, the elements that need to be configured are determined according to the attributes of the table fields. The applicable conditions, influencing factors and auxiliary accounting fields that can be configured as non-numeric types should be maintained with data dictionary codes to support querying of available data sets through data archive codes.

[0085] Table 1 Document fields Chinese and English comparison table Main fields

[0086]

[0087]

[0088] The automatic voucher switch is used to control whether accounting vouchers are automatically generated after the business document review is completed. If the switch is turned off, you need to query the document data in the manual voucher module and click to trigger the generation of accounting vouchers.

[0089] The voucher template configures the template trial conditions and voucher elements, etc. The voucher elements include accounting date, voucher attachments, voucher influencing factors, comparison tables and accounting entries, etc. Accounting entries include accounts or account classifications, summaries, amounts and auxiliary accounting, etc. In addition, according to business needs, it is possible to set whether to generate vouchers based on document summaries, whether to merge the same accounts, and the order rules for displaying each voucher entry.

[0090] Specifically, the system matches the corresponding voucher template according to the document type, and further filters it according to the applicable conditions of the template. The trial conditions in the template are used to match different templates and generate different vouchers for the same business document under different business logic and processes. The trial conditions are document dimensions, and the document dimension fields can be maintained instead of the detail dimension fields.

[0091] If the fields configured for an entry in the template include both document dimension fields and detail dimension fields, or both are detail dimension fields, the detail dimension data is used to match the entry during matching, and the details are matched cyclically when there are multiple entries; if the fields configured for the entry in the template are all document dimension fields, the document dimension data is used to match the entry only once. It may happen that one entry in the template generates multiple voucher entries after matching with multiple details. If the account entry of a business document cannot be determined directly, but needs to be determined based on the value of a certain field or several fields of the business, the account classification needs to be set. The fields that affect the account entry are set as influencing factors, and the corresponding relationship between the specific values ​​of the influencing factors and the account entry is maintained as a comparison table. When matching entries, the system queries the comparison table based on the value of the influencing factors to determine the account entry. If no data is found in the comparison table, the default account is used; if the account classification is not configured with a default account, the entry fails to match.

[0092] Specifically, for entries configured with auxiliary accounting, when obtaining a specific account based on the voucher elements in the template, it is necessary to determine whether this type of auxiliary accounting is enabled for the account. If not, voucher generation fails.

[0093] Merge the entries of the same account in the voucher according to the entry merge option. You can choose not to merge, allow merging with the same summary and the same debit and credit direction, and allow merging with the same debit and credit direction; allow merging with different debit and credit directions, and the entry direction is recorded in the larger debit and credit amount. Depending on the summary method, control whether to merge multiple vouchers of the same document to generate one voucher. When generating by document summary, each document first matches the template and verifies the voucher data. The verification method is the same as when generating by order, and the consolidation and summary are only performed before the final insertion into the voucher database.

[0094] Specifically, the attachment source and attachment type are configured in the voucher template. The attachment source is the field in the document field where the attachment can be queried, which is used to bind the found attachment to the generated voucher for voucher review and archiving, such as the bank electronic receipt of general account flow, sales contract, etc.

[0095] The voucher number acquisition adopts double database cache to solve the deadlock and excessive voucher number jump problems caused by low efficiency of voucher number acquisition during concurrency. First, obtain N minimum available voucher numbers from the database and store them in cache A and cache B; obtain the minimum voucher number from A each time a new voucher is added, and then remove the voucher number from A; if the voucher number is finally successfully generated, the voucher number is removed from B; if the voucher number is finally temporarily stored or not saved, and the voucher is not actually generated, the voucher number continues to be retained in B; if all voucher numbers in A are removed, the remaining voucher numbers in B are added to A, and N minimum available voucher numbers are obtained from the database again and stored in A and B. The number of voucher numbers N obtained each time can be configured through parameters to flexibly handle voucher number jumps and system efficiency issues.

[0096] Specifically, import the input or output invoice through the invoice import function, and call the Baiwang invoice recognition interface to obtain the product name, quantity, unit price and other information of the invoice details. For documents such as purchase warehouse receipts and sales warehouse delivery orders that have product details and need to issue invoices or cancel invoices, obtain the product name corresponding to the tax code table according to the tax code of the product in the document, and then query the product in the invoice details according to the product name, perform quantity cancellation, and generate a financial voucher for invoice cancellation. Since the voucher for invoice cancellation can use the unit price and quantity in the invoice details, the document cancellation amount is the unit price of the product in the document multiplied by the cancellation quantity, and the invoice cancellation amount is the unit price in the invoice multiplied by the cancellation quantity. This solves the problem of inconsistent total amounts caused by the inconsistency between the unit price of the product in the warehouse receipt and the actual unit price of the invoice product, and avoids the need to manually adjust the voucher due to different amounts.

[0097] Specifically, after obtaining the corresponding data of the voucher according to the voucher template and document data, the voucher verification is performed on the debit and credit amounts of the voucher entries, the account entries and the auxiliary accounting. When the voucher does not meet the requirements of the accounting voucher specifications, the voucher generation fails. The voucher template needs to be adjusted according to the specific situation, and then the voucher is generated through the manual voucher generation module.

[0098] The above description is merely a preferred embodiment of one or more embodiments of the present specification and is not intended to limit one or more embodiments of the present specification. Any modifications, equivalent substitutions, improvements, etc. made within the spirit and principles of one or more embodiments of the present specification shall be included in the scope of protection of one or more embodiments of the present specification.

Claims

1. A supply chain financial business and financial integration processing system, characterized in that: Including supply chain platform and accounting platform; (1) Supply chain platform, including supply chain perception system and purchase, sales and inventory management system; The supply chain perception system: users initiate business requests, which are reviewed by the supply chain management company and then forwarded to the purchase, sales and inventory management system; The purchase, sales and inventory management system: receives business requests and generates business documents, and after review and approval, initiates a document generation request to the accounting platform; the document generation request includes the document type and document primary key; (2) Accounting platform, including Chinese-English comparison table of document fields, automatic voucher switch, voucher template, voucher generation module and business-finance association module; (2.1) The English-Chinese comparison table of document fields: used to translate and map the English fields of business data obtained through the document primary key query into Chinese fields with business common sense, and the Chinese fields are used to configure the voucher template information; (2.2) The automatic voucher switch: for different document types, the on or off state is configured to control whether to call the voucher template to automatically generate the voucher after receiving the voucher generation request; (2.3) The voucher template: includes template application conditions and voucher elements; the voucher elements include accounting entries, voucher influencing factors, comparison tables and attachments; the accounting entries include accounts or account classifications, summaries, amounts, and auxiliary accounting; The template applicable conditions: for business documents of the same document type but different business logic, different voucher templates are set with fields reflecting different business logic as applicable conditions to meet the flexible requirements of different business scenarios requiring different accounting vouchers; after matching the voucher template that meets the applicable conditions, the voucher element configuration information corresponding to the voucher template is obtained; The subjects can be directly configured as fixed subjects, or they can be configured as subject classifications according to voucher influencing factors; The voucher influencing factor is the document field that affects the account entry; The subject classification is a set of subject data confirmed according to the voucher influencing factor, comparison table and default subject; The comparison table is the correspondence between the specific values ​​of the voucher impact factors and the fixed subjects; The attachment includes two elements: the source of the attachment and the type of the attachment. The original attachment of the voucher is obtained from the business document according to the source and type for voucher review and archiving; (2.4) The voucher generation module: obtains the data required for voucher generation according to the voucher element configuration fields in the voucher template and the queried business document information, and performs financial verification on the voucher data to generate an accounting voucher after passing the verification; (2.5) The business-finance association module: updates the voucher association fields of the business document according to the primary key of the business document, thereby realizing the mutual query of business-finance data.

2. A supply chain financial business and financial integration processing system according to claim 1, characterized in that: The default account is configured in the comparison table. If the specific value of the document field is not configured in the comparison table, or if no fixed account is matched in the comparison table, the default account is used.

3. The supply chain financial business and financial integrated processing system according to claim 1 is characterized in that: In the voucher generation module, the financial verification specifically includes: verifying whether the total amount of debits and credits is balanced, and verifying whether the auxiliary accounting value of the subject exists in the corresponding file dictionary.

4. The supply chain financial business and financial integration processing system according to claim 1 is characterized in that: The processing system also includes a voucher generation interface, which, after receiving a voucher generation request, calls a voucher template to generate an accounting voucher according to the state of an automatic voucher switch; The processing system also includes linkage with financial institutions: for payment and collection businesses with active accounts, the active account flow and receipt of the financial institution are obtained according to the enterprise account number as attachments to the payment and collection documents; according to the attachment source and attachment type configured in the template, when the voucher is generated, the attachment of the payment and collection document is used as an attachment to the voucher.

5. The supply chain financial business and financial integration processing system according to claim 1 is characterized in that: The processing system also includes a manual voucher module, which is used to manually trigger the generation of vouchers for business documents that have not generated vouchers when the automatic voucher switch is turned off.

6. The supply chain financial business and financial integrated processing system according to claim 1 is characterized in that: The voucher template is also configured with a voucher aggregation method and an entry merging method; the voucher aggregation method supports aggregating multiple business document data to generate one voucher; the entry merging method supports merging multiple entries of the same subject into one entry.

7. The supply chain financial business and financial integration processing system according to claim 1 is characterized in that: The voucher element matching of the voucher template is specifically as follows: if the fields configured in the entry in the template include both the fields of the document dimension and the fields of the detail dimension, or are all the fields of the detail dimension, the data of the detail dimension is used to match the entry during matching, and a circular matching is performed when there are multiple details; if the fields configured in the entry in the template are all the fields of the document dimension, the document dimension data is used to match the entry only once; there may be one entry in the template, and multiple entries are generated correspondingly after matching with multiple details; the fields configured in the entry in the template are not supported to come from different details.

8. The supply chain financial business and financial integration processing system according to claim 1 is characterized in that: In the voucher generation module, the minimum available voucher number is obtained through the database double cache, specifically: first obtain N minimum available voucher numbers from the database and store them in cache A and cache B; obtain the minimum voucher number from A each time a new voucher is added, and then remove the voucher number from A; if the voucher number is finally successfully generated, the voucher number is removed from B; if the voucher number is finally temporarily stored or not saved, and the voucher is not actually generated, the voucher number continues to be retained in B; if all the voucher numbers in A are removed, the remaining voucher numbers in B are added to A, and the N minimum available voucher numbers are obtained from the database again and stored in A and B.

9. The supply chain financial business and financial integration processing system according to claim 1 is characterized in that: In the voucher generation module, for documents with invoice issuance requirements, it supports associating the invoice with the product detail dimension of the document. By selecting the document product and obtaining the invoice details of the product in the invoice list through the product name, the invoice association is written off after filling in the quantity of the product to be written off. The invoice write-off amount is the unit price on the invoice multiplied by the product quantity, and the invoiced amount of the product details is the unit price of the product details multiplied by the product quantity.

10. A supply chain financial business and financial integration processing method based on the system according to any one of claims 1 to 9, characterized in that: The method comprises the following steps: S1: The user initiates a business request through the supply chain perception system, which is reviewed by the supply chain management company and then forwarded to the purchase, sales and inventory management system; S2: The purchase, sales and inventory management system receives the business request and generates a business document. After the document is reviewed and approved, it sends a document generation request to the accounting platform. S3: The accounting platform queries the automatic voucher switch status according to the document type in the voucher generation request. If the switch is on, step S4 is automatically executed. Otherwise, the voucher needs to be generated manually. S4: The accounting platform obtains the required business data according to the document type and document primary key of the voucher generation request, matches the voucher template corresponding to the document type according to the template applicable conditions, and obtains the voucher element configuration fields in the voucher template; S5: Obtain the data required for voucher generation according to the voucher element configuration fields and the queried business document information, and perform financial verification on the voucher data. If it passes, an accounting voucher is generated; S6: Update the corresponding voucher-related fields based on the business document primary key to achieve business and financial integration.

Images