CN112699137B - Cross-system financial data processing method and device - Google Patents
Cross-system financial data processing method and device Download PDFInfo
- Publication number
- CN112699137B CN112699137B CN202110004074.2A CN202110004074A CN112699137B CN 112699137 B CN112699137 B CN 112699137B CN 202110004074 A CN202110004074 A CN 202110004074A CN 112699137 B CN112699137 B CN 112699137B
- Authority
- CN
- China
- Prior art keywords
- data
- accounting
- target system
- message
- locking
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; 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 OR CALCULATING; 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 OR CALCULATING; 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 OR CALCULATING; 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 OR CALCULATING; 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 OR CALCULATING; 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 application 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 verification in the prior art. The method comprises the following steps: the source system receives a specified accounting check instruction input by a user, searches all target systems related to the specified accounting, 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 accounting data corresponding to the specific subject code, generates a data message containing the accounting data and the locking time, and feeds back the data message 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 data messages are locked, the financial data fed back by the target systems and the corresponding locked accounting data of the source systems 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 systems are updated in real time according to the corrected information.
Description
Technical Field
The application relates to the technical field of accounting management, in particular to a cross-system financial data processing method and device.
Background
Heterogeneous systems of group-level enterprise application are respectively and independently managed, business occurs in which system, certificates are generated in which system, and a bidirectional integration mode is adopted to ensure that complete certificates and accounting data exist among the heterogeneous systems. The success rate of credential integration cannot reach 100% due to the reasons of the integrated interface and channel problem, the asynchronous master data information, the non-uniform accounting control rule of the heterogeneous system, the error selection of the unclean item information, the error selection of the client provider information, the fact that business personnel do not perform accounting processing on the corresponding system according to the interface division, and the like.
After the integration fails, as one party is checked out and the other party does not receive the certificate, accounting data of the two parties are inconsistent, the heterogeneous systems are needed to be manually logged in to derive the accounting data, and then the accounting data is checked out with great time and effort in offline.
To continuously promote the management and control capability of the group, heterogeneous system accounting data creates an online automatic data check requirement. Because each system is relatively independent, accounting management level and mode have great difference, and accounting locking and accounting data check degree of coupling are very high, if the administrator divides step operation before and after, not only the operation step is loaded down with trivial details, increases operation degree of difficulty and time, still can cause because the time difference leads to influencing each system business to carry out, leads to work efficiency low.
Disclosure of Invention
In view of the above analysis, the present application aims to provide a cross-system financial data processing method and apparatus, so as to solve the problem of low work efficiency of cross-system accounting check in the prior art.
In one aspect, an embodiment of the present application provides a cross-system financial data processing method, including the following steps:
the source system receives a specified accounting check instruction input by a user, searches all target systems related to the specified accounting, 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 subject code, generates a data message containing the accounting data and the locking time, and feeds back the data message 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, financial data in the data messages fed back by the target systems and the corresponding locked accounting data of 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 appointed accounting data between the source system and the target system is completed.
The beneficial effects of the technical scheme are as follows: the system can realize one-key rapid generation of different target system messages (input messages), one-key completion of account locking and corresponding account checking processing, intelligently identify differentiated multi-system account data, send messages to management staff through a source system on-line, correct checked account data off-line in time, and have no need of manual intervention to check account data.
Based on a further improvement of the method, the specified accounting checking instruction comprises a locking time, a unit code and a subject code;
searching all target systems related to the appointed accounting, respectively generating an input message which comprises the locking time and the subject code and aims at each target system, and further comprising:
searching all target system interface fields corresponding to the unit codes and the subject codes;
generating an input message aiming at the target system and containing locking time and subject codes according to a preset template format according to each obtained target system interface field; the preset template format is as follows: target system interface field + unit code + lock time + lock switch instruction + subject code.
The beneficial effects of the further improved scheme are as follows: the input message of each target system is generated through the unified template format, the function can manually configure and adjust the message format on line at the foreground of the source system, the message is not required to be generated through background codes, and the 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 subject code, and generates a data message containing the accounting data and the locking time, and the method further comprises the following steps:
after receiving the 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 subject codes at the locking time, and recording the actual locking time of each accounting data;
extracting accounting data corresponding to each subject code;
for each subject code, sorting the obtained account data according to the sorting rule that the sequence of the analyzed unit codes is the first priority and the sequence of the account update date is the second priority;
and taking the sequenced result and the last actual locking moment of each subject code as a group of basis to generate a data message of the target system.
The beneficial effects of the further improved scheme are as follows: and sequencing and locking the accounting data through the set priority level, and modularization of the accounting data is realized. 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 accounting data not only accords with the business accounting feature, but also has higher matching efficiency than simply inquiring through a table.
Further, after the source system receives the data messages fed back by all the target systems, the source system locks the accounting 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 accounting data correspondingly locked by the source system in sequence, and sends inconsistent checking information to an administrator for manual correction, and the method further comprises the steps of:
after the source system receives the data messages fed back by all the target systems, locking accounting data corresponding to all the subject codes in the source system;
analyzing the data message fed back by each target system in turn to obtain the sequenced result and the final actual locking moment of each subject code of the target system;
sequencing according to the last actual locking time, taking the sequenced result of each subject code and the last actual locking time as a group of data, and generating an account period table;
deleting repeated data of the content in the account period table, identifying data which does not meet the preset requirement, and pushing the data to an operator for manual correction;
sequentially checking each group of data in the accounting schedule after manual correction with the accounting data correspondingly locked by the source system to obtain inconsistent comparison data;
and sorting the comparison data of the same subject codes and unit codes according to the sequence of the last actual locking moment, pushing the sorting result to an administrator for manual confirmation, and sequentially finally confirming the data of each subject code to obtain final corrected data.
The beneficial effects of the further improved scheme are as follows: the method can prompt operators (financial staff) to correct data in time without manual comparison; the data is confirmed according to the priority level, so that an administrator can confirm the data step by step according to the actual business time sequence, the account checking data is more visual, and the data checking is more intelligent and humanized.
Further, updating accounting data corresponding to the target system and the source system in real time according to the corrected information until all accounting data checks are completed, and further comprising:
acquiring the group data after the manual correction and the manual confirmation;
replacing corresponding data before manual correction and manual confirmation in the target system and the source system with the data after manual correction and manual confirmation to finish updating corresponding financial data of the target system and the source system, and recording updating time of each piece of data;
judging whether all the account data checks are completed according to the updating time of each piece of data, if the data has the updating time, judging that all the account data checks are completed, obtaining the last updating time, executing the next step, otherwise, not finishing and waiting for each piece of data to be updated;
and taking the last updated time as the unlocking time, generating a data message containing the manually corrected and confirmed group data and the unlocking time, and sending the data message to a corresponding target system to unlock the corresponding financial data at the unlocking time.
The beneficial effects of the further improved scheme are as follows: and the accounting data of the source system and the target system are corrected and confirmed synchronously on line, and whether the data check is finished or not is judged through the data updating time, so that secondary login is not needed, tedious repeated login and verification work is removed, and the usability of the whole system is greatly improved.
On the other hand, the embodiment of the application provides a cross-system financial data processing device, which comprises a source system end and a plurality of target system ends; wherein,,
the source system end is used for receiving a specified accounting check instruction input by a user, searching all target systems related to the specified accounting, respectively generating input messages containing locking time and subject codes aiming at 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 accounting 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 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 back the corrected information 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 subject 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 effects of adopting above-mentioned scheme are: the system can realize one-key online quick locking of accounts of all subject codes related target system ends, and real-time finishing of the accounting data correction and updating operation of the source system ends and the target system ends, without cross-system manual operation. The accounting locking and corresponding accounting checking processing is completed by one key, the differentiated multi-system accounting data are intelligently identified, information can be sent to management staff on line through a source system, the checked accounting data can be corrected off line in time, manual intervention is not needed for checking the accounting data, the operation process is simple, the productivity is liberated, and the working efficiency of financial staff is improved.
Based on a further improvement of the above system, the source system side further includes:
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 which comprise locking time and subject codes and are aimed at each target system, and transmitting the input messages to corresponding target system ends through a transmitting end;
the accounting data checking module is used for locking accounting data corresponding to all subject codes in the source system after receiving data messages fed back by all 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 back the corrected information to the corresponding target system ends;
the specified accounting checking instruction comprises a locking time, a unit code and a subject code.
The beneficial effects of adopting the further improvement scheme are as follows: the composition of the source system side is defined. The input instruction is divided into two blocks of account locking and account checking (the account checking instruction analysis module generates a plurality of messages of locking information, and the account data checking module completes the financial checking) in the source system end for processing respectively, asynchronous operation is performed, the account locking operation result is identified, the account data checking is asynchronously processed, correction and updating are performed, long-time waiting for data processing is not needed, the waiting time of a program thread is reduced, and the user experience is improved.
Further, each target system side further includes:
the message analysis module is used for analyzing the message after receiving the corresponding input message, locking the accounting data corresponding to each subject 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 accounting data corresponding to the same subject code after receiving the corrected information fed back by the source system end.
The beneficial effects of adopting the further improvement scheme are as follows: the composition of the target system end is limited. All the target system ends have the same composition. When the target system end locks the accounts, the accounting check data are synchronously transmitted to the source system end, at the moment, the service protocol does not perform closing processing, the data checked and corrected by the source system end automatically send an update request to the corresponding target system end, the accounting data of the corresponding target system end are updated, the data correction is synchronous, secondary triggering is not needed, the operation steps of a user are reduced, and the intelligent system is realized.
Further, the accounting checking instruction analysis module executes the following program to search all target systems related to the appointed accounting, and respectively generates an input message 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 aiming at the target system and containing locking time and subject codes according to a preset template format according to each obtained target system interface field; the preset template format is as follows: target system interface field + unit code + lock time + lock switch instruction + subject code.
The beneficial effects of adopting the further improvement scheme are as follows: the program can intelligently generate the input and output messages in the background only by setting the input and output fields in the preset template of the foreground of the source system and selecting the generated template format, and the message is assembled by entity class without depending on the background program, so that the message is configured on line, and the interaction of the integrated interfaces is more flexible.
Further, the accounting data checking module executes the following procedures to lock accounting data corresponding to all subject codes in the source system, checks the accounting data in the data message fed back by the target system end and the accounting data correspondingly locked by the source system in sequence, and sends inconsistent checking information to an administrator for manual correction:
after receiving the data messages fed back by all target system ends, locking accounting data corresponding to all subject codes in a source system;
analyzing the data message fed back by each target system end in turn to obtain the sequenced result and the final actual locking moment of each subject code of the target system;
sequencing according to the last actual locking time, taking the sequenced result of each subject code and the last actual locking time as a group of data, and generating an account period table;
deleting repeated data of the content in the account period table, identifying data which does not meet the preset requirement, and pushing the data to an operator for manual correction;
sequentially checking each group of data in the accounting schedule after manual correction with the accounting data correspondingly locked by the source system to obtain inconsistent comparison data;
and sorting the comparison data of the same subject codes and unit codes according to the sequence of the last actual locking moment, pushing the sorting result to an administrator for manual confirmation, and sequentially finally confirming the data of each subject code to obtain final corrected data.
The beneficial effects of adopting the further improvement scheme are as follows: by sequentially locking accounts according to the priority order, the account locking system is closer to and accords with the account locking service requirements of users, data checking is performed after the accounts are locked, manual correction is pushed and confirmed, background one-key automatic processing is realized, manual offline sub-steps are not needed, and the operation is more humanized.
In the application, the technical schemes can be mutually combined to realize more preferable combination schemes. Additional features and advantages of the application 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 application. The objectives and other advantages of the application may 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 application, like reference numerals being used to refer to like parts throughout the several views.
FIG. 1 is a schematic diagram showing steps of a cross-system financial data processing method according to embodiment 1 of the present application;
FIG. 2 is a schematic diagram showing the components of a cross-system financial data processing apparatus according to embodiment 3 of the present application.
Detailed Description
The following detailed description of preferred embodiments of the application is made in connection with the accompanying drawings, which form a part hereof, and together with the description of the embodiments of the application, are used to explain the principles of the application and are not intended to limit the scope of the application.
Example 1
In one embodiment of the present application, a method for processing cross-system financial data is disclosed, as shown in FIG. 1, comprising the steps of:
s1, a source system receives a specified accounting check instruction input by a user, searches all target systems related to specified 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;
s2, after receiving the corresponding input message, the target system analyzes the message, locks the accounting data corresponding to each subject code, generates a data message containing the accounting data and the locking time, and feeds back the data message to the source system;
s3, after the source system receives the data messages fed back by all the target systems, locking the accounting data corresponding to all the subject codes in the source system, sequentially checking the financial data fed back by the target systems and the corresponding locked accounting data of the source system, sending inconsistent checking information to an administrator for manual correction, and updating the accounting data corresponding to the target systems and/or the source system in real time according to the corrected information until the checking processing of all the appointed accounting data between the source system and the target system is completed.
When the method is implemented, the source system can generate an input message with well-confirmed encapsulation through a background JAVA object entity class, and send the target system through a service call interface; after receiving the input message, the target system analyzes the message through a parser, locks corresponding financial data according to the subject codes, and feeds back the financial data to the source system through a corresponding interface; after the source system receives the financial data, the financial data is synchronously locked through the subject code, then the financial data of the source system is inquired out and cached in the list by taking the subject code as a term, then the financial data returned by the target system is matched with the financial data list locked by the source system one by one, inconsistent check information is corrected manually, and data check update is carried out on the source system and the target system.
Compared with the prior art, the method provided by the embodiment can realize one-key rapid generation of different target system messages (input messages), one-key completion of accounting locking and corresponding accounting checking processing, intelligently identify differentiated multi-system accounting data, send messages to management staff through a source system on-line, correct checked accounting data off-line in time, and do not need manual intervention to check the accounting data.
Example 2
The improvement on the method of embodiment 1 is that the specified accounting check instruction in step S1 contains a lock time, a unit code, a subject code. The locking time is a preset date and time, and can be accurate to seconds.
Preferably, the searching in step S1 for all target systems related to the specified accounting generates an input message containing a lock time and a subject code for each target system, and 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, and corresponds to only one target system;
s12, according to each obtained interface field of the target system, generating an input message aiming at the target system and comprising locking time and subject codes according to a preset template format; the preset template format is as follows: target system interface field + unit code + lock time + lock switch instruction + subject code.
Preferably, step S2 is further refined to:
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 account data corresponding to all the subject codes at the locking time, and recording the actual locking time of each account 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 executing, the delay locking can be set by the target system;
s23, extracting accounting data corresponding to each subject code;
s24, for each subject code, sorting the obtained financial data according to the sorting rule of the first priority of the sequence of the analyzed unit codes and the second priority of the accounting update date;
s25, taking the sequenced result and the last actual locking moment of each subject code 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, checks the financial data in the data messages fed back by the target systems and the accounting data correspondingly locked by the source system in sequence, and sends inconsistent check information to the administrator for manual correction, which further includes:
s31, after receiving data messages fed back by all target systems, the source system immediately locks accounting data corresponding to all subject codes in the source system;
s32, sequentially analyzing the data message fed back by each target system to obtain the sequenced result and the final actual locking moment of each subject code of the target system;
s33, sorting according to the last actual locking time, taking the sorted result of each subject code and the last actual locking time as a group of data, sequentially obtaining all groups of data, and generating an account period table;
s34, deleting repeated data of the account period table, identifying data which do not meet preset requirements, and pushing the data to an operator for manual correction; specifically, firstly, the repeated data algorithm is cleared, the group data in the accounting schedule are matched pairwise from the unit code of the first priority, all the group data are consistent, namely deleted, the last locking moment is ignored, namely the same financial data at different locking moments only retain the data at the actual last locking moment; then, automatically matching the data in the account table according to a source system preset requirement (for example, a certain range) through an optimal matching algorithm, obtaining a matching degree, identifying the data which does not meet the preset requirement and is lower than 95% in the matching degree, pushing the data to an operator for manual correction, or matching the data in the account table according to a source system built-in preset rule, if the data does not match, judging that the corresponding data does not meet the preset rule (for example, the sum of the data is within the certain range, and the like), and pushing the output to the operator for manual correction;
s35, sequentially checking each group of data in the accounting schedule after manual correction with the accounting data correspondingly locked by the source system to obtain inconsistent comparison data;
s36, sorting the comparison data (inconsistent comparison data) of the same subject codes and unit codes according to the sequence of the last actual locking moment, pushing the sorting result to an administrator to manually confirm the sorting result one by one, and finally confirming the data of each subject code in sequence to obtain final corrected data.
Further, in step S3, the accounting data corresponding to the target system and the source system are updated in real time according to the corrected information until all accounting data checks are completed, which further includes:
s37, acquiring the group data after manual correction and manual confirmation;
s38, replacing corresponding manual correction and data before manual confirmation (direct replacement) in the target system and the source system with the data after manual correction and manual confirmation to finish updating of corresponding financial data of the target system and the source system, and recording updating time of each piece of data;
s39, judging whether all the account data checks are completed according to the updating time of each piece of data, if the data has the updating time, judging that all the account data checks are completed, obtaining the final updating time, executing the next step, otherwise, not finishing, and waiting for each piece of data to be updated.
Preferably, the method further comprises:
s4, taking the last updated time as the unlocking time, generating a data message containing the manually corrected and confirmed group data and the unlocking time, and sending the data message to a corresponding target system to unlock the corresponding financial data at the unlocking time.
Compared with the method of embodiment 1, the method provided by this embodiment has the following advantages:
a. the input message is set through a preset template, so that the probability of error of the message generated by the program through the entity class is reduced, and the message parameters can be flexibly configured;
b. the source system locks and generates the account period table according to the received accounting data of the target system according to the priority order, the database table is not required to be operated frequently, the system is locked from back to front rapidly according to the account period, the influence on the service of the user is minimum, and the safety is higher;
c. the accounting data is checked asynchronously, the source system performs matching and deleting operations on accounting schedule data according to priority by a duplicate data clearing algorithm, then performs preset required matching on the accounting data by an optimal matching algorithm, performs manual correction and confirmation on the account data through the matching degree, and has shorter matching operation time, smaller processing service difficulty and higher matching degree precision compared with the case of performing piece-by-piece matching in a list by caching;
d. and whether the data check is completed or not is judged by updating the time, so that the program automatic completion degree is higher.
Example 3
The application 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 specified accounting check instruction input by a user, searching all target systems related to the specified accounting, respectively generating input messages containing locking time and subject codes aiming at 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 accounting 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 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 back the corrected information 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 subject 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 application further provides a financial data processing device corresponding to the method of the embodiment 2, and the source system side further comprises an accounting checking instruction analysis module and an accounting data checking module. The two modules are provided with respective transceiver 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 which are aimed at each target system and contain locking time and subject codes, and transmitting the input messages to the corresponding target system end through the transmitting end. The specified accounting checking instruction comprises a locking 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 back the corrected information to the corresponding target system ends.
Preferably, each target system further comprises two modules, namely a message analysis module and a financial data updating module. Both modules are also provided with respective transceiver 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 subject 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 accounting data corresponding to the same subject code after receiving the corrected information fed back by the source system end.
Preferably, the accounting checking instruction analysis module executes the following program to search all target systems related to the specified accounting, and respectively generates an input message containing a locking time and a subject code for each target system:
SS1, searching all target system interface fields corresponding to unit codes and subject codes;
SS2, according to each obtained interface field of the target system, generating an input message containing locking time and subject codes for 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 subject codes in the source system, checks the accounting data in the data message fed back by the target system end and the accounting data correspondingly locked by the source system in sequence, and sends inconsistent checking information to an administrator for manual correction:
SS1, after receiving data messages fed back by all target system ends, locking accounting data corresponding to all subject codes in a source system;
SS2, sequentially analyzing the data message fed back by each target system end to obtain the sequenced result and the final actual locking moment of each subject code of the target system;
SS3, sorting according to the last actual locking time, and taking the sorted result of each subject code and the last actual locking time as a group of data to generate an account period table;
SS4, deleting the repeated data of the account period table, identifying the data which does not meet the preset requirement, 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 corresponding locked account data of the source system to obtain inconsistent comparison data;
and SS6, sorting the comparison data of the same subject codes and unit codes according to the sequence of the last actual locking moment, pushing the sorting result to an administrator for manual confirmation, and finally confirming the data of each subject code in sequence to obtain final corrected data.
Those skilled in the art will appreciate that all or part of the flow of the methods of the embodiments described above may be accomplished by way of a computer program to instruct associated hardware, where the program may be stored on a computer readable storage medium. Wherein the computer readable storage medium is a magnetic disk, an optical disk, a read-only memory or a random access memory, etc.
The present application is not limited to the above-mentioned embodiments, and any changes or substitutions that can be easily understood by those skilled in the art within the technical scope of the present application are intended to be included in the scope of the present application.
Claims (4)
1. A method of cross-system financial data processing comprising the steps of:
the source system receives a specified accounting checking instruction input by a user, wherein the specified accounting checking instruction comprises locking time, unit codes and subject codes;
searching all target systems related to the appointed accounting, respectively generating input messages containing locking time and subject codes aiming at each target system, and sending the input messages to the corresponding target system; further comprises: searching all target system interface fields corresponding to the unit codes and the subject codes; generating an input message aiming at the target system and containing locking time and subject codes according to a preset template format according to each obtained target system interface field; the preset template format is as follows: target system interface field + unit code + lock time + lock switch instruction + subject code;
after receiving the corresponding input message, the target system analyzes the message, locks the accounting data corresponding to each subject code, generates a data message containing the accounting data and the locking time, and feeds back the data message to the source system;
after receiving the corresponding input message, the target system analyzes the message, locks the accounting data corresponding to each subject code, and generates a data message containing the accounting data and the locking time, and the method further comprises the following steps: after receiving the 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 subject codes at the locking time, and recording the actual locking time of each accounting data; extracting accounting data corresponding to each subject code; for each subject code, sequencing the obtained financial data according to the first priority of the sequence of the analyzed unit codes and the second priority of the financial update date; taking the sequenced result and the last actual locking moment of each subject code as a group of basis to generate a data message of the target system;
after the source system receives the data messages fed back by all the target systems, locking the accounting data corresponding to all the subject codes in the source system, sequentially checking the financial data fed back by the target systems and the corresponding locked accounting data of the source system, sending inconsistent checking information to an administrator for manual correction, and updating the accounting data corresponding to the target systems and/or the source systems in real time according to the corrected information until the checking processing of all the appointed accounting data between the source systems and the target systems is completed;
after the source system receives the data messages fed back by all the target systems, the source system locks the accounting 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 accounting data correspondingly locked by the source system in sequence, and sends inconsistent checking information to an administrator for manual correction, and the method further comprises the following steps: after the source system receives the data messages fed back by all the target systems, locking accounting data corresponding to all the subject codes in the source system; analyzing the data message fed back by each target system in turn to obtain the sequenced result and the final actual locking moment of each subject code of the target system; sequencing according to the last actual locking time, taking the sequenced result of each subject code and the last actual locking time as a group of data, and generating an account period table; deleting repeated data of the content in the account period table, identifying data which does not meet the preset requirement, and pushing the data to an operator for manual correction; sequentially checking each group of data in the accounting schedule after manual correction with the accounting data correspondingly locked by the source system to obtain inconsistent comparison data; and sorting the comparison data of the same subject codes and unit codes according to the sequence of the last actual locking moment, pushing the sorting result to an administrator for manual confirmation, and sequentially finally confirming the data of each subject code to obtain final corrected data.
2. The cross-system financial data processing method as claimed in claim 1, wherein updating the corresponding accounting data of the target system and the source system in real time according to the corrected information until all accounting data checks are completed, further comprising:
acquiring the group data after the manual correction and the manual confirmation;
replacing corresponding data before manual correction and manual confirmation in the target system and the source system with the data after manual correction and manual confirmation to finish updating corresponding financial data of the target system and the source system, and recording updating time of each piece of data;
judging whether all the account data checks are completed according to the updating time of each piece of data, if the data has the updating time, judging that all the account data checks are completed, obtaining the last updating time, executing the next step, otherwise, not finishing and waiting for each piece of data to be updated;
and taking the last updated time as the unlocking time, generating a data message containing the manually corrected and confirmed group data and the unlocking time, and sending the data message to a corresponding target system to unlock the corresponding financial data at the unlocking time.
3. A cross-system financial data processing apparatus, comprising:
the source system end is used for receiving a specified accounting checking instruction input by a user, wherein the specified accounting checking instruction comprises locking time, unit codes and subject codes;
searching all target system ends related to the appointed accounts, respectively generating input messages containing locking time and subject codes aiming at each target system end, and sending the input messages to the corresponding target system end;
the 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 system ends related to the appointed accounting, respectively generating input messages containing locking time and subject codes aiming at each target system end, and transmitting the input messages to the corresponding target system end through the transmitting end;
the accounting checking instruction analysis module executes the following program to search all target system ends related to the appointed accounting, and respectively generates an input message which comprises locking time and subject codes and aims at each target system end:
searching all target system interface fields corresponding to the unit codes and the subject codes;
generating an input message aiming at the target system end and containing locking time and subject codes according to a preset template format according to the obtained interface field of each target system end; the preset template format is as follows: the interface field of the target system end, the unit code, the locking time, the locking switch instruction and the subject code;
each target system terminal further comprises a message analysis module, wherein the message analysis module is used for analyzing the message after receiving the corresponding input message, locking the accounting data corresponding to each subject code, generating a data message containing the accounting data and the locking time, and sending the data message to the source system terminal; and receiving corrected information fed back by the source system end, and updating accounting data corresponding to the same subject code;
after the target system receives the corresponding input message, analyzing the message, locking the accounting data corresponding to each subject code, and generating a data message containing the accounting data and the locking time, and further comprising: after receiving the 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 subject codes at the locking time, and recording the actual locking time of each accounting data; extracting accounting data corresponding to each subject code; for each subject code, sequencing the obtained financial data according to the first priority of the sequence of the analyzed unit codes and the second priority of the financial update date; taking the sequenced result and the final actual locking moment of each subject code as a group of basis to generate a data message of the target system end;
the source system side further comprises: the accounting data checking module is used for locking accounting data corresponding to all subject codes in the source system end after receiving 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 end and the accounting data correspondingly locked by the source system end, sending inconsistent checking information to an administrator for manual correction, updating the accounting data corresponding to the source system end in real time according to the corrected information, and feeding back the corrected information to the corresponding target system end; after the source system receives the data messages fed back by all the target system ends, the source system ends lock the accounting data corresponding to all the subject codes, check the financial data in the data messages fed back by the target system ends and the accounting data correspondingly locked by the source system ends in sequence, and send inconsistent check information to an administrator for manual correction, and the method further comprises the following steps: after the source system receives the data messages fed back by all the target system ends, locking accounting data corresponding to all the subject codes at the source system ends; analyzing the data message fed back by each target system end in turn to obtain the sequenced result and the final actual locking moment of each subject code of the target system end; sequencing according to the last actual locking time, taking the sequenced result of each subject code and the last actual locking time as a group of data, and generating an account period table; deleting repeated data of the content in the account period table, identifying data which does not meet the preset requirement, and pushing the data to an operator for manual correction; sequentially checking each group of data in the accounting schedule after manual correction with accounting data correspondingly locked by a source system end to obtain inconsistent comparison data; and sorting the comparison data of the same subject codes and unit codes according to the sequence of the last actual locking moment, pushing the sorting result to an administrator for manual confirmation, and sequentially finally confirming the data of each subject code to obtain final corrected data.
4. A cross-system financial data processing apparatus according to claim 3, wherein each target system side further comprises:
and the financial data updating module is used for updating the accounting data corresponding to the same subject code after receiving the corrected information fed back by the source system end.
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 CN112699137A (en) | 2021-04-23 |
| CN112699137B true 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) |
Families Citing this family (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113489593B (en) * | 2021-06-30 | 2022-11-08 | 深圳前海微众银行股份有限公司 | JSON message checking method and JSON message checking device |
| CN114818612B (en) * | 2022-04-26 | 2025-06-06 | 中国农业银行股份有限公司 | A method for processing report code based on structured data and related equipment |
| CN115603860B (en) * | 2022-09-26 | 2025-12-16 | 中国建设银行股份有限公司 | Message comparison method, device, equipment and storage medium |
Citations (9)
| 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 |
| CN104156832A (en) * | 2014-08-28 | 2014-11-19 | 国家电网公司 | Intersystem data verification method and device |
| 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 data verification method and device |
| 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 reconciliation method, automatic reconciliation device, and computer-readable storage medium |
| WO2020243903A1 (en) * | 2019-06-04 | 2020-12-10 | 深圳海付移通科技有限公司 | Bookkeeping method, accounting system, account system, and payment system |
Family Cites Families (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2012108015A1 (en) * | 2011-02-09 | 2012-08-16 | 富士通株式会社 | Data synchronization method, data synchronization program, and data synchronization control device |
| US9367597B2 (en) * | 2013-11-18 | 2016-06-14 | International Business Machines Corporation | Automatically managing mapping and transform rules when synchronizing systems |
| US10402744B2 (en) * | 2013-11-18 | 2019-09-03 | International Busniess Machines Corporation | Automatically self-learning bidirectional synchronization of a source system and a target system |
| 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 |
| US10528544B2 (en) * | 2017-06-28 | 2020-01-07 | International Business Machines Corporation | Cooperative locking between databases integrated with distributed programming environments |
-
2021
- 2021-01-04 CN CN202110004074.2A patent/CN112699137B/en active Active
Patent Citations (9)
| 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 |
| CN104156832A (en) * | 2014-08-28 | 2014-11-19 | 国家电网公司 | Intersystem data verification method and device |
| CN105488720A (en) * | 2015-11-27 | 2016-04-13 | 国网北京市电力公司 | Accounting data processing method and device |
| CN106897342A (en) * | 2016-07-20 | 2017-06-27 | 阿里巴巴集团控股有限公司 | A data verification method and device |
| CN106408410A (en) * | 2016-11-29 | 2017-02-15 | 用友网络科技股份有限公司 | Automatic account checking method and device |
| 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 reconciliation method, automatic reconciliation device, and computer-readable storage medium |
Non-Patent Citations (1)
| Title |
|---|
| 财务管控系统与SAP 系统电子对帐平台的研究;魏永瑜;《信息通信》;第100页 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112699137A (en) | 2021-04-23 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN112699137B (en) | Cross-system financial data processing method and device | |
| US6282508B1 (en) | Dictionary management apparatus and a dictionary server | |
| CN100499462C (en) | Integrated processing system and method for the data exchange between different application systems | |
| CN101282524B (en) | Method, system and related apparatus for managing smart card | |
| CN109358912A (en) | A kind of visualization system and method for batch starting micro services | |
| CN108734454A (en) | Reimbursement processing method and system | |
| US6615153B2 (en) | Method for managing and using test system | |
| CN113543185B (en) | Automatic-opening-assistance-based 5G high-density base station rapid operation method and system | |
| CN117973330A (en) | Real-time collaborative editing method and system for job data template | |
| CN113935659A (en) | Distributed dispatching method, system, equipment and medium for credit approval work order | |
| CN112612802A (en) | Real-time data middlebox processing method, device and platform | |
| CN112242909B (en) | Method and device for generating management template, electronic equipment and storage medium | |
| CN112954190B (en) | Online adjustment method, device and equipment for industrial detection equipment parameters and storage medium | |
| CN113238880A (en) | File processing method and equipment based on RPA robot | |
| CN105608561A (en) | Method and apparatus for processing mail | |
| CN112632523B (en) | Offline login and working method and system of mobile terminal | |
| CN114500002A (en) | LDAP-based cluster account allocation method and system | |
| CN116346954A (en) | Data transmission system and method based on Internet of things | |
| CN115841312A (en) | Real-time acquisition and analysis system for enterprise management file data and acquisition terminal thereof | |
| CN111783125A (en) | Cloud platform data dynamic configuration method for big data | |
| CN112685501A (en) | Data synchronization method, device and system for center node and edge node | |
| CN117149361B (en) | Multi-terminal collaborative optimization system for training model | |
| CN110244912B (en) | Caching method of data distribution system | |
| CN109246119B (en) | PON system with authentication information automatic modification function | |
| CN121234380A (en) | A method for dynamic data configuration on a cloud platform for big data |
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 |