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 |
Initials 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 |
Initials of person who changed kit status to "Kit in Process" |
Check when Kit Completed |
Date and Time when Kit Complete box was checked |
By |
Initials of person who checked the Kit Complete box |
Component Section - NOTE: Items will appear on screen only if the "Used in Kit" on the BOM is "Y". For further detail see Article #34.
|
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 |
The user may sort by Date, Supplier, PO Number or Manufacturer by depressing any of those buttons. |
|
|
The Inventory button will display on hand and location information for the part highlighted, as shown below |
|
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-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.1.4. How To ..... for Kitting & Shortage |
1.1.4.1. Finding a Work Order Record |
Enter Inventory Mgt/Kitting, Allocating & Shortage Management/Kitting & Shortage Management.
|
|
The following screen will appear:
Depress the Find action button the following screen will appear.
The user is prompted to search by Work Order Number, Product Number, Customer Name or Sales Order Number.
|
|
If you select by Work Order Number the following screen will appear.
Type the work order number in the red box, or highlight the work order number and double click to select.
|
|
If you select by Product Number the following screen will appear.
Type the part number in the red box, or highlight the part number and double click to select.
After selecting the product number, a screen is displayed listing work orders for the selected product.
|
|
Type the work order number in the red box, or highlight the work order number and double click to select.
|
|
If you select by Customer Name the following screen will appear.
Type the customer name in the red box, or highlight the customer name and double click to select.
After selecting the customer name, a screen is displayed listing work orders for the selected customer
|
|
Type the work order number in the red box, or highlight the work order number and double click to select.
|
|
If you select by Sales Order Number the following screen will appear.
Type the sales order number in the red box, or highlight the sales order number and double click to select.
After selecting the sales order number, a screen is displayed listing work orders for the selected sales order
|
|
Type the work order number in the red box, or highlight the work order number and double click to select.
|
|
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 | 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 and typing in the password will bring up this selection screen:
Depress the "YES" button and user will be presented with this screen: (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 type in the password the Issue Tab screen is displayed:
|
|
This screen is divided into four operational sections.
The left side of the screen will show the kit status, or 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 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 inventory status of 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/mfg. part number, kit qty, over issued qty, and lot code for the work order. |
|
In the lower right side of the screen, Mfgr part number, Lot code information, Part Class, Type, source, Work Center, and Description, about the inventory part highlighted in the upper right side of the screen, along with the Product number and Revision.
|
|
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 3 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 Prooduction 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.
AUTO KIT
If you select Auto Kit, user must enter in a password, and the parts will 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 from Approved AVL's then 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 .
COMPLETING KIT
|
1.1.4.3. Add a Line Item Shortage |
Pressing the Add Button (after finding a work order) 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) the user may type in the Part Number, Revision and Description and then select Source, Class, Type, Department and Reason from the respective Drop Down lists. The user may type in the Quantity and Quantity/Unit.
If you select Add Line Shortages, you will be prompted for your password and then the following screen will appear: (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. Type in the Quantity and the Quantity per Unit. Note: Shortages recorded by Ref Designator are case sensitive.
If the part is already on the Bill of Material, the work center may be selected. Otherwise, it is left blank.
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 appear:
Type in the Part Number, Revision and Description. Select Source, Class, Type, Department, Reason from the respective Drop Down lists. Type 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 part has been pulled 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.
The following message will appear:
Depress the OK button.
The item will disappear.
|
|
|
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 upon closing.
Highlight the item. The system will default in the issued qty into the Issue WO field (bottom screen). 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 (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 |
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:
For the situation where the user has created a line shortage, before the Work Order has been completed (reached the Finished Goods Inventory Work Center in Production), the user has the option of returning the unused components which were over-issued to the Work Order back into Inventory.
Using the Finding a Kitting & Shortage procedure, find the Work Order with the over-issue (remembering to select ALL). You will note that the shortage column contains a negative amount, as shown in the screen below:
-
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.
- Type in the corrected amount of picked quantity that was actually used in the assembly.
- Depress the Enter key. The actual over-issue will display. As shown in screen displayed.
Depress the Save action button. The difference between the original over-issue and the actual overissue 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).
Method 2:
This method covers the situation where the user has a reel of 750 parts and he/she doesn't want to count out 500 for the Work Order. All of the 750 is issued by clicking on the quantity in the lower right hand screen of the Issue tab and changing the amount to 750. (Please refer to procedures above regarding the Issue tab.) Then the system will over-issue 250 parts to the Work Order.
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 next Work Order, or returned to stock, as follows:
Using the Finding a Kitting & Shortage procedure, find the Work Order with the over-issue (remembering to select ALL).
- 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, 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, if the parts still have other locations available, the code only lets the user return back to those locations. The system will list all the available locations for the same manufacturere but not "WIP", "WO-WIP" and "MRB" locations for user to return. It will only "un-delete" a location if NO other locations are available. It defaults all items to have the over-issue qty returned to stock to the default warehouse. 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.
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, select the Print button from the ManEx action buttons at the top of the screen.
The following screen will appear:
Select the appropriate radio for the output format you desire: Screen, Printer, XL File, TXT File, or PDF.
Highlight the desired report and then depress the Option tab if applicable.
|
|
Kit Material Availability W/AVL Detail report
Select the appropriate radio on the right hand side of the screen: Customer, Product, Work Order or Simulation. Select the Customer from the drop down list. Select the Work Order from the drop down list. Check the Ignore Scrap check box to exclude Scrap % and/or Setup Scrap from the report. If these boxes are unchecked the report will include the Scrap % and Setup Scrap quantitys if they exist within inventory (regardless of the BOM setup).
Depress the OK button.
|
|
The following report will be displayed:
For simulation, select the Product Number from the drop down list. Select the quantity to simulate. Enter OK and the following report will print.
Kit Pick List Work Sheet report
Select the appropriate radio on the right hand side of the screen: Customer, Product, or Work Order. Select the Work Center and depress the > button. If you want all work centers, depress the >> button. Select the Work Order by highlighting and depress the > button. If you want all of the Work Orders, depress the >> button. Check the Ignore Scrap check box to exclude Scrap % and/or Setup Scrap from the report. If these boxes are unchecked the report will include the Scrap % and Setup Scrap quantitys if they exist within inventory (regardless of the BOM setup). Check or uncheck the radio's "Suppress Locations with 0 qty" and/or "Suppress Not Used in Kit Items" for the report to display these items or not. These radios can be setup to default in checked or unchecked within the Inventory Part Class and Type Setup .
This report displays the requirements (from the original BOM) for the selected work order. This report will NOT display any added Line Item Shortages. The added line item shortages can be viewed on the Work Order Shortage report.
Depress the OK button.
|
|
The following report will be displayed:
Part Labels or Part Labels with Ref Designators
Highlighting the Part Labels or Part Labels with Ref Designators 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.
Type in the qty of labels required and depress OK.
|
|
The labels printed will appear like this:
|
|
Box Labels
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
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.
Depress the OK button.
|
|
The following report will be displayed:
Work Order Kit & Shortage Issued Material History
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
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
Depress the OK button.
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 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
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:
Buildable report or Buildable Report with Top Three Shortages
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 Work Order Released box MUST be checked for this report to work properly.
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, mark the radial for 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
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.
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
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.2. WO Kitting Schedule |
Enter the Inventory Mgmt/Kitting, Allocating & Shortage Management/WO Kitting Schedule
Note: 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.
|
|
The WO Kitting Schedule displays the Required Date, the Work Order Number, the Assembly Part Number and Revision, Assembly Description, the Quantity to be kitted, the number of components in each kit, and the number of days late.
Selectr the appropriate radial to display "ALL" open un-kitted WO's, "BOM's only", or "Released WO" records only. The user may sort by Required Date, Work Order Number, Part Number or Kit Quantity by depressing the appropriate button.
WO Kitting Schedule field definitions
Required Date |
This date is based on the Due Date, along with the Kitting and Production Lead Times setup in Inventory Control Management Module |
Work Order Number |
The number assigned to the Work Order (job).
|
Part Number |
The number assigned to the completed assembly. |
Rev |
The number of the revision assigned to the completed assembly.
|
Description |
The description of the completed assembly |
Kit Quantity |
The quantity to be kitted |
Days Late |
The number of scheduled workdays between the due date and today’s date.
|
NO of BOM item |
This is the number of items on a BOM for a particular WO. The count is based off of the top level assembly only and DOES include Obsolete and Active parts. Note: This does include Phantom and Phantom/Make components but does not include the parts on the Phantom BOM's. |
|
1.3. WO Shortage Summary List |
Enter Inventory Mgmt/Kitting, Allocating & Shortage Management/Work Order Shortage Summary List
Note: A fter 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.
This screen provides complete visibility of component shortages by Work Order, Work Center, and Part Number. Users can also check the current status of on hand inventory and open orders for a selected part.
|
|
The following screen will appear:
The Work Order Shortage Tab
The first screen displayed is the Work Order Shortage Tab. This tab displays open Work Orders which have at least some components pulled and these pulled components are in Work In Process. The user may sort by Work Order Number, Part Number or Due Date by depressing the appropriate button.
Work Order Shortage field definitions
Work Order Number |
The number assigned to the Work Order (job). |
Part Number |
The number assigned to the completed assembly. |
Rev |
The number/letter of the revision assigned to the completed assembly. |
Description |
The description of the completed assembly. |
Due Date |
The Date the Work Order is to be completed. |
Work Order Quantity |
The quantity of the product to be assembled for that Work Order. |
Completed Quantity |
The quantity of that product already assembled. |
WIP Quantity |
The quantity of that product where at least some of the components are in Work In Process. |
To view the shortage, highlight one of the Work Orders and depress the Shortage button (at the bottom of the screen). The following additional information will display: |
|
Shortage Button field definitions
Misc |
An “M” in the field means that a miscellaneous shortage was added to the Kit. |
WC ID |
The Work Center 4 digit identification |
Part Number |
Component Part Number |
Rev |
Component Revision, if applicable |
Unit |
The Unit of Measure |
Short Qty |
The Quantity Short |
# Unit |
The number of units that the short quantity represents |
Part Source |
Buy, Make, etc. |
Work Center Shortage Tab
Selecting the Work Center Shortage tab will bring up the following screen:
Pressing on the Work Center field down arrow will display the component shortage by Work Center.
Press on the down arrow in the Work Center box. The following list of Work Centers will display:
Select the appropriate Work Center. Once that is selected, the user may sort by Work Order Number or Part Number by depressing on the appropriate button.
|
|
Work Center Shortage field definitions
M |
If this column is marked with the letter “M”, this represents a Miscellaneous Shortage |
Work Order Number |
The number assigned to the Work Order (job). |
Part Number |
The number assigned to the component part. |
Rev |
The number of the revision assigned to the part. |
Class |
The classification for that part |
Type |
The type of part. |
Description |
The description of the part. |
Short |
The number of units still needed for the Work Order |
|
Highlight the part number of interest. Depress the Open PO button |
The following list becomes available.
The user may sort by PO Date, Supplier name, PO Number or name of manufacturer by depressing the appropriate button.
|
|
|
Highlight the Part Number of interest. Depress the Inventory Status button
|
Information regarding the highlighted part number will display, showing current Warehouse, Location, quantity On Hand, quantity Allocated, quantity Available, Manufacturer name and Manufacturer Part Number. |
|
Part Number Shortage Tab
Selecting the Part Number Shortage tab will bring up the following screen:
This is a list of component part numbers where shortages exist.
Part Number Shortage field definitions
Top of Screen
Part Number |
The number assigned to the component part. |
Rev |
The number of the revision assigned to the part |
Class |
The classification for that part |
Type |
The type of part. |
Description |
The description of the part. |
Bottom of Screen (for the part number highlighted)
Work Order Number |
The number assigned to the Work Order (job) |
Work Center |
The name of the Work Center where the shortage exists. |
/Unit |
The unit of measure for the part number highlighted. |
Short Qty |
The number of units still needed for the Work Order. |
# Unit |
The /Unit multiplied by the Short Qty. |
|
Highlight the part number of interest. Depress the Open PO button |
The following list becomes available.
The user may sort by PO Date, Supplier name, PO Number or name of manufacturer by depressing the appropriate button.
|
|
|
Highlight the Part Number of interest. Depress the Inventory Status button
|
Information regarding the highlighted part number will display, showing current Warehouse, Location, quantity On Hand, quantity Allocated, quantity Available, Manufacturer name and Manufacturer Part Number. |
|
Work Order Shortage Summary List Reports
Open the tab for which you want the report. Depress the Reports button. Send the report to the appropriate printer. A printed copy of the screen you’ve selected will be available.
|
1.4. Inventory Allocation |
1.4.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.4.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.4.3. Fields & Definitions for Inventory Allocation |
1.4.3.1. Allocation Tab |
Customer Name |
This is the Name of the Customer. |
Project Description |
The description for the project. |
Project |
Project name or number. |
Work Order |
This is the number assigned to the Work Order for the assembly of the product. |
Sales Order |
This is the number assigned to the Sales Order.
|
Part Number |
The number the user has assigned to the part or product.
|
Rev |
The revision number pertaining to the part number |
Allocated |
Qty allocated to the WO or project listed. |
Class |
The classification to which the part number belongs. |
Type |
The type within the classification to which the part number belongs. |
Description |
The description of the part number. |
Inventory Locations - User has the ability to sort by Mfgr, Warehouse, Serial #, or Lot Code. Click on the blue header and the header color will change to Red and sort by that column.
Mfgr |
The manufacturer for the part. |
Mfgr Part No |
The commercial part number.
|
Warehouse |
The warehouse to which the purchase will be assigned when received.
|
Location |
The location in the warehouse to which the purchase will be assigned when received.
|
Alloc Qty |
Qty allocated to the WO or project listed. |
Serial # |
Serial numbers allocated to the project or WO listed. |
Lot Code |
Lot code allocated to the project or WO listed. |
Reference |
Lot code reference name or number. |
Exp Date |
Expiration date for the Lot Code. |
PO Number |
The Purchase Order number of the order. |
|
1.4.3.2. Allocation Maintenance |
Fields & Definitions
Header Fields and Defintions
Project No |
The project number the parts are being allocated to |
Customer |
The Customer the parts are being allocated to |
Project Description |
The project description the parts are being allocated to |
Part Number
|
The number the user has assigned to the part or product.
|
Rev
|
The revision number pertaining to the part number
|
Source
|
Make or Buy part
|
Class
|
The classification to which the part number belongs.
|
Type
|
The type within the classification to which the part number belongs.
|
Description
|
The description of the part number.
|
Qty Req
|
Qty needed for WO or Project
|
|
Depress this button to allocate a part to the project listed in the header |
|
Depress this button to de-allocate a part from this project |
|
This button will only be visable under the Project Allocation. When the screen is displayed and no parts have been allocated yet, the "Allocate All" button will be displayed. Upon depressing this button all records will be automatically allocated to the project. Then the button will change to "DeAllocate All" and if depressed all records would then be de-allocated from the project. |
Mfgr
|
The manufacturer for the part.
|
MPN
|
The commercial part number.
|
Warehouse
|
The warehouse to which the purchase will be assigned when received.
|
Location
|
The location in the warehouse to which the purchase will be assigned when received.
|
Avail Qty
|
Available quantity in inventory
|
Avail Qty Now
|
Available quantity in inventory after allocation
|
Alloc Qty
|
Qty allocated to the WO or project listed. 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.
|
Serial #
|
Serial numbers allocated to the project or WO listed.
|
Lot Code
|
Lot code allocated to the project or WO listed.
|
Exp Date
|
Expiration date for the Lot Code.
|
Reference
|
Lot code reference name or number.
|
PO #
|
The Purchase Order number of the order.
|
|
1.4.4. How To ..... for Inventory Allocation |
1.4.4.1. Find an Inventory Allocation |
To access this module, select Inventory Mgmt/Kitting, Allocating & Shortage Management/Inventory Allocation
|
|
The main screen will appear:
Find an Inventory Allocation
Depress the Find button . The following selection will be presented:
If you now the specific part number or range of numbers you are interested in, enter it into the Part number Range fields.
You also have the option to find allocations based on Projects, Work orders, Sales Order or Customer Name |
|
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.4.4.2. Add a New Inventory Allocation |
Enter Inventory Mgmt/Kitting, Allocating & Shortage Management/Inventory Allocation Module |
|
The following screen will appear:
Depress the Allocation Maintenance tab
Depress the Add record action button and type in your password will bring up the following selection.
Depress the “Work Order Allocation” button.
|
|
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 part used within the Work order (per BOM) and require the users to go through and manually allocate inventory to each desired part.
|
|
The following Work Order selection screen will then become available. Select the desired work order by Typing in the Work Order Number or highlight the Work Order and double click.
|
|
Particulars regarding that Work Order will populate the screen as displayed below:
- Highlight the desired part number you want to allocate. Inventory AVL information for that particular part will populate the lower portion of the screen.
- Type in the amount you want to allocate in the Alloc Qty column.
- Depress the Save record action button. The screen will update as follows:
Note that the Avail Qty column has updated to reflect the amount allocated. The Inventory Master has also automatically updated, and will now display the amount allocated (“reserved”).
|
1.4.4.3. Change the Allocation Quantity |
To Change the allocation qty, thus freeing up the amount allocated to a Work Order or Project, first go to the Allocation Maintenance screen.
Depress the Edit Record button.
The following find record options will be displayed
|
|
If you had selected to find per Work Order or Project the following screen will appear which lists all open WO numbers or project numbers with allocations.
Type the WO or project number in the red box or double click on the number and the screen below will appear with the allocation information listed.
|
|
The following screen will appear, and the user will be allowed to modify the Alloc Qty.
Highlight the desired part number and modify the Alloc Qty.
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.4.4.4. Un-Allocate an Allocation |
To Un-allocate an allocation, thus freeing up the amount allocated to a Work Order or Project, first go to the Allocation Maintenance screen.
Depress the Edit Record button.
The following find record options will be displayed
|
|
If you had selected to find per Work Order or Project the following screen will appear which lists all open WO numbers or project numbers with allocations.
Type the WO or project number in the red box or double click on the number and the screen below will appear with the allocation information listed.
|
|
Depress the Delete button.
Enter your password and the following prompt will appear which is defaulted to "No"
“No” will allow you to select which ones to un-allocate individually
Yes” will un-allocate 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.
If you had selected to find by Part Number the following screen will appear which lists all Part Numbers with allocations.
Type the Part number in the red box or double click on the number and the screen below will appear with the allocation information listed.
|
|
Depress the Delete button.
Enter your password and the following prompt will appear
YES” will un-allocate all items on screen automatically
“No” will allow you to select which ones to un-allocate individually
|
|
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.
The Inventory Control Item Master will update automatically. Note: For reports on Allocated Inventory, please refer to the ICM reports
|
|