CN102567826A - Method and system for processing material bills - Google Patents
Method and system for processing material bills Download PDFInfo
- Publication number
- CN102567826A CN102567826A CN201010596296XA CN201010596296A CN102567826A CN 102567826 A CN102567826 A CN 102567826A CN 201010596296X A CN201010596296X A CN 201010596296XA CN 201010596296 A CN201010596296 A CN 201010596296A CN 102567826 A CN102567826 A CN 102567826A
- Authority
- CN
- China
- Prior art keywords
- document
- plan
- classification
- parameter
- plan classification
- 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
Images
Abstract
The invention relates to a method for processing material bills, which comprises the following steps of: adding plan category fields for the material bills; setting plan category parameters for calculating a material requirement plan; and selecting the material bills according with the set plan category parameters to participate in calculation of the material requirement plan. A system for processing the material bills comprises a bill setting module, a parameter setting module and a calculating module, wherein the bill setting module is used for adding the plan category fields for the material bills; the parameter setting module is used for setting the plan category parameters for calculating the material requirement plan; and the calculating module is used for selecting the material bills according with the set plan category parameters to participate in calculation of the material requirement plan. According to the method and the system, by adding the plan category fields for the material bills, an auxiliary material management system of a computer can identify the bills with different production categories, so that the calculation of the material requirement plan can be selectively carried out. The method and the system are simple and effective.
Description
[technical field]
The present invention relates to the area of computer aided handling of goods and materials, especially relate to a kind of method and system of material handling document.
[background technology]
In the handling of goods and materials of enterprise production; MRP (Material Requirements Planning; MRP) calculate according to sales order, stock, the time in advance, BOM (Bill of Materiel) structure, Scheduled Receipt, expectation outbound amount etc. calculate and produce Start Date, Close Date; The material procurement date reaches the market demand that satisfies customer order date demand or product, and stock's balance.
When MRP calculates, need use multiple document, like demand document and expectation amount document.Traditional M RP calculates and can only in the document that provides, select document to participate in or do not participate in MRP calculating, utilizes same type of document to carry out the different production plan and relate in the actual production, like test manufacture or the volume production product that singly carries out according to production task.When the user need distinguish the product of volume production and test manufacture; Computer system has no idea to discern this two kinds of documents; Therefore can't obtain the MRP data of different production schedule classifications, accomplish that also to have no way of differentiating be the MRP data of which type production schedule classification even perhaps calculate.
[summary of the invention]
Given this, be necessary to provide a kind of disposal route of material document of the different production schedule classifications that can discern same type of document simply.
A kind of method of material handling document comprises the steps: to be material document interpolation plan classification field; Be provided for the plan classification parameter that MRP calculates; Choosing the material document partner material plan of needs that meets set plan classification parameter calculates.
Preferably, the said step that is provided for the plan classification parameter of MRP calculating comprises: read said material document and have the plan classification; The plan of choosing one or more in classification are as the screening classification.
Preferably, saidly choose the step that the material document partner material plan of needs that meets set plan classification parameter calculates and comprise: relatively the value of the plan classification field of said material document and plan classification parameter; Filter out plan classification field value and the material document of planning the classification parameter coupling; Deposit the material document that filters out in the database temporary table.
Preferably, the said step that is provided for the plan classification parameter that MRP calculates comprises also the plan classification create-rule of material document as a result is set that be specially: the plan classification of material document is set to acquiescence as a result; Or make the plan classification of material document as a result identical with said screening classification.
Preferably, said material document comprises demand document and expectation amount document, and said demand document is one or more in product prediction list, sales order and the export trade order; Said expectation amount document is in single one or more of order and production task outside planned order, production task list, procurement request list, purchase order, the committee.
A kind of system of material handling document comprises: document is provided with module, is used to material document interpolation plan classification field; Parameter is provided with module, is used to be provided for the plan classification parameter that MRP calculates; Computing module is used to choose the material document partner material plan of needs that meets set plan classification parameter and calculates.
Preferably, said parameter is provided with module and specifically is used for: read said material document and have the plan classification; The plan of choosing one or more in classification are as the screening classification.
Preferably, said computing module specifically is used for: with the value of the plan classification field of said material document and plan classification parameter relatively; Filter out plan classification field value and the material document of planning the classification parameter coupling; Deposit the material document that filters out in the database temporary table.
Preferably, said parameter is provided with module and also is used to be provided with the plan classification create-rule of material document as a result, is specially: the plan classification of material document is set to acquiescence as a result; Or make the plan classification of material document as a result identical with said screening classification.
Preferably, said material document comprises demand document and expectation amount document, and said demand document is that product prediction is single, a kind of in sales order and the export trade order; Said expectation amount document is a kind of in single of order and production task outside planned order, production task list, procurement request list, purchase order, the committee.
Said method and system make computer assisted material management system can discern the document of different production classifications through for the material document adds " plan classification " field, calculate thereby can carry out MRP selectively, and be effectively simple.
[description of drawings]
Fig. 1 is the method flow diagram of the material handling document of an embodiment;
Fig. 2 is the processing flow chart of step S20 among Fig. 1;
Fig. 3 is the processing flow chart of step S30 among Fig. 1;
Fig. 4 is the system construction drawing of the material handling document of an embodiment.
[embodiment]
Further specify below in conjunction with accompanying drawing and specific embodiment method and system the material handling document.
As shown in Figure 1, be the method flow diagram of the material handling document of an embodiment.This method comprises the steps:
S10: for the material document adds the plan classification field.The material document is related aborning various documents, is used for instructing producing and selling, buying etc.The material document of present embodiment mainly comprise the demand document of representing material requirement (single, sales order and export trade order) like the product prediction with and in transit and at the expectation amount document (order and production task are singly outside like planned order, production task list, procurement request list, purchase order, committee) of system.The field of material document (attribute) can be represented some information of material document, such as creation-time, size etc.This step makes the material document comprise the information of related production classification for the material document adds " plan classification " field, can distinguish being used for the different production classification with a kind of document through the value of " plan classification " field.As shown in table 1, be a kind of mode of adding field value for the material document:
| Code | Title | The product prediction is single | Sales order | The export trade order | Procurement request is single |
| STD | Standard | √ | √ | √ | √ |
| SE01 | Test manufacture | √ | √ | ||
| YP01 | Sample | √ | √ |
Table 1
Select setting to make product prediction list that the standard production classification only arranged through the user, make sales order that two kinds of production classifications of standard and test manufacture arranged, make the export trade order have standard, test manufacture and sample production classification simultaneously, make procurement request singly have standard and sample production classification.For the material document adds after the field value, " the plan classification " of material document can be one of them of the field value that adds.Only have a kind of production classification as product prediction is single, i.e. standard production classification, and the export trade order can be used for standard category production, test manufacture and sample production.
S20: be provided for the plan classification parameter that MRP calculates.The plan classification parameter mainly comprises the condition of screening material document and generates the rule of material document as a result.The plan classification of the material document after being provided with through step S10 is a kind of in a variety of plan classifications that are provided with in advance, and this step is provided with the condition of the satisfactory material document of screening from these plan classifications, and the plan classification field value of screening promptly is set.The material document is the document as a result that obtains after MRP (MRP) calculates as a result, is the reflection to the whole material requirement of product.This step also is provided with the create-rule of the plan classification of material document as a result.
S30: choose the material document partner material plan of needs that meets set plan classification parameter and calculate.After setting the plan classification parameter, can all material documents be distinguished, screen, then the material document ginseng MRP that filters out is calculated the MRP of the production classification that obtains expecting.
Through add the plan classification field for the material document, make computer assisted material management system can discern the document of different production classifications, calculate thereby can carry out MRP selectively, effectively simple.
Wherein at step S20: the step that is provided for the plan classification parameter of MRP calculating comprises:
S201: read said material document and have the plan classification.The plan classification parameter is corresponding with material document " plan classification ".Owing in step S10,, therefore when the plan classification parameter is set, at first read these plan classifications for different types of material document can be given multiple different plan classification respectively.As shown in table 2, be a kind of plan classification parameter setting of plan classification of correspondence table 1.
| Document types | Code | Title | This MPS/MRP |
| The product prediction is single | STD | Standard | √ |
| Sales order | STD | Standard | √ |
| SE01 | Test manufacture | ||
| The export trade order | STD | Standard | √ |
| SE01 | Test manufacture | ||
| YP01 | Sample | ||
| Procurement request is single | STD | Standard | √ |
| YP01 | Sample |
Table 2
Can see that product is predicted single owing to only be provided with the standard production classification, so it only has the standard production classification optional.The export trade order then has standard, test manufacture and the optional setting of sample three kinds.
S202: the plan of choosing one or more in classification are as the screening classification.Like the belongings material list certificate of need selection standard production classification, then with in " this MPS/MRP " classification that " standard " should be arranged being chosen.Certainly, in addition can also choose other classification.Through being provided with, MRP being calculated filter out satisfactory material document.As shown in table 2, all the product of selection standard production classification prediction list, sales order, export trade order and procurement request are single.
Step S30: the step of choosing the material document partner material plan of needs calculating that meets set plan classification parameter comprises:
S301: relatively with the value of the plan classification field of said material document and plan classification parameter.Plan classification parameter like each material document in the table 2 all is set to " standard ", in estimate participating in the material document that MRP calculates, with the value of the plan classification field of material document and " standard " classification relatively.
S302: filter out plan classification field value and the material document of planning the classification parameter coupling.The value of plan classification field is retained for the material document of " standard ", and other unmatched material documents then are left in the basket.
S303: deposit the material document that filters out in the database temporary table.Temporary table is the temporary storage table when being used for a MRP calculating, is used to store relate to the material document that this MRP calculates, and transfers when supplying MRP to calculate.
Further, in the material bill processing method of present embodiment, step S20 also comprises the plan classification create-rule of material document as a result is set, and is specially: the plan classification of material document is set to acquiescence as a result; Or make the plan classification of material document as a result identical with said screening classification.
The final step of calculating at MRP still will be provided with production schedule classification for material document as a result, can be different plan class orders according to the MRP result calculated.If the plan classification of material document is set to acquiescence as a result, then when generating document, generate according to the plan classification in the default setting, be " standard " like default setting, then produce document plan classification and be " standard ".If make the plan classification of material document as a result identical with said screening requirements classification, then will before participate in the demand document of MRP calculating plan classification field value bring as a result that the material document gets final product into.Demand document such as the test manufacture class does not generate according to default rule, but generates the plan document of test manufacture class according to it.
As shown in Figure 5, be the system of the material handling document of an embodiment.This system comprises that document is provided with module 10, parameter is provided with module 20 and computing module 30.
Document is provided with module 10 and is used to material document interpolation " plan classification " field.The material document is related aborning various documents, is used for instructing producing and selling, buying etc.The material document of present embodiment mainly comprise the demand document of representing material requirement (single, sales order and export trade order) like the product prediction with and in transit and at the expectation amount document (order and production task are singly outside like planned order, production task list, procurement request list, purchase order, committee) of system.The field of material document (attribute) can be represented some information of material document, such as creation-time, size etc.This step makes the material document comprise the information of related production classification for the material document adds " plan classification " field, can distinguish being used for the different production classification with a kind of document through the value of " plan classification " field.As shown in table 3, be a kind of mode of adding field value for the material document:
| Code | Title | The product prediction is single | Sales order | The export trade order | Procurement request is single |
| STD | Standard | √ | √ | √ | √ |
| SE01 | Test manufacture | √ | √ | ||
| YP01 | Sample | √ | √ |
Table 3
Select setting to make product prediction list that the standard production classification only arranged through the user, make sales order that two kinds of production classifications of standard and test manufacture arranged, make the export trade order have standard, test manufacture and sample production classification simultaneously, make procurement request singly have standard and sample production classification.For the material document adds after the field value, " the plan classification " of material document can be one of them of the field value that adds.Only have a kind of production classification as product prediction is single, i.e. standard production classification, and the export trade order can be used for standard category production, test manufacture and sample production.
Parameter is provided with module 20 and is used to be provided for the plan classification parameter that MRP calculates.The plan classification parameter mainly comprises the condition of screening material document and the create-rule of the plan classification of material document as a result.After the process document is provided with being provided with of module 10; The plan classification of material document is a kind of in a variety of plan classifications that are provided with in advance; Parameter is provided with the condition that module 20 is provided with the satisfactory material document of screening from these plan classifications, and the plan classification field value of screening promptly is set.The material document is the document as a result that obtains after MRP (MRP) calculates as a result, is the reflection to the whole material requirement of product.Parameter is provided with module 20 the plan classification create-rule of material document as a result also is set.
Computing module 30 is used to choose the material document partner material plan of needs that meets set plan classification parameter and calculates.After setting the plan classification parameter, can all material documents be distinguished, screen, then the material document ginseng MRP that filters out is calculated the MRP of the production classification that obtains expecting.
Through add the plan classification field for the material document, make computer assisted material management system can discern the document of different production classifications, calculate thereby can carry out MRP selectively, effectively simple.
Wherein parameter is provided with module 20 and specifically is used to read said material document and has the plan classification, chooses in the plan classification one or more then as the screening classification.
The plan classification parameter is corresponding with material document " plan classification ".Owing in step S10,, therefore when the plan classification parameter is set, at first read these plan classifications for different types of material document can be given multiple different plan classification respectively.As shown in table 4, be a kind of plan classification parameter setting of plan classification of correspondence table 3.
| Document types | Code | Title | This MPS/MRP |
| The product prediction is single | STD | Standard | √ |
| Sales order | STD | Standard | √ |
| SE01 | Test manufacture | ||
| The export trade order | STD | Standard | √ |
| SE01 | Test manufacture | ||
| YP01 | Sample | ||
| Procurement request is single | STD | Standard | √ |
| YP01 | Sample |
Table 4
Can see that product is predicted single owing to only be provided with the standard production classification, so it only has the standard production classification optional.The export trade order then has standard, test manufacture and the optional setting of sample three kinds.
Computing module 30 specifically is used for: with the value of the plan classification field of said material document and plan classification parameter relatively; Filter out plan classification field value and the material document of planning the classification parameter coupling; Deposit the material document that filters out in the database temporary table.
Computing module 30 also is used to be provided with the plan classification create-rule of material document as a result, specifically comprises: the plan classification of material document is set to acquiescence as a result; Or make the plan classification of material document as a result identical with said screening classification.
The above embodiment has only expressed several kinds of embodiments of the present invention, and it describes comparatively concrete and detailed, but can not therefore be interpreted as the restriction to claim of the present invention.Should be pointed out that for the person of ordinary skill of the art under the prerequisite that does not break away from the present invention's design, can also make some distortion and improvement, these all belong to protection scope of the present invention.Therefore, the protection domain of patent of the present invention should be as the criterion with accompanying claims.
Claims (10)
1. the method for a material handling document is characterized in that, comprises the steps:
For the material document adds the plan classification field;
Be provided for the plan classification parameter that MRP calculates;
Choosing the material document partner material plan of needs that meets set plan classification parameter calculates.
2. the method for material handling document as claimed in claim 1 is characterized in that, the said step that is provided for the plan classification parameter of MRP calculating comprises:
Read said material document and have the plan classification;
The plan of choosing one or more in classification are as the screening classification.
3. the method for material handling document as claimed in claim 1 is characterized in that, the said step of choosing the material document partner material plan of needs calculating that meets set plan classification parameter comprises:
With the value of the plan classification field of said material document and plan classification parameter relatively;
Filter out plan classification field value and the material document of planning the classification parameter coupling;
Deposit the material document that filters out in the database temporary table.
4. the method for material handling document as claimed in claim 2 is characterized in that, the said step that is provided for the plan classification parameter that MRP calculates also comprises the plan classification create-rule of material document as a result is set, and is specially:
The plan classification of material document is set to acquiescence as a result; Or
Make the plan classification of material document as a result identical with said screening classification.
5. the method for material handling document as claimed in claim 1 is characterized in that, said material document comprises demand document and expectation amount document, and said demand document is one or more in product prediction list, sales order and the export trade order; Said expectation amount document is in single one or more of order and production task outside planned order, production task list, procurement request list, purchase order, the committee.
6. the system of a material handling document is characterized in that, comprising:
Document is provided with module, is used to material document interpolation plan classification field;
Parameter is provided with module, is used to be provided for the plan classification parameter that MRP calculates;
Computing module is used to choose the material document partner material plan of needs that meets set plan classification parameter and calculates.
7. the system of material handling document as claimed in claim 6 is characterized in that, said parameter is provided with module and specifically is used for:
Read said material document and have the plan classification;
The plan of choosing one or more in classification are as the screening classification.
8. the system of material handling document as claimed in claim 6 is characterized in that, said computing module specifically is used for:
With the value of the plan classification field of said material document and plan classification parameter relatively;
Filter out plan classification field value and the material document of planning the classification parameter coupling;
Deposit the material document that filters out in the database temporary table.
9. the system of material handling document as claimed in claim 7 is characterized in that, said parameter is provided with module and also is used to be provided with the plan classification create-rule of material document as a result, is specially:
The plan classification of material document is set to acquiescence as a result; Or
Make the plan classification of material document as a result identical with said screening classification.
10. the system of material handling document as claimed in claim 6 is characterized in that, said material document comprises demand document and expectation amount document, and said demand document is that product prediction is single, a kind of in sales order and the export trade order; Said expectation amount document is a kind of in single of order and production task outside planned order, production task list, procurement request list, purchase order, the committee.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201010596296.XA CN102567826B (en) | 2010-12-20 | 2010-12-20 | The method and system of material handling document |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201010596296.XA CN102567826B (en) | 2010-12-20 | 2010-12-20 | The method and system of material handling document |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN102567826A true CN102567826A (en) | 2012-07-11 |
| CN102567826B CN102567826B (en) | 2016-05-25 |
Family
ID=46413193
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201010596296.XA Active CN102567826B (en) | 2010-12-20 | 2010-12-20 | The method and system of material handling document |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102567826B (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104281902A (en) * | 2013-07-05 | 2015-01-14 | 航天信息软件技术有限公司 | Material requirement suggestion making method |
| CN105678484A (en) * | 2014-11-18 | 2016-06-15 | 金蝶软件（中国）有限公司 | MRP calculation process control method and system |
| CN109544060A (en) * | 2018-10-18 | 2019-03-29 | 金蝶软件（中国）有限公司 | Delivery amount control method, device, computer equipment and storage medium based on ERP |
| CN109857759A (en) * | 2018-11-06 | 2019-06-07 | 金蝶软件（中国）有限公司 | Processing method, device, computer equipment and the storage medium of concurrent data |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1904919A (en) * | 2006-08-03 | 2007-01-31 | 董学军 | Comprehensive managing system of small power transformer limiting design and measurement automatic recording |
| CN101158977A (en) * | 2007-11-21 | 2008-04-09 | 金蝶软件（中国）有限公司 | Method and system for processing multiple services bills data |
| CN101388088A (en) * | 2008-11-11 | 2009-03-18 | 金蝶软件（中国）有限公司 | Range-assigned material demand planning method and relevant apparatus |
| CN101706912A (en) * | 2009-11-23 | 2010-05-12 | 浪潮集团山东通用软件有限公司 | Sales order BOM-based method for tracking material and calculating material requirements |
-
2010
- 2010-12-20 CN CN201010596296.XA patent/CN102567826B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1904919A (en) * | 2006-08-03 | 2007-01-31 | 董学军 | Comprehensive managing system of small power transformer limiting design and measurement automatic recording |
| CN101158977A (en) * | 2007-11-21 | 2008-04-09 | 金蝶软件（中国）有限公司 | Method and system for processing multiple services bills data |
| CN101388088A (en) * | 2008-11-11 | 2009-03-18 | 金蝶软件（中国）有限公司 | Range-assigned material demand planning method and relevant apparatus |
| CN101706912A (en) * | 2009-11-23 | 2010-05-12 | 浪潮集团山东通用软件有限公司 | Sales order BOM-based method for tracking material and calculating material requirements |
Non-Patent Citations (1)
| Title |
|---|
| 王晟，王松，刘强: "《Visual FoxPro数据库开发经典案例解析》", 31 July 2005, 清华大学出版社 * |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104281902A (en) * | 2013-07-05 | 2015-01-14 | 航天信息软件技术有限公司 | Material requirement suggestion making method |
| CN105678484A (en) * | 2014-11-18 | 2016-06-15 | 金蝶软件（中国）有限公司 | MRP calculation process control method and system |
| CN109544060A (en) * | 2018-10-18 | 2019-03-29 | 金蝶软件（中国）有限公司 | Delivery amount control method, device, computer equipment and storage medium based on ERP |
| CN109857759A (en) * | 2018-11-06 | 2019-06-07 | 金蝶软件（中国）有限公司 | Processing method, device, computer equipment and the storage medium of concurrent data |
| CN109857759B (en) * | 2018-11-06 | 2021-06-15 | 金蝶软件（中国）有限公司 | Concurrent data processing method and device, computer equipment and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN102567826B (en) | 2016-05-25 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Rinaldi et al. | Technology selection in green supply chains-the effects of additive and traditional manufacturing | |
| Biswas et al. | Optimal batch quantity models for a lean production system with in-cycle rework and scrap | |
| Gharaei et al. | Four-echelon integrated supply chain model with stochastic constraints under shortage condition: Sequential quadratic programming | |
| WO2001040886A1 (en) | Production scheduling system | |
| CN102567826A (en) | Method and system for processing material bills | |
| Agra et al. | Optimizing make-to-stock policies through a robust lot-sizing model | |
| Demir et al. | Competing through the last mile: Strategic 3D printing in a city logistics context | |
| CN104573903A (en) | Computer program for process control over enterprise production scheduling and production flow management | |
| CN101944212A (en) | Method and device for generating changed receipt | |
| Kaur et al. | Environmentally sustainable stochastic procurement model | |
| US11474498B2 (en) | Methods and systems for ordering expedited production or supply of designed products | |
| CN102254240A (en) | Data object substitution device and data object substitution method | |
| Chen et al. | Loss-averse retailer’s optimal ordering policies for perishable products with customer returns | |
| Behin et al. | Optimization of supply chain planning with considering defective rates of products in each echelon | |
| CN101697217A (en) | Method and device for generating evaluation scheme | |
| Sontake et al. | Sustainable supplier selection and order allocation considering discount schemes and disruptions in supply chain | |
| CN112699174B (en) | Big data building product drive chain diagram generation method | |
| Khaminich et al. | Managing the Product’s Creation of an Innovation-Oriented Engineering Business | |
| Skvortsova et al. | Economic assessment of the effectiveness of the introduction of industry 4.0 technologies in the activities of industrial enterprises | |
| Nappi et al. | Sustainability performance indicators for product lifecycle management | |
| Hong et al. | OPTIMAL PRICING AND GUARANTEED LEAD TIME WITH LATENESS PENALTIES. | |
| Park et al. | Optimal guaranteed service time and service level decision with time and service level sensitive demand | |
| CN105631684A (en) | Data analysis system used for electronic platform | |
| Liu et al. | Mixed-integer second order conic programming formulation for joint lot-sizing and pricing problem | |
| Süer et al. | Simultaneous optimisation of cell loading and transportation method selection decisions |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant |