CN112699137A - Cross-system financial data processing method and device - Google Patents
Cross-system financial data processing method and device Download PDFInfo
- Publication number
- CN112699137A CN112699137A CN202110004074.2A CN202110004074A CN112699137A CN 112699137 A CN112699137 A CN 112699137A CN 202110004074 A CN202110004074 A CN 202110004074A CN 112699137 A CN112699137 A CN 112699137A
- Authority
- CN
- China
- Prior art keywords
- data
- accounting
- source system
- target
- target system
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
- 238000003672 processing method Methods 0.000 title claims abstract description 13
- 238000012937 correction Methods 0.000 claims abstract description 40
- 238000000034 method Methods 0.000 claims abstract description 29
- 238000012545 processing Methods 0.000 claims description 18
- 238000012163 sequencing technique Methods 0.000 claims description 18
- 238000012790 confirmation Methods 0.000 claims description 17
- 238000004458 analytical method Methods 0.000 claims description 9
- 230000009286 beneficial effect Effects 0.000 description 10
- 230000010354 integration Effects 0.000 description 4
- 230000006870 function Effects 0.000 description 3
- 230000006872 improvement Effects 0.000 description 3
- 230000008569 process Effects 0.000 description 3
- 238000010586 diagram Methods 0.000 description 2
- 230000002457 bidirectional effect Effects 0.000 description 1
- 230000005540 biological transmission Effects 0.000 description 1
- 238000004590 computer program Methods 0.000 description 1
- 230000008878 coupling Effects 0.000 description 1
- 238000010168 coupling process Methods 0.000 description 1
- 238000005859 coupling reaction Methods 0.000 description 1
- 230000003993 interaction Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 238000012795 verification Methods 0.000 description 1
- 230000000007 visual effect Effects 0.000 description 1
Images
Classifications
-
- 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/23—Updating
- G06F16/2308—Concurrency control
-
- 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/23—Updating
- G06F16/2358—Change logging, detection, and notification
-
- 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/23—Updating
- G06F16/2365—Ensuring data consistency and integrity
-
- 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/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2474—Sequence data queries, e.g. querying versioned data
-
- 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/24—Querying
- G06F16/248—Presentation of query results
-
- 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/12—Accounting
- G06Q40/125—Finance or payroll
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Business, Economics & Management (AREA)
- Finance (AREA)
- Accounting & Taxation (AREA)
- Computational Linguistics (AREA)
- Fuzzy Systems (AREA)
- Computer Security & Cryptography (AREA)
- Mathematical Physics (AREA)
- Probability & Statistics with Applications (AREA)
- Software Systems (AREA)
- Development Economics (AREA)
- Economics (AREA)
- Marketing (AREA)
- Strategic Management (AREA)
- Technology Law (AREA)
- General Business, Economics & Management (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The invention relates to a cross-system financial data processing method, belongs to the technical field of financial management, and solves the problem of low work efficiency of cross-system financial checking in the prior art. The method comprises the following steps: the source system receives a designated account checking instruction input by a user, searches all target systems related to the designated account, and respectively generates an input message aiming at each target system; after receiving the input corresponding message, the target system analyzes the message, locks the account data corresponding to the specific subject code, generates a data message containing the account data and the locking time, and feeds the data message back to the source system; and after receiving the data messages fed back by all the target systems, the source system locks the accounting data corresponding to all the account codes in the data messages, sequentially checks the financial data fed back by the target systems and the accounting data correspondingly locked by the source system, sends inconsistent check information to an administrator for manual correction, and updates the accounting data corresponding to the target systems and/or the source systems in real time according to the corrected information.
Description
Technical Field
The invention relates to the technical field of financial management, in particular to a cross-system financial data processing method and device.
Background
The heterogeneous systems applied by the group-level enterprise are managed independently, the service occurs in which system, the certificate is generated in which system, and a bidirectional integration mode is adopted to ensure that complete certificates and financial data exist between the heterogeneous systems. Due to the problems of integration interfaces and channels, asynchronous main data information, non-uniform accounting control rules of heterogeneous systems, selection errors of unclosed information, selection errors of information of customer suppliers, business personnel not performing financial processing on corresponding systems according to interface division and the like, the success rate of voucher integration cannot reach 100%.
After the integration fails, because one party has already booked and the other party does not receive the certificate, the financial data of the two parties are inconsistent, the two parties need to manually log in the heterogeneous system to derive the financial data respectively, and then the financial data is checked with great time and energy offline.
In order to continuously improve the group management and control capability, the accounting data of the heterogeneous system generates an online automatic data checking requirement. Because each system is relatively independent, the accounting management level and mode have great difference, and the accounting locking and accounting data checking coupling degree is very high, if the administrator divides the front and back step operation, not only the operation step is tedious, increases the operation difficulty and time, still can cause because the time difference leads to influencing each system business execution, leads to work inefficiency.
Disclosure of Invention
In view of the foregoing analysis, embodiments of the present invention provide a cross-system financial data processing method and apparatus, so as to solve the problem of low work efficiency of cross-system financial transaction checking in the prior art.
In one aspect, an embodiment of the present invention provides a cross-system financial data processing method, including the following steps:
the method comprises the steps that a source system receives an appointed account checking instruction input by a user, searches all target systems related to appointed accounts, respectively generates input messages containing locking time and subject codes for each target system, and sends the input messages to the corresponding target systems;
after receiving the corresponding input message, the target system analyzes the message, locks the accounting data corresponding to each account code, generates a data message containing the accounting data and the locking time, and feeds the data message back to the source system;
after the source system receives the data messages fed back by all the target systems, the accounting data corresponding to all the subject codes in the source system are locked, the financial data in the data messages fed back by the target systems and the accounting data correspondingly locked by the source system are checked in sequence, inconsistent check information is sent to an administrator for manual correction, and the accounting data corresponding to the target systems and/or the source system are updated in real time according to the corrected information until the check processing of all the designated accounting data between the source system and the target system is completed.
The beneficial effects of the above technical scheme are as follows: the method can realize one-key quick generation of different target system messages (input messages), one-key completion of financial locking and corresponding financial checking, intelligent identification of differentiated multi-system financial data, online sending of messages to managers through a source system, offline timely correction of checked financial data, no need of manual intervention for checking financial data, simple operation process, one-key completion of all data checking functions, liberation of productivity and improvement of work efficiency of financial staff.
Based on the further improvement of the method, the specified account checking instruction comprises locking time, unit code and subject code;
the searching all target systems related to the designated account, and generating input messages containing locking time and subject codes for each target system respectively, further includes:
searching all target system interface fields corresponding to the unit codes and the subject codes;
generating an input message containing locking time and subject codes for each target system according to the obtained interface field of each target system and a preset template format; wherein the preset template format is as follows: target system interface field + unit code + lock time + lock switch command + subject code.
The beneficial effects of the above further improved scheme are: the input message of each target system is generated through a uniform template format, the function can manually configure and adjust the message format on the foreground of the source system on line, the message is not required to be generated through background codes, and interface data transmission is more flexible and convenient.
Further, after receiving the corresponding input message, the target system analyzes the message, locks the accounting data corresponding to each account code, and generates a data message including the accounting data and the locking time, further comprising:
after receiving a corresponding input message, the target system analyzes the message to obtain a unit code, locking time, a locking switch instruction and a subject code;
locking the accounting data corresponding to all the account codes at the locking time, and recording the actual locking time of each accounting data;
extracting account data corresponding to each subject code;
for each subject code, sequencing the obtained financial data according to the sequencing rule that the sequence of the analyzed unit codes is a first priority and the sequence of the financial updating date is a second priority;
and generating a data message of the target system by taking the sorted result of each subject code and the final actual locking time as a group of basis.
The beneficial effects of the above further improved scheme are: and sequencing and locking the account data through the set priority level, and modularizing the account data. The accounting data can be quickly locked from the earliest date to the latest date (or from the latest date to the earliest date) according to the updating time, so that the method not only meets the characteristics of business account closing, but also has higher matching efficiency than the method of simply inquiring through the table.
Further, after the source system receives the data messages fed back by all the target systems, the source system locks the financial data corresponding to all the subject codes in the source system, checks the financial data in the data messages fed back by the target systems and the financial data correspondingly locked by the source system in sequence, and sends inconsistent checking information to an administrator for manual correction, further comprising:
after receiving data messages fed back by all target systems, the source system locks account data corresponding to all subject codes in the source system;
analyzing the data messages fed back by each target system in sequence to obtain the sorted result and the final actual locking time of each subject code of the target system;
sorting according to the last actual locking time, and generating an account period table by taking the sorted result of each subject code and the last actual locking time as a group of data;
deleting data with repeated contents in the account period table, identifying data which does not meet preset requirements, and pushing the data to an operator for manual correction;
sequentially checking each group of data in the manually corrected account period table with the correspondingly locked accounting data of the source system to obtain inconsistent comparison data;
and sequencing the comparison data of the same subject code and unit code according to the sequence of the last actual locking moment, pushing the sequencing result to an administrator for manual confirmation, and finally confirming the data of each subject code in sequence to obtain the final corrected data.
The beneficial effects of the above further improved scheme are: the data correction system can remind an operator (financial staff) to correct data in time without manual item-by-item comparison; the data are confirmed according to the priority level, so that an administrator can confirm the data step by step according to the actual business in time sequence, the account checking data are more visual, and the data checking is more intelligent and humanized.
Further, the updating the accounting data corresponding to the target system and the source system in real time according to the corrected information until all the accounting data checks are completed further includes:
acquiring the group data after the manual correction and the manual confirmation;
replacing the corresponding data before the manual correction and the manual confirmation in the target system and the source system with the data after the manual correction and the manual confirmation, completing the corresponding financial data updating of the target system and the source system, and recording the updating time of each piece of data;
judging whether checking of all the financial data is finished or not according to the updating time of each piece of data, if the data has the updating time, judging that checking of all the financial data is finished, obtaining the final updating time, and executing the next step, otherwise, not finishing, and waiting for updating of each piece of data;
and taking the last updated time as unlocking time, generating a data message containing the group data after manual correction and manual confirmation and the unlocking time, and sending the data message to a corresponding target system to enable the target system to unlock the corresponding financial data at the unlocking time.
The beneficial effects of the above further improved scheme are: the financial data of the source system and the target system are corrected and confirmed on line synchronously, whether data checking is finished or not is judged according to the data updating time, secondary login is not needed, tedious and repeated login and verification work is eliminated, and the usability of the whole system is greatly improved.
In another aspect, an embodiment of the present invention provides a cross-system financial data processing apparatus, including a source system end and a plurality of target system ends; wherein,
the source system end is used for receiving a designated accounting checking instruction input by a user, searching all target systems related to designated accounting, respectively generating input messages containing locking time and subject codes for each target system, and sending the input messages to the corresponding target system end; after receiving the data messages fed back by all the target system ends, locking the financial data corresponding to all the subject codes in the source system, sequentially checking the financial data in the data messages fed back by the target system ends and the financial data correspondingly locked by the source system, sending inconsistent checking information to an administrator for manual correction, updating the financial data corresponding to the source system in real time according to the corrected information, and feeding the corrected information back to the corresponding target system ends;
the target system end is used for analyzing the message after receiving the corresponding input message, locking the accounting data corresponding to each account code, generating a data message containing the accounting data and the locking time and sending the data message to the source system end; and receiving the corrected information fed back by the source system end, and updating the accounting data corresponding to the same subject code.
The beneficial effect who adopts above-mentioned scheme is: the method can realize one-click online quick locking of the accounts of the target system end related to all the account codes, and complete the correction and updating operations of the accounting data of the source system end and the target system end in real time without cross-system manual operation. The financial locking and the corresponding financial checking are finished by one key, differentiated multi-system financial data are intelligently identified, the information can be sent to a manager on line through a source system, the checked financial data can be timely corrected off line, manual intervention is not needed for checking the financial data, the operation process is simple, the productivity is liberated, and the working efficiency of financial staff is improved.
Based on the further improvement of the above system, the source system further comprises:
the accounting checking instruction analysis module is used for receiving an appointed accounting checking instruction input by a user, searching all target systems related to the appointed accounting, respectively generating input messages containing locking time and subject codes for each target system, and sending the input messages to corresponding target system ends through a sending end;
the accounting data checking module is used for locking the accounting data corresponding to all the subject codes in the source system after receiving the data messages fed back by all the target system ends, sequentially checking the accounting data in the data messages fed back by the target system ends and the accounting data correspondingly locked by the source system, sending inconsistent checking information to an administrator for manual correction, updating the accounting data corresponding to the source system in real time according to the corrected information, and feeding the corrected information back to the corresponding target system ends;
the designated account checking command includes a lock time, a unit code, and a subject code.
The beneficial effect of adopting the above further improved scheme is: the composition of the source system side is defined. The source system end internally divides an input instruction into an account locking block and an account checking block (the account checking instruction analysis module generates a plurality of messages of locking information, the account data checking module completes financial checking), the messages are respectively processed, asynchronous operation is carried out, an account locking operation result is identified, account data checking is asynchronously processed, correction and updating are carried out, long-time waiting for data processing completion is not needed, program thread waiting time is reduced, and user experience is improved.
Further, each target system side further comprises:
the message analysis module is used for analyzing the message after receiving the corresponding input message, locking the accounting data corresponding to each account code, generating a data message containing the accounting data and the locking time and sending the data message to a source system end;
and the financial data updating module is used for updating the financial data corresponding to the same subject code after receiving the corrected information fed back by the source system terminal.
The beneficial effect of adopting the above further improved scheme is: the composition of the target system side is defined. The composition of all target system ends is the same. The method comprises the steps that when the target system side locks accounts, the accounts are synchronously checked and transmitted to the source system side, at the moment, the service agreement is not closed, the data checked and corrected by the source system side automatically sends an updating request to the corresponding target system side, the accounts of the corresponding target system side are updated, the data are corrected synchronously, secondary triggering is not needed, operation steps of users are reduced, and the method is more intelligent.
Further, the accounting checking instruction parsing module executes the following procedures to search all target systems related to the designated accounting, and respectively generates input messages containing locking time and subject codes for each target system:
searching all target system interface fields corresponding to the unit codes and the subject codes;
generating an input message containing locking time and subject codes for each target system according to the obtained interface field of each target system and a preset template format; wherein the preset template format is as follows: target system interface field + unit code + lock time + lock switch command + subject code.
The beneficial effect of adopting the above further improved scheme is: the program can intelligently generate input and output messages in the background only by setting input and output fields in a preset template of the foreground of the source system and selecting the format of the generated template, and the messages are assembled through entity classes without depending on the background program, so that the messages are configured on line, and the interaction of the integrated interface is more flexible.
Further, the accounting data checking module executes the following procedures to lock the accounting data corresponding to all the subject codes in the source system, sequentially checks the accounting data in the data packet fed back by the target system end and the accounting data correspondingly locked by the source system, and sends inconsistent checking information to an administrator for manual correction:
after receiving data messages fed back by all target system terminals, locking account data corresponding to all subject codes in a source system;
analyzing the data messages fed back by each target system end in sequence to obtain the sorted result and the final actual locking time of each subject code of the target system;
sorting according to the last actual locking time, and generating an account period table by taking the sorted result of each subject code and the last actual locking time as a group of data;
deleting data with repeated contents in the account period table, identifying data which does not meet preset requirements, and pushing the data to an operator for manual correction;
sequentially checking each group of data in the manually corrected account period table with the correspondingly locked accounting data of the source system to obtain inconsistent comparison data;
and sequencing the comparison data of the same subject code and unit code according to the sequence of the last actual locking moment, pushing the sequencing result to an administrator for manual confirmation, and finally confirming the data of each subject code in sequence to obtain the final corrected data.
The beneficial effect of adopting the above further improved scheme is: the account locking operation is performed in sequence according to the priority, so that the account locking operation requirements of the user are more close and met, data checking is performed after the account is locked, manual correction and confirmation are pushed, one-click type automatic processing of a background is realized, manual offline sub-step processing is not needed, and the operation is more humanized.
In the invention, the technical schemes can be combined with each other to realize more preferable combination schemes. Additional features and advantages of the invention will be set forth in the description which follows, and in part will be obvious from the description, or may be learned by practice of the invention. The objectives and other advantages of the invention will be realized and attained by the structure particularly pointed out in the written description and drawings.
Drawings
The drawings are only for purposes of illustrating particular embodiments and are not to be construed as limiting the invention, wherein like reference numerals are used to designate like parts throughout.
FIG. 1 is a schematic diagram of steps of a cross-system financial data processing method according to embodiment 1 of the present invention;
FIG. 2 is a schematic diagram of a cross-system financial data processing apparatus according to embodiment 3 of the present invention.
Detailed Description
The accompanying drawings, which are incorporated in and constitute a part of this application, illustrate preferred embodiments of the invention and together with the description, serve to explain the principles of the invention and not to limit the scope of the invention.
Example 1
One embodiment of the present invention discloses a cross-system financial data processing method, as shown in fig. 1, including the following steps:
s1, a source system receives an appointed account checking instruction input by a user, searches all target systems related to the appointed account, respectively generates input messages containing locking time and subject codes for each target system, and sends the input messages to the corresponding target systems;
s2, after receiving a corresponding input message, the target system analyzes the message, locks the accounting data corresponding to each account code, generates a data message containing the accounting data and the locking time, and feeds the data message back to the source system;
and S3, after the source system receives the data messages fed back by all the target systems, the source system locks the financial data corresponding to all the subject codes in the source system, sequentially checks the financial data in the data messages fed back by the target systems and the financial data correspondingly locked by the source system, sends inconsistent check information to an administrator for manual correction, and updates the financial data corresponding to the target systems and/or the source system in real time according to the corrected information until the check processing of all the designated financial data between the source system and the target system is completed.
When the method is implemented, a source system can generate an input message which is packaged and confirmed through a background JAVA object entity class and send a target system through a service calling interface; after receiving the input message, the target system analyzes the message through an analyzer, locks corresponding financial data according to the subject code, and feeds the financial data back to the source system through a corresponding interface; after the source system receives the financial data, the account data is synchronously locked through the account codes, then the financial data of the source system is inquired and cached in the list by taking the account codes as terms, the item-by-item matching is carried out according to the account data returned by the target system and the account data list locked by the source system, the inconsistent check information is manually corrected, and the data checking and updating are carried out on the source system and the target system.
Compared with the prior art, the method provided by the embodiment can realize that different target system messages (input messages) are generated quickly by one key, account locking and corresponding account checking processing are completed by one key, differentiated multi-system account data are intelligently identified, the information can be sent to a manager online through the source system, the checked account data can be corrected offline in time, manual intervention is not needed for checking the account data, the operation process is simple, all data checking functions are completed by one key, the productivity is liberated, and the work efficiency of financial staff is improved.
Example 2
The method of embodiment 1 is modified such that the designated account checking command in step S1 includes a lock time, a unit code, and a subject code. The locking time is the preset date + time, and can be accurate to seconds.
Preferably, the searching for all target systems related to the specified account in step S1, and generating an input message containing the locking time and the account code for each target system respectively, further includes:
s11, searching all target system interface fields corresponding to the unit codes and the subject codes; specifically, each target system interface field is a unique interface field corresponding to a unique target system;
s12, generating an input message containing locking time and subject codes for each target system according to each obtained target system interface field and a preset template format; wherein the preset template format is as follows: target system interface field + unit code + lock time + lock switch command + subject code.
Preferably, step S2 is further refined as:
s21, after receiving a corresponding input message, the target system analyzes the message to obtain a unit code, locking time, a locking switch instruction and a subject code;
s22, locking the accounting data corresponding to all the subject codes at the locking time, and recording the actual locking time of each accounting data; it should be noted that the locking time in the input message is not necessarily equal to the actual locking time of each accounting data, and if a task with a higher priority is executed, a delay lock may be set by the target system;
s23, extracting account data corresponding to each subject code;
s24, for each subject code, sequencing the obtained financial data according to the sequencing rule that the sequence of the analyzed unit codes is a first priority and the sequence of the financial updating date is a second priority;
and S25, taking the sorted result of each subject code and the final actual locking time as a group of basis, sequentially obtaining all groups of data, generating a data message of the target system, and feeding back and sending the data message to the source system.
Further, after the source system receives the data messages fed back by all the target systems in step S3, the source system locks the accounting data corresponding to all the subject codes in the source system, sequentially checks the financial data in the data messages fed back by the target systems and the accounting data correspondingly locked by the source system, and sends inconsistent checking information to the administrator for manual correction, further comprising:
s31, after receiving data messages fed back by all target systems, the source system immediately locks the account data corresponding to all subject codes in the source system;
s32, analyzing the data messages fed back by each target system in sequence to obtain the sorted result and the final actual locking time of each subject code of the target system;
s33, sorting is carried out according to the last actual locking time, the sorted result of each subject code and the last actual locking time are used as a group of data, all groups of data are obtained in sequence, and an account period table is generated;
s34, deleting data with repeated contents in the account period table, identifying data which do not meet preset requirements, and pushing the data to an operator for manual correction; specifically, firstly, a duplicate data removing algorithm is used, pairwise matching is performed on group data in an account period table from a unit code of a first priority, all the group data are consistent or deleted, and the last locking time is ignored, that is, only data of the actual last locking time is reserved for the same financial data of different locking times; then, automatically matching the data in the account period table according to a source system preset requirement (for example, a certain range) by using an optimal matching algorithm to obtain a matching degree, identifying the data which does not meet the preset requirement and has the matching degree lower than 95%, pushing the data to an operator for manual correction, or matching the data in the account period table according to a preset rule built in the source system, if the data do not meet the preset rule (for example, the sum of several data is within a certain range), judging that the corresponding data do not meet the preset rule, and outputting the data to the operator for manual correction;
s35, sequentially checking each group of data in the manually corrected account period table with the correspondingly locked accounting data of the source system to obtain inconsistent comparison data;
and S36, sequencing the comparison data (the inconsistent comparison data) of the same subject code and the unit code according to the sequence of the last actual locking moment, pushing the sequencing result to an administrator to manually confirm one by one, and finally confirming the data of each subject code in sequence to obtain the final corrected data.
Further, in step S3, updating the accounting data corresponding to the target system and the source system in real time according to the corrected information until all the accounting data checks are completed, further including:
s37, acquiring the group data after manual correction and manual confirmation;
s38, replacing the corresponding data in the target system and the source system with the data after each manual correction and each manual confirmation (direct replacement), completing the corresponding financial data updating of the target system and the source system, and recording the updating time of each piece of data;
s39, judging whether checking of all the financial data is finished or not according to the updating time of each piece of data, if the data have the updating time, judging that checking of all the financial data is finished, obtaining the final updating time, executing the next step, and if not, not finishing, waiting for updating of each piece of data.
Preferably, the method further comprises:
and S4, taking the last updated time as unlocking time, generating a data message containing the manually corrected and manually confirmed group data and the unlocking time, and sending the data message to a corresponding target system to enable the target system to unlock the corresponding financial data at the unlocking time.
Compared with the method of embodiment 1, the method provided by the embodiment has the following advantages:
a. the input message is set through a preset template, the error probability of the message generated by a program through an entity class is reduced, and the message parameters can be flexibly configured;
b. the source system sequentially locks and generates an account period table according to the received account data which are sorted by the target system according to the priority, the database table does not need to be frequently operated, the locking is quickly carried out from back to front according to the account period, the influence on the business of the user is minimum, and the safety is higher;
c. the method comprises the steps that account data are asynchronously checked, a source system performs matching and deleting operations on account period table data according to a repeated data removing algorithm and priority, then performs matching of preset requirements on the account data through an optimal matching algorithm, and performs manual correction and confirmation according to the matching degree, so that the time for performing matching operation one by one in list through caching is shorter, the difficulty of processing business is smaller, and the accuracy of data checking and matching degree is higher;
d. whether the data check is finished or not is judged by updating the time, and the automatic completion degree of the program is higher.
Example 3
The invention also provides a cross-system financial data processing device corresponding to the method of the embodiment 1, which comprises a source system end and a plurality of target system ends.
The source system end is used for receiving a designated accounting checking instruction input by a user, searching all target systems related to designated accounting, respectively generating input messages containing locking time and subject codes for each target system, and sending the input messages to the corresponding target system end; and after receiving the data messages fed back by all the target system ends, locking the financial data corresponding to all the subject codes in the source system, sequentially checking the financial data in the data messages fed back by the target system ends and the financial data correspondingly locked by the source system, sending inconsistent checking information to an administrator for manual correction, updating the financial data corresponding to the source system in real time according to the corrected information, and feeding the corrected information back to the corresponding target system ends.
The target system end is used for analyzing the message after receiving the corresponding input message, locking the accounting data corresponding to each account code, generating a data message containing the accounting data and the locking time and sending the data message to the source system end; and receiving the corrected information fed back by the source system end, and updating the accounting data corresponding to the same subject code.
Example 4
The invention also provides a financial data processing device corresponding to the method in the embodiment 2, and the source system end further comprises an accounting checking instruction analysis module and an accounting data checking module. The two modules are provided with respective transceiving sub-modules.
And the accounting checking instruction analysis module is used for receiving an appointed accounting checking instruction input by a user, searching all target systems related to the appointed accounting, respectively generating input messages containing locking time and subject codes for each target system, and sending the input messages to corresponding target system ends through the sending end. The designated account checking command includes a lock time, a unit code, and a subject code.
And the accounting data checking module is used for locking the accounting data corresponding to all the subject codes in the source system after receiving the data messages fed back by all the target system ends, sequentially checking the accounting data in the data messages fed back by the target system and the accounting data correspondingly locked by the source system, sending inconsistent checking information to an administrator for manual correction, updating the accounting data corresponding to the source system in real time according to the corrected information, and feeding the corrected information back to the corresponding target system ends.
Preferably, each target system further comprises two modules, namely a message parsing module and a financial data updating module. And the two modules are also provided with respective transceiving sub-modules.
And the message analysis module is used for analyzing the message after receiving the corresponding input message, locking the accounting data corresponding to each account code, generating a data message containing the accounting data and the locking time, and sending the data message to the source system end.
And the financial data updating module is used for updating the financial data corresponding to the same subject code after receiving the corrected information fed back by the source system terminal.
Preferably, the accounting checking instruction parsing module executes the following procedures to search all target systems related to the specified accounting, and respectively generates an input message containing the locking time and the subject code for each target system:
SS1, searching all target system interface fields corresponding to the unit code and the subject code;
and SS2, according to each obtained target system interface field, generating an input message containing locking time and subject code aiming at the target system according to the following template format:
preferably, the accounting data checking module executes the following procedures to lock accounting data corresponding to all the account codes in the source system, sequentially checks the accounting data in data messages fed back by the target system end and the accounting data correspondingly locked by the source system, and sends inconsistent checking information to an administrator for manual correction:
SS1, after receiving data messages fed back by all target system ends, locking account data corresponding to all subject codes in a source system;
SS2, analyzing the data messages fed back by each target system end in sequence to obtain the sorted result and the final actual locking time of each subject code of the target system;
SS3, sorting according to the last actual locking time, and generating an account period table by taking the sorted result and the last actual locking time of each subject code as a group of data;
SS4, deleting data with repeated contents in the account period table, identifying data which do not meet preset requirements, and pushing the data to an operator for manual correction;
SS5, sequentially checking each group of data in the manually corrected account period table with the correspondingly locked accounting data of the source system to obtain inconsistent comparison data;
and SS6, sequencing the comparison data of the same subject code and the unit code according to the sequence of the last actual locking moment, pushing the sequencing result to an administrator for manual confirmation, and finally confirming the data of each subject code in sequence to obtain the finally corrected data.
Those skilled in the art will appreciate that all or part of the flow of the method implementing the above embodiments may be implemented by a computer program, which is stored in a computer readable storage medium, to instruct related hardware. The computer readable storage medium is a magnetic disk, an optical disk, a read-only memory or a random access memory.
The above description is only for the preferred embodiment of the present invention, but the scope of the present invention is not limited thereto, and any changes or substitutions that can be easily conceived by those skilled in the art within the technical scope of the present invention are included in the scope of the present invention.
Claims (10)
1. A cross-system financial data processing method is characterized by comprising the following steps:
the method comprises the steps that a source system receives an appointed account checking instruction input by a user, searches all target systems related to appointed accounts, respectively generates input messages containing locking time and subject codes for each target system, and sends the input messages to the corresponding target systems;
after receiving the corresponding input message, the target system analyzes the message, locks the accounting data corresponding to each account code, generates a data message containing the accounting data and the locking time, and feeds the data message back to the source system;
after the source system receives the data messages fed back by all the target systems, the accounting data corresponding to all the subject codes in the source system are locked, the financial data in the data messages fed back by the target systems and the accounting data correspondingly locked by the source system are checked in sequence, inconsistent check information is sent to an administrator for manual correction, and the accounting data corresponding to the target systems and/or the source system are updated in real time according to the corrected information until the check processing of all the designated accounting data between the source system and the target system is completed.
2. The cross-system financial data processing method of claim 1 wherein said designated accounting check instruction includes a lock time, a unit code, a subject code;
the searching all target systems related to the designated account, and generating input messages containing locking time and subject codes for each target system respectively, further includes:
searching all target system interface fields corresponding to the unit codes and the subject codes;
generating an input message containing locking time and subject codes for each target system according to the obtained interface field of each target system and a preset template format; wherein the preset template format is as follows: target system interface field + unit code + lock time + lock switch command + subject code.
3. The cross-system financial data processing method of claim 2 wherein the target system, after receiving the corresponding input message, parses the message, locks accounting data corresponding to each account code, and generates a data message containing the accounting data and the locking time, further comprising:
after receiving a corresponding input message, the target system analyzes the message to obtain a unit code, locking time, a locking switch instruction and a subject code;
locking the accounting data corresponding to all the account codes at the locking time, and recording the actual locking time of each accounting data;
extracting account data corresponding to each subject code;
for each subject code, sequencing the obtained financial data according to the first priority of the analyzed unit codes and the second priority of the analyzed unit codes;
and generating a data message of the target system by taking the sorted result of each subject code and the final actual locking time as a group of basis.
4. The cross-system financial data processing method of claim 3, wherein after the source system receives the data messages fed back by all target systems, the source system locks the financial data corresponding to all subject codes in the source system, checks the financial data in the data messages fed back by the target systems and the financial data correspondingly locked by the source system in sequence, and sends inconsistent check information to an administrator for manual correction, further comprising:
after receiving data messages fed back by all target systems, the source system locks account data corresponding to all subject codes in the source system;
analyzing the data messages fed back by each target system in sequence to obtain the sorted result and the final actual locking time of each subject code of the target system;
sorting according to the last actual locking time, and generating an account period table by taking the sorted result of each subject code and the last actual locking time as a group of data;
deleting data with repeated contents in the account period table, identifying data which does not meet preset requirements, and pushing the data to an operator for manual correction;
sequentially checking each group of data in the manually corrected account period table with the correspondingly locked accounting data of the source system to obtain inconsistent comparison data;
and sequencing the comparison data of the same subject code and unit code according to the sequence of the last actual locking moment, pushing the sequencing result to an administrator for manual confirmation, and finally confirming the data of each subject code in sequence to obtain the final corrected data.
5. The cross-system financial data processing method of claim 4 wherein the updating the accounting data corresponding to the target system and the source system in real time according to the revised information until all accounting data checks are completed further comprises:
acquiring the group data after the manual correction and the manual confirmation;
replacing the corresponding data before the manual correction and the manual confirmation in the target system and the source system with the data after the manual correction and the manual confirmation, completing the corresponding financial data updating of the target system and the source system, and recording the updating time of each piece of data;
judging whether checking of all the financial data is finished or not according to the updating time of each piece of data, if the data has the updating time, judging that checking of all the financial data is finished, obtaining the final updating time, and executing the next step, otherwise, not finishing, and waiting for updating of each piece of data;
and taking the last updated time as unlocking time, generating a data message containing the group data after manual correction and manual confirmation and the unlocking time, and sending the data message to a corresponding target system to enable the target system to unlock the corresponding financial data at the unlocking time.
6. A cross-system financial data processing apparatus comprising:
the source system end is used for receiving a designated accounting checking instruction input by a user, searching all target systems related to designated accounting, respectively generating input messages containing locking time and subject codes for each target system, and sending the input messages to the corresponding target system end; after receiving the data messages fed back by all the target system ends, locking the financial data corresponding to all the subject codes in the source system, sequentially checking the financial data in the data messages fed back by the target system ends and the financial data correspondingly locked by the source system, sending inconsistent checking information to an administrator for manual correction, updating the financial data corresponding to the source system in real time according to the corrected information, and feeding the corrected information back to the corresponding target system ends;
the system comprises a plurality of target system ends, a source system end and a plurality of accounting data sending ends, wherein the target system ends are used for analyzing the messages after receiving corresponding input messages, locking the accounting data corresponding to each account code, generating data messages containing the accounting data and locking time and sending the data messages to the source system end; and receiving the corrected information fed back by the source system end, and updating the accounting data corresponding to the same subject code.
7. The cross-system financial data processing apparatus of claim 6 wherein said source system side further comprises:
the accounting checking instruction analysis module is used for receiving an appointed accounting checking instruction input by a user, searching all target systems related to the appointed accounting, respectively generating input messages containing locking time and subject codes for each target system, and sending the input messages to corresponding target system ends through a sending end;
the accounting data checking module is used for locking the accounting data corresponding to all the subject codes in the source system after receiving the data messages fed back by all the target system ends, sequentially checking the accounting data in the data messages fed back by the target system ends and the accounting data correspondingly locked by the source system, sending inconsistent checking information to an administrator for manual correction, updating the accounting data corresponding to the source system in real time according to the corrected information, and feeding the corrected information back to the corresponding target system ends;
the designated account checking command includes a lock time, a unit code, and a subject code.
8. The cross-system financial data processing apparatus of claim 7 wherein each target system end further comprises:
the message analysis module is used for analyzing the message after receiving the corresponding input message, locking the accounting data corresponding to each account code, generating a data message containing the accounting data and the locking time and sending the data message to a source system end;
and the financial data updating module is used for updating the financial data corresponding to the same subject code after receiving the corrected information fed back by the source system terminal.
9. The cross-system financial data processing apparatus of claim 7 or 8 wherein the accounting reconciliation instruction parsing module executes the following procedures to search all target systems related to the designated accounting, and respectively generate an input message containing the locking time and the subject code for each target system:
searching all target system interface fields corresponding to the unit codes and the subject codes;
generating an input message containing locking time and subject codes for each target system according to the obtained interface field of each target system and a preset template format; wherein the preset template format is as follows: target system interface field + unit code + lock time + lock switch command + subject code.
10. The cross-system financial data processing device of claim 9 wherein the accounting data checking module performs the following procedures to lock accounting data corresponding to all the subject codes in the source system, sequentially checks accounting data in data messages fed back by the target system side and correspondingly locked accounting data in the source system, and sends inconsistent checking information to the administrator for manual correction:
after receiving data messages fed back by all target system terminals, locking account data corresponding to all subject codes in a source system;
analyzing the data messages fed back by each target system end in sequence to obtain the sorted result and the final actual locking time of each subject code of the target system;
sorting according to the last actual locking time, and generating an account period table by taking the sorted result of each subject code and the last actual locking time as a group of data;
deleting data with repeated contents in the account period table, identifying data which does not meet preset requirements, and pushing the data to an operator for manual correction;
sequentially checking each group of data in the manually corrected account period table with the correspondingly locked accounting data of the source system to obtain inconsistent comparison data;
and sequencing the comparison data of the same subject code and unit code according to the sequence of the last actual locking moment, pushing the sequencing result to an administrator for manual confirmation, and finally confirming the data of each subject code in sequence to obtain the final corrected data.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110004074.2A CN112699137B (en) | 2021-01-04 | 2021-01-04 | Cross-system financial data processing method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110004074.2A CN112699137B (en) | 2021-01-04 | 2021-01-04 | Cross-system financial data processing method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112699137A true CN112699137A (en) | 2021-04-23 |
| CN112699137B CN112699137B (en) | 2023-09-12 |
Family
ID=75514535
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110004074.2A Active CN112699137B (en) | 2021-01-04 | 2021-01-04 | Cross-system financial data processing method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112699137B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113489593A (en) * | 2021-06-30 | 2021-10-08 | 深圳前海微众银行股份有限公司 | JSON message checking method and JSON message checking device |
Citations (14)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2013117852A (en) * | 2011-12-02 | 2013-06-13 | Internatl Business Mach Corp <Ibm> | Device and method for acquiring lock of resource |
| US20130346363A1 (en) * | 2011-02-09 | 2013-12-26 | Fujitsu Limited | Data synchronization method, computer readable recording medium having stored therein data synchronization program, and data synchronization control device |
| CN104156832A (en) * | 2014-08-28 | 2014-11-19 | 国家电网公司 | Intersystem data verification method and device |
| US20150142719A1 (en) * | 2013-11-18 | 2015-05-21 | International Business Machines Corporation | Automatically self-learning bidirectional synchronization of a source system and a target system |
| US20150142740A1 (en) * | 2013-11-18 | 2015-05-21 | International Business Machines Corporation | Automatically managing mapping and transform rules when synchronizing systems |
| CN105488720A (en) * | 2015-11-27 | 2016-04-13 | 国网北京市电力公司 | Accounting data processing method and device |
| CN106408410A (en) * | 2016-11-29 | 2017-02-15 | 用友网络科技股份有限公司 | Automatic account checking method and device |
| CN106897342A (en) * | 2016-07-20 | 2017-06-27 | 阿里巴巴集团控股有限公司 | A kind of data verification method and equipment |
| US20170236214A1 (en) * | 2015-01-09 | 2017-08-17 | NetSuite Inc. | System and methods for implementing a transition to multi-book accounting in a real-time financial management system |
| US20190005083A1 (en) * | 2017-06-28 | 2019-01-03 | International Business Machines Corporation | Cooperative locking between databases integrated with distributed programming environments |
| CN109903146A (en) * | 2018-11-22 | 2019-06-18 | 阿里巴巴集团控股有限公司 | A kind of accounting and account method and system calculate equipment and storage medium |
| CN110618873A (en) * | 2019-09-20 | 2019-12-27 | 中国银行股份有限公司 | Data locking method, equipment and system based on information system |
| CN111798296A (en) * | 2020-06-15 | 2020-10-20 | 远光软件股份有限公司 | Automatic account checking method, automatic account checking device and computer readable storage medium |
| WO2020243903A1 (en) * | 2019-06-04 | 2020-12-10 | 深圳海付移通科技有限公司 | Bookkeeping method, accounting system, account system, and payment system |
-
2021
- 2021-01-04 CN CN202110004074.2A patent/CN112699137B/en active Active
Patent Citations (14)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20130346363A1 (en) * | 2011-02-09 | 2013-12-26 | Fujitsu Limited | Data synchronization method, computer readable recording medium having stored therein data synchronization program, and data synchronization control device |
| JP2013117852A (en) * | 2011-12-02 | 2013-06-13 | Internatl Business Mach Corp <Ibm> | Device and method for acquiring lock of resource |
| US20150142719A1 (en) * | 2013-11-18 | 2015-05-21 | International Business Machines Corporation | Automatically self-learning bidirectional synchronization of a source system and a target system |
| US20150142740A1 (en) * | 2013-11-18 | 2015-05-21 | International Business Machines Corporation | Automatically managing mapping and transform rules when synchronizing systems |
| CN104156832A (en) * | 2014-08-28 | 2014-11-19 | 国家电网公司 | Intersystem data verification method and device |
| US20170236214A1 (en) * | 2015-01-09 | 2017-08-17 | NetSuite Inc. | System and methods for implementing a transition to multi-book accounting in a real-time financial management system |
| CN105488720A (en) * | 2015-11-27 | 2016-04-13 | 国网北京市电力公司 | Accounting data processing method and device |
| CN106897342A (en) * | 2016-07-20 | 2017-06-27 | 阿里巴巴集团控股有限公司 | A kind of data verification method and equipment |
| CN106408410A (en) * | 2016-11-29 | 2017-02-15 | 用友网络科技股份有限公司 | Automatic account checking method and device |
| US20190005083A1 (en) * | 2017-06-28 | 2019-01-03 | International Business Machines Corporation | Cooperative locking between databases integrated with distributed programming environments |
| CN109903146A (en) * | 2018-11-22 | 2019-06-18 | 阿里巴巴集团控股有限公司 | A kind of accounting and account method and system calculate equipment and storage medium |
| WO2020243903A1 (en) * | 2019-06-04 | 2020-12-10 | 深圳海付移通科技有限公司 | Bookkeeping method, accounting system, account system, and payment system |
| CN110618873A (en) * | 2019-09-20 | 2019-12-27 | 中国银行股份有限公司 | Data locking method, equipment and system based on information system |
| CN111798296A (en) * | 2020-06-15 | 2020-10-20 | 远光软件股份有限公司 | Automatic account checking method, automatic account checking device and computer readable storage medium |
Non-Patent Citations (1)
| Title |
|---|
| 魏永瑜: "财务管控系统与SAP 系统电子对帐平台的研究", 《信息通信》, pages 100 * |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113489593A (en) * | 2021-06-30 | 2021-10-08 | 深圳前海微众银行股份有限公司 | JSON message checking method and JSON message checking device |
| CN113489593B (en) * | 2021-06-30 | 2022-11-08 | 深圳前海微众银行股份有限公司 | JSON message checking method and JSON message checking device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112699137B (en) | 2023-09-12 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US6282508B1 (en) | Dictionary management apparatus and a dictionary server | |
| US6411922B1 (en) | Problem modeling in resource optimization | |
| CN113850527B (en) | Custom approval method, system and storage medium for medical electronic experiment record | |
| CN108600148B (en) | Transaction message processing method and device | |
| CN102323940B (en) | Configuration platform implementation method based on database, configuration platform and system | |
| CN110175822A (en) | A kind of equipment account management method and system | |
| CN111401029A (en) | Document version updating system and method based on document partition and collaborative editing | |
| CN112699137A (en) | Cross-system financial data processing method and device | |
| CN114418527A (en) | Project flow management system and method based on software componentization | |
| CN112905492B (en) | Verification method and device | |
| CN113849492A (en) | System for providing standardized data quality check for multi-scenario service | |
| CN112242909B (en) | Method and device for generating management template, electronic equipment and storage medium | |
| CN108768953A (en) | Control method, server and the storage medium of scheduling process | |
| CN103177004B (en) | Ensure the method and system that repaid card data is consistent | |
| CN105608561A (en) | Method and apparatus for processing mail | |
| KR20190040537A (en) | Electronic form generation and sharing system and method for performance reporting | |
| CN111381984B (en) | Method for automatically generating accounting document without billing code by SAP system interface | |
| CN114500002A (en) | LDAP-based cluster account allocation method and system | |
| CN112995188A (en) | Message conversion method, intermediate adaptation device, storage medium and electronic equipment | |
| CN112766930A (en) | High-efficient wisdom information management system based on instrumentization | |
| CN111783125A (en) | Cloud platform data dynamic configuration method for big data | |
| CN115484138B (en) | Operation and maintenance tool rapid customization development method and system | |
| CN115134326B (en) | Data processing device for generating messages to be sent | |
| US20230315723A1 (en) | Low-development system for dynamic information queries | |
| CN113947064A (en) | Report data acquisition method and device, computer equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |