CN104281902A - Material requirement suggestion making method - Google Patents
Material requirement suggestion making method Download PDFInfo
- Publication number
- CN104281902A CN104281902A CN201310282251.9A CN201310282251A CN104281902A CN 104281902 A CN104281902 A CN 104281902A CN 201310282251 A CN201310282251 A CN 201310282251A CN 104281902 A CN104281902 A CN 104281902A
- Authority
- CN
- China
- Prior art keywords
- article
- demand
- source
- involved
- quantity required
- 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.)
- Pending
Links
Classifications
-
- 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/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0631—Resource planning, allocation, distributing or scheduling for enterprises or organisations
- G06Q10/06315—Needs-based resource requirements planning or analysis
Abstract
The invention relates to a material requirement suggestion making method. The method comprises the steps that a requirement source is obtained, wherein the requirement source is one or more of the newest master production schedule and the newest sales order or a temporary schedule; all required objects involved in the requirement source and the required quantities of all required objects are obtained; the static available quantities of all the objects are obtained, the static available quantities comprise the stock quantities of the objects and available stock quantities of the objects involved in all schedule factors before the requirement source is obtained, and the schedule factors comprise one or more of production suggestions, purchase suggestions, outsourcing suggestions, production schedules, purchase schedules, production orders, purchase orders and outsourcing orders; the static available quantities of the objects are used for charging against the required quantities of required objects with the same names with the objects, and results are used as material requirement suggestions to be displayed. By means of the method, the required quantities of all required objects can be quickly and accurately adjusted when requirements change.
Description
Technical field
The present invention relates to MRP technical field, particularly relate to the formulating method of a kind of material requirement suggestion.
Background technology
MRP (Material Requirement Planning, MRP) be designed and for the manufacture of the information management system of industry, it solve and how to realize manufacturing production management target---obtain this difficult problem of required material in the correct time by correct quantity.
When demand changes, such as, change MPS, or interim insert very near sales order at delivery date, the quantity required of material all can be caused to change, thus larger impact is produced on whole MRP.Existing MRP technology is when tackling this kind of problem, often need to be adjusted material requirement by hand computation, and then adjustment scheduling of production, this not only adds manually-operated difficulty and complexity, and easily there is mistake, cause the problems such as scheduling of production is chaotic, cause unnecessary loss to enterprise.
Summary of the invention
Technical matters to be solved by this invention is to provide the formulating method of a kind of material requirement suggestion, can adjust the quantity required of each demand article when demand changes quickly and accurately.
The technical scheme that the present invention solves the problems of the technologies described above is as follows: a kind of formulating method of material requirement suggestion, and the method comprises:
Obtain source of demand, described source of demand is more than one or Contingency plans in up-to-date MPS and up-to-date sales order;
Obtain the quantity required of all demand article involved by described source of demand and each described demand article;
Obtain the static available quantity of each article, described static available quantity comprises: the stockpile number of each described article, obtain the available stock quantity of each described article involved by each program element before described source of demand; Described program element comprises: produce suggestion, purchasing recommendation, advise outside committee, the production schedule, procurement plan, production order, purchase order, outside committee in order more than one;
Carry out the quantity required of offset and this article described demand article of the same name with the static available quantity of each described article, its result shows as described material requirement suggestion.
The invention has the beneficial effects as follows: in the present invention, after acquisition source of demand, demand article involved by further acquisition source of demand and quantity required thereof, then the static available quantity of each article is obtained, the quantity required of offset article of the same name so just can be carried out with the static available quantity of each article, thus obtaining the suggested quantity of each article, these work all can realize automatically.Because source of demand covers the change of up-to-date MPS, Contingency plans and these three kinds of demands of up-to-date sales order, static available quantity covers the available stock quantity of the stockpile number of article and the article involved by various program element, thus the present invention can when arbitrary demand changes, adjust the quantity required of each demand article quickly and accurately, obtain the suggestion of corresponding material requirement, thus help enterprise is timely, arranged rational is produced, and guarantees the realization of MRP target.
On the basis of technique scheme, the present invention can also do following improvement:
Further, a part is had at least to preserve with the form of Bill of Material (BOM) in the article involved by described source of demand; Obtain the production suggestion before described source of demand, the outer suggestion of committee, article involved by the production schedule preserve with the form of Bill of Material (BOM); Obtain the production order before described source of demand, the outer order of committee is preserved with the form of component table;
The method of the quantity required of all demand article then involved by the described source of demand of described acquisition and each described demand article is:
The article do not preserved with the form of Bill of Material (BOM) involved by described source of demand and quantity required correspondence thereof are saved in interim tablet menu; All article preserved with the form of Bill of Material (BOM) involved by described source of demand are successively launched completely according to its Bill of Material (BOM), all article involved by this Bill of Material (BOM) and quantity required correspondence thereof is saved in described interim tablet menu;
Article involved by the production obtained before described source of demand suggestion, the outer suggestion of committee, the production schedule are all successively launched according to its Bill of Material (BOM), all article involved by this Bill of Material (BOM) and quantity required correspondence thereof is saved in described interim tablet menu; The production order obtained before described source of demand, the outer order of committee are successively launched according to its component table, all article involved by this component table and quantity required correspondence thereof are saved in described interim tablet menu;
Merge the quantity required of article corresponding to same names in described interim tablet menu, using the article in this interim tablet menu as described demand article, the quantity required of its correspondence is as the quantity required of these demand article.
Further, a part is had at least to preserve with the form of Bill of Material (BOM) in the article involved by described source of demand;
The method of the quantity required of all demand article then involved by the described source of demand of described acquisition and each described demand article is:
The article do not preserved with the form of Bill of Material (BOM) involved by described source of demand and quantity required correspondence thereof are saved in interim tablet menu; The article all involved by described source of demand preserved with the form of Bill of Material (BOM) and his father's item article all successively launch completely according to its Bill of Material (BOM), all article involved by this Bill of Material (BOM) and quantity required correspondence thereof are saved in described interim tablet menu;
By with all article preserved using the form of Bill of Material (BOM) involved by described source of demand as subitem article the outer order of production order and committee involved by article and the equal correspondence of quantity required be saved in described interim tablet menu;
Merge the quantity required of article corresponding to same names in described interim tablet menu, using the article in this interim tablet menu as described demand article, the quantity required of its correspondence is as the quantity required of these demand article.
Further, the method obtaining the static available quantity of each article is: be saved in by the static available quantity of each described article in the first form temporarily set up; Then
After the static available quantity of each article of described acquisition, carry out the quantity required of offset and this article described demand article of the same name at the described static available quantity with each described article before, also comprise: the quantity required of described demand article and each described demand article is saved in the second form temporarily set up;
The method of carrying out the quantity required of offset and this article described demand article of the same name with the static available quantity of each described article is the quantity required carrying out the described demand article of the same name with these article of the second table storage described in offset with the static available quantity of each described article of described first table storage, and the result obtained is saved in the 3rd form temporarily set up; Described result comprises: the suggested quantity after article and each article offset;
The method that result carries out showing as the suggestion of described material requirement is: show the article of described 3rd table storage and the described suggested quantity of each described article.
Further, before obtaining the quantity required of all demand article involved by described source of demand and each described demand article, also comprise: obtain the source document types involved by described source of demand;
Carry out the quantity required of offset and this article described demand article of the same name with the static available quantity of each described article before, also comprise: determine obtaining the source document types involved by each described program element before described source of demand;
The method then carrying out the quantity required of the offset described demand article of the same name with these article with the static available quantity of each described article is: the quantity required first coming offset and this article described demand article of the same name with the static available quantity of the identical each described article of source document types, then carrys out the quantity required of offset and this article described demand article of the same name with the static available quantity of the different each described article of source document types.
Accompanying drawing explanation
Fig. 1 is the process flow diagram of the present invention's specific embodiment.
Embodiment
Be described principle of the present invention and feature below in conjunction with accompanying drawing, example, only for explaining the present invention, is not intended to limit scope of the present invention.
The present invention proposes the formulating method of a kind of material requirement suggestion, the method sets up at MPS, sales order, namely when the available stock quantity of the stockpile number of each article (i.e. material), each article involved by each program element is known, when what need to enable when revising MPS, sales order or manual amendment MPS.Here program element comprises: produce suggestion, purchasing recommendation, advise outside committee, the production schedule, procurement plan, production order, purchase order, outside committee in order more than one.
Fig. 1 is the process flow diagram of the present invention's specific embodiment.As shown in Figure 1, the method that this embodiment proposes comprises:
Step 1: obtain source of demand, this source of demand is more than one or Contingency plans in up-to-date MPS and up-to-date sales order.
Here source of demand refers to the Suitable content that will carry out existing MRP, is specially any one in following four kinds of situations: the first situation is up-to-date MPS; The second situation is up-to-date sales order; The third situation comprises up-to-date MPS and up-to-date sales order simultaneously; 4th kind of situation is then Contingency plans.Here up-to-date MPS obtains by modifying to MPS, Contingency plans are obtained by manual amendment (namely temporarily revise) MPS, sales order etc., and up-to-date sales order is sales order by revising or insert renewal and obtains.
The source of demand that this step obtains can be preserved in table form, and this form can be called source of demand table in the present invention.Table 1-3 is respectively an embodiment of source of demand table corresponding to up-to-date MPS, Contingency plans and up-to-date sales order.
Table 1
| Field | Explanation |
| Source of demand type | MPS |
| Demand document ID | The capable ID of MPS |
| Article ID | Article ID |
| Article unit | Basic unit |
| Date Required | The scheduled completion date of MPS |
| Document quantity (A) | The quantity of MPS |
| Quantity performed (B) | The amount of warehouse-in of MPS |
| Amount (C) in short supply | A-B |
Table 2
| Field | Explanation |
| Source of demand type | SO |
| Demand document ID | The capable ID of sales order |
| Article ID | Article ID |
| Article unit | Basic unit |
| Date Required | A pre-date |
| Document quantity (A) | The amount on order of sales order |
| Quantity performed (B) | Sales order adds up outbound total amount |
| Amount (C) in short supply | A-B |
Table 3
| Field | Explanation |
| Source of demand type | MANU |
| Demand document ID | Empty |
| Article ID | Article ID |
| Article unit | Basic unit |
| Date Required | Scheduled completion date |
| Document quantity (A) | The quantity of manual input |
| Quantity performed (B) | 0 |
| Amount (C) in short supply | A-B |
The source of demand table that up-to-date MPS, Contingency plans and up-to-date sales order are corresponding can also have other forms, as long as it can reflect that article involved by source of demand and quantity thereof are namely within protection scope of the present invention, do not repeat them here.
Step 2: all demand article of acquisition involved by source of demand and the quantity required of each demand article.
The source of demand that step 1 obtains, must comprise certain Item Information, and the quantity information of these article, and this all reflects the demand such as increase, deletion, amendment of this source of demand to respective articles.Such as, when MPS requires to produce N part A product, and when having at present a demand of volume increase 100 A products, will change MPS, thus obtain up-to-date MPS as source of demand, step 1 is after obtaining this source of demand, and this step will obtain article (A product) involved by this source of demand and final quantity (N+100 part) thereof.
Demand article in this step not only comprise from the direct article (A product described above) of source of demand and varied number thereof (described above increase by 100), also comprise the relative article at different levels such as father's item article, subitem article that article direct to this are relevant, as in the above example, produce the starting material B needed for A product and starting material C, manufacture the starting material D needed for starting material B, and utilizing the product E etc. of A product manufacturing, these are all the demand article involved by source of demand.
This step can automatically perform.
Step 3: the static available quantity obtaining each article, static available quantity comprises: the stockpile number of each article, obtain the available stock quantity of each article involved by each program element before source of demand; Program element comprises: produce suggestion, purchasing recommendation, advise outside committee, the production schedule, procurement plan, production order, purchase order, outside committee in order more than one.
When setting up at MPS, sales order, this manufacturing enterprise for the production of and the available stock quantity of each article of producing involved by the stockpile number of each article obtained, each program element be known, which constitute the static available quantity described in this step.
The static available quantity that this step obtains, form can be adopted to preserve, and this form is called static available scale in the present invention.Table 4-12 is stockpile number, produce outside suggestion, purchasing recommendation, committee advise, the production schedule, procurement plan, production order, purchase order, the available scale of static state outside committee corresponding to order embodiment.
Table 4
| Field | Explanation |
| Available quantity type | STK |
| Document ID | Empty |
| Article ID | The ID of article |
| Article unit | Basic unit |
| Start Date | Empty |
| The supply of material date | Empty |
| Initial available quantity (A) | Storage on hand+workshop tank farm stock |
| Consumption (B) | According to optimum configurations, write safety stock |
| Non-consumption (C) | A-B |
| Homology occupancy (X) | 0 |
| Homology available quantity (Y) | C-X |
| Other occupancies (D) | 0 |
| This suggestion amount (E) | 0 |
| Available quantity (F) | C |
| The single type in corresponding source | Empty |
| The single ID in corresponding source | Empty |
| Initial source list type | Empty |
| Initial source list ID | Empty |
| MRP calculation flag | 0: do not calculate |
Table 5
| Field | Explanation |
| Available quantity type | MSS |
| Document ID | Produce the ID of suggestion |
| Article ID | Article ID |
| Article unit | Basic unit |
| Start Date | Advise starting date |
| The supply of material date | Recommended completion date |
| Initial available quantity (A) | Suggestion turnout |
| Consumption (B) | Generate the amount of producing order and the production schedule |
| Non-consumption (C) | A-B |
| Homology occupancy (X) | 0 |
| Homology available quantity (Y) | C-X |
| Other occupancies (D) | 0 |
| This suggestion amount (E) | 0 |
| Available quantity (F) | C |
| The single type in corresponding source | Produce the single type in the upper corresponding source of suggestion |
| The single ID in corresponding source | Produce the single ID in the upper corresponding source of suggestion |
| Initial source list type | Empty |
| Initial source list ID | Empty |
| MRP calculation flag | 1: to be calculated |
Table 6
| Field | Explanation |
| Available quantity type | PSS |
| Document ID | The ID of purchasing recommendation |
| Article ID | Article ID |
| Article unit | Basic unit |
| Start Date | The suggestion buying date |
| The supply of material date | Estimate arrival date |
| Initial available quantity (A) | Suggestion amount of purchase |
| Consumption (B) | Generate the amount of purchase order and procurement plan |
| Non-consumption (C) | A-B |
| Homology occupancy (X) | 0 |
| Homology available quantity (Y) | C-X |
| Other occupancies (D) | 0 |
| This suggestion amount (E) | 0 |
| Available quantity (F) | C |
| The single type in corresponding source | The single type in source corresponding in purchasing recommendation |
| The single ID in corresponding source | The single ID in source corresponding in purchasing recommendation |
| Initial source list type | Empty |
| Initial source list ID | Empty |
| MRP calculation flag | 0: do not calculate |
Table 7
| Field | Explanation |
| Available quantity type | ESS |
| Document ID | The ID of the outer suggestion of committee |
| Article ID | Article ID |
| Article unit | Basic unit |
| Start Date | Plan starting date |
| The supply of material date | Plan arrival date |
| Initial available quantity (A) | The outer amount of suggestion committee |
| Consumption (B) | Generate the outer order volume of committee |
| Non-consumption (C) | A-B |
| Homology occupancy (X) | 0 |
| Homology available quantity (Y) | C-X |
| Other occupancies (D) | 0 |
| This suggestion amount (E) | 0 |
| Available quantity (F) | C |
| The single type in corresponding source | The single type in the upper corresponding source of the outer suggestion of committee |
| The single ID in corresponding source | The single ID in the upper corresponding source of the outer suggestion of committee |
| Initial source list type | Empty |
| Initial source list ID | Empty |
| MRP calculation flag | 1: to be calculated |
Table 8
| Field | Explanation |
| Available quantity type | MP |
| Document ID | The ID of the production schedule |
| Article ID | Article ID |
| Article unit | Basic unit |
| Start Date | Plan starting date |
| The supply of material date | Estimated date of completion |
| Initial available quantity (A) | Planned production amount |
| Consumption (B) | Generate production order volume |
| Non-consumption (C) | A-B |
| Homology occupancy (X) | 0 |
| Homology available quantity (Y) | C-X |
| Other occupancies (D) | 0 |
| This suggestion amount (E) | 0 |
| Available quantity (F) | C |
| The single type in corresponding source | The single type in source in the production schedule |
| The single ID in corresponding source | The single ID in source in the production schedule |
| Initial source list type | Empty |
| Initial source list ID | Empty |
| MRP calculation flag | 1: to be calculated |
Table 9
| Field | Explanation |
| Available quantity type | PL |
| Document ID | The ID of procurement plan |
| Article ID | Article ID |
| Article unit | Basic unit |
| Start Date | Ps |
| The supply of material date | Estimate arrival date |
| Initial available quantity (A) | Scheduled purchasing amount |
| Consumption (B) | Generate purchase order amount |
| Non-consumption (C) | A-B |
| Homology occupancy (X) | 0 |
| Homology available quantity (Y) | C-X |
| Other occupancies (D) | 0 |
| This suggestion amount (E) | 0 |
| Available quantity (F) | C |
| The single type in corresponding source | The single type in source in procurement plan |
| The single ID in corresponding source | The single ID in source in procurement plan |
| Initial source list type | Empty |
| Initial source list ID | Empty |
| MRP calculation flag | 0: do not calculate |
Table 10
| Field | Explanation |
| Available quantity type | MO |
| Document ID | Produce the ID of order |
| Article ID | The ID of article |
| Article unit | Basic unit |
| Start Date | Produce the Start Date of order |
| The supply of material date | Produce the estimated date of completion of order |
| Initial available quantity (A) | Produce the turnout on order |
| Consumption (B) | Accumulative completion amount |
| Non-consumption (C) | A-B |
| Homology occupancy (X) | 0 |
| Homology available quantity (Y) | C-X |
| Other occupancies (D) | -(qualified quantity-warehousing quantity) |
| This suggestion amount (E) | 0 |
| Available quantity (F) | C-D |
| The single type in corresponding source | Produce the single type in the source that order records |
| The single ID in corresponding source | Produce the single ID in the source that order records |
| Initial source list type | Empty |
| Initial source list ID | Empty |
| MRP calculation flag | 1: to be calculated |
Table 11
| Field | Explanation |
| Available quantity type | PO |
| Document ID | The ID that purchase order is capable |
| Article ID | The ID of article |
| Article unit | Basic unit |
| Start Date | Empty |
| The supply of material date | The expectation arrival date of purchase order |
| Initial available quantity (A) | Order total amount on purchase order |
| Consumption (B) | The accumulative warehouse-in amount of purchase order |
| Non-consumption (C) | A-B |
| Homology occupancy (X) | 0 |
| Homology available quantity (Y) | C-X |
| Other occupancies (D) | 0 |
| This suggestion amount (E) | 0 |
| Available quantity (F) | C |
| The single type in corresponding source | The single type in source on purchase order |
| The single ID in corresponding source | The single ID in source on purchase order |
| Initial source list type | Empty |
| Initial source list ID | Empty |
| MRP calculation flag | 0: do not calculate |
Table 12
| Field | Explanation |
| Available quantity type | EO |
| Document ID | Entrust the ID of outer order |
| Article ID | The ID of article |
| Article unit | Basic unit |
| Start Date | Entrust plan on-stream time of outer order |
| The supply of material date | To entrust the expectation arrival date of outer order |
| Initial available quantity (A) | The order total amount of entrusting on outer order |
| Consumption (B) | To entrust the accumulative warehouse-in amount of outer order |
| Non-consumption (C) | A-B |
| Homology occupancy (X) | 0 |
| Homology available quantity (Y) | C-X |
| Other occupancies (D) | 0 |
| This suggestion amount (E) | 0 |
| Available quantity (F) | C |
| The single type in corresponding source | The single type in the corresponding source of entrusting on outer order |
| The single ID in corresponding source | The single ID in the corresponding source of entrusting on outer order |
| Initial source list type | Empty |
| Initial source list ID | Empty |
| MRP calculation flag | 1: to be calculated |
Certainly, static available scale can also have other embodiments, as long as can record the static available quantity of each article, namely within protection scope of the present invention, does not repeat them here.
Utilize electronic technology, this step can automatically perform, and relative to the hand computation of prior art, the workload of this step greatly reduces, thus ensure that the promptness that MRP adjusts.
Step 4: the quantity required coming offset and this article demand article of the same name with the static available quantity of each article, its result shows as material requirement suggestion.
The static available quantity of each article that step 3 obtains is the quantity that current production is using, the quantity required of the demand article that step 2 obtains, quantity then for modifying to static available quantity (comprise increase, delete or change), this step static available quantity of each article carrys out the quantity required of offset and this article demand article of the same name, the suggested quantity of each article after the impact considering source of demand can be obtained, thus obtain final material requirement suggestion.
As can be seen here, in the present invention, after acquisition source of demand, demand article involved by further acquisition source of demand and quantity required thereof, then the static available quantity of each article is obtained, so just can carry out the quantity required of offset article of the same name with the static available quantity of each article, thus obtain the suggested quantity of each article, these work all can realize automatically.Because source of demand covers the change of up-to-date MPS, Contingency plans and these three kinds of demands of up-to-date sales order, static available quantity covers the available stock quantity of the stockpile number of article and the article involved by various program element, thus the present invention can when arbitrary demand changes, adjust the quantity required of each demand article quickly and accurately, obtain the suggestion of corresponding material requirement, thus help enterprise is timely, arranged rational is produced, and guarantees the realization of MRP target.
It is to be noted, the sequence number 1,2,3 and 4 of each step in Fig. 1 embodiment, be the needs of each technical characteristic of the present invention for convenience of description, from the sequencing that each step performs, step 1 performs before step 2, step 4 finally performs, and the execution time of step 3 is comparatively free, such as, can perform before step 4 after step 2 as shown in Figure 1, also synchronously can perform with step 1, or synchronously perform with step 2.Visible, from the angle of each step execution sequence, what Fig. 1 showed is only a specific embodiment of the present invention, and the present invention can also have other specific embodiment, also all within protection scope of the present invention.
Production is free concept, and enterprise arranges production, is namely the day output of the starting material use amount of every day, product all to be arranged properly, thus accomplishes the supply according to plan of cleer and peaceful product of raw-material day.Therefore, the present invention also relates to the concept of progress, as fields such as " Start Dates ", " supply of material date " in " Date Required " field in table 1-3, table 4-12, is namely the embodiment to progress concept.
In MRP, having certain contact between multiple articles, as utilized starting material B and C to produce A product, is then the association having upstream and downstream between B, C and A, the form of this relation available material inventory (Bill of Materials, BOM) stores.
Due to mostly relevant between article, thus after step 1 obtains source of demand, except the article that will relate to source of demand and quantity thereof change, the change that also will link to the article associated by these article and quantity thereof, thus intactly reflect that source of demand is on the impact of MRP.The invention provides the two schemes of demand article in obtaining step 2 and quantity required thereof, one is called that total system obtains scheme, and another kind is called that slotting menu obtains scheme, and this two schemes is specific as follows:
(1) total system obtains scheme:
If in the article involved by source of demand that step 1 obtains, a part is had at least to preserve with the form of Bill of Material (BOM); Production suggestion before step 1 obtains source of demand, the outer suggestion of committee, article involved by the production schedule are also preserved with the form of Bill of Material (BOM); Step 1 obtain source of demand before production order, committee outer order preserve with the form of component table; The method that then step 2 obtains the quantity required of all demand article involved by source of demand and each demand article comprises:
Step 201: the article do not preserved with the form of Bill of Material (BOM) involved by source of demand and quantity required correspondence thereof are saved in interim tablet menu; All article preserved with the form of Bill of Material (BOM) involved by source of demand are successively launched completely according to its Bill of Material (BOM), all article involved by this Bill of Material (BOM) and quantity required correspondence thereof are saved in interim tablet menu.
The demand article of step 2 acquisition and the quantity required of each article in table form correspondence are kept in interim tablet menu here.
In article involved by source of demand, if having not with the article that the form of Bill of Material (BOM) is preserved, be then saved in interim tablet menu by these article and the direct correspondence of quantity required thereof, these article are as a part for demand article, and its quantity is as the quantity required of correspondence.
And in the article involved by source of demand with the article preserved with the form of Bill of Material (BOM), then after being pressed Bill of Material (BOM) expansion, be saved in interim tablet menu by all article involved by Bill of Material (BOM) and quantity required correspondence thereof, these article are also as a part for demand article.
Step 202: the article involved by the production obtained before source of demand suggestion, the outer suggestion of committee, the production schedule are all successively launched according to its Bill of Material (BOM), all article involved by this Bill of Material (BOM) and quantity required correspondence thereof are saved in interim tablet menu; The production order obtained before source of demand, the outer order of committee are successively launched according to its component table, all article involved by this component table and quantity required correspondence thereof are saved in interim tablet menu.
In this programme, step 1 obtain source of demand before production suggestion, the outer suggestion of committee, article place involved by the production schedule Bill of Material (BOM) in article, and all article produced in order, committee's component table of relating to of outer order, also be all a part for demand article, also these article and quantity required correspondence thereof should be saved in interim tablet menu.
Step 203: merge the quantity required of article corresponding to same names in interim tablet menu, using the article in this interim tablet menu as demand article, the quantity required of its correspondence is as the quantity required of these demand article.
The article that step 201 and 202 is deposited in interim tablet menu have duplication of name phenomenon unavoidably, namely for same article (corresponding quantity required is not necessarily identical), step 201 and step 202 all have and relate to, thus this step will merge the quantity required of the article of same names in interim tablet menu, to simplify the structure of interim tablet menu.
After having merged, the article in interim tablet menu are the demand article that step 2 will obtain, and the quantity required of its correspondence is the quantity required of these demand article that step 2 will obtain.This programme terminates.
It is pointed out that the angle from execution sequence, above-mentioned step 201 and 202 can synchronously perform, also can one first after one, and as step 201 performs prior to step 202, certainly, step 201 also can perform after step 202; But the execution time of step 203 the latest, namely perform after step 201 and step 202.
(2) insert menu and obtain scheme:
If have at least a part to preserve with the form of Bill of Material (BOM) in the article involved by source of demand that step 1 obtains; The method that then step 2 obtains the quantity required of all demand article involved by source of demand and each demand article comprises:
Step 211: the article do not preserved with the form of Bill of Material (BOM) involved by source of demand and quantity required correspondence thereof are saved in interim tablet menu; The article all involved by source of demand preserved with the form of Bill of Material (BOM) and his father's item article all successively launch completely according to its Bill of Material (BOM), all article involved by this Bill of Material (BOM) and quantity required correspondence thereof are saved in interim tablet menu.
To obtain scheme identical with total system, and this programme is also preserve demand article and quantity required thereof with interim tablet menu.For involved by source of demand not with the article that the form of Bill of Material (BOM) is preserved.This programme is also the part that it can be used as demand article, correspondingly with its quantity required is saved in interim tablet menu.
With total system obtain protocol step 201 unlike, for the article preserved with the form of Bill of Material (BOM) that source of demand relates to, article in father's item article place Bill of Material (BOM) of these article and corresponding quantity required also correspondence, except the article in its Bill of Material (BOM) and corresponding quantity required correspondence being saved in except in interim tablet menu, are also saved in interim tablet menu by this step.
Step 212: by with all article preserved using the form of Bill of Material (BOM) involved by source of demand as subitem article the outer order of production order and committee involved by article and the equal correspondence of quantity required be saved in interim tablet menu.
The article scope that this step is preserved is more much smaller than step 202.
Step 213: merge the quantity required of article corresponding to same names in interim tablet menu, using the article in this interim tablet menu as demand article, the quantity required of its correspondence is as the quantity required of these demand article.
Similar with step 203, this step is also the step that the quantity required of counterweight name article carries out merging.This step is finished, and the program terminates.
Equally, step 213 here performs the latest, namely performs after step 211 and step 212; Step 211 and step 212 then can synchronously perform, and also can perform after one first one, as step 211 performs early than step 212, or conversely, step 212 performs early than step 211.
Visible, the demand article that above-mentioned two schemes obtains and quantity required thereof are very different, and this offset result of calculation for step 4 can affect greatly, and the material requirement suggestion thus utilizing two schemes to obtain is completely different.
In order to improve the operation efficiency of step 4, and prevent from offset computing from aligning the MPS be in operation impacting, in step 3 of the present invention, the method obtaining the static available quantity of each article can be: be saved in by the static available quantity of each article in the first form temporarily set up, namely the static available quantity of each article is extracted in the first provisional form, so just can play the effect of isolated data.
After step 3 obtains the static available quantity of each article, to carry out the quantity required of offset and this article demand article of the same name with the static available quantity of each article in step 4 before, step 304 can also be comprised: be saved in the second form temporarily set up by the quantity required of demand article and each demand article, play the effect of isolated data further.
Corresponding to the different source of demand that step 1 obtains, the second form that step 304 obtains can have different forms.Table 13-15 is respectively up-to-date MPS, Contingency plans and the up-to-date sales order embodiment as the second form during source of demand.
Table 13
Table 14
Table 15
| Field | Explanation |
| Available quantity type | " self-control/buying/committee is outer " attribute according to article is filled in, self-made components write MS, |
| ? | Purchased Item write PS, committee outer member write ES |
| Document ID | The interim ID of MRP suggestion |
| Article ID | The ID of article |
| Article unit | Basic unit |
| Start Date | 1 is added the time in advance of deducting article scheduled completion date |
| The supply of material date | Scheduled completion date |
| Initial available quantity (A) | Short supply amount in source of demand table |
| Consumption (B) | 0 |
| Non-consumption (C) | A-B |
| Homology occupancy (X) | 0 |
| Homology available quantity (Y) | C-X |
| Other occupancies (D) | 0 |
| This suggestion amount (E) | 0 |
| Available quantity (F) | C-D |
| The single type in corresponding source | MANU |
| The single ID in corresponding source | Empty |
| Initial source list type | MANU |
| Initial source list ID | Empty |
| MRP calculation flag | 1 |
Second form can also have other embodiment, and the present invention repeats no more.
On this basis, in step 4:
The method carrying out the quantity required of offset and this article demand article of the same name with the static available quantity of each article is: the quantity required carrying out the demand article of the same name with these article of offset second table storage with the static available quantity of each article of the first table storage, and the result obtained is saved in the 3rd form temporarily set up; Here obtained result comprises: the suggested quantity after article and each article offset;
The method that the result obtained in step 4 carries out showing as material requirement suggestion is: the display article of the 3rd table storage and the suggested quantity of each article.
In above-mentioned step 4, do not consider the offset order of different static available quantities, if with the whole static available quantity of each article come offset and this article demand article of the same name quantity required, all within protection scope of the present invention.This is one embodiment of the present of invention, and in fact, in order to improve offset quality, can also sort to the offset computing of the static available quantity of difference, the static available quantity meeting certain condition preferentially carries out offset.Such as, enterprise produces 1 A product needed and uses 1 starting material B and 1 starting material C, produces 1 X product needed and uses 2 starting material B, 2 starting material C and 1 starting material D; Original MPS is produce 100 A products every day, does not produce X product; And the source of demand that step 1 obtains is that the A product that every day produces is reduced to 50, produce X product 50 every day simultaneously; Like this, when step 4 carries out offset, preferentially will carry out offset to 50 starting material B and 50 starting material C involved by underproduction every day 50 A products, in the present invention, the foundation of its preferential offset can be source document types.
Based on above consideration, before the quantity required that step 2 obtains all demand article involved by source of demand and each demand article, preferably, can also comprise in step 1: obtain the source document types involved by source of demand;
To carry out the quantity required of offset and this article demand article of the same name with the static available quantity of each article in step 4 before, preferably, can also comprise in step 3: determine obtaining the source document types involved by each program element before source of demand;
Then in step 4, the method carrying out the quantity required of the offset demand article of the same name with these article with the static available quantity of each article is: the quantity required first coming offset and this article demand article of the same name with the static available quantity of the identical each article of source document types, then carrys out the quantity required of offset and this article demand article of the same name with the static available quantity of the different each article of source document types.
As can be seen here, the present invention has the following advantages:
(1) in the present invention, after acquisition source of demand, demand article involved by further acquisition source of demand and quantity required thereof, then the static available quantity of each article is obtained, the quantity required of offset article of the same name so just can be carried out with the static available quantity of each article, thus obtaining the suggested quantity of each article, these work all can realize automatically.Because source of demand covers the change of up-to-date MPS, Contingency plans and these three kinds of demands of up-to-date sales order, static available quantity covers the available stock quantity of the stockpile number of article and the article involved by various program element, thus the present invention can when arbitrary demand changes, adjust the quantity required of each demand article quickly and accurately, obtain the suggestion of corresponding material requirement, thus help enterprise is timely, arranged rational is produced, and guarantees the realization of MRP target.
(2) the static available quantity of each article is saved in the first form temporarily set up by the present invention, can play the effect of isolated data, thus improves operation efficiency, and prevents from offset computing from aligning the MPS be in operation impacting.
The foregoing is only preferred embodiment of the present invention, not in order to limit the present invention, within the spirit and principles in the present invention all, any amendment done, equivalent replacement, improvement etc., all should be included within protection scope of the present invention.
Claims (5)
1. a formulating method for material requirement suggestion, it is characterized in that, the method comprises:
Obtain source of demand, described source of demand is more than one or Contingency plans in up-to-date MPS and up-to-date sales order;
Obtain the quantity required of all demand article involved by described source of demand and each described demand article;
Obtain the static available quantity of each article, described static available quantity comprises: the stockpile number of each described article, obtain the available stock quantity of each described article involved by each program element before described source of demand; Described program element comprises: produce suggestion, purchasing recommendation, advise outside committee, the production schedule, procurement plan, production order, purchase order, outside committee in order more than one;
Carry out the quantity required of offset and this article described demand article of the same name with the static available quantity of each described article, its result shows as described material requirement suggestion.
2. method according to claim 1, is characterized in that, has at least a part to preserve with the form of Bill of Material (BOM) in the article involved by described source of demand; Obtain the production suggestion before described source of demand, the outer suggestion of committee, article involved by the production schedule preserve with the form of Bill of Material (BOM); Obtain the production order before described source of demand, the outer order of committee is preserved with the form of component table;
The method of the quantity required of all demand article then involved by the described source of demand of described acquisition and each described demand article is:
The article do not preserved with the form of Bill of Material (BOM) involved by described source of demand and quantity required correspondence thereof are saved in interim tablet menu; All article preserved with the form of Bill of Material (BOM) involved by described source of demand are successively launched completely according to its Bill of Material (BOM), all article involved by this Bill of Material (BOM) and quantity required correspondence thereof is saved in described interim tablet menu;
Article involved by the production obtained before described source of demand suggestion, the outer suggestion of committee, the production schedule are all successively launched according to its Bill of Material (BOM), all article involved by this Bill of Material (BOM) and quantity required correspondence thereof is saved in described interim tablet menu; The production order obtained before described source of demand, the outer order of committee are successively launched according to its component table, all article involved by this component table and quantity required correspondence thereof are saved in described interim tablet menu;
Merge the quantity required of article corresponding to same names in described interim tablet menu, using the article in this interim tablet menu as described demand article, the quantity required of its correspondence is as the quantity required of these demand article.
3. method according to claim 1, is characterized in that, has at least a part to preserve with the form of Bill of Material (BOM) in the article involved by described source of demand;
The method of the quantity required of all demand article then involved by the described source of demand of described acquisition and each described demand article is:
The article do not preserved with the form of Bill of Material (BOM) involved by described source of demand and quantity required correspondence thereof are saved in interim tablet menu; The article all involved by described source of demand preserved with the form of Bill of Material (BOM) and his father's item article all successively launch completely according to its Bill of Material (BOM), all article involved by this Bill of Material (BOM) and quantity required correspondence thereof are saved in described interim tablet menu;
By with all article preserved using the form of Bill of Material (BOM) involved by described source of demand as subitem article the outer order of production order and committee involved by article and the equal correspondence of quantity required be saved in described interim tablet menu;
Merge the quantity required of article corresponding to same names in described interim tablet menu, using the article in this interim tablet menu as described demand article, the quantity required of its correspondence is as the quantity required of these demand article.
4. method according to claim 1, is characterized in that, the method obtaining the static available quantity of each article is: be saved in by the static available quantity of each described article in the first form temporarily set up; Then
After the static available quantity of each article of described acquisition, carry out the quantity required of offset and this article described demand article of the same name at the described static available quantity with each described article before, also comprise: the quantity required of described demand article and each described demand article is saved in the second form temporarily set up;
The method of carrying out the quantity required of offset and this article described demand article of the same name with the static available quantity of each described article is the quantity required carrying out the described demand article of the same name with these article of the second table storage described in offset with the static available quantity of each described article of described first table storage, and the result obtained is saved in the 3rd form temporarily set up; Described result comprises: the suggested quantity after article and each article offset;
The method that result carries out showing as the suggestion of described material requirement is: show the article of described 3rd table storage and the described suggested quantity of each described article.
5. method according to claim 1, is characterized in that,
Before obtaining the quantity required of all demand article involved by described source of demand and each described demand article, also comprise: obtain the source document types involved by described source of demand;
Carry out the quantity required of offset and this article described demand article of the same name with the static available quantity of each described article before, also comprise: determine obtaining the source document types involved by each described program element before described source of demand;
The method then carrying out the quantity required of the offset described demand article of the same name with these article with the static available quantity of each described article is: the quantity required first coming offset and this article described demand article of the same name with the static available quantity of the identical each described article of source document types, then carrys out the quantity required of offset and this article described demand article of the same name with the static available quantity of the different each described article of source document types.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310282251.9A CN104281902A (en) | 2013-07-05 | 2013-07-05 | Material requirement suggestion making method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310282251.9A CN104281902A (en) | 2013-07-05 | 2013-07-05 | Material requirement suggestion making method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN104281902A true CN104281902A (en) | 2015-01-14 |
Family
ID=52256762
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201310282251.9A Pending CN104281902A (en) | 2013-07-05 | 2013-07-05 | Material requirement suggestion making method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104281902A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109377055A (en) * | 2018-10-25 | 2019-02-22 | 金蝶软件（中国）有限公司 | A kind of method and device of business paper adjustment |
| CN113487134A (en) * | 2021-06-07 | 2021-10-08 | 石化盈科信息技术有限责任公司 | Material supply and demand tracking method and system, storage medium and electronic equipment |
| CN113592170A (en) * | 2021-07-26 | 2021-11-02 | 苏州大学文正学院 | APS planning method and system for project type ERP system |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20040117048A1 (en) * | 2002-12-13 | 2004-06-17 | Hung-Shan Wei | Master production scheduling management system and method |
| CN102063662A (en) * | 2010-12-30 | 2011-05-18 | 用友软件股份有限公司 | Replenishment need generation method and device |
| CN102254240A (en) * | 2011-06-03 | 2011-11-23 | 用友软件股份有限公司 | Data object substitution device and data object substitution method |
| CN102354316A (en) * | 2011-09-22 | 2012-02-15 | 用友软件股份有限公司 | Data updating device and data updating method |
| CN102567826A (en) * | 2010-12-20 | 2012-07-11 | 金蝶软件（中国）有限公司 | Method and system for processing material bills |
-
2013
- 2013-07-05 CN CN201310282251.9A patent/CN104281902A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20040117048A1 (en) * | 2002-12-13 | 2004-06-17 | Hung-Shan Wei | Master production scheduling management system and method |
| CN102567826A (en) * | 2010-12-20 | 2012-07-11 | 金蝶软件（中国）有限公司 | Method and system for processing material bills |
| CN102063662A (en) * | 2010-12-30 | 2011-05-18 | 用友软件股份有限公司 | Replenishment need generation method and device |
| CN102254240A (en) * | 2011-06-03 | 2011-11-23 | 用友软件股份有限公司 | Data object substitution device and data object substitution method |
| CN102354316A (en) * | 2011-09-22 | 2012-02-15 | 用友软件股份有限公司 | Data updating device and data updating method |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109377055A (en) * | 2018-10-25 | 2019-02-22 | 金蝶软件（中国）有限公司 | A kind of method and device of business paper adjustment |
| CN113487134A (en) * | 2021-06-07 | 2021-10-08 | 石化盈科信息技术有限责任公司 | Material supply and demand tracking method and system, storage medium and electronic equipment |
| CN113592170A (en) * | 2021-07-26 | 2021-11-02 | 苏州大学文正学院 | APS planning method and system for project type ERP system |
| CN113592170B (en) * | 2021-07-26 | 2023-08-08 | 苏州大学文正学院 | APS planning method and system for project-oriented ERP system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101859405A (en) | Method for synchronizing data between BOMs by utilizing implicit BOM model | |
| US20070219656A1 (en) | Modeling manufacturing processes to include defined markers | |
| CN107358415B (en) | SAP outsourcing lower-order material purchasing and control method | |
| JPH0430953A (en) | Manufacturing/purchasing control process | |
| KR102345145B1 (en) | Production and logistics ERP automation system by linking and using customer information | |
| JP2012088784A (en) | Production control system, production control method, and program | |
| CN104281902A (en) | Material requirement suggestion making method | |
| US7123977B2 (en) | Production planning system | |
| Nobil et al. | Optimal and simple algorithms to solve integrated procurement-production-inventory problem without/with shortage | |
| CN104778542A (en) | Rapid quality design system and method based on history order modeling | |
| US6856857B2 (en) | Method and system for planning disassembly and production of recyclable products and for planning procurement of parts for production | |
| CN101510277A (en) | Method for rolling computation of material requirement in production management process | |
| JP2007128225A (en) | Information formation device | |
| TW594528B (en) | System and method for rescheduling purchase order | |
| CN105654265A (en) | Material distribution list generation method and device of current procedure in mold production plan | |
| Stekolschik | Engineering change management method framework in mechanical engineering | |
| CN109214630A (en) | Mid-term production plan method, apparatus and system | |
| CN106909992B (en) | Split charging production method and device of multi-variety small-batch mixed flow assembly line | |
| CN102184482A (en) | Realization method for synchronizing data between BOM (Bill Of Material) by implicit technical BOM model | |
| CN111815148B (en) | Scheduling method, scheduling device, electronic equipment and computer readable storage medium | |
| JP2013182348A (en) | Production plan creation device, production plan creation system, and production plan creation program | |
| Sivashankari et al. | Production inventory model with defective items and integrates cost reduction delivery policy | |
| US20070043601A1 (en) | Supply chain linkage management system | |
| Riezebos | Shop floor planning and control in team-based work processes | |
| Raj et al. | A production inventory model with exponential demand rate and reverse logistic |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20150114 |