ArticlesArticles Most Helpful ArticlesMost Helpful Articles Language SettingsLanguage Settings LoginLogin
RSS Feeds
DrillDown Icon Table of Contents Back
 . . . . . . . . . . . . .
DrillDown Icon Hardware and Software Requirements for Installing SQL Server
DrillDown Icon List of Modules Converted to MANEX Client Server
DrillDown Icon Installing SQL Server
DrillDown Icon System Administrator
DrillDown Icon Security System
DrillDown Icon Accounting Setup
DrillDown Icon System Setup
DrillDown Icon General Setup
DrillDown Icon Sales
DrillDown Icon Production
DrillDown Icon Material
DrillDown Icon Prerequisites
DrillDown Icon Introduction
DrillDown Icon Part Source
DrillDown Icon Part Package
DrillDown Icon Unit of Measures
DrillDown Icon Unit of Measures Conversion
DrillDown Icon Warehouse Setup
DrillDown Icon ABC Types
DrillDown Icon Inventory Buyer Setup
DrillDown Icon General Inventory Setup
DrillDown Icon Inventory Part Class
DrillDown Icon Inventory Part Type Setup
DrillDown Icon Inventory Handling G/L Defaults
DrillDown Icon Inventory Handling Receive Reasons
DrillDown Icon Inventory Handling Transfer Reasons
DrillDown Icon Engineering Change Order Setup
DrillDown Icon Supplier Types
DrillDown Icon Supplier Status
DrillDown Icon Purchase Setup
DrillDown Icon First Article Disposition
DrillDown Icon Inspection Exception Setup
DrillDown Icon Return/Shortage Reasons
DrillDown Icon Kit Default Setup
DrillDown Icon MRP Default Setup
DrillDown Icon Material Risk Code Setup
DrillDown Icon Material Type Setup
DrillDown Icon Prerequisites
DrillDown Icon Introduction
DrillDown Icon Fields & Definitions
DrillDown Icon Material Type Mgmt
DrillDown Icon Inventory Material Type Setup Fields and Definitions
DrillDown Icon AVL Material Type Setup Fields and Definitions
DrillDown Icon How To ....
DrillDown Icon Clauses Setup
DrillDown Icon FAQs
DrillDown Icon Operations Manuals
DrillDown Icon System Utilities
DrillDown Icon SQL Server Memory Settings and Performance
DrillDown Icon Definitions
DrillDown Icon How to schedule and automate backups of SQL Server databases in SQL Server Express
DrillDown Icon SQL_FAQ's
  Email This ArticlePrint PreviewPrint Current Article and All Sub-Articles
 
Material Type Mgmt
 
 
 
This allows the users to decide if they would like the inventory part material type controlled automatically or manually.  If the user chooses MANUAL, each time an AVL is added, edited or deleted, the user would receive a popup reminder that "The Inventory level Material Type is set to Manual.  Be sure to verify how changes affect the Inventory Material Type".  If the user chooses AUTOMATIC then each time an AVL is added, edited or deleted, a popup will be displayed (if the the AVL material type is DIFFERENT than the inventory type) that says "AVL Material Type is different than Inventory Material Type and may affect the  Inventory Material Type", with an option to proceed or cancel.  If proceeding, then the system recalculates the material type on saving the edit. 
 

Inventory Material Type

Material Type at the Inventory Level 

AVL Material Type

Material Type at the AVL Level 

Logic

There are two grids in the Material Type Management screen.  The left side displays the different INVENTORY Material Types that the user has established in the Inventory Material Type setup screen.  When one of these Material Types (MT) 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 each of the AVL MT, and how they affect the INVENTORY MT.   The choices to affect the INVENTORY MT selected are ALL, INC, and NOT:  If ALL is selected, then every one of the AVL's available for that Inventory part must have the same MT.  (There can only be one ALL selected).  If INC is selected, then if any of the AVLs with that designations are included, then the INVENTORY MT will be assigned accordingly.  IF ANY of the AVL's for an Inventory part contain a designation in the NOT category, then the inventory designation will become "UNK".  For more MT Logic Setup Examples see attached document.

 

Depressing this button will allow the user to sort the Inventory Material Type in order of priorty in which the logic is checked.

Article ID: 4004