CN113362046A - Control method and device for preventing salary generation errors - Google Patents
Control method and device for preventing salary generation errors Download PDFInfo
- Publication number
- CN113362046A CN113362046A CN202110911601.8A CN202110911601A CN113362046A CN 113362046 A CN113362046 A CN 113362046A CN 202110911601 A CN202110911601 A CN 202110911601A CN 113362046 A CN113362046 A CN 113362046A
- Authority
- CN
- China
- Prior art keywords
- file
- payroll
- generation
- wage
- detail information
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
- G06Q10/105—Human resources
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/02—Banking, e.g. interest calculation or account maintenance
Abstract
The invention provides a control method, a device, computer equipment and a computer readable storage medium for preventing errors of salary generation, which are used for data processing for administrative, commercial, financial, management, supervision or prediction purposes, and the method comprises the following steps: acquiring a proxy wage file uploaded by a current user, wherein the proxy wage file comprises a plurality of wage detail information; verifying the secondary payroll file according to at least one preset verification condition, wherein the verification condition comprises the steps of obtaining a history file uploaded by a current user in a preset period, and comparing and verifying the history file and the secondary payroll file; the invention can prevent the error condition when the payroll is generated, and verify whether the payroll is generated or retransmitted, thereby improving the payroll generation efficiency.
Description
Technical Field
The present invention relates to computer technology, and more particularly, to a control method for preventing errors in the generation of salary, a control device for preventing errors in the generation of salary, a computer device, and a computer-readable storage medium.
Background
In the current environment, most enterprises carry out wage generation and mainly operate through enterprise internet banking or a counter of a branch point provided by a bank, in the generation and generation process, the enterprises need to upload batch files (such as Excel files and the like) transmitted at the current generation, and the enterprise internet banking or counter directly carries out batch-by-batch distribution according to detailed contents in the batch files, so that the accuracy of the detailed contents cannot be verified, and whether mistaken transmission exists cannot be verified; meanwhile, when a certain batch is not processed, the enterprise can initiate a new batch generation request again, and the enterprise internet bank or counter is still directly issued one by one according to the detail content in the batch file, so that the possibility that the content in the file and the detail transaction which is not processed and completed are repeated is not verified.
Disclosure of Invention
In view of the defects in the prior art, an object of the present invention is to provide a control method for preventing errors in the generation of salary, a control device for preventing errors in the generation of salary, a computer device and a computer-readable storage medium, which can prevent errors in the generation of salary, verify whether the salary is mistaken or retransmitted, and improve the efficiency of the generation of salary.
According to a first aspect of the present invention, the present invention provides a control method for preventing errors in payroll generation, the control method comprising:
acquiring a generation wage file uploaded by a current user, wherein the generation wage file comprises a plurality of wage detail information;
verifying the generation wage file according to at least one preset verification condition, wherein the verification condition comprises the steps of obtaining a history file uploaded by the current user in a preset period, and comparing and verifying the history file and the generation wage file;
and carrying out fund processing on the payroll detail information passing the verification in the generation payroll file.
Preferably, in an embodiment of the present invention, the step of comparing and verifying the history file and the generation wage file includes:
respectively reading verification parameters of the generation wage file and the history file, wherein the verification parameters comprise file names and/or MD5 codes;
determining whether the verification parameters of the commission agent file and the history file are repeated;
if not, determining that the verification of the proxy payroll file passes;
if yes, the generation wage file is judged to fail to be verified.
Preferably, in an embodiment of the present invention, the step of comparing and verifying the history file and the generation wage file includes:
acquiring identity IDs corresponding to the payroll detail information in the generation payroll file;
traversing each identity ID, and judging whether the payroll detail information repeated by the identity ID exists or not;
if not, determining that the verification of the proxy payroll file passes;
if yes, the generation wage file is judged to fail to be verified.
Preferably, in an embodiment of the present invention, the step of comparing and verifying the history file and the generation wage file includes:
respectively acquiring identity IDs corresponding to the payroll detail information in the generation payroll file and the historical file;
respectively acquiring the payroll values in the generation payroll file based on the same identity ID and taking the indexes as the current payroll values and the payroll values in the historical file based on the same identity ID;
judging whether the floating value between the current payroll value and the historical payroll value corresponding to the same identity ID exceeds a preset floating range or not;
if not, judging that the payroll detail information corresponding to the identity ID passes the verification;
if yes, determining that the payroll detail information corresponding to the identity ID is not verified.
Preferably, in a technical solution of the present invention, when the payroll details information corresponding to the current identity ID fails to be verified, it is determined whether the payroll details information corresponding to the current identity ID includes a verification-free field;
if yes, modifying the payroll detail information corresponding to the identity ID to pass the verification;
if not, keeping the payroll detail information corresponding to the identity ID as the payroll detail information which is not verified;
wherein the authentication-free field comprises any one or a combination of: enrollment, departure, leave, and other items.
Preferably, in an aspect of the present invention, the control method further includes:
when the current user is detected to have unprocessed historical batch files, judging whether the historical batch files and the generation wage files are repeated or not;
when judging whether the historical batch file and the generation wage file are repeated or not, judging any one or combination of the file names, the MD5 codes, the wage detail information, the identity IDs corresponding to the wage detail information and the wage values corresponding to the wage detail information of the historical batch file and the generation wage file;
if not, determining that the verification of the proxy payroll file passes;
if yes, determining that the proxy payroll file fails to be verified;
when the surreptitious payroll file fails to be verified, temporarily storing the repeated payroll detail information of the surreptitious payroll file and the historical batch file into a platform waiting area;
refreshing the processing result of each piece of payroll detail information in the historical batch file according to a preset time interval;
when the processing result of each piece of payroll detail information of the historical batch file is successful, the repeated payroll detail information in the generation payroll file is not processed;
and when the processing result of each piece of payroll detail information of the historical batch file is that the delivery fails, continuously processing the repeated payroll detail information in the generation payroll file.
Preferably, in an aspect of the present invention, the control method further includes:
when the surreptitious payroll file fails to pass the verification, sending prompt information to the current user;
displaying the payroll detail information which fails to be verified in the generation payroll file one by one;
and when a signal of continuous processing fed back by the current user is received, carrying out fund processing on the information of the generation payroll file or carrying out next verification on the generation payroll file.
According to a second aspect of the present invention, there is provided a control device for preventing errors in payroll delivery, the device comprising:
the system comprises an acquisition unit, a processing unit and a processing unit, wherein the acquisition unit is used for acquiring a proxy wage file uploaded by a current user, and the proxy wage file comprises a plurality of wage detail information;
the verification unit is used for verifying the generation wage file according to at least one preset verification condition, wherein the verification condition comprises the steps of obtaining a history file uploaded by the current user in a preset period, and comparing and verifying the history file and the generation wage file;
and the processing unit is used for carrying out fund processing on the payroll detail information passing the verification in the generation payroll file.
According to a third aspect of the embodiments of the present disclosure, a computer device is provided, where the computer device includes a processor, and the processor is configured to implement the steps of the control method for preventing errors in payroll generation according to any one of the above-mentioned technical solutions when executing a computer program stored in a memory.
According to a fourth aspect of the present invention, a computer-readable storage medium is provided, on which a computer program is stored, the computer program, when being executed by a processor, implementing the steps of the control method for preventing payroll errors according to any one of the above technical solutions.
The method is used for data processing for administrative, commercial, financial, management, supervision or prediction purposes, and comprises the steps of firstly acquiring a proxy payroll file uploaded by a current user, wherein the proxy payroll file can be a format file such as an Excel file, a text file or a picture file; the salary detail information is concrete information of the enterprise needing to pay salaries to the employees at this time, and comprises concrete information of the employee names, the employee payroll numbers, the employee card numbers, the employee monthly salary numerical value and the like of the employees; after the generation salary file is obtained, verifying the generation salary file according to preset verification conditions so as to ensure that the currently uploaded generation salary file is accurate; the preset verification condition quantity is at least one item, the preset verification condition comprises the acquisition of a historical file uploaded by a current user in a preset period, and the historical file is a surrogated payroll file uploaded by the user in the past; comparing and verifying the history file and the generation wage file, and checking and verifying the current generation wage file uploaded by the user by taking the history file as a reference so as to avoid the problems that the user uploads the files wrongly or the generation wage file is wrongly recorded and the like; after verification and check, the payroll detail information which passes verification in the generation payroll file is subjected to fund processing, but the payroll detail information in the generation payroll file which does not pass verification is not subjected to fund processing, and the fund processing process comprises the step that a bank transfers payroll to a corresponding employee account according to the details.
Drawings
Other features, objects and advantages of the invention will become more apparent upon reading of the detailed description of non-limiting embodiments with reference to the following drawings:
FIG. 1 is a flow chart illustrating a control method for preventing errors in payroll delivery according to an embodiment of the present invention;
FIG. 2 is a schematic flow chart illustrating a control method for preventing errors in payroll generation according to an embodiment of the present invention;
FIG. 3 is a schematic flow chart illustrating a control method for preventing errors in payroll generation according to an embodiment of the present invention;
FIG. 4 is a schematic flow chart illustrating a control method for preventing errors in payroll generation according to an embodiment of the present invention;
FIG. 5 is a schematic flow chart illustrating a control method for preventing errors in payroll generation according to an embodiment of the present invention;
FIG. 6 shows a schematic block diagram of a computer device provided by one embodiment of the present invention.
Detailed Description
The present invention will be described in detail with reference to specific examples. The following examples will assist those skilled in the art in further understanding the invention, but are not intended to limit the invention in any way. It should be noted that variations and modifications can be made by persons skilled in the art without departing from the spirit of the invention. All falling within the scope of the present invention.
The terms "first," "second," "third," "fourth," and the like in the description and in the claims, as well as in the drawings, if any, are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used is interchangeable under appropriate circumstances such that the embodiments of the invention described herein are, for example, capable of operation in sequences other than those illustrated or otherwise described herein. Furthermore, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed, but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.
The technical solution of the present invention will be described in detail below with specific examples. The following several specific embodiments may be combined with each other, and details of the same or similar concepts or processes may not be repeated in some embodiments.
The following describes the technical solutions of the present invention and how to solve the above technical problems with specific embodiments. The following several specific embodiments may be combined with each other, and details of the same or similar concepts or processes may not be repeated in some embodiments. Embodiments of the present invention will be described below with reference to the accompanying drawings.
The control method for preventing errors in payroll generation according to the disclosed embodiment of the invention will be described in detail with reference to fig. 1 to 5.
As shown in fig. 1, the control method for preventing errors in payroll generation according to the present invention includes:
s102, acquiring a proxy wage file uploaded by a current user, wherein the proxy wage file comprises a plurality of wage detail information;
s104, verifying the generation wage file according to at least one preset verification condition, wherein the verification condition comprises the steps of obtaining a history file uploaded by the current user in a preset period, and comparing and verifying the history file and the generation wage file;
and S106, carrying out fund processing on the payroll detail information passing the verification in the generation payroll file.
In the embodiment, a generation wage file uploaded by a current user is obtained, wherein the generation wage file can be a format file such as an Excel file, a text file or a picture file; the salary detail information is concrete information of the enterprise needing to pay salaries to the employees at this time, and comprises concrete information of the employee names, the employee payroll numbers, the employee card numbers, the employee monthly salary numerical value and the like of the employees; after the generation salary file is obtained, verifying the generation salary file according to preset verification conditions so as to ensure that the currently uploaded generation salary file is accurate; the preset verification condition quantity is at least one item, the preset verification condition comprises the acquisition of a historical file uploaded by a current user in a preset period, and the historical file is a surrogated payroll file uploaded by the user in the past; comparing and verifying the history file and the generation wage file, and checking and verifying the current generation wage file uploaded by the user by taking the history file as a reference so as to avoid the problems that the user uploads the files wrongly or the generation wage file is wrongly recorded and the like; after verification and check, the payroll detail information which passes verification in the generation payroll file is subjected to fund processing, but the payroll detail information in the generation payroll file which does not pass verification is not subjected to fund processing, and the fund processing process comprises the step that a bank transfers payroll to a corresponding employee account according to the details.
Specifically, the specific time period of the preset period may be set by an enterprise, for example, the specific time period is set in a function interface of the method or the apparatus provided by the present invention, if the enterprise does not set, a default period may exist in the system, for example, the default period is the last 30 days or a plurality of same months in a historical year, and the number of files may be one or a plurality of files.
Preferably, the application of the present invention may include corporate banking channels, financial systems, etc.
As shown in fig. 2, in an embodiment of the present invention, the step of comparing the history file with the generation payroll file for verification includes:
s202, reading the file names of the generation wage file and the history file respectively;
s204, judging whether the file names of the generation wage file and the history file are repeated or not;
s206, if not, determining that the verification of the proxy payroll file passes;
and S208, if so, determining that the proxy payroll file fails to be verified.
In this embodiment, the file names of the surrogated payroll file and the history file are read respectively, whether the file names of the surrogated payroll file and the history file are repeated or not is judged, if the file names of the surrogated payroll file and the history file are not repeated, the surrogated payroll file is judged to be verified to be passed, and if the file names of the surrogated payroll file and the history file are repeated, the surrogated payroll file is judged to be not verified to be passed.
For example, the file for reading the generative wage file is "2021 year 7 month wage table of a company a", the file name of the historical file is "2021 year 6 month wage table of a company a" and "2021 year 5 month wage table of a company a", at this time, the file names of the generative wage file and the historical file are not repeated, which indicates that the possibility that an operator selects the file incorrectly is eliminated; for another example, the file for reading the generation wage file is "2021 year 7 month wage table of a company a", the file name of the history file is "2021 year 7 month wage table of a company a" and "2021 year 5 month wage table of a company a", at this time, the generation wage file and the file name of the history file are repeated (including partial repetition), at this time, it indicates that there is a possibility that an operator selects the file incorrectly, and the current generation wage file cannot be verified and cannot be directly issued.
As shown in fig. 3, in an embodiment of the present invention, the step of comparing the history file with the generation payroll file for verification includes:
s302, respectively reading MD5 codes of the generation wage file and the history file;
s304, judging whether the MD5 codes of the generation wage file and the history file are repeated or not;
s306, if not, determining that the verification of the proxy payroll file passes;
and S308, if yes, determining that the proxy payroll file cannot be verified.
In this embodiment, MD5 codes (MD 5 Message-Digest Algorithm) of the surname payroll file and the history file are read respectively, whether the MD5 codes of the surname payroll file and the history file are repeated is determined, when the surname payroll file and the history file are not repeated, the surname payroll file is determined to pass verification, and when the surname payroll file and the history file are repeated, the surname payroll file is determined to fail verification.
In an embodiment of the present invention, the step of comparing and verifying the history file and the generation wage file includes:
acquiring identity IDs corresponding to the payroll detail information in the generation payroll file;
traversing each identity ID, and judging whether the payroll detail information repeated by the identity ID exists or not;
if not, determining that the verification of the proxy payroll file passes;
if yes, the generation wage file is judged to fail to be verified.
In this embodiment, an identity ID corresponding to each piece of payroll detail information in the generation payroll file is obtained, where the identity ID may be an identity card number, an employee payroll number, an employee card number, or other information that can uniquely identify and encode an employee; traversing each identity ID, and judging whether the payroll detail information repeated by the identity ID exists, namely judging whether the same identity ID exists in the same generation payroll file, judging that the generation payroll file passes the verification when the identity ID does not exist, and judging that the generation payroll file fails to pass the verification when the identity ID exists; the uniqueness is confirmed through the identity ID in the file, whether multiple generation invention detailed records with the same identity ID exist in one file or not is verified, and therefore repeated records of generation and issuance of one person and multiple persons caused by human errors when enterprise operators manufacture the generation and issuance files are prevented.
Preferably, in an embodiment of the present invention, the step of comparing and verifying the history file and the generation payroll file includes:
respectively acquiring identity IDs corresponding to the payroll detail information in the generation payroll file and the historical file;
respectively acquiring the payroll values in the generation payroll file based on the same identity ID and taking the indexes as the current payroll values and the payroll values in the historical file based on the same identity ID;
judging whether the floating value between the current payroll value and the historical payroll value corresponding to the same identity ID exceeds a preset floating range or not;
if not, judging that the payroll detail information corresponding to the identity ID passes the verification;
if yes, determining that the payroll detail information corresponding to the identity ID is not verified;
when the payroll detail information corresponding to the identity ID cannot be verified, judging whether the payroll detail information corresponding to the identity ID contains a verification-free field or not;
if yes, modifying the payroll detail information corresponding to the identity ID to pass the verification;
if not, keeping the payroll detail information corresponding to the identity ID as the payroll detail information which is not verified;
wherein the authentication-free field comprises any one or a combination of: enrollment, departure, leave, and other items.
In this embodiment, the identity IDs corresponding to the payroll details in the generation payroll file and the history file are respectively obtained, where the identity IDs may be information such as an identity card number, an employee payroll number, and an employee card number that can uniquely identify and encode an employee; respectively acquiring the wage value of the identity ID in a generation wage file based on the same identity ID, indexing the wage value as the current wage value, acquiring the wage value of the identity ID in the historical file, and indexing the wage value as the historical wage value, namely acquiring the wage value to be issued in the current month and the wage value issued in the historical month of the same employee; judging whether a floating value between the current payroll value and the historical payroll value corresponding to the same identity ID exceeds a preset floating range, wherein the floating value can be a floating proportion and/or a floating amount, and if not, judging that the payroll detail information corresponding to the current identity ID passes verification; if yes, determining that the payroll detail information corresponding to the identity ID is not verified; when the payroll detail information corresponding to the identity ID cannot be verified, judging whether the payroll detail information corresponding to the identity ID contains a verification-free field; the authentication-free field comprises any one or a combination of: enrollment, departure, leave, and other items; if yes, modifying the payroll detail information corresponding to the identity ID to pass the verification; if not, keeping the payroll detail information corresponding to the identity ID as the payroll detail information which is not verified; the verification aims to verify the file details uploaded by the enterprise one by one, and verify whether the details of the enterprise have a salary detail exceeding a preset floating range of the enterprise or not by performing floating comparison with the historical salary records of each person in the details so as to pre-judge whether an abnormal condition exists or not;
in the verification process of the floating amount details, for the situation that the enterprise does not have historical payoff data (such as newly added employees) or the enterprise employees cause the generation details abnormity due to the situations of entering into/leaving/asking for leave and the like, the enterprise can set whether to carry out verification-free on the data or not through the floating amount verification rule, for example, fields of entering and leaving states and asking for leave states of the employees are added in the generation file, and the system carries out verification-free on the generation details according to the field contents so as to improve the accuracy of the verification process and reduce the interference.
Preferably, the preset floating range of the enterprise can be set by each enterprise independently, and the setting items can include data such as historical payroll association checking times (default 1 time), floating proportion (default 50%)/floating amount (default 3000 yuan), and the like.
In one embodiment of the present invention, the control method further includes:
when the current user is detected to have unprocessed historical batch files, judging whether the historical batch files and the generation wage files are repeated or not;
when judging whether the historical batch file and the generation wage file are repeated or not, judging any one or combination of the file names, the MD5 codes, the wage detail information, the identity IDs corresponding to the wage detail information and the wage values corresponding to the wage detail information of the historical batch file and the generation wage file;
if not, determining that the verification of the proxy payroll file passes;
if yes, determining that the proxy payroll file fails to be verified;
when the surreptitious payroll file fails to be verified, temporarily storing the repeated payroll detail information of the surreptitious payroll file and the historical batch file into a platform waiting area;
refreshing the processing result of each piece of payroll detail information in the historical batch file according to a preset time interval;
when the processing result of each piece of payroll detail information of the historical batch file is successful, the repeated payroll detail information in the generation payroll file is not processed;
and when the processing result of each piece of payroll detail information of the historical batch file is that the delivery fails, continuously processing the repeated payroll detail information in the generation payroll file.
In this embodiment, when it is detected that the current user has an unprocessed historical batch file, it is determined whether there is a duplication between the historical batch file and the surrogated payroll file; if not, determining that the verification of the proxy payroll file passes; if yes, determining that the proxy payroll file fails to be verified; this step is intended to verify whether there is an unprocessed completed historical batch file. If the unprocessed batch files exist, whether records (including names, identification numbers, card numbers and money amounts) in the specifications of the incomplete historical batch files of the enterprise are consistent with the specifications in the generation file or not is verified, so that repeated issuing requests of the historical batch files are prevented from being performed again when the unprocessed batch files are not completed.
When the surrogated payroll file fails to be verified, the payroll detail information repeated with the historical batch file in the surrogated payroll file is temporarily stored in a platform waiting area, namely, the repeated part of detail is temporarily stored, the transaction records of the batch consistent with the detail in the historical unprocessed batch are temporarily stored in a platform waiting list, the detail in the historical unprocessed batch is refreshed at regular time, and the processing result of the detail is judged. If the final processing result is successful, the same detail record in the waiting list is not processed; and if the final processing result of the detail in the history unprocessed completion is failure, performing fund processing on the same detail record in the waiting list.
Preferably, when determining whether the historical batch file and the generation payroll file are duplicated, the determination may be made as to any one or combination of the file name, MD5 code, payroll details, the identity ID corresponding to each piece of payroll details, and the payroll value corresponding to each piece of payroll details;
as shown in fig. 4, in an embodiment of the present invention, the control method further includes:
s402, when the surreptitious wage file fails to pass the verification, sending prompt information to the current user;
s404, displaying the payroll detail information which fails to pass verification in the generation payroll file one by one;
s406, when a signal of continuing processing fed back by the current user is received, carrying out fund processing on the information of the generation payroll file or carrying out next verification on the generation payroll file.
In this embodiment, when the surreptitious payroll file fails to be verified, a prompt message is sent to the current user; displaying the payroll detail information which fails to be verified in the generation payroll file one by one; and displaying whether the option is continued or not until the user selects, and when receiving a signal of continuing processing fed back by the current user, indicating that the user confirms by himself, and carrying out fund processing on the information of the alternative payroll file or carrying out the next verification on the alternative payroll file. And prompting the enterprise operators that the salary table file sent by the enterprise operator at this time is not verified, and confirming whether to continue processing or not by the operators. After the operator verifies the prompt, if the operator chooses not to continue the issuing, the process is ended; if the release is selected to be continued, the release is continued.
Preferably, a plurality of verification conditions of the present application may perform combined verification, and the order of the combined verification may be selected by itself.
The invention aims at identifying and reminding false issuance caused by human errors in the process of carrying out the generation and payment of wages by enterprises through bank channels, and can find out problems before formally initiating transactions; aiming at the problem that repeated issuing is generated in the re-issuing process after the transaction is unknown due to system abnormity in the process of issuing wages by enterprises through bank channels, the repeated issuing problem can be judged in time, and the retransmitted data can be identified and prevented while the user experience is not influenced; the identification and processing of enterprise retransmission/wrong transmission do not affect the normal use process of users, noninductive optimization is achieved, and high processing cost caused by wrong transmission/wrong transmission is reduced for banks through the effect of the invention.
The specific embodiment is as follows:
as shown in fig. 5, a specific embodiment provided by the present invention, step 1 is to verify the file name of the proxy file uploaded by the enterprise, and to verify whether there are files with identical file names in a certain fixed period. If the file name is not repeated, entering the step 2; and if the file name is verified to be repeated, the method enters the step 1.2, and prompts enterprise operators that the salary table file sent by the enterprise operators at this time is a repeated file, and the enterprise operators confirm whether to continue processing or not. After the operator verifies the prompt, if the operator chooses not to continue the issuing, the process is ended; if the user chooses to continue the issuing, the verification link of the step 2 is also entered.
And 2, verifying the whole file content of the generation file uploaded by the enterprise, and verifying whether the same generation file is uploaded and processed in a fixed period by comparing the MD5 values of the generation file. If the verification file is not a repeated file, entering the verification of step 3; and if the verification file is a repeated file, the step 2.1 is carried out, the verification result is displayed to enterprise operators, and the operators distinguish and select whether to continue to issue or not. After the operator verifies the prompt, if the operator chooses not to continue the issuing, the process is ended; if the release is selected to continue, the processing link of the step 3 is also entered.
And 4, verifying the generation document details uploaded by the enterprise one by one, and verifying whether the generation document details of the batch of details have the details exceeding the preset floating range of the enterprise or not by performing floating comparison with the historical payment records of each person in the details. The preset floating range of the enterprise can be set by each enterprise independently through the matched interface in the step 4.1, and if the fact that the details exceeding the floating amount do not exist is verified, the step 5 is carried out; if the details exceeding the floating amount exist, the step 4.2 is entered, the identified abnormal data possibly exist is displayed, enterprise operators confirm the data item by item, whether the details are wrong is checked, and whether the details are continuously issued is selected. After the operator verifies the prompt, if the operator chooses not to continue the issuing, the process is ended; if the release is selected to continue, the processing link of step 5 is also entered.
Supplementary description of step 4: in the verification process of the floating amount details, for the situation that the enterprise does not have historical payroll data (newly added employees) or the enterprise employees enter/leave due to other scenes, the enterprise can set whether to perform verification-free on the data or not by setting in the floating amount verification rule in the step 4.1. If the selection is yes, fields of employee attendance and leave states need to be added in the generation document, and the system does not need to verify the details according to the contents of the fields. If the enterprise does not select the data to be free from verification, the system can display the abnormal data caused by employee attendance/leave in the process of displaying the abnormal data in the step 4.2, and the abnormal data is checked one by enterprise operators, so that the generation detailed file is more accurate.
And 5, verifying whether the unprocessed historical batch files exist when the enterprise uploads the file at the current time. If the unprocessed batch files do not exist, entering step 6; if the unprocessed batch files exist, the step 5.1 is carried out, and whether records (namely the name, the identity card number, the card number and the amount of money) in the incomplete historical batch file details of the enterprise are consistent with the details in the generation and distribution file are verified, so that repeated issuing requests of the historical batch files are prevented when the unprocessed batch files are not completed. If the step 5.1 verifies that the detail record consistent with the batch file does not exist in the unprocessed batch file, the step 6 is normally executed; if the document exists in the detail record consistent with the batch of documents, the step 5.2 is entered, the identified details which are possibly repeatedly issued are displayed, enterprise operators confirm the details one by one, check whether the details are wrong or not, and select whether the details are continuously issued or not. After the operator verifies the prompt, if the operator chooses not to continue the issuing, the process is ended; if the release is selected to continue, step 5.3 is entered.
Step 5.3, the fund processing of step 6 is carried out on the details which are not contained in the historical unprocessed finished batches in the files of the batch; and temporarily storing the transaction records of the batch, which are consistent with the details in the historical unprocessed batches, in a platform issuing waiting list, refreshing the details in the historical unprocessed batches at regular time, and judging the processing result of the details. If the final processing result is successful, the same detail record in the waiting list is not processed; if the final processing result of the detail in the history unprocessed completion is failure, the same detail record in the waiting list is processed for the fund in the step 6.
Finally, step 6 is to process the fund for the transaction detail passing the verification through the multi-node verification link of the invention.
According to a second aspect of the present invention, there is provided a control device for preventing errors in payroll delivery, the device comprising:
the system comprises an acquisition unit, a processing unit and a processing unit, wherein the acquisition unit is used for acquiring a proxy wage file uploaded by a current user, and the proxy wage file comprises a plurality of wage detail information;
the verification unit is used for verifying the generation wage file according to at least one preset verification condition, wherein the verification condition comprises the steps of obtaining a history file uploaded by the current user in a preset period, and comparing and verifying the history file and the generation wage file;
and the processing unit is used for carrying out fund processing on the payroll detail information passing the verification in the generation payroll file.
As shown in fig. 6, according to a third aspect of the present invention, a computer device 40 is proposed, which comprises a processor 404, wherein the processor 404 is configured to implement the steps of the control method for preventing payroll errors as described in any one of the above-mentioned solutions of the first aspect when executing the computer program stored in the memory 402.
According to a fourth aspect of the present invention, a computer-readable storage medium is provided, on which a computer program is stored, the computer program, when being executed by a processor, implementing the steps of the control method for preventing payroll errors according to any one of the above technical solutions.
The units in the computer device of the disclosed embodiment of the invention can be merged, divided and deleted according to actual needs.
The invention carries out self-checking on the detail data in the generation file, including whether one person or a plurality of details exist in the same file, and whether the generation amount fluctuation of each detail is within a preset range; verifying whether the issuing file is repeated and whether a re-issuing request exists in the transaction record with unknown state of the enterprise; supporting enterprises to flexibly configure repeated data checking rules, issuing the preset range of the amount fluctuation data, supporting the display of abnormal data identified by the system, and automatically selecting whether to continue after the abnormal data is confirmed by the enterprises, namely ensuring that the data possibly causing the abnormality is identified for the verification of users, and ensuring that the enterprises repeatedly issue salaries under the normal condition; after multiple verification is added, operation experience of enterprises is realized to be 'no perception', namely the whole verification is high in effectiveness, users use the system interactively friendly, and next operation can be simply carried out through various exception handling guidance of the system. The invention can reduce the probability of the occurrence of wrong sending and retransmission problems in the enterprise wage sending process by more than 85 percent; the invention can reduce 45% of workload in the process of checking and solving the problem of the issue wage business by bank business personnel, customer service personnel, technical personnel and operation and maintenance personnel; the average processing time of the added verification module system is less than 1s, the generation experience of the client is slightly influenced, and the generation accuracy of the client is obviously improved.
As will be appreciated by one skilled in the art, embodiments of the present invention may be provided as a method, apparatus (system) or computer program product. Accordingly, the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present invention may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The embodiments in the present description are described in a progressive manner, each embodiment focuses on differences from other embodiments, and the same and similar parts among the embodiments are referred to each other. The previous description of the disclosed embodiments is provided to enable any person skilled in the art to make or use the present invention. Various modifications to these embodiments will be readily apparent to those skilled in the art, and the generic principles defined herein may be applied to other embodiments without departing from the spirit or scope of the invention. Thus, the present invention is not intended to be limited to the embodiments shown herein but is to be accorded the widest scope consistent with the principles and novel features disclosed herein.
The foregoing description of specific embodiments of the present invention has been presented. It is to be understood that the present invention is not limited to the specific embodiments described above, and that various changes and modifications may be made by one skilled in the art within the scope of the appended claims without departing from the spirit of the invention.
Claims (10)
1. A control method for preventing errors of payroll generation is characterized by comprising the following steps:
acquiring a generation wage file uploaded by a current user, wherein the generation wage file comprises a plurality of wage detail information;
verifying the generation wage file according to at least one preset verification condition, wherein the verification condition comprises the steps of obtaining a history file uploaded by the current user in a preset period, and comparing and verifying the history file and the generation wage file;
and carrying out fund processing on the payroll detail information passing the verification in the generation payroll file.
2. The method as claimed in claim 1, wherein the step of comparing the historical file with the generation payroll file comprises:
respectively reading verification parameters of the generation wage file and the history file, wherein the verification parameters comprise file names and/or MD5 codes;
determining whether the verification parameters of the commission agent file and the history file are repeated;
if not, determining that the verification of the proxy payroll file passes;
if yes, the generation wage file is judged to fail to be verified.
3. The method as claimed in claim 1, wherein the step of comparing the historical file with the generation payroll file comprises:
acquiring identity IDs corresponding to the payroll detail information in the generation payroll file;
traversing each identity ID, and judging whether the payroll detail information repeated by the identity ID exists or not;
if not, determining that the verification of the proxy payroll file passes;
if yes, the generation wage file is judged to fail to be verified.
4. The method as claimed in claim 1, wherein the step of comparing the historical file with the generation payroll file comprises:
respectively acquiring identity IDs corresponding to the payroll detail information in the generation payroll file and the historical file;
respectively acquiring the payroll values in the generation payroll file based on the same identity ID and taking the indexes as the current payroll values and the payroll values in the historical file based on the same identity ID;
judging whether the floating value between the current payroll value and the historical payroll value corresponding to the same identity ID exceeds a preset floating range or not;
if not, judging that the payroll detail information corresponding to the identity ID passes the verification;
if yes, determining that the payroll detail information corresponding to the identity ID is not verified.
5. The method of claim 4, wherein the payroll failure prevention control method,
when the payroll detail information corresponding to the identity ID cannot be verified, judging whether the payroll detail information corresponding to the identity ID contains a verification-free field or not;
if yes, modifying the payroll detail information corresponding to the identity ID to pass the verification;
if not, keeping the payroll detail information corresponding to the identity ID as the payroll detail information which is not verified;
wherein the authentication-free field comprises any one or a combination of: enrollment, departure, leave, and other items.
6. The control method for preventing salary errors according to claim 1, wherein the control method further comprises:
when the current user is detected to have unprocessed historical batch files, judging whether the historical batch files and the generation wage files are repeated or not;
when judging whether the historical batch file and the generation wage file are repeated or not, judging any one or combination of the file names, the MD5 codes, the wage detail information, the identity IDs corresponding to the wage detail information and the wage values corresponding to the wage detail information of the historical batch file and the generation wage file;
if not, determining that the verification of the proxy payroll file passes;
if yes, determining that the proxy payroll file fails to be verified;
when the surreptitious payroll file fails to be verified, temporarily storing the repeated payroll detail information of the surreptitious payroll file and the historical batch file into a platform waiting area;
refreshing the processing result of each piece of payroll detail information in the historical batch file according to a preset time interval;
when the processing result of each piece of payroll detail information of the historical batch file is successful, the repeated payroll detail information in the generation payroll file is not processed;
and when the processing result of each piece of payroll detail information of the historical batch file is that the delivery fails, continuously processing the repeated payroll detail information in the generation payroll file.
7. The control method for preventing salary errors according to any one of claims 1 to 6, wherein the control method further comprises:
when the surreptitious payroll file fails to pass the verification, sending prompt information to the current user;
displaying the payroll detail information which fails to be verified in the generation payroll file one by one;
and when a signal of continuous processing fed back by the current user is received, carrying out fund processing on the information of the generation payroll file or carrying out next verification on the generation payroll file.
8. A control device for preventing errors in the generation of payroll information, the device comprising:
the system comprises an acquisition unit, a processing unit and a processing unit, wherein the acquisition unit is used for acquiring a proxy wage file uploaded by a current user, and the proxy wage file comprises a plurality of wage detail information;
the verification unit is used for verifying the generation wage file according to at least one preset verification condition, wherein the verification condition comprises the steps of obtaining a history file uploaded by the current user in a preset period, and comparing and verifying the history file and the generation wage file;
and the processing unit is used for carrying out fund processing on the payroll detail information passing the verification in the generation payroll file.
9. A computer device, characterized in that the computer device comprises a processor for implementing the steps of the control method for preventing payroll errors according to any one of claims 1 to 7 when executing a computer program stored in a memory.
10. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the steps of the control method for preventing errors in payroll delivery according to any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110911601.8A CN113362046A (en) | 2021-08-10 | 2021-08-10 | Control method and device for preventing salary generation errors |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110911601.8A CN113362046A (en) | 2021-08-10 | 2021-08-10 | Control method and device for preventing salary generation errors |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113362046A true CN113362046A (en) | 2021-09-07 |
Family
ID=77540753
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110911601.8A Pending CN113362046A (en) | 2021-08-10 | 2021-08-10 | Control method and device for preventing salary generation errors |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113362046A (en) |
Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8666893B1 (en) * | 2009-01-05 | 2014-03-04 | Bank Of America Corporation | Electronic funds transfer authentication system |
| CN105243519A (en) * | 2015-11-13 | 2016-01-13 | 广州市社会保险基金管理中心 | Social security finance and accounting management and control system |
| CN107306274A (en) * | 2016-04-18 | 2017-10-31 | 北京市神州百戏文化产业有限公司 | Data de-duplication method based on digital digest |
| CN109213738A (en) * | 2018-11-20 | 2019-01-15 | 武汉理工光科股份有限公司 | A kind of cloud storage file-level data de-duplication searching system and method |
| CN109241009A (en) * | 2018-08-21 | 2019-01-18 | 中国平安人寿保险股份有限公司 | Prevent file from repeating the method and its control method and device that upload |
| CN109785104A (en) * | 2019-01-23 | 2019-05-21 | 常州市第二人民医院 | A kind of financial data management method and system |
| CN110033362A (en) * | 2018-11-14 | 2019-07-19 | 阿里巴巴集团控股有限公司 | One kind beating money method, device and equipment |
| CN110503567A (en) * | 2019-08-15 | 2019-11-26 | 中国平安财产保险股份有限公司 | Data verification method, equipment, storage medium and device |
| CN111986012A (en) * | 2020-08-26 | 2020-11-24 | 北京中电普华信息技术有限公司 | Financial data processing method and device, electronic equipment and computer storage medium |
-
2021
- 2021-08-10 CN CN202110911601.8A patent/CN113362046A/en active Pending
Patent Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8666893B1 (en) * | 2009-01-05 | 2014-03-04 | Bank Of America Corporation | Electronic funds transfer authentication system |
| CN105243519A (en) * | 2015-11-13 | 2016-01-13 | 广州市社会保险基金管理中心 | Social security finance and accounting management and control system |
| CN107306274A (en) * | 2016-04-18 | 2017-10-31 | 北京市神州百戏文化产业有限公司 | Data de-duplication method based on digital digest |
| CN109241009A (en) * | 2018-08-21 | 2019-01-18 | 中国平安人寿保险股份有限公司 | Prevent file from repeating the method and its control method and device that upload |
| CN110033362A (en) * | 2018-11-14 | 2019-07-19 | 阿里巴巴集团控股有限公司 | One kind beating money method, device and equipment |
| CN109213738A (en) * | 2018-11-20 | 2019-01-15 | 武汉理工光科股份有限公司 | A kind of cloud storage file-level data de-duplication searching system and method |
| CN109785104A (en) * | 2019-01-23 | 2019-05-21 | 常州市第二人民医院 | A kind of financial data management method and system |
| CN110503567A (en) * | 2019-08-15 | 2019-11-26 | 中国平安财产保险股份有限公司 | Data verification method, equipment, storage medium and device |
| CN111986012A (en) * | 2020-08-26 | 2020-11-24 | 北京中电普华信息技术有限公司 | Financial data processing method and device, electronic equipment and computer storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US20140025548A1 (en) | Automated anomaly detection for real estate transactions | |
| US11282073B2 (en) | Multi-party payment card processing systems and methods with friendly fraud detection | |
| CN114331315A (en) | Social security service processing method and device combining RPA and AI | |
| CN113420057A (en) | Account checking data processing method and related device | |
| CN107181721A (en) | A kind of information processing method and device based on daily record | |
| CN111353841B (en) | Document data processing method, device and system | |
| CN112116306A (en) | Medical reconciliation method based on T +0/N combination | |
| CN113362046A (en) | Control method and device for preventing salary generation errors | |
| KR101667644B1 (en) | The system which supports a verification process about the truth of a user information | |
| CN114255134A (en) | Account number disassembling method and device and storage medium | |
| US11176785B1 (en) | Detection of dispensing errors in automated teller machines | |
| CN112990871A (en) | Document processing method and related equipment | |
| CN111768547A (en) | Method, device and system for automatically verifying authenticity and verifying weight of invoice | |
| US20180336563A1 (en) | Electronic payment card systems and methods with rogue authorization charge identification and resolution | |
| CN112767593B (en) | Traffic card owner identification method, device, equipment and storage medium | |
| CN116128669A (en) | Processing system, method, electronic equipment and storage medium for summarizing tax return data | |
| CN115187339A (en) | Business order information processing method and device based on artificial intelligence | |
| CN117252606A (en) | Product qualification checking method, device and equipment | |
| CN116934452A (en) | Counter business handling method, device, equipment and storage medium | |
| CN116909844A (en) | Resource interaction information early warning method and device, computer equipment and storage medium | |
| CN117635230A (en) | Abnormality processing method, abnormality processing device, electronic equipment and storage medium | |
| JPS58142475A (en) | Transaction processor | |
| CN114331653A (en) | Processing method and device for to-and-fro ledger data | |
| CN117436822A (en) | Intelligent declaration automatic creation system | |
| CN113962803A (en) | Financial business data processing method and device, storage medium and electronic equipment |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20210907 |
|
| RJ01 | Rejection of invention patent application after publication |