CN111209273B - Configurable ERP system data unloading method and device - Google Patents
Configurable ERP system data unloading method and device Download PDFInfo
- Publication number
- CN111209273B CN111209273B CN201911386037.1A CN201911386037A CN111209273B CN 111209273 B CN111209273 B CN 111209273B CN 201911386037 A CN201911386037 A CN 201911386037A CN 111209273 B CN111209273 B CN 111209273B
- Authority
- CN
- China
- Prior art keywords
- service
- data
- subsystem
- business
- bill
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 56
- 238000012546 transfer Methods 0.000 claims abstract description 101
- 238000012795 verification Methods 0.000 claims abstract description 49
- 238000013075 data extraction Methods 0.000 claims description 3
- 238000007726 management method Methods 0.000 description 28
- 238000013524 data verification Methods 0.000 description 6
- 238000001514 detection method Methods 0.000 description 5
- 238000012545 processing Methods 0.000 description 5
- 238000013439 planning Methods 0.000 description 4
- 238000011161 development Methods 0.000 description 3
- 230000007547 defect Effects 0.000 description 2
- 238000012217 deletion Methods 0.000 description 2
- 230000037430 deletion Effects 0.000 description 2
- 230000004913 activation Effects 0.000 description 1
- 230000015556 catabolic process Effects 0.000 description 1
- 238000006243 chemical reaction Methods 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 238000007429 general method Methods 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 230000031877 prophase Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 238000012384 transportation and delivery Methods 0.000 description 1
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)
- Finance (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Accounting & Taxation (AREA)
- Human Resources & Organizations (AREA)
- General Engineering & Computer Science (AREA)
- Entrepreneurship & Innovation (AREA)
- Economics (AREA)
- Marketing (AREA)
- General Business, Economics & Management (AREA)
- Quality & Reliability (AREA)
- Operations Research (AREA)
- Tourism & Hospitality (AREA)
- Software Systems (AREA)
- Development Economics (AREA)
- Technology Law (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 a cut-off period of the data transfer operation corresponding to the at least one service subsystem or service module, wherein the cut-off period is a date of transfer; extracting the early-stage data of the final period aiming at least one service subsystem which is checked by data unloading and executes data transfer operation and a service bill related to a service module thereof; and deleting the business documents associated with the at least one business subsystem and the business modules thereof from the database according to a preset data unloading rule. The method carries out business data transfer according to the use requirement of the user, carries out configuration verification before the transfer, and unloads the data after the transfer 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 (Enterprise Resource Planning, ERP for short) is an information system with accounting as a core, which includes identifying and planning enterprise resources, obtaining customer orders, completing processing and delivery, and finally obtaining payment from customers. In other words, ERP integrates all resources in the enterprise together, and plans purchasing, production, cost, inventory, distribution, transportation, finance and manpower resources, so that the optimal resource combination is achieved, the optimal benefit is obtained, and meanwhile, the enterprise is also facilitated to rapidly respond to market demands.
As the service time of the ERP system increases, the data volume stored in the ERP system also increases continuously, and the data volume runs at the upper limit of the system load continuously, so that the ERP system is slow, the service cannot be processed, and even crashes.
Disclosure of Invention
Aiming at the defects of the prior art, the invention provides a configurable ERP system data unloading method and device, which are used for solving the problems of poor system performance and the like caused by continuous increase of data in the prior 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 and comprises a plurality of service subsystems, wherein each service subsystem comprises a plurality of service 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 a cut-off period of the data transfer operation corresponding to the at least one service subsystem or service module, wherein the cut-off period is a date of transfer;
extracting the early-stage data of the final period aiming at least one service subsystem which is checked by data unloading and executes data transfer operation and a service bill related to a service module thereof;
and deleting the business documents related to the at least one business subsystem and the business modules thereof from a database according to a preset data unloading rule, wherein after data transfer operation is carried out on the at least one business subsystem and the business modules thereof, the business documents related to the at least one business subsystem and the business modules thereof are the early-period data.
Further, the ERP system data unloading method,
before the at least one service subsystem or service module for performing the data transfer operation is obtained from the user terminal, the method further comprises:
determining the use authority of a user and at least one service subsystem or service module with the operation authority of the user according to the user data acquired from the user terminal;
information of the at least one service subsystem or service module is presented at the user terminal so that the user selects at least one service subsystem or service module from which to perform the data transfer operation.
Further, the ERP system data unloading method further comprises the following steps:
based on at least one service subsystem or service module performing a data transfer operation acquired from the user terminal,
according to the business logic of the at least one business subsystem or business module, configuring a data unloading verification rule corresponding to the at least one business subsystem or business module for executing the data transfer operation;
and configuring a data unloading rule corresponding to the at least one service subsystem or the service module for executing the data transfer operation according to the service logic of the at least one service subsystem or the service module.
Further, the ERP system data unloading method further comprises the following steps:
according to a preset data unloading verification rule, carrying out data unloading verification on at least one service subsystem for executing data transfer operation and service documents related to the service module of the service subsystem;
and when the service bill does not meet the data unloading verification rule, generating service bill operation prompt information, and displaying the service bill operation prompt information at a user terminal so that a user can operate the corresponding service bill according to the prompt information, and the service bill meets the data unloading verification rule after operation.
Further, the ERP system data unloading method,
the extracting the early-stage data of the final stage for the business bill associated with the at least one business subsystem and the business module thereof which execute the data transfer operation through the data unloading verification comprises the following steps:
for the receivable management module of the supply chain subsystem of the ERP system, extracting the initial data of the final period comprises:
and before the date of the transfer, transferring the remaining uncore amount of the checked service bill which is not completely checked to the corresponding initial bill of the next period, and updating the initial mark on the original bill, wherein the service bill comprises the following components: the method comprises the steps of initial bill collection, initial other bill collection, initial sales bill, bill collection, sales bill, sales fee bill, purchasing bill and purchasing fee bill;
registering the bill data of the beginning of the period and the bill table of the receivable detail;
and registering the remaining uncombusted amount in the statement, and updating the receivable general account table according to the statement of the initial receivable.
Further, the ERP system comprises a financial subsystem and a supply chain subsystem;
wherein the financial subsystem comprises a report management module;
the supply chain subsystem comprises a purchase management module, an inventory management module, a commission management module, a sales management module, a management due module or a management due module.
In a second aspect, the present invention provides a configurable data offloading device of an ERP system, configured to a server of the ERP system, including:
an execution data transfer operation object acquisition unit configured to:
acquiring at least one service subsystem or service unit for executing data transfer operation from a user terminal, and a cut-off period of the data transfer operation corresponding to the at least one service subsystem or service unit, wherein the cut-off period is a date of transfer;
a final-period initial data extraction unit for:
extracting the early-stage data of the outcome period aiming at least one service subsystem which is checked by data unloading and executes data transfer operation and service documents related to service units thereof;
a data unloading unit for:
and deleting the business documents related to the at least one business subsystem and the business units thereof from a database according to a preset data unloading rule, wherein after data transfer operation is carried out on the at least one business subsystem and the business units thereof, the business documents related to the at least one business subsystem and the business units thereof are the early-period data.
Further, the ERP system data unloading device further comprises:
an execution data transfer operation object determination unit configured to:
determining the use authority of a user and at least one service subsystem or service unit with the operation authority of the user according to the user data acquired from the user terminal;
information of the at least one service subsystem or service unit is presented at the user terminal so that the user selects at least one service subsystem or service unit from which to perform the data transfer operation.
Further, the ERP system data unloading device further comprises:
a data unloading verification rule/data unloading rule configuration unit for:
based on at least one service subsystem or service unit obtained from the user terminal performing the data transfer operation,
according to the business logic of the at least one business subsystem or business unit, configuring a data unloading check rule corresponding to the at least one business subsystem or business unit for executing the data transfer operation;
and configuring a data unloading rule corresponding to the at least one service subsystem or the service unit for executing the data transfer operation according to the service logic of the at least one service subsystem or the service unit.
Further, the ERP system data unloading device further comprises:
a data unloading checking unit, configured to:
according to a preset data unloading verification rule, carrying out data unloading verification on at least one service subsystem for executing data transfer operation and service documents related to service units of the service subsystem;
and when the service bill does not meet the data unloading verification rule, generating service bill operation prompt information, and displaying the service bill operation prompt information at a user terminal so that a user can operate the corresponding service bill according to the prompt information, and the service bill meets the data unloading verification rule after operation.
According to the configurable ERP system data unloading method and device, business data is transferred according to the user's use requirement, configuration verification is carried out before transferring, and data after transferring verification is unloaded; the framework solution of data unloading is provided through the configuration database, and the framework solution can be realized in various ERP systems; the user data error possibly caused by directly deleting the data is avoided, and the data safety is ensured.
Drawings
Exemplary embodiments of the present invention may be more completely understood in consideration of the following drawings:
FIG. 1 is a flow chart of a configurable ERP system data offloading method of a preferred embodiment of the invention;
FIG. 2 is a schematic diagram of the components of a configurable ERP system data offloading device of a preferred embodiment of the invention;
FIG. 3 is a listing of subsystems and modules to be turned selected by a user in a configurable ERP system data offloading method of a preferred embodiment of the invention;
FIG. 4 is a user selected deadline for historical data transfer of subsystems and modules to be transferred in a configurable ERP system data offloading method of a preferred embodiment of the invention;
FIG. 5 is a business rule check progress presentation page for a user-selected supply chain subsystem in a configurable ERP system data offloading method of a preferred embodiment of the invention;
FIG. 6 is a warning type data verification hint page for a user selected supply chain subsystem in a configurable ERP system data offloading method of a preferred embodiment of the invention;
FIG. 7 is a page of a configurable ERP system data offloading method of a preferred embodiment of the invention, configured for data offloading statements;
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 examples described herein, which are provided to fully and completely disclose the present invention and fully convey the scope of the 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, like elements/components are referred to by like reference numerals.
Unless otherwise indicated, terms (including technical and scientific terms) used herein have the same meaning as commonly understood by one of ordinary skill in the art. In addition, it will be understood that terms 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.
Most of the current ERP products increase with time, users continuously generate various business documents in use, and the data volume managed in the ERP system is increased continuously. Once the upper load limit of the server is close, various problems of unsmooth operation of the ERP system can be caused, and even system breakdown or service defects can be caused. And user data errors that may be caused by direct deletion of data; recovering or correcting errors results in unnecessary time and resource overhead.
As shown in fig. 1, the configurable data unloading method of the ERP system in the embodiment of the present invention is used for the ERP system, where the ERP system includes a plurality of service subsystems, and each service subsystem includes a plurality of service modules;
the method comprises the steps of:
step S100: acquiring at least one service subsystem or service module for executing data transfer operation from a user terminal, and a cut-off period of the data transfer operation corresponding to the at least one service subsystem or service module, wherein the cut-off period is a date of transfer;
step S200: extracting the early-stage data of the final period aiming at least one service subsystem which is checked by data unloading and executes data transfer operation and a service bill related to a service module thereof;
step S300: and deleting the business documents related to the at least one business subsystem and the business modules thereof from a database according to a preset data unloading rule, wherein after data transfer operation is carried out on the at least one business subsystem and the business modules thereof, the business documents related to the at least one business subsystem and the business modules thereof are the early-period data.
It should be understood that, in step S300, the data meeting the unloading condition before the date of the transfer will be deleted, and before the data is deleted, all the service document data in the server will be automatically backed up in the manner disclosed in the prior art.
It should be appreciated that an ERP system includes a plurality of business subsystems, each of which includes 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 by accessing the server.
The configurable ERP system data unloading method of the embodiment is used for a server of an ERP system, business data is transferred according to user use requirements obtained from a user terminal, configuration verification is carried out before the transfer, and data after the transfer verification is unloaded.
Further, the ERP system data unloading method,
before the at least one service subsystem or service module for performing the data transfer operation is obtained from the user terminal, the method further comprises:
determining the use authority of a user and at least one service subsystem or service module with the operation authority of the user according to the user data acquired from the user terminal;
information of the at least one service subsystem or service module is presented at the user terminal so that the user selects at least one service subsystem or service module from which to perform the data transfer operation.
It should be understood that the server of the ERP system verifies the user's usage rights and at least one service subsystem or service module to which the user has the operation rights according to the user name and password acquired from the user terminal.
Further, the ERP system data unloading method further comprises the following steps:
based on at least one service subsystem or service module performing a data transfer operation acquired from the user terminal,
according to the business logic of the at least one business subsystem or business module, configuring a data unloading verification rule corresponding to the at least one business subsystem or business module for executing the data transfer operation;
and configuring a data unloading rule corresponding to the at least one service subsystem or the service module for executing the data transfer operation according to the service logic of the at least one service subsystem or the service module.
Further, the ERP system data unloading method further comprises the following steps:
according to a preset data unloading verification rule, carrying out data unloading verification on at least one service subsystem for executing data transfer operation and service documents related to the service module of the service subsystem;
and when the service bill does not meet the data unloading verification rule, generating service bill operation prompt information, and displaying the service bill operation prompt information at a user terminal so that a user can operate the corresponding service bill according to the prompt information, and the service bill meets the data unloading verification rule after operation.
Further, the ERP system data unloading method,
the extracting the early-stage data of the final stage for the business bill associated with the at least one business subsystem and the business module thereof which execute the data transfer operation through the data unloading verification comprises the following steps:
for the receivable management module of the supply chain subsystem of the ERP system, extracting the initial data of the final period comprises:
and before the date of the transfer, transferring the remaining uncore amount of the checked service bill which is not completely checked to the corresponding initial bill of the next period, and updating the initial mark on the original bill, wherein the service bill comprises the following components: the method comprises the steps of initial bill collection, initial other bill collection, initial sales bill, bill collection, sales bill, sales fee bill, purchasing bill and purchasing fee bill;
registering the bill data of the beginning of the period and the bill table of the receivable detail;
and registering the remaining uncombusted amount in the statement, and updating the receivable general account table according to the statement of the initial receivable.
Further, the ERP system comprises a financial subsystem and a supply chain subsystem;
wherein the financial subsystem comprises a report management module;
the supply chain subsystem comprises a purchase management module, an inventory management module, a commission management module, a sales management module, a management due module or a management due module.
The configurable ERP system data unloading method of the embodiment of the invention carries out business data transfer according to the user requirement, carries out configuration verification before the transfer, and unloads the data after the transfer verification. The configurable ERP system data unloading method provided by the embodiment of the invention provides a framework solution for data unloading through the configuration database, and can be realized in various ERP systems. The configurable ERP system data unloading method of the embodiment of the invention avoids user data errors possibly caused by directly deleting data.
For the ERP front-end user, only a few steps of selection operations are needed to execute the configurable ERP system data unloading method of the embodiment, for example, checking whether the verification is passed; if the result is not passed, checking the reason of the failed result and processing; the data transfer can be performed, so that the operation steps of a user are greatly optimized, and the time required by the data transfer is reduced.
For developers, only the configuration of the database is needed in the development process, and the development work can be completed quickly by dividing the modules.
As shown in fig. 2, a configurable data offloading device of an ERP system in an embodiment of the present invention is configured on a server of the ERP system, and includes:
an execution data transfer operation object acquisition unit 10 for:
acquiring at least one service subsystem or service unit for executing data transfer operation from a user terminal, and a cut-off period of the data transfer operation corresponding to the at least one service subsystem or service unit, wherein the cut-off period is a date of transfer;
a prophase data extraction unit 20 for:
extracting the early-stage data of the outcome period aiming at least one service subsystem which is checked by data unloading and executes data transfer operation and service documents related to service units thereof;
a data unloading unit 30 for:
and deleting the business documents related to the at least one business subsystem and the business units thereof from a database according to a preset data unloading rule, wherein after data transfer operation is carried out on the at least one business subsystem and the business units thereof, the business documents related to the at least one business subsystem and the business units thereof are the early-period data.
Further, the ERP system data unloading device further comprises:
an execution data transfer operation object determination unit configured to:
determining the use authority of a user and at least one service subsystem or service unit with the operation authority of the user according to the user data acquired from the user terminal;
information of the at least one service subsystem or service unit is presented at the user terminal so that the user selects at least one service subsystem or service unit from which to perform the data transfer operation.
Further, the ERP system data unloading device further comprises:
a data unloading verification rule/data unloading rule configuration unit for:
based on at least one service subsystem or service unit obtained from the user terminal performing the data transfer operation,
according to the business logic of the at least one business subsystem or business unit, configuring a data unloading check rule corresponding to the at least one business subsystem or business unit for executing the data transfer operation;
and configuring a data unloading rule corresponding to the at least one service subsystem or the service unit for executing the data transfer operation according to the service logic of the at least one service subsystem or the service unit.
Further, the ERP system data unloading device further comprises:
a data unloading checking unit, configured to:
according to a preset data unloading verification rule, carrying out data unloading verification on at least one service subsystem for executing data transfer operation and service documents related to service units of the service subsystem;
and when the service bill does not meet the data unloading verification rule, generating service bill operation prompt information, and displaying the service bill operation prompt information at a user terminal so that a user can operate the corresponding service bill according to the prompt information, and the service bill meets the data unloading verification rule after operation.
The data unloading device of the embodiment is configured in a target ERP system, and comprises:
checking the data during the period of the user selection of the transfer;
performing a forward operation on the initial data, and ensuring the correctness of the unloaded data;
and deleting the data.
The configurable ERP system data unloading device of the embodiment provides a convenient and effective data transfer tool for an ERP system and avoids the occurrence of continuous expansion of ERP system data.
In summary, the configurable data unloading method and device for the ERP system of the embodiment are applied to the ERP system, and the data unloading method for the big data account cover is achieved. By unloading the historical data which is checked and is in the time designated by the user, the requirement of the user on performance is met under the condition of ensuring the correct data at the beginning of the new account registration period, 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 capable of starting the turning operation is displayed to the user for the user to select.
The financial subsystem and the supply chain subsystem are shown in FIG. 3. Wherein, in the financial subsystem, a report management module is included; the supply chain subsystem comprises a purchasing management module, an inventory management module, a consignment management module, a sales management module, a management due module and the like.
When data transfer is carried out, the operation is carried out step by step according to the logic structures of the service subsystem and the modules in the service subsystem.
After the service range is determined, the user-selected period of the forward-reverse is further acquired. As shown in fig. 4, the deadline for the transfer of the history data selected by the user is 2017, 5 months. That is, the present transfer operation is directed to data generated and stored before 2017, 5 months (31 days). The cut-off period of the historical data transfer takes natural months as the minimum unit; and is the initial time of newly generated data after data unloading.
It should be understood that setting the activation time of the historical data transfer associated with each business module is also included.
After determining the forward period, the server performs service rule verification on the service data to be forwarded. 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 the data offloading associated with the sales module in the supply chain subsystem. Specifically, for various business documents related to the sales module, determining whether the current state of the business document meets the turning-around requirement.
Table 1 verification rules for sales modules to fail data offloading
In the service rule detection process aiming at the supply chain subsystem, a detection log aiming at each service module is generated; the detection log records the starting time and the current period of each service module, and records the detection result as success or warning. Aiming at the item with the warning detection result, a message page shown in fig. 6 is displayed at the user side and is used for prompting the user to have a warning check item, and the user is recommended to carry out the supplementary operation on the related business bill so as to enable the data state of the business bill to meet the turning requirement.
Table 2 lists the data verification rules for generating data offload alerts associated with sales modules in the supply chain subsystem.
Table 2 sales module data offload alert check
If the data unloading verification is unsuccessful (the business rule is not passed), the starting of the forwarding operation is terminated. And correspondingly processing the data to be unloaded by the user according to the unloading failure entry, and restarting the data verification operation before the transfer after the processing until all the data to be transferred meet the transfer requirement.
On the other hand, if the data warning check fails, the user side prompts the data warning check, and waits for the user to select whether to continue unloading the data. It should be appreciated that the data alert check does not pass without affecting the progress of the tie-down.
It should be understood that the data offload checksum data alert check are performed independently and in parallel, respectively; when the data is displayed to the user terminal, the data unloading verification prompt and the data warning verification prompt are displayed simultaneously, so that the integrity and the correctness of the information acquired by the user are ensured.
2) Data processing
Some business subsystems in the ERP system have data associated with business modules that exist for the beginning of their life. For example, the inventory management module, the payable management module and the payable management module in the supply chain subsystem relate to the initial date, all the data to be deleted needs to be processed before the data is deleted, and the final date is extracted.
Specifically, rules of the early-future data of the receivability management module in the supply chain subsystem are as follows:
the checking of the document which is not completely verified before the date is transferred comprises the following steps: the method comprises the steps of transferring the remaining uncombusted amounts of an initial bill, other initial bill to be collected, initial sales bill, bill to be collected, sales bill, purchasing bill and purchasing bill into an initial bill corresponding to the next period, and updating an initial mark on the original bill; registering the bill data of the beginning of the period and the bill table of the receivable detail; and registering the remaining uncombusted amount in the statement, and updating the receivable general account table according to the statement of the initial receivable.
Specifically, the rules of the management module payable in the supply chain subsystem for the early date of the conversion are as follows:
the checking of the document which is not completely verified before the date is transferred comprises the following steps: the remaining uncombusted amounts of the initial payment bill, the initial other payable bill, the initial procurement bill, the payment bill, the sales bill, the procurement bill and the procurement bill are transferred into the initial bill corresponding to the next period, and the initial identification on the original bill is updated; registering the initial bill data of the period and the payable detail account table; the remaining uncombusted amount is registered in the statement, and the general account payable table is updated according to the statement payable at the beginning of the period.
3) Data offloading
And when the data is unloaded, according to the logic relation between the service modules or the service subsystems, the data associated with the service modules are unloaded one by one according to the service logic.
It should be understood that, at the time of deletion or offloading, the execution order of the data offloading operation for each service module and each service subsystem is decomposed and set according to the dependency relationship or precondition relationship that the service modules or the service subsystems have according to the service logic.
Specifically, the server fully pre-prepares the offload data operation statement in the database table. In the specific implementation, the identification of the service module is used as an index, and the unloading data operation sentences are grouped; and unloading data according to a pre-configured business rule aiming at the data unloading operation statement in each group. As shown in fig. 7, the statement is operated on for the offload data configured for the sales management module in the supply chain subsystem.
An offload progress presentation page presented at the user terminal is shown in fig. 8. It should be appreciated that the user terminal of the ERP system does not generate or receive new business documents while offloading data.
According to the configurable ERP system data unloading method, verification is conducted according to the time point selected by the user, and data in the period appointed by the user is unloaded after verification. Preferably, the time point is the last day of accounting period selected by the user, so that the requirement of the enterprise can be met more flexibly.
According to the configurable ERP system data unloading method, during the period of initial accounting which needs to be reserved by a user, data is transversely unloaded after necessary data verification is carried out, basic data are reserved, and 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 business documents in an ERP system, and can be used for configuring various ERP systems currently in operation. The development process is simpler, and when the module to be operated is added, the module is only required to be configured in the database.
The present invention is not limited to the above-mentioned embodiments, and any changes or substitutions that can be easily understood by those skilled in the art within the technical scope of the present invention are intended to be included in the scope of the present invention. Therefore, the protection scope of the present invention should be subject to the protection scope of the claims.
The invention has been described above with reference to a few embodiments. However, as is well known to those skilled in the art, other embodiments than the above disclosed invention are equally possible within the scope of the invention, as defined by 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 therein. All references to "a// the [ means, component, etc ]" are to be interpreted openly as referring to at least one instance of means, 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 (9)
1. A configurable ERP system data unloading method is characterized in that,
the ERP system is used for an ERP system and comprises a plurality of service subsystems, wherein each service subsystem comprises a plurality of service 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 a cut-off period of the data transfer operation corresponding to the at least one service subsystem or service module, wherein the cut-off period is a date of transfer;
extracting early-stage data of a result of a data transfer operation for a business document associated with at least one business subsystem or business module which performs the data transfer operation through data unloading verification, including: for the receivable management module of the supply chain subsystem of the ERP system, extracting the initial data of the final period comprises: and before the date of the transfer, transferring the remaining uncore amount of the checked service bill which is not completely checked to the corresponding initial bill of the next period, and updating the initial mark on the original bill, wherein the service bill comprises the following components: initial bill of collection, initial sales invoice and purchase invoice; after data transfer operation is executed for the at least one service subsystem or service module, service documents associated with the at least one service subsystem or service module are the early-stage data of the outcome period;
and deleting the business document associated with the at least one business subsystem or the business module from the database according to a preset data unloading rule.
2. The ERP system data offloading method of claim 1, wherein,
before the at least one service subsystem or service module for performing the data transfer operation is obtained from the user terminal, the method further comprises:
determining the use authority of a user and at least one service subsystem or service module with the operation authority of the user according to the user data acquired from the user terminal;
information of the at least one service subsystem or service module is presented at the user terminal so that the user selects at least one service subsystem or service module from which to perform 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 acquired from the user terminal,
according to the business logic of the at least one business subsystem or business module, configuring a data unloading verification rule corresponding to the at least one business subsystem or business module for executing the data transfer operation;
and configuring a data unloading rule corresponding to the at least one service subsystem or the service module for executing the data transfer operation according to the service logic of the at least one service subsystem or the service module.
4. The ERP system data offloading method of claim 3, further comprising:
according to a preset data unloading verification rule, carrying out data unloading verification on at least one service subsystem for executing data transfer operation and service documents related to the service module of the service subsystem;
and when the service bill does not meet the data unloading verification rule, generating service bill operation prompt information, and displaying the service bill operation prompt information at a user terminal so that a user can operate the corresponding service bill according to the prompt information, and the service bill meets the data unloading verification rule after operation.
5. The ERP system data offloading method of claim 1, wherein,
the ERP system comprises a financial subsystem and a supply chain subsystem;
wherein the financial subsystem comprises a report management module;
the supply chain subsystem comprises a purchase management module, an inventory management module, a commission management module, a sales management module, a management due module or a management due module.
6. A configurable ERP system data offloading apparatus, configured to a server of an ERP system, comprising:
an execution data transfer operation object acquisition unit configured to:
acquiring at least one service subsystem or service unit for executing data transfer operation from a user terminal, and a cut-off period of the data transfer operation corresponding to the at least one service subsystem or service unit, wherein the cut-off period is a date of transfer;
a final-period initial data extraction unit for:
extracting early-stage data of a result of a data transfer operation for at least one service subsystem or service document associated with a service unit which is checked by data unloading, wherein the early-stage data comprises the following steps: for the receivable management module of the supply chain subsystem of the ERP system, extracting the initial data of the final period comprises: and before the date of the transfer, transferring the remaining uncore amount of the checked service bill which is not completely checked to the corresponding initial bill of the next period, and updating the initial mark on the original bill, wherein the service bill comprises the following components: initial bill of collection, initial sales invoice and purchase invoice; after data transfer operation is executed for the at least one service subsystem or service module, service documents associated with the at least one service subsystem or service module are the early-stage data of the outcome period;
a data unloading unit for:
and deleting the business document associated with the at least one business subsystem or the business unit from the database according to a preset data unloading rule.
7. The ERP system data offloading apparatus of claim 6, wherein,
further comprises:
an execution data transfer operation object determination unit configured to:
determining the use authority of a user and at least one service subsystem or service unit with the operation authority of the user according to the user data acquired from the user terminal;
information of the at least one service subsystem or service unit is presented at the user terminal so that the user selects at least one service subsystem or service unit from which to perform the data transfer operation.
8. The ERP system data offloading apparatus of claim 7, further comprising:
a data unloading verification rule/data unloading rule configuration unit for:
based on at least one service subsystem or service unit obtained from the user terminal performing the data transfer operation,
according to the business logic of the at least one business subsystem or business unit, configuring a data unloading check rule corresponding to the at least one business subsystem or business unit for executing the data transfer operation;
and configuring a data unloading rule corresponding to the at least one service subsystem or the service unit for executing the data transfer operation according to the service logic of the at least one service subsystem or the service unit.
9. The ERP system data offloading apparatus of claim 6, further comprising:
a data unloading checking unit, configured to:
according to a preset data unloading verification rule, carrying out data unloading verification on at least one service subsystem for executing data transfer operation and service documents related to service units of the service subsystem;
and when the service bill does not meet the data unloading verification rule, generating service bill operation prompt information, and displaying the service bill operation prompt information at a user terminal so that a user can operate the corresponding service bill according to the prompt information, and the service bill 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 CN111209273A (en) | 2020-05-29 |
| CN111209273B true 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) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112598492B (en) * | 2020-12-25 | 2023-12-01 | 航天信息股份有限公司企业服务分公司 | project cost accounting system |
Citations (12)
| 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 |
| 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 |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2014146066A2 (en) * | 2013-03-15 | 2014-09-18 | 3-D Business Tools, Llc | Business analysis tool using attribute groups |
-
2019
- 2019-12-29 CN CN201911386037.1A patent/CN111209273B/en active Active
Patent Citations (12)
| 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 |
| 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 |
|---|
| 以业务单据为中心的业务流程模型聚类及相似性查询方法;刘海滨 等;计算机集成制造系统;第19卷(第08期);1810-1821 * |
| 应用EAServer多层构架的ERP系统的设计与实现;王向炜;中国优秀硕士学位论文全文数据库信息科技辑(第10期);I138-232 * |
| 税务管理决策分析系统的设计与应用;高恩龙;中国优秀硕士学位论文全文数据库信息科技辑(第08期);I138-1038 * |
| 金蝶、安易、用友三大会计核算软件评价;黄永琳;中国会计电算化(02);14-17 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111209273A (en) | 2020-05-29 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US6477703B1 (en) | Software patch selection tool | |
| US6990466B1 (en) | Method and system for integrating core banking business processes | |
| US11915239B2 (en) | System and method for updating and managing hosted catalogs in a procurement system | |
| US20070169097A1 (en) | Configuration tool and method of updating an archive file property relating to at least one point-of-sale peripheral | |
| Fisher et al. | Utilizing Atlassian JIRA for large-scale software development management | |
| US20160086130A1 (en) | Method and apparatus for foreign trade and export control | |
| CN102812462A (en) | Database, data-management server, and data-management program | |
| CN111209273B (en) | Configurable ERP system data unloading method and device | |
| US20060026595A1 (en) | Workflow management apparatus, workflow management program, and workflow management method | |
| CN112561370A (en) | Software version management method and device, computer equipment and storage medium | |
| CN108711109B (en) | Method, device, storage medium and apparatus for updating preparation gold computing system | |
| US20020128874A1 (en) | Computer-implemented vehicle repair claims rules generator system | |
| CN114661423A (en) | Cluster configuration detection method and device, computer equipment and storage medium | |
| CN113362025A (en) | Data accounting system, method, computer readable storage medium, electronic device | |
| US20090182671A1 (en) | Interface system for annuity database for management of assets | |
| US20020128876A1 (en) | Computer-implemented vehicle repair claims processing system | |
| US20060085209A1 (en) | Establishment of vehicle item categories | |
| EP3651106A1 (en) | Systems and methods for generating a digital identity of equipment on an equipment online marketplace platform | |
| CN110704462A (en) | Data change notification method, electronic device, computer device, and storage medium | |
| CN110956552B (en) | Insurance problem processing method, apparatus, device and storage medium | |
| CN115167896A (en) | Method and device for updating software version, storage medium and electronic equipment | |
| US11494832B2 (en) | Systems and methods for securely creating a listing of equipment on an equipment online marketplace platform | |
| CN111796847A (en) | System software verification method and device | |
| CN114327588A (en) | Method and device for processing code submission log | |
| CN112165512B (en) | File release method and device, terminal 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 |