Material Type Setup

Prerequisites
User must have full rights to the System Setup in System Security. Users with supervisor rights will automatically have access.
Fri, 1 Jul, 2022 at 10:47 AM
Introduction
The user may establish the logic by which the material type for parts are established by the material types at the AVL level. User may also reorder the mate...
Fri, 1 Jul, 2022 at 10:47 AM
Fields and Definitions: Material Type Management
  This screen allows users to decide if they would like the inventory part material type to be controlled automatically or manually. If the user cho...
Fri, 1 Jul, 2022 at 10:47 AM
Fields and Definitions: Inventory Material Type Setup
    Inventory Material Type Inventory Material Type Codes:  LF: lead-free RoHS: restriction of hazardous substances* Unk: unknown Non-Comp: N...
Fri, 1 Jul, 2022 at 10:47 AM
Fields and Definitions - AVL Material Type Setup
   AVL Material Type Approved Vendor List Material Type Codes:  LF, LF-Date, LF-Mark, LF-P/N, RoHS, RoHS-Date, RoHS-Mark, RoHS-P/N, and Unk. (These ...
Fri, 1 Jul, 2022 at 10:47 AM
How to edit the Material Type Logic
Open SQLSYSSETTING.EXE within the manexSQL root directory.   Enter password when prompted. Select Material > Material Type Setup from the menu. ...
Fri, 1 Jul, 2022 at 10:47 AM
How to add or edit an Inventory and/or AVL Material Type
Open SQLSYSSETTING.EXE within the manexSQL root directory.   Enter password when prompted. Select Material > Material Type Setup from the menu....
Fri, 1 Jul, 2022 at 10:48 AM
How to delete an Inventory and/or AVL Material Type
Open SQLSYSSETTING.EXE within the manexSQL root directory.   Enter password when prompted. Select Material > Material Type Setup from the menu. ...
Fri, 1 Jul, 2022 at 10:48 AM
Material Type Logic Setup Examples
In this setup, a part with one or more AVLs with an AVL Material Type (AMT) of Lead-PB will not assign Lead-PB to the Inventory Material Type (IMT). However...
Fri, 1 Jul, 2022 at 10:48 AM