CN113888298A - Supply chain financial industry and finance integrated processing system and method - Google Patents

Supply chain financial industry and finance integrated processing system and method Download PDF

Info

Publication number
CN113888298A
CN113888298A CN202111150914.2A CN202111150914A CN113888298A CN 113888298 A CN113888298 A CN 113888298A CN 202111150914 A CN202111150914 A CN 202111150914A CN 113888298 A CN113888298 A CN 113888298A
Authority
CN
China
Prior art keywords
voucher
document
business
financial
template
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN202111150914.2A
Other languages
Chinese (zh)
Inventor
谈维棋
李慕华
李全军
陈健
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
China Zheshang Bank Co Ltd
Original Assignee
China Zheshang Bank Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by China Zheshang Bank Co Ltd filed Critical China Zheshang Bank Co Ltd
Priority to CN202111150914.2A priority Critical patent/CN113888298A/en
Publication of CN113888298A publication Critical patent/CN113888298A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q40/00Finance; Insurance; Tax strategies; Processing of corporate or income taxes
    • G06Q40/12Accounting
    • G06Q40/125Finance or payroll

Landscapes

  • Business, Economics & Management (AREA)
  • Accounting & Taxation (AREA)
  • Finance (AREA)
  • Engineering & Computer Science (AREA)
  • Development Economics (AREA)
  • Economics (AREA)
  • Marketing (AREA)
  • Strategic Management (AREA)
  • Technology Law (AREA)
  • Physics & Mathematics (AREA)
  • General Business, Economics & Management (AREA)
  • General Physics & Mathematics (AREA)
  • Theoretical Computer Science (AREA)
  • Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)

Abstract

The invention discloses a supply chain financial industry and property integrated processing system and method. The scheme can adopt a micro-service deployment mode, the supply chain financial system is docked through simple secondary development and document field Chinese and English comparison table data maintenance, financial and business data are fused, meanwhile, the coupling of finance and business is removed, and the relative independence of the financial and business data is kept. According to the method, after supply chain financial business occurs, corresponding voucher entries in the templates are matched according to business data and the configured voucher templates, and accounting vouchers are generated. The invention automatically acquires the original accessories required by the voucher filing, effectively improves the financial working efficiency and realizes the financial digital management. According to flexible template configuration, different business logic scenes are supported to realize business and financial integration, the method is suitable for a supply chain system with flexible business change to realize business and financial integration, and the problem of excessive constraint of financial on business is solved.

Description

Supply chain financial industry and finance integrated processing system and method
Technical Field
The invention belongs to the field of information processing, and particularly relates to a supply chain financial industry and property integrated processing system and method.
Background
The digital transformation and the transformation are becoming new directions of global economy and are core power for promoting the development of economic society of China. With the rapid development of informatization, enterprises begin to utilize digitization transformation to enable management and management, the financial management of a great deal of enterprises selects the development direction of more intellectualization and informatization, the pace of financial fusion innovation is accelerated, the operation cost is reduced, basic financial work is liberated, the transformation and upgrade of financial accounting to management accounting are accelerated, and the decision basis of a leader is enhanced.
Along with the popularization of the internet technology, supply chain finance brought out by financial institutions such as banks aiming at the characteristics of medium and small enterprises obtains better social and economic benefits, and the problems of credit increase, limited marketing, fund and the like of the medium and small enterprises are solved. The business operation mode of supply chain finance also presents a diversified trend, taking the most common core enterprise as the dominant business mode as an example, the main business and the strong degree of the core enterprise are different, and the core enterprise can correspond to different business processes and logics, thereby causing great challenges for realizing the integration of business and finance. At present, most supply chain financial systems only pay attention to self business logic, and when the supply chain financial systems are in butt joint with a financial system of a third party, a data interaction mode of importing and exporting needs to be adopted, complex manual processing such as data format conversion needs to be carried out in the process, and the working efficiency and the accuracy of data are seriously influenced; or although the common financial software integrates the business and financial functions, the business processing logic of the common financial software cannot completely meet the requirements of the supply chain financial services, and the enterprise secondary development has strong dependence on a third party and higher cost.
Disclosure of Invention
The invention aims to provide a reference scheme for realizing the integration of industry and finance in the finance of a supply chain and solve the problems that the business and the finance are independent and cannot be fused. And automatically recording and generating accounting documents meeting financial requirements according to the business data and the configured voucher template, and acquiring the attachment information required by voucher filing.
The purpose of the invention is realized by the following technical scheme:
the invention provides a supply chain financial industry and property integrated processing system on one hand, which comprises a supply chain platform and an accounting platform;
(1) the supply chain platform comprises a supply chain sensing system and a purchase, sale and storage system;
the supply chain awareness system: a user initiates a service request, and the service request is transmitted to a purchase, sale and storage system after being audited by a supply chain management company;
the purchase, sale and storage system comprises: receiving a service request and generating a service document, and initiating a voucher generation request to an accounting platform after the audit is passed; the voucher generation request comprises a voucher type and a voucher master key;
(2) the accounting platform comprises a document field Chinese and English comparison table, an automatic voucher switch, a voucher template, a voucher generation module and a property association module;
(2.1) the document field Chinese and English comparison table: the document processing system is used for translating and mapping English fields of business data acquired through document main key query into Chinese fields with business identification degrees, and the Chinese fields are used for configuring credential template information;
(2.2) the automatic credential switch: configuring an open state or a close state for different document types, and controlling whether to call a document template to automatically generate a document after receiving a document generation request;
(2.3) the credential template: including template applicable conditions and credential elements; the voucher elements comprise accounting entries, voucher influence factors, comparison tables and accessories; the accounting entry comprises subjects or subject classification, abstract, amount and auxiliary accounting;
the applicable conditions of the template are as follows: aiming at the business documents of the same document type but different business logics, setting different voucher templates by taking fields reflecting different business logics as applicable conditions, wherein the different voucher templates are used for meeting the flexible requirements of different business scenes for recording different accounting vouchers; after the certificate templates meeting the applicable conditions are matched, obtaining certificate element configuration information corresponding to the certificate templates;
the subjects can be directly configured as fixed subjects, and can also be configured as subject classification according to the voucher influence factor;
the voucher influence factor is a document field influencing the entry item;
the subject classification is a group of subject data confirmed according to the voucher influence factor, the comparison table and the default subject;
the comparison table is the corresponding relation between the specific value of the voucher influence factor and the fixed subject;
the attachment comprises two elements of an attachment source and an attachment type, and the original attachment of the certificate is obtained from the business document according to the source and the type and is used for verifying and filing the certificate;
(2.4) the credential generation module: acquiring the required data for generating the voucher according to the voucher element configuration field in the voucher template and the inquired business document information, performing financial verification on the voucher data, and forming an accounting voucher after the financial verification is passed;
(2.5) the property association module: and updating the certificate associated field of the business document according to the main key of the business document, and realizing mutual joint check of the business and financial data.
Further, a default subject is configured in the comparison table, and if the specific value of the document field is not configured in the comparison table or is not matched with the fixed subject in the comparison table, the default subject is selected.
Further, if the business document is matched with the plurality of voucher templates, the voucher elements corresponding to each voucher template are circularly acquired, and a plurality of accounting vouchers are generated.
Further, in the credential generating module, the financial verification specifically includes: checking whether the total sum of the lender is balanced, and checking whether the subject auxiliary check value exists in the corresponding file dictionary.
Furthermore, the processing system also comprises a voucher generation interface, and the voucher generation interface calls a voucher template to generate the accounting voucher according to the state of an automatic voucher switch after receiving the voucher generation request.
Further, the processing system further comprises a linkage with the financial institution; for the receipt and payment service with the dynamic account, the dynamic account flow and the receipt of the financial institution are obtained according to the enterprise account number and are used as the attachment of the receipt and payment document, and the attachment of the receipt and payment document is used as the attachment of the voucher when the voucher is generated according to the attachment source and the attachment type configured by the template.
Furthermore, the processing system also comprises a manual voucher module which is used for manually triggering the business document without generating the voucher to generate the voucher under the closing state of the automatic voucher switch.
Furthermore, a voucher summarizing mode and an entry and entry merging mode are also configured in the voucher template; the voucher summarizing mode supports a plurality of business document data to summarize to generate a voucher; the entry merging mode supports merging of multiple entries of the same subject into one entry.
Further, the matching of the certificate elements of the certificate template specifically includes: if the fields configured in the records in the template have document dimension fields and detail dimension fields, or detail dimension fields, matching the entry by using detail dimension data during matching, and circularly matching when a plurality of details exist; if all fields configured in the entry in the template are document dimension fields, matching the entry only once by using document dimension data; one entry in the template may appear, and a plurality of entries are correspondingly generated after a plurality of details are matched; fields that do not support entry configuration in the template are derived from different details.
Further, in the credential generating module, the minimum available credential number is obtained through the database double cache, which specifically includes: firstly, N minimum available certificate numbers are obtained from a database and stored in a cache A and a cache B; acquiring a minimum certificate number from A each time a certificate is newly added, and then removing the certificate number from A; if the voucher number is finally successfully generated into a voucher, removing the voucher number from B; if the certificate number is finally temporarily stored or not stored and the certificate is not actually generated, the certificate number is continuously reserved in the step B; if the voucher numbers in the A are all removed, the rest voucher numbers in the B are added into the A, N minimum available voucher numbers are obtained from the database again and stored in the A and the B, and the problems of deadlock and excessive number skipping of the voucher numbers caused by low voucher number obtaining efficiency in the concurrent process are solved.
Furthermore, in the voucher generation module, for a voucher with an invoicing requirement, a commodity detail dimension for associating an invoice to the voucher is supported, invoice details of the commodity in an invoice list are obtained through selecting a voucher commodity, invoice quantity of the commodity to be checked is filled, invoice association checking is carried out, checking and canceling amount of the invoice is the product price on the invoice multiplied by the commodity quantity, invoicing amount of the commodity details is the product price multiplied by the product quantity of the commodity details, and the problem that the voucher needs to be manually adjusted when the invoice product price is inconsistent with the commodity product price is solved.
The invention also provides a processing method of the supply chain financial integrated processing system, which comprises the following steps:
s1: a user initiates a service request through a supply chain sensing system, and the service request is transmitted to a purchase, sale and storage system after being audited by a supply chain management company;
s2: the purchase, sales and inventory system receives the business request and generates a business document, and after the business request is approved, a voucher generation request is initiated to the accounting platform;
s3: the accounting platform inquires the automatic voucher switch state according to the receipt type in the voucher generation request, if the switch is in the open state, the step S4 is automatically executed, otherwise, the voucher is manually generated;
s4: the accounting platform acquires required business data according to the document type and the document main key of the document generation request, and acquires a document element configuration field in the document template by matching the document template corresponding to the document type according to the template application condition;
s5: acquiring the required data generated by the voucher according to the voucher element configuration field and the inquired business document information, performing financial verification on the voucher data, and forming an accounting voucher after the required data passes the financial verification;
s6: and updating the corresponding certificate associated field according to the main key of the business document to realize the integration of business and property.
Compared with the prior art, the invention has the beneficial effects that:
1. the invention supports the realization of the integration of industry and property by automatically generating the certificate through the certificate template configuration according to the supply chain financial service characteristics and the accounting criteria requirements, and is particularly suitable for the industry and property integration of a supply chain financial system with flexible and complex service scenes.
2. According to the invention, the Chinese and English comparison table of the business document field is maintained for configuring the voucher template according to the characteristics of the business data and the accounting and accounting requirements, so that the coupling relation between finance and a business system is eliminated, the integration of finance and accounting of financial systems of different supply chains can be quickly realized, and the immersion of the business system is small.
3. According to the accessory source and the accessory type configured by the voucher template, the invention automatically acquires various original voucher accessories for voucher filing, such as electronic receipt of bank customers, contract accessories of original receipt and the like, for the accounting platform, thereby greatly improving the working efficiency of finance and realizing the digital management of finance.
4. The invention supports the invoicing and the verification of the detail of the commodity in the supply chain finance, and solves the problem that manual account making and accounting document adjustment are needed when the bill amount is inconsistent with the invoice amount due to the inconsistency between the commodity bill and the invoice data in the bill.
Drawings
FIG. 1 is a block diagram of an implementation of a supply chain financial integrated processing system according to an embodiment of the present invention;
fig. 2 is a financial relationship diagram of a supply chain of a certain bank adopting a financing model according to an embodiment of the present invention.
Detailed Description
For better understanding of the technical solutions of the present application, the following detailed descriptions of the embodiments of the present application are provided with reference to the accompanying drawings. It should be understood that the embodiments described are only a few embodiments of the present application, and not all embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present application.
The terminology used in the embodiments of the present application is for the purpose of describing particular embodiments only and is not intended to be limiting of the application. As used in the examples of this application and the appended claims, the singular forms "a", "an", and "the" are intended to include the plural forms as well, unless the context clearly indicates otherwise.
The invention provides a supply chain financial industry and property integrated processing system, which comprises a supply chain platform and an accounting platform, wherein the supply chain platform is connected with the accounting platform through a network;
(1) the supply chain platform comprises a supply chain sensing system and a purchase, sale and storage system;
the supply chain awareness system: a user initiates a service request, and the service request is transmitted to a purchase, sale and storage system after being audited by a supply chain management company;
the purchase, sale and storage system comprises: receiving a service request and generating a service document, and initiating a voucher generation request to an accounting platform after the audit is passed; the voucher generation request comprises a voucher type and a voucher master key.
(2) The accounting platform comprises a document field Chinese and English comparison table, an automatic voucher switch, a voucher template, a voucher generation module and a property association module;
(2.1) the document field Chinese and English comparison table: the document processing system is used for translating and mapping English fields of business data acquired through document primary key query into Chinese fields with business identification degrees, and the Chinese fields are used for configuring credential template information, such as whether the document is used for abstract, amount or applicable conditions.
(2.2) the automatic credential switch: and configuring the opening or closing state for different bill types, and controlling whether to call a certificate template to automatically generate the certificate after receiving the certificate generation request.
(2.3) the credential template: including template applicable conditions and credential elements; the voucher elements comprise accounting entries, voucher influence factors, comparison tables and accessories; the accounting entry comprises subjects or subject classification, abstract, amount and auxiliary accounting;
the applicable conditions of the template are as follows: aiming at the business documents of the same document type but different business logics, setting different voucher templates by taking fields reflecting different business logics as applicable conditions, wherein the different voucher templates are used for meeting the flexible requirements of different business scenes for recording different accounting vouchers; after the certificate templates meeting the applicable conditions are matched, obtaining certificate element configuration information corresponding to the certificate templates;
the subjects can be directly configured as fixed subjects, and can also be configured as subject classification according to the voucher influence factor;
the voucher influence factor is a document field influencing the entry item;
the subject classification is a group of subject data confirmed according to the voucher influence factor, the comparison table and the default subject;
the comparison table is the corresponding relation between the specific value of the voucher influence factor and the fixed subject; default subjects can be configured in the comparison table, and if the specific value of the document field is not configured in the comparison table or is not matched with the fixed subject in the comparison table, the default subject is selected;
the attachment comprises two elements of an attachment source and an attachment type, and the original attachment of the certificate is obtained from the business document according to the source and the type and is used for verifying and filing the certificate.
Specifically, the voucher template can be configured with a voucher summarizing mode and an entry merging mode; the voucher summarizing mode supports a plurality of business document data to summarize to generate a voucher; the entry merging mode supports merging of multiple entries of the same subject into one entry.
Specifically, the matching of the credential elements of the credential template specifically includes: if the fields configured in the records in the template have document dimension fields and detail dimension fields, or detail dimension fields, matching the entry by using detail dimension data during matching, and circularly matching when a plurality of details exist; if all fields configured in the entry in the template are document dimension fields, matching the entry only once by using document dimension data; one entry in the template may appear, and a plurality of entries are correspondingly generated after a plurality of details are matched; fields that do not support entry configuration in the template are derived from different details.
(2.4) the credential generation module: acquiring the required data for generating the voucher according to the voucher element configuration field in the voucher template and the inquired business document information, performing financial verification on the voucher data, and forming an accounting voucher after the financial verification is passed; and if the business document is matched with the plurality of voucher templates, circularly acquiring the voucher elements corresponding to each voucher template and generating a plurality of accounting vouchers.
Specifically, the following financial verification may be employed: checking whether the total sum of the lender is balanced, and checking whether the subject auxiliary check value exists in the corresponding file dictionary.
Specifically, in the voucher generation module, for a voucher with an invoicing requirement, a commodity detail dimension for associating an invoice to the voucher is supported, invoice details of the commodity in an invoice list are obtained through selecting a voucher commodity, invoice quantity of the commodity to be checked is filled, invoice association checking is carried out, checking and canceling amount of the invoice is the product price on the invoice multiplied by the commodity quantity, invoicing amount of the commodity details is the product price multiplied by the product quantity of the commodity details, and the problem that the voucher needs to be manually adjusted when the invoice product price is inconsistent with the commodity product price is solved.
(2.5) the property association module: and updating the certificate associated field of the business document according to the main key of the business document, and realizing mutual joint check of the business and financial data.
In one embodiment, the supply chain financial industry and property integrated processing system further comprises a voucher generation interface, and the voucher generation interface calls a voucher template to generate an accounting voucher according to the state of an automatic voucher switch after receiving a voucher generation request.
In one embodiment, the supply chain financial integrated processing system provided by the invention further comprises linkage with a financial institution; for the receipt and payment service with the dynamic account, the dynamic account flow and the receipt of the financial institution are obtained according to the enterprise account number and are used as the attachment of the receipt and payment document, and the attachment of the receipt and payment document is used as the attachment of the voucher when the voucher is generated according to the attachment source and the attachment type configured by the template.
In one embodiment, the supply chain financial integrated processing system further comprises a manual voucher module, wherein the manual voucher module is used for manually triggering business receipts without generating vouchers to generate vouchers under the state that the automatic voucher switch is closed.
The invention also provides a processing method of the supply chain financial integrated processing system, as shown in fig. 1, the method comprises the following steps:
s1: a user initiates a service request through a supply chain sensing system, and the service request is transmitted to a purchase, sale and storage system after being audited by a supply chain management company;
s2: the purchase, sales and inventory system receives the business request and generates a business document, and after the business request is approved, a voucher generation request is initiated to the accounting platform;
s3: the accounting platform inquires the automatic voucher switch state according to the receipt type in the voucher generation request, if the switch is in the open state, the step S4 is automatically executed, otherwise, the voucher is manually generated;
s4: the accounting platform acquires required business data according to the document type and the document main key of the document generation request, and acquires a document element configuration field in the document template by matching the document template corresponding to the document type according to the template application condition;
s5: acquiring the required data generated by the voucher according to the voucher element configuration field and the inquired business document information, performing financial verification on the voucher data, and forming an accounting voucher after the required data passes the financial verification;
s6: and updating the corresponding certificate associated field according to the main key of the business document to realize the integration of business and property.
The following further describes a specific embodiment of the present invention with reference to the process of collecting financing business in financial services of a certain bank supply chain, and the specific embodiment is shown in fig. 2.
The supplier senses that a collection application is initiated in the enterprise platform, after the application is audited by business personnel of a supply chain management company, the application information is forwarded to the purchase-sale-storage system, the purchase-sale-storage system receives the collection application and automatically generates a sales order and a purchase order, and simultaneously, receivable/payable records of initial payment, loan payment, payment and the like corresponding to the business are generated for later use.
After the warehousing/ex-warehouse operation is completed, business personnel input warehousing/ex-warehouse information in the perception bank, the information is pushed to the warehousing/sales back end, corresponding business documents such as purchasing warehousing documents/selling ex-warehouse documents are generated, and the documents are automatically generated through the accounting platform during auditing.
The purchase, sales and inventory system automatically synchronizes bank flow information every day according to the account number configured in the bank platform system. The business personnel will accept/pay the record and make the bank flow water and receipt information related to the pre-receiving/pre-paying bill, and automatically generate the voucher through the accounting platform after the audit.
The bank collection mode business generates original bills needing financial bookkeeping, such as purchase warehousing bills, sales delivery bills, pre-payment bills, payment bills and the like. In an industrial chain financial service system of a bank, an industry and a property are integrated by mainly butting an accounting platform through a purchase, sales and inventory system.
The accounting platform mainly comprises six parts, namely a document field Chinese and English comparison table, an automatic document switch, a manual document module, a document template, a document generation module and a business and property association module.
The document field Chinese and English comparison table maintains the file information of each field and whether the document field Chinese and English comparison table can be used as the configuration attribute of each element of the voucher, and the document field Chinese and English comparison table is the basic function of the whole accounting platform. The table is described in table 1 for the main field names and field usage. The business documents for realizing the integration of business and financial resources need to maintain a document field Chinese and English comparison table firstly, then a voucher template is configured by using a field Chinese name according to field attributes maintained in the comparison table, an English name corresponding to the Chinese field name is stored in a template table in a database, and a system acquires a specific value from data returned by document inquiry according to the template English name when the voucher is matched. And according to the field type returned by each business document query service, the field is maintained with a document dimension field and a detail dimension field. The document dimension information includes document numbers, creation dates, suppliers, customers and the like of the purchase warehousing documents, and the detail dimension information includes detail data returned from the purchase warehousing documents, such as commodity names, commodity unit prices, commodity specifications and the like of the commodity details. When the voucher template is configured, elements needing to be configured are determined according to the attributes of the table fields. Fields which can be configured into non-numerical type applicable conditions, influence factors and auxiliary accounting should be maintained with data dictionary coding, and support to search out alternative data sets through data archive coding.
TABLE 1 document fields Chinese and English reference table main fields
Figure BDA0003287034390000091
Figure BDA0003287034390000101
The automatic voucher switch is used for controlling whether to automatically generate an accounting voucher or not after the business document is checked and verified. If the switch is closed, the accounting document is generated by clicking and triggering after document data is inquired in the manual document module.
The voucher template is provided with template trial conditions, voucher elements and the like, wherein the voucher elements comprise accounting dates, voucher attachments, voucher influence factors, comparison tables, accounting entries and the like; the accounting entry comprises subjects or subject classification, abstract, amount, auxiliary accounting and the like. In addition, according to business needs, whether the voucher needs to be generated according to the bill summary or not during the generation of the voucher, whether the same subject needs to be combined or not, and the order rule of the entry display of the voucher and the like are set.
Specifically, the system matches a corresponding voucher template according to the type of the document, and further screens the document according to the applicable conditions of the template. The trial conditions in the templates are used for matching different templates and generating different certificates under different business logics and flows of the same business document. The trial condition is the document dimension, and the document dimension field can be maintained instead of the detail dimension field.
If the field configured by one entry in the template has both document dimension fields and detail dimension fields, or both detail dimension fields, matching the entry by using detail dimension data during matching, and circularly matching when a plurality of details exist; and if the fields configured in the records in the template are all fields of document dimensions, matching the records only once by using document dimension data. One entry in the template may appear, and a plurality of voucher entries are correspondingly generated after a plurality of details are matched. If the entry account of the business document can not be directly determined and needs to be determined according to the value of a certain field or a plurality of fields of the business, the account classification needs to be set. And setting the field influencing the account entry as an influence factor, and maintaining the corresponding relation between the specific value of the influence factor and the account entry as a comparison table. And when the entries are matched, the system queries the comparison table according to the values of the influence factors to determine the account entry. If the data is not inquired in the comparison table, taking a default subject; if the subject classification does not configure the default subject, the entry matching fails.
Specifically, when a specific subject is obtained according to the certificate element in the template, it is necessary to determine whether the subject starts the type of auxiliary accounting, and if not, the certificate generation fails.
Merging the entries of the same subjects in the certificate according to the entry merging option, and selecting the allowable merging in the same loan direction and the allowable merging in the same loan direction without merging and with the same abstract; the different directions of the debiting and the crediting allow the combination, and the direction of the record is recorded on the side with larger amount of money. And controlling whether to combine a plurality of vouchers of the same document to generate one voucher or not according to different gathering modes. When the documents are generated in a summary mode, the documents are matched with the templates respectively and the document data are verified, the verification mode is consistent with that of the document generation, and the documents are merged and summarized only before being finally inserted into the document database.
Specifically, the accessory source and the accessory type are configured in the credential template. The accessory source is a field capable of inquiring the accessory in the document field, and is used for binding the inquired accessory to the generated certificate to be used as certificate auditing and filing, such as bank electronic receipt and sale contract of general dynamic account flow.
The certificate number acquisition adopts database double-cache, and the problems of deadlock and excessive number skipping of the certificate number caused by low certificate number acquisition efficiency in concurrence are solved. Firstly, N minimum available certificate numbers are obtained from a database and stored in a cache A and a cache B; acquiring a minimum certificate number from A each time a certificate is newly added, and then removing the certificate number from A; if the voucher number is finally successfully generated into a voucher, removing the voucher number from B; if the certificate number is finally temporarily stored or not stored and the certificate is not actually generated, the certificate number is continuously reserved in the step B; if the certificate numbers in A are all removed, the rest certificate numbers in B are added into A, and N minimum available certificate numbers are obtained from the database again and stored into A and B. The number N of the acquired certificate numbers at each time can be configured through parameters so as to flexibly process the problems of certificate number skip and system efficiency.
Specifically, an incoming invoice or a sales invoice is imported through an invoice import function, and information such as commodity names, quantity and unit price of invoice details is acquired by calling a Baiwang invoice identification interface. And aiming at documents with commodity details requiring invoicing or invoice verification, such as purchase warehousing documents, sales delivery documents and the like, acquiring a commodity name corresponding to a tax code table according to the tax code of the document commodity, inquiring the commodity in the invoice details according to the commodity name, performing quantity verification and generating a financial certificate for the invoice verification and verification. The voucher for ticket checking and canceling can use the unit price and the quantity in the issuing detail, the amount of ticket checking and canceling is the product unit price in the voucher multiplied by the amount of canceling, the amount of canceling in the invoice is the product unit price in the invoice multiplied by the amount of canceling, the problem that the product unit price in the warehousing and delivery bill is inconsistent with the actual unit price of the invoice product to cause the inconsistent total amount is solved, and the fact that the voucher needs to be adjusted manually due to the different amount is avoided.
Specifically, after the corresponding data of the voucher is obtained according to the voucher template and the document data, the voucher is subjected to voucher verification on the voucher entry lending amount, the account entry subject and the auxiliary accounting, when the voucher does not meet the standard requirement of the accounting voucher, the voucher is failed to be generated, the voucher template needs to be adjusted according to specific conditions, and then the voucher is generated through a manual voucher generating module.
The above description is only for the purpose of illustrating the preferred embodiments of the one or more embodiments of the present disclosure, and is not intended to limit the scope of the one or more embodiments of the present disclosure, and any modifications, equivalent substitutions, improvements, etc. made within the spirit and principle of the one or more embodiments of the present disclosure should be included in the scope of the one or more embodiments of the present disclosure.

Claims (10)

1. A supply chain financial industry and property integrated processing system is characterized by comprising a supply chain platform and an accounting platform;
(1) the supply chain platform comprises a supply chain sensing system and a purchase, sale and storage system;
the supply chain awareness system: a user initiates a service request, and the service request is transmitted to a purchase, sale and storage system after being audited by a supply chain management company;
the purchase, sale and storage system comprises: receiving a service request and generating a service document, and initiating a voucher generation request to an accounting platform after the audit is passed; the voucher generation request comprises a voucher type and a voucher master key;
(2) the accounting platform comprises a document field Chinese and English comparison table, an automatic voucher switch, a voucher template, a voucher generation module and a property association module;
(2.1) the document field Chinese and English comparison table: the document processing system is used for translating and mapping English fields of business data acquired through document main key query into Chinese fields with business identification degrees, and the Chinese fields are used for configuring credential template information;
(2.2) the automatic credential switch: configuring an open state or a close state for different document types, and controlling whether to call a document template to automatically generate a document after receiving a document generation request;
(2.3) the credential template: including template applicable conditions and credential elements; the voucher elements comprise accounting entries, voucher influence factors, comparison tables and accessories; the accounting entry comprises subjects or subject classification, abstract, amount and auxiliary accounting;
the applicable conditions of the template are as follows: aiming at the business documents of the same document type but different business logics, setting different voucher templates by taking fields reflecting different business logics as applicable conditions, wherein the different voucher templates are used for meeting the flexible requirements of different business scenes for recording different accounting vouchers; after the certificate templates meeting the applicable conditions are matched, obtaining certificate element configuration information corresponding to the certificate templates;
the subjects can be directly configured as fixed subjects, and can also be configured as subject classification according to the voucher influence factor;
the voucher influence factor is a document field influencing the entry item;
the subject classification is a group of subject data confirmed according to the voucher influence factor, the comparison table and the default subject;
the comparison table is the corresponding relation between the specific value of the voucher influence factor and the fixed subject;
the attachment comprises two elements of an attachment source and an attachment type, and the original attachment of the certificate is obtained from the business document according to the source and the type and is used for verifying and filing the certificate;
(2.4) the credential generation module: acquiring the required data for generating the voucher according to the voucher element configuration field in the voucher template and the inquired business document information, performing financial verification on the voucher data, and forming an accounting voucher after the financial verification is passed;
(2.5) the property association module: and updating the certificate associated field of the business document according to the main key of the business document, and realizing mutual joint check of the business and financial data.
2. The system of claim 1, wherein the cross-reference table is configured with default subjects, and if the specific value of the document field is not configured in the cross-reference table or does not match a fixed subject in the cross-reference table, the default subject is selected.
3. The supply chain financial integrated processing system according to claim 1, wherein in the voucher generation module, the financial verification specifically comprises: checking whether the total sum of the lender is balanced, and checking whether the subject auxiliary check value exists in the corresponding file dictionary.
4. The supply chain financial industry integration processing system of claim 1, wherein the processing system further comprises a voucher generation interface, the voucher generation interface calls a voucher template to generate an accounting voucher according to the state of an automatic voucher switch after receiving a voucher generation request;
the processing system further comprises linkage with the financial institution: for the payment and receipt business with the dynamic account, acquiring dynamic account running water and receipt of the financial institution according to the enterprise account as an attachment of the payment and receipt document; and according to the accessory source and the accessory type configured by the template, taking the accessory of the receipt and payment document as the accessory of the certificate when the certificate is generated.
5. The integrated processing system of supply chain finance business and financial according to claim 1, characterized in that, the processing system further comprises a manual voucher module, which is used for manually triggering the business document without generating voucher to generate voucher under the state that the automatic voucher switch is closed.
6. The supply chain financial integrated processing system according to claim 1, wherein the voucher template is further configured with a voucher summarizing mode and a separate and recording combining mode; the voucher summarizing mode supports a plurality of business document data to summarize to generate a voucher; the entry merging mode supports merging of multiple entries of the same subject into one entry.
7. The system of claim 1, wherein the matching of the certificate elements of the certificate template is specifically: if the fields configured in the records in the template have document dimension fields and detail dimension fields, or detail dimension fields, matching the entry by using detail dimension data during matching, and circularly matching when a plurality of details exist; if all fields configured in the entry in the template are document dimension fields, matching the entry only once by using document dimension data; one entry in the template may appear, and a plurality of entries are correspondingly generated after a plurality of details are matched; fields that do not support entry configuration in the template are derived from different details.
8. The supply chain financial integrated processing system according to claim 1, wherein in the voucher generation module, the minimum available voucher number is obtained through database double cache, specifically: firstly, N minimum available certificate numbers are obtained from a database and stored in a cache A and a cache B; acquiring a minimum certificate number from A each time a certificate is newly added, and then removing the certificate number from A; if the voucher number is finally successfully generated into a voucher, removing the voucher number from B; if the certificate number is finally temporarily stored or not stored and the certificate is not actually generated, the certificate number is continuously reserved in the step B; if the certificate numbers in A are all removed, the rest certificate numbers in B are added into A, and N minimum available certificate numbers are obtained from the database again and stored into A and B.
9. The supply chain financial integrated processing system according to claim 1, wherein in the voucher generation module, for a voucher requiring invoicing, a commodity detail dimension for associating an invoice to the voucher is supported, the invoice detail of the commodity in the invoice list is obtained by selecting a voucher commodity and a commodity name, and after filling in the quantity of the commodity to be checked out, invoice association checking is performed, wherein the checking out amount of the invoice is the product price on the invoice multiplied by the quantity of the commodity, and the invoiced amount of the commodity detail is the product price multiplied by the product quantity multiplied by the commodity detail.
10. A supply chain finance and financial integration processing method based on the system of any one of claims 1-9, which is characterized by comprising the following steps:
s1: a user initiates a service request through a supply chain sensing system, and the service request is transmitted to a purchase, sale and storage system after being audited by a supply chain management company;
s2: the purchase, sales and inventory system receives the business request and generates a business document, and after the business request is approved, a voucher generation request is initiated to the accounting platform;
s3: the accounting platform inquires the automatic voucher switch state according to the receipt type in the voucher generation request, if the switch is in the open state, the step S4 is automatically executed, otherwise, the voucher is manually generated;
s4: the accounting platform acquires required business data according to the document type and the document main key of the document generation request, and acquires a document element configuration field in the document template by matching the document template corresponding to the document type according to the template application condition;
s5: acquiring the required data generated by the voucher according to the voucher element configuration field and the inquired business document information, performing financial verification on the voucher data, and forming an accounting voucher after the required data passes the financial verification;
s6: and updating the corresponding certificate associated field according to the main key of the business document to realize the integration of business and property.
CN202111150914.2A 2021-09-29 2021-09-29 Supply chain financial industry and finance integrated processing system and method Pending CN113888298A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202111150914.2A CN113888298A (en) 2021-09-29 2021-09-29 Supply chain financial industry and finance integrated processing system and method

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202111150914.2A CN113888298A (en) 2021-09-29 2021-09-29 Supply chain financial industry and finance integrated processing system and method

Publications (1)

Publication Number Publication Date
CN113888298A true CN113888298A (en) 2022-01-04

Family

ID=79007844

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202111150914.2A Pending CN113888298A (en) 2021-09-29 2021-09-29 Supply chain financial industry and finance integrated processing system and method

Country Status (1)

Country Link
CN (1) CN113888298A (en)

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN114862282A (en) * 2022-07-05 2022-08-05 中交第四航务工程勘察设计院有限公司 Business and financial cooperative management method and system based on data analysis
CN115311651A (en) * 2022-10-12 2022-11-08 泰安协同软件有限公司 Real estate voucher data acquisition and arrangement method
CN115423591A (en) * 2022-09-05 2022-12-02 北京华科诚信科技股份有限公司 Accounting engine system and voucher mapping conversion method thereof

Cited By (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN114862282A (en) * 2022-07-05 2022-08-05 中交第四航务工程勘察设计院有限公司 Business and financial cooperative management method and system based on data analysis
CN114862282B (en) * 2022-07-05 2022-11-18 中交第四航务工程勘察设计院有限公司 Business and financial cooperative management method and system based on data analysis
CN115423591A (en) * 2022-09-05 2022-12-02 北京华科诚信科技股份有限公司 Accounting engine system and voucher mapping conversion method thereof
CN115311651A (en) * 2022-10-12 2022-11-08 泰安协同软件有限公司 Real estate voucher data acquisition and arrangement method
CN115311651B (en) * 2022-10-12 2023-08-08 泰安协同软件有限公司 Real estate certificate data acquisition and arrangement method

Similar Documents

Publication Publication Date Title
US11361281B2 (en) Methods and systems for expense management
US7865413B2 (en) Method and system for processing transactions by a third party using a central database to facilitate remittance
US7490059B2 (en) Methods and systems for consolidating financial reporting information
AU2002359502B2 (en) Integrated invoice solution
US8442881B2 (en) Systems and methods of processing and classifying a financial transaction
US7970671B2 (en) Automated transaction processing system and approach with currency conversion
US7107244B2 (en) Bill payment system and method with merchant information
US7552089B2 (en) Method and apparatus for automatically applying/linking transactions in a financial management system
CN113888298A (en) Supply chain financial industry and finance integrated processing system and method
US20050222944A1 (en) System and method for managing the reimbursement of expenses using expense reports
US20050075979A1 (en) System and method for seller-assisted automated payment processing and exception management
AU2002242031A1 (en) Method and system for processing transactions
US7209897B2 (en) Systems and methods for charge-back invoice generation
CN111402019A (en) Value-added tax invoice online verification method and system suitable for enterprise settlement
CN111768281A (en) General ledger voucher generation method, device and system
CN115827798A (en) Bill management method established based on industry characteristics
JP2001222656A (en) System, device, method for financial affair management, and recording medium
TW200411457A (en) Notes receivable management system and method
US20040128209A1 (en) Outsourcing management system and method
KR102244727B1 (en) System and method for chechking business-to-business transactions and computer program for the same
CN115099914A (en) Financial business accounting system and equipment based on NCC framework
CN117911173A (en) Voucher processing system of business data
JP2003067575A (en) Security information registration and management system, security information registration program, and recording medium for recording the same
SG176353A1 (en) Point of sale - gst automatic reporting system
KR20100045070A (en) System and method for providing option additional service based on life cycle by complex account and recording medium

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination