Method for classifying, summarizing and prefabricating to-be-issued tickets and checking passed accounts
Automatic processing of invoice data through RPA and OCR technology, solving the problems of cumbersome and inefficient in invoice classification summary, prefabrication and posting processes in the existing technology, improving processing efficiency and accuracy, and reducing the workload and errors of financial personnel The rate has improved the speed of capital management.
Patent Information
- Application Number
- CN202411232726.8
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-09-04
- Publication Date
- 2024-11-26
AI Technical Summary
In the prior art, the invoice classification summary, prefabrication and posting process are cumbersome and inefficient, which can easily lead to data input errors and omissions, increase the workload and error rate of financial personnel, and affect the company's capital management and working capital management.
Using an automated method based on RPA and OCR, we automatically log in to the ERP system through RPA robots, obtain purchase order information, classify and summarize data, generate prefabricated invoices, and identify original document data through OCR for automatic review and posting operations, reducing manual intervention.
It realizes the automated processing of invoice data, improves processing efficiency, reduces the error rate, reduces the workload of financial personnel, and improves the speed of fund management.
Smart Images

Figure CN119027254A_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the field of computer technology, and is a method for automating classification and aggregation of invoices to be issued, invoice pre-production and posting review based on RPA and OCR. Background Art
[0002] At present, in the daily operation of the company's procurement department, processing the purchase orders of various suppliers and issuing invoices is a tedious and important task. Every day, the corresponding data of three documents, namely different types of purchase orders, original invoice documents, and warehouse acceptance documents, need to be retrieved according to fixed rules to check and issue invoices. This manual operation requires a lot of human resources and consumes a lot of manpower costs. The procurement department and the finance department need to arrange 3 employees to complete it for at least 1 hour. Due to the trivial and complicated operation process, manual operation is prone to data input errors, omissions or duplications. Once an error occurs, it needs to be repeatedly checked, which increases the posting time and affects the company's working capital management, especially for the management of expenses, accounts receivable and accounts payable related to the financial process, resulting in a slower capital turnover.
[0003] At the same time, as the company streamlines its staff and effectively reduces labor costs, the workload of financial personnel has increased dramatically. Manual operations are difficult to cope with large-scale invoice processing tasks, and visual operations are prone to operational errors and confusion, increasing error rates and reducing the success rate of one-time postings. This causes financial personnel to be exhausted, ineffective work increases, and a lot of time is wasted. Summary of the invention
[0004] The present invention provides a method for automatically processing and classifying data to be invoiced, automatically pre-making invoices, and automatically reviewing postings, which overcomes the shortcomings of the above-mentioned prior art and can effectively solve the problems of being cumbersome, inefficient, and having a high error rate in the existing methods of classifying and summarizing invoices, pre-making invoices, and postings that are mainly performed manually.
[0005] One of the technical solutions of the present invention is achieved by the following measures: a method for automating the classification and aggregation of invoices to be issued, invoice pre-production and posting review based on RPA and OCR, comprising: Initialize the RPA robot and automatically log in to the ERP system; The RPA robot obtains the purchase order information that needs to be invoiced and automatically classifies and summarizes the data to be invoiced; Trigger the ERP invoice pre-production service interface to generate pre-production invoices according to the corresponding invoicing rules based on different types of invoicing data and purchase order information; If review and posting are required, RPA will automatically obtain the original document voucher of the purchase order and obtain the original voucher data through OCR recognition; if review and posting are not required, RPA will summarize and record the current processing data and send an email notification; Automatically review the prefabricated invoices based on the review of the original document data and prefabricated invoice data identified by OCR. By triggering the ERP review posting service interface, the posting operation is executed, the current processing data is summarized and recorded, and an email notification is sent. If the review fails, it is forwarded to the financial staff for processing.
[0006] The following are further optimizations and improvements to the above-mentioned technical solution: The above RPA can process and classify the automatic invoicing data, including: Use RPA robots to extract purchase order information to be invoiced from the ERP system; Based on the extracted data features, the data is classified by supplier and invoice type standards; Automatically retrieve corresponding invoice pre-production rules according to different purchase order categories; Summarize the processed data into data to be invoiced as required; Enter the data to be billed as a pre-made invoice.
[0007] The above RPA can automatically complete invoice pre-production, including: Associating the aggregated invoice data package with the purchase order information as input parameters for the ERP invoice pre-production service interface; Trigger the invoice pre-production service interface. According to the preset rules, the RPA instance automatically fills in the invoice information in the ERP system and generates a pre-production invoice. Persist the prefabricated invoice data information and use it as posting review input.
[0008] The above-mentioned RPA automatically obtains the original document voucher of the purchase order, and combines OCR optical recognition technology to identify and obtain the original document data information, including: The RPA instance automatically determines whether to execute the review and posting task by setting parameters; If a review and posting task needs to be performed, the RPA instance will automatically obtain the original document attachment of the purchase order. If it cannot be obtained, the instance will be suspended and a notification will be sent to the purchasing department to remind them to upload the original document. After the document is uploaded, the purchasing staff will trigger the activation of the RPA instance; The RPA instance automatically calls the OCR service and uploads the original order information to the OCR service. The OCR recognizes and obtains the original document data information and encapsulates it into JSON; Cache the original document information to the cache service, generate the original document data information identifier based on the purchase order information, and record the operation log as the input for posting review.
[0009] The above RPA can realize automatic posting review, including: Generate input for verification script by combining original document data and prefabricated invoice information; By calling the script file of the matching rule, the original document data information is matched and reviewed with the prefabricated invoice information to determine whether the review is passed; if the review is correct, the posting service is triggered, the posting operation is performed, and the posting voucher is generated; If any abnormality is found during verification, the system will automatically transfer the problematic invoice to the finance department for processing; Summarize current processing data and send notifications to the purchasing department and financial personnel, and record operation logs.
[0010] The above RPA is equipped with scheduled task execution and task execution monitoring functions, including: RPA instances can trigger tasks at specific time points or intervals, and any abnormalities during task execution will be notified via email; RPA instances can monitor detailed execution logs of tasks, including task start time, end time, classification summary, invoice pre-production, posting review, and execution result information, and notify via email.
[0011] The second technical solution of the present invention is achieved by the following measures: a method for automatically processing and classifying data to be invoiced, automatically pre-making invoices, and automatically reviewing postings, including: Initialize the instance and automatically log in to the module. Through scheduled tasks or event triggers, the RPA robot instance is initialized according to the set parameters, and the robot automatically logs in to the ERP system. The classification and summary module uses RPA to automatically retrieve the corresponding invoice pre-production rules according to different purchase order types, and automatically classifies and summarizes different types of invoicing data information; The prefabricated invoice generation module obtains the data information to be invoiced and triggers the invoice prefabrication service to generate prefabricated invoices; In the information processing module, if review and posting are required, RPA will automatically obtain the original document voucher of the purchase order and obtain the original voucher data through OCR recognition; if review and posting are not required, the current processing data will be summarized and recorded, and an email notification will be sent; The posting review module reviews the original document data identified by OCR with the prefabricated invoice data through RPA to realize automatic review of prefabricated invoices. By triggering the ERP review posting service interface, the posting operation is executed, the current processing data is summarized and recorded, and an email notification is sent. If the review fails, it is forwarded to the financial staff for processing; The timing and monitoring module executes the core functional tasks of classification summary, invoice pre-production and posting review through RPA scheduled tasks or event triggers, and monitors the execution of tasks to ensure timely and accurate operations. BRIEF DESCRIPTION OF THE DRAWINGS
[0012] AttachedFigure 1 This is a business flow chart of the present invention.
[0013] Attached Figure 2 This is a flow chart of the method of Example 1 of the present invention.
[0014] Attached Figure 3 This is a flow chart of the method of embodiment 2 of the present invention.
[0015] Attached Figure 4 This is a system structure block diagram of embodiment 3 of the present invention. DETAILED DESCRIPTION
[0016] The present invention is not limited to the embodiments described below, and specific implementation methods can be determined based on the technical solutions of the present invention and actual conditions.
[0017] Embodiment 1: As attached Figure 2 As shown, the embodiment of the present invention discloses a method for automatically processing and classifying data to be invoiced, automatically pre-producing invoices, and automatically reviewing postings, including: S101 automatically logs into the ERP system through RPA, automatically retrieves the corresponding invoice pre-production rules and classifies and summarizes different types of purchase order data information according to different purchase order types, including suppliers, invoice types and amounts; S102 obtains purchase order data information, triggers the ERP invoice pre-production service interface, and generates a pre-production invoice according to preset rules; S103 automatically obtains the original voucher of the purchase order through RPA, obtains the original voucher data through OCR recognition, and obtains structured data, including amount, tax amount and tax code; S104 uses RPA to match and verify the original document data with the prefabricated invoice data, triggering the ERP review and posting service interface to perform the posting operation.
[0018] This embodiment discloses a method for automatically processing and classifying data to be invoiced, automatically pre-making invoices, and automatically reviewing postings. RPA can automatically log in to ERP, process and classify the data to be invoiced automatically, pre-make invoices according to the corresponding rules of different purchase order types, automatically obtain the original document voucher of the purchase order, and automatically identify the attachment information based on OCR optical recognition, and use RPA to match and check the original document data with the pre-made invoice data, trigger the ERP review posting service interface, and perform the posting operation. Therefore, it realizes the information transmission, invoice pre-making and review operations between the procurement business and finance in the system through informatization and automation, improves efficiency and reduces the error rate.
[0019] Embodiment 2: As attached Figure 3As shown, the embodiment of the present invention discloses a method for automatically processing and classifying data to be invoiced, pre-making invoices and posting and reviewing invoices, including: S201 automatically logs into the ERP system through RPA, automatically retrieves the corresponding invoice pre-production rules and classifies and summarizes different types of purchase order data information according to different purchase order types, including suppliers, invoice types and amounts; S202 obtains purchase order data information, triggers the ERP invoice pre-production service interface, and generates a pre-production invoice according to preset rules; S203 RPA automatically determines whether to execute the posting task based on the set parameters. If the posting task needs to be executed, S204 is executed; otherwise, S208 is executed. S204 automatically obtains the original purchase order voucher through RPA; S205 RPA automatically determines whether the original voucher of the purchase order has been successfully obtained. If it is successfully obtained, S206 is executed. Otherwise, the instance is suspended and a notification is sent to the purchasing department to remind it to upload the original voucher. After the voucher is uploaded, the purchasing staff triggers the activation of the RPA instance; S206 RPA automatically calls the OCR service, uploads the original voucher of the acquired order information to the OCR service, obtains the original voucher data through OCR recognition, and obtains structured data, including amount, tax amount and tax code. RAP obtains the original document data information and prefabricated invoice information according to the purchase order information, generates the input of the verification script, and matches and verifies the original document data information with the prefabricated invoice information by calling the script file of the matching rule; S207 RPA automatically determines whether the review has passed. If the review is correct, the posting service is triggered, the posting operation is performed, the posting voucher is generated, and S208 is executed; if there is an abnormality in the review, the system automatically transfers the problematic invoice to the finance department for processing; S208 RPA automatically summarizes the current processing data records and sends emails.
[0020] Embodiment 3: As attached Figure 4 As shown, the embodiment of the present invention discloses a method for automatically processing and classifying data to be invoiced, pre-making invoices and posting and reviewing invoices, including: Initialize the instance and automatically log in to the module. Through scheduled tasks or event triggers, the RPA robot instance is initialized according to the set parameters, and the robot automatically logs in to the ERP system. The classification and summary module uses RPA to automatically retrieve the corresponding invoice pre-production rules according to different purchase order types, and automatically classifies and summarizes different types of invoicing data information; The prefabricated invoice generation module obtains the data information to be invoiced and triggers the invoice prefabrication service to generate prefabricated invoices; In the information processing module, if review and posting are required, RPA will automatically obtain the original document voucher of the purchase order and obtain the original voucher data through OCR recognition; if review and posting are not required, the current processing data will be summarized and recorded, and an email notification will be sent; The posting review module reviews the original document data identified by OCR with the prefabricated invoice data through RPA to realize automatic review of prefabricated invoices. By triggering the ERP review posting service interface, the posting operation is executed, the current processing data is summarized and recorded, and an email notification is sent. If the review fails, it is forwarded to the financial staff for processing; The timing and monitoring module executes the core functional tasks of classification summary, invoice pre-production and posting review through RPA scheduled tasks or event triggers, and monitors the execution of tasks to ensure timely and accurate operations.
Claims
1. A method for automating the classification and aggregation of invoice information to be issued, invoice pre-production and posting review based on RPA and OCR. It is characterized in that The following steps are involved: Initialize the RPA robot and automatically log in to the ERP system; The RPA robot obtains the purchase order information that needs to be invoiced and automatically classifies and summarizes the data to be invoiced; Trigger the ERP invoice pre-production service interface to generate pre-production invoices according to the corresponding invoicing rules based on different types of invoicing data and purchase order information; If review and posting are required, RPA will automatically obtain the original document voucher of the purchase order and obtain the original voucher data through OCR recognition; if review and posting are not required, RPA will summarize and record the current processing data and send an email notification; Automatic review of prefabricated invoices is achieved by reviewing the original document data and prefabricated invoice data recognized by OCR. Posting operations are performed by triggering the ERP review and posting service interface, and current processing data is summarized and recorded. An email notification is sent. If the review fails, it is forwarded to the financial staff for processing.
2. The method for automating the classification and aggregation of invoice information to be issued, invoice pre-production and posting review according to claim 1, It is characterized in that The automatic acquisition of ERP purchase order information based on RPA and the aggregation and classification of invoicing information include: Through scheduled tasks or event triggers, the RPA robot instance is initialized according to the set parameters, and the robot automatically logs into the ERP system to obtain the purchase order information that needs to be invoiced on the business side; The RPA instance automatically obtains the purchase order information that needs to be invoiced, classifies the data according to the data characteristics of the supplier and invoice type, and finally summarizes it into data to be invoiced; Encapsulate the invoicing data into JSON format and record the operation log.
3. The method for automating the classification and aggregation of invoice information to be issued, invoice pre-production and posting review according to claim 1 or 2, It is characterized in that The RPA automatically calls the ERP invoice pre-production interface to implement invoice pre-production for different types of invoicing data according to different rules, including: The RPA instance associates the aggregated invoice data package with the purchase order information to generate input parameters for the ERP invoice pre-production service interface; The RPA instance automatically triggers the call of the ERP invoice pre-production service interface to implement invoice pre-production for different types of invoicing data according to different rules and generate pre-production invoice information; Persistent prefabricated invoice data information and record invoice prefabrication operation logs.
4. The method for automating the classification and aggregation of invoice information to be issued, invoice pre-production and posting review according to claim 1, It is characterized in that The RPA instance automatically obtains the original document voucher of the purchase order and uses OCR optical recognition technology to identify and obtain the original document data information, including: The RPA instance automatically determines whether to execute the review and posting task by setting parameters; If a review and posting task needs to be performed, the RPA instance will automatically obtain the original document attachment of the purchase order; if it cannot be obtained, the instance will be suspended and a notification will be sent to the purchasing department to remind them to upload the original document. After the document is uploaded, the purchasing staff will trigger and activate the RPA instance; The RPA instance automatically calls the OCR service and uploads the original voucher of the acquired order information to the OCR service. The OCR recognizes and obtains the original document data information and encapsulates it into JSON. Cache the original document information to the cache service, generate the original document data information identifier based on the purchase order information, and record the operation log.
5. The method for automatically classifying and aggregating invoice information to be issued, pre-making invoices and checking postings according to claim 1 or 4, It is characterized in that Based on RPA, pre-made invoice information and original documents are reviewed and posted, including: The RAP instance obtains the original document data information and prefabricated invoice information based on the purchase order information and generates the input of the verification script; By calling the script file of the matching rule, the original document data information is matched and reviewed with the prefabricated invoice information to determine whether the review is passed; if the review is correct, the posting service is triggered, the posting operation is performed, and the posting voucher is generated; If any abnormality is found during verification, the system will automatically transfer the problematic invoice to the finance department for processing; Summarize current processing data and send notifications to the purchasing department and financial personnel, and record operation logs.
6. The method for automating the classification and aggregation of invoice information to be issued, invoice pre-production and posting review according to claim 1, It is characterized in that The RPA system is based on scheduled execution of tasks or event triggering, and has the function of monitoring task execution, including: RPA instances can be triggered to execute tasks at specific time points or events, and any abnormalities during task execution will be notified via email; RPA instances can monitor detailed execution logs of tasks, including task start time, end time, classification summary, invoice pre-production, posting review, and execution result information, and notify via email.
7. A method for automating the classification and aggregation of invoice information to be issued, invoice pre-production and posting review based on RPA and OCR. It is characterized in that include: Initialize the instance and automatically log in to the module. Through scheduled tasks or event triggers, the RPA robot instance is initialized according to the set parameters, and the robot automatically logs in to the ERP system. The classification and summary module uses RPA to automatically retrieve the corresponding invoice pre-production rules according to different purchase order types, and automatically classifies and summarizes different types of invoicing data information; The prefabricated invoice generation module obtains the data information to be invoiced and triggers the invoice prefabrication service to generate prefabricated invoices; In the information processing module, if review and posting are required, RPA will automatically obtain the original document voucher of the purchase order and obtain the original voucher data through OCR recognition; if review and posting are not required, the current processing data will be summarized and recorded, and an email notification will be sent; The posting review module reviews the original document data identified by OCR with the prefabricated invoice data through RPA to realize automatic review of prefabricated invoices; by triggering the ERP review posting service interface, the posting operation is executed, the current processing data is summarized and recorded, and an email notification is sent. If the review fails, it is forwarded to the financial staff for processing; The timing and monitoring module executes the core functional tasks of classification summary, invoice pre-production and posting review through RPA scheduled tasks or event triggers, and monitors the execution of tasks to ensure timely and accurate operations.
