Business receipt-based debt recombination business profit and loss calculation method and device, terminal and medium
By obtaining the identification information of user configuration, automatically rendering document parameters, connecting to the data system and performing profit and loss calculations, the problem of inefficiency of debt restructuring business under the traditional ERP model is solved, and efficient and accurate data processing and calculation are achieved.
Patent Information
- Application Number
- CN202510612224.6
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2025-05-13
- Publication Date
- 2025-08-19
AI Technical Summary
Under the traditional ERP model, the processing efficiency of debt restructuring business is inefficient and prone to human errors, and cannot conduct detailed statistical analysis. The existing technology cannot effectively solve the complexity and data processing needs of debt restructuring business.
By obtaining the user-configured communication unit identification and reorganization business form identification, automatically rendering the target document parameters, connecting to the target data system to obtain data, and using the target formula engine to perform reorganization profit and loss calculations, reducing manual entry, and improving data accuracy and calculation results.
It realizes automated data processing of debt restructuring business, reduces the workload of manual entry, improves work efficiency and data accuracy, and ensures the accuracy and reliability of calculation results.
Smart Images

Figure CN120509979A_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the technical field of ERP financial management, and in particular to a method, device, terminal and medium for calculating profit and loss of debt restructuring business based on business documents. Background Art
[0002] Debt restructuring is a common and important economic activity in corporate operations. It refers to a transaction whereby the creditor and debtor reach a new agreement on the timing, amount, or method of debt repayment, without changing the counterparty, through agreement or court ruling.
[0003] However, under the traditional ERP (Enterprise Resource Planning) model, enterprises face numerous challenges in handling debt restructuring. Due to the inherent complexity of debt restructuring, involving numerous business documents and data, and different restructuring business forms may require different processing rules and calculation methods, enterprises primarily handle debt restructuring through manual entry of vouchers into the ERP system, with the entire management process conducted entirely offline. For example, when conducting debt restructuring, enterprises need to collect and organize a large number of business documents, such as account information of business entities and relevant agreements for the restructuring business, and then manually enter this information into the ERP system. This approach is not only inefficient and prone to human error, but also makes it impossible to conduct detailed statistical analysis of debt restructuring business. Summary of the Invention
[0004] To solve the above problems, the present invention provides a method, device, terminal and medium for calculating the profit and loss of debt restructuring business based on business documents, which reduces the workload of manual data entry, improves work efficiency, data accuracy and reliability, and at the same time calculates the restructuring profit and loss according to the data in the target sub-table through the target formula engine to ensure the accuracy of the calculation results.
[0005] In a first aspect, the technical solution of the present invention provides a method for calculating profit and loss of a debt restructuring business based on business documents, comprising the following steps: Obtain the user-configured trade entity ID and reorganized business form ID; Respond to the sub-table rendering instruction, retrieve the target document parameters according to the reorganized business form identifier, and render the target sub-table and its field information according to the target document parameters; Respond to the data retrieval instruction, connect to the target data system according to the reorganized business form identifier, and obtain the target data in the target data system according to the transaction unit identifier; Fill the acquired target data into the corresponding fields of the target subtable; In response to the profit and loss calculation instruction, the target formula engine is called according to the reorganization business form identifier, and the reorganization profit and loss calculation is performed based on the data in the target sub-table through the target formula engine.
[0006] In an optional embodiment, responding to the sub-table rendering instruction, retrieving target document parameters according to the reorganized business form identifier, and rendering the target sub-table and its field information according to the target document parameters specifically includes: In response to the sub-table rendering instruction, the creditor's rights information document parameter and the profit and loss information document parameter are obtained from the first storage area; Render the debt information subtable and its field information on the front-end page according to the debt information document parameters; Render the profit and loss information sub-table and its field information on the front-end page according to the profit and loss information document parameters; Retrieving a pre-built first mapping relationship from the second storage area, the first mapping relationship storing a mapping relationship between a reorganization business form identifier and a reorganization business document parameter data packet identifier; Filtering the target reorganization business document parameter data packet identifier according to the first mapping relationship; According to the target reorganized business document parameter data packet identifier, the target reorganized business document parameter data packet is obtained from the third storage area; Parse the target reorganization business document parameter data packet to obtain the target reorganization business document parameters; Render the target reorganization business subtable and its field information on the front-end page according to the target reorganization business document parameters.
[0007] In an optional embodiment, responding to the data retrieval instruction, connecting to the target data system according to the reorganized business form identifier, and obtaining target data in the target data system according to the transaction unit identifier specifically includes: Responding to the data retrieval instruction, parsing the data retrieval instruction, and obtaining the reorganized business form identifier and the transaction unit identifier contained in the data retrieval instruction; Retrieving a pre-built second mapping relationship from the second storage area, the second mapping relationship storing a mapping relationship between the reorganized business form identifier and the business data system identifier; Filtering the target business data system identifier according to the second mapping relationship; Obtaining a target business data system request parameter package from a third storage area according to the target data system identifier; Parse the target business data system request parameter package to obtain the target business data system request parameters; Construct the business data retrieval instruction by using the business unit identifier and the target business data system request parameters; Establish a connection with the target business data system according to the business data retrieval instruction, and obtain the target business data from the target business data system according to the trading unit identifier.
[0008] In an optional embodiment, responding to the data retrieval instruction, connecting to the target data system according to the reorganized business form identifier, and obtaining target data in the target data system according to the transaction unit identifier further includes: Retrieving a claim data system request parameter package from the third storage area; Parse the request parameter package of the creditor's rights data system to obtain the creditor's rights data system request parameters; Construct the transaction unit ID and the creditor's rights data system request parameters into a creditor's rights data retrieval instruction; Establish a connection with the debt data system according to the debt data retrieval instruction, and obtain the target debt data from the debt data system according to the transaction unit identifier.
[0009] In an optional implementation, filling the acquired target data into corresponding fields of the target sub-table specifically includes: Fill the target debt data into the debt information subtable; Fill the target business data into the target reorganization business subtable.
[0010] In an optional embodiment, in response to the profit and loss calculation instruction, a target formula engine is called according to the restructuring business form identifier, and the restructuring profit and loss calculation is performed by the target formula engine according to the data in the target sub-table, specifically including: Responding to a profit and loss calculation instruction, parsing the profit and loss calculation instruction, and obtaining a reorganized business form identifier contained in the profit and loss calculation instruction; Retrieving a pre-built third mapping relationship from the second storage area, the third mapping relationship storing a mapping relationship between the reorganized business form identifier and the formula engine identifier; Filter the target formula engine identifier according to the third mapping relationship; According to the target formula engine identifier, obtaining the target formula engine from the third storage area; The target formula engine is used to perform reorganized profit and loss calculations based on the data in the target sub-table.
[0011] In an optional embodiment, the target formula engine performs a restructuring profit and loss calculation based on the data in the target sub-table, specifically including: Obtain target debt data from the debt information sub-table and target business data from the target restructuring business sub-table; The target debt data and target business data are processed through the target formula engine to obtain the restructuring profit and loss.
[0012] In a second aspect, the technical solution of the present invention provides a debt restructuring business profit and loss calculation device based on business documents, comprising: The module for obtaining the configuration parameters of the reorganization business is used to obtain the user-configured business entity identifier and the reorganization business form identifier; The sub-table rendering module is used to respond to the sub-table rendering instruction, retrieve the target document parameters according to the reorganized business form identifier, and render the target sub-table and its field information according to the target document parameters; The target data acquisition module is used to respond to the data retrieval instruction, connect to the target data system according to the reorganized business form identifier, and obtain the target data in the target data system according to the trading unit identifier; The target data filling module is used to fill the acquired target data into the corresponding fields of the target subtable; The restructuring profit and loss calculation module is used to respond to the profit and loss calculation instruction, call the target formula engine according to the restructuring business form identifier, and perform restructuring profit and loss calculation based on the data in the target sub-table through the target formula engine.
[0013] In a third aspect, the technical solution of the present invention provides a terminal, including: A memory device for storing a debt restructuring business profit and loss calculation program based on business documents; A processor is used to implement the steps of the debt restructuring business profit and loss calculation method based on business documents as described in any of the above items when executing the debt restructuring business profit and loss calculation program based on business documents.
[0014] In a fourth aspect, the technical solution of the present invention provides a computer-readable storage medium, on which a debt restructuring business profit and loss calculation program based on business documents is stored. When the debt restructuring business profit and loss calculation program based on business documents is executed by a processor, the steps of the debt restructuring business profit and loss calculation method based on business documents as described in any of the above items are implemented.
[0015] It can be seen from the above technical solutions that the present application has the following advantages: first, the sub-table is rendered according to the user configuration parameters, and the target data is extracted from the target data system, and then the extracted target data is filled into the corresponding fields of the sub-table, and finally the pre-built corresponding formula engine is called according to the configuration parameters, so that the formula engine performs calculations based on the target data to obtain the profit and loss of the restructuring business. The present invention greatly reduces the workload of manual data entry and improves work efficiency by automatically obtaining the user-configured business unit identifier and restructuring business form identifier, automatically calling the target document parameters based on these identifiers, connecting to the target data system to obtain the target data, and automatically filling the data into the target sub-table. The automated data acquisition and filling process avoids data entry errors caused by human factors, improves the accuracy and reliability of the data, and at the same time, the target formula engine performs restructuring profit and loss calculations based on the data in the target sub-table to ensure the accuracy of the calculation results. BRIEF DESCRIPTION OF THE DRAWINGS
[0016] In order to more clearly illustrate the technical solution of the present application, the following is a brief introduction to the drawings required for the description. Obviously, the drawings described below are only some embodiments of the present application. For ordinary technicians in this field, other drawings can be obtained based on these drawings without any creative work.
[0017] Figure 1 A flowchart of a method for calculating profit and loss of a debt restructuring business based on business documents is provided in an embodiment of the present invention.
[0018] Figure 2 A schematic block diagram of the structure of a debt restructuring business profit and loss calculation system based on business documents provided in an embodiment of the present invention.
[0019] Figure 3 A schematic diagram of the structure of a terminal provided by an embodiment of the present invention. DETAILED DESCRIPTION
[0020] In order to make the application objectives, features, and advantages of this application more obvious and easy to understand, the technical solutions protected by this application will be clearly and completely described below using specific embodiments and drawings. Obviously, the embodiments described below are only part of the embodiments of this application, not all of them. Based on the embodiments in this application, all other embodiments obtained by ordinary technicians in this field without making creative efforts are within the scope of protection of this application.
[0021] Unless otherwise defined, all technical and scientific terms used herein have the same meaning as those commonly understood by those skilled in the art of the present invention. The terms used in this specification of the present invention are only for the purpose of describing specific embodiments and are not intended to limit the present invention.
[0022] Figure 1 The present invention provides a flow chart of a method for calculating the profit and loss of a debt restructuring business based on business documents. Figure 1 The execution entity may be a device for calculating the profit and loss of a debt restructuring business based on business documents. The method for calculating the profit and loss of a debt restructuring business based on business documents provided in embodiments of the present invention is executed by a computer device. Accordingly, the device for calculating the profit and loss of a debt restructuring business based on business documents runs on the computer device. The order of the steps in this flowchart may be varied, and some steps may be omitted, depending on different needs.
[0023] like Figure 1 As shown, the method includes the following steps.
[0024] S1, obtain the user-configured business entity identifier and reorganized business form identifier.
[0025] This step collects two key identifiers pre-configured by the user: the transaction entity identifier and the restructuring business type identifier. The transaction entity identifier identifies the specific entity involved in the debt restructuring, while the restructuring business type identifier represents the specific method used for debt restructuring. This provides basic information for subsequent data processing, ensuring that the system can accurately identify the parties involved in the debt restructuring transaction and the type of business.
[0026] S2, responding to the sub-table rendering instruction, calling the target document parameters according to the reorganized business form identifier, and rendering the target sub-table and its field information according to the target document parameters.
[0027] Upon receiving a sub-table rendering instruction, the system retrieves the target document parameters corresponding to the restructuring business form from the corresponding database or configuration, based on the previously acquired restructuring business form identifier. These parameters are then used to render the target sub-table and its field information, constructing a table framework for recording debt restructuring business data. This enables dynamic sub-table rendering, with different restructuring business forms corresponding to different document parameters and sub-table formats. This adapts to diverse business needs, ensures system scalability, and facilitates subsequent data entry and management.
[0028] S3, responding to the data retrieval instruction, connecting to the target data system according to the reorganized business form identifier, and obtaining the target data in the target data system according to the transaction unit identifier.
[0029] Upon receiving a data retrieval instruction, the system identifies the target data system to connect to based on the reorganized business form identifier. These data systems contain the required business data, such as the financial data and business records of the business entity. The system then uses the business entity identifier to filter and retrieve relevant data from the target data system, such as debt amounts and repayment records. This automated data acquisition eliminates the tedious process of manual data collection and entry, improving data collection efficiency and accuracy. Furthermore, the system filters required data based on different business forms and business entities, ensuring that the acquired data is relevant to the business and providing reliable data for subsequent profit and loss calculations.
[0030] S4, filling the acquired target data into the corresponding fields of the target subtable.
[0031] The target data acquired in step S3 is filled into the corresponding fields of the sub-table according to the field definitions and format requirements of the target sub-table, completing the initial data organization and storage. This enables data organization and management and provides a complete data structure for subsequent profit and loss calculations.
[0032] S5, responding to the profit and loss calculation instruction, calling the target formula engine according to the reorganization business form identifier, and performing the reorganization profit and loss calculation based on the data in the target sub-table through the target formula engine.
[0033] When receiving a profit and loss calculation instruction, the system retrieves the corresponding target formula engine based on the restructuring business form identifier. This formula engine calculates the debt restructuring business's profit and loss based on the data populated in the target subtable and according to pre-set calculation rules, ultimately generating the final profit and loss result. This automates and standardizes profit and loss calculations, allowing different calculation rules to be applied to different restructuring business forms to ensure accurate and reasonable results. This also avoids errors and deviations that may occur in manual calculations, improving calculation efficiency.
[0034] Furthermore, as a refinement and extension of the specific implementation of the above embodiment, in order to fully illustrate the specific implementation process in this embodiment, another method for calculating the profit and loss of debt restructuring business based on business documents is provided, which includes the following steps.
[0035] SS1, obtains the user-configured trading unit ID and reorganized business form ID.
[0036] In some optional implementations, the document constructs a main table and multiple sub-tables. The "Business Matters" field of the main table, in accordance with relevant regulations, divides seven debt restructuring business forms, which are pre-built into the system in the form of enumerated values. These are "Cash Settlement," "Inventory Settlement," "Fixed Assets / Intangible Assets Settlement," "Financial Asset Settlement," "Debt Conversion into Equity," "Modification of Other Debt Conditions," and "Mixed Restructuring." The above seven forms are pre-built as basic data in the "Public Business Matters" function, and are associated with form fields by binding to drop-down list components, thereby realizing the dynamic display and selection functions of enumerated values.
[0037] In some optional implementations, operations on the input box and drop-down list on the user configuration form are monitored. When a user enters a business entity ID in the input box and selects a restructuring business form in the drop-down list, the system immediately captures these operations. Specifically, the system captures the business entity ID entered by the user from the input box and retrieves the enumeration value corresponding to the selected restructuring business form from the drop-down list.
[0038] SS2 responds to the sub-table rendering instruction, retrieves the target document parameters according to the reorganized business form identifier, and renders the target sub-table and its field information according to the target document parameters.
[0039] In some optional implementations, different sub-tables and field information are displayed in the document based on the selected business item (i.e., debt restructuring form). The front-end monitors changes in the business item selected by the user, calls the back-end interface to obtain the corresponding sub-table and field configuration data, and dynamically generates form controls based on the returned configuration using the front-end framework (Vue) and binds the form controls to the data model. Specifically, this process includes the following steps.
[0040] SS2.1, responding to the sub-table rendering instruction, obtaining the debt information document parameters and the profit and loss information document parameters from the first storage area.
[0041] After the system responds to the sub-table rendering instruction, it will obtain the debt information document parameters and profit and loss information document parameters from the first storage area. These parameters include the structure definition, field type, field name and other information of the debt information sub-table and profit and loss information sub-table.
[0042] SS2.2, render the debt information subtable and its field information on the front-end page according to the debt information document parameters.
[0043] After the front-end receives the debt information document parameters, it uses the front-end framework (such as Vue) to dynamically generate the debt information sub-table and its field information based on these parameters, including creating table elements, table headers, table bodies, and form controls for each field (such as input boxes, drop-down boxes, etc.), and binding these form controls to the corresponding data model for subsequent data entry and display.
[0044] SS2.3, render the profit and loss information subtable and its field information on the front-end page based on the profit and loss information document parameters.
[0045] Similarly, based on the obtained profit and loss information document parameters, the profit and loss information sub-table and its field information are rendered on the front-end page. The front-end framework is also used to generate the corresponding tables and form controls and complete the data binding.
[0046] SS2.4, retrieve a pre-built first mapping relationship from the second storage area, where the first mapping relationship stores a mapping relationship between a reorganized business form identifier and a reorganized business document parameter data packet identifier.
[0047] The system retrieves a pre-built first mapping relationship from the second storage area. This mapping relationship stores the correspondence between the reorganization business form identifier and the reorganization business document parameter data package identifier. For example, the reorganization business form "cash settlement" corresponds to a specific data package identifier.
[0048] SS2.5: Filter the target reorganized business document parameter data packet identifier according to the first mapping relationship.
[0049] According to the reorganization business form identifier currently selected by the user, a filter is performed in the first mapping relationship to find the corresponding target reorganization business document parameter data package identifier.
[0050] SS2.6. Obtain the target reorganized business document parameter data package from the third storage area according to the target reorganized business document parameter data package identifier.
[0051] According to the target reorganized business document parameter data package identifier obtained by screening, the corresponding target reorganized business document parameter data package is obtained from the third storage area. This data package can be a compressed file or a serialized data object, containing detailed document parameters under a specific reorganized business form.
[0052] SS2.7, parse the target reorganization business document parameter data packet to obtain the target reorganization business document parameters.
[0053] Parse the acquired target reorganization business document parameter data packet and convert it into target reorganization business document parameters that can be recognized and used by the system.
[0054] SS2.8, render the target reorganization business subtable and its field information on the front-end page based on the target reorganization business document parameters.
[0055] Based on the parsed target restructuring document parameters, the front-end framework dynamically generates the target restructuring business sub-table and its field information on the front-end page. Similarly, the corresponding tables and form controls are created and bound to the data model to enable automatic filling, user input, and viewing of relevant data.
[0056] The system dynamically renders corresponding sub-tables and field information based on different restructuring business forms. When a new debt restructuring form emerges, simply updating the corresponding document parameters and mapping relationships will automatically support the new business form, improving system scalability. Furthermore, unified document parameters and mapping relationships manage sub-tables and field information, ensuring that data entry and display for different business forms adhere to the same rules and standards, avoiding data inconsistencies caused by human factors and improving data accuracy and reliability.
[0057] SS3 responds to the data retrieval instruction, connects to the target data system according to the reorganized business form identifier, and obtains the target data in the target data system according to the transaction unit identifier.
[0058] In some optional implementations, obtaining target data specifically includes the following steps.
[0059] SS3.1, respond to the data retrieval instruction, parse the data retrieval instruction, and obtain the reorganized business form identifier and the transaction unit identifier contained in the data retrieval instruction.
[0060] When the system receives a data retrieval instruction, it first parses it. Data retrieval instructions typically include a reorganized business form identifier and a transaction entity identifier. The parsing process extracts these two identifiers from the specific format of the instruction.
[0061] SS3.2, retrieve a pre-built second mapping relationship from the second storage area, where the second mapping relationship stores a mapping relationship between the reorganized business form identifier and the business data system identifier.
[0062] The system retrieves a pre-built second mapping relationship from the second storage area. This mapping relationship records the correspondence between the reorganized business form identifier and the business data system identifier. For example, the reorganized business form "cash settlement" corresponds to a specific business data system identifier.
[0063] SS3.3, filter the target business data system identifier according to the second mapping relationship.
[0064] Based on the reorganized business form identifier obtained in step SS3.1, a filter is performed in the second mapping relationship to find a target business data system identifier that matches it.
[0065] SS3.4, obtain the target business data system request parameter package from the third storage area according to the target data system identifier.
[0066] According to the filtered target business data system identifier, a target business data system request parameter package is obtained from the third storage area. The parameter package includes various parameters required for interacting with the target business data system.
[0067] SS3.5, parse the target business data system request parameter package to obtain the target business data system request parameters.
[0068] Parse the obtained target business data system request parameter package and convert it into target business data system request parameters that can be directly used by the system, including the requested URL, request method, request header information, etc.
[0069] SS3.6, construct the business unit identifier and target business data system request parameters into a business data retrieval instruction.
[0070] The business entity identifier obtained in step SS3.1 is combined with the target business data system request parameters parsed in step SS3.5 to construct a complete business data retrieval instruction.
[0071] SS3.7, establish a connection with the target business data system according to the business data retrieval instruction, and obtain the target business data from the target business data system according to the trading unit identifier.
[0072] Use the pre-built business data retrieval instructions to establish a connection with the target business data system. Specifically, use the network request library to send a request to the target business data system. Once the connection is established, filter and retrieve the target business data from the target business data system based on the business entity ID. This data may include transaction records, financial statements, and other information about the business entity.
[0073] SS3.8, retrieve the creditor's rights data system request parameter package from the third storage area.
[0074] A claim data system request parameter package is retrieved from the third storage area, where the parameter package includes parameters required for interacting with the claim data system.
[0075] SS3.9, parse the creditor's rights data system request parameter package to obtain the creditor's rights data system request parameters.
[0076] Parse the claim data system request parameter package to obtain the claim data system request parameters, including the requested interface address, authentication information, etc.
[0077] SS3.10, construct the transaction unit identification and debt data system request parameters into a debt data retrieval instruction.
[0078] Combine the trader identification and the creditor data system request parameters into a creditor data retrieval instruction.
[0079] SS3.11, establish a connection with the debt data system according to the debt data retrieval instruction, and obtain the target debt data from the debt data system according to the transaction unit identifier.
[0080] Establish a connection with the debt data system based on the debt data retrieval instruction, send a request to the debt data system, and obtain the target debt data based on the trade unit identifier. Specifically, this data includes the nature of the payment (such as sales proceeds), debt balance, and the amount of bad debt provision already accrued.
[0081] The above process, through pre-built mapping relationships, allows the system to adapt to different restructuring business forms and data systems. Data is obtained from both the business data system and the debt data system, improving processing efficiency. It should also be noted that the system also allows users to manually enter data into the subtables.
[0082] SS4, fills the acquired target data into the corresponding fields of the target subtable.
[0083] Specifically, the target debt data is filled into the debt information subtable; the target business data is filled into the target restructuring business subtable.
[0084] In some optional implementations, a mapping relationship between data and fields is pre-established, and the structure of the target debt data and the field definitions of the debt information subtable are analyzed to determine which field in the subtable each data item corresponds to. For example, the "Debt Amount" field in the target debt data corresponds to the "Debt Amount" field in the debt information subtable. Similarly, the structure of the target business data and the field definitions of the target restructuring business subtable are analyzed to establish a mapping relationship between data and fields. Based on the established mapping relationship, each data item in the target debt data is populated into the corresponding field in the debt information subtable. The data item value can be assigned to the corresponding form control or table cell by traversing the data object. Similar to the debt information subtable, the target restructuring business subtable is dynamically rendered on the front-end page, and the subtable fields are bound to the corresponding data model. Based on the established mapping relationship, each data item in the target business data is populated into the corresponding field in the target restructuring business subtable.
[0085] SS5 responds to the profit and loss calculation instruction, calls the target formula engine according to the reorganization business form identifier, and uses the target formula engine to perform reorganization profit and loss calculation based on the data in the target sub-table.
[0086] The backend uses a formula engine to dynamically parse preset formulas, extract required parameters from subtables, and automatically calculate gains or losses, enabling flexible and accurate business processing. This includes the following steps.
[0087] SS5.1, responding to the profit and loss calculation instruction, parsing the profit and loss calculation instruction, and obtaining the reorganization business form identifier contained in the profit and loss calculation instruction.
[0088] When the system receives the profit and loss calculation instruction, it immediately parses it. This instruction is delivered in a specific format, from which the system extracts the reorganized business form identifier.
[0089] SS5.2, retrieve a pre-built third mapping relationship from the second storage area, where the third mapping relationship stores a mapping relationship between the reorganized business form identifier and the formula engine identifier.
[0090] The system retrieves a pre-built third mapping relationship from the second storage area. This mapping relationship records the correspondence between different restructuring business form identifiers and corresponding formula engine identifiers. For example, the restructuring business form "cash settlement" corresponds to a specific formula engine identifier.
[0091] SS5.3, filter the target formula engine identifier according to the third mapping relationship.
[0092] Based on the reorganized business form identifier obtained in step SS5.1, a screening operation is performed in the third mapping relationship to find a target formula engine identifier that matches it.
[0093] SS5.4, obtain the target formula engine from the third storage area according to the target formula engine identifier.
[0094] Based on the target formula engine identifier obtained through screening, the system obtains the target formula engine from the third storage area. This formula engine can be a pre-compiled program module, script, or configuration file containing profit and loss calculation rules and algorithms for a specific restructuring business form.
[0095] SS5.5 uses the target formula engine to perform reorganized profit and loss calculations based on the data in the target subtable.
[0096] Specifically, target debt data is obtained from the debt information subtable, and target business data is obtained from the target restructuring business subtable; the target debt data and target business data are processed by the target formula engine to obtain restructuring profit and loss.
[0097] The system extracts target debt data from the debt information subtable and obtains target business data from the target restructuring business subtable. The extracted target debt data and target business data are input into the target formula engine, which processes and calculates these data according to preset rules and algorithms.
[0098] In one specific implementation, each of the seven debt restructuring business types includes a creditor's rights information subtable, a target restructuring business subtable, and a profit and loss information subtable. The contents of the creditor's rights information and profit and loss information subtables remain consistent across different debt restructuring business types. Specifically, the creditor's rights information required in the creditor's rights information subtable is detailed information on the creditor's receivables, which can be retrieved from the accounts receivable and payable system. Filtered by the "Trade Entity" main table, the fields include document number, summary, trade entity, item nature, project name, contract name, currency, exchange rate, transaction date, maturity date, new transaction date, document balance (including document balance in original currency and document balance), and bad debt provision amount (including bad debt amount in original currency and bad debt amount). The profit and loss information subtable includes fields such as profit and loss category, original currency, exchange rate, original currency amount, and local currency amount.
[0099] The target restructuring business sub-table varies according to the corresponding restructuring business form. In addition, the formula engine varies according to the restructuring business form. Specifically, the information contained in the restructuring business sub-table of various restructuring business forms and the calculation method of restructuring profit and loss are as follows.
[0100] (1) Settlement in cash [Receipt Information]: Detailed information on the outstanding balance received by the creditor, including the receiving account number, receiving account, bank name, original currency, exchange rate, original currency amount, and local currency amount. Receipt information can be automatically obtained from the funding system; manual entry is also supported.
[0101] Profit and loss amount (gain / loss) = receivables balance - receivables amount - bad debt provision amount.
[0102] (2) Settlement with inventory Inventory Information: Inventory information received by the creditor from the debtor to offset the debt, including inventory type, original currency, exchange rate, tax rate, original currency (including tax-exclusive amount, tax amount, and total amount), and local currency (including tax-exclusive amount, tax amount, and total amount). Inventory information can be automatically obtained from the supply chain system; manual entry is also supported.
[0103] Profit and loss amount (gain / loss) = receivables balance - inventory amount - bad debt provision amount.
[0104] (3) Settlement with fixed assets / intangible assets [Asset Information]: Information about the asset received by the creditor from the debtor to offset the debt, including asset number, asset name, asset category, original currency, exchange rate, tax rate, original currency (including amount excluding tax, tax amount, and total amount), and local currency (including amount excluding tax, tax amount, and total amount). Asset information can be automatically obtained from the asset management system; manual entry is also supported.
[0105] Profit and loss amount (gain / loss) = receivables balance - assets amount - bad debt provision amount.
[0106] (4) Settlement with financial assets [Financial Asset Information]: Information about financial assets acquired by the creditor for use by the debtor to offset debts, including asset number, asset name, asset category, original currency, exchange rate, tax rate, original currency (including amount excluding tax, tax amount, and total amount), and local currency (including amount excluding tax, tax amount, and total amount). Asset information can be automatically obtained from the asset management system; manual entry is also supported.
[0107] Profit and loss amount (gain / loss) = balance of receivables - amount of financial assets - amount of bad debt provision.
[0108] (5) Conversion of debt into equity [Equity Information]: Information related to the debtor's equity acquired by the creditor, including transaction details, original currency, exchange rate, original currency amount, and local currency amount. This information can be automatically obtained from the asset management system and converted into equity; manual entry is also supported.
[0109] Profit and loss amount (gain / loss) = debt balance - equity amount - bad debt provision amount.
[0110] (6) Modification of other debt conditions It should be noted that the form for modifying other debt conditions only includes the creditor's rights information sub-table and the profit and loss information sub-table.
[0111] Profit and loss amount (gain / loss) = receivables balance - balance after reduction or exemption - bad debt provision amount.
[0112] (7) Hybrid restructuring The mixed-mode reorganization form includes multiple reorganization business sub-tables, each containing the following information.
[0113] [Receipt Information]: Detailed information on the outstanding balance received by the creditor, including the receiving account number, receiving account, bank name, original currency, exchange rate, original currency amount, and local currency amount. Receipt information can be automatically obtained from the funding system; manual entry is also supported.
[0114] Inventory Information: Inventory information received by the creditor from the debtor to offset the debt, including inventory type, original currency, exchange rate, tax rate, original currency (including tax-exclusive amount, tax amount, and total amount), and local currency (including tax-exclusive amount, tax amount, and total amount). Inventory information can be automatically obtained from the supply chain system; manual entry is also supported.
[0115] [Asset Information]: Information about the asset received by the creditor from the debtor to offset the debt, including asset number, asset name, asset category, original currency, exchange rate, tax rate, original currency (including amount excluding tax, tax amount, and total amount), and local currency (including amount excluding tax, tax amount, and total amount). Asset information can be automatically obtained from the asset management system; manual entry is also supported.
[0116] [Financial Asset Information]: Information about financial assets acquired by the creditor for use by the debtor to offset debts, including asset number, asset name, asset category, original currency, exchange rate, tax rate, original currency (including amount excluding tax, tax amount, and total amount), and local currency (including amount excluding tax, tax amount, and total amount). Asset information can be automatically obtained from the asset management system; manual entry is also supported.
[0117] [Equity Information]: Information related to the debtor's equity acquired by the creditor, including transaction details, original currency, exchange rate, original currency amount, and local currency amount. This information can be automatically obtained from the asset management system and converted into equity; manual entry is also supported.
[0118] Profit and loss amount (gain / loss) = receivables balance - receivables - inventory - assets - financial assets - equity - allowance for doubtful accounts.
[0119] In some optional implementations, after the document is completed, a debt restructuring financial voucher is automatically generated, and the receivables data in the accounts receivable and payable system is automatically offset, and the amount of bad debt reserves that have been accrued is automatically offset.
[0120] The above describes in detail an embodiment of a method for calculating the profit and loss of a debt restructuring business based on business documents. Based on the method for calculating the profit and loss of a debt restructuring business based on business documents described in the above embodiment, an embodiment of the present invention also provides a device for calculating the profit and loss of a debt restructuring business based on business documents corresponding to this method.
[0121] Figure 2 This is a schematic block diagram of a system for calculating the profit and loss of a debt restructuring business based on business documents, provided in an embodiment of the present invention. In this embodiment, the profit and loss calculation device 200 for a debt restructuring business based on business documents can be divided into multiple functional modules based on the functions they perform. A module, as used herein, refers to a series of computer program segments that can be executed by at least one processor and perform a fixed function, and is stored in a memory.
[0122] The reorganization service configuration parameter acquisition module 210 is used to acquire the transaction unit identifier and the reorganization service form identifier configured by the user.
[0123] The sub-table rendering module 220 is used to respond to the sub-table rendering instruction, retrieve the target document parameters according to the reorganized business form identifier, and render the target sub-table and its field information according to the target document parameters.
[0124] The target data acquisition module 230 is used to respond to the data retrieval instruction, connect to the target data system according to the reorganized business form identifier, and obtain the target data in the target data system according to the trading unit identifier.
[0125] The target data filling module 240 is used to fill the acquired target data into the corresponding fields of the target sub-table.
[0126] The restructuring profit and loss calculation module 250 is used to respond to the profit and loss calculation instruction, call the target formula engine according to the restructuring business form identifier, and perform restructuring profit and loss calculation based on the data in the target sub-table through the target formula engine.
[0127] The debt restructuring business profit and loss calculation device based on business documents in this embodiment is used to implement the aforementioned debt restructuring business profit and loss calculation method based on business documents. Therefore, the specific implementation method of the device can be seen in the embodiment part of the debt restructuring business profit and loss calculation method based on business documents in the previous text. Therefore, its specific implementation method can refer to the description of the corresponding embodiments of each part and will not be elaborated here.
[0128] In addition, since the debt restructuring business profit and loss calculation device based on business documents in this embodiment is used to implement the aforementioned debt restructuring business profit and loss calculation method based on business documents, its function corresponds to that of the aforementioned method and will not be repeated here.
[0129] Figure 3This is a schematic diagram of the structure of a terminal 300 provided in an embodiment of the present invention, comprising a processor 310, a memory 320, and a communication unit 330. The processor 310 is configured to implement the process steps of the embodiment of the method for calculating the profit and loss of a debt restructuring business based on a business document when executing the debt restructuring business profit and loss calculation program based on a business document stored in the memory 320.
[0130] The terminal 300 includes a processor 310, a memory 320, and a communication unit 330. These components communicate via one or more buses. Those skilled in the art will appreciate that the server structure shown in the figure does not limit the present invention; it may be a bus structure or a star structure, and may include more or fewer components than shown, or combine certain components, or arrange the components differently.
[0131] Memory 320 can be used to store execution instructions of processor 310. Memory 320 can be implemented by any type of volatile or non-volatile storage device, or a combination thereof, such as static random access memory (SRAM), electrically erasable programmable read-only memory (EEPROM), erasable programmable read-only memory (EPROM), programmable read-only memory (PROM), read-only memory (ROM), magnetic memory, flash memory, magnetic disk, or optical disk. When the execution instructions in memory 320 are executed by processor 310, terminal 300 can perform some or all of the steps in the above-described method embodiments.
[0132] The processor 310 is the control center of the storage terminal. It uses various interfaces and lines to connect various parts of the entire electronic terminal. It executes various functions of the electronic terminal and / or processes data by running or executing software programs and / or modules stored in the memory 320, and calling data stored in the memory. The processor can be composed of an integrated circuit (IC), for example, it can be composed of a single packaged IC, or it can be composed of multiple packaged ICs with the same or different functions. For example, the processor 310 can only include a central processing unit (CPU). In the embodiment of the present invention, the CPU can be a single computing core or multiple computing cores.
[0133] The communication unit 330 is configured to establish a communication channel so that the storage terminal can communicate with other terminals, receive user data sent by other terminals, or send user data to other terminals.
[0134] The present invention also provides a computer storage medium, wherein the storage medium may be a magnetic disk, an optical disk, a read-only memory (ROM) or a random access memory (RAM).
[0135] The present invention also provides a computer storage medium, wherein the storage medium may be a magnetic disk, an optical disk, a read-only memory (ROM) or a random access memory (RAM).
[0136] The computer storage medium stores a debt restructuring business profit and loss calculation program based on business documents. When the debt restructuring business profit and loss calculation program based on business documents is executed by the processor, the process steps of the above-mentioned debt restructuring business profit and loss calculation method embodiment based on business documents are implemented.
[0137] Those skilled in the art will clearly understand that the techniques in the embodiments of the present invention can be implemented using software plus a necessary general-purpose hardware platform. Based on this understanding, the technical solutions in the embodiments of the present invention, or the portion that contributes to the prior art, can be embodied in the form of a software product. This computer software product is stored in a storage medium such as a USB flash drive, a mobile hard drive, a read-only memory (ROM), a random access memory (RAM), a magnetic disk, or an optical disk, among other media capable of storing program code, and includes instructions for causing a computer terminal (which can be a personal computer, a server, or a second terminal, a network terminal, etc.) to execute all or part of the steps of the methods described in various embodiments of the present invention.
[0138] In the several embodiments provided by the present invention, it should be understood that the disclosed systems, devices and methods can be implemented in other ways. For example, the device embodiments described above are merely illustrative. For example, the division of the units is merely a logical function division. In actual implementation, there may be other division methods, such as multiple units or components can be combined or integrated into another system, or some features can be ignored or not executed. Another point is that the mutual coupling or direct coupling or communication connection shown or discussed can be through some interfaces, indirect coupling or communication connection of devices or units, which can be electrical, mechanical or other forms.
[0139] The units described as separate components may or may not be physically separate, and the components shown as units may or may not be physical units, that is, they may be located in one place or distributed across multiple network units. Some or all of these units may be selected to achieve the purpose of this embodiment according to actual needs.
[0140] In addition, each functional unit in each embodiment of the present invention may be integrated into one processing unit, or each unit may exist physically separately, or two or more units may be integrated into one unit.
[0141] The above description of the disclosed embodiments is intended to enable one skilled in the art to implement or use the present invention. Various modifications to these embodiments will be readily apparent to one skilled in the art, and the general principles defined herein may be implemented in other embodiments without departing from the spirit or scope of the present invention. Therefore, the present invention is not limited to the embodiments shown herein but is intended to conform to the widest scope consistent with the principles and novel features disclosed herein.
Claims
1. A method for calculating profit and loss of debt restructuring business based on business documents, characterized in that: The following steps are involved: Obtain the user-configured trade entity ID and reorganized business form ID; Respond to the sub-table rendering instruction, retrieve the target document parameters according to the reorganized business form identifier, and render the target sub-table and its field information according to the target document parameters; Respond to the data retrieval instruction, connect to the target data system according to the reorganized business form identifier, and obtain the target data in the target data system according to the transaction unit identifier; Fill the acquired target data into the corresponding fields of the target subtable; In response to the profit and loss calculation instruction, the target formula engine is called according to the reorganization business form identifier, and the reorganization profit and loss calculation is performed based on the data in the target sub-table through the target formula engine.
2. The method for calculating profit and loss of debt restructuring business based on business documents according to claim 1, characterized in that: Respond to the sub-table rendering instruction, retrieve the target document parameters according to the reorganized business form identifier, and render the target sub-table and its field information according to the target document parameters, including: In response to the sub-table rendering instruction, the creditor's rights information document parameter and the profit and loss information document parameter are obtained from the first storage area; Render the debt information subtable and its field information on the front-end page according to the debt information document parameters; Render the profit and loss information sub-table and its field information on the front-end page according to the profit and loss information document parameters; Retrieving a pre-built first mapping relationship from the second storage area, the first mapping relationship storing a mapping relationship between a reorganization business form identifier and a reorganization business document parameter data packet identifier; Filtering the target reorganization business document parameter data packet identifier according to the first mapping relationship; According to the target reorganized business document parameter data packet identifier, the target reorganized business document parameter data packet is obtained from the third storage area; Parse the target reorganization business document parameter data packet to obtain the target reorganization business document parameters; Render the target reorganization business subtable and its field information on the front-end page according to the target reorganization business document parameters.
3. The method for calculating profit and loss of debt restructuring business based on business documents according to claim 2, characterized in that: Respond to the data retrieval instruction, connect to the target data system according to the reorganized business form identifier, and obtain the target data in the target data system according to the transaction unit identifier, specifically including: Responding to the data retrieval instruction, parsing the data retrieval instruction, and obtaining the reorganized business form identifier and the transaction unit identifier contained in the data retrieval instruction; Retrieving a pre-built second mapping relationship from the second storage area, the second mapping relationship storing a mapping relationship between the reorganized business form identifier and the business data system identifier; Filtering the target business data system identifier according to the second mapping relationship; Obtaining a target business data system request parameter package from a third storage area according to the target data system identifier; Parse the target business data system request parameter package to obtain the target business data system request parameters; Construct the business data retrieval instruction by using the business unit identifier and the target business data system request parameters; Establish a connection with the target business data system according to the business data retrieval instruction, and obtain the target business data from the target business data system according to the trading unit identifier.
4. The method for calculating profit and loss of debt restructuring business based on business documents according to claim 3, characterized in that: Responding to the data retrieval instruction, connecting to the target data system according to the reorganized business form identifier, and obtaining the target data in the target data system according to the transaction unit identifier, also includes: Retrieving a claim data system request parameter package from the third storage area; Parse the request parameter package of the creditor's rights data system to obtain the creditor's rights data system request parameters; Construct the transaction unit ID and the creditor's rights data system request parameters into a creditor's rights data retrieval instruction; Establish a connection with the debt data system according to the debt data retrieval instruction, and obtain the target debt data from the debt data system according to the transaction unit identifier.
5. The method for calculating profit and loss of debt restructuring business based on business documents according to claim 4, characterized in that: Fill the acquired target data into the corresponding fields of the target subtable, including: Fill the target debt data into the debt information subtable; Fill the target business data into the target reorganization business subtable.
6. The method for calculating profit and loss of debt restructuring business based on business documents according to claim 5, characterized in that: In response to the profit and loss calculation instruction, the target formula engine is called according to the restructuring business form identifier, and the restructuring profit and loss calculation is performed based on the data in the target sub-table through the target formula engine. Specifically, the following steps are performed: Responding to a profit and loss calculation instruction, parsing the profit and loss calculation instruction, and obtaining a reorganized business form identifier contained in the profit and loss calculation instruction; Retrieving a pre-built third mapping relationship from the second storage area, the third mapping relationship storing a mapping relationship between the reorganized business form identifier and the formula engine identifier; Filter the target formula engine identifier according to the third mapping relationship; According to the target formula engine identifier, obtaining the target formula engine from the third storage area; The target formula engine is used to perform reorganized profit and loss calculations based on the data in the target sub-table.
7. The method for calculating profit and loss of debt restructuring business based on business documents according to claim 6, characterized in that: The target formula engine performs reorganization profit and loss calculations based on the data in the target sub-table, including: Obtain target debt data from the debt information sub-table and target business data from the target restructuring business sub-table; The target debt data and target business data are processed through the target formula engine to obtain the restructuring profit and loss.
8. A debt restructuring business profit and loss calculation device based on business documents, characterized in that: include: The module for obtaining the configuration parameters of the reorganization business is used to obtain the user-configured business entity identifier and the reorganization business form identifier; The sub-table rendering module is used to respond to the sub-table rendering instruction, retrieve the target document parameters according to the reorganized business form identifier, and render the target sub-table and its field information according to the target document parameters; The target data acquisition module is used to respond to the data retrieval instruction, connect to the target data system according to the reorganized business form identifier, and obtain the target data in the target data system according to the trading unit identifier; The target data filling module is used to fill the acquired target data into the corresponding fields of the target subtable; The restructuring profit and loss calculation module is used to respond to the profit and loss calculation instruction, call the target formula engine according to the restructuring business form identifier, and perform restructuring profit and loss calculation based on the data in the target sub-table through the target formula engine.
9. A terminal, characterized in that: include: A memory device for storing a debt restructuring business profit and loss calculation program based on business documents; A processor is used to implement the steps of the debt restructuring business profit and loss calculation method based on business documents as described in any one of claims 1 to 7 when executing the debt restructuring business profit and loss calculation program based on business documents.
10. A computer-readable storage medium, characterized in that The readable storage medium stores a debt restructuring business profit and loss calculation program based on business documents. When the debt restructuring business profit and loss calculation program based on business documents is executed by the processor, the steps of the debt restructuring business profit and loss calculation method based on business documents as described in any one of claims 1 to 7 are implemented.