RPA-based cost accounting method, device, equipment and storage medium
Through the RPA-based method, the calculation inaccuracy and insufficient timeliness caused by the out-of-synchronization of BOM system data and design changes are solved, and the accuracy and timeliness of cost accounting data are achieved, and the cost prediction needs on the financial side are met.
Patent Information
- Application Number
- CN202311149402.3
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2023-09-06
- Publication Date
- 2024-11-19
- Estimated Expiration
- 2043-09-06
AI Technical Summary
The current cost accounting is inaccurate and insufficient timeliness due to the out-of-synchronization of BOM system data and design changes, which cannot meet the financial cost prediction timeliness and accuracy requirements.
Using an RPA-based method, by receiving the target part table, using the RPA cloud to access the material list database and procurement price database, perform part number matching, material data combination and price query, calculate the total price, and establish a communication connection through the RPA cloud to ensure that Data accuracy and timeliness.
The accuracy and timeliness of accounting data are achieved, and the problems of inaccuracy and timeliness of accounting caused by the out-of-synchronization of BOM system data and design changes are solved, and the cost prediction needs on the financial side are met.
Smart Images

Figure CN117078293B_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the field of data transmission, and in particular to a cost accounting method, device, equipment and storage medium based on RPA. Background Art
[0002] The BOM material cost convolution of domestic OEMs is generally completed in ERP. The ERP data comes from the synchronization of BOM monthly vehicle model solution data, and the timeliness and quality of the data cannot be effectively guaranteed.
[0003] When different forms of BOMs (mainly EBOM, PBOM, MBOM, and SBOM) are transmitted, the relevant models of the car companies dynamically calculate the single vehicle BOM. Especially in the C2M scenario, the calculation amount is large, the calculation frequency is high, and the computing power requirements are high. Directly obtaining the calculated model data from the BOM will affect production. The financial system generally synchronizes model data on a monthly basis, or exports batches from the BOM to Excel for analysis. This data processing method has poor timeliness.
[0004] On the other hand, in the actual manufacturing process, there are usually design changes. Design changes usually occur in the work order system, which cannot meet the timeliness analysis requirements and cannot even be transferred to the BOM, resulting in differences between the vehicle model parts obtained by the financial system from the BOM and the actual ones, which leads to inaccurate material cost analysis. This data asynchrony is a pain point in the accounting of the entire manufacturing industry, and the timeliness of current cost accounting is also insufficient, which cannot meet the timeliness and accuracy requirements of cost forecasting on the financial side.
[0005] Therefore, a new technology is needed to address the current cost accounting problems such as inaccurate accounting and lack of timeliness due to the asynchrony between BOM system data and design changes. Summary of the invention
[0006] The main purpose of the present invention is to solve the technical problems of inaccurate cost accounting and insufficient timeliness due to the asynchrony between BOM system data and design changes.
[0007] A first aspect of the present invention provides a cost accounting method based on RPA, comprising the steps of:
[0008] Receive a target part list, wherein the target part list includes: N target part names, part numbers corresponding to the target part names, and part quantities corresponding to the target part names, wherein N is a positive integer;
[0009] Using a preset RPA cloud, accessing a preset bill of materials database, and performing part number matching processing in the bill of materials database according to part numbers corresponding to N target part names in the target part table to obtain N material data, and combining and processing the N material data to obtain a material data set;
[0010] Using a preset RPA cloud, access a preset purchase price database, perform query and combination processing on the material data set according to the purchase price database, and obtain a material price combination set;
[0011] Based on the number of parts corresponding to each target part name in the target parts table, the material price combination set is calculated and statistically processed to obtain the calculated total price corresponding to the target parts table.
[0012] Optionally, in a first implementation of the first aspect of the present invention, before receiving the target parts list, the method further includes:
[0013] Create an accounting task execution process in the pre-installed RPA cloud;
[0014] Performing data format verification on the accounting task execution process to obtain a verification result;
[0015] Determine whether the verification result is qualified;
[0016] If the verification result is qualified, the preset material list database and the preset purchase price database are logged in and verified through the RPA cloud, a first communication connection between the RPA cloud and the material list database is established, and a second communication connection between the RPA cloud and the purchase price database is established.
[0017] Optionally, in a second implementation of the first aspect of the present invention, performing login verification processing on a preset material list database and a preset purchase price database through the RPA cloud, establishing a first communication connection between the RPA cloud and the material list database, and establishing a second communication connection between the RPA cloud and the purchase price database includes:
[0018] Sending the authentication token of the RPA cloud to the preset material list database and the preset purchase price database;
[0019] receiving a first authentication key fed back by the bill of materials database, and receiving a second authentication key fed back by the purchase price database;
[0020] Based on the first authentication key, a first communication connection is established between the RPA cloud and the bill of materials database, and based on the second authentication key, a second communication connection is established between the RPA cloud and the purchase price database.
[0021] Optionally, in a third implementation of the first aspect of the present invention, querying and combining the material data set according to the purchase price database to obtain a material price combination set includes:
[0022] Extracting material data from the material data set to obtain target material data;
[0023] Based on the part number corresponding to the target material data, query processing is performed in the purchase price database to obtain the purchase price corresponding to the target material data;
[0024] The target material data and the purchase price are combined to obtain a material price combination element.
[0025] Optionally, in a fourth implementation of the first aspect of the present invention, the received target parts list includes:
[0026] Receiving a part entry instruction in a preset work order system interface, and writing part data corresponding to the part entry instruction into an edited parts table;
[0027] A confirmation instruction is received, and the edited parts list is confirmed as a target parts list.
[0028] Optionally, in a fifth implementation of the first aspect of the present invention, after the material price combination set is calculated and statistically processed based on the number of parts corresponding to each target part name in the target part table to obtain the calculated total price corresponding to the target part table, the method further includes:
[0029] Binding and converting the calculated total price and the target parts list to generate a JSON text;
[0030] The JSON text is uploaded to a preset history database.
[0031] Optionally, in a sixth implementation of the first aspect of the present invention, performing part number matching processing in the bill of materials database according to the part numbers corresponding to the N target part names in the target part table to obtain the N material data includes:
[0032] Read the part number corresponding to a single target part name in the target part table;
[0033] Based on preset regular rules, data corresponding to the part number is matched in the bill of materials database to obtain single material data.
[0034] A second aspect of the present invention provides a cost accounting device based on RPA, and the cost accounting device based on RPA includes:
[0035] A receiving module, used for receiving a target part list, wherein the target part list includes: N target part names, part numbers corresponding to the target part names, and part quantities corresponding to the target part names, wherein N is a positive integer;
[0036] A matching module, for accessing a preset bill of materials database by using a preset RPA cloud, and performing part number matching processing in the bill of materials database according to part numbers corresponding to N target part names in the target part table to obtain N material data, and combining the N material data to obtain a material data set;
[0037] A query combination module is used to use a preset RPA cloud to access a preset purchase price database, and perform query combination processing on the material data set according to the purchase price database to obtain a material price combination set;
[0038] The calculation and statistics module is used to perform calculation and statistics processing on the material price combination set based on the number of parts corresponding to each target part name in the target part table to obtain the calculated total price corresponding to the target part table.
[0039] A third aspect of the present invention provides an RPA-based cost accounting device, comprising: a memory and at least one processor, the memory storing instructions, the memory and the at least one processor being interconnected through lines; the at least one processor calling the instructions in the memory so that the RPA-based cost accounting device executes the above-mentioned RPA-based cost accounting method.
[0040] A fourth aspect of the present invention provides a computer-readable storage medium, which stores instructions that, when executed on a computer, enable the computer to execute the above-mentioned RPA-based cost accounting method.
[0041] In an embodiment of the present invention, the RPA cloud is used as a data transfer platform to establish a communication connection between the bill of materials database and the procurement system, and the accounting data results are adjusted based on the entered target parts list to ensure the accuracy and timeliness of the accounting data, thereby solving the technical problems of inaccurate accounting and insufficient timeliness of current cost accounting due to the asynchrony of BOM system data and design changes. BRIEF DESCRIPTION OF THE DRAWINGS
[0042] Figure 1 This is a schematic diagram of an embodiment of a cost accounting method based on RPA in an embodiment of the present invention;
[0043] Figure 2 This is a schematic diagram of an embodiment of a cost accounting device based on RPA in an embodiment of the present invention;
[0044] Figure 3 This is a schematic diagram of another embodiment of a cost accounting device based on RPA in an embodiment of the present invention;
[0045] Figure 4 The figure is a schematic diagram of an embodiment of a cost accounting device based on RPA in an embodiment of the present invention. DETAILED DESCRIPTION
[0046] Embodiments of the present invention provide a cost accounting method, apparatus, device and storage medium based on RPA.
[0047] The terms "first", "second", "third", "fourth", etc. (if any) in the specification and claims of the present invention and the above-mentioned drawings are used to distinguish similar objects, and are not necessarily used to describe a specific order or sequence. It should be understood that the data used in this way can be interchanged where appropriate, so that the embodiments described herein can be implemented in an order other than that illustrated or described herein. In addition, the terms "including" or "having" and any variations thereof are intended to cover non-exclusive inclusions, for example, a process, method, system, product or device that includes a series of steps or units is not necessarily limited to those steps or units that are clearly listed, but may include other steps or units that are not clearly listed or inherent to these processes, methods, products or devices.
[0048] For ease of understanding, the specific process of the embodiment of the present invention is described below. Figure 1 , an embodiment of the cost accounting method based on RPA in an embodiment of the present invention includes the steps of:
[0049] 101. Receive a target part list, wherein the target part list includes: N target part names, part numbers corresponding to the target part names, and part quantities corresponding to the target part names, wherein N is a positive integer;
[0050] In this embodiment, the target part table contains N target part names, which are displayed in a table. For example, the target part name-part number-part quantity format is "suspension cylinder-PMskj5655-20". The target part table contains N parameters with target part names. The target part table can be data imported from other databases or manually input data.
[0051] Furthermore, the following steps may be performed at 101:
[0052] 1011. Receive a part entry instruction in the preset work order system interface, and write part data corresponding to the part entry instruction into the edited parts table;
[0053] 1012. Receive a confirmation instruction, and confirm the edited parts list as the target parts list.
[0054] In steps 1011-1012, the work order system interface receives the part entry instructions manually input by the user, and the part entry instructions write the target part name-part number-part quantity data into the edited parts table according to the established format. After receiving the user confirmation instruction, the edited parts table is confirmed as the target parts table. That is, the data input of this application is directly entered into the work order system, and the edited parts table of the changed design in the manufacturing industry is used as a new calculation and accounting, and does not need to be updated in the BOM database before calculation.
[0055] Furthermore, before 101, you can also perform the following steps:
[0056] 1013. Create an accounting task execution process in the pre-installed RPA cloud;
[0057] 1014. Perform data format verification on the accounting task execution process to obtain a verification result;
[0058] 1015. Determine whether the verification result is qualified;
[0059] 1016. If the verification result is qualified, the preset material list database and the preset purchase price database are logged in and verified through the RPA cloud, a first communication connection between the RPA cloud and the material list database is established, and a second communication connection between the RPA cloud and the purchase price database is established.
[0060] In steps 1013-1016, there are multiple spaces in the RPA cloud, and an RPA task execution process is started. The framework of the task execution process needs to meet the data format requirements of the BOM database, work order interface data, and procurement database. The task execution process is format checked. After the check result is qualified, the RPA cloud is instructed to log in to the bill of materials database and the preset procurement price database. Because the bill of materials database and the procurement price database are not public libraries, the account verification must be completed before the API interface can be used to connect to the RPA cloud, establish a first communication connection between the RPA cloud and the bill of materials database, and establish a second communication connection between the RPA cloud and the procurement price database.
[0061] Furthermore, in step 1016, the following steps may be performed:
[0062] 10161. Send the authentication token of the RPA cloud to the preset material list database and the preset purchase price database;
[0063] 10162. Receive a first authentication key fed back by the bill of materials database, and receive a second authentication key fed back by the purchase price database;
[0064] 10163. Based on the first authentication key, a first communication connection is established between the RPA cloud and the bill of materials database, and based on the second authentication key, a second communication connection is established between the RPA cloud and the purchase price database.
[0065] In steps 10161-10163, the authentication token is first entered into the RPA cloud, and the RPA cloud acts as an agent to send the authentication token to the bill of materials database and the preset purchase price database, receiving the first authentication key fed back by the bill of materials database, and receiving the second authentication key fed back by the purchase price database. The authentication key is used as the basis for login verification, and the authentication key is the signature data encrypted by the MD5 algorithm.
[0066] 102. Using a preset RPA cloud, access a preset bill of materials database, and perform part number matching processing in the bill of materials database according to part numbers corresponding to N target part names in the target part table to obtain N material data, and combine the N material data to obtain a material data set;
[0067] In this embodiment, the bill of materials database is a BOM database for scenes in the manufacturing industry. The part number corresponding to the target part name in the target part table is matched with the material data. Because the names of the same part may be different for different manufacturers, only the part number is the only basis for verification and matching. The 26 material data A, B, C, ..., X are queried and the 26 material data are combined into a material data set {A, B, C, ..., X}.
[0068] Furthermore, at 102, the following steps may be performed:
[0069] 1021. Read the part number corresponding to a single target part name in the target part table;
[0070] 1022. Based on preset regular rules, match data corresponding to the part number in the bill of materials database to obtain single material data.
[0071] In steps 1021-1022, the part number is matched by using regular rules to match the data corresponding to the part number in the BOM database to obtain single material data, that is, the actual material data in the BOM database. The loop is repeated N times, and the part numbers corresponding to the N target part names in the target part table are matched and queried to obtain N material data.
[0072] 103. Using the preset RPA cloud, access the preset purchase price database, and perform query and combination processing on the material data set according to the purchase price database to obtain a material price combination set;
[0073] In this embodiment, the purchase price database is accessed through the RPA cloud, and then the purchase price database is queried. The purchase price of each material in the material data set {A, B, C, ..., X} is A1, B1, C1, ..., X1, which are combined into the material price combination set {(A, A1), (B, B1), (C, C1) ..., (X, X1)}.
[0074] Furthermore, the following steps may be performed at 103:
[0075] 1031. Extract material data from the material data set to obtain target material data;
[0076] 1032. Based on the part number corresponding to the target material data, query processing is performed in the purchase price database to obtain the purchase price corresponding to the target material data;
[0077] 1033. Combine the target material data and the purchase price to obtain a material price combination element.
[0078] In steps 1031-1033, material data A in the material data set {A, B, C, ..., X} is extracted to obtain target material data A, and then the part number QIOPD8455 of the target material data A is queried in the purchase price database to obtain the purchase price 56.21 corresponding to the target material data A. The target material data A and the purchase price 56.21 are combined to obtain a material price combination element (A, 56.21).
[0079] 104. Based on the number of parts corresponding to each target part name in the target parts table, perform statistical calculations on the material price combination set to obtain a calculated total price corresponding to the target parts table.
[0080] In this embodiment, the material AX of the material price combination set {(A, A1), (B, B1), (C, C1)..., (X, X1)} has corresponding quantities of parts in the target parts table of 5, 7, 6..., 6, then the calculated total price = 5*A1+7*B1+6*C1+...+6*X1.
[0081] Furthermore, at 104, the following steps may be performed:
[0082] 105. Binding and converting the calculated total price and the target parts list to generate a JSON text;
[0083] 106. Upload the JSON text to a preset history database.
[0084] In steps 105-106, 5*A1+7*B1+6*C1+...+6*X1 and the target parts list are first bound and then converted into JSON format to obtain a JSON text of {5*A1+7*B1+6*C1+...+6X1: target parts list}. The JSON text is uploaded to the history database for backup to facilitate subsequent viewing.
[0085] In an embodiment of the present invention, the RPA cloud is used as a data transfer platform to establish a communication connection between the bill of materials database and the procurement system, and the accounting data results are adjusted based on the entered target parts list to ensure the accuracy and timeliness of the accounting data, thereby solving the technical problems of inaccurate accounting and insufficient timeliness of current cost accounting due to the asynchrony of BOM system data and design changes.
[0086] The above describes the cost accounting method based on RPA in the embodiment of the present invention. The following describes the cost accounting device based on RPA in the embodiment of the present invention. Figure 2 In one embodiment of the present invention, a cost accounting device based on RPA is provided. The cost accounting device based on RPA includes:
[0087] The receiving module 201 is used to receive a target part list, wherein the target part list includes: N target part names, part numbers corresponding to the target part names, and part quantities corresponding to the target part names, wherein N is a positive integer;
[0088] A matching module 202 is used to access a preset bill of materials database by using a preset RPA cloud, and to perform part number matching processing in the bill of materials database according to part numbers corresponding to N target part names in the target part table to obtain N material data, and to combine the N material data to obtain a material data set;
[0089] The query combination module 203 is used to use the preset RPA cloud to access the preset purchase price database, and perform query combination processing on the material data set according to the purchase price database to obtain a material price combination set;
[0090] The calculation and statistics module 204 is used to perform calculation and statistics processing on the material price combination set based on the number of parts corresponding to each target part name in the target part table to obtain the calculated total price corresponding to the target part table.
[0091] In an embodiment of the present invention, the RPA cloud is used as a data transfer platform to establish a communication connection between the bill of materials database and the procurement system, and the accounting data results are adjusted based on the entered target parts list to ensure the accuracy and timeliness of the accounting data, thereby solving the technical problems of inaccurate accounting and insufficient timeliness of current cost accounting due to the asynchrony of BOM system data and design changes.
[0092] See also Figure 3 According to another embodiment of the RPA-based cost accounting device in the embodiment of the present invention, the RPA-based cost accounting device includes:
[0093] The receiving module 201 is used to receive a target part list, wherein the target part list includes: N target part names, part numbers corresponding to the target part names, and part quantities corresponding to the target part names, wherein N is a positive integer;
[0094] A matching module 202 is used to access a preset bill of materials database by using a preset RPA cloud, and to perform part number matching processing in the bill of materials database according to part numbers corresponding to N target part names in the target part table to obtain N material data, and to combine the N material data to obtain a material data set;
[0095] The query combination module 203 is used to use the preset RPA cloud to access the preset purchase price database, and perform query combination processing on the material data set according to the purchase price database to obtain a material price combination set;
[0096] The calculation and statistics module 204 is used to perform calculation and statistics processing on the material price combination set based on the number of parts corresponding to each target part name in the target part table to obtain the calculated total price corresponding to the target part table.
[0097] The RPA-based cost accounting device further includes a communication establishment module 205, and the communication establishment module 205 is specifically used for:
[0098] Create an accounting task execution process in the pre-installed RPA cloud;
[0099] Performing data format verification on the accounting task execution process to obtain a verification result;
[0100] Determine whether the verification result is qualified;
[0101] If the verification result is qualified, the preset material list database and the preset purchase price database are logged in and verified through the RPA cloud, a first communication connection between the RPA cloud and the material list database is established, and a second communication connection between the RPA cloud and the purchase price database is established.
[0102] The communication establishment module 205 is further specifically used for:
[0103] Sending the authentication token of the RPA cloud to the preset material list database and the preset purchase price database;
[0104] receiving a first authentication key fed back by the bill of materials database, and receiving a second authentication key fed back by the purchase price database;
[0105] Based on the first authentication key, a first communication connection is established between the RPA cloud and the bill of materials database, and based on the second authentication key, a second communication connection is established between the RPA cloud and the purchase price database.
[0106] The query combination module 203 is specifically used for:
[0107] Extracting material data from the material data set to obtain target material data;
[0108] Based on the part number corresponding to the target material data, query processing is performed in the purchase price database to obtain the purchase price corresponding to the target material data;
[0109] The target material data and the purchase price are combined to obtain a material price combination element.
[0110] The receiving module 201 is specifically used for:
[0111] Receiving a part entry instruction in a preset work order system interface, and writing part data corresponding to the part entry instruction into an edited parts table;
[0112] A confirmation instruction is received, and the edited parts list is confirmed as a target parts list.
[0113] The RPA-based cost accounting device further includes an upload backup module 206, which is specifically used for:
[0114] Binding and converting the calculated total price and the target parts list to generate a JSON text;
[0115] The JSON text is uploaded to a preset history database.
[0116] The matching module 202 is specifically used for:
[0117] Read the part number corresponding to a single target part name in the target part table;
[0118] Based on preset regular rules, data corresponding to the part number is matched in the bill of materials database to obtain single material data.
[0119] In an embodiment of the present invention, the RPA cloud is used as a data transfer platform to establish a communication connection between the bill of materials database and the procurement system, and the accounting data results are adjusted based on the entered target parts list to ensure the accuracy and timeliness of the accounting data, thereby solving the technical problems of inaccurate accounting and insufficient timeliness of current cost accounting due to the asynchrony of BOM system data and design changes.
[0120] above Figure 2 and Figure 3 The RPA-based cost accounting device in the embodiment of the present invention is described in detail from the perspective of modular functional entities. The RPA-based cost accounting device in the embodiment of the present invention is described in detail from the perspective of hardware processing.
[0121] Figure 4 4 is a schematic diagram of the structure of a cost accounting device based on RPA provided by an embodiment of the present invention. The cost accounting device 400 based on RPA may have relatively large differences due to different configurations or performances, and may include one or more processors (central processing units, CPU) 410 (for example, one or more processors) and a memory 420, and one or more storage media 430 (for example, one or more mass storage devices) storing application programs 433 or data 432. Among them, the memory 420 and the storage medium 430 can be short-term storage or persistent storage. The program stored in the storage medium 430 may include one or more modules (not shown in the figure), and each module may include a series of instruction operations in the cost accounting device 400 based on RPA. Furthermore, the processor 410 may be configured to communicate with the storage medium 430 to execute a series of instruction operations in the storage medium 430 on the cost accounting device 400 based on RPA.
[0122] The RPA-based cost accounting device 400 may further include one or more power supplies 440, one or more wired or wireless network interfaces 450, one or more input and output interfaces 460, and / or one or more operating systems 431, such as Windows Serve, Mac OS X, Unix, Linux, Free BSD, etc. It will be appreciated by those skilled in the art that Figure 4 The RPA-based cost accounting device structure shown does not constitute a limitation on the RPA-based cost accounting device, and may include more or fewer components than shown in the figure, or a combination of certain components, or a different arrangement of components.
[0123] The present invention also provides a computer-readable storage medium, which may be a non-volatile computer-readable storage medium or a volatile computer-readable storage medium. Instructions are stored in the computer-readable storage medium. When the instructions are executed on a computer, the computer executes the steps of the RPA-based cost accounting method.
[0124] Those skilled in the art can clearly understand that, for the convenience and brevity of description, the specific working process of the above-described system, device, or unit can refer to the corresponding process in the aforementioned method embodiment and will not be repeated here.
[0125] If the integrated unit is implemented in the form of a software functional unit and sold or used as an independent product, it can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present invention is essentially or the part that contributes to the prior art or all or part of the technical solution can be embodied in the form of a software product. The computer software product is stored in a storage medium, including a number of instructions to enable a computer device (which can be a personal computer, a server, or a network device, etc.) to perform all or part of the steps of the method described in each embodiment of the present invention. The aforementioned storage medium includes: U disk, mobile hard disk, read-only memory (ROM), random access memory (RAM), disk or optical disk and other media that can store program codes.
[0126] As described above, the above embodiments are only used to illustrate the technical solutions of the present invention, rather than to limit the same. Although the present invention has been described in detail with reference to the aforementioned embodiments, those skilled in the art should understand that the technical solutions described in the aforementioned embodiments may still be modified, or some of the technical features thereof may be replaced by equivalents. However, these modifications or replacements do not deviate the essence of the corresponding technical solutions from the spirit and scope of the technical solutions of the embodiments of the present invention.
Claims
1. A cost accounting method based on RPA, characterized in that: Includes steps: Receive a target part list, wherein the target part list includes: N target part names, part numbers corresponding to the target part names, and part quantities corresponding to the target part names, wherein N is a positive integer; Using a preset RPA cloud, accessing a preset bill of materials database, and performing part number matching processing in the bill of materials database according to part numbers corresponding to N target part names in the target part table to obtain N material data, and combining and processing the N material data to obtain a material data set; Using a preset RPA cloud, access a preset purchase price database, perform query and combination processing on the material data set according to the purchase price database, and obtain a material price combination set; Based on the number of parts corresponding to each target part name in the target parts list, the material price combination set is calculated and statistically processed to obtain the total accounting price corresponding to the target parts list; Wherein, before receiving the target parts list, the method further includes: Create an accounting task execution process in the pre-installed RPA cloud; Performing data format verification on the accounting task execution process to obtain a verification result; Determine whether the verification result is qualified; If the verification result is qualified, the preset material list database and the preset purchase price database are logged in and verified through the RPA cloud, a first communication connection between the RPA cloud and the material list database is established, and a second communication connection between the RPA cloud and the purchase price database is established.
2. The RPA-based cost accounting method according to claim 1, characterized in that: The method of performing login verification processing on a preset material list database and a preset purchase price database through the RPA cloud, establishing a first communication connection between the RPA cloud and the material list database, and establishing a second communication connection between the RPA cloud and the purchase price database includes: Sending the authentication token of the RPA cloud to the preset bill of materials database and the preset purchase price database; receiving a first authentication key fed back by the bill of materials database, and receiving a second authentication key fed back by the purchase price database; Based on the first authentication key, a first communication connection is established between the RPA cloud and the bill of materials database, and based on the second authentication key, a second communication connection is established between the RPA cloud and the purchase price database.
3. The RPA-based cost accounting method according to claim 1, characterized in that: The query and combination processing is performed on the material data set according to the purchase price database to obtain a material price combination set including: Extracting material data from the material data set to obtain target material data; Based on the part number corresponding to the target material data, query processing is performed in the purchase price database to obtain the purchase price corresponding to the target material data; The target material data and the purchase price are combined to obtain a material price combination element.
4. The RPA-based cost accounting method according to claim 1, characterized in that: The receiving target parts list includes: Receiving a part entry instruction in a preset work order system interface, and writing part data corresponding to the part entry instruction into an edited parts table; A confirmation instruction is received, and the edited parts list is confirmed as a target parts list.
5. The RPA-based cost accounting method according to claim 1, characterized in that: After calculating and statistically processing the material price combination set based on the number of parts corresponding to each target part name in the target part list to obtain the total accounting price corresponding to the target part list, the method further includes: Binding and converting the calculated total price and the target parts list to generate a JSON text; The JSON text is uploaded to a preset history database.
6. The RPA-based cost accounting method according to claim 1, characterized in that: According to the part numbers corresponding to the N target part names in the target part table, part number matching processing is performed in the bill of materials database to obtain N material data, including: Read the part number corresponding to a single target part name in the target part table; Based on preset regular rules, data corresponding to the part number is matched in the bill of materials database to obtain single material data.
7. A cost accounting device based on RPA, characterized in that: The RPA-based cost accounting device includes: A receiving module, used for receiving a target part list, wherein the target part list includes: N target part names, part numbers corresponding to the target part names, and part quantities corresponding to the target part names, wherein N is a positive integer; A matching module, for accessing a preset bill of materials database by using a preset RPA cloud, and performing part number matching processing in the bill of materials database according to part numbers corresponding to N target part names in the target part table to obtain N material data, and combining the N material data to obtain a material data set; A query combination module is used to use a preset RPA cloud to access a preset purchase price database, and perform query combination processing on the material data set according to the purchase price database to obtain a material price combination set; A calculation and statistics module, used for performing calculation and statistics processing on the material price combination set based on the number of parts corresponding to each target part name in the target part table, to obtain a calculated total price corresponding to the target part table; The RPA-based cost accounting device further includes a communication establishment module, which is specifically used to: Create an accounting task execution process in the pre-installed RPA cloud; Performing data format verification on the accounting task execution process to obtain a verification result; Determine whether the verification result is qualified; If the verification result is qualified, the preset material list database and the preset purchase price database are logged in and verified through the RPA cloud, a first communication connection between the RPA cloud and the material list database is established, and a second communication connection between the RPA cloud and the purchase price database is established.
8. A cost accounting device based on RPA, characterized in that: The RPA-based cost accounting device includes: a memory and at least one processor, the memory stores instructions, and the memory and the at least one processor are interconnected via a line; The at least one processor calls the instructions in the memory so that the RPA-based cost accounting device executes the RPA-based cost accounting method as described in any one of claims 1-6.
9. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the RPA-based cost accounting method according to any one of claims 1 to 6 is implemented.
