CN109871256B - Method and equipment for integrating audit system and heterogeneous system based on RPA - Google Patents

Method and equipment for integrating audit system and heterogeneous system based on RPA Download PDF

Info

Publication number
CN109871256B
CN109871256B CN201910111356.5A CN201910111356A CN109871256B CN 109871256 B CN109871256 B CN 109871256B CN 201910111356 A CN201910111356 A CN 201910111356A CN 109871256 B CN109871256 B CN 109871256B
Authority
CN
China
Prior art keywords
expense
interface element
heterogeneous
interface
heterogeneous system
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.)
Active
Application number
CN201910111356.5A
Other languages
Chinese (zh)
Other versions
CN109871256A (en
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.)
Xiamen Shangji Network Technology Co ltd
Original Assignee
Xiamen Shangji Network Technology 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 Xiamen Shangji Network Technology Co ltd filed Critical Xiamen Shangji Network Technology Co ltd
Priority to CN201910111356.5A priority Critical patent/CN109871256B/en
Publication of CN109871256A publication Critical patent/CN109871256A/en
Application granted granted Critical
Publication of CN109871256B publication Critical patent/CN109871256B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Landscapes

  • Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)

Abstract

The invention relates to a method for integrating a fee auditing system and a heterogeneous system based on RPA, which comprises the following steps: establishing at least one expense audit system interface element control in an RPA robot system interface based on an interface of an expense audit system, wherein the expense audit system interface element control is used for linking corresponding interface elements in the expense audit system; creating at least one heterogeneous system interface element control in an RPA robot system interface based on an interface of a heterogeneous system, wherein the heterogeneous system interface element control is used for linking corresponding interface elements in the heterogeneous system; and generating an instruction set for operating each expense audit system interface element control and each heterogeneous system interface element control in an RPA robot system interface, simulating a service flow manually operated between the expense audit system and the heterogeneous system, and completing data transmission between the expense audit system and the heterogeneous system.

Description

Method and equipment for integrating audit system and heterogeneous system based on RPA
Technical Field
The invention relates to a method and equipment for integrating an auditing system and a heterogeneous system based on RPA, belonging to the technical field of robot process automation.
Background art:
RPA is an abbreviation for Robotic Process Automation, i.e., Robotic Process Automation. Is an emerging business process automation technology form based on software robotics or Artificial Intelligence (AI) staff concepts. The RPA robot is deployed in a computer, and can replace manual work to execute process automation work on the computer.
The expense auditing system is an internet operating system which controls risks by convenient acquisition, intelligent identification, intelligent auditing and intelligent accounting and combining expense big data analysis guidance and intelligent internal auditing.
The integration mode of the expense audit system and the heterogeneous system (such as an expense reimbursement system, a tax system and an OA system) is limited, when the audit system acquires data to be audited in the heterogeneous system, the heterogeneous system may have an interface but the interface data does not necessarily meet the requirement, and at the moment, the project may be limited by an interface provider; if the heterogeneous system has no interface, but the heterogeneous system allows the database to be directly connected, the data specification and safety problems exist; if no interface exists, the database cannot be directly connected, at the moment, data can be docked only in a manual mode, errors are prone to occurring, and efficiency is low. Conversely, data to interface to a heterogeneous system after being processed by the cost audit system also experiences the above problems.
Disclosure of Invention
In order to solve the problems in the prior art, the invention provides a method for integrating an audit system and a heterogeneous system based on RPA, which realizes the non-invasive butt joint of a cost audit system and the heterogeneous system through an RPA robot, reduces the manual repeated labor and avoids the development dependence of the heterogeneous system.
The technical scheme of the invention is as follows:
the first technical scheme is as follows:
a method for integrating a fee auditing system and a heterogeneous system based on RPA comprises the following steps:
based on an interface of the expense audit system, packaging interface elements of the expense audit system in an RPA robot system interface, and creating at least one expense audit system interface element control, wherein the expense audit system interface element control is used for linking corresponding interface elements in the expense audit system;
based on an interface of the heterogeneous system, packaging interface elements of the heterogeneous system in an RPA robot system interface, and creating at least one heterogeneous system interface element control, wherein the heterogeneous system interface element control is used for linking corresponding interface elements in the heterogeneous system;
generating an instruction set for operating each expense audit system interface element control and each heterogeneous system interface element control in an RPA robot system interface, and simulating a service flow manually operated between an expense audit system and a heterogeneous system through the instruction set to finish data transmission between the expense audit system and the heterogeneous system;
the expense auditing system is an internet operating system and has the function of identifying and auditing the financial data;
the heterogeneous system is an internet operating system and stores electronic financial data.
Furthermore, the expense audit system interface element control comprises the address of the corresponding interface element in the expense audit system and the name of the interface element;
the heterogeneous system interface element control comprises an address of a corresponding interface element in the heterogeneous system and a name of the interface element;
further, the specific steps of simulating a service flow operated manually between the fee auditing system and the heterogeneous system through the instruction set and completing data transmission between the fee auditing system and the heterogeneous system are as follows:
setting at least one instruction of jumping, selecting, clicking and inputting for each heterogeneous system interface element control, so that the RPA robot jumps to an interface for storing financial data in a heterogeneous system and automatically captures the financial data from the interface;
setting at least one instruction of skipping, selecting, clicking and inputting in each expense auditing system interface element control, so that the RPA robot inputs the financial data into the expense auditing system and triggers the expense auditing system to operate to identify the financial data;
setting at least one instruction of skipping, selecting, clicking and inputting in each expense auditing system interface element control, so that the RPA robot skips to a processing result interface of the expense auditing system and automatically captures processing data after the expense auditing system identifies financial data;
setting at least one instruction of skipping, selecting, clicking and inputting for each heterogeneous system interface element control, so that the RPA robot skips to an interface for storing financial data in a heterogeneous system, processing data after the financial data is identified is input into the heterogeneous system, and the heterogeneous system is triggered to operate to store the processing data after the financial data is identified.
Further, the financial data includes at least one of a reimbursement order image, a bank receipt image, and an invoice image.
Furthermore, the expense auditing system identifies the financial data through an OCR (optical character recognition) technology, and identifies financial details in the reimbursement bill image, the bank receipt image or the invoice image.
The second technical scheme is as follows:
an apparatus for integrating an audit system and a heterogeneous system based on RPA, comprising a memory and a processor, wherein the memory stores instructions, and wherein the instructions are adapted to be loaded by the processor and to perform the steps of:
based on an interface of the expense audit system, packaging interface elements of the expense audit system in an RPA robot system interface, and creating at least one expense audit system interface element control, wherein the expense audit system interface element control is used for linking corresponding interface elements in the expense audit system;
based on an interface of the heterogeneous system, packaging interface elements of the heterogeneous system in an RPA robot system interface, and creating at least one heterogeneous system interface element control, wherein the heterogeneous system interface element control is used for linking corresponding interface elements in the heterogeneous system;
generating an instruction set for operating each expense audit system interface element control and each heterogeneous system interface element control in an RPA robot system interface, and simulating a service flow manually operated between an expense audit system and a heterogeneous system through the instruction set to finish data transmission between the expense audit system and the heterogeneous system;
the expense auditing system is an internet operating system and has the function of identifying and auditing the financial data;
the heterogeneous system is an internet operating system and stores electronic financial data.
Furthermore, the expense audit system interface element control comprises the address of the corresponding interface element in the expense audit system and the name of the interface element;
the heterogeneous system interface element control comprises an address of a corresponding interface element in the heterogeneous system and a name of the interface element;
further, the specific steps of simulating a service flow operated manually between the fee auditing system and the heterogeneous system through the instruction set and completing data transmission between the fee auditing system and the heterogeneous system are as follows:
setting at least one instruction of jumping, selecting, clicking and inputting for each heterogeneous system interface element control, so that the RPA robot jumps to an interface for storing financial data in a heterogeneous system and automatically captures the financial data from the interface;
setting at least one instruction of skipping, selecting, clicking and inputting in each expense auditing system interface element control, so that the RPA robot inputs the financial data into the expense auditing system and triggers the expense auditing system to operate to identify the financial data;
setting at least one instruction of skipping, selecting, clicking and inputting in each expense auditing system interface element control, so that the RPA robot skips to a processing result interface of the expense auditing system and automatically captures processing data after the expense auditing system identifies financial data;
setting at least one instruction of skipping, selecting, clicking and inputting for each heterogeneous system interface element control, so that the RPA robot skips to an interface for storing financial data in a heterogeneous system, processing data after the financial data is identified is input into the heterogeneous system, and the heterogeneous system is triggered to operate to store the processing data after the financial data is identified.
Further, the financial data includes at least one of a reimbursement order image, a bank receipt image, and an invoice image.
Furthermore, the expense auditing system identifies the financial data through an OCR (optical character recognition) technology, and identifies financial details in the reimbursement bill image, the bank receipt image or the invoice image.
The invention has the following beneficial effects:
1. according to the method, the interface elements of the expense audit system and the heterogeneous system are used for creating the interface element control of the expense audit system for accessing the expense audit system and the interface element control of the heterogeneous system for accessing the heterogeneous system in the RPA robot, the RPA robot is used as a middle layer, so that the data transmission of the expense audit system and the heterogeneous system is realized, a user does not need to change the conventional expense audit system and the heterogeneous system, the financial data in the heterogeneous system and the processing result of the financial data in the expense audit system can be directly in seamless butt joint, the manual repeated labor is reduced, and the development dependence of the heterogeneous system is avoided; through the RPA robot, the non-invasive butt joint of the expense audit system and the heterogeneous system is realized, and the safety is higher.
2. The method utilizes the RPA robot to simulate the service flow of manual operation between the expense audit system and the heterogeneous system, and completes the data transmission between the expense audit system and the heterogeneous system; the working efficiency of the enterprise is improved, and errors caused by manual repeated operation are reduced.
Drawings
FIG. 1 is a flow chart of the present invention;
FIG. 2 is a flow chart of a simulation of manual operation according to a second embodiment of the present invention;
FIG. 3 is a schematic diagram of a portion of an interface of an electronic image management system according to an embodiment of the present invention;
FIG. 4 is a schematic code for encapsulating a portion of the interface elements of the electronic image management system of FIG. 3 according to an embodiment of the present invention;
FIG. 5 is a schematic code of an image barcode extracted through an interface element control of an electronic image management system according to an embodiment of the present invention;
FIG. 6 is a schematic diagram of another interface of the electronic image management system according to the embodiment of the present disclosure;
FIG. 7 is a schematic code for encapsulating a portion of the interface elements of the electronic image management system of FIG. 6 according to an embodiment of the present invention;
fig. 8 is a schematic code of writing financial details through an electronic image management system interface element control according to an embodiment of the present invention.
Detailed Description
The invention is described in detail below with reference to the figures and the specific embodiments.
Example one
Referring to fig. 1, a method for integrating a fee auditing system and a heterogeneous system based on an RPA includes the following steps:
the method comprises the steps that on the basis of an interface of a fee auditing system, all interface elements of the fee auditing system are packaged in an RPA robot system interface (namely, an externally-disclosed interface is packaged to control the access level of attribute reading and modification in a program;
based on an interface of the heterogeneous system, packaging each interface element of the heterogeneous system in an RPA robot system interface, and creating at least one heterogeneous system interface element control (the heterogeneous system interface element control is the packaging of each interface element of the heterogeneous system), wherein the heterogeneous system interface element control is used for linking corresponding interface elements in the heterogeneous system;
generating an instruction set for operating each expense audit system interface element control and each heterogeneous system interface element control in an RPA robot system interface (the instruction set is a set of instructions and commands for commanding each expense audit system interface element control and each heterogeneous system interface element control according to a certain sequence, namely a program for realizing a certain function), and simulating a service flow manually operated between an expense audit system and a heterogeneous system through the instruction set to complete data transmission between the expense audit system and the heterogeneous system;
the expense auditing system is an internet operating system and has the function of identifying and auditing the financial data;
the heterogeneous system is an internet operating system and stores electronic financial data.
In the embodiment, the interface elements of the expense audit system and the heterogeneous system are used for creating the interface element control of the expense audit system for accessing the expense audit system and the interface element control of the heterogeneous system for accessing the heterogeneous system in the RPA robot, and the RPA robot is used as a middle layer to realize the data transmission of the expense audit system and the heterogeneous system, so that a user can directly butt joint the financial data in the heterogeneous system and the processing result of the financial data in the expense audit system without changing the existing expense audit system and the heterogeneous system, thereby reducing the manual repeated labor and avoiding the development dependence of the heterogeneous system; through the RPA robot, the non-invasive butt joint of the expense audit system and the heterogeneous system is realized, and the safety is higher.
Example two
2-8, further, the expense audit system interface element control includes the address of the corresponding interface element in the expense audit system and the name of the interface element; for example, if the interface element of the fee auditing system has an identification button, a fee auditing system interface element control is created in the RPA robot, the address of the identification button is saved, and the name of the fee auditing system interface element control is set as the identification button;
the heterogeneous system interface element control comprises an address of a corresponding interface element in the heterogeneous system and a name of the interface element; for example, if the interface element of the heterogeneous system has a bank receipt list, a heterogeneous system interface element control is created in the RPA robot, the address of the bank receipt list is saved, and the name of the heterogeneous system interface element control is set to be the bank receipt list, specifically referring to fig. 3-4, the interface element of the electronic image management system includes interface elements such as a main interface entering a bank receipt list page, a bank receipt list, a matching state selection item, an image barcode input frame, and the like, and the required interface element is encapsulated in the RPA robot, so that the RPA robot can access the interface element in the electronic image management system;
further, the specific steps of simulating a service flow operated manually between the fee auditing system and the heterogeneous system through the instruction set and completing data transmission between the fee auditing system and the heterogeneous system are as follows:
setting at least one instruction of jumping, selecting, clicking and inputting for each heterogeneous system interface element control, so that the RPA robot jumps to an interface for storing financial data in a heterogeneous system and automatically captures the financial data from the interface;
setting at least one instruction of skipping, selecting, clicking and inputting in each expense auditing system interface element control, so that the RPA robot inputs the financial data into the expense auditing system and triggers the expense auditing system to operate to identify the financial data;
setting at least one instruction of skipping, selecting, clicking and inputting in each expense auditing system interface element control, so that the RPA robot skips to a processing result interface of the expense auditing system and automatically captures processing data after the expense auditing system identifies financial data;
setting at least one instruction of skipping, selecting, clicking and inputting for each heterogeneous system interface element control, so that the RPA robot skips to an interface for storing financial data in a heterogeneous system, processing data after the financial data is identified is input into the heterogeneous system, and the heterogeneous system is triggered to operate to store the processing data after the financial data is identified.
Further, the financial data includes at least one of a reimbursement order image, a bank receipt image, and an invoice image.
Furthermore, the expense auditing system identifies the financial data through an OCR (optical character recognition) technology, and identifies financial details in the reimbursement bill image, the bank receipt image or the invoice image.
The following describes a specific workflow of this embodiment with a heterogeneous system as an electronic image management system:
referring specifically to fig. 5, an instruction set for the interface element control of the electronic image management system is generated in the RPA robot, so that the RPA robot performs the following actions: entering a bank receipt list, selecting unmatched image bar codes in the matched state options and triggering screening, removing the originally stored image bar codes, and re-capturing the image bar codes obtained by selecting unmatched image bar codes and triggering screening for storage;
generating an instruction set of the expense audit system interface element controls in the RPA robot, so that the RPA robot executes the following actions: inputting the image bar code data into a charge auditing system, triggering the charge auditing system to work, and identifying financial details in the image bar code data through OCR (optical character recognition), wherein the financial details comprise an account number of a receipt information party, a user name of the receipt information party, a transaction amount of the receipt information and the like;
generating an instruction set of the expense audit system interface element controls in the RPA robot, so that the RPA robot executes the following actions: storing financial details such as the account number of the receipt information party, the name of the account number of the receipt information party, the transaction amount of the receipt information and the like;
referring specifically to fig. 6-8, an instruction set for the interface element control of the electronic image management system is generated in the RPA robot, so that the RPA robot performs the following actions: and writing the financial details such as the account number of the receipt information party, the name of the account number of the receipt information party, the transaction amount of the receipt information and the like into corresponding interface elements in the electronic image management system.
The embodiment has the beneficial effects of the first embodiment, and further provides a concrete step of simulating a service flow operated manually between the expense audit system and the heterogeneous system by using the RPA robot to complete data transmission between the expense audit system and the heterogeneous system; the RPA robot simulates the business process of manual repeated operation, so that the working efficiency of enterprises is improved, and errors caused by manual repeated operation are reduced.
EXAMPLE III
An apparatus for integrating an audit system and a heterogeneous system based on RPA, comprising a memory and a processor, wherein the memory stores instructions, and wherein the instructions are adapted to be loaded by the processor and to perform the steps of:
the method comprises the steps that on the basis of an interface of a fee auditing system, all interface elements of the fee auditing system are packaged in an RPA robot system interface (namely, an externally-disclosed interface is packaged to control the access level of attribute reading and modification in a program;
based on an interface of the heterogeneous system, packaging each interface element of the heterogeneous system in an RPA robot system interface, and creating at least one heterogeneous system interface element control (the heterogeneous system interface element control is the packaging of each interface element of the heterogeneous system), wherein the heterogeneous system interface element control is used for linking corresponding interface elements in the heterogeneous system;
generating an instruction set for operating each expense audit system interface element control and each heterogeneous system interface element control in an RPA robot system interface (the instruction set is a set of instructions and commands for commanding each expense audit system interface element control and each heterogeneous system interface element control according to a certain sequence, namely a program for realizing a certain function), and simulating a service flow manually operated between an expense audit system and a heterogeneous system through the instruction set to complete data transmission between the expense audit system and the heterogeneous system;
the expense auditing system is an internet operating system and has the function of identifying and auditing the financial data;
the heterogeneous system is an internet operating system and stores electronic financial data.
In the embodiment, the interface elements of the expense audit system and the heterogeneous system are used for creating the interface element control of the expense audit system for accessing the expense audit system and the interface element control of the heterogeneous system for accessing the heterogeneous system in the RPA robot, and the RPA robot is used as a middle layer to realize the data transmission of the expense audit system and the heterogeneous system, so that a user can directly butt joint the financial data in the heterogeneous system and the processing result of the financial data in the expense audit system without changing the existing expense audit system and the heterogeneous system, thereby reducing the manual repeated labor and avoiding the development dependence of the heterogeneous system; through the RPA robot, the non-invasive butt joint of the expense audit system and the heterogeneous system is realized, and the safety is higher.
Example four
2-8, further, the expense audit system interface element control includes the address of the corresponding interface element in the expense audit system and the name of the interface element; for example, if the interface element of the fee auditing system has an identification button, a fee auditing system interface element control is created in the RPA robot, the address of the identification button is saved, and the name of the fee auditing system interface element control is set as the identification button;
the heterogeneous system interface element control comprises an address of a corresponding interface element in the heterogeneous system and a name of the interface element; for example, if the interface element of the heterogeneous system has a bank receipt list, a heterogeneous system interface element control is created in the RPA robot, the address of the bank receipt list is saved, and the name of the heterogeneous system interface element control is set to be the bank receipt list, specifically referring to fig. 3-4, the interface element of the electronic image management system includes interface elements such as a main interface entering a bank receipt list page, a bank receipt list, a matching state selection item, an image barcode input frame, and the like, and the required interface element is encapsulated in the RPA robot, so that the RPA robot can access the interface element in the electronic image management system;
further, the specific steps of simulating a service flow operated manually between the fee auditing system and the heterogeneous system through the instruction set and completing data transmission between the fee auditing system and the heterogeneous system are as follows:
setting at least one instruction of jumping, selecting, clicking and inputting for each heterogeneous system interface element control, so that the RPA robot jumps to an interface for storing financial data in a heterogeneous system and automatically captures the financial data from the interface;
setting at least one instruction of skipping, selecting, clicking and inputting in each expense auditing system interface element control, so that the RPA robot inputs the financial data into the expense auditing system and triggers the expense auditing system to operate to identify the financial data;
setting at least one instruction of skipping, selecting, clicking and inputting in each expense auditing system interface element control, so that the RPA robot skips to a processing result interface of the expense auditing system and automatically captures processing data after the expense auditing system identifies financial data;
setting at least one instruction of skipping, selecting, clicking and inputting for each heterogeneous system interface element control, so that the RPA robot skips to an interface for storing financial data in a heterogeneous system, processing data after the financial data is identified is input into the heterogeneous system, and the heterogeneous system is triggered to operate to store the processing data after the financial data is identified.
Further, the financial data includes at least one of a reimbursement order image, a bank receipt image, and an invoice image.
Furthermore, the expense auditing system identifies the financial data through an OCR (optical character recognition) technology, and identifies financial details in the reimbursement bill image, the bank receipt image or the invoice image.
The following describes a specific workflow of this embodiment with a heterogeneous system as an electronic image management system:
referring specifically to fig. 5, an instruction set for the interface element control of the electronic image management system is generated in the RPA robot, so that the RPA robot performs the following actions: entering a bank receipt list, selecting unmatched image bar codes in the matched state options and triggering screening, removing the originally stored image bar codes, and re-capturing the image bar codes obtained by selecting unmatched image bar codes and triggering screening for storage;
generating an instruction set of the expense audit system interface element controls in the RPA robot, so that the RPA robot executes the following actions: inputting the image bar code data into a charge auditing system, triggering the charge auditing system to work, and identifying financial details in the image bar code data through OCR (optical character recognition), wherein the financial details comprise an account number of a receipt information party, a user name of the receipt information party, a transaction amount of the receipt information and the like;
generating an instruction set of the expense audit system interface element controls in the RPA robot, so that the RPA robot executes the following actions: storing financial details such as the account number of the receipt information party, the name of the account number of the receipt information party, the transaction amount of the receipt information and the like;
referring specifically to fig. 6-8, an instruction set for the interface element control of the electronic image management system is generated in the RPA robot, so that the RPA robot performs the following actions: and writing the financial details such as the account number of the receipt information party, the name of the account number of the receipt information party, the transaction amount of the receipt information and the like into corresponding interface elements in the electronic image management system.
The embodiment has the beneficial effects of the third embodiment, and further provides a concrete step of simulating a service flow operated manually between the expense audit system and the heterogeneous system by using the RPA robot to complete data transmission between the expense audit system and the heterogeneous system; the RPA robot simulates the business process of manual repeated operation, so that the working efficiency of enterprises is improved, and errors caused by manual repeated operation are reduced.
The above description is only an embodiment of the present invention, and not intended to limit the scope of the present invention, and all modifications of equivalent structures and equivalent processes performed by the present specification and drawings, or directly or indirectly applied to other related technical fields, are included in the scope of the present invention.

Claims (8)

1. A method for integrating a fee auditing system and a heterogeneous system based on RPA is characterized by comprising the following steps:
based on an interface of the expense audit system, packaging interface elements of the expense audit system in an RPA robot system interface, and creating at least one expense audit system interface element control, wherein the expense audit system interface element control is used for linking corresponding interface elements in the expense audit system;
based on an interface of the heterogeneous system, packaging interface elements of the heterogeneous system in an RPA robot system interface, and creating at least one heterogeneous system interface element control, wherein the heterogeneous system interface element control is used for linking corresponding interface elements in the heterogeneous system;
generating an instruction set for operating each expense audit system interface element control and each heterogeneous system interface element control in an RPA robot system interface, and simulating a service flow manually operated between an expense audit system and a heterogeneous system through the instruction set to finish data transmission between the expense audit system and the heterogeneous system; the method specifically comprises the following steps:
setting at least one instruction of jumping, selecting, clicking and inputting for each heterogeneous system interface element control, so that the RPA robot jumps to an interface for storing financial data in a heterogeneous system and automatically captures the financial data from the interface;
setting at least one instruction of skipping, selecting, clicking and inputting in each expense auditing system interface element control, so that the RPA robot inputs the financial data into the expense auditing system and triggers the expense auditing system to operate to identify the financial data;
setting at least one instruction of skipping, selecting, clicking and inputting in each expense auditing system interface element control, so that the RPA robot skips to a processing result interface of the expense auditing system and automatically captures processing data after the expense auditing system identifies financial data;
setting at least one instruction of skipping, selecting, clicking and inputting for each heterogeneous system interface element control, so that the RPA robot skips to an interface for storing financial data in a heterogeneous system, processing data after the financial data is identified is input into the heterogeneous system, and the heterogeneous system is triggered to operate to store the processing data after the financial data is identified;
the expense auditing system is an internet operating system and has the function of identifying and auditing the financial data;
the heterogeneous system is an internet operating system and stores electronic financial data.
2. The method of claim 1, wherein the fee auditing system and the heterogeneous system are integrated based on the RPA, and the method comprises:
the expense audit system interface element control comprises the address of the corresponding interface element in the expense audit system and the name of the interface element;
the heterogeneous system interface element control comprises an address of a corresponding interface element in the heterogeneous system and a name of the interface element.
3. The method of claim 1, wherein the fee auditing system and the heterogeneous system are integrated based on the RPA, and the method comprises: the financial data includes at least one of a reimbursement order image, a bank receipt image, and an invoice image.
4. The method of claim 3, wherein the fee auditing system and the heterogeneous system are integrated based on the RPA, and the method further comprises: the expense auditing system identifies the financial data through an OCR (optical character recognition) technology, and identifies financial details in the reimbursement bill image, the bank receipt image or the invoice image.
5. An apparatus for integrating an audit system and a heterogeneous system based on RPA, comprising a memory and a processor, wherein the memory stores instructions, wherein the instructions are adapted to be loaded by the processor and perform the following steps:
based on an interface of the expense audit system, packaging interface elements of the expense audit system in an RPA robot system interface, and creating at least one expense audit system interface element control, wherein the expense audit system interface element control is used for linking corresponding interface elements in the expense audit system;
based on an interface of the heterogeneous system, packaging interface elements of the heterogeneous system in an RPA robot system interface, and creating at least one heterogeneous system interface element control, wherein the heterogeneous system interface element control is used for linking corresponding interface elements in the heterogeneous system;
generating an instruction set for operating each expense audit system interface element control and each heterogeneous system interface element control in an RPA robot system interface, and simulating a service flow manually operated between an expense audit system and a heterogeneous system through the instruction set to finish data transmission between the expense audit system and the heterogeneous system; the method specifically comprises the following steps:
setting at least one instruction of jumping, selecting, clicking and inputting for each heterogeneous system interface element control, so that the RPA robot jumps to an interface for storing financial data in a heterogeneous system and automatically captures the financial data from the interface;
setting at least one instruction of skipping, selecting, clicking and inputting in each expense auditing system interface element control, so that the RPA robot inputs the financial data into the expense auditing system and triggers the expense auditing system to operate to identify the financial data;
setting at least one instruction of skipping, selecting, clicking and inputting in each expense auditing system interface element control, so that the RPA robot skips to a processing result interface of the expense auditing system and automatically captures processing data after the expense auditing system identifies financial data;
setting at least one instruction of skipping, selecting, clicking and inputting for each heterogeneous system interface element control, so that the RPA robot skips to an interface for storing financial data in a heterogeneous system, processing data after the financial data is identified is input into the heterogeneous system, and the heterogeneous system is triggered to operate to store the processing data after the financial data is identified;
the expense auditing system is an internet operating system and has the function of identifying and auditing the financial data;
the heterogeneous system is an internet operating system and stores electronic financial data.
6. The device of claim 5, wherein the device based on the RPA integrated audit system and the heterogeneous system comprises:
the expense audit system interface element control comprises the address of the corresponding interface element in the expense audit system and the name of the interface element;
the heterogeneous system interface element control comprises an address of a corresponding interface element in the heterogeneous system and a name of the interface element.
7. The device of claim 5, wherein the device based on the RPA integrated audit system and the heterogeneous system comprises: the financial data includes at least one of a reimbursement order image, a bank receipt image, and an invoice image.
8. The device of claim 7, wherein the device based on the RPA integrated audit system and the heterogeneous system comprises: the expense auditing system identifies the financial data through an OCR (optical character recognition) technology, and identifies financial details in the reimbursement bill image, the bank receipt image or the invoice image.
CN201910111356.5A 2019-02-12 2019-02-12 Method and equipment for integrating audit system and heterogeneous system based on RPA Active CN109871256B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201910111356.5A CN109871256B (en) 2019-02-12 2019-02-12 Method and equipment for integrating audit system and heterogeneous system based on RPA

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201910111356.5A CN109871256B (en) 2019-02-12 2019-02-12 Method and equipment for integrating audit system and heterogeneous system based on RPA

Publications (2)

Publication Number Publication Date
CN109871256A CN109871256A (en) 2019-06-11
CN109871256B true CN109871256B (en) 2022-04-01

Family

ID=66918657

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201910111356.5A Active CN109871256B (en) 2019-02-12 2019-02-12 Method and equipment for integrating audit system and heterogeneous system based on RPA

Country Status (1)

Country Link
CN (1) CN109871256B (en)

Families Citing this family (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111144886B (en) * 2019-12-17 2023-04-07 远光软件股份有限公司 Automatic bank account-arriving record processing method, system, equipment and storage medium
CN111722840A (en) * 2020-06-30 2020-09-29 北京来也网络科技有限公司 Command library creating method, device, medium and equipment for RPA flow generating end
CN113282425A (en) * 2021-04-26 2021-08-20 广州汉盛信息科技有限公司 Immersive robot process automation application system, platform and method
CN113176920B (en) * 2021-04-29 2024-05-31 上海云扩信息科技有限公司 Universal RPA element selector management system
CN113011959A (en) * 2021-05-24 2021-06-22 国能大渡河大数据服务有限公司 Seven-expense intelligent auditing system and use method thereof
CN113467879A (en) * 2021-07-20 2021-10-01 上海数慧系统技术有限公司 Multi-system data processing method and device based on RPA robot
CN113391871B (en) * 2021-08-17 2021-11-16 杭州实在智能科技有限公司 RPA element intelligent fusion picking method and system

Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN108470228A (en) * 2017-02-22 2018-08-31 国网能源研究院 Financial data auditing method and audit system
CN108769103A (en) * 2018-04-04 2018-11-06 卓望数码技术(深圳)有限公司 A kind of control method and system for checking result displaying based on communication service data

Patent Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN108470228A (en) * 2017-02-22 2018-08-31 国网能源研究院 Financial data auditing method and audit system
CN108769103A (en) * 2018-04-04 2018-11-06 卓望数码技术(深圳)有限公司 A kind of control method and system for checking result displaying based on communication service data

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
基于RPA的财务共享服务中心应付账款流程优化研究;程平 等;《会计之友》;20180831;第154-160页 *

Also Published As

Publication number Publication date
CN109871256A (en) 2019-06-11

Similar Documents

Publication Publication Date Title
CN109871256B (en) Method and equipment for integrating audit system and heterogeneous system based on RPA
CN109324787B (en) Business software development method and device and terminal equipment
US7334223B2 (en) Apparatus and method for automatically migrating client server applications to other architectures and platforms
US20080034347A1 (en) System and method for software lifecycle management
WO1996032675A9 (en) Automated enforcement of behavior in application program
EP0823084A4 (en) Automated enforcement of behavior in application program
CN101110021A (en) Method for visually programming instruction set for process
WO2000062191A2 (en) Interface for an enterprise resource planning program
CN114092951A (en) Financial bill processing method, device, system, equipment and medium combining RPA and AI
CN112579455B (en) Automatic interface testing method and device, electronic equipment and storage medium
CN110968437A (en) Method, device, equipment and medium for parallel execution of single contract based on Java intelligent contract
CN101777142A (en) Method for converting rules and regulations of enterprises and public institutions into computer-recognizable programs
CN112101869A (en) Express cabinet-based express item storing and taking method and device and server
CN104657274A (en) Method and device for testing software interface
Barnett et al. Model-based testing with AsmL .NET
CN110659348A (en) Group enterprise universe risk fusion analysis method and system based on knowledge reasoning
CN113887913A (en) Efficiency evaluation method and device combining RPA and AI and electronic equipment
Klein et al. Problem-adaptable document analysis and understanding for high-volume applications
CN114969127A (en) Reconciliation method, reconciliation system and storage medium for automatically combining reconciliation transactions
CN106528718A (en) Method and device for processing data from third party
JP2003140895A (en) Test system having recombinable software
CN113836037A (en) Interface interaction test method, device, equipment and storage medium
CN112667278A (en) Hospital medical insurance interface configuration method and system
CN113159951B (en) Financial data clearing method, device, equipment and storage medium
CN111859370A (en) Method, apparatus, electronic device and computer-readable storage medium for identifying service

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
GR01 Patent grant
GR01 Patent grant