CN111754320B - Method, device and medium for canceling internal transaction certificates based on service management dimension - Google Patents
Method, device and medium for canceling internal transaction certificates based on service management dimension Download PDFInfo
- Publication number
- CN111754320B CN111754320B CN202010414145.1A CN202010414145A CN111754320B CN 111754320 B CN111754320 B CN 111754320B CN 202010414145 A CN202010414145 A CN 202010414145A CN 111754320 B CN111754320 B CN 111754320B
- Authority
- CN
- China
- Prior art keywords
- transaction
- internal
- dimension
- data
- accounting
- 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; 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
-
- 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/2455—Query execution
-
- 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
- G06Q20/00—Payment architectures, schemes or protocols
- G06Q20/38—Payment protocols; Details thereof
- G06Q20/382—Payment protocols; Details thereof insuring higher security of transaction
- G06Q20/3821—Electronic credentials
-
- 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/03—Credit; Loans; Processing thereof
-
- 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
Abstract
The application discloses a method, a device and a medium for canceling an internal transaction certificate based on a service management dimension. The method comprises the following steps: identifying an internal transaction credential from the accounting credentials of the group; the internal transaction certificate comprises business management dimension data, transaction data and certificate identification; extracting service management dimension data and certificate identification into a service management dimension table; checking the transaction data, and taking two internal transaction certificates with the transaction data matched with each other as internal associated transaction certificates; matching the transaction data in the internal association transaction certificate with the cancellation scheme table to match out a corresponding cancellation scheme; and generating a business dimension offset certificate. By the mode, more sufficient data support can be provided for lean management of group enterprises.
Description
Technical Field
The present application relates to the field of financial management information technology, and in particular, to a method for canceling an internal transaction credential based on a service management dimension, a device for canceling an internal transaction credential based on a service management dimension, and a computer storage medium.
Background
Internal association transactions generally refer to transactions that occur between a parent company and a subsidiary, and between a subsidiary and a subsidiary, within the scope of an enterprise group consisting of the parent company and all of its subsidiary, such as: internal purchase and sales, equity investments, etc. between parent and subsidiary companies or between subsidiary companies within a group. And the internal transaction business in the group enterprise requires merging and cancellation processing on the accounting system when the group issues the merging financial statement.
In the related art, the merging report of the group enterprises adopts a form of account and union, and compared with a manual form, the form of account and union has the characteristics of high data accuracy, high merging efficiency, high-grade data traceability and the like. However, the combined report generated by the current account-and-sum mode cannot meet the requirement of fine management.
Disclosure of Invention
The application provides a method for canceling an internal transaction certificate based on a service management dimension, a device for canceling the internal transaction certificate based on the service management dimension and a computer storage medium, which are used for solving the problem that a combined report is not fine enough in the related art.
In order to solve the technical problems, the application provides an internal transaction certificate cancellation method based on a service management dimension. The method comprises the following steps: identifying an internal transaction credential from the accounting credentials of the group; the internal transaction certificate comprises business management dimension data, transaction data and certificate identification; extracting service management dimension data and certificate identification into a service management dimension table; checking the transaction data, and taking two internal transaction certificates with the transaction data matched with each other as internal associated transaction certificates; matching the transaction data in the internal association transaction certificate with the cancellation scheme table to match out a corresponding cancellation scheme; and extracting transaction data in the internal association transaction certificate and service management dimension data in a service management dimension table determined according to the certificate identification in the internal association transaction certificate to a cancellation scheme so as to generate a service dimension cancellation certificate.
In order to solve the technical problems, the application provides an internal transaction certificate cancellation device based on a service management dimension. The apparatus includes a processor and a memory; the processor is coupled with the memory, and executes instructions during working to cooperate with the memory to realize the internal transaction credential cancellation method based on the service management dimension.
In order to solve the technical problems, the application provides a computer storage medium. The computer storage medium stores a computer program that is executed to implement the steps of the internal transaction credential cancellation method described above that are based on the business management dimension.
The application identifies the internal transaction certificate in the group accounting certificate, and extracts the service management dimension data in the internal transaction certificate to the service management dimension table; further, two internal transaction vouchers based on the same transaction service transaction parties are identified from the internal transaction vouchers as internal association transaction vouchers. And matching corresponding cancellation schemes according to the transaction data in the internal associated transaction credentials, and extracting business management dimension data in the business dimension table and the transaction data to the cancellation schemes to generate business dimension cancellation credentials containing the business management dimension data. The business dimension offset certificate can provide more dimension data for the combined report of the group, thereby laying a data foundation for lean management of the group.
Drawings
FIG. 1 is a flow chart of a first embodiment of a business management dimension based internal transaction credential cancellation method provided by the present application;
FIG. 2 is a flow chart of an embodiment of identifying internal transaction credentials from accounting credentials of a group according to the present application;
FIG. 3 is a flowchart of a second embodiment of a method for canceling internal transaction credentials based on a business management dimension according to the present application;
FIG. 4 is a schematic diagram illustrating an embodiment of a transaction credential cancellation device based on a business management dimension according to the present application;
fig. 5 is a schematic structural diagram of an embodiment of a computer storage medium provided by the present application.
Detailed Description
In order to better understand the technical solution of the present application for those skilled in the art, the method for canceling an internal transaction credential based on a service management dimension, the apparatus for canceling an internal transaction credential based on a service management dimension, and the computer storage medium provided by the present application are described in further detail below with reference to the accompanying drawings and detailed description.
The merging criteria of the merged financial statement is to provide the financial accounting report user with relevant accounting information such as enterprise financial conditions, operation results, cash flow and the like, and reflect the trusted responsibility fulfillment condition of the enterprise management layer, so that the financial accounting report user is facilitated to make operation decisions. The account and book method is based on the statement of each company, and the internal certificates reflecting the internal business are marked by compiling accounting certificates by the parent company and each subsidiary company during daily business processing. When the group company compiles the combined accounting report, the internal transaction certificate is screened out through the mark, the external certificate reflecting the external business of the whole group and the accounting certificate compiled in the group account book are used as the basis, a set of virtual group account book is formed together, and finally the combined accounting report of the whole group is generated according to the account book.
In recent years, with the demands of enterprise business and finance and further convergence and enterprise internal lean management, the original financial data needs to reflect more business information, and more business departments also need to use the financial information. On the other hand, as the requirements on the data quality are higher and higher, more and more group enterprises adopt the account merging method to merge the financial statement, and compared with the original manual account merging method, the account merging method has the advantages of high data accuracy, high merging efficiency, strong data traceability and the like, but the account merging method still has some defects, such as: accounting methods can only reach the accounting subject level at present and cannot be embodied on the business dimension carried on the certificate. Due to the lack of business dimension data, there is a lack of adequate data support and response to the enterprise's internal lean management aspects.
In order to solve the above problems, the present application provides the following embodiments.
Referring to fig. 1, fig. 1 is a flowchart of a first embodiment of a method for canceling an internal transaction credential based on a service management dimension according to the present application. The embodiment comprises the following steps:
s11: an internal transaction credential is identified from the accounting credentials of the group.
The accounting document of the group comprises the accounting document uploaded by the parent company and the subsidiary company. The accounting document comprises an internal transaction document, an external transaction document and the like. The internal transaction certificate refers to an accounting certificate generated by a transaction between a parent company and a subsidiary company in a group or between a subsidiary company and a subsidiary company in the group, and the external transaction certificate refers to an accounting certificate generated by a transaction between the parent company or the subsidiary company and an external enterprise.
In this embodiment, the accounting document includes service management dimension data, transaction data and document identification. Business dimension management data includes, for example, bank accounts, asset types, purchase orders, cost details, and the like. The transaction data includes, for example, transaction units, accounting subjects, directions for loans, amounts, and the like. The voucher identification refers to the unique number of the accounting voucher, and the voucher identification is mapped in association with service management dimension data and transaction data in the accounting voucher.
Thus, internal transaction credentials may be identified from the accounting credentials of the group based on the transaction data. Referring to fig. 2, fig. 2 is a flowchart illustrating an embodiment of identifying an internal transaction credential from a group of accounting credentials according to the present application. The embodiment comprises the following steps:
s111: and judging whether the accounting subjects in the accounting document are target business subjects or not.
And acquiring accounting subjects in the accounting document, and comparing the accounting subjects in the accounting document with preset target transaction subjects. If the accounting subject in the accounting document is the target transaction subject, executing S112; if the accounting subject in the accounting document is not the target transaction subject, the accounting document can be determined not to be the internal transaction document.
The target past subjects are accounting subjects related to offset, and are stored in a target past subject table in advance. The target to-and-from subjects are, for example, accounts receivable, accounts payable, prepaid accounts, and receivables, etc.
In this embodiment, the target past subjects are first-level subjects.
S112: it is determined whether the current unit is an internal current unit.
After the accounting subjects in the accounting document are determined to be the target incoming and outgoing subjects, whether the incoming and outgoing units in the accounting document are internal incoming and outgoing units or not is continuously judged.
Specifically, accounting subjects on the accounting document are hooked to the units of business in the ancillary accounting. The units of the current and the next are divided into two types: an internal unit of traffic and an external unit of traffic. When the current unit is newly added, the internal current unit is marked. Therefore, whether the unit of business is an internal unit of business can be determined based on the indicia of the unit of business.
If the unit of traffic is the internal unit of traffic, S113 is executed.
S113: and determining the accounting document as an internal transaction document.
When the accounting subjects in the accounting document are both target transaction subjects and the transaction units to which the accounting document is attached are internal transaction units, the accounting document can be determined to be an internal transaction document.
S12: the service management dimension data and the certificate identification are extracted into a service management dimension table.
After the internal transaction certificate is identified, the service dimension management data and the certificate identification in the internal transaction certificate are classified and stored in a service dimension table. The service management dimension table is shown in table 1. The structure and data in the table of the present application are only examples, and specific data is based on actual requirements for service management dimensions and accounting certificates, which the present application is not limited to.
TABLE 1 service management dimension List
In this embodiment, the service management dimension table includes service management dimension data extracted from other data tables in addition to the service management dimension data hooked on the internal transaction certificate.
Specifically, the other data tables and the business management dimension table have an association mapping relation, and after the business management dimension data on the internal transaction certificate is extracted, the business management dimension data in the other data tables of the enterprise are extracted into the business management dimension table based on the business management dimension data on the internal transaction certificate.
For example, there is no business management dimension data for the business management dimension of product services on the internal transaction voucher, but there is business management dimension data for the profit center. And in the other data table with the association mapping relation with the business management dimension table, the association relation between the profit center and the product service is stored, and after the business management dimension data of the profit center is extracted from the internal transaction certificate, the business management dimension data of the product service is extracted from the other data table into the business management dimension table according to the business management dimension data of the profit center.
S13: checking the transaction data, and taking two internal transaction certificates with the transaction data matched with each other as internal associated transaction certificates.
After the internal transaction certificate is identified from the accounting certificates of the group, the internal associated transaction certificate generated on the basis of the same internal transaction service on both sides of the transaction needs to be further identified from the internal transaction certificates so as to be capable of being offset on the basis of the internal associated transaction certificate in the follow-up.
Specifically, the internal transaction certificates of the transaction parties with opposite transaction units, accounting subjects and lending directions and equal amounts are matched to be used as the internal association transaction certificates.
For example, the units to and from the internal transaction voucher 001 of the a unit are the B units, the accounting subjects are accounts receivable and lending directions are lending, the transaction amount is 10000.00 yuan, the units to and from the internal transaction voucher 002 of the B unit are the a units, the accounting subjects are accounts payable and lending directions are lending, and the transaction amount is 10000.00 yuan. Then the internal transaction credential 001 and the internal transaction credential 002 may be determined to be internal associated transaction credentials according to the matching rules.
When the internal transaction credentials of one party of the transaction match a plurality of (more than or equal to 2) internal transaction credentials of the other party of the transaction, the internal associated transaction credentials can be further determined according to the uploading time of the internal transaction credentials. For example, an internal transaction credential of another party to the transaction that is more closely timed to the uploading of the internal transaction credential of the party to the transaction is determined as the internal associated transaction credential.
S14: and matching the transaction data in the internal association transaction certificate with the cancellation scheme table to match out a corresponding cancellation scheme.
In this embodiment, different cancellation schemes are stored in advance. The cancellation scheme is determined by matching the transaction data in the internal associated transaction voucher with the accounting and lending directions in the cancellation scheme table. The cancellation scheme table stores the association relation between the cancellation scheme and the accounting subject and the lending direction. The structure of the cancellation scheme table is shown in table 2.
TABLE 2 cancellation scheme table
Specifically, accounting subjects and lending directions in the internal associated transaction vouchers are extracted. And matching the accounting subjects and the borrowing directions in the cancellation scheme table, and if the accounting subjects and the borrowing directions are consistent with the accounting subjects and the borrowing directions corresponding to the cancellation schemes in the cancellation scheme table, determining that the cancellation scheme is the cancellation scheme corresponding to the internal association transaction certificate.
Further, after the cancellation schemes are matched, a flag of whether the corresponding cancellation schemes in the cancellation scheme table match dimensions is obtained. If the mark of the matching dimension in the cancellation scheme table is yes, when the cancellation certificate is generated, the service management dimension is synchronously cancelled, namely, the service dimension cancellation certificate is generated.
S15: and extracting transaction data in the internal association transaction certificate and service management dimension data in a service dimension table determined according to the certificate identification in the internal association transaction certificate to a cancellation scheme so as to generate a service dimension cancellation certificate.
And extracting transaction data to and from the internal association transaction voucher into the cancellation scheme based on the cancellation scheme matched with the internal association transaction voucher. In addition, since the service management dimension data in the internal association transaction credential is already extracted into the service management dimension table, and the service management dimension table further includes the service management dimension data extracted from other data tables into the service management dimension table, the service management dimension data corresponding to the same credential identifier in the service dimension table needs to be added into the cancellation scheme according to the credential identifier in the internal association transaction credential, so as to generate the service dimension cancellation credential.
For example, referring to tables 3-5, table 3 is an a-unit internal association transaction credential, table 4 is a B-unit internal association transaction credential, and table 5 is a business dimension cancellation credential generated based on tables 3 and 4.
TABLE 3 internal associated transaction credentials for A units
Table 4.B units of internal associated transaction credentials
TABLE 5 Business dimension offset vouchers
After the offset voucher is generated, a summary offset voucher can be further generated according to the service dimension offset vouchers of the plurality of internal transaction services. The aggregate offset vouchers are shown in table 6.
TABLE 6 summarizing the offset vouchers
Based on the business dimension offset vouchers and the summary offset vouchers, multi-dimension offset data can be provided for group enterprises.
In this embodiment, the internal transaction credentials in the group accounting credentials are identified, and service management dimension data in the internal transaction credentials are extracted into a service management dimension table; further, two internal transaction vouchers based on the same transaction service transaction parties are identified from the internal transaction vouchers as internal association transaction vouchers. And matching corresponding cancellation schemes according to the transaction data in the internal associated transaction credentials, and extracting business management dimension data in the business dimension table and the transaction data to the cancellation schemes to generate business dimension cancellation credentials containing the business management dimension data. The business dimension offset certificate can provide more dimension data for the combined report of the group, thereby laying a data foundation for lean management of the group.
Before identifying the service management dimension, the service management dimension definition table needs to be stored according to the definition instruction of the service management dimension. Referring to fig. 3, fig. 3 is a flowchart illustrating a second embodiment of a method for canceling an internal transaction credential based on a service management dimension according to the present application. The present embodiment is a first embodiment of the method for canceling internal transaction certificates based on the service management dimension, so the same steps are not repeated here. The embodiment comprises the following steps:
s21: and receiving a dimension name, a dimension type and a definition instruction of whether the service management dimension is in the accounting document.
In actual management, the group enterprise firstly analyzes and plans the service management dimension which is needed to be used, and defines the service management dimension which is possibly used.
The definition of the business management dimension includes definition of dimension name, dimension type, and whether in accounting documents, etc.
S22: in response to the definition instruction, a service management dimension table is generated.
And generating a service management dimension table according to the definition instruction of the service management dimension. The service management dimension definition table is shown in table 7.
TABLE 7 service management dimension definition table
| Dimension internal identification | Dimension type | Dimension name | Corresponding field | Whether or not to account for |
| 1 | 1 | Bank account | DIM01 | Is that |
| 2 | 2 | Asset type | DIM02 | Is that |
| 3 | 1 | Purchase order | DIM03 | Is that |
| 4 | 1 | Cost center | DIM04 | Is that |
| 5 | 1 | Profit center | DIM05 | Is that |
| 6 | 2 | Product service | DIM06 | Whether or not |
| 7 | 2 | Cost details | DIM07 | Is that |
| … | … | … | … | … |
Wherein the dimension internal identifier is the only key of the dimension definition table, and the value is automatically generated.
Dimension type: the data items are divided into two types, 1 is a main data item, and 2 is an enumeration item.
Dimension name: the specific business management dimension name, the group enterprise can be customized.
The corresponding fields: the service dimension management data mapping method is used for the service management dimension data table, the service dimension canceling certificate and the service dimension management data association mapping between the summarizing canceling certificates.
Whether to bill: some business management dimensions are selected and entered when accounting documents are filled, then marked as yes. Some business management dimensions are converted from other data sheet dimensions, and if not, such business management dimensions and business dimension management data are not directly embodied on the accounting document.
S23: an internal transaction credential is identified from the accounting credentials of the group.
S24: the service management dimension data and the certificate identification are extracted into a service management dimension table.
S25: checking the transaction data, and taking two internal transaction certificates with the transaction data matched with each other as internal associated transaction certificates.
S26: and matching the transaction data in the internal association transaction certificate with the cancellation scheme table to match out a corresponding cancellation scheme.
S27: and extracting transaction data in the internal association transaction certificate and service management dimension data in a service dimension table determined according to the certificate identification in the internal association transaction certificate to a cancellation scheme so as to generate a service dimension cancellation certificate.
In this embodiment, the group enterprise can define the service management dimension according to its own needs, and can more flexibly use the service dimension management data, so as to reflect the real financial and service conditions, provide more dimension data for the consolidated report, and lay a data foundation for lean management of the enterprise.
The embodiment of the method for canceling the internal transaction certificate based on the service management dimension is implemented by the internal transaction certificate canceling device based on the service management dimension, so the application also provides the internal transaction certificate canceling device based on the service management dimension, please refer to fig. 4, fig. 4 is a schematic structural diagram of an embodiment of the internal transaction certificate canceling device based on the service management dimension. The internal transaction credential cancellation device 100 based on the service management dimension of the present embodiment may include a processor 101 and a memory 102 that are connected to each other, and the internal transaction credential cancellation device 100 based on the service management dimension of the present embodiment may implement an embodiment of the internal transaction credential cancellation method based on the service management dimension. Wherein the memory 102 is used for storing accounting documents, and the processor 101 identifies internal transaction documents from accounting documents of a group; extracting service management dimension data and certificate identification into a service management dimension table; checking the transaction data, and taking two internal transaction certificates with the transaction data matched with each other as internal associated transaction certificates; matching the transaction data in the internal association transaction certificate with the cancellation scheme table to match out a corresponding cancellation scheme; and extracting transaction data in the internal association transaction certificate and service management dimension data in a service management dimension table determined according to the certificate identification in the internal association transaction certificate to a cancellation scheme so as to generate a service dimension cancellation certificate.
The processor 101 may be an integrated circuit chip with signal processing capability. Processor 101 may also be a general purpose processor, a Digital Signal Processor (DSP), an Application Specific Integrated Circuit (ASIC), a Field Programmable Gate Array (FPGA) or other programmable logic device, discrete gate or transistor logic, discrete hardware components. A general purpose processor may be a microprocessor or the processor may be any conventional processor or the like.
For the method of the above embodiment, which may exist in the form of a computer program, the present application proposes a computer storage medium, and referring to fig. 5, fig. 5 is a schematic structural diagram of an embodiment of the computer storage medium provided by the present application. The computer storage medium 200 of this embodiment stores therein a computer program 201 executable to implement the method of the above-described embodiment of the internal transaction credential cancellation method based on the business management dimension.
The computer storage medium 200 of this embodiment may be a medium that may store program instructions, such as a usb disk, a removable hard disk, a Read-Only Memory (ROM), a random access Memory (RAM, random Access Memory), a magnetic disk, or an optical disc, or may be a server that stores the program instructions, and the server may send the stored program instructions to other devices for execution, or may also self-execute the stored program instructions.
In the several embodiments provided in the present application, it should be understood that the disclosed method and apparatus may be implemented in other manners. For example, the apparatus embodiments described above are merely illustrative, e.g., the division of modules or units is merely a logical function division, and there may be additional divisions when actually implemented, e.g., multiple units or components may be combined or integrated into another apparatus, or some features may be omitted or not performed. Alternatively, the coupling or direct coupling or communication connection shown or discussed with each other may be an indirect coupling or communication connection via some interfaces, devices or units, which may be in electrical, mechanical or other form.
The units described as separate units may or may not be physically separate, and units shown as units may or may not be physical units, may be located in one place, or may be distributed over a plurality of network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the embodiment.
In addition, each functional unit in the embodiments of the present application may be integrated in one processing unit, or each unit may exist alone physically, or two or more units may be integrated in one unit. The integrated units may be implemented in hardware or in software functional units.
The integrated units, if implemented in the form of software functional units and sold or used as stand-alone products, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present application may be embodied in essence or a part contributing to the prior art or all or part of the technical solution in the form of a software product stored in a storage medium, including several instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) or a processor (processor) to execute all or part of the steps of the methods of the embodiments of the present application. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a Read-Only Memory (ROM), a random access Memory (RAM, random Access Memory), a magnetic disk, or an optical disk, or other various media capable of storing program codes.
The foregoing is only the embodiments of the present application, and therefore, the patent scope of the application is not limited thereto, and all equivalent structures or equivalent processes using the descriptions of the present application and the accompanying drawings, or direct or indirect application in other related technical fields, are included in the scope of the application.
Claims (9)
1. A method for internal transaction credential cancellation based on a business management dimension, the method comprising:
identifying the internal transaction credential from the accounting credentials of the group; wherein the internal transaction voucher comprises service management dimension data, transaction data and voucher identification; the certificate identification refers to a unique number of the accounting certificate, and the certificate identification is mapped in association with service management dimension data and transaction data in the accounting certificate;
extracting the service management dimension data and the certificate identification into a service management dimension table;
checking the transaction data, and taking two internal transaction certificates with the transaction data matched with each other as internal associated transaction certificates; the transaction data at least comprises accounting subjects and lending directions;
extracting accounting subjects and lending directions in the internal association transaction vouchers;
matching in a cancellation scheme table using the accounting subject and the lending direction; wherein, the offset scheme table stores the association relation between the offset scheme and the accounting subject and the lending direction;
if the accounting subjects and the borrowing directions are consistent with the accounting subjects and the borrowing directions corresponding to the cancellation schemes in the cancellation scheme table, determining that the cancellation scheme is the cancellation scheme of the internal association transaction certificate;
and extracting transaction data to and from the internal association transaction certificate and service management dimension data in the service management dimension table determined according to the certificate identification in the internal association transaction certificate to the cancellation scheme so as to generate a service dimension cancellation certificate.
2. The method of claim 1, wherein the extracting the business management dimension data and the credential identification into a business dimension table, further comprising thereafter:
and extracting service management dimension data in other data tables of the group into the service management dimension table based on the service management dimension data.
3. The method of claim 2, wherein prior to identifying the internal transaction credential from among the group's accounting credentials, comprising:
receiving a dimension name, a dimension type and a definition instruction whether in an accounting document of a service management dimension;
and responding to the definition instruction, and generating the service management dimension table.
4. The method of claim 1, wherein the transaction data includes accounting and transaction units, the identifying the internal transaction credential from the group of accounting credentials comprising:
judging whether the accounting subjects in the accounting document are target business subjects or not;
if the accounting subject is a target current subject, judging whether the current unit is an internal current unit or not;
and if the current unit is an internal current unit, determining that the accounting document is an internal transaction document.
5. The method of claim 1, wherein the transaction data further includes transaction units, accounting subjects, lending directions, and amounts, the checking the transaction data, and the matching of the transaction data to two internal transaction vouchers as internal associated transaction vouchers, comprising:
and matching the internal transaction certificates of the transaction parties with the same amount, which are opposite in transaction units, accounting subjects and lending directions, as internal associated transaction certificates.
6. The method of claim 1, wherein the cancellation scheme table further includes dimensions for matching, and wherein the extracting the transaction data from the internal associated transaction credential and the transaction management dimension data from the transaction dimension table determined from the credential identification in the internal associated transaction credential into the cancellation scheme to generate a transaction dimension cancellation credential further includes:
acquiring a mark of whether the offset scheme matches a dimension;
and if the mark of the matching dimension is yes, generating the business dimension cancellation certificate.
7. The method of claim 1, wherein the extracting transaction data from the internal associated transaction credentials and the transaction management dimension data in the transaction management dimension table determined from the credential identification in the internal associated transaction credentials into the cancellation scheme to generate a transaction dimension cancellation credential, comprises:
and summarizing the business dimension offset certificates to obtain summarized offset certificates.
8. An internal transaction credential cancellation device based on a business management dimension, the device comprising a processor and a memory; the processor is coupled to the memory and operative to execute instructions to implement, in cooperation with the memory, the method for transaction management dimension-based internal transaction credential cancellation as claimed in any one of claims 1 to 7.
9. A computer storage medium storing a computer program to be executed to implement the steps of the business management dimension based internal transaction credential cancellation method of any of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010414145.1A CN111754320B (en) | 2020-05-15 | 2020-05-15 | Method, device and medium for canceling internal transaction certificates based on service management dimension |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010414145.1A CN111754320B (en) | 2020-05-15 | 2020-05-15 | Method, device and medium for canceling internal transaction certificates based on service management dimension |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111754320A CN111754320A (en) | 2020-10-09 |
| CN111754320B true CN111754320B (en) | 2023-09-19 |
Family
ID=72673422
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010414145.1A Active CN111754320B (en) | 2020-05-15 | 2020-05-15 | Method, device and medium for canceling internal transaction certificates based on service management dimension |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111754320B (en) |
Citations (13)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2004178480A (en) * | 2002-11-29 | 2004-06-24 | Fujitsu Ltd | Transaction slip management method and transaction slip management program |
| CN103020782A (en) * | 2012-12-25 | 2013-04-03 | 远光软件股份有限公司 | Automatic identification-extraction method and system for internal connected transactions |
| CN103426063A (en) * | 2013-08-19 | 2013-12-04 | 远光软件股份有限公司 | Coprocessing method and coprocessing device of inner related business |
| CN103440557A (en) * | 2013-08-19 | 2013-12-11 | 远光软件股份有限公司 | Generation method and system for group consolidated accounts and consolidated statements |
| CN103559275A (en) * | 2013-11-05 | 2014-02-05 | 中铁二十二局集团有限公司 | Internal transaction business identification and offsetting method and system |
| CN103761599A (en) * | 2013-12-23 | 2014-04-30 | 远光软件股份有限公司 | Method and device for generating compensating vouchers of internal transaction businesses |
| CN104484762A (en) * | 2014-12-19 | 2015-04-01 | 浪潮通用软件有限公司 | Multidimensional statement consolidating method based on consolidated statement |
| JP2016081484A (en) * | 2014-10-22 | 2016-05-16 | 富士通株式会社 | Voucher confirmation control program, voucher confirmation control method and voucher confirmation control device |
| CN108182630A (en) * | 2018-02-02 | 2018-06-19 | 金蝶软件（中国）有限公司 | Counteracting method and device in a kind of group financial report |
| JP2018116602A (en) * | 2017-01-20 | 2018-07-26 | 株式会社マネーフォワード | Voucher processing system and voucher processing method |
| CN109669948A (en) * | 2018-12-24 | 2019-04-23 | 安徽经邦软件技术有限公司 | A kind of quick financial statement combination system and its method based on data warehouse |
| CN110135882A (en) * | 2019-03-26 | 2019-08-16 | 口口相传(北京)网络技术有限公司 | Business checks and writes off the integration method and device, storage medium, terminal of data |
| CN110765748A (en) * | 2019-09-02 | 2020-02-07 | 北京东软望海科技有限公司 | Intelligent generation system and method for budget accounting document |
Family Cites Families (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| AU2012202173B2 (en) * | 2011-04-18 | 2013-09-05 | Castle Bookkeeping Wizard Pty Ltd | System and method for processing a transaction document including one or more financial transaction entries |
| US10430875B2 (en) * | 2016-08-02 | 2019-10-01 | Dun & Bradstreet Emerging Businesses Corp. | Integration and enhancement of business systems with external services |
-
2020
- 2020-05-15 CN CN202010414145.1A patent/CN111754320B/en active Active
Patent Citations (13)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2004178480A (en) * | 2002-11-29 | 2004-06-24 | Fujitsu Ltd | Transaction slip management method and transaction slip management program |
| CN103020782A (en) * | 2012-12-25 | 2013-04-03 | 远光软件股份有限公司 | Automatic identification-extraction method and system for internal connected transactions |
| CN103426063A (en) * | 2013-08-19 | 2013-12-04 | 远光软件股份有限公司 | Coprocessing method and coprocessing device of inner related business |
| CN103440557A (en) * | 2013-08-19 | 2013-12-11 | 远光软件股份有限公司 | Generation method and system for group consolidated accounts and consolidated statements |
| CN103559275A (en) * | 2013-11-05 | 2014-02-05 | 中铁二十二局集团有限公司 | Internal transaction business identification and offsetting method and system |
| CN103761599A (en) * | 2013-12-23 | 2014-04-30 | 远光软件股份有限公司 | Method and device for generating compensating vouchers of internal transaction businesses |
| JP2016081484A (en) * | 2014-10-22 | 2016-05-16 | 富士通株式会社 | Voucher confirmation control program, voucher confirmation control method and voucher confirmation control device |
| CN104484762A (en) * | 2014-12-19 | 2015-04-01 | 浪潮通用软件有限公司 | Multidimensional statement consolidating method based on consolidated statement |
| JP2018116602A (en) * | 2017-01-20 | 2018-07-26 | 株式会社マネーフォワード | Voucher processing system and voucher processing method |
| CN108182630A (en) * | 2018-02-02 | 2018-06-19 | 金蝶软件（中国）有限公司 | Counteracting method and device in a kind of group financial report |
| CN109669948A (en) * | 2018-12-24 | 2019-04-23 | 安徽经邦软件技术有限公司 | A kind of quick financial statement combination system and its method based on data warehouse |
| CN110135882A (en) * | 2019-03-26 | 2019-08-16 | 口口相传(北京)网络技术有限公司 | Business checks and writes off the integration method and device, storage medium, terminal of data |
| CN110765748A (en) * | 2019-09-02 | 2020-02-07 | 北京东软望海科技有限公司 | Intelligent generation system and method for budget accounting document |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111754320A (en) | 2020-10-09 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US7114649B2 (en) | Automatic generation of bank deposits | |
| US20190228419A1 (en) | Dynamic self-learning system for automatically creating new rules for detecting organizational fraud | |
| Arruñada | Mandatory accounting disclosure by small private companies | |
| US20070063016A1 (en) | System and method for cash management in a commercial and retail environment | |
| US20060178957A1 (en) | Commercial market determination and forecasting system and method | |
| US20130282426A1 (en) | Targeted Security Implementation Through Security Loss Forecasting | |
| US20060184585A1 (en) | Communication point delivery instructions | |
| Bian et al. | Non‐interest income, profit, and risk efficiencies: Evidence from commercial banks in China | |
| CN108734563B (en) | Method for automatically generating intelligent accounting document | |
| US20150106243A1 (en) | Aggregation of item-level transaction data for a group of individuals | |
| Tucker | Financial performance of selected microfinance institutions: Benchmarking progress to sustainability | |
| Xu et al. | A framework for the evaluation of InsurTech | |
| CN105809538A (en) | Credit scoring method based on B2B financing transaction | |
| CN107798602B (en) | Management method and system for interest loan of public accumulation fund | |
| US20140136398A1 (en) | System and method for consolidating account data | |
| US20210073805A1 (en) | Embedded data transaction exchange platform | |
| CN111754320B (en) | Method, device and medium for canceling internal transaction certificates based on service management dimension | |
| CN110750302A (en) | Accounting production line accounting method for accounting | |
| CN114971825A (en) | System for generating financial voucher based on retail business and financial voucher generating method thereof | |
| US7752091B2 (en) | Flexible assignment scheme for financial statement items in an automated accounting system | |
| CN113191881A (en) | Financial business supervision data processing method, device and system based on block chain | |
| US20060212369A1 (en) | Multiple dimension closings | |
| Kim | Investment decisions, debt renegotiation friction, and agency conflicts | |
| CN110502503A (en) | Financial data record, access and the system managed | |
| JP2014215824A (en) | Fluidization management system for electronically recorded credits |
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 |