CN111209273A - Configurable ERP system data unloading method and device - Google Patents
Configurable ERP system data unloading method and device Download PDFInfo
- Publication number
- CN111209273A CN111209273A CN201911386037.1A CN201911386037A CN111209273A CN 111209273 A CN111209273 A CN 111209273A CN 201911386037 A CN201911386037 A CN 201911386037A CN 111209273 A CN111209273 A CN 111209273A
- Authority
- CN
- China
- Prior art keywords
- service
- data
- subsystem
- unloading
- erp system
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 60
- 238000012546 transfer Methods 0.000 claims abstract description 85
- 238000012795 verification Methods 0.000 claims abstract description 46
- 238000007726 management method Methods 0.000 claims description 37
- 238000012946 outsourcing Methods 0.000 claims description 4
- 238000012384 transportation and delivery Methods 0.000 claims description 4
- 238000013075 data extraction Methods 0.000 claims description 3
- 238000013524 data verification Methods 0.000 description 5
- 238000001514 detection method Methods 0.000 description 5
- 238000012545 processing Methods 0.000 description 4
- 238000011161 development Methods 0.000 description 3
- 238000013439 planning Methods 0.000 description 3
- 230000007547 defect Effects 0.000 description 2
- 238000010586 diagram Methods 0.000 description 2
- 230000004913 activation Effects 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000013502 data validation Methods 0.000 description 1
- 238000012217 deletion Methods 0.000 description 1
- 230000037430 deletion Effects 0.000 description 1
- 238000007429 general method Methods 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/215—Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
-
- 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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management 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
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
- G06Q10/103—Workflow collaboration or project management
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/12—Accounting
- G06Q40/125—Finance or payroll
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Theoretical Computer Science (AREA)
- Strategic Management (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Human Resources & Organizations (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- General Engineering & Computer Science (AREA)
- Economics (AREA)
- Marketing (AREA)
- General Business, Economics & Management (AREA)
- Quality & Reliability (AREA)
- Entrepreneurship & Innovation (AREA)
- Development Economics (AREA)
- Technology Law (AREA)
- Software Systems (AREA)
- Operations Research (AREA)
- Tourism & Hospitality (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The invention discloses a configurable ERP system data unloading method and device. The method comprises the following steps: acquiring at least one service subsystem or service module for executing data transfer operation from a user terminal, and an expiration period of the data transfer operation corresponding to the at least one service subsystem or service module, wherein the expiration period is a transfer-forward date; extracting early-stage final data of the final stage of the transfer aiming at least one service subsystem which carries out data transfer operation and is verified by data unloading and a service bill associated with a service module of the at least one service subsystem; and deleting the service bill associated with the at least one service subsystem and the service module thereof from the database according to a preset data unloading rule. The method carries out service data carry-over according to the use requirement of the user, carries out configuration verification before carry-over, and unloads the data after carry-over verification, thereby ensuring the data safety.
Description
Technical Field
The invention relates to the technical field of enterprise resource planning, in particular to a configurable ERP system data unloading method and device.
Background
Enterprise Resource Planning (ERP) is an information system with management accounting as the core, and includes identifying and Planning Enterprise resources, obtaining customer orders, completing processing and delivery, and finally obtaining customer payments. In other words, ERP integrates all resources inside an enterprise, and plans purchasing, production, cost, inventory, distribution, transportation, finance and human resources, thereby achieving the best resource combination, obtaining the best benefit, and being beneficial to the enterprise to quickly respond to market demands.
With the increase of the service time of the ERP system, the data volume stored in the ERP system is continuously increased, and the data volume is continuously operated at the upper limit of the system load, so that the ERP system is slowed down, and the service cannot be processed, even crashed.
Disclosure of Invention
Aiming at the defects of the prior art, the invention provides a configurable ERP system data unloading method and a configurable ERP system data unloading device, so as to solve the problems of poor system performance and the like caused by continuous increase of data in the current ERP system.
In a first aspect, the present invention provides a configurable ERP system data offloading method,
the ERP system is used for an ERP system, the ERP system comprises a plurality of business subsystems, and each business subsystem comprises a plurality of business modules;
the method comprises the following steps:
acquiring at least one service subsystem or service module for executing data transfer operation from a user terminal, and an expiration period of the data transfer operation corresponding to the at least one service subsystem or service module, wherein the expiration period is a transfer-forward date;
extracting early-stage final data of the final stage of the transfer aiming at least one service subsystem which carries out data transfer operation and is verified by data unloading and a service bill associated with a service module of the at least one service subsystem;
and deleting the service bill associated with the at least one service subsystem and the service module thereof from the database according to a preset data unloading rule, wherein the service bill associated with the at least one service subsystem and the service module thereof is the final data after data transfer operation is performed on the at least one service subsystem and the service module thereof.
Further, the ERP system data unloading method,
before the obtaining at least one service subsystem or service module for performing data transfer operation from the user terminal, the method further includes:
determining the use authority of a user and at least one service subsystem or service module of which the user has the operation authority according to user data acquired from a user terminal;
and displaying the information of the at least one service subsystem or service module at the user terminal so that the user selects the at least one service subsystem or service module as the at least one service subsystem or service module for executing the data transfer operation.
Further, the ERP system data unloading method further includes:
based on at least one service subsystem or service module performing a data transfer operation obtained from the user terminal,
configuring a data unloading verification rule corresponding to the at least one service subsystem or service module executing the data transfer operation according to the service logic of the at least one service subsystem or service module;
and configuring a data unloading rule corresponding to the at least one service subsystem or service module executing the data transfer operation according to the service logic of the at least one service subsystem or service module.
Further, the ERP system data unloading method further includes:
according to a preset data unloading verification rule, performing data unloading verification on at least one service subsystem performing data transfer operation and a service bill associated with a service module of the at least one service subsystem;
and when the service document does not meet the data unloading verification rule, generating service document operation prompt information, and displaying the service document operation prompt information at a user terminal, so that a user operates the corresponding service document according to the prompt information, and the service document meets the data unloading verification rule after operation.
Further, the ERP system data unloading method,
the extracting of the early-stage-of-delivery data from the at least one service subsystem performing the data transfer operation and the service bill associated with the service module thereof, which are verified by data unloading, includes:
for an receivable management module of a supply chain subsystem of the ERP system, extracting initial data of a forward stage comprises the following steps:
and transferring the remaining uncounted amount of the checked and incompletely cancelled business document before the transfer date into an initial document corresponding to the next period, and updating an initial identifier on the original document, wherein the business document comprises: an initial receipt, other receipts to be received at the initial, an initial sale invoice, a receipt, a sale invoice, a purchase invoice, and a purchase invoice;
registering the initial document data to an account detail list to be received;
and registering the remaining uncorrupted amount in the detail account, and updating the account receivable general account table according to the initial account receivable detail account.
Further, the ERP system data unloading method includes that the ERP system comprises a financial subsystem and a supply chain subsystem;
the financial subsystem comprises a report management module;
the supply chain subsystem comprises a purchasing management module, an inventory management module, an outsourcing management module, a sales management module, an owing management module or an accepting management module.
In a second aspect, the present invention provides a configurable data offloading device for an ERP system, configured on a server of the ERP system, including:
a data transfer execution operand acquisition unit to:
acquiring at least one service subsystem or service unit for executing data transfer operation from a user terminal, and an expiration period of the data transfer operation corresponding to the at least one service subsystem or service unit, wherein the expiration period is a transfer-forward date;
an early-in-transition data extraction unit configured to:
extracting early-stage final data of the final stage of the data transfer aiming at least one service subsystem which carries out data transfer operation and is verified by data unloading and a service bill associated with a service unit of the at least one service subsystem;
a data offload unit to:
and deleting the service bill associated with the at least one service subsystem and the service unit thereof from the database according to a preset data unloading rule, wherein the service bill associated with the at least one service subsystem and the service unit thereof is the final data after data transfer operation is performed on the at least one service subsystem and the service unit thereof.
Further, the ERP system data uninstalling apparatus further includes:
a data transfer execution operand determination unit to:
determining the use authority of a user and at least one service subsystem or service unit of which the user has operation authority according to user data acquired from a user terminal;
and displaying the information of the at least one service subsystem or service unit at the user terminal so that the user selects the at least one service subsystem or service unit as the at least one service subsystem or service unit for executing the data transfer operation.
Further, the ERP system data uninstalling apparatus further includes:
a data offload check rule/data offload rule configuration unit configured to:
based on at least one service subsystem or service unit performing a data transfer operation obtained from the user terminal,
configuring a data unloading verification rule corresponding to the at least one service subsystem or service unit executing the data transfer operation according to the service logic of the at least one service subsystem or service unit;
and configuring a data unloading rule corresponding to the at least one service subsystem or service unit executing the data transfer operation according to the service logic of the at least one service subsystem or service unit.
Further, the ERP system data uninstalling apparatus further includes:
a data offload check unit to:
according to a preset data unloading verification rule, performing data unloading verification on at least one service subsystem performing data transfer operation and a service bill associated with a service unit of the at least one service subsystem;
and when the service document does not meet the data unloading verification rule, generating service document operation prompt information, and displaying the service document operation prompt information at a user terminal, so that a user operates the corresponding service document according to the prompt information, and the service document meets the data unloading verification rule after operation.
According to the configurable ERP system data unloading method and device, service data are carried out according to user use requirements, configuration verification is carried out before carrying out, and unloading is carried out on the data subjected to carrying out verification; a data unloading framework solution is provided through the configuration database, and the data unloading framework solution can be realized in various ERP systems; the method avoids user data errors possibly caused by directly deleting data, and ensures data safety.
Drawings
A more complete understanding of exemplary embodiments of the present invention may be had by reference to the following drawings in which:
FIG. 1 is a schematic flow diagram of a configurable ERP system data offloading method in accordance with a preferred embodiment of the present invention;
FIG. 2 is a schematic diagram of the components of a configurable ERP system data offload device in accordance with a preferred embodiment of the present invention;
FIG. 3 is a list of subsystems and modules to be carried over that are selected by a user in the configurable ERP system data offloading method according to the preferred embodiment of the present invention;
FIG. 4 illustrates an expiration period of historical data transfer for a user-selected subsystem and module to be carried out in the configurable ERP system data offloading method of the preferred embodiment of the present invention;
FIG. 5 is a display page of business rule verification progress for a supply chain subsystem selected by a user in the configurable ERP system data offloading method according to the preferred embodiment of the present invention;
FIG. 6 is a warning type data verification prompt page for a supply chain subsystem selected by a user in the configurable ERP system data offloading method of the preferred embodiment of the present invention;
FIG. 7 is a page of the configurable ERP system data unloading method according to the preferred embodiment of the present invention, when a data unloading statement is configured;
fig. 8 is a progress prompt page during data unloading in the configurable ERP system data unloading method according to the preferred embodiment of the present invention.
Detailed Description
The exemplary embodiments of the present invention will now be described with reference to the accompanying drawings, however, the present invention may be embodied in many different forms and is not limited to the embodiments described herein, which are provided for complete and complete disclosure of the present invention and to fully convey the scope of the present invention to those skilled in the art. The terminology used in the exemplary embodiments illustrated in the accompanying drawings is not intended to be limiting of the invention. In the drawings, the same units/elements are denoted by the same reference numerals.
Unless otherwise defined, terms (including technical and scientific terms) used herein have the same meaning as commonly understood by one of ordinary skill in the art to which this invention belongs. Further, it will be understood that terms, such as those defined in commonly used dictionaries, should be interpreted as having a meaning that is consistent with their meaning in the context of the relevant art and will not be interpreted in an idealized or overly formal sense.
At present, most ERP products increase with time, and various business documents are continuously generated by users in use, so that the data volume managed in the ERP system continuously rises. Once the load of the server is close to the upper limit, various problems of poor operation of the ERP system can occur, and even system crash or service defect can be caused. User data errors which may be caused by directly deleting data; recovering or correcting errors results in unnecessary time and resource overhead.
As shown in fig. 1, the configurable ERP system data offloading method of the embodiment of the present invention is used for an ERP system, where the ERP system includes a plurality of business subsystems, and each business subsystem includes a plurality of business modules;
the method comprises the following steps:
step S100: acquiring at least one service subsystem or service module for executing data transfer operation from a user terminal, and an expiration period of the data transfer operation corresponding to the at least one service subsystem or service module, wherein the expiration period is a transfer-forward date;
step S200: extracting early-stage final data of the final stage of the transfer aiming at least one service subsystem which carries out data transfer operation and is verified by data unloading and a service bill associated with a service module of the at least one service subsystem;
step S300: and deleting the service bill associated with the at least one service subsystem and the service module thereof from the database according to a preset data unloading rule, wherein the service bill associated with the at least one service subsystem and the service module thereof is the final data after data transfer operation is performed on the at least one service subsystem and the service module thereof.
It should be understood that, in step S300, the data meeting the uninstalling condition before the carry-over date is deleted, and before the data is deleted, all the business document data in the server is automatically backed up in the manner disclosed in the prior art.
It should be understood that the ERP system comprises a plurality of business subsystems, each of which comprises a plurality of business modules.
On the other hand, the ERP system comprises a server and a user terminal, wherein the server generates and manages a database for storing business document data; the user terminal accesses the database storing the business document data through the access server.
The configurable data unloading method of the ERP system in the embodiment is used for a server of the ERP system, carrying out service data carry-over according to user use requirements acquired from a user terminal, carrying out configuration verification before carry-over, and unloading the data subjected to carry-over verification.
Further, the ERP system data unloading method,
before the obtaining at least one service subsystem or service module for performing data transfer operation from the user terminal, the method further includes:
determining the use authority of a user and at least one service subsystem or service module of which the user has the operation authority according to user data acquired from a user terminal;
and displaying the information of the at least one service subsystem or service module at the user terminal so that the user selects the at least one service subsystem or service module as the at least one service subsystem or service module for executing the data transfer operation.
It should be understood that the server of the ERP system verifies the usage authority of the user and the at least one service subsystem or service module that the user has the operation authority according to the user name and the password obtained from the user terminal.
Further, the ERP system data unloading method further includes:
based on at least one service subsystem or service module performing a data transfer operation obtained from the user terminal,
configuring a data unloading verification rule corresponding to the at least one service subsystem or service module executing the data transfer operation according to the service logic of the at least one service subsystem or service module;
and configuring a data unloading rule corresponding to the at least one service subsystem or service module executing the data transfer operation according to the service logic of the at least one service subsystem or service module.
Further, the ERP system data unloading method further includes:
according to a preset data unloading verification rule, performing data unloading verification on at least one service subsystem performing data transfer operation and a service bill associated with a service module of the at least one service subsystem;
and when the service document does not meet the data unloading verification rule, generating service document operation prompt information, and displaying the service document operation prompt information at a user terminal, so that a user operates the corresponding service document according to the prompt information, and the service document meets the data unloading verification rule after operation.
Further, the ERP system data unloading method,
the extracting of the early-stage-of-delivery data from the at least one service subsystem performing the data transfer operation and the service bill associated with the service module thereof, which are verified by data unloading, includes:
for an receivable management module of a supply chain subsystem of the ERP system, extracting initial data of a forward stage comprises the following steps:
and transferring the remaining uncounted amount of the checked and incompletely cancelled business document before the transfer date into an initial document corresponding to the next period, and updating an initial identifier on the original document, wherein the business document comprises: an initial receipt, other receipts to be received at the initial, an initial sale invoice, a receipt, a sale invoice, a purchase invoice, and a purchase invoice;
registering the initial document data to an account detail list to be received;
and registering the remaining uncorrupted amount in the detail account, and updating the account receivable general account table according to the initial account receivable detail account.
Further, the ERP system data unloading method includes that the ERP system comprises a financial subsystem and a supply chain subsystem;
the financial subsystem comprises a report management module;
the supply chain subsystem comprises a purchasing management module, an inventory management module, an outsourcing management module, a sales management module, an owing management module or an accepting management module.
The configurable ERP system data unloading method provided by the embodiment of the invention carries out service data carry-over according to the use requirements of users, carries out configuration verification before carry-over, and unloads the data subjected to carry-over verification. The configurable ERP system data unloading method provided by the embodiment of the invention provides a frame solution for data unloading through the configuration database, and can be realized in various ERP systems. The configurable ERP system data unloading method avoids user data errors possibly caused by directly deleting data.
For an ERP front-end user, only a few steps of selection operations are required to execute the configurable ERP system data unloading method of the embodiment, for example, to check whether the verification passes; if not, checking the reason of failing to pass for processing; the data can be carried out the carry-over, thereby greatly optimizing the operation steps of the user and reducing the time required by the data carry-over.
For developers, the development work can be completed quickly by only configuring the database and dividing each module in the development process.
As shown in fig. 2, a configurable ERP system data offloading device according to an embodiment of the present invention, configured on a server of an ERP system, includes:
a data transfer execution operand obtaining unit 10 for:
acquiring at least one service subsystem or service unit for executing data transfer operation from a user terminal, and an expiration period of the data transfer operation corresponding to the at least one service subsystem or service unit, wherein the expiration period is a transfer-forward date;
an early-in-transition data extraction unit 20 configured to:
extracting early-stage final data of the final stage of the data transfer aiming at least one service subsystem which carries out data transfer operation and is verified by data unloading and a service bill associated with a service unit of the at least one service subsystem;
a data offload unit 30 for:
and deleting the service bill associated with the at least one service subsystem and the service unit thereof from the database according to a preset data unloading rule, wherein the service bill associated with the at least one service subsystem and the service unit thereof is the final data after data transfer operation is performed on the at least one service subsystem and the service unit thereof.
Further, the ERP system data uninstalling apparatus further includes:
a data transfer execution operand determination unit to:
determining the use authority of a user and at least one service subsystem or service unit of which the user has operation authority according to user data acquired from a user terminal;
and displaying the information of the at least one service subsystem or service unit at the user terminal so that the user selects the at least one service subsystem or service unit as the at least one service subsystem or service unit for executing the data transfer operation.
Further, the ERP system data uninstalling apparatus further includes:
a data offload check rule/data offload rule configuration unit configured to:
based on at least one service subsystem or service unit performing a data transfer operation obtained from the user terminal,
configuring a data unloading verification rule corresponding to the at least one service subsystem or service unit executing the data transfer operation according to the service logic of the at least one service subsystem or service unit;
and configuring a data unloading rule corresponding to the at least one service subsystem or service unit executing the data transfer operation according to the service logic of the at least one service subsystem or service unit.
Further, the ERP system data uninstalling apparatus further includes:
a data offload check unit to:
according to a preset data unloading verification rule, performing data unloading verification on at least one service subsystem performing data transfer operation and a service bill associated with a service unit of the at least one service subsystem;
and when the service document does not meet the data unloading verification rule, generating service document operation prompt information, and displaying the service document operation prompt information at a user terminal, so that a user operates the corresponding service document according to the prompt information, and the service document meets the data unloading verification rule after operation.
The data offloading device of this embodiment, configured in the target ERP system, includes:
verifying the data during the period of the user selected to carry out the balance;
carrying out carry-over operation on the initial data to ensure the correctness of the unloaded data;
and deleting the data.
The configurable data unloading device for the ERP system in the embodiment provides a convenient and effective data carry-over tool for the ERP system, and avoids the occurrence of continuous expansion of data of the ERP system.
In summary, the configurable data unloading method and device for the ERP system in the above embodiments are applied to the ERP system, and a data unloading method for a big data account set is implemented. By unloading the historical data which is specified by the user and is verified, the requirement of the user on performance is met under the condition that the initial data of the new account set is correct, and the method can be widely applied to various ERP systems.
Specifically, the configurable ERP system data unloading method comprises the following steps:
1) data verification
The server determines the use authority of the user and a service module with the operation authority of the user according to the acquired user data;
at the user terminal, at least one service subsystem which can start the carry-over operation is displayed for the user to select.
The financial subsystem and supply chain subsystem are shown in FIG. 3. Wherein, in the financial subsystem, include the management module of the report form; the supply chain subsystem comprises a purchasing management module, an inventory management module, an outsourcing management module, a sales management module, a payable management module, an receivable management module and the like.
And when data transfer is carried out, the data transfer method operates step by step according to the logical structures of the service subsystem and each module in the service subsystem.
After the service scope is determined, the user-selected forward running period is further acquired. As shown in fig. 4, the expiration period of the history data transfer selected by the user is 2017 and 5 months when the account data is transferred. That is, the present carry-over operation is for data generated and stored 5 months (31 days) before 2017. The deadline of the historical data transfer takes the natural month as the minimum unit; and is also the beginning time of newly generated data after data is unloaded.
It should be understood that setting the activation time for the historical data transfer associated with each business module is also included.
And after the carry-over period is determined, the server checks the business rule for the business data to be carried over. FIG. 5 illustrates a process presentation page that detects business rules for a supply chain subsystem. Table 1 lists data verification rules that may result in failure of data offload associated with sales modules in the supply chain subsystem. Specifically, whether the current state of the business document meets the carry-over requirement or not is determined for various business documents related to the sales module.
TABLE 1 verification rules that sales modules cause data offload failures
Generating a detection log aiming at each service module in the service rule detection process aiming at the supply chain subsystem; the detection log records the starting time and the current period of each service module, and records the detection result as success or warning. For the item whose detection result is an alert, a message page as shown in fig. 6 is displayed at the user end for prompting the user that there is a check item for the alert, and the user is advised to perform a supplementary operation on the related business document, so that the data state of the business document meets the carry-over requirement.
Table 2 lists the data validation rules that generate the data offload alerts associated with the sales modules in the supply chain subsystem.
TABLE 2 sales Module data offload alert verification
And if the data unloading verification is unsuccessful (the business rule is not passed), terminating the starting carry-over operation. And correspondingly processing the data to be unloaded by the user according to the unloading failure item, and after the data to be unloaded is processed, restarting the data verification operation before the forwarding until all the data to be forwarded meet the forwarding requirement.
On the other hand, if the data warning check fails, prompting is carried out at the user side, and the user waits for selecting whether to continue unloading the data. It should be understood that failure of the data alert check does not affect the performance of the spin-up.
It should be understood that the data offload check and the data alert check are each independently performed in parallel; when the data is displayed to the user terminal, the data unloading verification prompt and the data warning verification prompt are displayed simultaneously so as to ensure the integrity and the correctness of the information acquired by the user.
2) Data processing
Data associated with some business subsystems and business modules in the ERP system has beginning-of-life data. For example, the inventory management module, the due management module and the due management module in the supply chain subsystem relate to the initial data, and the data to be deleted needs to be processed before the data is deleted, so that the forward-to-end data is extracted.
Specifically, the rules for the early-in-carry-forward data for the receivable management modules in the supply chain subsystem are as follows:
the method comprises the following steps of checking the documents which are not completely verified before the final date, wherein the following steps are included: the remaining uncounted amount of the initial receipt, the other receivable receipts, the initial sale invoice and the receipt, the sale invoice, the purchase invoice and the purchase invoice is transferred into the initial receipt corresponding to the next period, and the initial mark on the original receipt is updated; registering the initial document data to an account detail list to be received; and registering the remaining uncorrupted amount in the detail account, and updating the account receivable general account table according to the initial account receivable detail account.
Specifically, the rules governing the modules due in the supply chain subsystem to carry forward the beginning of the term data are as follows:
the method comprises the following steps of checking the documents which are not completely verified before the final date, wherein the following steps are included: the remaining uncounted amount of the initial payment bill, the other payable bills, the initial purchase invoice, the payment bill, the sales invoice, the purchase invoice and the purchase invoice is carried into the initial bill corresponding to the next period, and the initial mark on the original bill is updated; registering the initial receipt data in an accounts payable statement table; and registering the remaining uncorrupted amount of money into the detail account, and updating the general accounts payable table according to the initial detailed accounts payable.
3) Data offloading
And when the data is unloaded, the data associated with the service modules are unloaded one by one according to the service logic according to the logic relation between the service modules or the service subsystems.
It should be understood that, at the time of deletion or uninstallation, the execution order of the data uninstalling operation for each service module and each service subsystem is decomposed and set according to the dependency relationship or precondition relationship between the service modules or between the service subsystems according to the service logic.
Specifically, the server pre-prepares the unload data operation statement entirely in a database table. In specific implementation, the identifiers of the business modules are used as indexes to group the operation statements of the unloaded data; and unloading the data according to a preset service rule aiming at the unloading data operation statement in each group. As shown in FIG. 7, an unload data operation statement is configured for the sales management module in the supply chain subsystem.
An uninstall progress presentation page presented at the user terminal is shown in fig. 8. It should be understood that no new business documents are generated or received by the user terminals of the ERP system when offloading data.
The configurable ERP system data unloading method provided by the embodiment of the invention is used for verifying according to the time point selected by the user and unloading the data in the period specified by the user after verification. Preferably, the time point is the last day of the accounting period selected by the user, so that the requirements of the enterprise can be met more flexibly.
According to the configurable data unloading method for the ERP system, disclosed by the embodiment of the invention, during the period that a user selects the initial accounting to be reserved, basic data can be reserved after necessary data verification is carried out on the data, so that the user can conveniently continue to use the ERP system.
The configurable ERP system data unloading method provided by the embodiment of the invention provides a general method for unloading service documents in the ERP system, and can be used for configuring various currently transported ERP systems. The development process is simpler, and the module to be operated is added only by configuring the module in the database.
The above description is only for the preferred embodiment of the present invention, but the scope of the present invention is not limited thereto, and any changes or substitutions that can be easily conceived by those skilled in the art within the technical scope of the present invention are included in the scope of the present invention. Therefore, the protection scope of the present invention shall be subject to the protection scope of the claims.
The invention has been described above by reference to a few embodiments. However, other embodiments of the invention than the one disclosed above are equally possible within the scope of the invention, as would be apparent to a person skilled in the art from the appended patent claims.
Generally, all terms used in the claims are to be interpreted according to their ordinary meaning in the technical field, unless explicitly defined otherwise herein. All references to "a// the [ device, component, etc ]" are to be interpreted openly as at least one instance of a device, component, etc., unless explicitly stated otherwise. The steps of any method disclosed herein do not have to be performed in the exact order disclosed, unless explicitly stated.
Claims (10)
1. A configurable ERP system data unloading method is characterized in that,
the ERP system is used for an ERP system, the ERP system comprises a plurality of business subsystems, and each business subsystem comprises a plurality of business modules;
the method comprises the following steps:
acquiring at least one service subsystem or service module for executing data transfer operation from a user terminal, and an expiration period of the data transfer operation corresponding to the at least one service subsystem or service module, wherein the expiration period is a transfer-forward date;
extracting early-stage final data of the final stage of the transfer aiming at least one service subsystem which carries out data transfer operation and is verified by data unloading and a service bill associated with a service module of the at least one service subsystem;
and deleting the service bill associated with the at least one service subsystem and the service module thereof from the database according to a preset data unloading rule, wherein the service bill associated with the at least one service subsystem and the service module thereof is the final data after data transfer operation is performed on the at least one service subsystem and the service module thereof.
2. The ERP system data offloading method of claim 1,
before the obtaining at least one service subsystem or service module for performing data transfer operation from the user terminal, the method further includes:
determining the use authority of a user and at least one service subsystem or service module of which the user has the operation authority according to user data acquired from a user terminal;
and displaying the information of the at least one service subsystem or service module at the user terminal so that the user selects the at least one service subsystem or service module as the at least one service subsystem or service module for executing the data transfer operation.
3. The ERP system data offloading method of claim 2, further comprising:
based on at least one service subsystem or service module performing a data transfer operation obtained from the user terminal,
configuring a data unloading verification rule corresponding to the at least one service subsystem or service module executing the data transfer operation according to the service logic of the at least one service subsystem or service module;
and configuring a data unloading rule corresponding to the at least one service subsystem or service module executing the data transfer operation according to the service logic of the at least one service subsystem or service module.
4. The ERP system data offloading method of claim 3, further comprising:
according to a preset data unloading verification rule, performing data unloading verification on at least one service subsystem performing data transfer operation and a service bill associated with a service module of the at least one service subsystem;
and when the service document does not meet the data unloading verification rule, generating service document operation prompt information, and displaying the service document operation prompt information at a user terminal, so that a user operates the corresponding service document according to the prompt information, and the service document meets the data unloading verification rule after operation.
5. The ERP system data offloading method of claim 1,
the extracting of the early-stage-of-delivery data from the at least one service subsystem performing the data transfer operation and the service bill associated with the service module thereof, which are verified by data unloading, includes:
for an receivable management module of a supply chain subsystem of the ERP system, extracting initial data of a forward stage comprises the following steps:
and transferring the remaining uncounted amount of the checked and incompletely cancelled business document before the transfer date into an initial document corresponding to the next period, and updating an initial identifier on the original document, wherein the business document comprises: an initial receipt, other receipts to be received at the initial, an initial sale invoice, a receipt, a sale invoice, a purchase invoice, and a purchase invoice;
registering the initial document data to an account detail list to be received;
and registering the remaining uncorrupted amount in the detail account, and updating the account receivable general account table according to the initial account receivable detail account.
6. The ERP system data offloading method of claim 1,
the ERP system comprises a financial subsystem and a supply chain subsystem;
the financial subsystem comprises a report management module;
the supply chain subsystem comprises a purchasing management module, an inventory management module, an outsourcing management module, a sales management module, an owing management module or an accepting management module.
7. A configurable ERP system data unloading device is characterized in that a server configured in an ERP system comprises:
a data transfer execution operand acquisition unit to:
acquiring at least one service subsystem or service unit for executing data transfer operation from a user terminal, and an expiration period of the data transfer operation corresponding to the at least one service subsystem or service unit, wherein the expiration period is a transfer-forward date;
an early-in-transition data extraction unit configured to:
extracting early-stage final data of the final stage of the data transfer aiming at least one service subsystem which carries out data transfer operation and is verified by data unloading and a service bill associated with a service unit of the at least one service subsystem;
a data offload unit to:
and deleting the service bill associated with the at least one service subsystem and the service unit thereof from the database according to a preset data unloading rule, wherein the service bill associated with the at least one service subsystem and the service unit thereof is the final data after data transfer operation is performed on the at least one service subsystem and the service unit thereof.
8. The ERP system data offload device of claim 7,
further comprising:
a data transfer execution operand determination unit to:
determining the use authority of a user and at least one service subsystem or service unit of which the user has operation authority according to user data acquired from a user terminal;
and displaying the information of the at least one service subsystem or service unit at the user terminal so that the user selects the at least one service subsystem or service unit as the at least one service subsystem or service unit for executing the data transfer operation.
9. The ERP system data uninstaller according to claim 8, further comprising:
a data offload check rule/data offload rule configuration unit configured to:
based on at least one service subsystem or service unit performing a data transfer operation obtained from the user terminal,
configuring a data unloading verification rule corresponding to the at least one service subsystem or service unit executing the data transfer operation according to the service logic of the at least one service subsystem or service unit;
and configuring a data unloading rule corresponding to the at least one service subsystem or service unit executing the data transfer operation according to the service logic of the at least one service subsystem or service unit.
10. The ERP system data uninstaller according to claim 7, further comprising:
a data offload check unit to:
according to a preset data unloading verification rule, performing data unloading verification on at least one service subsystem performing data transfer operation and a service bill associated with a service unit of the at least one service subsystem;
and when the service document does not meet the data unloading verification rule, generating service document operation prompt information, and displaying the service document operation prompt information at a user terminal, so that a user operates the corresponding service document according to the prompt information, and the service document meets the data unloading verification rule after operation.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911386037.1A CN111209273B (en) | 2019-12-29 | 2019-12-29 | Configurable ERP system data unloading method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911386037.1A CN111209273B (en) | 2019-12-29 | 2019-12-29 | Configurable ERP system data unloading method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111209273A true CN111209273A (en) | 2020-05-29 |
| CN111209273B CN111209273B (en) | 2023-11-14 |
Family
ID=70785863
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911386037.1A Active CN111209273B (en) | 2019-12-29 | 2019-12-29 | Configurable ERP system data unloading method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111209273B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112598492A (en) * | 2020-12-25 | 2021-04-02 | 航天信息股份有限公司企业服务分公司 | Project cost accounting system |
Citations (13)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| AU2002233050B2 (en) * | 2001-03-02 | 2005-02-24 | British American Tobacco Australia Limited | Network based business to business portal for the retail convenience marketplace |
| WO2006117680A2 (en) * | 2005-02-25 | 2006-11-09 | Sap Ag | Consistent set of interfaces derived from a business object model |
| CN101504742A (en) * | 2009-04-08 | 2009-08-12 | 金蝶软件（中国）有限公司 | Service documents verifying and cancelling method and system |
| CN101882266A (en) * | 2010-06-22 | 2010-11-10 | 方志忠 | Account making system for medium-sized and small enterprises |
| CN102194163A (en) * | 2011-04-14 | 2011-09-21 | 中国联合网络通信集团有限公司 | Enterprise resource planning management method, server and system |
| CN102542338A (en) * | 2010-12-15 | 2012-07-04 | 金蝶软件（中国）有限公司 | Method for storing business documents and system |
| CN103093301A (en) * | 2011-08-25 | 2013-05-08 | 西门子公司 | Production management for manufacturing execution systems |
| CN103489061A (en) * | 2013-09-04 | 2014-01-01 | 用友软件股份有限公司 | Batch data processing device and batch data processing method |
| CN103729703A (en) * | 2012-10-11 | 2014-04-16 | 天津恒星科技有限公司 | Data processing conflict detection method |
| US20160012549A1 (en) * | 2013-03-15 | 2016-01-14 | 3-D Business Tools, Llc | Business analysis tool using attribute groups |
| CN108090823A (en) * | 2017-12-20 | 2018-05-29 | 重庆八戒财云网络科技有限公司 | accounting data management system based on SaaS |
| CN108777633A (en) * | 2018-05-18 | 2018-11-09 | 重庆邮电大学 | Support the intention type industry SDN north interface systems and exchange method of data dispatch |
| CN109785106A (en) * | 2019-03-05 | 2019-05-21 | 浪潮通用软件有限公司 | A kind of ERP system account checking method |
-
2019
- 2019-12-29 CN CN201911386037.1A patent/CN111209273B/en active Active
Patent Citations (13)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| AU2002233050B2 (en) * | 2001-03-02 | 2005-02-24 | British American Tobacco Australia Limited | Network based business to business portal for the retail convenience marketplace |
| WO2006117680A2 (en) * | 2005-02-25 | 2006-11-09 | Sap Ag | Consistent set of interfaces derived from a business object model |
| CN101504742A (en) * | 2009-04-08 | 2009-08-12 | 金蝶软件（中国）有限公司 | Service documents verifying and cancelling method and system |
| CN101882266A (en) * | 2010-06-22 | 2010-11-10 | 方志忠 | Account making system for medium-sized and small enterprises |
| CN102542338A (en) * | 2010-12-15 | 2012-07-04 | 金蝶软件（中国）有限公司 | Method for storing business documents and system |
| CN102194163A (en) * | 2011-04-14 | 2011-09-21 | 中国联合网络通信集团有限公司 | Enterprise resource planning management method, server and system |
| CN103093301A (en) * | 2011-08-25 | 2013-05-08 | 西门子公司 | Production management for manufacturing execution systems |
| CN103729703A (en) * | 2012-10-11 | 2014-04-16 | 天津恒星科技有限公司 | Data processing conflict detection method |
| US20160012549A1 (en) * | 2013-03-15 | 2016-01-14 | 3-D Business Tools, Llc | Business analysis tool using attribute groups |
| CN103489061A (en) * | 2013-09-04 | 2014-01-01 | 用友软件股份有限公司 | Batch data processing device and batch data processing method |
| CN108090823A (en) * | 2017-12-20 | 2018-05-29 | 重庆八戒财云网络科技有限公司 | accounting data management system based on SaaS |
| CN108777633A (en) * | 2018-05-18 | 2018-11-09 | 重庆邮电大学 | Support the intention type industry SDN north interface systems and exchange method of data dispatch |
| CN109785106A (en) * | 2019-03-05 | 2019-05-21 | 浪潮通用软件有限公司 | A kind of ERP system account checking method |
Non-Patent Citations (4)
| Title |
|---|
| 刘海滨 等: "以业务单据为中心的业务流程模型聚类及相似性查询方法", 计算机集成制造系统, vol. 19, no. 08, pages 1810 - 1821 * |
| 王向炜: "应用EAServer多层构架的ERP系统的设计与实现", 中国优秀硕士学位论文全文数据库信息科技辑, no. 10, pages 138 - 232 * |
| 高恩龙: "税务管理决策分析系统的设计与应用", 中国优秀硕士学位论文全文数据库信息科技辑, no. 08, pages 138 - 1038 * |
| 黄永琳: "金蝶、安易、用友三大会计核算软件评价", 中国会计电算化, no. 02, pages 14 - 17 * |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112598492A (en) * | 2020-12-25 | 2021-04-02 | 航天信息股份有限公司企业服务分公司 | Project cost accounting system |
| CN112598492B (en) * | 2020-12-25 | 2023-12-01 | 航天信息股份有限公司企业服务分公司 | project cost accounting system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111209273B (en) | 2023-11-14 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US6990466B1 (en) | Method and system for integrating core banking business processes | |
| US6477703B1 (en) | Software patch selection tool | |
| US7861238B2 (en) | Configuration tool and method of updating an archive file property relating to at least one point-of-sale peripheral | |
| KR19990082628A (en) | Invoice Purchase Order System | |
| US11915239B2 (en) | System and method for updating and managing hosted catalogs in a procurement system | |
| CN113362025B (en) | Data accounting system, method, computer-readable storage medium, and electronic device | |
| CN111353841B (en) | Document data processing method, device and system | |
| CN111222966A (en) | Automatic account checking system and implementation method | |
| CN111209273B (en) | Configurable ERP system data unloading method and device | |
| CN114170023A (en) | Method and device for testing fund transaction operation platform system | |
| CN112990871A (en) | Document processing method and related equipment | |
| CN115496480A (en) | Data inspection method, system and related equipment | |
| CN113947465A (en) | Cross-border electricity quotient declaration result checking and early warning method and device | |
| CN110956552B (en) | Insurance problem processing method, apparatus, device and storage medium | |
| CN114971903A (en) | Batch task processing method and device | |
| EP3651107A1 (en) | Systems and methods for securely creating a listing of equipment on an equipment online marketplace platform | |
| CN112418878A (en) | Method, device and equipment for processing rights and interests service data and storage medium | |
| US20160012502A1 (en) | Preventive auditing | |
| CN112419052A (en) | Transaction testing method and device, electronic equipment and readable storage medium | |
| JP2004062378A (en) | Contribution collation system, account receivable collation program and recording medium with account receivable collation program recorded thereon | |
| CN113326179B (en) | Emergency payment starting method and device, computing equipment and computer storage medium | |
| KR102713484B1 (en) | Information processing method for item in distribution system and electronic device | |
| JP2003233687A (en) | System and method for repairing computer by user | |
| CN118096150A (en) | Payment processing method, device, equipment and storage medium based on payment platform | |
| CN117743018A (en) | Service data processing method and device, electronic equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |