Main Screen field definitions

Warehouse	The name of the warehouse for the part highlighted.If the warehouse button is depressed, the grid will sort by warehouse.
Source	The source of the part number, Make or Buy. If the source button is depressed, the grid will sort by source.
Class	The classification of the part.If the Class button is depressed, the grid will sort by class.
Type	The type within the classification of the part number.
Description	The description of the part number.
UoM	The unit of measure of the part number.
	This will allow user to select only the un-reconciled parts or all parts.   Selecting "All" will display parts that are un-reconciled and reconciled but not yet posted.
Location	The warehouse location for the part to be counted.
Part Mfgr	The Manufacturer for the part to be counted.
MPN (Manufacturer’s Part Number)	If the source is a buy, the number that the manufacturer has assigned to the part.
Part Number	The Internal Part Number for the item to be counted.Depressing the Part Number button will sort the grid by part number.
Rev	The Part Number Revision for the item. An item may exist under multiple revisions.
Count	The physical count quantity of the item observed during cycle counting
Init	The initials of the individual who performed the cycle count.
Date	The date that the inventory was counted. The date will default to the current date, but may be over-written.
Allocated	If an inventory part number has allocated inventory, the line will show in red and the Allocated box will have a check mark.This field is a reference field which indicates to the user that there is allocated inventory against this item and the system will not allow you to adjust the qty below the allocated amount.
Lot Code	If the part type has been designated as requiring lot tracking, then the lot tracking reference number appears.
Reference	Lot Code tracking reference number.
Exp Date	Expiration date of Lot Code
PO #	Customer PO number
Serial Number	If the part has been designated as requiring serial numbers, then the serial numbers appear in this screen.

Depress this button to record the adjustments in the count into the Inventory Master and to create the applicable accounting entry.  The "Allow Updating Inventory" option button (for Physical Inventory) within the Security module MUST be checked in order to Post Inventory Adjustments.

ABC codes are used as an aid to manage inventory tracking. Traditionally, ABC codes are established to divide the inventory by value, and to guide in the cycle counting of inventory.

First the value of all inventory in stores is added up and listed by part in order of the highest extended value first. Then, the top percentage value (e.g. 80 % of the parts value) would be classified as “A” items, and will probably consist of about 10-15% of the inventory part numbers. The next 15% of the value items would be classified as “B” items, and will be in the neighborhood of 20-40% of the part numbers. The last 5% of the value will be classified as “C” items, and represent at least 50% of the part numbers.

The user then sets up an inventory counting program called “Cycle Counting”, which assists in counting all inventory over a period of time. The “A” items might be counted completely within each month. Therefore, a list of all of the “A” items (the highest dollar value) is generated, and randomly divided into 20 days, and each day 1/20th of the list counted and checked. The “B” items might be checked every quarter, and the “C” items checked once a year. This is one way to verify the accuracy of stockroom transactions, and to take measures necessary to keep the counts accurate.

In ManEx, the ABC codes have a slightly different meaning. 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 stock room after the part is received on the user’s dock. This duration may include the amount of time it takes to organize the shipment, count the parts, log the receipt into the inventory system, perform incoming inspection, and physically move the parts to stores. Intuitively, the higher dollar parts may have longer dock to stock times because of increased inspection. And the lesser valued parts may not require inspection.

Also, for each ABC code, ManEx provides a cycle count tolerance, which, if exceeded, will result in reporting unfavorable inventory control results during cycle counting. These tolerances may be expressed in an absolute dollar value, or a percentage of the inventory being counted.   For further information on the cycle count tolerances and what the purpose of setting them up in ManEx is see the attachment <<Cycle Count Tolerance.docx>>

And, the ABC code identifies a part source for inventory parts. Because ManEx allows up to 36 ABC codes, it also provides for identifying if a part is a make or buy part. 

The ABC codes need to be specifically setup for Make parts. If Make parts are to be included in the cycle count. If an ABC code is setup for a buy part and that ABC code is assigned to a Make part the make part will NOT be included in the cycle count and vica vera.  

Note:  If an internal part number does NOT have an ABC code assigned, that part will NEVER be selected for cycle counting.  Therefore, all internal parts which the user wished to be cycle counted, MUST have a code in the ABC field in the Inventory Control Item Master.