MRP system with viewable master production schedule

• US 6,119,102 A
• Filed: 01/24/1997
• Issued: 09/12/2000
• Est. Priority Date: 04/15/1996
• Status: Expired due to Term

• Current Assignee: Aptean, Inc. (Aptean Superior Holdings, Inc.)
• Original Assignee: Made2Manage Systems Incorporated (Aptean Superior Holdings, Inc.)
• Inventors: Rush, Gary W., Kiefus, Herman J.
• Primary Examiner(s): Weinhardt, Robert A.
• Application Number:
  US08/787,253
• Time in Patent Office: 1,327 Days
• Field of Search: 364/468.05, 364/468.06, 364/468.13, 364/468.14, 705/7, 705/8, 705/29, 700/99, 700/100, 700/106, 700/107
• US Class Current: 705/29
• CPC Class Codes: G06Q 10/06 Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
• CPC Class Codes: G06Q 10/0875 Itemisation or classification of parts, supplies or services, e.g. bill of materials

Abstract

An MRP system that operates on a single data set containing records for all item demands and supplies. The file may be opened under a demand alias and a supply alias to expedite MRP regeneration. A second item master extension file includes data for each item which is subject to MRP, which further contributes to improved MRP regeneration time. Item low level codes for an item are recalculated in real time whenever a bill of material referencing the item is created or modified. Therefore, low level codes need not be calculated during MRP regeneration.

Claims

1. An improved MRP system comprising:

at least one item demand data set;

at least one item supply data set;

means for generating a Master Production Schedule ("MPS"), the means for generating being operable to perform the step of;

creating an MPS data set comprising data from the item demand and item supply data sets; and

wherein each such MPS data set record includes data indicating;

an item identifier;

a quantity;

a transaction time period; and

a "pass-through flag" which is set for those item supply records for which there is no independent demand in the MPS file for the same item;

such that the means for generating ensures that the MPS data set includes item supply information for items for which there is no independent demand;

means for viewing data in the records in the MPS data set for which the pass-through flag has not been set prior to performing materials requirement planning ("MRP");

means for performing time phased MRP netting on the MPS data set to thereby generate MRP action messages; and

such that means for generating ensures that it is unnecessary for such MRP netting means to access data from the item supply data set.

2. The MRP system of claim 1 further comprising:

an item data set wherein each record is uniquely identified by an item identifier, and wherein the item data set further comprises a low level code associated with each unique item identifier on which MRP is to be performed.

3. The MRP system of claim 2 further comprising:

a second item data set wherein each record is uniquely identified by an item identifier, and

wherein each record stores non-MRP data for the item, and

further comprising means for browsing item records in the second item data set.

4. The MRP system of claim 3 further comprising:

at least one bill of material data set defining parent-child relationships among items to thereby define a plurality of bills of material for items; and

wherein the first item data set comprises, for each item record in the file, a single low level code for the item.

5. The MRP system of claim 1 further comprising:

a first item data set wherein each record is uniquely identified by an item identifier, and

a second item data set wherein each record is uniquely identified by an item identifier, and wherein each record stores non-MRP data for the item, and,

means for browsing item records in the second item data set.

6. The MPS system of claim 1 wherein:

the step for creating the MPS data set comprising information from item demand and supply information further comprises the steps of;

inserting all demand records into the MPS data set before inserting supply records into the MPS data set.

7. The MPS system of claim 6 wherein each item identifier is the subject of a supply record, and wherein the need for setting the pass-through flag for a particular supply record in the MPS data set is determined by the means for generating a Master Production Schedule by performing a seek operation to ascertain whether any record for the item identifier which is the subject of the supply record already exists as a demand in the MPS table.

8. The improved MPS system of claim 1 wherein the MPS data set records for which the source of the supply or demand is a sales order, job order, purchase order document, further comprises a reference uniquely identifying the sales order, job order or purchase order document.