1. Kitting, Allocating & Shortage Management
1.1. Kitting & Shortage Management
1.1.1. Prerequisties for Kitting & Shortage
Prerequisites Required for Entering a New KITTING & SHORTAGE

After activation, "Kitting & Shortage Management" access for each user must be setup in the ManEx
System Security module.  Users with “Supervisor Rights” will automatically have access.
 

Work Order A work order must exist.
Bill of Material The assembly must have a bill of materials, with kitted components
AVL The Manufacturer Names must exist when using the AVL in the BOM.
Reason Codes These codes must be established in the Return/Shortage Reasons  setup module.
Accounting Defaults Inventory and Variance General Ledger accounts must be set up in the G/L Accounting Setup.

Optional Prerequisites for Entering a New KITTING & SHORTAGE

Work Order Traveler When adding line shortages, must have Work Order Traveler established if parts are to be issued to work center

 

 

1.1.2. Introduction for Kitting & Shortage
This screen provides a method for gathering data related to a specific Work Order.  Users are able to simulate a kit pull to better determine component availability and identify potential delays.  They also record unexpected component shortages allowing purchasing to order more and inventory to replace the components as needed.
 
See Article #3273 on "How ManEx can help you Streamline your Kitting Process". 
1.1.3. Fields & Definitions for Kitting & Shortage
1.1.3.1. Main Tab

 

Main Screen Field Definitions

Work Order The work order selected for kitting activities
Product # The Part number assigned to the assembly in the work order
(Rev) The Part Number Revision for the assembly
Customer The customer for the work order
Build Qty The quantity of assemblies to be made for the work order
Class The classification of the assembly
Type The type of assembly
Description Consists of the Inventory Control Item Master Description
Last Changed Date and Time of Last Change to this Work Order/Kit
By User ID of person who made last change to this Work Order/Kit
Kit Status

KITSTATUS ( character field) may be empty, or one of the following:  Kit Closed, Kit Process, Rework. If the KIT MANAGEMENT screen has been opened, and any material issued to the kit, the condition of this field will be changed from empty to Kit Process. This field is NOT dependant on the KIT field, but by the logic described in Article #2679 , and cannot be changed unless the kit is released.

Reason
When user pulls kit, edit, update..... all these details are saved in a table called "Kadetail".  All these records will have a "short reason" which is hard-coded in the program.  Here are some examples:

Procedures                                    Reasons
Edit kit(edit qty or delete):                KIT MODULE/REV
New Kit Pull                                    KIT MODULE/Issu
Auto Kit                                          KIT MODULE
Kit Update                                       KIT UPDATE or KIT MODULE/Upd(if user has overissue)
Delete part                                      DEL
Add misc shortage                           ADD
Edit misc shortage                           EDT
 
If it's a line shortage, then user can select the reasons that's set up in System Setup So, when user highlights an item, the user will be able to view all different reasons for this item.
Kit in Process Date and Time status of Kit was changed to "Kit in Process"
By User ID of person who changed kit status to "Kit in Process"
Check when Kit Completed Date and Time when Kit Complete box was checked
By User ID of person who checked the Kit Complete box

Component Section

This is the “Ignore Shortage” box: If you want to remove the component from the shortage reports and MRP, check the box at the left of the part number.  Note:  the box for checking KITTED shortages only works with those items that are kitted based on the BOM for the assembly. Checking the boxes means that the part on the BOM will NOT be considered for MRP purposes, and not show up on shortage lists. This is the only way you can get a part on the BOM off of the shortage list. Line shortages, however, can be edited to make them larger or completed.  The user will not be able to create a line shortage, then try to check the “ignore shortage” box, this box is disabled for added line shortages.  
This symbol before a part number is to inform the user that this part is originating from a Phantom BOM.  
When shortages have been saved for the work order, they will be added to the Kit Status section of the main information tab. The item will be preceded with the rho (? ) symbol to differentiate it from a kit shortage.
Part Number The part number of a component belonging to the Bill of Materials for the assembly
Rev The part number revision of the component
Ref Designator The Reference Designator as assigned in the BOM Module
Required Qty The number of parts required of the component in the work center shown. (A component may be used in more than one work center.) This qty may include Setup Scrap if the "Setup Stcrp" box is check on the BOM Header Information and/or Run Scrap if selected to include scrap in the Kit Default Setup .
Picked Qty The number of parts already picked from stores for the work order
Shortage The quantity of parts short for the work order will be displayed as a positive number, the quantity of parts issued as an overage will be displayed with a negative number.
Part Source The source code for the part, BUY, MAKE, Phantom or Consigned
Work Center The work center in which the part is needed and to which it is to be kitted
Rej Qty If parts have been rejected during the kitting process, the quantity of parts rejected

DIRECTIVE BUTTONS

The following buttons are displayed on the Kitting Main screen

  Kit Note will bring up any notes entered concerning the kitting or shortages
  BOM Note will show any notations entered at the Bill of Material level
  W/O Note will display any notes entered about the work order
  Item Mstr Note will display any notes entered in the Inventory Control Item Master about the part highlighted
 
On Order button will display information about any open orders that may exist for the part highlighted, as shown below:  

User may:
 
- Sort by Clicking on header
- Search for specific item by typing in column
- Double Click on Selected Record to Drill Down to PO




 
The Inventory button will display on hand and location information for the part highlighted, as shown below:
 
User may:
 
- Sort by Clicking on header
- Search for specific item by typing in column

     
 
 
 
1.1.3.1.1. Kit Status Logic

Status of Kit:  Released is a term that means the work order has moved from the initial input condition, where it is possible to check on details of the work order and to utilize a check list to indicate certain functions (established in the setup) have been completed (e.g., necessary documents have been received, shortages have been resolved, tooling is available, etc.). An unreleased work order cannot be kitted, nor moved on the shop floor.

KIT (a logic field) means that the work order has been released for production to work on it. This includes kitting and SFT. It means that in the WO screen, the user has clicked on the “Work Order Released” checkbox. Or, this box is automatically checked when all of the items on a work order check list have been completed. It does not mean that the work order or the kit have been started. Until this box is checked, no kitting nor SFT activities can begin.

OPENCLOS ( character field) is the status, or condition of the work order. This condition is required to initiate a work order. These conditions must be one of the following:  Archived, Cancel, Closed, Firm Plann, Rework, ReworkFirm, Standard.  Every work order  must have one of these conditions.
1.1.3.2. Issue Tab

Issue Screen Fields

KIT STATUS SECTION

Part Number

The part number of a component belonging to the Bill of Materials for theAssembly.

Rev The part number revision of the component
Shortage

The quantity of parts short for the work order.

INVENTORY STATUS SECTION

Part Mfg The name of the manufacturer for the highlighted part
Warehouse The name of the warehouse
Location The location within the warehouse listed, such as Row 2, Bin 34
Available Qty The quantity available for this part for this work order
WO Alloc The quantity allocated to other Work Orders.
Pjct Alloc

The quantity allocated to other projects.

PICKED STATUS SECTION

An "A" will be displayed in this column if the Manufacturer is approved
Part Mfgr The name of the manufacturer for the highlighted part.
Mfgr Part Number The manufacturer number for the part highlighted
Pick Qty The qty required for this WO.   See Article #1240 for more detail on why the system will not allow user to enter in a fraction of a number, and an alternative.
Over issued Qty The qty over issued to this WO.  See Article #1240 for more detail on why the system will not allow user to enter in a fraction of a number, and an alternative.
Lot Code The manufacturers lot code for the part highlighted
Total Picked Qty

The quantity of the highlighted part already picked. Below that is the part number of the completed assembly.

Total Overissued Qty Any quantity issued over what the Bill of Materials depict. Below that is the revision number of the completed assembly.
  When depressing this button a bar code label will be printed
 

The "Next" button should be used with the top "part number (type or scan)" field. When user types (or scans) the part number the user wants to issue, the cursor on the left list will move to the right part number record, then user can issue it. After the user is done, click the "Next" button, the system will save the issued record, and the cursor will move to top "part number" field again for user to enter whatever part number the user wants to issue next.  It doesn't mean the "next one" record in sequence.

  When the user is finished pulling the parts to the kit, they would depress this button and it will bring them back to the Main screen

  LOT CODE INFORMATION

 Mfgr Part Number  The manufacturer number for the part highlighted
 Lot Code  The manufacturers lot code for the part highlighted
 Lot Qty alloc to this PRJ  The quantity allocated to this specific project.
 Int. Lot Code  The users internal lot code for the part highlighted.
 Exp Date  The assigned date of expiration for the lot.
 Avail Lot Quantity  The quantity available for that lot which is available to assign to the work order.
 Lot Qty alloc to this WO  The quantity allocated to this specific work order.

ADDITIONAL PART INFORMATION

 Part Class  The classification of the highlighted part. Below that is the part description
 Part Type  The type of part
 Part Source  The source for the part: Buy, Phantom, etc.
 Work Center  The work center where the part will be needed for the assembly

 

1.1.3.3. Utility Tab

The Utility Tab has four functions:

 

1.  Close Kit - This section is used to close the kit from further transactions. Once closed, no further parts may be issued to or from the work order.



Once the Close Kit button has been depress the following screen will appear, this screen will list all over-issues for disposition, it defaults all items to have the over-issue qty returned to stock.  If the users wants to return all to stock they just have to click the OK button.  If they want to assign all the over-issue to the Work Order (kit) they can do so by depressing the "Issue All to Kit" button.  

The act of closing the kit sets up the material variance entry for the Accounting module if more parts or less parts than called for by the Bill of Materials were actually used. Note:  Only an accounting password can close the kit.

The manufacturing variance is based on what should have been kitted according to the BOM for the work order. Under issues, overissues and alternate parts are considered as variances.

If a part is allocated to a Work Order or a Project (linked to the work order), when the KIT over-issues to WO-WIP location.  Once the WO is closed, and user chooses to return stock, the WO allocation will be cleared, but the Project allocations will be retained and carry back to stock as still allocated to that project. 

What are the actions that would cause a work order to appear on the “Kits to Close” report?

The action that causes a work order to appear on the Kits to Close report is when the Work order is closed. (In the Shop floor tracking module, the units are transferred to the Finished Goods work center). There is no longer a balance due on the order but the work order has not yet had the kit closed. There are two aspects of closing a work order activity – 1, closing the work order; and 2, closing the kit. The work order closes when all of the scheduled parts are either in finished goods or scrap. This happens automatically when the last transfer is made in the shop floor tracking module. The kit closing is a manual function. It is separate, because even though the work order may be closed, somebody may not have completed kitting all the parts to the work order, nor moved all of the over-issue out of the work order. These actions are prompted for when the kit is closed. The user may close the kit without addressing the open issues, but if that happens, each will become a variance within accounting. Unfilled shortages will become a positive variance and overissued parts will become a negative variance.

(Important Note: For those instances where the user didn’t issue the parts to the work order initially, but completed the work order in shop floor tracking and then closed the kit, there will be a very large positive variance created because the system will assume that the cost of the components = zero.) Therefore, do not close a kit if it was never pulled.

2.  Re-open kit - If the user wishes, he/she may re-open the kit once it has been closed. Note: Only an accounting password can re-open the kit.

 

3.  De-KitThe act of de-kitting will return all of the previously picked parts to inventory.  If a part is allocated to a Work Order or a Project (linked to the work order), once the part is issued to the WO (not over-issue) the allocation will be removed,  only the allocation for over-issue parts can be kept. Once the WO is closed, and user chooses to return stock, the WO allocation will be cleared, but the Project allocations will be retained and carry back to stock as still allocated to that project.  The appropriate accounting entry will also be generated to return all parts to Raw materials inventory from Work in Process. The system will not allow you to de-kit with product in finished goods.

 

4.  Update Kit - The Update Kit button will update the work order with any BOM changes.

Depress the Update Kit button. Type in your password.

You will receive a confirmation message.

 

If the changes to the BOM reflect inventory parts that require dispositioning the following screen will appear:

Highlight the item. The system will default in the issued qty into the Issue WO field. If you wish to issue the parts directly to the cost of the Work Order then you can leave the qty in Issue WO. Depressing the OK button will then issue and cost those parts to the kit.

If you wish to return those part back to inventory you will change the Issue WO qty to 0 and then you will see the Return to Stock qty adjust. That amount in the Return to Stock will be the amount that will be returned back to stock as available inventory.

If there is an Over Issue Quantity found during the update kit, user will receive a message to remind the user that there was an Over-issue qty found, and to make any needed changes to those quantities to "Return to Stock".  (If you wish to return those part back to inventory you will change the Over Issue qty to 0 (bottom screen)  and then you will see the Return to Stock qty adjust (top screen)). That amount in the Return to Stock will be the amount that will be returned back to stock as available inventory.

If not the over-issued qty will remain as an overissue - and upon completion of the update kit the parts will be issued to the WO (costed to the kit) and accounted for as a Mfgr Variance upon closing.   

If a part is allocated to a Work Order or a Project (linked to the work order), when the KIT over-issues to WO-WIP location.  Once the WO is closed, and user chooses to return stock, the WO allocation will be cleared, but the Project allocations will be retained and carry back to stock as still allocated to that project.  

Depress the OK button and you will receive a confirmation message.

For any new parts added to the BOM, they will appear as shortages. You need to make sure to pull them to the kit.

If any of the quantities per within the BOM were increased, you’ll have to also pull additional amounts, which will now show as shortages to the Work Order:

In the example below, part number 105-0002726 was just added to the BOM and must now be pulled. Additionally, part number 101-0001633 had the quantity per on the BOM increased and now the shortage must be pulled.

1.1.4. How To ..... for Kitting & Shortage
1.1.4.1. Finding a Work Order Record

Enter the SQLMANEX.EXE (within the ManEx root directory)
This action will then prompt the user for a password

The following screen will be displayed, enter Enter Inventory Management/Kitting, Allocating & Shortage Management/Kitting & Shortage Management.  

 

The following screen will be displayed:

 

Depress the Find action button the following screen will appear.
 
Select the desired Filter: by selecting the appropriate radio button - Open, Closed/Cancelled, or All.

Select the desired
Find: by selecting the appropriate radio button -  Work Order Number, Product Number, Customer, Sales Order Number, or All. 

Enter the information into the red box, depress the Enter key and the information will populate the screen.    If you do not know the exact number, Customer, etc you may enter in a partial number, letter, etc, then once you depress the enter key the system will pull up the matching record onto the screen or a list of all Work Orders that contain the partial number, letter, etc. entered, to select from.

 

If user selects ANY of the Filters:  and Find by All - a screen will appear listing all the Work Orders filtered by the selection,  in numerical order, along with the part number, and Customer name.   


The user has the option to view the work order by either entering the work order number into the red box, or scrolling down the list, highlighting the desired record and double click on it.  

.

 

After finding the Work Order, the Main KITTING screen appears, populated with any current information about the work order, as displayed.

 

 

1.1.4.2. Issue Parts to Kit

Enter the SQLMANEX.EXE (within the ManEx root directory)
This action will then prompt the user for a password

The following screen will be displayed, enter Inventory Management/Kitting, Allocating & Shortage Management/Kitting & Shortage Management
 
 The following screen will be displayed:
 




After
Finding a kit and if it has NOT been previously pulled, the following procedure is performed

Press the Edit action button. This selection will appear:

Select between Manual Kit and Auto Kit.  The user may abort
the process by clicking on the X button to exit without pulling the kit.
 
When Selecting either "Manual Kit" or "Auto Kit" and this message appears the WO has a status of Mfgr Hold and the kitting procedure cannot continue until this WO status has been changed.


MANUAL KIT

Selecting "Manual Kit", this action will prompt the user for a password, after entering a password the following message will be displayed: 





Depress the "YES" button and user will be presented with the screen being displayed below: (Note: the Kit Status has been updated to "Kit in Process")
NOTE:   If user selects "Yes" to continue and is using the WO Release CheckList the "Kit Released" box will be checked at this time
 

 
 
If you would like to see if there is part availability for the highlighted part number before going to the next step depress the "Inventory" button. 
 

Depress the Edit action button again and the following selection will appear:

Depress the Issue Parts button to continue or X to cancel.  If you depress the Issue Parts button and enter in a password the Issue Tab screen is displayed:    

 

 

This screen is divided into four operational sections.

The left side of the screen will display the parts to be kitted, and the current shortage for each part  
On the upper right side of the screen, ManEx will display either all the AVL's or only the approved AVL's depending on how the Kit Default setup is setup.  

If the "Show all Manufacturers" is selected in the Kit Default screen the kitting module will display ALL AVL's and then indicate the approved ones with an "A" on the left of the screen and will allow user to pick from the non-approved AVL's as well as the approved AVL's. 
 
If the "Show only Approved Manufacturers" is selected in the Kit Default screen the kitting module will ONLY display the approved AVL's and so users will only be able to pull parts from the Approved AVL's. 
 
An "A" will appear in the left column for the approved AVL's.  Then the Mfgr, WH and Location will be displayed along with the current Available Quantity for the part highlighted on the left side of the screen, plus whether or not there has been any quantity allocated to this Work Order or project. 
 
User also has the option to Allow use of non-nettable warehouse locations by checking or unchecking the box located in the Kit Default  Setup screen.  
 
In the center of the right side of the screen,  the Picked Status section, ManEx will display the Part Manufacturer, Mfgr Part Number, Pick Quantity, Over Issued Qty, Lot Code for the work order, Total Picked Qty, and Total Over Issued Qty.  

In the lower right side of the screen, Mfgr Part Number, Lot code information, Part Class, Type, Part Source, Work Center, and Description, about the inventory part highlighted in the upper right side of the screen.    



The user first selects a part from the kit status section.

Place the cursor on a part manufucturer in the inventory status screen and drag it to the Picked Status section in the center of the right side of the screen. To drag, place the cursor on the line indicating an available quantity. Do not remove your finger from the mouse. While you are in the process of dragging, you will see an outline of a hand holding a document. Pull the cursor down to the Pick quantity section. To drop, remove your finger from the mouse. Those manufacturers approved for the bill of material will have the manufacturer preceded with an A.

When inventory from the Inventory Status section is dragged to the Picked Status section, the quantity required for the work order is subtracted from the original quantity in inventory.  If there is insufficient quantity in inventory, an additional lot may be dragged to the picked status section. If the quantity of parts needed is less than the quantity in inventory, only the quantity needed will be transferred.

While still in the Pick Status, the user may modify the quantities being picked. Increasing the quantity that is required for the kit (if there is more available in inventory) will place the extra parts in the overissued qty column. The shortage column will display the over-issues as negative shortages. By reducing the quantity, the remainder of the parts will be returned to inventory.  If not returned to Inventory, unused parts in the overissued inventory will continue to be considered as available for use by MRP actions. Other kits may be kitted using these parts.

To change the amount Picked, place the cursor on the amount picked. A white box will display. Type the revised amount picked in the white box and depress the Enter key.

REAL TIME KITTING FEATURE

When you first enter the ISSUE screen and if you just continue through and Drag & Drop items as described above all of the transactions will be saved to the system upon depressing the Save Record Icon.   But as soon as you depress the Next button the system will begin to save the records immediately and the Save and Cancel icons will became inactive. This has been added so our users can begin real-time kitting and since intended for a wireless network connection we need to save individual pulled records instead of the entire kit pull save. Below is a description of how this feature is intended to operate:

  1. User has a Pull Cart with a wireless laptop along with a wireless label printer.
  2. The barcode scanner will be hooked to the laptop.
  3. User takes the Kit Pick Worksheets with the items needed to be pulled.
  4. Goes down the isles and scans the part being pulled and enters in the pick qty.
  5. Then depresses the Next button. That record will be saved immediately.
  6. Prints the 4 x 2 label by depressing the Print a Label button. (if you need 3 labels, then depress the Print a Label button 3 times).
  7. Continue going through pulling parts for that kit as you go through the isles.
  8. Then when user is finished pulling parts for that kit they can depress the Done button.

This will then bring them back to the Main Kitting screen.

  This field will allow you to type or scan in the Part number you are wishing to pick parts for.

ENTER SERIAL NUMBERS

If the Part Number highlighted in the left column, is a serialized part, highlight the Available Quantity.  Drag and drop into the Pick Quantity space (as described above). The quantity will appear as 0 in pick quantity. Click on pick quantity and manually fill in quantity. The following screen will appear:

 


All serial numbers for this part number will appear in the left hand column. Highlight the serial numbers you want used for this work order click on the > arrows. They will
appear in the right hand column. If you overissued you must highlight the serial numbers for the overissued quantity click on the > arrows and they will appear in the bottom right hand screen. Once the serial numbers that are to be used for this work order appear in the right hand column depress the OK button.

Depress the ‘DONE’ Button or ‘Save’ button.

The completed Main tab screen appears as below:

 

NOTE:  MRP is designed to calculate from the Kit Shortage and not from the Lead times once the parts have been pulled to the kit and the kit status is changed to "Kit in Process".   Once the parts have been pulled to the kit, the systems is assuming that the shortages are needed by the WO due date, rather than the Production lead time, so MRP then calculates using the due date of the WO as the date the materials must be on hand, MRP no longer takes the production lead time into consideration.

This message will be displayed if the user has over-issued to one item, then trying to issue to 2nd item (same part number) from the over-issued SN of first item.  The system filters out those SN that are over-issued to the same work order and same part number (might be different kit item) when the program is preparing the SN selection list.  In this case user should decrease the over-issued SN from first item, and it will be available for 2nd item.   




 

AUTO KIT

If you select Auto Kit, user will need to enter password, parts will then be pulled automatically to the kit.  Parts will ONLY be pulled from Stock, Allocation, or Lot Coded Parts and Approved AVL's. Note: Auto Kit will NOT pull parts from WO-WIP locations.   

If there are serialized parts assigned to the work order you will receive the following message and will NOT be allowed to Auto kit. The system will allow you to auto kit the non-serialized parts within that kit. But if there are any serialized parts you will have to pull those items manually.

 

If the Bill of Material does not have any components that are kitted, then no kitting will be done.

Kitting Preference Hierarchy

When Kitting

Manex picks Approved AVL's and in numeric sequence. (1 before 2, 2 before 3, etc.) "99" is the default preference number, if no preferences are entered, then other un-controllable factors affect which is picked first.  

If the user wants to have a specific warehouse picked first, then they are to enter a preference number such as "1" in the preference field  within the Quantity Info screen within  Inventory Control Mgmt

If the part is a lot coded part, auto kit considers the lot code expiration date.  The auto kit sequence should be allocation first then non allocation.  If a part has allocation but with a later expiration date, it still should be picked first than the non-allocation parts with an earlier expiration date.  


 
COMPLETING KIT
 
When kit is completed, all shortage filled, etc. check the kit complete box, and the date, time, and users initials will defaulted in. This box must be checked when usiing the Unreleased Work Order List and the  Work Center Checklist  

1.1.4.3. Add a Line Item Shortage

Enter the SQLMANEX.EXE (within the ManEx root directory)
This action will then prompt the user for a password

The following screen will be displayed, enter Inventory Management/Kitting, Allocating & Shortage Management/Kitting & Shortage Management

The following screen will be displayed:



After Finding a kit that has a status of "Kit In Process"



Pressing the Add Button displays the following selection choices:
 
 




 
 

Shortages other than those resulting from an incomplete kit are considered Line Shortages. Line shortages may be a result of poor yield on a part, and additional parts are required, or because one or more additional parts are needed for the work order beyond those described in the bill of materials. Line shortages may be created because of alternate parts, special engineering evaluations, or for any reason that the user decides to enter in the system setup.

For Miscellaneous Shortages, (this selection may be used to issue non-inventory items to kit).  (See further detail below). 

If you select Add Line Shortages, you will be prompted for your password and then the following screen will be displayed:  (NOTE:  If line shortages are added and issued to rework WOs, the kit status will update to  “REWORK”).   True "Phantoms" cannot be added as a line item shortage to a kit.
 

NOTE:  The Line item shortages are considered as in the WIP account all the way through until the Kit is closed within the Kitting module. Upon Closing the kit within the Kitting module the Line Item Shortages are then costed out and credited out of WIP account and debited in the Mfgr Variance account. So the “Inventory WIP Valuation Report” by Work Order by Standard Cost  does not deduct those line item shortages as the product is moved into FGI.   See Article #1777 for further detail.

 

The bottom of the Main information tab is opened up to display an area to enter the part information necessary to describe the shortages.

The part information for the shortage is entered. The part must be a part defined in the Inventory Control Item Master. Select Part Source, Part Class, Part Type, Part Number from the respective drop down lists. Enter the Short Quantity and the Required Qty will default in then enter the the Quantity per Unit. Select a Work Center from the drop down.   Note:  Shortages recorded by Ref Designator are case sensitive.   
 

There must be a reason for the shortage entered in the Reason field. These reasons are established in the Return/Shortage Reason in System Setup. The user chooses the appropriate reason from the drop down list. The reason will appear in the Reason box.

 

When shortages have been saved for the work order, they will be added to the Kit Status section of the main information tab. The item will be preceded with the rho (? ) symbol to differentiate it from a kit shortage, as displayed:



“Ignore Shortage” box: If you want to remove the component from the shortage reports and MRP, check the box at the left of the part number. Note that the box for checking KITTED shortages only works with those items that are kitted based on the BOM for the assembly. Checking the boxes means that the part on the BOM will NOT be considered for MRP purposes, and NOT show up on shortage lists. This is the only way you can get a part on the BOM, off of the shortage list. Line shortages, however, can be edited to make them larger or completed. The user should NOT create a line shortage, then try to check the “ignore shortage” box.  A line shortage is either short or not.   If it is not short for this particular work order, then check the box to take it off of the shortage list.

Add a Miscellaneous Shortage

If you select Add a Miscellaneous Shortage you will be prompted for your password, and then the following screen will be displayed:

Enter in the Part Number, Revision and Description. Select Source, Class, Type, Department, Reason from the respective Drop Down lists.  Enter in the Quantity and Quantity/Unit. Continue in this fashion until all entries are made. Depress the Save button.

 

Issue or Edit a Line Item Shortage

Pressing the Edit Button (after finding a work order) displays the following selection choices:

 

If user selects "Edit line Shortages", you will be prompted for your password and then you will have the opportunity to change Quantity, Quantity/Unit or Work Center Selection for an existing line item shortage.  

This field is intended for the user to enter in the qty needed for the shortage and the system will make the needed adjustments based off from that qty.
For Example:  if the user originally added a line item shortage for a qty of 5, and picked a total of 7 to the kit. (Production has no way of knowing how many were pulled to the kit originally, so a week later they come back to the stockroom, and request 4 more).  The stockroom will then edit the line item shortage at this time the qty will display a -2.00, stockroom will issue 4 more by entering a qty of 4, the system will make the adjustments based off from that qty, so the Required qty will then become 11. 
 
NOTE:  You can only reduce the shortage qty if there are no issues against it.  If the complete shortage qty has been issued, and user depress the Edit line Shortage button and the qty field is "0" and user enters a qty in the qty field the system will interpret this as an additional qty.  To change a qty that has already been issued user would need to un-issue the complete qty and then go back and change the shortage qty.  System will not allow user to enter a negative qty.

Depress the Save button when changes are completed.

If user selects " Issue Parts" enters their password, they may follow the steps outlined in Article #904

 

Add a Line Shortage to a Rework Work Order

Overview of a Rework Order

When a rework order is created via the RMA Receiver module (Please refer to the Return Material Authorization Management manual), there is no demand created for any parts on the BOM for the product of the work order. But, demand will be created for any line shortages established for the work order. There should be a line shortage created for the assembly being reworked, so the product can be issued to the work order.

When the work order has the kit closed, the manufacturing variance is created that is the difference between the standard cost of the parts issued to the work order and the standard cost of the sum of all of the BOM components.

If there is no BOM for the product, but if the assembly has a standard cost assigned to it, the following will happen:

There will be a favorable variance to the wip (the difference between the standard cost of the product and the standard cost of the sum of the materials on the BOM) Assembly Standard cost – zero BOM cost.

The kit close will have an unfavorable variance created for accounting which will be the sum of the standard cost of the components issued to the work order. The kit close will offset the line shortages pulled.

To add a line shortage to a rework work order, follow the same procedures as finding the work order, as detailed above.

Depress the Add button to add a new line shortage. Type in your password. Then follow the procedures to add and pull a line shortage as detailed above. Upon completion, you will see a message at the top right hand side of the screen that inventory files are being updated. Then the part information in the lower part of the screen will turn blank.

Exit the kitting module and then proceed to the shop floor tracking module to complete the rework order.

The Delete button is used to remove line shortages BEFORE the parts has been pulled to the kit for that line item. Find the Work Order containing the line shortage, using the find procedures. After selecting the delete button, the user is asked for an authorized password. Then the user selects the item to be deleted. Highlight the line item containing a rho symbol (? ) at the far left of the part number.
 
If the parts HAVE been pulled to the kit for the line item shortage, user MUST de-kit or return picked qty to stock before the line shortage can be deleted.
 
 
 



 

The following message will appear:  Depress the OK button. 

 

The item will still be displayed with a Required Qty of 0.
 
 

 

 

1.1.4.4. Update Kit
The Update Kit button will update the work order with any BOM changes.   Note:  This button MUST be depressed after an ECO approval for any part changes to be reflected if the Work Order due date proceeds the effectivity date of the ECO.

Depress the Update Kit button. Type in your password.

You will receive a confirmation message.

 

If the changes to the BOM reflect inventory parts that require dispositioning the following screen will appear: 

 
Note:  If parts are being displayed for dispositioning even though NO changes to quantities were made it may be due to the fact that the work centers were changed and upon completion of the update kit the parts will be issued to the WO (costed to the kit) and accounted for as a Mfgr Variance.      

Highlight the item. The system will default in the issued qty into the Issue WO field (bottom screen).  

If you wish to issue all the parts directly to the cost of the Work Order then you can leave the qty in Issue WO and Over Issue.  Depressing the OK button will then issue and cost all those parts to the kit.
 
If you wish to return those part back to inventory you will change the Issue WO qty to 0 (bottom screen)  and then you will see the Return to Stock qty adjust (top screen). That amount in the Return to Stock will be the amount that will be returned back to stock as available inventory.

If there is an Over Issue Quantity found during the update kit, user will receive the following message to remind the user that there was an Over-issue qty found, and to make any needed changes to those quantities to "Return to Stock".  (If you wish to return those part back to inventory you will change the Over Issue qty to 0 (bottom screen)  and then you will see the Return to Stock qty adjust (top screen)). That amount in the Return to Stock will be the amount that will be returned back to stock as available inventory.
 
If not the over-issued qty will remain as an overissue - and upon completion of the update kit the parts will be issued to the WO (costed to the kit) and accounted for as a Mfgr Variance upon closing.   

 
If the over-issued quantity or quantity in WO-WIP has been allocated to other work orders/projects,  then the user will receive the following message and the kit will not update until the allocatiions have been cleared.
 

For any new parts added to the BOM, they will appear as shortages, and user will need to make sure to pull them to the kit.

If any of the quantities per within the BOM were increased, you will have to also pull additional amounts, which will now show as shortages to the Work Order. 

If user changes a Work Center on a BOM and depress the Update kit button, the system will treat this part as a new item, and will appear as shortages and user will need to make sure and pull them to the kit.

In the example below, part number 105-0002726 was just added to the BOM and must now be pulled. Additionally, part number 101-0001633 had the quantity per on the BOM increased and now the shortage must be pulled. 

 

1.1.4.5. De-Kit

The act of de-kitting will return all of the previously picked parts to inventory.  If a part is allocated to a Work Order or a Project (linked to the work order), once the part is issued to the WO (not over-issue) the allocation will be removed,  only the allocation for over-issue parts can be kept.  The system will NOT allow you to de-kit with product in finished goods.

Note:  If the "Remove location with this warehouse from the Inventory when qty on hand gets to "0" box is checked in the Warehouse Setup , and the work order is de-kitted, the warehouse will be reactivated and parts will be returned to that same warehouse.    


When De-Kitting parts issued from an In-Store warehouse, the parts will NOT be returned to the In-Store warehouse.  The parts will be returned to Stock and the In-Store PO will still need to be created. 

 
Depress the De-Kit button and the following message will be displayed:
 
 



If the over-issued quantity or quantity in WO-WIP has been allocated to other work orders/projects,  then the user will receive the following message and the kit will not Dekit until the allocatiions have been cleared.


If the kit is NOT in process yet or has been de-kitted already, the following message will appear on screen and will cancel the de-kit.
 
 



.
1.1.4.6. Return Over-Issue

There are two methods of returning an over issue:

Method 1:
 
This method allows users to return the unused over-issued parts back to Inventory BEFORE the Work Order has been completed (reached the Finished Goods Inventory Work Center in Production).  

Using the Finding a Kitting & Shortage procedure, find the Work Order with the over-issue. You will note that the shortage column contains a negative amount, as shown in the screen below:
 


Depress the Edit action button if the Work Order has been completed and the status of the Work Order is Closed user will receive the following message and will NOT be able to continue this process.

 

  1. Depress the Edit action button. The following selection will appear:
  2. Select the Issue Parts option.
  3. Enter password.
 
  1. Highlight the Part Number with the negative shortage.
  2. Move the cursor into the Pick Quantity field.
  3. Enter in the corrected amount of picked quantity that was actually used in the assembly. (For example in the screens below there was Required qty of 100, I picked a qty of 130, but actually only used a qty of 107, so I returned 23 to Inventory/Stock).
  4. Depress the Enter key. The over-issued Qty and Avail Qty will update as displayed below. 

 

Depress the Save action button. The difference between the original over-issue and the actual over-issue will be returned to inventory. The inventory records will update and the appropriate accounting entry removing the part from WIP will also be made.  (If the parts in WO-WIP have been allocated to another work order/project user will NOT be able to return the over-issue qty using this method).  NOTE:  If parts have been pulled from an In-Store location and there is an over-issue qty the over-issued qty will be returned to the In-Store location.

Method 2:
 
This method gives the user the option to Return parts to Stock/Inventory or Issue parts to kit once the assembly has been completed and reaches the Work Center for Finished Goods Inventory, and the Work Order Status is Closed.  For example:  the user has a reel of 250 parts and he/she doesn't want to count out 100 parts for the Work Order so they issue the complete reel of 250 to the WO, which will cause an over-issue of 150 parts.  
 
 
Once the assembly has been completed and reaches the Work Center for Finished Goods Inventory, these un-used over-issued parts can now be issued to the Work Order, or returned to stock, as follows:

Using the Finding a Kitting & Shortage procedure, find the Work Order with the over-issue.  

  1. Open the Utility tab.
  2. Depress the Close Kit button, the following screen will appear.

  

3.  If then you want the un-used overissue returned to stock (The Warehouse that the parts were pulled from will be displayed - MAIN1, In-Store, etc), depress the OK button.  Notice that the over issue has disappeared from the Main tab, as shown in the screen below: (If the user does not want the un-used over-issues returned to Raw Materials Inventory, he/she edits the Quantity Transfer Amount at the bottom right hand side of the screen. The user may transfer 0 quantity or any amount up to the amount of the over-issue). 



Once the above steps are completed, the "Qty Transfer" parts are returned to their warehouse location, WIP is relieved, the Quantity on Hand in Raw Materials Inventory is increased in the Inventory Item Master and the appropriate accounting entries are generated. 
 
Lot Coded Parts - If parts have been issued from different Lot Codes with over-issued qty, those over-issued parts are moved to "WO-WIP" location, and the system saves what lots they come from, when the Kit is closed, the system locates all the WO-WIP locations and lot information, and returns it back to the original lot, if the lot is deleted (due to the lot qty is 0), is will re-create it. 
 
Allocated Parts - If a part in WO-WIP is allocated to other work orders/projects, and user chooses to return back to stock, the program will unallocate from the work orders WO-WIP, return to the original location and then re-allocate to the original locatiion,  if user chooses to issue to work order the program will remove the allocation and  cost it to the work order.  

1.1.4.7. Close Kit
This section is used to close the kit from further transactions. Once closed, no further parts may be issued to or from the work order.  
 
NOTE:  User MUST have full rights to the Kitting & Shortage Management module within Security to be able to close a kit.
 

NOTE:  It is very important to close out all kits. Kits need to be closed manually so the user can choose whether the over-issues are to be returned to stock, or charged to the work order. If kits are not closed users are likely to have a huge manufacturing variance, or very inaccurate inventory records, and MRP will think that the over-issues are available to meet demand, when they might not actually be available
 
 
 
 
Once the Close Kit button has been depress the following screen will appear, this screen will list all over-issues for disposition, it defaults all items to have the over-issue qty returned to stock.  If the user choose to return all inventory to stock they just have to click the "OK" button.   If they choose to assign all the over-issued qty to the Work Order (kit) they can do so by depressing the "Issue All to Kit" button, and the pick qty will increase to include the overissued qty.  So, if the users decide to re-open the kit, they have the option to return the material back to inventory if they choose.

When the close kit has been depressed, if NO locations are available for the parts return, the system will display all deleted locations (which will be displayed in purple color background) for that part mfgr for user to select from.  If the item has available locations, even if it is not the original one, the system will just display those available locations, it will NOT display deleted locations.  The system will list all the available locations for the same manufacturer but not "WIP","WO-WIP" and "MRB" locations for user to return.  User can return overissued qty's to another location but that location must exist in the inventory for that part.  Users are NOT allowed to create new locations through the kitting module.

NOTE:  If the user REDUCES the Build Qty on a Work Order that will change the WO status to "CLOSED",  upon closing the kit the system will take the original quantity pulled to the kit and automatically cost the different to the kit without giving any option to the user.  If the user does NOT wish to have the extra parts automatically costed to the kit upon closing they will need to change the WO status from "CLOSED" to "STANDARD",  return to the Kitting module and "UPDATE"  the kit,  then  return to the WO module and edit/save the record without making any changes – the Status will automatically update to Closed
.   See attached word document <<PS_961_090427.docx>>  for an example.  
 
 
The act of closing the kit sets up the material variance entry for the accounting module if more parts or less parts than called for by the Kit for the Bill of Materials and actually used.
 
The manufacturing variance is based on what should have been kitted according to the BOM extension for kitting for the work order. Under issues, overissues and alternate parts are considered as variances.

The BOM may contain components which may have a scrap percentage associated with them.  When the standard cost is calculated for such a BOM, and if the extended quantity calculated for scrap percentage for a component is fractional, the fraction of a cost is used in the determination of the standard cost.  (For example,if a component had a scrap percentage of 3%, and the BOM calls for 50 components per assembly, the cost is determined based on 51.5 components.  However, when kitting the assembly, it isn't possible to issue 51.5 components, so it is rounded to 52 components.  Then when the assembly is removed from WIP, and the kit is closed, the WIP is credited for the value of the assembly, which includes the price based on 51.5 components.  That leaves the cost of 1/2 of the affected component left in WIP.  The rounding variance tracks down these differences and also removes the remaining cost of 1/2 component.  

The Line item shortages are considered as in the WIP account all the way through until the Kit is closed within the Kitting module. Upon Closing the kit within the Kitting module the Line Item Shortages are then costed out and credited out of WIP account and debited in the Mfgr Variance account. So the “Inventory WIP Valuation Report” by Work Order by Standard Cost  does not deduct those line item shortages as the product is moved into FGI.   For further detail see Article #3053 .

1.       If no G/L account number has been established for the rounding variance user will receive the following message and a G/L account number will need to be established for the rounding variance in  Inventory Setup  before user can continue.


 
 
 
The Kit Closing Procedure will separate out the manufacturing variance, rounding variance, and the changes to WIP values.   

If a part is allocated to a Work Order or a Project (linked to the work order), when the KIT over-issues to WO-WIP location.  Once the WO is closed, and user chooses to return stock, the WO allocation will be cleared, but the Project allocations will be retained and carry back to stock as still allocated to that project. 

If Lot Coded parts have been over-issued to the kit those over-issued parts are moved to "WO-WIP" location and the system will save what lots they were pulled from.  When the Kit is closed, the kit finds all the" WO-WIP" locations and lot information, and returns the parts back to the original lot.  If the lot is deleted (due to the lot qty is 0), the system will re-create that lot.
 
When closing a kit see Article #1777 for further detail on how Line Item Shortages are handled.
 
Upon attempting to close a kit, some users may report this type of message that was presented to them.   This more than likely indicates that parts that have been used on the kit are currently in an active Cycle Count or Physical Inventory. Make sure that Cycle Count or Physical Inventory have been posted to Inventory and then attempt to close the kit again.
 
 
 
 

What are the actions that would cause a work order to appear on the “Kits to Close” report?

The action that causes a work order to appear on the Kits to Close report is when the Work order is closed. (In the Shop floor tracking module, the units are transferred to the Finished Goods work center). There is no longer a balance due on the order but the work order has not yet had the kit closed.

There are two aspects of closing a work order activity – 1, closing the work order; and 2, closing the kit.

The work order closes when all of the scheduled parts are either in finished goods or scrap. This happens automatically when the last transfer is made in the shop floor tracking module.

The kit closing is a manual function. It is separate, because even though the work order may be closed, somebody may not have completed kitting all the parts to the work order, nor moved all of the over-issue out of the work order. These actions are prompted for when the kit is closed. The user may close the kit without addressing the open issues, but if that happens, each will become a variance within accounting. Unfilled shortages will become a positive variance and overissued parts will become a negative variance. 

It is good practice to have someone in accounting and/or inventory review the Kit to Close report and clear them out. 
 
1.1.4.8. Re-Open Kit
Re-open kit - If the user wishes, he/she may re-open the kit once it has been closed.   Note: User MUST have full rights to the Kitting and Shortage Mgmt module within  Production Security along with full right the the ALL Release to GL and ALL Posting to GL modules within Acct Security
 

 
 
 
If a closed kit contains parts with multiple Lot Code pick records against it and then later is re-opened the Kit Pick Lot Qty should still match the inventory Lot Qty when re-opened.  If a closed kit contains overissued qty's the user can select to return the overissued qty to stock.
 
When re-opening of a Rework Kit it should only pull forward items from the original kit for Rework, not all the items from the BOM.    

 

1.1.5. Reports - Kitting & Shortage

To obtain the Kit Reports within the Web, select the WEB Print button from the ManEx action buttons at the top of the screen. For further detail on How the Reports work within the Web refer to Article #5477.

Note: In order to access the Reports within the Web the Company Root URL must be setup within the System Appearance module and user must be linked to web within the System Security Module.


Select the Report Type:  KIT - A List of Reports will be displayed that are available on the Web for KIT



To obtain the Kit reports, select the Print button from the ManEx action buttons at the top of the screen. 



The following reports screen will display a list of reports that are available on the ManEx Desktop:  
 

Highlight the desired report and then depress the OK button  

 
 

Kit Material Availability W/AVL Detail report

The following screen will be displayed if there is NOT a Work Order open on screen.  (Note: If there is a Work Order open on screen this screen will be by passed and the report for the Work Order open on screen will be printed).   Enter a Work Order Number.  Select to Ignore any of the Scrap.   If you wish to NOT ignore any of the scraps, then leave single quotes ' ' as default.   (Default is from Kit Default Setup within System Setup).

NOTE:  If the Kit is in Process the results of the report will always show the same as what is displaying on the Main Kit screen. Regardless as to what the user selects for the Ignore Scrap parameter..

If the Kit is NOT in process yet, it should follow the below:

 First run should take what the Kit Default is set to (ignore or not to ignore at kitting).   If the user refreshes that report and then selects ignore Both . . . then it should ignore both.   If the user refreshes and selects Ignore Scrap . . . then it should only ignore the Run Scrap (%).   If the user refreshes and select Ignore Setup Scrap . . then it should only ignore the setup Scrap.  Select 'No' and it should include both of the scraps. 


Depress the OK button.

 
If users select to run the kit availability report for a closed kit, the KitStatus field will display in RED if = 'KIT CLOSED'.  It will also display if the kit status = 'REWORK', otherwise it will not display
 
This report will check the Kitting Default setup and display the AVL's based off of the default setup to show All Manufacturers or Show only Approved Manufacturers.
 
Phantom Parents will be indicated on the report with 'Phantom:' next to it.  
 
The following report will be displayed: 
 
 


Kit Pick List Work Sheet report
 

The following screen will be displayed if there is NOT a Work Order open on screen.   (Note: If there is a Work Order open on screen this screen will be by passed and the report for the Work Order open on screen will be printed).  Enter a Work Order Number, Dept ID or leave as default.

Select the Scrap option, Suppress Not Used in Kit Items option, and the Suppress Locations with 0 qty option.  (Note:  if no options are selected the "Use System Default"  from the Kit Default Setup and General Inventory Setup within the System Setup will be used.


NOTE:  If user wishes to change view these options or change them for a specific report being printed, they must first bring the report to screen then select the refresh button



and the options will be displayed.

Depress the OK button.

 
The following screen will be displayed if there is a Work Order open on screen
 
The options to Ignore Scrap or not, Suppress Not Used in Kit Items and Suppress Locations with 0 qty will be defaulted from the Kit Default Setup and General Inventory Setup within the System Setup will be used.
 

Depress the OK button and the report will be printed for the Work Order open on Screen.



NOTE: If user wishes to change view these options or change them for a specific report being printed, they must first bring the report to screen then select the refresh button and the options will be displayed or they may select "Cancel" then the refresh button and the options will be displayed. 



 

The following report will be displayed:



Part Labels 

Highlighting the Part Labels brings up the Detail of printer that needs to be used to print the labels.

Depress the OK button. 


The following screen will be displayed if there is NOT a Work Order open on screen.  (Note: If there is a Work Order open on screen this screen will be by passed and the report for the Work Order open on screen will be printed).   Enter a Work Order Number and Depress OK.
 

The labels printed will appear like this:

Box Labels (Not Completed in SQL)

Highlighting the Box Labels brings up a selection of printers to be used. Highlight the printer and depress the option tab.

 

The following screen will appear:

Select the appropriate radio on the right hand side of the screen: Customer, Product, or Work Order. Select the Customer from the drop down list. Select the Work Order from the drop down list. Depress go and the items that require labels for that work order number will appear in the bottom section of the screen.

Depress go and the items that require labels for that work order number will appear in the bottom section of the screen

Type in the qty of labels required and depress OK.

 

 

 The labels printed will appear like this  

Kit Traveler by WC report (Not Completed in SQL)

Select the appropriate radio on the right hand side of the screen: Customer, Product, or Work Order. Select the Customer from the drop down list. Select the Work Order from the drop down list. Depress the OK button.

 

The following report will be displayed:

 



Over Issued Material report

Select Inventory type: Internal or Consign.
 
Enter Customer:  This entry only applies when Consigned is selected as a Type.  Entry must be within Single Quotes.  If All Customers are desired leave '*' Defaulted. 

Depress the OK button.

 

The following report will be displayed:

Work Order Kit & Shortage Issued Material History (Not Completed in SQL)

Select the appropriate radio on the right hand side of the screen: Customer, Product, or Work Order. Select the Customer from the drop down list. Work Order from the drop down list. Depress the OK button.
 
This report will also give you Lot Code and Serial Number History for parts used on Work Orders. 
 
The leading zero's for serial numbers will be removed from report.
 

The following report will be displayed:

 

Customer Consigned Shortage Summary report (Not Completed in SQL)

Highlighting Customer Consigned Shortage Summary report brings up a detail screen:

Highlight By Work Order or By Part No. Depress the option tab.

 

The following screen will appear:

Select the Customers by highlighting and depress the > button. If you want all customers depress the >> button.

Depress the OK button. 

 

 

 

 

The following report will be displayed:

 

Purchased Part Shortage Summary report -

NOTEThe kit has to be in process in order for the parts to show as a shortage on the Report

Highlighting Purchased Part Shortage Summary report brings up a detail screen:

Highlight By Part No. or By Work Order Due Date

 

 
Depress the OK button. 
 
NOTEThis report will ONLY display the actual scheduled qty’s on the PO NOT the ordered qty on the PO.  It will also, ONLY display the next due PO info. it will not display all the Open POs.  (View the PO Detail Report to get the detail PO info)
 
 

·         The report  will suppress the line if the warehouse = 'WO-WIP' and AvailQty = 0.00.

 

 

The following report will be displayed:

Work Order Shortage report or Work Order Detail Shortage report
 
NOTEThe kit has to be in process in order for the parts to show as a shortage on the Report

The following screen will be displayed if there is NOT a Work Order open on screen. (Note: If there is a Work Order open on screen this screen will be by passed and the report for the Work Order open on screen will be printed).

Enter a Work Order Number, Select to Ignore Scrap, Ignore Setup Scrap, or Ignore Both Scraps, (if you wish to NOT ignore any of the scraps, then leave single quotes' ' as default).
 
Once you have made your selection depress "GO"
 
 
 
 
 
 
The report will display "LS" = Line Shortages and "MS" = Misc Line Shortages.  This will be displayed in Red on the left of the part number as displayed in the example below.
 
The Work Order Status and the Kit Status will be displayed on the report header, since both the WO and Kit could be closed with shortages and information still being displayed on this report. 

·        

 

The following report will be displayed:

Buildable report or Buildable Report with Top Three Shortages (Not Completed in SQL)

Select the Customers by highlighting and depress the > button. If you want customers depress the >> button.

Depress the OK button.

NOTE:  Buildable column will display KNS (Kit not started), or KIP (Kit in Process) until the Kit Complete checkbox is checked in the Kitting module.  At this time the Work Order will be listed on the Buildable reports, and the buildable qty will properly display the correct qty based on any shortages.  

The Buildable reports are intended  to be used during the Scheduling meeting for Production scheduling only.  

 

The following report will be displayed:

 

Kits to be Closed 

For the Kits to close selection, select the desired Sort by: Last Complete Date; Work Order; Product Number; Customer:

Depress the OK button.

 

The Estimated Manufacturing Variance being displayed on this report is  calculated by taking the sum of the components (including all overissues (including line shortages)) issued to the work order at their standard cost at the time of the kit close and comparing it to the costed BOM at the time of the kit closing.    Note:  The user will still have the option to disposition the shortages and overages at the time the kit is closed.  
 
 
The Kitted BOM Cost calculations is based off the WO Due date and compares that to the EFF/OB dates on the BOM.  So users need to be very careful with the WO Due Dates and make sure that they stay current along with the EFF/OB dates on the BOM.   


The following report will be displayed:
 

 

Purchase Part Shortages by Work Order report 
 
NOTEThe kit has to be in process in order for the parts to show as a shortage on the Report


If there is a Work Order open on screen the values screen will display only asking if you want to Suppress items with no shortages.  Once user depresses the OK button the report displayed will be for the Work Order open on screen. 

If there is NOT a Work Order open on screen the values screen will display asking user to enter in a Work Order Number, and if you want to Suppress items with no shortages.  Once a Work Order number has been entered user must d
epress the OK button.
 
This report will display all the Open POs (displayed in Yellow box below) for the parts with shortages per Work Order, displays all shortages including Consigned and Make parts along with the Purchase parts and On-Hand Quantity.  The "Not Available" qty displays what the on-hand qty will be once all open PO's are received, and Kit Shortages fulfilled.   
 
The following report will be displayed:   The "Shortage"   will be the total from Kit Shortages, etc;  the "OH Balance"   will be Available Inventory, and the "Not Available"  displays what the Balance or on-hand qty will be once the Purchase Order has been received, and Kit Shortages fulfilled.  (Multiple of 200 minus shortage of 100 and OH balance of 25 equals a balance of 125).  The report is assuming a head of time that the users will order the minimum/multiple buy qty's setup in the MRP info setup on that part.        
 
 

As Built Kit History form (Not Completed in SQL)

Select the appropriate radio on the right hand side of the screen: Customer, Product, or Work Order. Select the Customer from the drop down list. Select the Work Order from the drop down list.

Depress the OK button.

 

 

The following report will be displayed:

 

1.1.6. FAQs - Kitting & Shortage
Facts and Questions for the Kitting & Shortage Module
1.2. Inventory Allocation
1.2.1. Prerequisites for Inventory Allocation
Prerequisites Required for Entering a New Work Order Allocation:

After activation, "Kitting & Shortage Management" access for each user must be setup in the ManEx System Security module.  Users with “Supervisor Rights” will automatically have access.

A Work Order must exist and  be released.

The Item to be allocated must be on the products BOM.


The quantity to allocate must be available in stock (not already allocated).


The manufacturer allocated must be approved on the product BOM.


1.2.2. Introduction for Inventory Allocation

Inventory Allocation is used to allocate (reserve) quantities of existing items in stock or future Purchase Order deliveries to a Work Order or Project. This allocation prevents issuing the quantity reserved to any other use except the Work Order or Project specified. The allocation of existing inventory may be removed by un-allocation. Purchase Order Line Item allocations may be removed prior to receipt of the parts by editing the Purchase Order. After receipt of parts allocated by Purchase Order, the allocation may only be removed after the parts are in stock.

The Inventory Allocation module is designed to Add or Change an allocation of a particular part for a specific work order or Project. In essence, this feature will “reserve” the quantity specified for a particular Work Order or Project.

The user may find an existing allocation or add a new one. Also, the user may delete an existing allocation, thus freeing the quantity up for other Work Orders or Projects.

User cannot allocate from WO-WIP locations.  If we were to allow you to allocate parts from WO-WIP to a different work order, you would be unable to close the original work order.  If you want to allocate parts that are in WO-WIP, you will need to return the parts to the store room, then allocate. 

1.2.3. Fields & Definitions for Inventory Allocation
1.2.3.1. Inventory Allocation Screen

 

 

 Work Order This is the number assigned to the Work Order for the assembly of the product.
 Product Number/Rev

The number the user has assigned to the product and revision.

 Class The classification to which the product number belongs.
 Type The type within the classification to which the product number belongs.
Description  The description of the product. 

Part Number The Part Number of the part being allocated to the Work Order or Project
Revision The revision of the part being allocated to the Work Order or Project
Part Description The description of the part being allocated to the Work Order or Project 
Calculated Req Qty The Required qty for the Work Order or Project
Qty Kitted to Selected Request The qty that has been issued to the Work Order or Project
Qty Reserved for Selected Request The qty allocated to the Work Order or Project
Balance Required Qty The balance required for the Work Order or Project after Qty kitted and qty allocated
Part Class The classification to which the part being allocated belongs
Part Type The type within the classification to which the part being allocated belongs
Qty Allocated The qty allocated to the Work Order or Project

Del Alloc Check this box to de-allocate a part from this project or Work Order
Mfgr Part No The manufacturer part number
Mfgr The manufactuere name
Warehouse The warehouse where the parts are located 
Location The location in the warehouse where the parts are located
Available Qty Available quantity in inventory
Allocated Qty The Qty allocated to the Work Order or project listed
Balance Qty Available Available quantity after allocation
Serial Number The Serial numbers located to the project or Work Order listed
Lot Code The Lot Code allocated to the project or Work Order listed
Exp Date The expiration date for the Lot Code
Reference The Lot Code reference name or number
PO Number The Purchase Order number of the order
Save Date/Time The Date and Time the allocation was saved
Initials The intials of the person saving the allocation







 

1.2.4. How To ..... for Inventory Allocation
1.2.4.1. Find an Inventory Allocation

Enter the SQLMANEX.EXE (within the ManEx root directory)
This action will then prompt the user for a password

The following screen will be displayed, select Inventory Management/Kitting, Allocating & Shortage Management/Inventory Allocation

 

 

The following screen will be displayed:


Find an Inventory Allocation

Depress the Find button . The following selection will be presented:

You have the option to find allocations based on Work order Number, Part Number, or Project Number.    

If you do not know the exact number, Customer, etc you may enter in a partial number, letter, etc, then once you depress the enter key the system will pull up the matching record onto the screen or a list of all Sales Orders that contain the partial number, letter, etc. entered, to select from.
 

For the selections entered into the find criteria screen, the allocations will display in the bottom of the screen for the highlight part number.
 

1.2.4.2. Add a New Inventory Allocation

Enter the SQLMANEX.EXE (within the ManEx root directory)
This action will then prompt the user for a password

The following screen will be displayed, select Inventory Management/Kitting, Allocating & Shortage Management/Inventory Allocation Module 

 

The following screen will be displayed:

Depress the Add record action button and the following selection.

Select “Work Order Allocation” or "Project Allocation" button.
 
Once the type has been selected user will be prompt for their password:
 

After entering a password, the following screen will appear when selecting "Work Order Allocation (a similar screen will appear if you select "Project Allocation"):



Select the Desired Work Order and the following prompt will appear:





If you select “YES” then all available inventory will be allocated automatically to the selected work order. Edit any quantities allocated by selecting the Part Number (highlighted) in the upper screen table and changing the Alloc Qty for the desired manufacturer in the lower part of the screen. Save after all allocation editing has been completed.

If you select “NO” then the system will list out all parts used within the Work order (per BOM) and require the users to go through and manually allocate inventory to each desired part.
 
Particulars regarding that Work Order will populate the screen as displayed below:

Highlight the desired part number you want to allocate. Only Approved AVL information for that particular part will populate the lower portion of the screen.

  1. Enter the amount you want to allocate in the Alloc Qty column.
  2. Once all parts have been allocated, depress the Save record action button.   



Note: 
The Inventory Master should have automatically updated, and will now display the amount allocated (“reserved”).
 
 
 
1.2.4.3. Change the Allocation Quantity

Find a Record



Depress the Edit button, highlight the desired part and modify the Allocated Qty in the lower grid 





Depress the Save record action button. 



The program will unallocate all original qty and allocate the new quantity again.  This will create two records in the Inventory Transaction report

 

 

 

1.2.4.4. Un-Allocate an Allocation

Find a record




Depress the Edit button and enter password.
 
To Un-allocate an allocation, thus freeing up the amount allocated to a Work Order or Project, user then must depress the Delete/Unallocate button:



User will then be prompt for a password, after entering a password the following prompt will be displayed (which is defaulted to "No")  giving the user the option to un-allocate parts automatically:




Selecting "No" will allow user to select which items to un-allocate
Selecting "Yes' will unallocate all items on screen automatically


Highlight the desired part number and then Check mark which items you wish to un-allocate.
 
 
 
Depress the Save record action button and any marked item should now be unallocated and be considered available inventory.  Note: For reports on Allocated Inventory, please refer to the ICM reports