Open SQLSYSSETTING.EXE within the manexSQL root directory.
Enter password when prompted. |  |
Select Material > Material Type Setup from the menu. |  |
The following screen will be displayed:
Click the Edit icon in the main toolbar. This will allow you to change the Inventory Material Type to "Automatic" or "Manual" based on AVL material type.
If the user chooses the manual option, there will be a pull-down next to the Material Type field at the top of the Quantity Info screen (within the Inventory Control Mgmt module) listing all the Inventory Material Types available:
The user may highlight the material type they wish to be assigned to this Inventory part regardless of the material types of the AVLs. Each time an AVL is added, edited, or deleted, the user will receive the following popup reminder:
If the user chooses the automatic option, they must also set up the logic by clicking on the radio button next to "ALL," "INC," or "NOT."
Note: Make sure you do not set up duplicate logics for different material types.
There are two grids in the Material Type Management screen.
The left side displays the Inventory Material Types (MT) that the user has established in the Inventory Material Type setup screen. When one of these material types is selected, the grid on the right side of the page displays all available AVL material types that the user has established in the AVL Material Type Setup screen.
For each Inventory MT, the user can select the AVL MT and how they affect the Inventory MT. The choices to affect the selected Inventory MT are ALL, INC, and NOT.
If ALL is selected, every one of the AVLs available for that inventory part must have the same material type. (There can only be one "ALL" selected).
If INC is selected, if any of the AVLs with that designation are included, the Inventory Material Type will be assigned accordingly.
If any of the AVLs for an inventory part contain a designation in the NOT category, the inventory designation will become "UNK".
If the AVL material type is set to "automatic" and a user attempts to edit the logic setup, the following message will be displayed:
EXAMPLE:
Set up logic for a new Inventory MT (Mixed):
- Go to the AVL Material Types.
- Check LF-Date and RoHS-Date as INC.
- Check all other AVL MT as NOT.
(For more MT Logic Setup examples, see Material Type Logic Setup Examples.)
In manexSQL's Inventory Control Management module (Inventory Management > Inventory Control Management > Inventory Control Management), search for and open an existing inventory part (# 101-0001621, in this case) with a different AVL Material Type and an Inventory Material Type of "UNK."
Click the "Edit" icon on the record and change all AVL Material Types to either LF-Date or RoHs-Date. The Inventory Material Type will update to "MIXED" per the MIXED logic in the system setup.
Or: User can leave all AVL MT as is, go to System Setup, and edit the Inventory MT - MIXED Logic to include UNK and LF-P/N, then update records. Inventory MT will update automatically with existing AVL Material Types.
The user may also sort the Inventory Material Type in order of priority in which the logic is checked by clicking the reorder button as shown in the screen below:
Reorder by using the arrows on the left side of the Inventory Material Types.
Click "Done" when re-order is complete.
If Inventory Material Type is set to automatic, the user will receive the following message:
