1. Kitting & Shortage Management |
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.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.3. Fields & Definitions for Kitting & Shortage |
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
|
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.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.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.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-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. 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.4. How To ..... for Kitting & Shortage |
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.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:
- User has a Pull Cart with a wireless laptop along with a wireless label printer.
-
The barcode scanner will be hooked to the laptop.
-
User takes the Kit Pick Worksheets with the items needed to be pulled.
-
Goes down the isles and scans the part being pulled and enters in the pick qty.
-
Then depresses the Next button. That record will be saved immediately.
-
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).
-
Continue going through pulling parts for that kit as you go through the isles.
-
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.
|
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.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.4.5. De-Kit |
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.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.
|
|
-
Depress the Edit action button. The following selection will appear:
- Select the Issue Parts option.
- Enter password.
|
|
- Highlight the Part Number with the negative shortage.
- Move the cursor into the Pick Quantity field.
- 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).
- 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.
- Open the Utility tab.
- 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.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.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.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 -
NOTE: The 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
NOTE: This 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
NOTE: The 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
NOTE: The 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 depress 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:
|
|