Open SQLSYSSETTING.EXE within the manexSQL root directory.

 

Enter password when prompted.

Select Material > ABC Types from the menu. 


 

  
 
The following screen will be displayed:


 Your "ABC Calculation Based on" selection affects the meaning of the % of Value field.  
 
  • If Manual has been selected, then % Value does not apply.   
     
  • If $ Estimated Annual Usage (EAU) has been selected, then it is EAU x STD cost and % of that value (top 80%, 15-80%, etc.).   
     
  • If $ On-Hand has been selected,  then it is On-Hand x STD cost and % of that value (top 80%, 15-80%, etc.). 


ABC Codes will be calculated using the information in the % value and LT> fields. These fields are used to determine which parts should have their ABC codes automatically adjusted. After the ABC codes are updated, those parts will be included with the appropriate group for cycle counting.

 
Tick the "Ignore In Store" checkbox only if you do not want the in-store warehouses to be included in the cycle counts, regardless of which "Calculation Based on" is selected.


To edit the information in this module, click the Edit icon. Select "ABC Calculation based on" by clicking on the appropriate radio button. 

If the user selects $ Estimated Annual Usage, the following options will become visible:




Type in the EAU Factor %, then click the "Calc EAU" button to update the EAU field within the ICM screen.


This button will only be available if the screen is in Edit mode. Clicking this button will update the EAU field within the ICM screen. The term EAU (Estimated Annual Usage) may be considered as consumption, depletion, loss, used up, etc. As such, the EAU calculations must include the in-store issues in order to be accurate.

If a user is issuing in-store parts to a Sales Order to be shipped, the parts still count as an issue, and so it is necessary to include them when considering plans for future usage. If a user were to deliver all material directly to Work Orders from in-house and these transactions were not included, there would be no calculated EAU. This is why we do not allow in-store issues to be ignored. The only time in-store issues will not be calculated in the EAU is if they are being returned to the vendor through Inventory Handling. 

  

To save your changes, click the Save icon. 
 



User may then click any of the Calculation buttons.

  • Calc EAU: Will update the EAU field within the ICM screen. The last EAU date will be filled in.
     
  • Calc ABC Codes: Information in the % Value and LT> fields will be used to determine which parts should have their ABC codes automatically adjusted. After the ABC codes are updated, those parts will be included with the appropriate group for cycle counting. 
     
  • Update ABC Codes: Information in the % Value and LT> fields will be used to determine which parts should have their ABC codes automatically adjusted. After the ABC codes are updated, those parts will be included with the appropriate group for cycle counting.

The user may next set up an inventory counting program called “Inventory Cycle Count,” which assists in counting all inventory over a period of time. Type A items might be counted in their entirety each month. As such, a list of all type A items (the highest dollar value) will be generated and randomly divided into 20 days. Each day, 1/20th of the list will be counted and checked. Type B items might be checked every quarter and type C items once a year. This is a way to verify the accuracy of stockroom transactions and take the measures necessary to keep counts accurate. 
 
Enter the ABC Types into the appropriate boxes.


The ABC code identifies a part source for inventory parts. Because manexSQL allows up to 26 ABC codes, it also provides for identifying if a part is a BUY or MAKE part. Click on the desired part source radio button for BUY or MAKE parts.

Enter the Dock to Stock days.  

In addition to identifying the most or least expensive part numbers, a dock to stock period may be included in each ABC code. Dock to stock is the number of days a part is expected to take to be delivered to the stockroom after the part is received on the user’s dock.

Additionally, for each ABC code, manexSQL provides a cycle count tolerance, which, if exceeded, will result in reporting unfavorable results during cycle counting. These tolerances may be an absolute dollar value or a percentage of the inventory being counted. 

In the Cycle Count section, enter the cycle count days. 

Note: This field must be populated with a number other than 0. If 0 is entered, the parts will not be included in the cycle count. 

When finished editing, the user may click either the the Save icon or the Abandon Changes icon. 

Where Used: Part Type Setup, Inventory Item Master, Material Requirements Planning, and Cycle Count functions.