Open SQLSYSSETTING.EXE within the manexSQL root directory.

 

Enter password when prompted.

Select Material > Inventory Part Type Setup from the menu.

 

 

The following screen will be displayed:  

Part Class tab: Shows a list of existing part classes. Highlighting a part class will show the corresponding types linked to it on the right. Clicking the Re-Order button allows the user to sort the order in which the part types are displayed in the pulldown when setting up parts in the Inventory Control Mgmt module.


Details tab: This is where records are created.  

To add a part class, click on the Add icon in the main toolbar.

  


Enter the part type, part prefix, and part description template into their respective fields. If inspection and/or certification(s) are required, check the appropriate boxes.
 
Select the stock unit of measure, purchasing unit of measure, package, ABC code, and buyer code by clicking the down arrow next to the field. Enter the run scrap percentage and setup scrap quantity information, as well as the cost information for material, labor, overhead, user-defined, etc. 

Note: (If accounting is installed.) For all BUY parts, the material cost field must have data entered. If this data is missing or incorrect, the Raw Materials Inventory and the Work In Process (WIP) will be incorrect for the accounting records. 

All MAKE parts which are not labor only (the customer provides the kit and you apply the labor) must have data entered in the Material Cost field. Additionally, the data entered in the Material Cost field for the MAKE part must equal the sum of the Bill of Materials components. (Please refer to Bill of Materials Reports - Bill of Material With Standard Cost.) 

If data is missing or incorrect on a MAKE part, the Work In Process, Cost of Goods Sold, and Finished Goods Inventory will be incorrect in the accounting records. If the sum of the Bill of Materials components does not equal the standard cost per the Item Master, a configuration variance will generate. 


Select the order policy by clicking the down arrow next to the field. Enter in the order multiple, the minimum order quantity, re-order point, and re-order quantity. 

Select the certificate type by clicking the down arrow next to the field. Select the day of the week or day of the month by clicking the down arrow next to the field. 

Select the purchase, kitting, and production lead times by entering the number in the appropriate box and clicking the down arrow to select the days, weeks, or months. 

Enter the pull-in or push-out days. Check the lot code box, if desired. If you select lot/date code tracking, you will also be prompted for the auto date for all lots and for the product expiration days, as displayed below.

 

If the user wishes to edit or delete part type information, clicking the Edit or Delete icons in the main toolbar enables the user to choose a part type used in the class and edit or delete it. 

Note: Users will not be allowed to delete a part type which has active inventory or orders.
 
After adding, editing, or deleting a part type, the user may save the data by pressing the Save icon in the main toolbar. 

When saving a new part type, the user will receive the following message as a reminder that once this record is saved, the lot/date code tracking field can not be edited:

The user can select "Yes" to continue the save or "No" to abort the save. 

  

Where Used:  Material functions.