Method for achieving concurrency control over business bill push-down

A technology of business documents and documents, which is applied in the concurrency control field of the push-down process of business documents in the EPR system, and can solve problems such as data errors

Inactive Publication Date: 2014-04-16
TIANJIN HENGXING TECH
View PDF0 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] The purpose of the present invention is to provide a method for effectively controlling concurrency in the push-down process of business documents, so as to solve the problem of data errors that may be caused by the current ERP system during the push-down operation of documents

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0015] The present invention provides a method for realizing push-down concurrency control of business documents, which includes the following steps in the specific implementation process:

[0016] 1. Create a business document push-down status table in a relational database: fields include but are not limited to document category, document internal code (the above two fields can be used as primary keys), creator, creation time, workstation name, etc.;

[0017] 2. Realize the document push-down state management class, which completes the maintenance of the state table, including table insertion, update, deletion, and query;

[0018] 3. The document push-down program queries the status information of the business document push-down process through the status management class. The status management class is based on the incoming relevant information. The typical query parameters are the document type and the internal code of the document. If there is none, the returned status is ...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention relates to the technical field of Enterprise Resources Planning (ERP). According to an ERP system, the push-down operation often needs to be carried out on one kind of business bill, the follow-up business process is finished, but due to the complexity of the ERP system application, it may occur that different users operate the same business bill, for example, the same purchasing order is operated into a purchasing storage entry, the repeated storage operation is caused, the error of the executing condition information of the purchasing order is caused, and the same condition may happen in the process of processing other business bills. The method for achieving effective concurrency control during the business data push-down process is provided, a state management mechanism is established, the business bill push-down process can be carried out according to the state, and therefore the data error problem probably caused during the bill push-down operation process in the ERP system can be effectively solved.

Description

technical field [0001] The invention relates to the technical field of enterprise resource planning (Enterprise Resources Planning, ERP), in particular to a concurrency control method for the push-down process of business documents in the EPR system. Background technique [0002] In the ERP system, it is often necessary to push down certain business documents to complete the follow-up business process, such as pushing down from purchase order to purchase storage order, and pushing down from sales order to sales delivery order. This design simplifies The entry work of follow-up business improves the efficiency and establishes the connection between business (documents). However, due to the complexity of the application of the ERP system, different users may operate the same business document, such as a purchase order to purchase storage order, which will cause repeated storage operations, and also cause information on the execution of purchase orders. Error, the typical oper...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
IPC IPC(8): G06Q10/06
Inventor马铮
OwnerTIANJIN HENGXING TECH