5.1.1
5.1.1 Define the Part Number Size
Prior to entering part numbers, the size and configuration of the part number must be defined using pc/MRP's Configuration Menu. pc/MRP's part numbers can be numeric and/or alphanumeric.
Part number size - pc/MRP's configuration menu, option 28, allows the part number size to be set from 6 to 15 characters, see section 15.1.28 in this manual.
Part number prefix size - pc/MRP's configuration menu, option 29, allows the first X characters of the part number (including any dash) to be set as a prefix (product code), see section 15.1.29 in this manual.
Part number suffix size - pc/MRP's configuration menu, options 48 and 49 allow the last X characters of the part number (including any dashes) to be set as a suffix, see section 15.1.48 and 15.1.49 in this manual.
Below are some additional ideas to think about if you are free to define the part number size and structure:
A straight non-encoded numeric part numbering scheme could be employed. It is easier to maintain and expand a stock room with a non-encoded numeric part numbering system. However, with this method it is not easy to find part numbers by scrolling the partmaster file.
Encoding the first two or three characters of the part number as a product code will allow scrolling to start in the product code area the part was assigned to. The size of the product code can be set on the second page of pc/MRP's Configuration Module.
Large part number structures slow down data input and lead to data input errors. Supermarkets do not trust people to put in $6.99 let alone an 18 character part number. In addition, large part number structures could make it difficult to switch over to bar-coding in the future.
Alphanumeric part number structures can lead to errors due to upper and lower case letters and 0's versus O's.
Companies selling to retail markets would do well to consider using a 9 or 10 digit numeric part number system to match retail UPC bar coding structures. Many retailers request their products be shipped with UPC bar code labels.
An eight character part number structure could be optimal for companies that plan to use Auto Cad to generate and store their drawings.
Companies dealing with consignment parts should read the chapter in section 15.10.5 which covers part numbering schemes (methods) for companies who carry a large number of consignment parts.
pc/MRP defaults to a 9 character part number size and a 2 character product code size unless modified by the user in the Configuration Menu.
5.1.2 Enter A New Part Number
Selecting New allows you to enter a new part into the Partmaster Database File. Select N if you want the next available part number displayed. pc/MRP will display the next available part number provided all of the part numbers previously entered contain only numeric characters. If the prior part numbers contain on alpha character, pc/MRP will not know how to increment the number and will display "00000001" as the next available number. Select P if you want the next available part number for a product code displayed. pc/MRP will display the next available number for either, provided any alpha characters in the part number are all contained in the product code portion of the part number.
The following paragraphs describe the fields and buttons used in the inventory enter and edit screen shown above.
The Alternate Part Button opens an auxilary window which allows the association of six alternate part numbers (altpart1 - altpart6) for each primary part number. Option 54 in pc/MRP's configuration settings and utilities menu will set the alternate partnumbers in the partmaster to update or not update the alternate partnumbers in the BOM file.
The Dwg Size/# allow referencing to a partnumber's drawing number (drawingno) and drawing size (drawsize).
The Description (descript) should be such that similar items appear together in any report sorted by description. For example, the descriptions, "WIRE,BLUE" and "WIRE,RED" will allow all WIRE to be listed under WIRE.
Pressing the Elipse ... Button will allow the user to select a pre-defined description. The predefined descriptions can be created using pc/MRP's configuration settings and utilities option 58. Predefined descriptions can be used to keep part descriptions uniform and in alphabetical order next to each other when printing out a parts list sorted by description.
The Rev (revlevel) contains the current revision level of the part or assembly, i.e. A, B, C etc. If the part or assembly is changed such that it is still backwards compatible roll the Rev. If the part or assembly is not backwards compatible, change the partnumber. pc/MRP's ECN module will automatically increment the revision level for a partnumber whenever a new ECN is created for that partnumber.
The Start Date (startdate) references to the date the part was first entered into the Part Master.
The Memo Field (altpartno) is sort of a wild card field. It can be used to store information such as purchasing specifications, additional description, alternate part numbers, etc. Option 22 in pc/MRP's configuration settings and utilities menu can be set to automatically import the contents of this field into sales and purchase order comments field.
The Manufacturers (modelno,mfg2-mfg9) and Model Numbers (modelno,modelno2-modelno9) are self-explanatory. Manufacturer's part numbers can be entered into their respective model number fields. Three manufacturers and model numbers are displayed on the primary data screen.
Pressing the More Manufact/Models button will allow the user to enter up to six additional manufacturers and model numbers.
The Vendor Lookup (id1-id3) allows you to enter vendor(s) from the address book for each part. Click on the "Vendor Lookup" check box and enter the first few characters of the Vendor Name, Phone Number, or ID Number. Press the "Enter" key and the address book will appear from which you may select the vendor desired. The Vendor Name, Phone Number, and ID Number will then be automatically filled in.
An Alt Currency drop-down list box is available with pc/MRP versions 6.82 and higher for users who have purchased the optional Alternate Currency module. The user can then display the cost and pricing information in any of the alternate currencies.
The Std Cost/Unit (stdcost) field contains the list cost of the part. If your company's accounting department is using standard costs to value inventory, standard costs should only be entered and changed with the permission of the accounting department.
The Ave Cost/Unit (cost) contains the average cost per unit. The value in this field is recalculated every time a receiver is entered for that part number. The cost averaging formula and conditions are covered in the receiving section of this manual. The cost averaging defaults can be set with option 50 in the configuration settings and utilities module.
|
Clicking the Cost Detail Button will display the sum of the component, labor and overhead costs for an assembly. This button will not respond for a component part numbers nor labor part numbers.
In the above example: The Standard Cost, $852.32, is the sum from the last "Standard Cost Roll Up" and is stored in the stdcost field. The standard cost of labor is $7.32 and is stored in the stdlabcost field. The Average Cost, $749.65, is the sum from the last "Average Cost Roll Up" and is stored in the cost field. The average cost of labor is $7.32 and is stored in the avelabcost field. The Last PO Cost, $787.00, is the sum from the last "Last PO Cost Roll Up" and is stored in the lastpocost field. The last PO cost of labor is $3.66 and is stored in the lplabcost field. Option 60 in the configuration settings and utilities menu, sets the overhead %. Option 35 in the configuration settings and utilities menu, sets whether the average or standard cost will be inserted into sales orders and invoices as the cost of sales. Option 35 will also set what is included during cost roll ups:
|
The Unit (unit) field contains the unit of measure (each, ft, lb, hrs, etc). It should contain the unit the parts are issued and sold in.
The Last PO Cost (lastpocost) field contains the cost of the last PO for this part. pc/MRP automatically enters the last PO cost whenever a purchase order is created for a part number.
The Purchase Ratio (poratio) field is the ratio of the number of issued units required for one purchase unit. For example, if you issue in ft. and purchase in yards, the PO Ratio would equal 3. The PO Ratio must be a positive number greater than zero. A zero could cause a divide by zero overflow error message. Whenever a part number is created or data is imported into the partmast.dbf file, pc/MRP automatically inserts 1 into this field.
The Purchase Unit (pounit) field is the purchase unit of measurement. Referring to the example above this would be one yard. When entering a PO, enter the quantity of purchase units you require. pc/MRP will insert the purchase unit and multiply the vendor's unit cost by the purchase ratio. The quanity on order in the partmaster will be increased by the quantity ordered x the purchase ratio. When the PO is received, the quantity on hand will increase by the quantity received x the purchase ratio.
The QTY On Order (onorder) field contains the quantity on order from purchase orders. As explained above the quantity on order in the partmaster will be increased by the quantity ordered x the purchase ratio. When the PO is received, the quantity on hand will increase by the quantity received x the purchase ratio.
The Qty On Demand (ondemand) field contains the quantity on demand from open work orders and sales orders. Whenever a work order or an "Order Entry" sales order is entered, the quantity on demand for that specific assembly is increased. It is important to note, the quantity ondemand for the component parts that go into that assembly do not increase. Instead, whenever an MRP is generated, pc/MRP decreases the quantity available field for the component parts to satisfy the demand from the open sales and work orders. Creating an invoice for a sales order will decrease the quantity on demand for the assembly listed in that sales order. Using the stockroom's "Receive completed assemblies from manufacturing" for a work order will decrease the quantity on demand for the assembly listed on that work order.
The Qty Available (avail) field contains the quantity available after allocation. This field is updated by running pc/MRP's Single or Infinite Bucket MRP program. The MRP programs will allocate parts on hand and on order and fill in the quantity available field with the quantity after allocation. For example, if a company has 1200 bearings on hand, the quantity available might be 800 after allocation. The Quantity Available field consist of the onhand quantity + PO quantity (on order) - the allocated quantity (future issues and sales) - the minimum quantity. pc/MRP Versions 7.02 and higher dynamically adjust the qty available field (new purchase orders increase the quantity available of component parts and invoices decrease the quantity available of finished assemblies).
The Min Qty (minqty) field contains the quantity at which a part should be reordered. For example, if you use 2 parts per week and it takes 3 weeks to receive the part the min qty field should be set to 6. pc/MRP's optional sales analysis module has an option that will study your sales (invoices) and related BOMs for a specified period of time and automatically fill in this field.
The Max Qty (maxqty) field contains the quantity to re-order up to. This field is used by the min/max report found in pc/MRP's purchasing report module.
The Part/Assy/Labr (part_assy) field should be filled in with a P for component, A for an assembly, and L for labor. Assemblies should not be entered into the PARTMASTER by hand. The BOM module will automatically enter the assembly into the PARTMASTER and place an A in this field. Parts marked L will not be adjusted when parts are converted to assemblies or when they are invoiced or received. The Infinite Bucket MRP optional module does include L in the MRP report, but still does not adjust quantities. Vendor assemblies should be entered as parts. If you include labor as part numbers, select parts and assemblies only when running a costed inventory report.
The Class Field (class) is used by pc/MRP's Inventory Cycle Count Module. All Class A parts are counted every 30 days. All Class B parts are counted every 90 days. All Class C parts are counted every 180 days. This field must be filled in with either an A, B, or C. See the Cycle Count Module section in this manual for additional details on automatically filling this field.
The warehouse Area Names such as TEST/MRB,ENGINEER,R&D can be changed using option 34 in the configuration settings and utilities module. It is important to note, that these are areas that store parts & assemblies and are not manufacturing areas. pc/MRP has one area representing manufacturing and that area is WIP (work in progress).
The Stores, Area and WIP Qtys (onhand,area2qty-area6qty,wipqty) fields contain the quantity stored in that area for that part number. Basically the onhand quantity of a part number is automatically increased whenever it is received by the receiving module. The onhand quantities are automatically decreased when they are "Issued to Manufacturing" and/or "Invoiced". Much of this depends on how you set your inventory adjustment method (see option 4 in the configuration, settings and utilities menu).
The stores and area quantity fields can be entered and edited directly. However, it would be better to enter the initial quantities using pc/MRP's physical inventory program and edit the quantities using the stockroom's "Adjust Quantities" option. Both the physical inventory program and the stockroom's "Adjust Quantities" programs leave records of the changes. This allows pc/MRP's "Inventory Movement" report to calculate the inventory at any specified date after the physical inventory was taken. Option 62 in the configuration settings and utilities menu allow you to turn off the option to enter and edit the stores and area quantities from the partmaster screen.
The Parts Location Fields (locate,locate2-locate6) can contain any six-digit code you care to come up with to aid in locating parts.
Pressing the Purchase Prices Button will display the following window.
The Quantity (qtyl2-qtyl5,qtyl2_v2-qtyl5_v2,qtyl2_v3-qtyl5_v3) fields contain the quantity breaks for the three primary vendors.
The Cost (stdcost1-stdcost5,stdcost1b-stdcost5b,stdcost1c-stdcost5c) fields contain the cost breaks for the three primary vendors.
The Vendor Currency (vendcurncy,vendcur2,vendcur3) drop-down list boxes are available for each vendor if pc/MRP's optional Alternate Currency module has been activated. This allows the user to set the currency in which the Standard Cost will be tracked. As currency rates change, the standard cost fields will remain constant with regard to the vendor's currency.
The Displayed Currency drop down list box allows the costs to be displayed in various currencies provided the pc/MRP's optional alternate currency module has been activated.
In the above purchase prices window, Vendor 1, Ultracision, charges $3.00 for 20 or more of part number 000000001. The $3.00 is displayed in the base currency, however the price will fluctuate based on the vendor's currency. This means that the vendor will always get his asking price based on his currency.
pc/MRP Version 6.80 contained just one set of cost quanity breaks (stdcost,stdcost2-stdcost5, qtyl2-qtyl5) and they were associated with a vendor with fields (v1-v5). With pc/MRP version 6.80, only one vendor currency (vendcurncy) could be specified per part.
Pressing the Sales Prices Button will display the following window.
The Sale Price Quantity fields (qtyl2-qtyl5,qtyl2a-qtyl5a,qtyl2b-qtyl5b,qtyl2c-qtyl5c, qtyl2d-qtyl5d,qtyl2e-qtyl5e,) contain the sales price quantity breaks for various levels (types) of customers.
The Sale Price fields (saleprice,salepric2-salepric5,salepriceb,saleprice2b-saleprice5b, salepricec,saleprice2c-saleprice5c, etc.) contain the sales prices based on quantity and customer's sales level as per that customer's sales level found in the customer's address book record.
The Displayed Currency drop down list box allows the sale prices to be displayed in various currencies provided the pc/MRP's optional alternate currency module has been activated.
pc/MRP version 6.80 there was only one quantity sale price table containing the sales prices based on quantity or customer sales level. Version 6.80 used the following fields to store the sale prices per unit (saleprice, salepric2-salepric5). In version 6.80, option 41 in pc/MRP's configuration settings and utilities module allowed the users to set sales orders to insert the sales price based on price/quantity breaks or the customer's sales level. The customer's sales level is stored in the customer's address book record.
The Save and Cancel options are self explanatory.
The Delete option allows the deletion of and existing part.
The Logbook button opens an ASCII text file where additional comments or instructions regarding the part may be recorded. Important: Do not change the filename assigned to the log file. pc/MRP would no longer be able to associate the file with the part number.
The Where Used Button will open a pop up window listing all BOMs which use this part and the quantity per assembly.
The Next Page option continues the data entry process to the next page. The following fields are found on the next page option.
The Image File (image_file) field is used to store and display pictures of each part. BMP files are displayed directly within pc/MRP, while all other file types, (GIF, JPG, PDF, AVI, DOC.....) are viewed through your browser. Plug-ins for your browser must be loaded to view file types other than GIF and JPG. When entering a file path into the file image field, pc/MRP will plant a "Display Picture" button in the center of the image window. Double click the "Display Picture", the internet browser will be launched. We recommend that all files be deposited into a sub-directory of pc/MRP's main directory labeled BMP. This will eliminate difficulties that may occur when trying to view the image from workstations that have a different drive designation for the server. The size of the BMP file can not exceed 280k. You can use Microsoft's Paint program to decrease the size of you BMP file. Select Accessories, Paint, Image, Stretch/Scew and reduce the % horizontal and vertical size. If you wish to view PDF picture or document files you must install Adobe Acrobat Reader. Adobe Acrobat Reader can be downloaded from http://www.adobe.com/products/acrobat/readstep.html. In versions 7.02K and higher a URL can be entered into this field. The URL must however contain the full URL. (http:\\www.xxxxx.xxx)
Clicking on the Orcad Fields Button will allow you to fill in the orcad fields (parttype,value, tolerance,rating,packtype,schematic, and footprint).
Checking the Floor Stock Item check box (floorstk) will prevent this part number from being decremented when the stock room module is used to issue parts to manufacturing. If a part number is stored on the manufacturing floor (such as nuts and bolts) and is not issued with the assembly, you would check the floor stock check box. Use the stock room's "Adjust Quantity" method to decrement the stores quantity when refilling the bin box on the manufacturing floor.
The Std Order Qty (ordqty) field is used by pc/MRP's Infinite Bucket module. If the infinite bucket module needs to create a buy action item for a part number, it will use the actual quantity required. However if the standard order quantity for that part number is greater than actual quantity required, it will use the standard order quantity.
The Std Pkg Qty (ordmult) field is used by pc/MRP's versions 6.87 and higher Infinite Bucket module. If a part is required to be ordered in a multiple, such as eggs one dozen to a carton, it will increment the buy to the next highest multiple.
The Est Lead Time field is used by the Infinite Bucket optional module. This tracks lead time by days. For component parts, this represents the delivery time needed to receive the part for the vendor. For assemblies, it represents the build time for the assembly.
The Estimated Usage/Week (usage) field is used by pc/MRP's Inventory Cycle Count Module to automatically determine which parts are to be reclassified as Class A, B , or C parts based on usage and unit cost. pc/MRP's optional Sales Analysis Report will fill this field in automatically based on past sales (invoice) history.
The Weight/Unit (weight) field is self explanatory. This is the weight per unit.
The Catindex (catindex) field is utilized in the optional Sales Analysis module. This allows the end-user to leave min quantities for part numbers or assemblies unchanged regardless of usage figures by entering "SAV" into that part's or assembly's catindex field.
The Salesman (salesman) and Sales Commission(%) (commiss), fields are automatically inserted into sales orders, invoices, and accounting transactions to allow pc/MRP to track and report on sales commissions. A sales commission of 5.00 would represent 5%.
The Division (division) field is automatically inserted into sales orders and purchase orders. pc/MRP uses this field to determine what division or department chart of accounts to credit or debit for sales orders and purchase orders.
The Shelf Life (shelflife) field contains the shelf life in days for that part number. If you have activated pc/MRP's optional serial/lot number module, receive completed assemblies back from manufacturing, and select to enter serial/lot numbers, pc/MRP will insert the expiration date into that serial lot/number based on the date and the shelf life.
The Licensor (licensor) field is automatically inserted into sales orders and contains the name of the company that may have licensed this part number for resale.
The Royalty Rate (royalrate) field contains the royalty rate charged for this part number.
The Debit Account (dacct1) field is automatically inserted into purchase orders and receivers. If a receiver's debit account field contains an 8 character chart of accounts number, pc/MRP will debit that account when posting the accounts payable voucher (receiver).
The Credit Account (cacct1) field is automatically inserted into sales orders and invoices. If an invoice credit account field contains an 8 character chart of accounts number, pc/MRP will credit that account when posting the accounts receivable voucher (invoice).
The Next Page option can be exited by choosing the appropriate box for your desired outcome; Save, Cancel, or Last Page.
5.1.3 View/Edit A Part Number
This option allows you to view or edit information pertaining to a part number or to mark the part number for deletion.
In the scroll options window, select the action you prefer (View or Edit). If you select view, any changes you make while viewing will not be saved.
From the Sort Order list box, select the field by which you wish the data to be sorted.
Having selected the field to scroll on, pc/MRP will prompt you to enter the first characters to begin scrolling at for that field. For example, if you wanted to find the record for part number 123456 you would select Part Number as the sort order and begin scrolling at 123. Use the arrow keys to scroll. Once you have located the record press <Enter> to display it.
If you select the Delete or Undelete button to delete or undelete a part, pc/MRP will locate and mark for deletion or undeletion every occurrence of that part in every BOM. It will then ask for permission to remove those records from disk for both the partmaster and BOM database files. If you have a number of parts to mark for deletion and wish to save time, answer No to removing the marked records from disk. Mark the remaining parts for deletion, then on the last part number allow the program to remove the records from disk.
5.1.4 Change Part Number
5.1.5 Find Parts (Matching A Partial Description)
Allows you to search for all parts matching a specified description in the Partmaster's Description Field or Memo Field. For example, to search the Partmaster Description Field for all elbows you could select D, for search on description and enter the letters ELB.
5.1.6 Reports (Print/Display Inventory Reports)
Selection 3 will allow you to print out various reports on the partmaster file. See
section 15.4.1 to create custom reports. Your standard report options are
as follows:
The report output options include:
The report format options include:
5.1.7 Labels (Print Part Labels)
Prints out labels for the following items:
You can customize pc/MRP labels using Configuration Utility, option 24 or FoxPro for Windows 2.6, see Customizing pc/MRP for Windows, section 15.4.1 of this manual.
The standard labels can be purchased at any office supply store selling 15/16" high by 3-1/2" wide single row pin fed labels designed for dot matrix printers. These labels are also available from Rapid Forms in white (5K350151), yellow (5K350151), blue (5K350151), or green (5K350151). To order from Rapid Forms call 800-257-8354.
The labels can be used to accurately label part bins, parts, etc.
pc/MRP labels are designed for dot matrix and laser printers. If you are using a laser printer, answer no when prompted to align labels as laser labels do not require alignment. If you are printing out labels with a laser printer, use 1"x4" labels 20/sheet. Use your laser printer to print the first row of labels, then reverse the sheet to print out the second row of labels.
The Work/Sales Order label option creates a mem file (wosernum.mem) to store the last serial number issued. It increases the serial number and prints out as many labels as received for the Work/Sales order line item.
5.1.8 Sales Price Markup
Automatically mark up every part's sale price by a specified % of each parts current cost or sales price.
5.1.9 Cost Roll Up (Automatic)
Cost Roll Up uses the Bill of Materials to automatically update all assembly costs or the assembly cost for a single assembly. The new costs are then recorded in the Partmaster Database File. You can update either the average cost, standard cost or last PO cost.
5.1.10 Physical Inventory (and Cycle Count Programs)
Allows you to take a physical inventory and/or cycle count of all parts that have not been issued to the floor (WIP). See the Physical Inventory Section of this manual for a more complete description of the Physical Inventory and Cycle Count Programs.
5.1.11 Audit-Duplicate Parts
This function searches the Partmaster for duplicate part numbers. You will be asked if you want to remove duplicate part numbers. If you answer yes, and it finds duplicate part numbers, it will mark the second part number for deletion. The program will continue searching the Partmaster database file for additional duplicate part numbers until it has marked all duplicate part numbers for deletion. The program will then remove the part numbers marked for deletion from the disk. If you answer no, pc/MRP will display or print a list of duplicate part numbers.
5.1.12 Audit-WIP Quantities
pc/MRP versions 6.78G and lower allow the user to correct the partmaster wip quantities based on the open sales and work orders and the stock transaction records issued to manufacturing as per the pseudo code below:
Selecting the Partmaster Data Base File
Zero out all WIPQTYs
Select Stock Transaction Data Base File
Set filter to ACTION = "ISSTM"
Do while not end of file
Store the SONO
Store the Itemno
Store the Qty issued to m_parts_issued
Store the Qty required to m_parts_required
Select Sales (Includes Work Order records also)
Find the SONO
If found()
Store Original Qty required to m_assys_req
Store Qtyassembled to m_assys_assembled
Store Qty shipped to m_assys_shipped
If open and m_assys_req > m_assys_assmebled and _assys_req >
m_assys_shipped
Select the Partmaster Database File
FIND the PARTNO
If found()
If m_assys_assembled = 0
Replace the wipqty with wipqty + m_parts_issued
Endif
If m_assys_assembled > 0
Replace the wipqty with wipqty + (m_parts_required x (1-
(m_assys_assembled/m_assys_req)))
Endif
Endif
Endif
Endif
Select Stock Transaction Data Base File
Skip to the next stock transaction record
Enddo
|
This report will only print or display open sales or work orders if it is not complete (the complete field does not contain a "Y"), the order was issued (in the stockroom there is an ISSTM record), and, the quantity issued is greater than the quantity returned. With pc/MRP version 6.91H and higher, the audit WIP report also displays parts with WIP quantities in the partmaster and no relevant stock transaction WIP records by checking the "Include all parts option".
This report can be helpful in displaying which sales/work orders are currently open and are on the manufacturing floor.
The quantity issued column contains the quantity of that part number issued to that sales/work order. The quantity returned column contains the quantity returned (as part of the finished assemblies). The correct WIP quantity (stockroom) contains the quantity issued - (minus) the quantity returned. The current WIP quantity represents the quantity in the partmaster WIP quantity field. The variance is the difference between the stockroom module and the partmaster module.
If the report's stockroom quantities are too small, determine which sales/work orders have not been issued by pc/MRP. Use the stock room module to issue them.
If the report's stockroom quantities are too large, determine which sales/work are open that were closed some time ago. Use the stock room module to receive these sales/work orders back from manufacturing or close out the sales/work orders by entering a Y the complete field of the sales/work orders.
Once the corrections have been made, run the report again. If the new quantities are correct run the "Correct WIP Variances" option to transfer the new wip quantities into the partmaster wipqty fields.
If you select the "Correct WIP Variances" option, pc/MRP will correct the wip quantities in the partmaster as per the following pseudo code:
Replaces all partmast wipqtys with 0
Uses open sales and work orders (complete # Y)
Do while not end of file
If the related stock transaction = ISSTM
in_wip = qtyissued-qtyreturned in completed assys
If in_wip > 0
Increase partmast wipqty by in_wip
endif
endif
Enddo
|
Once WIP is correct, you can run a physical inventory on the stores area(s) and correct the quantities for that area (do not include wip quantities as they have already been corrected at this point).
5.1.13 Index (The Partmaster File)
Allows you to re-index the partmaster's main index files. pc/MRP automatically updates its index files under normal operation. However, if you ever get a "record out of range" error message, or you can not find a part number you know exists, reindexing the index file is usually the cure.
5.1.14 Remove Marked Records
Removes all Partmaster Records marked for deletion from the disk. The records will no longer be recoverable. The remaining records are then automatically re-indexed.
5.1.15 Undisplayed Partmaster Fields
pc/MRP's partmaster file contains many undisplayed fields. The following is a list of those fields and the purpose for each of those fields.
pc/MRP's physical inventory program stores the physical inventory counts in the invarea1-invarea8 and invtot fields. Once the counts have been verified and the user pressed the update button. The counts are moved from the invarea fields to the stores and areaqty fields.
The lastphydat field stores the date the last time a physical inventory was taken with pc/MRP's Physical Inventory Module. The lastphydat field will also be filled when the part number is first entered.
The lastqty1-lastqty6,lastqtywip fields store the physical inventory quantities recorded on the date the last physical inventory was taken with pc/MRP's Physical Inventory Module. These fields will also be filled when the part number is first entered.
The above fields allow pc/MRP's inventory movement report to calculate the physical inventory at any date. However, for this to work, the following practices must be followed.
