1. Inventory Management
1.1. Packing List Management (PL)
1.1.1. Packing List Management
1.1.1.1. Prerequisites for Packing List Mgmt
Prerequisites for Entering a New Packing List: 

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

A Sales Order

The packing normally refers to a Sales Order, which includes the part numbers and description of the material being shipped.  Also, the Sales Order must have been approved for shipment by placing a check in the Order Acknowledgment box.  There is also provision for a stand-alone packing list (manual invoice).

Packing List Numbering

The Number System Setup must be defined for either automatic or manual packing list numbers.

Serial Numbers

If the order involves serial numbers, such numbers must have been set up in Work Order Serial Number Control.    

 

1.1.1.2. Introduction for Packing List Mgmt

The Packing List Module is used to record the details of shipments to customers.

The Packing List is created when the user has completed assembly, or pulled parts for an order and the order is scheduled to ship. There is also provision for a stand-alone (manual invoice) packing list.

Note:  In order to initiate the packing list, the Sales Order MUST have the Order Acknowledgment box checked, indicating that it is OK to ship the product to the customer.  For further Detail See Article #1150.

1.1.1.3. Fields & Definitions for Packing List Mgmt
1.1.1.3.1. Packing List Tab

 

 

Packing List tab field definitions

Customer   The name of the Customer
Ship To

The address where the shipment was delivered

Attention

The Customer’s contact

Ship Via

How the shipment was transported

Freight

Whether or not freight will be charged to the Customer

FOB

The point at which title passes

Terms

The payment terms the user has for the Customer

Frt Amt

The amount of freight the user charged the customer

Waybill

The number of the waybill as assigned by the carrier

P/L Number

The number of the Packing List

Packing List Date

The date of the packing list

Sales Order

The number of the Sales Order

Purchase Order

This is the Customer’s Purchase Order number

Customer Acct # This is the Customers Acct #

Sales Order Acknowledgement

If this box is checked, the Sales Order has been acknowledged.(If this box is NOT checked, go back into the Sales order module and acknowledge the order)

Credit

The customer’s credit status with the user

Entered by The initials of the user who entered the Packing List

1.1.1.3.2. Detail Tab

Detail tab field definitions

Customer

The name of the Customer.

P/L Number

The number assigned to the packing list.

Ln

The Sales Order Line item number.

Part Number

The number the user has assigned to the product.

Rev

The revision number applicable to the Part Number.

Class

The classification to which the Part Number belongs.

Type The type within the classification
Qty

The number of units shipped with this Packing List.  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.

Back Order

The number of units still not shipped.

Description

The description of the product.

UOM

The unit of measure for the product.

Shipped Rev

If the Packing List is revised, the revision number will appear in this field.

Serial Number Entry This is the list of Serial Numbers shipped on this Packing List .For a discussion on how to enter serial numbers, see section below on Serial Number Entry.

Buttons

If there is a Sales Order associated with the shipment, depressing this button will display the Sales Order line items for the user to select for this shipment.

Depressing this button will allow the user to add a manual item to the Packing List.

Highlighting a line item and depressing this button will delete the line.

This button is depressed to enter Sets of Serial numbers to ship 

 

For the line item highlighted, this field is for any applicable notes.

1.1.1.3.3. Ship Instruction Tab

 

Shipping Instructions Tab Detail

This tab is used for special instructions regarding the shipment.  This information defaults in from the Customer Info module.

1.1.1.3.4. History Tab

 

History tab field definitions

Sales Order Shipping History

This section displays the Ship Date, Ship Via, Way Bill number, Line Number, Class, Part No. Rev., Description and Ship Quantity for this packing list.It also displays the Ship History of the Part by displaying the Packing List number and the Ship Quantity.

Packing List Adjustment Log

This section displays any packing list adjustments for this packing list and details the Date, Class, Description, Part Number, Rev., and Shipped Qty.

1.1.1.3.5. Notes Tab

Notes tab field definitions

Sales Order Note

This section will display any note pertaining to the Sales Order.

Packing List Footnote

This section is for any packing list footnotes which will appear when the Packing List is printed.

1.1.1.4. How To ..... for Packing List Mgmt
1.1.1.4.1. Find an Existing Packing List
Enter Inventory Mgt/Packing List Management/Packing List Management

The following screen will appear.  When the screen first opens, the user is limited to only four of the seven action buttons shown: Find an existing Packing List, Add a new Packing List record,  Print a packing list or report, and Exit.

Pressing the Find Button displays the following sequences: 

 

If the user elects to find a packing list by the Packing List Number, a screen appears listing Packing lists in numerical order, along with the Customer Name, Sales Order Number, and Ship Date. The user selects the packing list by either entering it into the red box, or scrolling down the list and clicking on the selected order.

The Packing List screen is populated with the appropriate data.

 

If the user elects to find a packing list by the Customer, a screen appears listing Customers. The user selects the customer by either entering it into the red box, or scrolling down the list and clicking on the selected Customer.

 

Then a list of all of the selected Customer orders are shown in numerical order, along with the Customer Name, Sales Order Number, and Ship Date. The user selects the packing list by either entering it into the red box, or scrolling down the list and clicking on the selected order.

The Packing List screen is populated with the appropriate data.

 

If the user elects to find a packing list by the Sales Order Number, a screen appears listing open orders in numerical order, by Sales Order, Customer Name, and Customer PO Number. The user selects the Sales Order by either entering it into the red box, or scrolling down the list and clicking on the selected order.

The Packing List screen is populated with the appropriate data.

 

If the user elects to find a packing list by Posted or Unposted, a screen appears listing Packing Lists in numerical order, along with the Customer Name, Sales Order Number, and Ship Date. The user selects the packing list by either entering it into the red box, or scrolling down the list and clicking on the selected order.

The Packing List screen is populated with the appropriate data.

 

If the user elects to find a Packing List by Product Number, a screen appears listing  Part Number, Rev, Class, Type and Description.  Type the Part Number into the red box or highlight your selection and double click.

 

Then a list of all the Packing List Numbers, for that product will appear, along with the Customer,  Sales Order and Ship Date.  Type the Packing List number into the red box or highlight your selection and double click.

The Packing List screen is populated with the appropriate data.

 
 

1.1.1.4.2. Add a New Packing List
Enter Inventory Mgt/Packing List Management/Packing List Management

The following screen will appear.  When the screen first opens, the user is limited to only four of the seven action buttons shown: Find an existing Packing List, Add a new Packing List record,  Print a packing list or report, and Exit.

Pressing the Add Button displays the following sequences: 

 

If the user elects to add by Sales Order, a screen appears listing Open Sales Orders in numerical order, along with the Customer Name, Customer PO, and if applicable the  RMA number. The user selects the Sales Order number by either entering it into the red box, or scrolling down the list and clicking on the selected order.

 

 

If the user elects to add by Sales Order/Customer, a screen appears listing Customers.  The user selects the customer by either entering it into the red box, or scrolling down the list and clicking on the selected Customer.

Decide between Active or Inactive customer by checking the appropriate box. Type in the Customer name or highlight the customer and double click to select.

 

Then a list of all of the selected Customer Sales orders are shown in numerical order, along with the Customer Name, Customer PO, and RMA number (If applicable). The user selects the Sales Order by either entering it into the red box, or scrolling down the list and clicking on the selected order.

 

If the user elects to add by Stand Alone, a screen appears listing Customers.  The user selects the customer by either entering it into the red box, or scrolling down the list and clicking on the selected Customer.

Decide between Active or Inactive customer by checking the appropriate box. Type in the Customer name or highlight the customer and double click to select.

See procedures below to Add a Stand Alone Packing List (Manual Invoice).

 

Once the Sales Order selection has been made, the Packing List screen is popluated with the appropriate data based on the default shipping destination established for the customer selected:

If Manual is selected for Packing List numbers in Number System Setup user will need to enter P/L No.

If the customer has multiple ship-to addresses established, then pressing on the down-arrow button to the right of the field will display alternate shipping destinations. Selecting an alternate shipping destination will cause the default values shown on the screen to change and match those of the selected destination.

Move cursor to the Frt Amt (Freight Amount) field. The user may then enter the amount of the freight charges for the shipment. (These may also be entered during the invoicing, if the freight amounts are not yet known).

The user may also enter the Waybill number. This is the tracking number used by the freight carrier to identify and track (and bill) the shipment. The Ship Via, Freight and FOB fields are populated with the default information from the customer ship-to files, but the user may select alternate actions by pressing on the down-arrow on the right side of the field. (The choices shown at this point must have been established in the System Setup/Sales)

After completing the Packing List information screen, the user clicks on the Detail Tab

In this screen, the user defines the material to be shipped.

The user may choose from one of the directive buttons to proceed:

If the user has selected the Add Sales Order Item(s) option, and user receives the following message, it may be due to the status of the line item on the SO.  If the line item Status on the Sales order is "Admin Hold"  or "Mfgr Hold"   you will receive the following message when creating the PL.




If the user has selected the Add Sales Order Item(s) option, (data can automatically be completed in this screen) the following screen will appear:

Highlight the appropriate Sales Order line item.  Depress the OK button and the sales order line item(s) will populate the detail screen.

The user will note that each item defined on the sales order is added to the packing list, and the Quantity is at zero. If the sales order has many lines and only a few are NOT being shipped, then the user can add them all, and delete the lines that do not apply. The user then completes the quantity column with the amount of product shipped for this packing list.
 
The following message will appear if the part requires a certificate and the "Done" box has NOT be checked.  The packing list will NOT be allowed to be saved until checking off the certificate required "Done" box.  
 
 
 
The following message will appear if the user is attempting to ship product out of FGI that was not originally transfered into FGI from a Work order that was associated to that Sales order.  This is just a warning that you will be releaving stock that was transfered into FGI from a Work order that was associated to a different Sales order, and is asking the user if they are sure that is what they want to do?  It does not hurt anything to answer yes, the only thing that might happen later down the road is the product that you had transfered  into FGI from a different sales order has already been shipped against this Sales order or packing list. 
 

Depress the Yes button. 

 If the user attempts to ship a product with no or not enough available inventory, ManEx advises the user and prompts to cancel the transaction.

TIP Users may modify the appearance of the columns on the spread sheet by click and holding on the column header description, and slide the description to the right or left, then releasing the mouse button. The width of the columns may also be modified by click and holding on the right edge of the column header and sliding the border right or left.

As the user completes a quantity shipped, ManEx produces an inventory allocation table displaying the available and reserved inventory on hand for the product being shipped if there is more than one location. If the Sales Order allocated product for this order, the quantity will be shown in the Reserved Qty column.

Enter Ship Qty.

If the product and the work order were identified as requiring serial numbers and there are no products available in inventory with the appropriate serial numbers, the following message will display:

Depress the OK button.  The transaction will be cancelled.

If the product and the work order were identified as requiring serial numbers and there is product available in inventory the following screen will display:

Use the > or >> button to move the Serial Number into the Ship Prepared Serial Number column. Depress the OK button. The serial numbers will display in the Serial Number Entry window. The serial numbers will print on the packing list.

 
 
If user receives the following message when trying to ship out parts:
 
 
The user may return to the SO, depress the Edit button and double click on the Order Qty  field.  The available MFGRs will be listed and the users can make the needed changes.
 
 
Return to the Packing List module and the record can then be processed.  

If the user selects Add manual item, the user will be prompted for the sales type:

Depress the down arrow for Sales Type and the following list will appear:

Highlight and click on the Sales Type of Interest and the following screen will appear:

The Revenue GL number and the Cost GL number will update. Note:  When creating Stand Alone Invoices users should not select the same GL account number that is entered in the Actsetup for the Account Receivables.  IF you do, then the resulting transaction will debit and credit both the sane GL account number.   Depress the OK button.

The user will be prompted for Quantity, Back Order amount, Description and Units of Measure.

The user may enter notes of any length for a line item by highlighting the appropriate line item and then selecting the Item Note.

If the user wishes to establish shipping instructions, then pressing on the screen tab Ship Inst will bring up the following screen.


Tabbing on the History tab will bring up the following:

This will give you the Shipping Historyof the Part highlighted in the Detail screen.

In addition to special notes to the shipping department, tabbing to the Notes screen, there are two additional areas for notes: the Sales Order Notes, and the Packing List Footnotes. The Sales Order Notes will be maintained in the ManEx system for review by other users, and the Packing List Footnotes will be added to the packing list when printed. 

When the user has completed all of the information needed for the packing list, the information must be saved.

Note: The Packing List MUST be printed for the shipping information to advance to Invoice Administration.

If the user has set the system setup to Manual Invoice numbering, then ManEx will prompt for the invoice number to be used for the packing list.

If automatic numbering is used in the setup, then ManEx will supply the invoice number, and close the screen.

Hold for Credit Limit

If the user has elected Enforce Credit Limit at Shipment feature in Accounts Receivable Defaults in Accounting Setup, the following message will appear if a non-supervisor attempts to ship:
 
 

The program gets the total Accounts Receivable (AR Aging) + Not Posted Invoice (invoice not printed out of the Admin/Invoice module) + Open SO Amounts.  Compares it to the Credit Limit setup in the Customer Information module.

This is based on having the "Include Open Orders for Credit Approvals for Shipping" option checked, (within the Print PL/Invoice setup module) (if you do not want to include open Sales Orders you would want to uncheck this option) and the "Enforce Credit Limit at Shipment" option checked, (within the Sales-A/R setup module)(uncheck this option if you do not want to Enforce the Credit Limit at Shipment). 

Make sure that these options are marked properly to get the results you are expecting.

Depress the OK button,  and enter a supervisor password or a password for a user with rights within the Security module, that has the ability to approve the credit limit exceed message. The following warning will appear:

To continue, select "Yes" to abandon select "No".

Add a Stand Alone Packing List  

Add by Stand Alone procedure is the ONLY way that a manual invoice can be created. 

If the user elects to add by Stand Alone, a screen appears listing Customers.  The user selects the customer by either entering it into the red box, or scrolling down the list and clicking on the selected Customer.

Decide between Active or Inactive customer by checking the appropriate box. Type in the Customer name or highlight the customer and double click to select.

Once the customer is selected, you will be prompted for your password.

The following screen will appear:

 

 

Go to the Detail Tab, and select Add manual item, the user will be prompted for the Credit G/L Number:

Depress the down arrow, select to Find By either Account Type or Account Numbers

If you select by Account Type, the GL Type box will be enabled.  Depress the down arrow next to the GL Type box and a list of accounts will appear. Select the desired GL Type.

Once the GL Type is selected the Account number box will be enabled.  Depress the down arrow next to the Account Numbers box, and only the G/L accounts within that range will appear.  Select the desired GL account number.

If you select by Account Numbers, the Account Numbers box will be enabled. Depress the down arrow next to the Account Numbers box, and the list of ALL of the G/L Account numbers will appear. Select the desired G/L account number.

The user will be prompted for Quantity, Back Order amount, Description and Units of Measure.

Finish the process as detailed above.

Note: The user may edit a Packing List up until the time that the Invoice is printed.After that, no edits are allowed.

1.1.1.4.3. Edit an Existing Packing List

Find
 a Packing List (Posted or Not-Posted).  Depress the Edit Action button.
 
Note:  Once a packing list is created user cannot remove it completely.  You can remove all line items except for one.  One item must remain on the packing list to save it.  If there is only one line item on the packing list user can reverse the shipped qty on the line item to 0, so it won't affect inventory counts and shipped qty against the Sales Order schedule(s).   Any packing list is editable until the invoice is posted.  Once the invoice has been posted the packing list is not longer editable. 


 
All fields available for editing will be enabled for modification.
 

Packing List tab The Ship to address, Attention, Ship Via, Freight, FOB, Terms, Freight Amount, Way Bill number and the Packing List date may be edited. 
Detail tab The user may add another sales order item, add a manual item, edit the qty on an existing item.
Ship Instructions The user may add/edit instructions
Notes tab

The user may add/edit notes.

At the conclusion of the modification process, the user may either press the Save button to save the changes or press the Cancel button to cancel changes.

The user may re-print the Packing List.

1.1.1.4.4. E-mail Packing List(s)
 To e-mail Packing List report(s), depress the Reports button. 

Note:
  You MUST have the e-mail setup within the Trigger.exe setup and working before the Packing List e-mail will work.   

The reports screen will appear:

Select the output XL File, TXT File, or PDF by clicking on the radial.

Check the Email box located int he left hand corner of the Reports Tab.  

Highlight the report you want to Email.

Depress the option tab.

 
 

Complete the Option tab with the information required:  Note:  User has the option to check the Email box on the Options screen also.

 

Depress OK.  The following screen will appear.  Select or Enter File Name. 

 

Depress Save, the following Check Email Addresses screen will appear.  Within this screen you can enter an e-mail address or add any special notes needed:

Depress OK and documents will be sent to e-mail addresses assigned. 

The following is what the receiver will receive:

 

1.1.1.5. Reports - Packing List Mgmt
To obtain the Packing List 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. 

PACKING LIST REPORT

Some of the radial options/info is defaulted from the Print Packing List/Invoice Setup

Click on the radial to choose to use either Preprinted Form, or Laser Form.

Type in number of copies to be printed.

Click on the radial to choose using internal part numbers or customer part numbers. 
 
Click on the radial to choose to show list of Un-printed Packing List, Single Packing List, or Reprint Last Batch.

If you want the report to show records with a zero Invoice Amount, check the box.   

Click on the radial to choose sort by, either Packing List, Sales Order, Customer, or Ship Via. 
 
If you want an additional Bar Code page printed along with the packing list that will contain Bar Code information for specific fields you would check the "Include Bar Code Addendum" box.

To select one Packing List, highlight the Packing List, depress the > button. If you want all Packing Lists, depress the >> button.

Depress the OK button.
 
(RMA) will appear next to the SO No.  If printed from an RMA.
 
If printing a Packing List report with SN's the leading zero's will be removed from report.

Mfgr and MPN will be listed on the Packing Slip report for Buy parts only. 
 
'C of C Required' will be displayed on the Packing List Report, only if the "Certificate Required" box is checked in Packing List.
 
 

The following is printed

SHIPPING REPORT

Highlighting the Shipping report brings up a further selection:

Highlight the desired selection, either by Sales Order, Customer, Packing List. 

Depress the Options tab will bring up the following screen:

 
 

You’ll be prompted for the date range. To clear the default selection, check the Clear Selection box. Enter the Sales Order Number.

Once selection is made, depress the OK button.

 

The following is printed:

SHIPPING HISTORY REPORT

Depress the OK button and the following will print:

SERIAL NUMBER SHIP HISTORY

Highlighting the Serial Number Ship History report brings up a further selection:

Highlight the desired selection, either by Packing List Number, Sales Order,  or Part Number.  

Depress the Options tab will bring up the following screen:

 

You’ll be prompted for the date range. To clear the default selection, check the Clear Selection box. 

To select one Part Number, highlight the part number and depress the > button. If you want all Part Numbers, depress the >> button.

 Once selection is made, depress the OK button.
 
The leading zero's for SN's will be removed from report.
 

The following will print:

SHIPPING LABEL 
 

Highlighting the Shipping Label brings up a further selection:

Highlight the desired print selection.   

Depress the Options tab will bring up the following screen:

User will be prompt the enter a Packing List Number, Number of Labels to be printed, and Item Number on Packing List. 

Once selection is made, depress the OK button.
 
Note:  ManEx uses the standard labels used in the UPS printers.
 

.

 

 

The following is printed:

 
SHIPPING LABEL  (AIAG)
 

Highlighting the Shipping Lable (AIAG) brings up a further selection:

Highlight the desired printer selection.   

Depress the Options tab will bring up the following screen:

User will be prompt the enter a Packing List Number, Number of Labels to be printed, and Item Number on Packing List. 

Once selection is made, depress the OK button.
 
 
 

.

 

 

The following is printed:
 
 
 
ProForma Invoice
 

User will be prompt the enter a Packing List Number.  

Once selection is made, depress the OK button.
 
The report form will look just like ProForma Invoice form that resides within the Sales Order module, except the one within the Packing List module will display the Actual Ship Qty that was entered for that highlighed packing list.  Printing this report does NOT update any accounting information.  It will also NOT flag the packing list record as printed/posted.
 
 
The following will print:
 
 
 
 
 
 
 
 
 
 
1.1.2. Sales Order Shipping Schedule

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



Enter Inventory Mgt/Packing List Management/Sales Order Shipping Schedule Module
 
.
 

 

The following screen will appear:

 

 

  

This is the listing of all open and unshipped Sales Orders.  The user may sort by Ship Date, Sales Order Number, Customer or Part Number by depressing the appropriate button.

 

Sales Order Shipping Requirements List Field Definitions

 

Ship Date

The due date of the Sales Order.

Sales Order Number  

The number assigned to the Sales Order.

Customer     

The name of the customer.

Part Number

The number assigned to the part.

Rev    

The number of the revision assigned to the part.      

Part Mfgr

The manufacturer name assigned to the part.  (This is only displayed if the "MAKE" item originates from a RMA order, or the item is a "BUY" or "MAKE_BUY") 
See Note below.

Mfgr Part Number

The  manufacturer part number assigned to the part.  (This is only displayed if the "MAKE" item originates from a RMA order, or the item is a "BUY" or "MAKE_BUY") See Note below.

Scheduled Quantity 

The quantity to be shipped for the Sales Order.

FGI Quantity       

The quantity currently in finished goods inventory.

 

 

NOTE:    In the SO Module, when a user enters the SO item, if the item is for a "BUY" or "MAKE_BUY" part the system will ask the user to select the part mfgr at this time because the system needs to know (and save) where the SO item is being created from.  For a "MAKE" the system does NOT need to know or save this information until the user creates the Packing List.  In the RMA module, the system needs to know which part mfgr the RMA item is going to be returned to, so the system saves the part mfgr for all RMA items.  This is why the Part Mfgr and Part Mfgr Part Number is only displayed if the "MAKE" item originates from a RMA order, or the SO item is a "BUY" or "MAKE_BUY".                    

                           

                                      

              

                   
1.2. Return Material Authorization (RMA) Receiver
1.2.1. Prerequisites for RMA Receiver

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


RMA Order Number

To add an RMA Receiver, there must be an open RMA Order established in the RMA Management module which has been acknowledged by the user. 

1.2.2. Introduction for RMA Receiver

The Return Material Authorization module notifies receiving to expect a return from a customer.

Once the material is received back from the Customer, this module is used to record the receipt, create the Re-Work Work Order, adds the product into the work order, and the applicable Credit Memo. Once the RMA is received, a Credit Memo automatically forwards to the Accounting Accounts Receivable Credit Memo module, if a dollar amount was entered for the return.

When the re-work/replacement is ready to re-ship, a Packing List and Invoice can be created.

Note:  When an RMA is created, both the pending receipt of the items from the customer and the subsequent shipment of replacement product to the customer are entered.  Reference is made to the original Sales Order and Invoice only to allow the Credit Memo (when created) to have a place to apply the credit.  Utilizing this approach, the user is free to set different schedules for receiving and/or shipping the material without affecting the original Sales Order.  It also allows the user to place different prices or costs on the line items.  For example, it may be that full credit is issued on the RMA receipt, but extra charges apply on the reshipment because of non-warranty issues.  Or the user may wish to have a “no-credit, no-charge” RMA policy where items are received and reshipped with no General Ledger affects.  Or, the receipts may be at no credit, but the return shipment includes only the rework charges.  Because of the variety of possibilities, trying to incorporate any of these actions into the original Sales order would make it really difficult to maintain data about the costs associated with the order.  This also permits the user to develop reports for on-time shipments, and shipping/scheduling quality. 
 
To review how an RMA impacts MRP see Article #2507.
 
 
NOTE:  If you do not follow this procedure to bring material back into your plant, your rework work orders do not have the value of the original product placed in WIP, and therefore when completing your rework work orders, there will be a huge variance created because there were no items placed in WIP (except for a few replacement parts),  yet the product is moved from WIP to FGI at standard cost.  When you use the RMA module these accounts balance out, with the variance being only those items added to the work order.
1.2.3. Fields and Definitions for RMA Receiver
1.2.3.1. RMA Receiver Tab

RMA Receiver Tab Field Definitions

Customer

This is the name of the Customer who returned the material.

RMA Receiving Number

This is the unique number assigned to the RMA Receiver.

Ship From

This is the Customer’s address from which the material was returned.

RMA Receiving Date

This is the date the user’s Receiving Department received the returned material.

RMA Order Number

This is the RMA Order Number assigned in the RMA Management module.See above.

Purchase Order

The was the customer’s original purchase order number for the original Sales Order.

Attention

This is the contact name at the Customer.

Ship Via

This is the original carrier for the original Sales Order.

Freight Amount

This is the freight originally charged the customer on the original Sales Order.

RMA Order Acknowledgement

This box is checked in the RMA Management module, as explained above.

Freight

This is the freight arrangement per the original Sales Order.

Waybill

This is the Waybill number pertaining to the original Sales Order.

Credit

This is the Customer’s Credit Status with the user.

FOB

This is the original FOB terms pertaining to the original Sales Order.

Entered By

These are the user’s initials authorizing the material return in the RMA Management module. 

1.2.3.2. Detail Tab

RMA Receiver Detail Tab Field Definitions

Customer

This is the name of the Customer who returned the material

RMA Receiving Number

This is the unique number assigned to the RMA Receiver.

 Ln

The line number of the Return Material Authorization or the line member of the order to be re-worked/replaced and returned to the customer.

Part Number

The user’s internal number for the part or assembly.

Rev

The revision number pertaining to the Part Number.

Class

The user’s classification covering the Part Number.

Type

The type within the classification covering the Part Number.

Qty

It’s the amount of the original order which the customer is returning. 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.

Back Order

The amount of product still expected to be returned by the customer.

Description

The user’s description covering the Part Number.

UOM

The unit of measure pertaining to the product.

This button allows the user to add items from the RMA Management module.

This button allows the user to delete the highlighted line.

Packing List Ship Date

 The date the Original Packing list was created.

Warranty Expiration

The date the warranty originally extended to the customer expires.

Serial Number Entry

The serial numbers pertaining to the items returned.

The note pertaining to the Part Number as entered in the Inventory Master.

1.2.3.3. Notes Tab

RMA Receiver Notes Tab Field Definitions

RMA Note

This is the internal note used by the user regarding the Return Material Authorization as entered in the RMA Management module.

RMA Receiver Note

This is a note that will be displayed on the RMA Packing List.

Credit Memo Reason

This is the note created when the Credit Memo was created.

1.2.3.4. WO List Tab

RMA Receiver Work Order List Tab

If the RMA Management module called for a re-work or replacement in addition to authorization of the return of material, the system will have created a Work Order.  Information regarding any such Work Order will appear in this tab.

RMA Receivng Work Order List Tab Field Definitions

Ln

The line number of the Return Material Authorization or the line member of the order to be re-worked/replaced and returned to the customer.

Part Number

The user’s internal number for the part or assembly.

Rev

The revision number pertaining to the Part Number.

Class

The user’s classification covering the Part Number.

Type

The type within the classification covering the Part Number.

Description

The user’s description covering the Part Number.

Work Order Number

The unique number assigned to the Work Order for Re-Work or Replacement

Work Order Due Date

The date the Work Order is scheduled to be completed.

Build Quantity

The number of units to be re-worked or replaced.

Back Order

The number of units still to be shipped.

Work Center

The name of the Work Center where the Work Order is currently.

Quantity

The quantity of the Work Order currently at the Work Center

1.2.3.5. Overview Regarding Return Material Authorization Accounting

No Journal Entry is created in the RMA module, however the system was collecting the JE components from that module as follows:

Assume that the original sale was for 10 units @ $100.00 each, with a standard cost of $80.00 each and freight charged the customer of $15.00.

At the time the user selects the original Invoice number in the Return Material Authorization module, the system “remembers” the original accounting entry that was created at the time the original Invoice was printed, which was:

Debit Accounts Receivable – Trade  $1,015.00

Debit Cost of Goods Sold  $800.00

Credit Sales  $1,000.00

Credit Finished Goods Inventory  $800.00

Credit Freight Income  $15.00

When the user enters the “return quantity” (the one entered as a negative quantity), the system will remember that the original cost of sales was $80.00 per unit.

The user then enters the pricing on the item to be returned on the Pricing page of the RMA module.

The pricing entered can be any amount up to the amount of the original pricing of $100.00 per unit. And so the journal entry component for the debit to the sales account is 2X $100.00 = $200.00, in this example.

The user selects the sales and cost of goods general ledger accounts to be used per the Sales Type column:

And so, the sales account number selected will be debited for $200.00 once the journal entry is created, upon the actual receipt of the returned item.And the related Cost of Goods sold account will be credited for the $160.00.

If the return is to be reworked and then returned back to the customer, the user creates a second line item on the RMA using a positive quantity which is in actuality creating the RMA Sales Order and an eventual invoice upon shipment.

The journal entry and the applicable Credit Memo for the returnis created in this Return Material Authorization Receiving module.On this screen, the user indicates the amount of freight to be credited, such as a pro rata 2/10 of $15.00, or $3.00, for example:


After the user types in the quantity received on the Detail page and depresses the Save button, several things happen all at once:

The Journal Entry is created as follows and forwards to the Release to General Ledger module:

Debit Sales  $200.00

Debit WIP  $160.00

Debit Freight  $3.00

Credit Accounts Receivable $203.00

Credit COGS  $160.00

  1. The Credit Memo is created for an amount of $203.00 total.  If the original invoice is still open, the amount of the credit memo will net against the original invoice leaving an open balance of $812.00, $1,015.00 minus $203.00.   If the invoice is paid than a credit balance will appear on the A/P Aging for the unapplied amount up to $203.00.
  2. The e-mail trigger is activated announcing that a Credit Memo has been created.
  3. The ReWork Work Order is created.
  4. The returned material is placed into WIP.

Once the Rework Work order is released, the user may opt to go into kitting and add line shortages which will be included in the Material Variance once the Kit is closed.Please refer to the Kitting and Shortage Management manual.

From this point forward, the accounting is the same as for a regular order.

1.2.4. How To .... for RMA Receiver
1.2.4.1. Find a Return Material Authorization Receiver

Enter Inventory Mgt/RMA Receiver Module  

The following screen will appear:

To find an RMA receiver, depress the Find action button.  The following selection screen will appear:

 

Find RMA Receiver by RMA Receiving Number

If you choose to find an RMA Receiver by the RMA Receiving Number, depress that selection and the following screen will appear:

Type the RMA Receiving Number into the red box or highlight your selection and double click.

 

Find RMA Receiver by Customer

If you select to find the RMA Receiver by Customer, a list of customers will appear:

Type the Customer Name into the red box or highlight and double click.

 

A list of RMA receivers for that customer will appear:

Type the RMA Receiving Number into the red box or highlight the selection and double click.

 

Find RMA Receiver by RMA Order Number

If you decide to find the RMA Receiver by the RMA Order Number, a list of RMA Orders will appear:

Type the RMA Order number into the red box or highlight your selection and double click

 

A list of RMA receivers will appear:

Type the RMA Receiving number into the red box or highlight your selection and double click.

 

Once the Find operation has been completed, the found RMA Receiver will populate the screen. 

1.2.4.2. Add an Return Material Authorization Receiver

Enter Inventory Mgt/RMA Receiver Module  

The following screen will appear:

To add a new RMA Receiver, depress the Add record action button. The following selection list will appear: 

Type the RMA Order Number into the red box or highlight your choice and double click.  Information from the RMA Management module will appear once you enter your password, as shown below:

RMA Receiving Tab

Depress the down arrow to select the appropriate ship from address.

Edit the RMA Receiving Date, if desired.

Depress the down arrow to select the appropriate customer contact, Ship Via, Freight, or FOB.

Enter the amount of freight, if desired.

Enter the number of the Waybill, if desired. 

 All other fields will be defaulted in.

Depress the RMA Receiver Detail Tab.   The following screen will appear:

Depress the Add RMA order item(s) button.  A list of products, etc. pertaining to the RMA selected will appear:

Highlight the selection and then depress the OK button. The cursor will go to the Quantity field. Type in the quantity being received.

If the warehouse selected in RMA module is not found (deleted or in cycle count/physical inventory), the user will receive the following message and will not be able to continue until this issue has been resolved.  



The following Work Order screen will appear:
 
NOTE:  Work Orders originated from an RMA Receiver will have "ReworkFirm" Job Status and users will NOT be allowed to change the Job Status. Since the material issued to the RMA is likely to be a defective assembly, or requires re-inspection, the work order must be completed by either transferring the material to FGI or to scrap to close the work order.  Therefore, an RMA work order cannot be cancelled. 
 
Also, users will NOT be allowed to edit or change the Bld qty because when product is brought into the system with an RMA Receiver it is then automatically issued as itself to the kit at that time.   
 
 

You may change the Work Order due date.     NOTE:  The Work Order due dates from the RMA Receiver are generated automatically based on the date the RMA was created. This date may need to be reviewed and adjusted to match the RMA scheduled ship date. MRP will not instruct you to reschedule a rework firm work order, so it is important to make sure all dates match.

Depress the Save  record action button.  

If the returned material contained serial numbers, the following screen will appear displaying the available qty:

Enter the Received Qty and depress the OK button, and the following screen will appear:

Type the Serial Number to be received into the Receiver Serial No box (if it doesn't exist in the system, System will prompt user if they wish to add serial # and the SN will be created). Or, select the Serial Number(s) being returned by highlighting and depressing the > button. For multiple serial numbers, hold the CTRL key down while highlighting.  If you want to include all Serial Numbers, depress the >> button.

Depress the OK button.  The Serial Number Entry box will update.

Rework Work Order Serial Numbers

When a Rework Work order is established for a serialized product, the user may select existing serial numbers that are in inventory (finished goods) that are to be reworked. Rework Work Orders will not accept new serial numbers.  When a serial number is placed in the Rework Work Order, the serial number must exist in finished goods, and the number of serial numbers transferred to the Work Order must equal the quantity of assemblies for the Work Order.  The part number for the serial number that is moved into the Rework Work Order does not need to be the same part number and revision as the Work Order.  Thus, if a user wants to upgrade part number 123 rev A to part number 123 rev B, they can transfer the parts to the Work Order and identify the serial number transferred.  Parts may also be changed to a new part number:  Example:part number 123 rev A can be placed in a Rework Work Order for part number 234 rev C.  The only condition is that the quantity and number of serial numbers must match.

You may enter an item Note, if desired.

The completed screen will look like this:


 

Depressing the Note tab will bring up the following screen:

The credit memo reason will display as referencing the RMA number.  You may add to the Credit Memo Reason, if you wish.

You may add an RMA note or an RMA Receiver Note, if desired.

When RMA is complete.  Depress the Save record action button to save changes, or depress the Abandon changes button.

If you depress the Save record action button, the following message will appear:

To continue the save, depress the Yes button. 

Selecting the WO list tab will bring up the following:
 

You may not change anything on this screen.

Note: The user can not kit a Rework Work Order. The user may only pull the shortage. Please refer to the Kitting, Allocating &  Shortage Management article.

Note:  If the RMA line number for the negative (returning) item is placed on administrative hold, then receiving will not be able to receive in the parts until it is cleared. 

Credit Memo

The Credit Memo is not created until the returned material is actually RECEIVED in the RMA Receiving module. There is no financial involvement UNTIL the parts are received back. Regarding the matter of advising accounting that a Credit Memo has been created, the system will send an e-mail to the appointed recipient when the RMA is received if a trigger is setup to do so. 
 
 
 
 
1.2.5. Reports - RMA Receiver
To print the RMA Receiver report, 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. 


RMA Receiver

For the RMA Receiver report, Select the RMA Receiver you want to print by highlighting it and then depressing the > button. Once the receiver is selected, depress the OK button.
 
If there are SN's listed on the report the leading zero's will not be displayed.
 

The following report is printed:

1.3. Purchase Order Receiving & DMR
1.3.1. Purchase Order Dock Receiving
1.3.1.1. Prerequisties for PO Dock Receiver
Prerequisites Required for Entering a New RECEIVER

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

Open Purchase Order

There must be an open purchase order for the receipt and the PO status MUST be "Approved".  If the PO is in "Edit" mode the PO Dock will not find receipt.

 

1.3.1.2. Introduction - PO Dock Receiver

In System setup/Purchasing Setup it gives the user the option to use PO Dock Receiving.  If this box is checked, the purchases are received at the dock requiring the user to complete a PO Dock Receiving record, listing the supplier’s packing list number and the quantities per that packing list.  An inspection report is printed.  The purchases are inspected and counted.  (If this box is left unchecked the user can skip the PO Dock Receiving step and go directly to the PO Receiving and Inspection record.)

 

 

 

1.3.1.3. Fields & Definitions for PO Dock Receiving

Fields & Definitions

Supplier Name  The Name of the supplier.
PO Number  The Purchase Order Number.
Supplier PL No  The Supplier’s Packing List number.
Receiver No  The user’s receiver number.
Item  The item number per the Purchase Order.
Part Number  The number the user has assigned to the part.
Rev The revision number related to the Part Number.
Balance Qty The un-received quantity portion of the item.
Recv Qty The quantity received per PO Dock Receiving.  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.  Note: Users must have special access in order to receive overages,  There is a checkbox to allow overages within Security/User Rights for PO Receiving. 

Note: The overage is applied to the entire PO order qty - it does not go down to the schedule level.  Example:  If you have an order qty of 100 and an allowed overage of 5% the system will allow you to receive in a total overage of 105.  But if you have only scheduled a qty of 25 and go to recieve in qty of 30 the system will allow you to do so, because it has not met the order overage yet. 

Part Class The classification to which the part number belongs.
Part Type The type within the class to which the part number belongs.
Description The description of the Part Number.
Insp  Displays whether Inspection is required as set up in the Inventory Control Management module.
Cert Displays whether Certificates are required per the Inventory Control Managment module.
Part Mfgr The name of the manufacturer for listed part.
MPN (Mfgr Part No)  The manufacturers part number for listed part.

1.3.1.4. How To ..... for PO Dock Receiver
1.3.1.4.1. Find Dock Receiver

Enter Inventory Mgt/Purchase Order Receiving & DMR/Purchase Order Dock Receiving Module

.

 

IF DOCK RECEIVING is DISABLED in Purchase Setup  user will receive the following message:




IF DOCK RECEIVING is ENABLED in Purchase Setup  t
he following screen will appear:

 

1.  Press the Find record action button will display the following sequences:

The user is prompted to search by Receiver Number, Purchase Order Number, or Supplier.

 

 2a. If you select by Receiving Number the following screen will appear.

Type in the receiver number in the red box, or highlight the receiver number and double click to select.

 

2b. If you select by Purchase Order Number the following screen will appear.

Type in the PO number in the red box, or highlight the PO number and double click to select.

 

2c. If you select by Supplier, the following screen will appear listing all the suppliers with open orders placed. The list is in alphanumeric order by supplier.

Type in the supplier in the red box, or highlight the supplier and double click to select.

2d. Once the supplier is selected, a listing of all open purchase orders for that supplier is presented, as displayed:

Type the Receiver Number into the red box or highlight the receiver number of interest and double click.

 

3. The completed Dock Receiving screen will look like this:

 

 

 

 

 

 

 

 

1.3.1.4.2. Add a Dock Receiver

Enter Inventory Mgt/Purchase Order Receiving & DMR/Purchase Order Dock Receiving Module

.

 

IF DOCK RECEIVING is DISABLED in Purchase Setup  user will receive the following message:




IF DOCK RECEIVING is ENABLED in Purchase Setup  t
he following screen will appear:

 

1.  To add a new receiving record, depress the Add action button. You will be prompted for your password. Then a selection screen will appear:

 

2a.  If you select Purchase Order Number, the following screen will appear:

Type the PO number into the red box or highlight the PO Number of choice and double click.The PO information will populate the screen.

 

2b.  If you select by Supplier name, the following screen will appear:

Type the Supplier Name into the red box or highlight the supplier and double click.

 

2c.  The following list of purchase orders for the supplier selected will appear:

Type the PO Number into the red box or highlight the PO Number and double click.

 

3. The purchase order selected will populate the Dock Receiving screen, as displayed:

 

Type the Supplier’s Packing List Number into the red box.  Fill in the Received Qty column.  (The qty entered in this field will have to either be accepted or rejected when completing the PO Receiver, user will not be allowed to create a PO receiver for only a Partial of this qty).  
 
Depress the Save changes action button.
 
User will receive the following warning if the qty received is larger than the PO balance.

Users must have special access in order to receive overages,  there is a checkbox to allow overages within Security/User Rights for PO Receiving.    If user does NOT have these rights, they will not be able to continue.

Note: The overage is applied to the entire PO order qty - it does not go down to the schedule level.  Example:  If you have an order qty of 100 and an allowed overage of 5% the system will allow you to receive in a total overage of 105.  But if you have only scheduled a qty of 25 and go to recieve in qty of 30 the system will allow you to do so, because it has not met the order overage yet.   Note:  A negative qty will appear in the balance column on the PO when an overage has been received.

User will receive the following warning if  one or more of the items on the receipt is before the PO due date and the early tolerance time allowed in the  Purchase Setup screen. 

Note:
   This warning will only display the item # of the first item found that the receipt is before the PO due date.  It will not display other item #'s' that have early deliveries on the same PO Dock receiver.  Depress OK to continue.  

Note:
Users must have special access in order to receive early shipments. There is a checkbox to allow eary shipments within Security/User Rights for PO Receiving.  If user does NOT have these rights, they will NOT be able to continue.

Users that have the special access to receive early shipments or users with Supervisor rights will receive this reminder message if the receipt is before the PO due date and the early tolerance time allowed the  Purchase Setup screen.

 

4. The completed Dock Receiving screen will look like this:

 
1.3.1.4.3. Editing a Dock Receiver

The user may edit the Dock Receiving record as long as a related PO Receiving has NOT been done.

  1. Find  Dock Receiver.
  2. Depress the Edit action button.
  3. You’ll be prompted for your password.
  4. User may edit the supplier's Packing List Number or the quantity received. The system does allow you to receive more then the PO quantity/Overage.   Note: Users must have special access in order to receive overages,  there is a checkbox to allow overages within Security/User Rights for PO Receiving. 
  5. Depress the Save changes action button.

If you try to receive more than the PO quantity, you’ll receive the following warning message:  

If you enter YES and depress the Save action button (and if you have exceeded the overage percentage from the Purchase Setup and\or PO line item) you will receive the following warning message. 

Note: The overage is applied to the entire PO order qty - it does not go down to the schedule level.  Example:  If you have an order qty of 100 and an allowed overage of 5% the system will allow you to receive in a total overage of 105.  But if you have only scheduled a qty of 25 and go to recieve in qty of 30 the system will allow you to do so, because it has not met the order overage yet. 

 
 
 
 
 
 
 
 
 
1.3.1.5. Reports - PO Dock Receiving
To obtain the PO Dock Receiving reports, select the Print button from the ManEx action buttons at the top of the screen.  

 

The report 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. 

 

If you select the Purchase Order Receipt Inspection Work Sheet report, or Purchase Order Receipt Inspection Work Sheet with Requester report highlight that report. Depress the Options tab. This screen appears:

 

Highlight the Purchase Order and depress the > button.If you want all of the Purchase Orders listed, depress the >> button.Depress the OK button.

 

The following is printed:

If you select the Open PO Dock Receiving Report, the following additional window will display at the bottom of the screen:

 

Select detail either by PO Number or by Received Date.Depress the OK button.

 

The following is printed:
 
 

 

1.3.1.6. FAQs for PO Dock Receiver
Facts & Questions for the PO Receiving & DMR Module
1.3.2. Purchase & Receiving Management
1.3.2.1. Prerequisties for Purchase & Receiving Mgmt
After activation, "Purchase Order & Dock Receiving" access for each user must be setup in the ManEx System Security module.  Users with “Supervisor Rights” will automatically have access.  
 
Dock Received Purchase Order
There must be a dock receiver for the purchase order. (If required in Purchase Setup).
Return/Shortage Reasons  Return/Shortage reasons must have been entered in System Setup - Return/Shortage Reasons Setup.
1.3.2.2. Introduction for Purchase & Receiving Mgmt

Receiving is the next step after creating and submitting a Purchase Order.  

 

In System setup/Purchase Setup it gives the user the option to use PO Dock Receiving.  If this box is checked, the purchases are received at the dock requiring the user to complete a   PO Dock Receiving record, listing the supplier’s packing list number and the quantities per that packing list.  An inspection report is printed.  The purchases are inspected and counted.  (If this box is left unchecked the user can skip the PO Dock Receiving step and go directly to the Purchase Order Receiving & Inspection record.

 

The user then is required to complete a PO Receiving & Inspection record. This module has a provision for rejected purchases.

 

For rejected materials, ManEx provides for a PO DMR (Discrepant Materials Receipt) module. The Discrepant Material Receiver is used to receive material which  does not meet the specifications for the purchased part or purchase order.  This module allows for review by the Materials Review Board.  Then, if not acceptable, the material may be returned to the supplier.  The user may reject in the Purchase & Receiving Management module OR may return an item From Inventory.  If an item is returned From Inventory, and the PO has been reconciled, a Debit Memo forwards into Accounting along with the appropriate journal entry. 

 

Once the data entry is completed, the purchase receivers are forwarded to the Accounting module for PO Receipt Reconciliation.  (The attached Print Screens below <<PO_Recv_Resulting_Trans.docx>> displays the resulting transactions that affect the Un-reconciled Receipt accounts after accepting items into stock through PO Receiving). 

Within the PO Receiving module there is a "Shortage List and Issue" button.  This will allow users to issue parts from receiving directly to the Kit Shortages.   This screen will display all shortages for that part and AVL.  There is an Approved Check box for reference to the Work Order Shortage List. This will be checked if the AVL that you are receiving is an approved AVL for that shortage.  This will give the users the needed information on screen to make the decision to use or not use a non-approved AVL to fulfill a shortage.    
1.3.2.3. Fields & Definitions for Purchase & Receiving Mgmt

 

Supplier Name The supplier or vendor with whom the order was placed.
P O Number The Purchase Order number of the order.
CO Number The Change Order revision status of the order placed.
Supplier PL No The number of the supplier’s Packing List.
Receiver No The Purchase Order Dock Receiving number.
Date Received The date the Purchase Order Receiving was completed.
Buyer The initials of the buyer for the order.
Item The Purchase Order Item Number.
Part Number The number the user has assigned to the part.
Rev The revision number assigned to the part.
Purch UOM The Purchased unit of measure. (May be different than stocking unit of measure).
Package The package type assigned to part in Inventory Control module. 
Balance The un-received quantity.
Received Qty The quantity received in Purchase Order Dock Receiving.  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.  Note: Users must have special access in order to receive overages,  There is a checkbox to allow overages within Security/User Rights for PO Receiving.    Note: The overage is applied to the entire PO order qty - it does not go down to the schedule level.  Example:  If you have an order qty of 100 and an allowed overage of 5% the system will allow you to receive in a total overage of 105.  But if you have only scheduled a qty of 25 and go to recieve in qty of 30 the system will allow you to do so, because it has not met the order overage yet. 
Accept Qty The quantity accepted within Purchase Order Receiving.
Reject Qty The quantity rejected.
Reject Reason The rejection reason Pull down list, (which is created within the System Setup Return/Shortage Reasons), is to allow the users to be able to select the Reject Reason code rather then writing notes and to be more consistent.  
Part Mfgr The manufacturer for the part.
MPN The manufacturer part number.
Description The description pertaining to the part number.

For the Highlighted Line Item:

Due Date  The date the item was due to the user’s dock.
Balance The un-received balance of the order.
Accept Qty The quantity accepted in Purchase Order Receiving.
Reject Qty The quantity rejected which will be placed in the Material Review Board warehouse.
Distribute To This is classification of the distribution of the item when received, either to regular Inventory Receiving or  to Allocate to a specific Work Order or Project.
Requestor On MRO and Services Purchase Orders, the name of the requestor is indicated.
N/A For future use.
WO Number The number of the Work Order for which the item was purchased.
Warehouse The name of the warehouse where the accepted quantity will be placed.
Location The specific location within the warehouse.
Note Schedule notes pertaining to that specific item and scheduled date.
Material Type  The material type listed is at the AVL level
Inspection Required This will be visible ONLY when selected in the Inventory module.  Check box when complete.  If box is NOT checked user will NOT be able to save record.
Certificate Required This will be visible ONLY when selected in the Inventory and/or PO module.  Check box when complete.  If box is NOT checked user will NOT be able to save.  
First Article Required This will be visible ONLY when selected in the Inventory module.  Check box when complete.  If box is NOT checked user will NOT be able to save record.
Enter any special notes pertaining to the 1st article.
Lot Code Lot Code number assigned to part.
Exp. Date Expiration date of Lot Code.
Reference User assigned number or code for reference
Lot Qty Qty of parts lot includes.
Reject Qty Qty of parts rejected out of lot.
Serial Number Serial numbers assigned to parts.
Reject Check box if that serial number is being rejected.
Insp Exception Note This information is displayed as reference information for processing the Receipts through the system.
Insp Excep Doc. This information is displayed as reference information for processing the Receipts through the system.

Directive Buttons:

 

The Item Inspection Note screen will be editable in the Add/Edit mode within the PO Receiving module (not editable when in view mode).  This button will turn Red when information has been entered.  The information added in the PO Receiving module will also be viewable in the Purchase Order module. 

  If this button is displayed in Red related documents have been attached to this item in the ICM module and may be viewed by depressing the "View Inventory Item Related Documentation" button.  For further detail see Article #2396 
Depress this button to view Item Master Notes for that specific part.  If there are Item Master Notes the button will be Red.  
Depress this button to view PO Item notes entered in the Purchase Order.  If there are PO Item notes the button will be Red.
Depress this button to view PO notes entered in the Purchase Order.  If there are PO notes the button will be Red
 

Depressing this button will bring up the following screen. If shortages exist for the current line item the button will be Red For further detail see Article #105 .

The system shows all the shortages for the part that is received, if:

  1. the WO is not closed or cancelled 
  2. the WO balance is more than 0
  3. the kit line "Ignore Kit" flag is not on
  4. the Kit status is "Released"

It is up to the user to decide which receipt has to be applied to which shortage.

Work Order Shortage List field definitions:

Work Order Due Date The date the Work Order was due to be completed and ready to ship.
Work Order Number The number of the Work Order.
Customer The name of the customer listed on the Work Order.
Product Number The Product number listed on the Work Order.
Revision The revision listed on the Work Order.
Shortage Quantity The amount of the Work Order shortage.

Qty Issued

The quantity issued to the Work Order shortage. System does not allow you to issue quantities greater than the shortage quantity.  For more detail see Article #2479.

Balance

The balance of the shortage after issuing parts to WO.

Approved 

This will be checked if the AVL that you are receiving is an approved AVL for that shortage.  This will give the users the needed information on screen to make the decision to use or not use a non-approved AVL to fulfill a shortage. 

Incoming Receipts field definitions:

PO REC Due Date The date the Purchase Order Receiving was completed. 
Available Qty The quantity accepted within Purchase Order Receiving. 
Warehouse The name of the warehouse where the accepted quantity will be placed.
Location The specific location within the warehouse. 
Part Mfgr The manufacturer for the part.
MPN The manufacturer part number.
Allocated To If the parts have been allocated to a WO or project when PO was created.
Requestor On MRO and Services Purchase Orders, the name of the requestor is indicated.
Lot Code Lot Code number assigned to part.
Exp Date Expiration date of Lot Code. 
Reference User assigned number or code for reference

Highlight WO Shortage and drag Incoming Receipt here to issue field defintions:

Work Order The number of the Work Order.
PO Rec Due Date The date the Purchase Order Receiving was completed.
Warehouse The name of the warehouse where the accepted quantity will be placed.
Location The specific location within the warehouse.
Part Mfgr The manufacturer for the part.
MPN The manufacturer part number.
Qty Issued The quantity issued to Work Order Shortage
Lot Code Lot Code number assigned to part.
Exp Date Expiration date of Lot Code.
Reference User assigned number or code for reference
 

1.3.2.4. How To ..... for Purchase & Receiving Mgmt
1.3.2.4.1. Find a Purchase Order in Receiving Inspection

Depress the Inventory Mgt/Purchase Order Receiving & DMR/Purchase & Receiving Management module  

The following screen will appear:

 

1. Pressing the Find action button at the top of the main screen displays the following sequences:

This allows the user to search by Purchase Order Number, Supplier, or Receiver Number.

 

2a. If the user selects to find by Purchase Order Number, a screen is presented listing all orders placed.

Type the PO number into the red box or highlight the PO Number of choice and double click.The PO information will populate the screen.

 
 2b. If the user selects to find by Supplier, a screen is presented listing all of the suppliers with all orders placed.

Type the supplier into the red box or highlight the supplier of choice and double click.The PO information will populate the screen.

 

2c. If the user selects to find by Receiver Number, a screen is presented listing all of the receiver numbers with all orders placed.

Type the receiver number into the red box or highlight the receiver number of choice and double click.The PO information will populate the screen.

 

3. The found information will populate the screen, as follows:

1.3.2.4.2. Add a PO Receiving Inspection Record

If system is setup for Dock Receiving follow a.  If system is setup for Inventory receiving ONLY follow b. 

    1. Print out the  Purchase Order Receipt Inspection Worksheet.
    2. You will go directly to step 3. 
    3. Inspect the shipment received. 
    4. Add a record.
    5. The user will be prompted for the password. 
    6. Find  a Purchase Order 
    7. If Supplier Packing List Number is not already entered, enter it now.
    8. Select the part to receive.
    9. Enter the quantity accepted and/or rejected and reject reasons.  (When using the PO Dock, user has to either accept the entire Dock qty or reject the balance.  User can not accept only a partial PO Dock qty).   Note: Users must have special access in order to receive overages, receive early shipments,and/or receive banned MPNs.  There is a checkbox to allow user to receive overages, receive early shipments, and/or receive banned MPSs, within Security/User Rights for PO Receiving.   

       

      User will receive the following warning if the number of parts received is higher than the qty ordered.

      The overage is applied to the entire PO order qty - it does NOT go down to the schedule level.  Example:  If you have an order qty of 100 and an allowed overage of 5% the system will allow you to receive in a total overage of 105.  But if you have only scheduled a qty of 25 and go to receive in qty of 30 the system will allow you to do so, because it has not met the order overage yet.  Note:  A negative qty will appear in the balance column on the PO when an overage has been received.

      Note:  User must have special access in order to receive overages.   There is a checkbox to allow overages within Security/User Rights for PO Receiving.  
      If user does NOT have these rights, they will NOT be able to continue.

      User will receive the following warning if the receipt is before the PO due date and the early tolerance time allowed in the  Purchase Setup screen

      Note: Users must have special access in order to receive early shipments. There is a checkbox to allow early shipments within Security/User Rights for PO Receiving If user does not have these rights, they will NOT be able to continue.

       

       

    10. If the “Allow auto creating location at receiving” box is checked in Inventory Control, AVL level & Warehouse Setup, this will allow the user to add or edit the location at time of receipt. User may also select an existing warehouse at receiving instead of having to create one before receiving.   For further information on the "Allow auto creating location at receiving" see Inventory Control & Warehouse setup.  If the Inspection Required, Certificate Required, and/or the First Article Required is setup in the Inventory Control Management module,   these boxes will be displayed in Red and the "DONE" boxes must be checked to continue the receiving process.  

       

    11. In the system setup - Purchase Setup user can choose to allow receiver to change AVL at the receipt.   The pull down will display all the Mfgr and Mfgr PN's listed in the AVL screen in the ICM module.

    12. Enter Serial Number and/or Lot Information if required.

    13. Issue parts directly to Work Order Shortages.

    14. Save the record.

    NOTE:  If there is a Item Master Note, Purchase Order Item Note, or a Purchase Order Note, it will be RED. To view the note, depress the button of interest. When finished viewing Depress the OK button at the bottom of the screen.  The user will have the ability to edit the Item Master Notes if they have “Edit” rights to the Inventory Module, which can be setup in the Security Module. 
    1.3.2.4.2.1. Entering Serial Number and/or Lot Information

    Introduction

    The users can receive components that require Lot Code Only, Serial Number Only, or both Serial Number and Lot Code, following the instructions listed below.  A part that requires a Lot Coded is setup in the Inventory Part Class set-up module.  A part that requires Serial numbers is set-up in Inventory Control Module.

    1. Fill in accepted item quanitity as instructed in the Add a PO Receiving Inspection Record.
    2. Depress the Add button next to the Lot Code section.
    3. Type in the Lot Code. The expiration date, reference date and quantity will automatically update, (if the part class/type setup is set to auto update expiration date and reference for the lot code).   In order for a Lot Code to be unique, the system looks at four fields for comparison.  They are Lot Code, Reference, and PO Number.  So while a batch may have the same Lot Code as another batch, if it arrives in a different PO, the it will be classified as a different lot.  The expiration date is optional and is not required when creating a new lot.

    4. Serial numbers will have to be assigned only if a part has the serial number box checked in the inventory module.
      1. Select either single or range.
      2. Enter the serial number in the red box and depress enter.
      3. The serial numbers will automatically update. (Serial numbers may or may not have lot codes).

         

      1.3.2.4.2.2. Issue Directly to Work Order Shortages

      Highlight the line item of interest on the PO Receiving and Inspection screen.

      Depress the Work Order Shortage List and Issue button.

      Highlight the work order shortage at top of screen. 

      Drag Available Qty located in the middle of your screen under Incoming Receipt.

      Drop it in the quantity issued at the bottom of your screen as displayed below.  System will allow users to pick to each of the individual shortages within the same Work Order and/or different Work Orders.
       

      The Approved box will be checked if the AVL that you are receiving is an approved AVL for that shortage. This will give the users the needed information on screen to make the decision to use or not use a non-approved AVL to fulfill a shortage.

      System will not allow user to issue quantities greater than the shortage quantity.  See Article #2479 for further detail.

      The following messge will be displayed if user issues a quantity greater than the shortage quantity. 



      NOTE:  If a user has the Work Order Checklist feature active and tries to use the PO Receiving shortage and issues feature within the PO Receiving, it will not recognize the shortages until the kit has been flagged as "Kit Complete".  It is designed this way because the user will not know if the parts are short until the kit is completed. 

      You may have parts in the inventory and have not pulled them to the kit yet.  If you allow seeing the shortage (which may not be a shortage because parts are not pulled yet) from the PO receiving, the receiver may be trained to automatically issue to the shortages first, but it may not be a shortage because parts have not been pulled from inventory, so how would they know if it is a real shortage or just not pulled from inventory yet.

       

      1.3.2.4.3. Rejecting Quantity in PO Receiving & Inspection
      1. Highlight the PO item number located in the middle section of the PO Receiving and Inspection screen.
      2. Type in the accepted quantity (if any).
      3. Place the cursor in the next box (rej qty) and type in the rejected quantity.
      4. Select a reject reason from the pull down in the top section of the screen.
      5. If lot coded type in the accepted qty and rejected qty in the lot code screen.
      6. If serial numbers are required check the serial numbers that have been rejected.
      7. Continue this process until all items are either accepted or rejected.

      8. Depress the Save button.   
      9. If all items on the Purchase Order have been received it will be marked "CLOSED". 
      1.3.2.4.3.1. Rejecting Items if Accounting has Processed the Invoice
      1. If the Purchase Order has been processed through accounting:
        1. Transfer the discrepant material into the MRB (materials review board) warehouse via Inventory Handling.
        2. Enter the PO DMR module (discrepant material return).
        3. Add from Inventory. (This is called an INVENTORY DMR).
      2. If the user has already pulled the kit associated with the part to be returned to the supplier.
        1.  Enter the Kitting module.
        2. Find the work order.
        3. Depress the Utility tab and depress the De Kit button.  This process will return the part into the inventory warehouse. (Please refer to the Kitting & Shortage Mgmt module).
      1.3.2.4.3.2. Rejecting Items if Accounting hasn't Processed the Invoice

      Introduction

      After the user has accepted all of the items on a Closed Purchase Order and then subsequently it’s discovered that the material received is discrepant, do the following if Accounting hasn’t already processed the Supplier’s Invoice for payment:

       

      1. Enter the Purchase and Receiving Managment Module.
      2. Find the closed PO, using the Find a Purchase Order.
      3. Depress the Edit button.
      4. Type in your password.
      5. Highlight the discrepant Part Number Line Item in the top section of the screen.
      6. In the middle section of the screen, enter the revised accepted quantity, and the rejected quantity.
      7. Go back up to the top section of the screen and select a reject reason.
      8. If there is Lot Code Tracking involved, also adjust the Lot accepted quantity and rejected quantity, and check the serial numbers that have been rejected.
      9. Depress the Save button.

      1.3.2.5. Reports - Purchase & Receiving Mgmt
      To obtain the PO Receiving 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. 

       

       

      MATERIAL RECEIPT LABELS

      For the PO Receiving Material Receipt Labels, you can choose between the Avery label #5163 (laser Sheet 4x2) or the Zebra Printer.
       
      Select PO Status - Open or Closed.  Select to pick PO # from List or Enter Single PO #.  Select the PO from the pull down. Depress the GO button. 
       

      The information will automatically fill in.  Enter the quantity of labels needed for each item.
       
      Note:  The Mfgr and Mfgr PN info is being pulled from the PO Module and not the Receiving Module.

      Depress the OK button.

       

      The following is printed (This example is Printing to the Laser Printer (Sheet):  Label size 4" x 2")
       
       
       

      MATERIAL RECEIPT TRAVELER REPORT

      For the Material Receipt Traveler report, highlight that report.

      Go  to the Options screen, select the PO Items Type from the pull down screen. 

      Depress the OK button. 

       

      The following is printed.

      MATERIAL RECEIPT HISTORY FOR ONE PART REPORT 

      For the Material Receipt History for One Part report, highlight that report.

      Go to the Options screen.  Enter the part number.  Enter the desired date range.  To clear the selection, check the Clear Selection box and re-enter the desired date range.
       
      Check the box to Suppress leading "0" when printing serial numbers.

      Depress the OK button.

       

      The following is printed:

      MATERIAL RECEIPT HISTORY REPORT FOR ALL PARTS

      For the Material Receipt History Report for ALL Parts, highlight that report and make the appropriate selection at the bottom of the screen, By Part Number, By Warehouse or By Supplier.

      Go to the Options tab.  Enter the desired date range.  To clear the selection, check the Clear Selection box and re-enter the desired date range.
       
      Check the box to Suppress leading "0" when printing serial numbers.

      Depress the OK button.

       

      The following is printed:

      PURCHASE ORDER RECEIPT INSPECTION WORKSHEET or

      PURCHASE ORDER RECEIPT INSPECTION WORKSHEET with REQUESTER

      For the Purchase Order Receipt Inspection Work Sheet, or Purchase Order Receipt Inspection Work Sheet with Requester, highlight that report.

      Go to the Options tab. Highlight the Purchase Order and depress the > button.  If you want all of the Purchase Orders listed, depress the >> button.

      Depress the OK button.

       

       

      The following is printed:

      Material Receipt History Report for PO

      For the Material Receipt History Report for PO, highlight that report.

      Go to the option tab. Choose Single PO or PO received in given Date Range by selecting the radial.  Enter date range.
       
      Check the box to Suppress leading "0" when printing serial numbers.
       
      The Project/Work Order Allocation information will be displayed on the report. NOTE: The report has to pull the allocation information from the Purchase Order Item Schedule, if the item schedule allocation is modified after receipts have already been made against this item, the report will also change to display what is currently assigned for allocation, not what they were received into the system as.

      Depress the OK button.

       

      The following will print:

      1.3.2.6. FAQs - Purchase & Receiving Mgmt
      Facts and Questions for the PO Receiving & DMR Module
      1.3.2.7. ManEx Minutes (PO Receivng)
      1.3.3. Purchase Bar Code Receiving
      1.3.3.1. Prerequisites for Bar Code Receiving

      After activation, "PO Bar Code Receiving" access for each user must be setup in the ManEx
      System Security module.  Users with “Supervisor Rights” will automatically have access.
       
      Dock Received Purchase Order There must be a dock receiver for the purchase order. (If required in Purchase Setup).
      Return/Shortage Reasons  Return/Shortage reasons must have been entered in System Setup - Return/Shortage Reasons Setup.
      BarCode Printer Zebra Model #LP2844 and ZEBRA labels part number 10000281 (or equivalent) for the 4 x 6 label.  For further detail see Article #142
      1.3.3.2. Introduction for Bar Code Receiving
      This module is designed to streamline the receiving process by giving the user the capability to scan the bar code in PO Receiving and print out the labels upon receipt.  This module can be used with a Bar Code Scanner or manually.  This will enhance the process of receiving product by saving time with the simple procedure of scanning by bar code and the option to print out labels upon receipts. 
       
      The objective of the bar code receiving is to minimize the time spent on receiving a PO.  Having a number of additional items on the screen is NOT practical from a space standpoint nor from a user standpoint.  If the receiving clerk is required to modify the Warehouse location, AVL, etc. they will need to use the manual PO Receiver module.
       
       
         
      1.3.3.3. Fields and Definitions for Bar Code Receiving

      Bar Code Command

      When you first open the Bar code screen your cursor will be located in the “Bar Command” text box. You can use a scanner or just type the same value as you see on the print-out to navigate this screen.   For example when you first started you can just type “add” into the “Bar Code Command” space to activate the “Add” button. 

      Supplier PL No  The Supplier PL No scanned or entered
      Receiver No  The Receiver No scanned or entered
      Date Received  The Current Date and Time will default in when Bar Code is scanned or info is entered manually
        Depress this button to clear Values (if scanned incorrect Bar Code or entered incorrect information) 
      Depress this button to Print the Label after Transaction has been saved.
      Print Labels Upon PO Receipts in BC If this box is checked the Label will be printed upon PO Receipt
      PO Number  The PO Number (scanned or entered manually)
      CO #  The Chance Order Number listed on the PO 
      Buyer  The Buyer listed on the PO  
      Item #  The item number on the PO for the part number scanned or entered manually 
      Part Number  The Part Number scanned or entered manually
      Revision  The Revision of the Part Number scanned or entered manually
      Material Type  The Material Type assigned to the Part Number scanned or entered manually
      Manufacturer Part Number  The Mfgr PN  listed on the PO
      Part Manufacturer   The Mfgr listed on the PO
      Accept Quantity  Enter the Accept Quantity 
      Reject Quantity  Enter the Reject Quantity
      Reject Reason  The reject reason field is linked to the appropriate setup tables if you print just partial information and press enter the information should get completed, but if the information is completely wrong then the system will prompt for the correct info. 
      Inspection/Certifcate/1st Article  The 1st article disposition field is linked to the appropriate setup tables if you print just partial information and press enter the information should get completed, but if the information is completely wrong then the system will prompt for the correct info.  
      Lot Code Entry Area 

      Enter Lot Code number assigned to parts, expiration date, qty, etc. 

      Serial Numbers Entry Area  Enter Serial numbers assigned to parts.
        If this button is displayed in Red related documents have been attached to this item in the ICM module and may be viewed by depressing the "View Inventory Item Related Documentation" button.  For further detail see Article #2396  

      1.3.3.4. How To ..... for Bar Code Receiving
      1.3.3.4.1. Accept/Reject Quantity
      Enter Inventory Mgt/Purchase Order Receiving & DMR/Purchase Bar Code Receiving Module    

      The following screen will appear:

      When you first open the Bar code screen your cursor will be located in the “Bar Command” text box.  Use print button to print a bar code for all the commands you can use in this screen.

       

      You can use a scanner or just type the same value as you see on the print-out to navigate this screen.  For example when you first started you can just type “add” into the “Bar Code Command” space to activate the “Add” button.  When in the “Add” mode cursor will be positioned in the “Supplier PL No” field you can enter or scan a supplier packing list number or if you would like to advance to the let say “PO Number” field you can type\scan “PO” and the cursor will advance to the PO # field.   If you have a barcode which has “PO1530” where “1530” is an actual PO#  the cursor will advance to the “PO Number” field and place value of “1530” into it.   You can do the same with any of the other fields, which have a command listed in the print out.
       
      Depress the "Print Label for Saved Transaction" or check the box "Print Labels upon PO Receipts" .  ManEx has designed the labels to be printed on a Zebra Label #10000281 (or equivalent) for a 4 X 6 label.     
       
       
       
       
      1.3.4. PO DMR
      1.3.4.1. Prerequistes for PO DMR
      Prerequisites for PO Inspection/Acceptance Received with Rejected Quantities:
       
      After activation, "Purchase Order Management" access for each user must be setup in the ManEx System Security module.  Users with “Supervisor Rights” will automatically have access.
       

      Purchase Order received with Rejected Quantities

      There must have been a rejection in the Purchase & Receiving Management module.


      Prerequisites for Rejects from Inventory:

      MRB (materials review board) Warehouse

      A MRB (materials review board) Warehouse must be set up in Warehouse Setup.

      Inventory transferred to MRB (materials review board) whse 

      Within Inventory Handling the discrepant quantity must have been transferred to MRB (materials review board) warehouse.

       

       

       

      1.3.4.2. Introduction for PO DMR

      Discrepant Material Return is used to return material which is different than what was ordered, received late, over shipment, damaged, etc.

       

      There are two ways to return discrepant materials.

       

      1.                    The discrepancy is discovered in PO Inspection/Acceptance Receiving and rejected there.

      2.                    The discrepancy is discovered after the Inventory has been placed into stock.  This module allows for review by the Materials Review Board.  Then, if not acceptable, the material may be returned to the supplier.  Once the DMR (discrepant material return) is created, information regarding the return is forwarded into Accounting where a Debit Memo and the accompanying accounting journal entry is created.

       

      Once the Discrepant Material is added, the user may print out a DMR (discrepant material return) Packing List.

       

      In Defect Code Entry we allow users to move product into FGI, when a part is transferred to FGI, the program will compare the total cost of components with the "material cost" of the assembly, then create the configuration variance. In addition to that, the system will create additional 4 records for "Labor", "Overhead", "Other Costs" and "User Defined" costs.

       

      1.3.4.3. Fields & Definitions for PO DMR
      1.3.4.3.1. Return Items Tab

      Fields & Definitions

      Supplier The name of the supplier
      PO Number The number of the Purchase Order.
      CO The Change Order pertaining to the Purchase Order
      Receiver # The number of the Purchase Order Receiver
      Packing List # The number the supplier assigned to the Packing list
      Item The number of the line item per the Purchase Order.
      Part Number The user assigned number for the part being returned
      Rev The revision of the part number, if applicable.
      Class The classification of the part number returned.
      Type The type within the classification.
      Description The description of the part number
      Manufacturer The name of the part manufacturer
      Mfgr part Number The number assigned to the part by the manufacturer
      DMR # The number assigned to the DMR.
      DMR Date This is the date the DMR was created.
      RMA # The number the Supplier provided for the Return Material Authorization.
      RMA Date The date of the Supplier’s Return Material Authorization
      Return Quantity The number of units returned to the supplier. 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.
      DMR Confirm By The name of the user who authorized the DMR.
      DMR Created so far Previous DMR's Created

      Return Items tab field definitions

       Warehouse

      Part Number Original Warehouse

       Location

      Part Number Original Location

       Accpt Qty

      Qty after returns processed

       PO Rejected

      PO number that qty was rejected against

       Return Qty

      The quantity of material returned

       Balance

      The quantity balance

       Due Date

      The date to expect the replacements

       Distribute to

      A special person or department to deliver the parts to

       Requestor

      A person or department requesting the DMR

      Lot Code The lot code as assigned in PO Receiving module.
      Accpt Lot Qty The total quantity of the lot
      PO Rejected

      PO number that qty was rejected against

      Returned Qty

      The quantity of material returned 

      Exp Date The expiration date assigned to the lot
      Reference The reference number assigned to the lot 

      Lot Code  The lot code as assigned in PO Receiving module.
      Quantity The balance left after all returns.
      Reference The reference number assigned to the lot 
      Exp Date The expiration date assigned to the lot

      Serial Number  The serial numbers being returned
      Return The quantity of material being returned 

       
      1.3.4.3.2. Packing List Tab

      Field & Definitions

       Supplier The name of the supplier
       DMR Packing List The Packing List number the user has assigned to the material return.
       Ship to The address where the return will be shipped.
       Remit To The address for the receipt of the Debit Memo, if applicable.
       Attention The supplier representative to whom the Purchase Order was sent.
       Ship Via The name of the carrier for the returned material.
       Ship Charge The mode of the charge of the shipping for the return
       FOB The point where title of the returned goods passes.
       Terms The payment terms offered by the supplier
       Waybill The carrier’s waybill number pertaining to the material return.

      1.3.4.3.3. View DMR Tab

       DMR #  The number assigned to the DMR.
       RMA #  The number the Supplier provided for the Return Material Authorization.
       RMA Date  The date of the Supplier’s Return Material Authorization
       DMR Packing List  This is the alphanumeric packing list identifier
       DMR Date  This is the date the DMR was created.
       Return Quantity  The number of units returned to the supplier.
       DMR Confirm By  The name of the user who authorized the DMR.
       PO Number  The number of the Purchase Order.
       CO  The Change Order pertaining to the Purchase Order
       Receiver #  The number of the Purchase Order Receiver
       Packing List #  The number the supplier assigned to the Packing list
       Item  The number of the line item per the Purchase Order.
       Class  The classification of the part number returned.
       Type  The type within the classification.
       Part Number  The user assigned number for the part being returned
       Rev  The revision of the part number, if applicable.
       Manufacturer  The name of the part manufacturer
       Mfgr part Number  The number assigned to the part by the manufacturer
       Description  The description of the part number
       Supplier  The name of the supplier
       Ship to  The address where the return will be shipped.
       Remit To   The address for the receipt of the Debit Memo, if applicable.
       Attention  The name of the supplier’s contact.
       Ship Via  The method of shipment for the return
       Ship Charge   The mode of the charge of the shipping for the return
       FOB  The point at which legal title passes.
       Terms  The payment terms offered by the supplier
       Waybill  The number of the shipper’s document

       

      1.3.4.4. How To ..... for PO DMR
      1.3.4.4.1. Adding a DMR from Inventory

      This procedure is used after accounting has Reconciled the Purchase Order.  If accounting has not yet reconciled the purchase order, see  Rejecting Items if Accounting hasn't Processed the Invoice.

      Note that the discrepant material must be transfer into the MRB (materials review board) warehouse via Inventory Handling before you can proceed.

      To enter the PO DMR (discrepant material return) module, select Inventory Mgt / Purchase Order Receiving & DMR (discrepant material return) / PO DMR (discrepant material return).  

      1. Depress the Add button.
      2. Type in your password.
      3. The following screen will appear;

                                                                                                                                    
      4. Select the From Inventory radial.
      5. Type in the Part Number and depress the OK button.  The following screen will appear (If there is more than one Purchase Order involved it will list them all)     


                                                                                                                
      6. Highlight the Purchase Order of choice.

      7. Depress the OK button. Information regarding that part number for the Purchase Order selected will display:

      8. Type in the returned quantity in the Return From section.
      9.  In the DMR List section, type in the RMA number.
      10. Type your name in the Confirm By column.
      11. Depress the Packing List Tab.
      12. Typing in your Packing List number for the return.  Type in the associated waybill number.  

       

      If accounting has not yet transferred the reconciled invoice into AP Aging, the following message will appear:
       


      Depress the Save button.  The following screen will appear:
       

       
       
      Once the DMR (discrepant material return) has been added and saved, a Debit Memo will be created.  If Debit memo numbering is manual, the user will be prompted for the number.  Additionally, the corresponding entry will be created and the balance in the Accounts Payable Aging will adjust as soon as the Debit Memo is printed.
       
      If the invoice happens to be in a Saved Check batch the following warning will be displayed:
       
       

       

      1.3.4.4.2. Add a DMR from a PO Inspection/Acceptance Receiving Rejection
      To enter the PO DMR (discrepant material return) module, select Inventory Mgt / Purchase Order Receiving & DMR (discrepant material return) / PO DMR (discrepant material return).  
      1. Depress the Add button.
      2. Type in your password.The following screen will appear:

      3. Select the From PO Receiving radial.
        1. If you then mark the radial Purchase Order #, you will need to type in the number of the PO on which material was rejected.
        2. If you mark the radial Supplier, you must then type in the name of the Supplier and then depress the OK button.
        3. A list of Purchase Orders pertaining to that supplier will appear.

           
      4. Type the PO number of interest in the red box or highlight and double click.
      5. Depress the OK button.  (Note there are four additional screens if lot code and serial numbers are involved).

      6. Type in the DMR number (if set-up for manual numbering) you are assigning to this return.
      7. Type in the RMA number as provided by the supplier.
      8. Type your name in the Confirm By space.
      9. Highlight the line item containing the rejected quantity. (If returning a part that involves a Lot Code, type in the returned quantity in the Lot Code section and it will automatically update the Return From section. Check the serial numbers being returned).
      10. Depress the Packing List tab.
      11. Enter the Packing List number you wish to assign to the return. (Note that this number is NOT tied to regular shipping Packing Lists.This is a manually numbered field that is only for reference on the DMR’s.Any alpha-numeric code can be used here.DMR packing list numbers cannot be found in the regular shipping module – Packing List Management.It is suggested that the user manually log these codes or type in some kind of significant code, such as the date followed by the PO#).
      12. Type in the Waybill number.
      13. Depress the Save button. The View DMR screen will appear: 

         

         

      1.3.4.4.3. Find an Existing Discrepant Material Record (DMR)

      To enter the PO DMR (discrepant material return) module, select Inventory Mgt / Purchase Order Receiving & DMR (discrepant material return) / PO DMR (discrepant material return).

       
      1. Depress the Find button. The following screen will appear: 

      2. Select the appropriate radial – either DMR Number or Receiver Number.

      3. Type the appropriate DMR or Receiver number into the Red box.

      4. Depress the OK button.

       

      The following screen will appear:

       

      1.3.4.5. Reports - PO DMR

      To print out the DMR (discrepant material return) Packing List, depress the Print button. The following screen will appear:

      Highlight the DMR (discrepant material return) Packing List Form. Depress the Options tab.

       
      The following screen will appear:

      Select the Output, either Screen, Printer, XL File, TXT File, or PDF.  Select the number of copies by toggling on the arrows.  If you don’t want to print the DMR displayed, click on the Select DMR from the list radial then highlight the DMR (discrepant material return) # you want printed and depress the > button.  If you want all of them, depress the >> button.

       

       

      The following will print:

      1.3.4.6. FAQs - PO DMR
      Facts and Questions for the PO Receiving and DMR Module
      1.4. Kitting, Allocating & Shortage Management
      1.4.1. Kitting & Shortage Management
      1.4.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.4.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.4.1.3. Fields & Definitions for Kitting & Shortage
      1.4.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.4.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.4.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.4.1.3.3. Utility Tab

      The Utility Tab has four functions:

       

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



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

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

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

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

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

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

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

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

       

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

       

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

      Depress the Update Kit button. Type in your password.

      You will receive a confirmation message.

       

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

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

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

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

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

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

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

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

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

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

      1.4.1.4. How To ..... for Kitting & Shortage
      1.4.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.4.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:

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

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

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

      ENTER SERIAL NUMBERS

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

       


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

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

      The completed Main tab screen appears as below:

       
       
       
      NOTE:  MRP is designed to calculate from the Kit Shortage and not from the Lead times once the parts have been pulled to the kit and the kit status is changed to "Kit in Process".   Once the parts have been pulled to the kit, the systems is assuming that the shortages are needed by the WO due date, rather than the 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

       

       

       

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

       

       

      1.4.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.4.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.4.1.4.5. De-Kit

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

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


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





      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.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:



      1. Depress the Edit action button. The following selection will appear:
      2. Select the Issue Parts option.
      3. Enter password.
       

      1. Highlight the Part Number with the negative shortage.
      2. Move the cursor into the Pick Quantity field.
      3. Type in the corrected amount of picked quantity that was actually used in the assembly.
      4. 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). 

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

        

      3.  If then you want the un-used overissue returned to stock, 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.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.4.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.4.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 -

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

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

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

       

       

      The following report will be displayed:

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

      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
       
      NOTEThe 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.4.1.6. FAQs - Kitting & Shortage
      Facts and Questions for the Kitting & Shortage Module
      1.4.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.4.3. WO Shortage Summary List

       

      Enter Inventory Mgmt/Kitting, Allocating & Shortage Management/Work Order Shortage Summary List 
       
      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. 

      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.4. Inventory Allocation
      1.4.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.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.4.3. Fields & Definitions for Inventory Allocation
      1.4.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.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.4. How To ..... for Inventory Allocation
      1.4.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.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:

      1. Highlight the desired part number you want to allocate. Inventory AVL information for that particular part will populate the lower portion of the screen.
      2. Type in the amount you want to allocate in the Alloc Qty column.
      3. 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.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.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

       

      1.5. Inventory Control Management (ICM)
      1.5.1. Inventory Control Management (ICM)
      1.5.1.1. Prerequisties for ICM Mgmt

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

      Before entering products and parts in the Item Master, the following product, part and system classifications and item parameters must be setup in ManEx using the System Setup Material Module.  Note:  that although data entry is possible with only the Prerequisites below, using the Data Entry Defaults explained in the next section is strongly advised to save time and maintain consistency.

      Product and Part Class

      All items must be assigned a Class code (Finished Goods, Subassembly, Resistor, Capacitor, Raw PCB, etc.) in order for ManEx to number, connect, sort and organize the items. Class codes are User-defined but chosen carefully.

      Product and Part Type

      Each Class is further grouped into Types (Surface Mount, Thru-Hole, Precision, Programmed, etc.) to standardize description fields and allow use of default values. This speeds up data entry and eliminates redundant data and duplicate records.

      Units of Measure

      Several standard Units of Measure (U/M) are already setup in ManEx.Additional purchase or stocking U/M’s must be added in System Setup.  Also, if the Purchase and Stocking U/M are different (eg. Wire purchased in FT, issued in IN.), a Conversion Formula must be entered in System Setup Unit of Measure & Conversion.

      Numbering System

      The User must select Automatic or Manually Numbering in System Setup Number System Module. For Auto-numbering, the Beginning Number must be entered. A customer-selected prefix can be entered in System Setup Number System to be added to each Manual or Auto-Numbered part no.

      Warehouse Assignments

      A System Setup (Warehouse Setup)  to assign names and General Ledger Numbers (for ManEx Accounting) to the hard-coded MAIN1, WIP, WO-WIP and MRB Warehouses is required. Additional FGI and/or In-Store Warehouses can be added if assignment as stocking locations during Item Master data entry is desired. 

      Optional Data Entry Default fields are not required for Item Master entries, but are highly recommended to ensure consistency and save time during data entry.They are shown below.

      Data Entry Defaults

      Item Master Data Entry Defaults are selections that remain the same for most of the items for a particular Class and Type. These Defaults are entered in System Setup Inventory Part Class and will be automatically filled in by ManEx once the Item Class and Type have been selected during data entry of a new Item.  Defaults can be over-ridden during data entry.

      For instance, if the User wished to make the Default entry for Item Package to be REEL for all Items with the Class RES-SMT and the Type 0402, the User should select REEL in the Package field of the System Setup when entering Type “0402" as shown in the example.

       



      The same procedure would be used to set up Defaults for all of the fields for each Item Master Class and Type as shown.  The information entered in each of the Default fields will be automatically entered in the corresponding field during data entry of a new Item after selecting the Class and Type.

      Defaults should be setup to apply in most cases. If the default in a particular field is not appropriate for a new Item being entered, the User may make another choice on a one-time basis or if the default has changed. Use System Setup Inventory Part Class to change the default.  If too many over-rides are necessary for a particular Type, it may be too general. Consider splitting it into two Types, each with its own set of Defaults. Changed defaults only affect future data entry, not items already entered.  Each existing item must be reassigned to a new Type before the old Type can be deleted from setup.

      1.5.1.2. Introduction for ICM Mgmt

      Information entered and maintained in the Inventory Control Management Module is used in nearly ALL of the ManEx Modules.  Product, assembly and part information that is necessary to plan, purchase, receive, inspect, stock, issue, kit and cost all items can be found and should be maintained in this location.   In particular this information includes:

      • Item Master Part and Product Descriptions, Classifications and Revisions
      • Purchasing Parameters, Buyer Assignments, Lead Times and Units of Measure
      • Inspection, Certification and Specification Data and Notes
      • Warehouse Assignments, Inventory and Stocking Locations and Quantities on Hand
      • Material Requirements Planning Variables, Re-order Policy and Re-stocking Method
      • Internal and Customer Approved Vendor List with Manufacturer Part Numbers
      • Our system operates on a "Standard Cost Basis" (for further information see Article #3386 ) and Purchase Price Weighted Averages for Parts and Assemblies
      • ABC Classification for Cycle Counts, Buyer Assignment and Inventory Stratification
      • Supplier Name and Supplier Part Number
      • Manufacturing Specifications with either a .bmp or a .pdf file
      1.5.1.3. Fields & Definitions for ICM Mgmt
      1.5.1.3.1. Summary Tab
      The Summary Tab (screen) displays the results of an Inventory Find operation and is the starting point for further sorts, searches and selections based on Part Number, Part Class or a word or string of characters in the Description field. To view detailed information on a particular item, highlight the item and click on the appropriate Tab. An example Summary screen for all Internal Inventory is shown below

      Note:  To display changes made in other windows or by other Users while this window is open, you must repeat the Inventory Find and refresh the screen data.



      If a particular item does not appear on the Summary Screen, it may have been excluded by an Inventory Find that was too specific. Click on the Find a record and broaden the search criteria to display more records. Clicking OK with “Internal Inventory” and both “All Records” boxes checked will display ALL Internal items. Display all Consigned or In-Store records for a selected Customer or Supplier the same way.

      Sorting, Searching and Selecting in the Inventory Summary Screen

      • To sort the contents of the Summary screen by Part Number, Part Class or Description, click the button at the top of the column.
      • It will turn red and the list will automatically sort in ascending alphanumeric sequence per the selection.
      • To search for an item by Part Class, click Class and enter the first few characters of the Part Class in the Search by Part Class field.
      • The list will scroll down to the first incidence of each character in the sequence entered. If a character is not found in the position typed, the list will scroll to the bottom.
      • To Search for an item by Description starting with the 1st character on the left, click Description and begin entering the first characters in the field. The list will scroll down to the first incidence of each character in the sequence entered. If a character is not found in the position typed, the list will scroll to the bottom.
      • To Search for an item by a word or character string anywhere in the Description, click on Description, click on the Left button next to the Search by Description window (changes to “Random”).
      • Enter the search word or characters in the window. Hit return and the first match in the list will be highlighted. Click on the window and hit return to highlight the next match in the summary list.  After the last match or if a match is not found, the last item in the summary list will be highlighted.
      • To visually search the summary list, use the scroll bar or arrows to the right of the list. The Source (Buy, Make, Consigned or In-Store) and total On Hand quantity is displayed in the last two columns.

      For further Details on any item in the summary list, highlight the item by a search or mouse click and select the appropriate Tab to display the desired detail information.

      To display changes made in other windows or by other Users while this window is open, you must repeat the Inventory Find and refresh the screen data.
       
       

       

        This button will take the user to a screen, where they can make a selection by what ever criteria needed by choosing (internal part number, mfgr part number, customer part number, supplier part number, or description) to search.  

       

      The following screen will appear: 

       

      The user can enter partial string and search is not case sensitive.  After system finds parts in response to the search (inactive parts will be highlighted in Purple),  the user can make a selection by checking on one of the check boxes located at the left.  If system was unable to find the exact match, a message will appear up in the right hand corner (in red) to let the user know that the part did not exist in the item master but the following are similar parts found. 

      The user can choose to Select Without Exit; Select & Exit; or Exit Without Selection. 

       

      1.5.1.3.2. Item Master Tab
      The following fields may be viewed in the Item Master screen. This screen is the starting point when the Add a New Inventory Record Action button is clicked or an existing record is highlighted within the summary screen.   Clicking the Edit action button allows editing of existing Fields that are not grayed out.  The ICM module will display "Internal" in the screen Header/Title bar, if internal inventory is open, and display the Customer name in the Screen Header/Title Bar if you have consigned inventory open.  This will allow users that have multiple inventory screens open at the same time to seen at first glance which screen contains what type of inventory data.  


       
      See Article #4765 for further detail on how to Use the X-Reference Find

       

      Item Master Tab Field Definitions

      Part Source
      This field is hard coded in the system. Select BUY for purchased parts and assemblies, MAKE for an item made in-house (assemblies and sub-assemblies) and PHANTOM which is a list of parts that is common to several subassemblies. 
       
      A good example of where a Phantom can be used is a video card with different memory options.  On all the variations of the memory card, there are a lot of parts which are common, including the circuit board.  If we assume the only thing unique to each assembly is the amount or type of memory component and a couple of resistors, then the parts common to all the assemblies can be listed as a PHANTOM assembly.  The PHANTOM part number is then listed as a component under each of the top-level assemblies.  The BOM of the Phantom is exploded in the kitting module as if they were part of the BOM (hence the word Phantom) and pulled with the top level assembly.  It becomes easy to maintain these BOMs since one change in the Phantom will ripple through all the video card variations. 
      Phantom/Make If the Part Source is a MAKE and this box is checked, the system will treat the part as a Phantom when the sub-assembly components are called up during the Kitting process BUT as a Make part for a stand alone assembly when the part is NOT a sub-assembly.

       

      You can assign the status of "Make/Phantom" to a sub assembly.   In this condition, it will cause the components to be added to a kit for the top assembly as if it was a Phantom BOM. On the other hand, you can also create work orders and demands for the sub assembly itself.  The difference between this Make/Phantom and a straight Phantom is that you cannot build the straight Phantom.

       

      Phantoms We suggest that the user utilizes this feature, especially if the subgroup of parts are going to be used in more than one top assembly.   If the subgroup has a modification to its BOM, the user does not have to go to each top level and change all of them.  By simply changing the BOM in the Phantom assembly  (or Make/Phantom), the kitting for all top assemblies including this subassembly will be changed to the new configuration.   If you did not use the Phantom, and copied the parts into numerous top assemblies, you will have to make a change to every one of them if the subgroup of parts was modified.
      Make/Buy

      Make/Buy is setup to allow users to have a part in the system that they wished to BUY but also keep documentation within the system (BOM).  If the Part Source is a MAKE and this box is checked, the assembly MUST be purchased from an outside sourceIf a Part is marked as Make/Buy within Inventory the MRP will only give PO Actions and that product will NOT be available for selection within the Work Order Management module, (due to MRP calculating incorrect demand and showing incorrect message with safety stock).  If the part souce on a product is originally setup as a MAKE the user WILL be allowed to edit the record and change the part souce to Make/Buy.  For further details see Article #3289 .

      Part Class

      This is a general part, product or item classification that must be selected from the drop-down box.  If an appropriate choice is not available when entering a new item, you may add a new part class in Inventory Part Class, (examples of Part Classes are BATTERY, DIODE, FUSE, FILTER, IC-SMT, CAP-SMT, RES-TH, etc.)

      Part Type
      Type is a sub-classification of Part Class. If an appropriate choice is not available when entering a new item, you may add a new part type in Inventory Part Class (examples of Part Types for the Class IC-SMT would be 0603-5%, 0805-10%, 0805-5%, 1206-5%, 1210-5%, etc.)
       
      NOTE:  A user does have the option of leaving the Part Type blank, however if this option is selected the prefix for the part number will be omitted.  There is no reason to enforce part type if a user doesn’t want to have that kind of detailed classification.  If the user decides to leave the Part Type blank they will receive a message and at  this point they have the option to continue or go back and pick a Part Type.
      Description

      There are 45 characters available to put descriptive data about the item being entered that is not already in Part Class and Part Type. For instance, in the previous figure the Part Class and Type already show that it is a RESN-SMT 2512 so this information need not be repeated in the Description.  We suggest when entering the description, that you be consistent with your capitalization and punctuation.  Some of the screens and reports can be sorted by description so the more consistent you are the easier it will be to use the system in the future.

      Material Type

      This field is an Item fields which is repeat at the top of all Tabs to display the selected Item.  

      If the Inventory Material Type is set to "Auto" (within the Material Type Setup), everytime the user modifies the AVL material type, the program will update the Inventory Material Type automatically. 

      >> If any of the AVL material type for the item is 'Unk' - the item level type will be 'Unk'
      >> If any the material type is the same for all of the AVL's of the same item, the material type for the item will be the same as material type of the AVL's without a suffix.  For example:  if AVL types is anyof the 'LF-P/N', 'LF-Date', 'LF-Mark', the material type for the item will be 'LF'.  If AVL's material type is 'ROHS-P/N', 'ROHS-Date', 'ROHS-Mark', the item's material type will be 'ROHS'
      >> If any of the material type of the AVL's for the same item are different and none of them is 'Unk' then the type of the item will be 'LF'

      Any changes to the AVL material type that drives the item material type to a lower level will display a warning.

      If the control is set to "Manual", then the user will be able to modify the Inventory Material Type from the Material Type pulldown.  Keep in mind that the program will NOT validate if the material type in Inventory and AVL levels are in sync.
       

      The AVL Material Type is carried forward for the consign part when the consign part is first added to the system or when new AVL was added to the internal part and the user elects to add this AVL to the existing consign parts.  If the user later changes the Material Type on the internal part, the change is NOT carried over to the consigned part. 
       
      Changed This field will display the date of the last change to the material type.  
      Initials This field will display the initials of the user that made the last change to the material type.
      Serialize

      This box will be available only if the option to use Serial Number Tracking in Shop Floor Tracking Defaults is set up.

      The system allows this box to be check for a MAKE or BUY part. If this box is checked for a BUY part, all components are being tracked by a serial number that was assigned to the part at time of receipt. If this box is checked for a MAKE part, the FG assemblies will be tracked by the serial number through complete process. Note:  Once a serial number for a MAKE part is created, we don't allow user to turn off the serialized checkbox anymore, even if there is no qty on hand and all accounting records are cleared.  This is so no history of Shop Floor tracking, shipping, RMA’s, etc. . . . for the Make Parts are lost. 

      If a user changes a non-serialized part to a Serialize part the system will check.  * If the part has allocated qty, (user has to un-allocate parts before the system will allow user to check the "Serialize" box).  *If  the part has any OPEN kit (kit in process), (user has to de-kit or close kit before system will allow user to check the "Serialize"  box)  *If the parts is a BUY part and has un-reconciled PO (user has to reconcile all receipts before system will allow user to check the "Serialize" box).

      After all these criterias are passed, if the part has quantity on hand, the user has to enter the serial numbers to match the quantity on hand.
       
      Note: Users have to have special access in order to modify this checkbox, this access is assigned through Security/User Rights. 
      Status All items must be Active in order to buy, receive, issue, invoice or ship. Use Inactive Status to remove items from use that have already had transactions against the Part Number.  Use Delete button to delete Items with no transactions.  Changing status from Active to Inactive (for a Make Inventory part) will NOT change BOM status. User will have to change BOM status seperately.  Changing from Inactive to Active status can be used to release items from Engineering.  Note:   If WIP (Work-in-Process) exists for a part the system will not allow the part status to be changed.  This will prevent any possiblity's of qty on hand being returned to an inactive part if the users would happen to dekit.   
      Part Number

      Item/Part number is a unique identifier for every Item Master record entered in the database.  Part numbers can be setup to be manual numbered, or auto assigned to all items except MAKE assemblies, or all items including MAKE assemblies (within the Number System setup module). The standard part number is a 3-digit dash seven digit format where the three-digit prefix is used to define the part class, part type setup in the Inventory Part Class setup module to work with auto or manual numbered parts and assemblies. A manually assigned part number can be 25 characters.  Alphanumeric part numbers are permitted.  The revision field is 4 characters, also alphanumeric. ManEx uses separate assembly and revision fields making it easier to group all revisions of the same assembly and verify that the correct version is selected for production

       ABC
      Stock/BOM UOM
       

      This is the Unit Of Measure (Foot, Inch, Each, Gallon, Quart, etc.) that is used to specify how much of the Item displayed or being entered is issued from Stock or is used in a Bill of Material for an assembly.   ManEx tracks stocking units of measure within inventory, kitting, MRP, etc.   

      Purchase UOM
      This is the Unit Of Measure (Foot, Inch, Each, Gallon, Quart, etc.) that is used to specify how the Item displayed or being entered is purchased from a supplier.

      NOTE:  When creating a PO for an item with different purchasing and stocking UoMs, be sure to enter the MRP suggestion into the Stocking qty field rather than the purchasing qty field.  The system will automatically convert the stocking unit into the purchasing unit for the purchase order qty.

      For example if  the buyer is creating a PO for an item that is used by inches but sold by the foot, the user would enter the 24 inches into the stocking qty field and the PO would automatically convert it to 2 feet in the purchasing qty field.  So the supplier deals in feet, but ManEx deals in inches.  The conversion between the two are established in the Unit of Measure & Conversion  module. 

      Once the items have been accepted into inventory it is then converted over to Stock UOM and from that point forward everything within the system is using the Stock UOM.
       
      ManEx DOES NOT recommend changing either of the UOM's if the part has a qty on hand.  See Article #3414 for further detail.
      Package

      This field defines how the components are to be packaged (ie. Reel, Tray, 6-Pak, Ream, Individually, etc.) when it is delivered.  This defaults to what is setup in the Inventory Part Class setup.  User can edit this field to fit the component package as it is purchased for your organization. This will default to the PO Screen.  The buyer has the right to override the package definition in the item master or on the PO screen.  (ie. Reel, Tray, 6-Pak, Ream, Individually, etc.)

      Last Changed This captures the date,and time from the password of the individual making the changes to this screen and/or changes to the fields displayed on this screen from outside modules. Anytime an edit/save occurs this field is updated.   Note:  This field will NOT be adjusted from outside modules that change the costs, such as the Purchase Order module or the Cost Adjustment module those Last Changed dates will be displayed in the Last Changed fileds displayed next to the costs. 
      By

      This captures the initials from the password of the individual making the changes to this screen and/or changes to the fields displayed on this screen from outside modules.  Anytime an edit/save occurs this field is updated.   Note:  This field will NOT be adjusted from outside modules that change the costs, such as the Purchase Order module or the Cost Adjustment module

      Buyer

      This field is automatically filled in from the information entered in the Inventory Part Class setup module.  This field is used in the MRP lookup as a sort field to allow a buyer to find the parts they are exclusively responsible to purchase.  If a buyer leaves or is replaced, there is a global replacement of one buyer to another located in the System Utilities.exe/Change Parameters for the Part/Class

      Mgmt Lock

      This option is for Inventory parts that need to be protected, even from those users that have edit capabilities. Only Supervisors or users with Lock/Unlock rights within the Security/User rights can modify this checkbox.  If locked, all users can access the screen, but only supervisors or those with Lock/Unlock rights will have the capability to bypass the lock and make changes, while the Inventory part is still in lock mode. The reason we do NOT force the user to unlock the Inventory part before making any changes, is to protect it from anyone else making changes while the 'authorized" user is making their changes.

      Lock Date This displays the date and time the Approved user implemented the Mgmt lock.
      By

      This is the users initials that implemented the Mgmt lock.

      Configuration Charge

      This is NOT a part of the standard cost total.It is a specific cost used with the MANEX Order Configurator module and represents any additional cost over and above the standard cost total.

      Run Scrap %

      This amount is added to the exact quantity used on an assembly to provide an overage to cover losses during running due to predictable machine and human losses.

      Setup Scrap Qty

      Setup losses may be added to the BOM requirement and Run Scrap for an item.For instance, an auto-insertion machine may use extra parts for alignment checks.

        Depressing this button will give the users the ability to scan any related documents directly into the ManEx system and attached the document directly to the item in the ICM Module.  For further detail see Article #2396.  If this button is displayed in Red there is Related documents attached. 
      Inspection / Quality Spec

      Checking the box will cause the item to require inspection to whatever Quality Spec. shows in the Quality Spec box. The Quality Spec appearing in the box is entered in System Setup Inventory Part Class Setup. Any Part Type in a particular Part Class can have Inspection Required turned on or off.

      Certs Required/ Cert Type

      Checking this box will allow selection of Cert Type. Cert Type choices are Receive, Ship or Both.  A typical Cert would be UL or CSA Certification on wire. Check the box and then depress the down arrow for the types to display.  Select the desired type:  Receive - Requires user to check the "Certificate Required" box has been Done at Receiving.  Ship - Requires user to check the "Certificate Required" box on Packing List/SHipping.  Both - Requires user to check the "Certificate Required" box at both Receiving and Packing List/Shipping.  

      First Article Checking this box will alert the users that the item requires a first article check at receiving inspection
      NC NR

      Checking this box, means that once the part is ordered it can not be returned or the order can not be cancelled.

      MRC

      The Material Risk Codes listed in the pull down are entered in the System Setup Material Risk Code Setup. This is to inform the users which items are Low Risk or High Risk (can not be cancelled or returned).

      EAU The quantity displayed in this box is the estimated Annual quantity.  This is calculated from information entered into the ABC Types screen. 
      Last EAU Calculated The date shown in this box is the date the EAU was last calculated in the ABC Types screen.
      PPM (Parts per million)

      This is a data entry field and is not involved in any calculations or used anywhere within the system at this point.It is planned to be used in the future to calculate the component level of PPM and then update the assembly PPM within the routing module.

      Length

      Specific length allowed for part.

      Width

      Specific width allowed for part.

      Depth Specific depth allowed for part
      Weight

      Specific weight allowed for part.

      Material Cost  For BUY Parts:  This is the purchase price of the BUY part.  For MAKE Parts:  The sum of the STANDARD COSTS of BUY parts in the assembly.  Whether or not setup scrap is included is a system setup option.
      Labor Cost For BUY Parts:  If the user wishes to include any preparation labor costs associated with a BUY part, like crimping, tinning testing. etc., those costs may be included here.  For MAKE Parts:  The user may include the labor associated with building the assembly.
      Overhead Cost

      For BUY Parts:  Any additional costs associated with the labor, such as heating, lighting, etc., that the user may wish to include in the cost of the inventory value.  For MAKE Parts:  Any additional costs associated with the labor, such as vacations, sick leave, meeting times, etc., that the user may wish to include in the inventory value.

      Other Cost For BUY or MAKE Parts:  This is up to the user  to decide if there are any other costs that should be absorbed in the inventory value. 
      User Defined For BUY or MAKE Parts:  This is a field where a user may define the field name and include any optional costs.
      Standard Cost

      The STANDARD COST of an item is a calculated value determined by the sum of individual costs.  These individual costs may be in any combination of the Material, Labor, Overhead, Other and User Defined costs.   Each of the individual costs should have their own account number in the Inventory Setup , and those accounts will accrue the costs when material is added to inventory.  User MUST have optional rights within the Security module to "Allow Updating Inventory Std Cost and Standard Cost Rollups".

      If ManEx Accounting is neither installed nor active, then there is no value other than reference in including values in these fields.

      Important Notice:  It is very important to have standard costs (as determined above) in place for any part entering inventory.  ManEx allows users to enter a standard material cost at the time of purchase, if one is not already entered.  Without accurate cost data, the inventory value could be next to useless, and major variances would show in Purchase Price, Configuration and Manufacturing Variances.  If the material cost if the assembly does not equal the computed sum of the standard costs of the components based on the system setup, a configuration variance will be accrued.

      Target Price This field is currently only a data entry field and will be reflected in the Purchase Order module for "BUY" or "MAKE/BUY" parts.  This field is not editable for "MAKE" or "PHANTOM" parts.  NOTE:  To assign prices to products ("MAKE" parts), ManEx suggests using the Sales Price List Information module.  This module allows users to enter prices by product and by customer so different customers can have different prices.  This price will default into the sales order, but is still editable within the Sales Order module. 
      Weighted Cost - Last 5
      If the Part Source is a BUY,  the weighted cost is calculated by dividing the extended total cost from 5 purchase order by the total qty from 5 Purchase Orders.  The Purchase Orders used is with the latest version date (example if the original PO date is 1/3/06, but it was revised/edited on 12/5/06 it will use the 12/5/06 date, no matter what was edited on the PO).  (if a user accidently selected the wrong PO to edit and had depressed the edit button, they could depress the abandon changes button to avoid the PO version date from being updated).   
         
       
      Last Changed This captures the date of the last change to the cost within this module and/or the outside modules such as the Purchase Order module and/or the Cost Adjustment module.  

      If the Part Source is a BUY, the purchase history will list information of 10 latest POs.  The PO's will only be displayed on this list if the status is "OPEN" or "CLOSED".  If the PO status is "EDIT" or "CANCEL" it will NOT be displayed on the the list.  The system will select POs by original date.    Note that the User may sort by depressing the Date, Supplier, PO Number, Manufacturer or Price button.  For further detail see Article #3203

      1.5.1.3.3. Quantity Info Tab

      This screen is used to enter, edit and display Warehouse, Location, Manufacturer, and Safety Stock information for an inventory item.   Also, after an item has been entered, complete inventory stock, allocation and usage information by Manufacturer is displayed or available at the click of a button.   All current inventory information about any selected part can be displayed here.

      Header Information fields

      Part Number, Part Class, Part Type, Description and Material Type are Item fields which repeat at the top of all Tabs to display the selected Item. 

        Clicking on this button will display all Active assemblies and sub-assemblies with this item appearing in their BOM.

      Where Part Used field Definitions

      Part Number Is the number assigned to the assembly for which the internal Part Number is a component
      Rev Is the revision number of the assembly
      Description Is the description of the assembly
      Quantity Pertains to the amount of the component used for 1 unit of the completed assembly
      Bom Stat Is status of the Bom (Active, Inactive,etc.)
      Status Is status of the assembly (Active, Inactive, etc.)
      Eff Dt Pertain to any effective dates regarding the assembly
      Obs Dt Pertain to any obsolete dates regarding the assembly
      Item Number Is the item number on the Bom

       

      Clicking on this button will display Inventory Allocations and Shortages for this item by Work Order number, as displayed:



      Part Shortage and Allocation Field definitions

      WoNo Is the number assigned to the Work Order for which the component part is short
      Project No Is the number assigned to a work order for a special project
      Wk Ctr Is the name of the Work Center where the Part Number is short
      PartMfgr Is the name of the manufacturer of this part.
      Wh Is the name of the warehouse where this Part Number is stored
      Location Displays if the shortage is a kit shortage, line item shortage or an allocation
      Qty Alloc Displays the quantity allocated to a specific Work Order or Project
      Qty Short Shows the number of units short for the Work Order

      The User may sort on Work Order Number, Project No, Work Center, Part Manufacturer or Warehouse by depressing the appropriate button.

        Clicking on this button will display all Open, Approved Purchase Orders for this item, as displayed:  (The quantity being displayed is the qty scheduled not the qty on order)



      On Order Field definitions

      Date Represents the calendar date of the Purchase Order
      Supplier Is the name of the Supplier to which the Purchase Order was sent
      PO Number Is the internal number assigned to that Purchase Order
      Mfgr Is the name of the Manufacturer specified in the Purchase Order
      Price Is the amount of money to be paid for one unit in the Purchase Order line item
      Quantity Is the amount of unit(s) scheduled on the PO, not the qty on order

      The User may sort on Date, Supplier, PO Number, Manufacturer or Price by depressing on the appropriate button.

      This field is read only.  The button will be displayed in Red when there are serial numbers present.  Clicking on this button will display all serial numbers assigned to this item, as display: (only if this item is serialized). This information comes from the PO Receiving module or Inventory Handling (Receiving) module and is not editable.

       
       
      Serial Number Field definitions
       
      Sequence # Is the order in which the serial numbers were assigned
      Serial Number Is the number assigned to that part
      WH Qty Is the quantity available in the warehouse being used
      Warehouse Is the name of the warehouse the parts are being stored in
      Location Displays where the parts can be found
      Manufacturer Is the name of the mfg. specified
      Manufacturers Part Number Is the mfg. part number being used

      If the part is lot coded the additional fields will appear on the View Serial Number screen

       

      Lot Code Is the number of the lot
      Exp Date

      Displays the date the parts can no longer be used.  This field is for reference only.  Manex doesn't act on that date to expire the part.  But it is part of the unique combination users can have LOT code A, exp date 01/10/2005 and LOT code A, exp date 01/01/2010 and the system will consider it as a completely different LOT.  

      Reference Is a name/number to identify the Lot.
      PO Number Is the internal number assigned when order is placed.
        This field is read only and is not editable.  The button will be displayed in Red and will be only displayed if the item is Lot Coded.  Clicking on this button will display all the Lot Code Detail assigned to this item, as display below.   All Lot Codes received by Purchase Order (in the PO Receiving module) will have a PO Number displayed against which they were received.  If received using the  Inventory Handling (Receiving) module the PO Number will be empty.  

      Lot Detail Field Definitions

      Lot/Date Code Is the number of the Lot/Date Code
      Expiration Dt

      Displays the date the parts can no longer be used.  This field is for reference only.  Manex doesn't act on that date to expire the part.  But it is part of the unique combination users can have LOT code A, exp date 01/10/2005 and LOT code A, exp date 01/01/2010 and the system will consider it as a completely different LOT.  

      Qty on Hand Displays the qty available in Inventory
      Qty Alloc Displays the quantity allocated to a specific Work Order or Project
      Reference Is a name/number identify the Lot
      PO Number Is the internal number assigned when order is placed

      AVL Information 

      This section will define all the AVL, and Safety Stock information assigned to the inventory part.  The user may Add, Delete, or Edit the AVL information here.  

      When adding new MPN's to the item master, if you do not want the BOM's automatically updated be sure that the "Disable Automatic BOM AVL update" is Enabled.  See article #1477  for more information.  
       
      Note:  When deleting an MPN - keep in mind that the MPN will be deleted from the screen but NOT from the tables. The MPN's that have been deleted are retained in the tables for history tracking purposes.   
          
       

      AVL Field Definitions

      Manufacturers Part Number

      Displays the Mfg. Part Number for an existing highlighted Mfg. Also, Used to enter Mfg. Part Number during data entry.  If no manufacturers Part Number is entered into the Inventory Master during data entry, GENR (Generic) will be automatically entered by the system as the Manufacturer and the Manufacturers Part Number will be left blank. If a Buy item is fabricated by a customer, then the Customers name must be added to the list of Manufacturers and the Customers Part Number entered in the Manufacturers Part Number field. 

      Manufacturer

      Any Manufacturer entered in Part Manufacturer Setup can be selected in this field. If no specific Manufacturer is required, GENR. (Generic) may be used to show that any Manufacturer is usable.  Also displays Manufacturer for an existing inventory record choosen.

      Pref This is a number indicating the preference for use in Work Order Kitting for each Manufacturer shown. The number 1 indicates 1st ranking, 2 is 2nd ranking, etc. User will only be allowed to enter postive numbers (1 through 99).   If no preference code is entered the preference automatically is assigned 99. All items will be at the bottom of the preference list unless the user assigns another number to it.  For further detail on how the preference code is used in MRP see Article #3032 .
      Safety Stock

      Enter in a qty that you want kept on hand for this specific AVL.  User may have safety stock for more than one AVL for a given part number.  (Safety stock is calculated in MRP at the AVL level NOT the part number level).  This qty is in addition to the MRP demands.  ManEx will ensure that there is always the safety stock qty on hand regardless of the MRP demands.  Please see Article #2331 for more detail.  (This field is calculated off of the Stock UOM). 

      AVL Material Type

      Select from the pull down, Unk, LF-P/N, LF-Date, LF-Mark, RoHS-P/N, RoHS-Date, RoHS-Mark. See Article 2267 for definitions. These choices have been defaulted in.  Customers may establish the logic by which the material type for the parts are established by the material types at the AVL level in Material Type Setup

      The AVL Material Type is carried forward for the consign part when the consign part is first added to the system or when new AVL was added to the internal part and the user elects to add this AVL to the existing consign parts.  If the user later changes the Material Type on the internal part, the change is NOT carried over to the consigned part.

      If the Inventory Material Type is set to "Auto" (within the Material Type Setup), everytime the user modifies the AVL material type, the program will update the Inventory Material Type automatically, if the control is set to "Manual", then the user will be able to modify the Inventory Material Type from the Material Type pulldown.  Keep in mind that the program will NOT validate if the material type in Inventory and AVL levels are in sync. 
      AVL Material Value This field is a text modifier for a given material type.  For example, if the material type was "LF-Date", the text in the field could be a date code.  This value could be different for various AVL with the same Material Code.  This field is optional and does not have to be populated. 

      This field is to add the AVL(s) to a consigned part.  

      Allow Auto Creating Location at Receiving (Selected AVL)
      Note: Users have to have special access in order to modify this checkbox, this access is assigned through Security/User Rights. 

      If the box is checked (for the highlighted AVL) it will allow the user to create a location when entering the Purchase Order or at PO Receiving. Note:  The "Allow Auto Creating Location at Receiving" box must be checked also in Warehouse Setup.
       
      If the user has the "Remove location with this warehouse from the Inventory when qty on hand gets to zero Box" box checked within the Warehouse Setup Setup module this box MUST be checked also.
      There are situations where the Users customers will allow them to use up non-conforming inventory, but cannot replace the same AVLs. So, at the AVL level, we added two logic fields that would signify that the AVL is NOT to be purchased and/or kitted.   In such a circumstance, it is NOT appropriate to delete the parts, but neither can they be purchased for future requirements.  Likewise, they may want to avoid kitting  so you would check these boxes to "Disallow this part from Purchase and/or Kitting".  For special circumstances,  the user can override the block from kitting if their customer permits it.  For further information on how to use these fields effectively refer to Article #2329 For information on how these fields affect MRP refer to Article #3211 .  (See the non-nettable function for the warehouse level described below).  
      AVL Qty on Hand Total qty on hand for each individual mfg.
      Total Qty on Hand

      Total qty on hand for all mfg.'s combined

      Total Allocated Qty Total qty allocated to a specific work order or project
      Total Available Qty

      Total qty available minus the allocated qty

      Add

      Allows data entry to add Manufacturer record. Enter Manufacturer part number and a drop down list will appear to choose the Manufacturer. Click on the save button and the information entered will be displayed in the screen.

      Delete

      Deletes the highlighted manufacturer part number record. A ????? screen will appear. Click the NO button to restore the deleted record if this button is clicked in error. Deletion of manufacturer part number records is not allowed if a Warehouse quantity other than zero (0) is shown for that record. Before manufacturer records are deleted, please realize that SOME of the history regarding the manufacturer may also be deleted.

      Save Appears after clicking the Add button. Clicking on this button saves the record
      Cancel

      Appears after clicking the Add button. Click to abort saving a new record or changes to existing records.

      Warehouse Information

      This section will define all the Warehouse information assigned to the inventory part.  The user may add or edit the Warehouse information here also.   

       

      Warehouse Field Definitions

      One of these radials must be checked.   Internal (User owned) or In-Store (supplier owned).  This selection is available only for "BUY" parts.  This selection will not be displayed for "MAKE" or "PHANTOM" parts.

      Last Count

      Displays the date of the last physical Inventory or Cycle Count for the highlighted item in the Warehouse/Location/Manufacturer display window.

      Warehouse

      Used to display the stocking Warehouse for an existing item or to select a Warehouse during entry of a new Location or Manufacturers Part Number. Only Warehouses entered in Warehouse Setup may be selected in this field.

      Location

      Allows entry of any Location code desired. It could be an area assigned for Finished Goods, High Value items, Programmed parts or a Row, Aisle and Shelf Code. Also displays Location for an existing highlighted Warehouse record.  This field is flagged "Read Only" for MRB whse (meaning you can not create a location for an MRB whse).

      Netable (box)

      If this is checked, any On Hand inventory of the item in the Warehouse location being added or highlighted (if already added) will be used to fill Material Requirements Planning stipulations when processing the MRP.  If you want to exclude this part from MRP and Kitting Issue screens, uncheck this box.  You Cannot have a netable part that is excluded by MRP.  The only warehouse that is non-netable is the MRB warehouse. Any parts in that warehouse are deemed questionable until the parts are validated and returned to a normal warehouse.  So they will not be considered by MRP. 

      Validated (box)

      This is for reference only and does not affect any other modules in Manex. This is simply to help users keep track of changes and for the users to check that the part being added has been verified as appropriate. 

        or  

      If Enabled ManEx will add the new AVL to all existing BOMs and check them as approved.  If Disabled ManEx will add the new AVL to all existing BOMs but will NOT mark them as approved. Then they will not drive any demands or be available for pulling to that kit.  Then you will have to manually go into each individual BOM and Check mark the ones that you do intend to use that new AVL on.  See article #1477  for more information.

      On Hand

      Shows the total quantity of the Manufacturer Part Number indicated which is currently in the Warehouse and Location shown.

      Allocated

      Quantity of the item that has been allocated to a Work Order in the Inventory Mgt./ Kitting, Allocating and Shortage Management/ Work Order Allocation screen.

      Available

      (Calculated field) Equals the quantity On Hand minus the Allocated quantity.

      Add

      Allows data entry to add a Warehouse, and Location. A drop down list appears to select a warehouse.  Enter in a location if you choose.  Click on the save button and the information entered will appear in the screen.

      Delete

      Deletes the highlighted Warehouse record.  A reminder screen will appear.  Click the NO button to restore the Deleted record if this button is clicked in error. Deletion of Warehouse records is not allowed if a Warehouse quantity other than zero (0) is shown for that record.Before warehouse records are deleted, please realize that SOME of the history regarding the warehouse may also be deleted.

      Save

      Appears after depressing the Add button.  Depressing this button saves the record.

      Cancel

      Appears after depressing the Add button.   Depress to abort saving a new record or changes to existing records.

      1.5.1.3.4. MRP Tab (Material Requirements Planning Info Tab)

      This Tab displays the screen in which Material Requirements Planning parameters are entered, edited or viewed. Default choices for each of these fields may be selected in System Setup Inventory Part Class Setup.

      Header Information fields

      Part Number, Part Class, Part Type, Description, and Material type are Item fields which repeat at the top of all Tabs to display the selected Item.
       
      Note:  All lead times are calculated with the Production Calendar.

      Order Policy field

      This field is used to select the method used by the Material Requirements Planning module to combine requirements for this item in creating Planned Purchase Orders (PO’s).   For instance if the choice is “Lot for Lot”, for a BUY part, the Material Requirements Planning module will plan one PO for the total requirements on a daily basis.  If the choice is "Lot for Lot" for a MAKE part MRP will calculate off of each Sales Order individually .  If the choice were “Weekly”, for a BUY part, the Material Requirements Planning module would combine all the requirements each week and plan one PO on the first requirement day for the entire week’s needs, etc. Note: If order policy is left blank "Lot For Lot" will be used upon default for MRP calculations.

      Min Order Qty field

      This is smallest number of the item that can be ordered from the supplier in one PO. For instance, Surface Mount components on a reel usually have a minimum order of 1000 items or more.  (This field is calculated off of the Stock UOM).

      Order Multiple field This field defines the even multiples of the Unit of Measure in which an item must be purchased. For example, 16AWG Wire might be only available in even hundreds of feet on a spool in which case the Material Requirements Planning module would plan a PO for the next higher even hundred above the requirement.  (This field is calculated off of the Stock UOM).
      Purchase Lead Time field This field will be displayed for a Buy part or a Make with Make/Buy Flag part.  Purchase of all items other than In-Store items requires that the PO be placed a minimum number of days before the actual requirement. This Lead Time requirement is what tells the Material Requirements Planning module how many days before a requirement to plan a PO.  Changing the leadtime of a Buy part will NOT change the due date in MRP, only the date to take action.  For more detail see diagram shown below.
      Kitting Lead Time field

      This field will be displayed for a Regular Make part or a Make with Make/Phantom Flag part.  This Lead Time requirement is what tells the Material Requirements Planning module how many days to allow for kitting. Changing the kitting leadtime of a Make or Make/Phantom part will change the due date in MRP.  A TRUE phantom does NOT require any lead times and should be left blank.  BUT . . . if for some reason you need to add a lead time for a TRUE phantom ManEx does have the capability. For more detail see diagram shown below.

      Production Lead Time field 
      This field will be displayed for a Regular Make part, a Make with Make/Phantom Flag part or a Straight Phantom part.  This Lead Time requirement is what tells the Material Requirements Planning module how many days to allow for production. Changing the production leadtime of a Make or Make/Phantom part will change the due date in MRP.  A TRUE phantom does NOT require any lead times and should be left blank.  BUT . . . if for some reason you need to add a lead time for a TRUE phantom ManEx does have the capability. For more detail see diagram shown below.
       
      NOTE:  Once the parts have been pulled to the kit and the kit status is changed to "Kit in Process" MRP is designed to calculate from the Kit Shortage and production lead time NOT from the production offset lead times.  Once the parts have been pulled to the kit, the system is assuming that the shortages are needed by the WO due date, rather than the Production offset lead time, so MRP then calculates using the production lead time and due date of the WO as the date the materials must be on hand, MRP no longer takes the production offset lead time into consideration.
      Pull In Days field

      When PO due date is more than this number of days too late for a Material Requirements Planning module requirement, a PO Due Date change Action Notice will be generated.   It allows the user to have the flexability for SO and WO due dates to be different without MRP actions being generated.    For more information on how the Pull-in days work within MRP see Article #2557.     Note:  These parameters may be thought of as filters for MRP Order Actions when the requirement dates for the parts changes In the case of the customer pulling forward their required date, it is a greater imperative that the work orders (thus the assembly) be pulled in to match the earlier due date.  So the assemblies should probably have a minimum number of days to be sensitive to earlier demandsSee attached Document <<pullin-pushout discussion.docx>>.

      Push Out Days field

      When PO due date is more than this number of days too early for a Material Requirements Planning module requirement, a PO Due Date change Action Notice will be generated.  Example: if there is a PO that is due to be delivered Dec 15, but now it is not needed until Dec 26 and the Push out is 30 days, then there WOULD NOT be a message issued within MRP to reschedule the PO delivery, because it is within 30 days, but if the Push out was 5 days then an action  message WOULD BE issue to reschedule the delivery because the new date was outside of the push-out days.      It allows the user to have the flexability for SO and WO due dates to be different without MRP actions being generated.  For more information on how the Push-out days work within MRP see Article #2557.     Note: These parameters may be thought of as filters for MRP Order Actions when the requirement dates for the parts changes.    The Push Out value (in days) is the number of days that the required date, base on MRP, may be pushed out (required later than the original date) but will not result in a change order to move the required delivery for the item involved.  See attached Document <<pullin-pushout discussion.docx>>. 

      Re-Order Point field

      To use the Re-Order Point and Re-Order Qty rather than Material Requirements Planning for reordering this item, enter the quantity at or below which the item should be replenished. Print the "Inventory Material Reorder List" report to show items which have dropped below re-order point minimums.  NOTE:  The Re-Order Point/Qty fields have NO AFFECT on MRP at all.  MRP will NOT consider these fields for any calculations (these fields have no connection with MRP).  These fields are intended to control stock on overhead items.   (This field is calculated off of the Stock UOM).

      Re-Order Quantity field To use the Re-Order Point and Re-Order Qty rather than Material Requirements Planning for reordering this item, enter the quantity of the re-order here. Print the "Inventory Material Reorder List" report to show items which have dropped below re-order point minimums.  NOTE:  The Re-Order Point/Qty fields have NO AFFECT on MRP at all.  MRP will NOT consider these fields for any calculations (these fields have no connection with MRP).  These fields are intended to control stock on overhead items.    (This field is calculated off of the Stock UOM).  

       

      1.5.1.3.5. Notes Tab

      Notes are usable for text information relevant to this item that is of interest to Engineering, Purchasing, Stores or Planning. A typical note is shown below. These item notes are viewable from the Material Requirements Planning,  Bill of Material and Purchasing screens. 

       

       

      1.5.1.3.6. Customer Tab

      This screen allows users to connect the customer part number and revision with the internal part number and revision.  Entry of a Customer Part Number creates a Consigned Inventory Record that does several very important functions:

      • Serves as the place for selection of each Approved Manufacturers (Customer’s Approved Vendor List) from the list of all Manufacturer Part Numbers for that particular generic part
      • Provides a way to cross reference Customer Part Numbers to Internal Part Numbers
      • Allows generation of Bills of Material with Customer Part Numbers
      • Sets up a Consigned Inventory Warehouse(s) to allow receipt, issue and tracking of this Customer part  

      Header information fields: Displays the Part Number, Class, Type, Description and Material Type selected in the Summary Tab.

      Customer field In View Mode, this screen shows the Customer selected from the Customer window.In Edit Mode, use this field to enter Customer Name
      Customer Part Number

      For viewing or entry of Customer Part Number for the internal Part Number displayed in the Header.

      Display/ select window

      Shows all Customers and Customer Part Numbers for this internal part and their status, (active, in-active, etc).

      Add Add a new Customer and customer part number
      Delete Delete an existing Customer and customer part number
      Save Save new Customer Part Number
      Cancel Cancel a Customer Part Number

      Add Default Warehouse Select to add only the default warehouse to customer side when adding a Customer Part Number
      Copy Warehouse Location from Internal Part Select to Copy Warehouse Location(s) from Internal Part to customer side when adding a Customer Part Number
      Do not add any Warehouse/Location Select if user does not want to add any Warehouse/Location(s) from the interanl side to the customer side when adding a Customer Part Number


      ManEx does not allow user to link same customer with multiple customer part numbers to the same internal part number. Our structure is based tightly on the internal part number. We link to customer part numbers when needed for showing customer part numbers or for MRP AVL limitations. If we allowed more than one customer part number for the same customer, we would not be able to process mrp AVL selection, nor reports that currently show customer part numbers.
      1.5.1.3.7. Supplier Tab

      This screen is for referencing the supplier(s) of this part and the Supplier’s Part Number.

      Header information fields: Displays the Part Number, Class, Type, Description, and Material Type selected in the Summary Tab.

      Mfg field Displays the mfg. selected in the quantity info. Tab
      Manufacturer’s Part Number

      Displays the manufactuer’s part number selected in the quantity info. tab.

      Supplier field

      In View Mode, this screen shows the Supplier selected from the Supplier window. In Edit Mode, use this field to enter Supplier Name.

      Supplier Part Number

      For viewing or entry of Supplier Part Number for the internal Part Number displayed in the Header.

      Default

      Check this box if you would like this supplier to show automatically when purchasing this part number.

      Display Select Window

      Shows all Suppliers and Supplier Part Numbers for this internal part and whether it is chosen as a defalut.

       Add Add a new supplier and supplier part number
       Delete Delete an existing supplier and supplier part number

      Note:  The system allows you to have multiple suppliers per AVL and one default supplier per AVL.  But each AVL can have a different default supplier and different suppliers.

      1.5.1.3.8. Mfg. Part Spec Tab

      This screen is used to view or enter a link to a drawing, photograph,image or .pdf file to be used as an on-line reference for engineering, purchasing, quoting or any other item master usage. It can be an assembly drawing, purchased part specification, spec. control drawing, photograph or any other image or .pdf file linkable to Manex. The image or .pdf file is not stored in Manex. The file in which the image or .pdf file is stored is linked to this screen in Manex and can be maintained without access to Manex.

       

      Header Information: Displays the Part Number, Rev, Class, Type and Description selected in the Summary screen. Displayed on the 2nd line is the manufacturer information:Mfg. Name, Manufacturer’s Part Number, Marking, Package, Body and Pitch.

      Load Picture or PDF document (Buttons): Used to link the Image Space below to a file on the local hard drive or any other location on the network connected to the Manex Server. To Load a Picture, while in the add or edit mode, the LOAD PICTURE button becomes active. Pressing this button prompts the User to enter the location of a picture file created for this particular inventory part.

      Files (pdf.; word; jpeg;, etc.) should be stored in a permanent directory on the server (all users need network security access). The user will define the directory and file for each product in this module, but the information will be available elsewhere throughout the manufacturing module.

      After defining the location for the document, the document is available for viewing, as displayed



      Scroll bars
      : The bars at the bottom and side of the picture allow viewing of the parts of the image that are outside the window’s display. This allows detail viewing of large drawings.

      As soon as you enter the module, Acrobat will load.The user may load a PDF file to the Mfgr Part Spec tab. This allows users access to whole textbooks from within MANEX.PDF files can be drawings, images, CAD files (as printed to a plotter), and multiple pages of mixed text and graphics.Users may also print these PDF files from MANEX.

      PDF and Image files:

      PDF and Image files used in the MANEX system should be placed in the server, where all users have access to them. These files are used in the Product Data Management, Inventory, Customer and Supplier Contact programs. We suggest that the users create an additional directory, called "Images" under the MANEX System directory on the server. So then under the Main MANEX system directory, there would be the \apps, \dbfs, \images and \reports subdirectory.

      If the user is going to make extensive use of the image capability, they may wish to further provide subdirectories under the Image. These might be called "inventory", "PDM", "photos" etc. These files could, in turn, have further subdirectories. For example, under \manex\images\inventory there might be one for each class of part. Or one for make parts and one for buy parts. Under the PDM group could breakdowns by customer.

      Such organization will make it much easier to find files when it is time to update them. MANEX can accommodate file path-names up to 100 characters long.

      While viewing a PDF document, the user may scan and zoom throughout the document. Items may be copied from it, and the document can be printed from the MANEX program, as long as there is a default printer assigned to the workstation.

       

      1.5.1.4. How To ..... for ICM Mgmt
      1.5.1.4.1. Find an Inventory Control Record

      Entering the Inventory Control Management Module.  Depress Inventory Mgt/Inventory Control Managment/Inventory Control Management. 

       

       

       

      The main screen will appear.

       

      Inventory Find Prerequistes

      In order to Find items with certain characteristics or parameters using the Inventory Find Screen, the items must have been entered in the Item Master with those characteristics. Listed below are the pre-requisites for doing 3 different kinds of Inventory Finds:

      • Internal items must be in the system to be found.Searches for parts between a Starting number and Ending Part Number must include the prefix and any dashes or special characters.
      • A part cannot be found in an “In-Store part find” unless it has been set up with an In-Store warehouse and supplier in the Item Master Quantity Info. screen.
      • A Consigned record cannot be found for an item until the Customer has been entered and the item has been given a Customer Part No. in the Item Master Customer Reference screen.

      When the user does an Inventory Find, in order to speed up the process the user may eliminate the quantity display.

      Depress the Find button. The following screen will display:

       

      Note that the default is for the Summary screen to NOT display the quantity.

       

      If the user wants to have the quantity display on the Summary screen, highlight the desired part number and right click your mouse. The quantity will display for the one part number:

       

      If the user wants the entire summary screen to display all of the quantities, then select the Display Summary Quantity radio.

      Inventory Find Search Field Definitions

      • Internal Inventory – Products, Parts and Assemblies purchased, received, stocked, issued and shipped using standard in-house internal item numbers.These numbers are required and serve as the basis for creation of Consigned and In-Store parts. Just clicking on OK with the default selections shown in the preceding Find Screen will bring up all internal inventory parts in the Item Master Summary screen.
      • Consigned Inventory – these records are created every time a Customer Part Number is entered in the Item Master Customer Reference screen. These records are used to enter Customer requirements (Approved Vendor List) and preferences (choices within the Approved Vendor List) for Manufacturers for a given Part Number.It is also where Customer-owned item inventory levels and locations can be seen.
      • In-Store Inventory – any internal item can be setup with an In-Store Inventory for a Supplier under contract to supply that item. In-Store items are setup in the Internal Inventory Item Master Quantity Info screen and can be viewed individually in that screen or as a group by supplier in the Summary Screen as the result of an Inventory Find by In-Store Inventory.
      • Starting Part Number and an Ending Part Number
        • Enter all prefixes, dashes, spaces and alpha charactersto show the entire number.
        • Enter first and last Part Number of a series for those and all items numbered between.
        • Enter a desired single item in the 1st box and hit return to select only that record.
      • Assigned Buyer will bring up all items assigned to that particular Inventory Buyer.The Buyer assignment is made in Part Class and Type System Setup Defaults or in the Item Master.
      • Part Class and/or Part Type will bring up only those items that match all entries made.Both Part Class and Part Type must be specified to bring up any items.
      • Do not display Summary Quantity radio will by-pass the quantity calculation.
      • Display Summary Quantity radio will open up another selection "Total On Hand Quantities"
        • Total On Hand Quantities will bring up only items with matching inventory quantities.The user may choose from Total Quantity on Hand, Quantity on Hand > 0, or Quantity on Hand = 0.
      • Record Status allows selection of All, Active Only or Inactive Only item records.

      Tips on Using the Inventory Find Screen

      • Selection of at least one parameter will reduce the time to retrieve the information.
      • In-Store Inventory searches require that a Supplier Contract be entered in order to select a Supplier.
      • Consigned Inventory searches show Customer-specific information (such as Approved Vendor List information) as well as Consigned Inventory On-Hand Quantities.
      • If no information is selected in a Find operation, try using broader or fewer selection criteria.

      Combination Searches

      Combinations of search parameters may be made for further filtering of the Inventory Item Master files to see item(s) of interest. For instance, selecting the items on the example screen will find all ACTIVE, In-Store Inventory for "Anixter" with the Class “CABLE”.In-Store Inventory Searches are Supplier specific whereas Consigned Inventory searches require entry of a Customer in order to initiate the search.

       

      Inventory Find Example

      The screen shown below is to illustrate Inventory Find results from selecting Internal Inventory, a Part Class of CAP-SMT, a type of 0805, Total On Hand Quantities of Qty on Hand = 0, and Record Status of Active Records Only

       

       



      The first tab (Summary Tab) is used to display the results of an Inventory Find. The remaining Tabs will then display detail information for any item selected (highlighted) in the Summary screen. If no items have yet been entered in the system or copying an existing part is not needed, it is not necessary to populate the Summary screen by doing an Inventory Find. 

      If user has the internal inventory screen open as well as the customers inventory screen open, the customer name will be displayed at the top of the page.  So when switching between the two screens user will easily be able to determine which screen they are in.

       

      1.5.1.4.2. Find an Inventory Control Record Using the X-Reference Find
       

       

        This button will take the user to a screen, where they can make a selection by what ever criteria needed by choosing (internal part number, mfgr part number, customer part number, supplier part number, or description) to search.  

       

      The following screen will appear: 

       

      The user can enter partial string and search is not case sensitive.  After system finds parts in response to the search (inactive parts will be highlighted in Purple),  the user can make a selection by checking on one of the check boxes located at the left.  If system was unable to find the exact match, a message will appear up in the right hand corner (in red) to let the user know that the part did not exist in the item master but the following are similar parts found. 

      The user can choose to Select Without Exit; Select & Exit; or Exit Without Selection. 

      To Select user must check the box to the left of the Part Number.  If user Selects a Part Number (Internal or Customer Part Number) then depresses the Select and Exit button, the part will be displayed in the Summary Tab as shown below. 

        

       

      1.5.1.4.3. Add an Inventory Control Record

      Following a logical sequence when adding items into the Inventory Master not only eliminates lost time due to continual back-tracking, but ensures that decisions will be made in a sequence which will support the data entry process.

      The sequence shown below is for adding products, parts, assemblies, subassemblies or Phantoms to the Item Master after completion of System Setup.

      1. Search whether item already exists.  Use Find an Inventory Control Part to search the existing database along with the archived database, to verify that the items to be added do not already exist. 
      2. Verify Available Class and Type.  Use Find an Inventory Control Part by Class and Type to verify that the item to be added will fit into the existing Class and Types . Refer to System Setup, Inventory Part Class if a new Part Class or Type and the corresponding Data Entry Defaults must be added.
      3. Is Customer available?  If the items to be entered will have a Customer-Specific Approved Vendor List (Approved Vendor List), then verify that the Customer is in the database using Customer Information.  Add the Customer Information if it is not there.  
      4. Does Manufacturer exist?  Use Part Manufacturer Setup to view existing Manufacturers. Enter new Manufacturers for Buy Items as required and enter the Source for Fabricated items being purchased as outside purchased assemblies. Please refer to procedures below.
      5. Add a part/product, etcDepress the Item Master screen tab. Use the Add button to enter the stand-alone product number or the top level assembly number for a Bill of Material (BOM) MAKE item that must be added.  If the product is purchased complete and has no BOM, enter it as a BUY item.  Enter your Password.
      6. Enter information.  Enter all basic item information in the Item Master Screen.

       

      Part Source: This field is hard coded in the system. Select BUY for purchased parts and assemblies, MAKE for an item made in-house (assemblies and sub-assemblies) and PHANTOM for a number used to define a collection of items that does not exist as a separate assembly built on a Work Order (ship kits, upgrade packages, spares kits, etc.).

       

      • Phantom/Make: If the Part Source above is a MAKE and this box is checked, the system will treat the part as a Phantom when the sub-assembly components are called up during the Kitting process BUT as a Make part for a stand alone assembly when the part is NOT a sub-assembly.

      • Make/Buy: Make/Buy is setup to allow users to have a part in the system that they wished to BUY but also keep documentation within the system (BOM).  If the Part Source is a MAKE and this box is checked, the assembly could also be purchased from an outside sourceIf a Part is marked as Make/Buy within Inventory the MRP will only give PO Actions and that product will not be available for selection within the Work Order management module.  If the part souce on a product is originally setup as a MAKE the user will be allowed to edit the record and change the part souce to Make/Buy.  For further details see Article #3289 .

      Part Class: This is a general part, product or item classification that must be selected from the drop-down box. If an appropriate choice is not available when entering a new item, see System Setup/Inventory Part Class to add a part class (examples of Part Classes are BATTERY, DIODE, FUSE, FILTER, IC-SMT, CAP-SMT, RES-TH, etc.)

       

      Part Type: Type is a sub-classification of Part Class. If an appropriate choice is not available when entering a new item, see System Setup/Inventory Part Class to add a Part Type (examples of Part Types for the Class CAP-SMT would be 0402, 0603, 0805,1206, 1210, etc.)
       
      To re-sort the order the part types are being displayed in the pulldown See Article #214
       
      A user does have the option of leaving the Part Type blank, however if this option is selected the prefix for the part number will be omitted.  There is no reason to enforce part type if a user doesn’t want to have that kind of detailed classification.  If the user decides to leave the Part Type blank they will receive the following message:
       
       
      At this point they have the option to continue or go back and pick a Part Type.
       

      Description: There are 45 characters available to put descriptive data about the item being entered that is not already in Part Class and Part Type. For instance, in the previous figure the Part Class and Type already show that it is a CAP-SMT. 0603 so this information need not be repeated in the Description.  We suggest when entering the description, that you be consistent with your capitalization and punctuation.  Some of the screens and reports can be sorted by description so the more consistent you are the easier it will be to use the system in the future.

        If the Inventory Material Type is set to "Auto" (within the Material Type Setup), everytime the user modifies the AVL material type, the program will update the Inventory Material Type automatically, if the control is set to "Manual", then the user will be able to modify the Inventory Material Type from the Material Type pulldown.  Keep in mind that the program will NOT validate if the material type in Inventory and AVL levels are in sync.    

      The AVL Material Type is carried forward for the consign part when the consign part is first added to the system or when new AVL was added to the internal part and the user elects to add this AVL to the existing consign parts.  If the user later changes the Material Type on the internal part, the change is NOT carried over to the consigned.  

      Serialized: Check this box if the parts need to be tracked with serial numbers. This box will allow you to mark either Make or Buy parts as Serialized. 

      Note
      :Users MUST have special access with the Security module for the Inventory Control module to modify the serialized checkbox.
       
      When the serialized checkbox is checked for an existing BUY part and there is open kit records in the system the following message will appear:   
       
      When serialized checkbox is checked for an existing MAKE or BUY part and there are open work orders or inventory against it the following message will appear:
      If user checks the Serialized box and receives the following message, this means that the "Do not use serial number tracking" checkbox is checked within SFT Setup.

       

      Depress Yes and the following screen appears

      If user doesn' t know the available work orders which have FGI qty, he/she can double click the work order number field (red box).

       

      A list with work order numbers and FGI qty for that part number will appear (as shown below).  The user then can select one for entering serial numbers.

       

      The users can enter the serial numbers by clicking "single" or "range" option. 

      Once all the serial numbers have been entered for all work orders the completed screen will look like this.

      Depress the Save button.

       

      The following message will appear reminding the user that they will need to assign serial numbers to the balance of the work orders in order to transfer to FGI.

       

      Status: All items must be Active in order to buy, receive, issue, Invoice, or ship. Use Inactive Status to remove items from use that have already had transactions against the Part Number. Use the Delete button to delete Items with no transactions for further detail see Article #3143.  Changing from Inactive to Active status can be used to release items from Engineering.  The system will not allow you to change the status from Active to Inactive if there is WIP for that item.  This will prevent the possibility of qty on hand being returned to an inactive part upon dekitting.  

       

      Part Number: The item/Part Number is a unique identifier for every Item Master record entered into the database. Part Numbers can be auto-assigned to all items or all items except Make assemblies or all items including Make Assemblies. Use of a 3-digit prefix for each different Part Type may be setup in System Setup Number System to work with auto or manual numbered parts and assemblies..

      ABC: This field allows further grouping of items (parts, products or assemblies) into classes according to: 1) the percent of the total inventory their current stock value represents.2) the percent of total inventory their forecasted value will represent.3) a manual classification based upon chosen factors.  If an appropriate choice is not available when entering a new item, see System Setup ABC Types to add a new Type.

       

      Stock/BOM UOM: This is the Unit Of Measure (Foot, Inch, Each, Gallon, Quart, etc.) that is used to specify how much of Item displayed or being entered is issued from Stock or is used in a Bill of Material for an assembly. Note that in ManEx, the Unit of Measure Each is treated as being an integer unit. That is, you can only have one or multiples of an Each, but not a fraction of an each. You can have fractions of inches, feet, pounds, ounces and any other Unit of Measure. Although you can use fractions in the Bill of Material, the User can't kit fractions of each parts. ManEx will round up to the nearest whole number. The proper way to approach the situation where the kit amount is expressed in fractions, is to use any Unit of Measure other than Each. If an appropriate choice is not available when entering a new item, see System Setup/Unit of Measure & Conversion to set up a new Unit of Measure. 
       

      ManEx
      DOES NOT recommend users to change the Unit of Measure while there is qty on hand within the system.  See Article #3414 for further detail. 
       

      Purchase UOM: This is the Unit Of Measure (Foot, Inch, Each, Gallon, Quart, etc.) that is used to specify how the Item displayed or being entered is purchased from a vendor.  If an appropriate choice is not available when entering a new item, see System Setup/Unit of Measure & Conversion to set up a new Unit of Measure. 
       
       
       


      ManEx
      DOES NOT recommend users to change the Unit of Measure while there is qty on hand within the system.   See Article #3414 for further detail.
       

      Package: Specifies the way in which the Item is packaged when it comes from a vendor (ie. Reel, Tray, 6-Pak, Ream, Individually, etc.)   If an appropriate choice is not available when entering a new item, see System Setup/Part Package to set up additional part packaging.   

      Buyer: All items with the same Buyer's initials in this field will be grouped together for display or printout of the Material Requirements Planning Action List when filtered or displayed by Buyer. If an appropriate choice is not available when entering a new item, see System Setup/Inventory Buyer Setup to set up additional buyers.   

      Last Change 

      This automatically defaults in the date and time of the last change made to this part number in the item master. Once the change has been saved. 

      By

      This automatically defaults in the initials of the user that made the last change to this part in the item master. Once the change has been saved.

      Configuration Charge 

      This is NOT a part of the standard cost total, as discussed below.It is a specific cost used with the ManEx Order Configurator module and represents any additional cost over and above the standard cost total.

      Run Scrap % 

      This amount is added to the exact quantity used on an assembly to provide an overage to cover losses during running due to predictable machine and human losses. 

      Setup Scrap Qty  Setup losses may be added to the BOM requirement and Run Scrap for an item.For instance, an auto-insertion machine may use extra parts for alignment checks. 

      Mgmt Lock:   Only Supervisors or users with Lock/Unlock rights within the Security/User rights can modify this checkbox. If locked, all users can access the screen, but only supervisors or those with Lock/Unlock rights will have the capability to bypass the lock and make changes, while the Inventory Part is still in lock mode. The reason we do NOT force the user to unlock the Inventory Part before making any changes, is to protect it from anyone else making changes while the 'authorized" user is making their changes.

      Lock Date: This automatically defaults in the date and time the lock was implemented to this part number in the item master.

      By: This automatically defaults in the initials of the user that implemented the lock to this part number in the item master.

       

        Depressing this button will give the users the ability to scan any related documents directly into the ManEx system and attached the document directly to the item in the ICM Module.  For further detail see Article #2396.  If this button is displayed in Red there is Related documents attached. 
      Inspection Required/ Quality Spec 

      Checking the box will cause the item to require inspection to whatever Quality Spec. shows in the Quality Spec box. The Quality Spec appearing in the box is entered in System Setup in the Inventory Part Class & Type Setup.Any Part Type in a particular Part Class can have Inspection Required turned on or off. 

      Certs Required/ Cert Type:  Checking this box will allow selection of Cert Type.  Cert Type choices are Receive, Ship or Both.  A typical Cert would be UL or CSA Certification on wire. Check the box and then depress the down arrow for the types to display.  Select the desired type:  Receive - Requires user to check the "Certificate Required" box has been Done at Receiving.  Ship - Requires user to check the "Certificate Required" box on Packing List/SHipping.  Both - Requires user to check the "Certificate Required" box at both Receiving and Packing List/Shipping.   

      MRC 

      This is to inform the users which items are Low Risk, High Risk, etc.This will need to be defined in System Setup Material Risk Code Setup.

      EAU/Last EAU Calc 

      These fields display the Estimated Annual Usage, if applicable and the last date that the EAU was calculated. 

      PPM 

      This field is a data entry field and is not currently involved in any calculations or used anywhere else within the system at this point. It is planned to be used in the future to calculate the component level of PPM and then update the assembly PPM within the routing module. 

      The dimensions such as Length, Width, Depth and Weight are entered in this section  

      Within Security there is the option to allow users to have access (all or partial) to the Inventory Control Management module.  Then within those Inventory Security settings there is a provision for optional additional privileges, including the ability to make changes to the Standard Costs.  Only a user with these rights will be allowed to change any of the costs listed below.  Also, none of the cost listed below will be editable if there is inventory or WIP on hand.  

      Material Cost  
      For BUY Parts:  This is the purchase price of the BUY part.  For MAKE Parts:  The sum of the STANDARD COSTS of BUY parts in the assembly.  Whether or not setup scrap is included is a system setup option 
      Labor Cost

      For BUY Parts:  If the user wishes to include any preparation labor costs associated with a BUY part, like crimping, tinning testing. etc., those costs may be included here.  For MAKE Parts:  The user may include the labor associated with building the assembly.

      Overhead Cost For BUY Parts:  Any additional costs associated with the labor, such as heating, lighting, etc., that the user may wish to include in the cost of the inventory value.  For MAKE Parts:  Any additional costs associated with the labor, such as vacations, sick leave, meeting times, etc., that the user may wish to include in the inventory value.
      Other Cost For BUY or MAKE Parts:  This is up to the user  to decide if there are any other costs that should be absorbed in the inventory value. 
      User Defined Cost  For BUY or MAKE Parts:  This is a field where a user may define the field name and include any optional costs.
      Standard Cost 

      The STANDARD COST of an item is a calculated value determined by the sum of individual costs.  These individual costs may be in any combination of the Material, Labor, Overhead, Other and User Defined costs.   Each of the individual costs should have their own account number in the Inventory setup, and those accounts will accrue the costs when material is added to inventory.

      If ManEx Accounting is neither installed nor active, then there is no value other than reference in including values in these fields.

      Important Notice:  It is very important to have standard costs (as determined above) in place for any part entering inventory.  ManEx allows users to enter a standard material cost at the time of purchase, if one is not already entered.  Without accurate cost data, the iventory value could be next to useless, and major variances would show in Purchase Price, Configuration and Manufacturing Variances.
      Target Price 

      This field is currently only a data entry field and will be reflected in the Purchase Order module for "BUY" or "MAKE/BUY" parts.  This field is not editable for "MAKE" or "PHANTOM" parts.  NOTE:  To assign prices to products ("MAKE" parts), ManEx suggests using the Sales Price List Information module.  This module allows users to enter prices by product and by customer so different customers can have different prices.  This price will default into the sales order, but is still editable within the Sales Order module. 

      Weighted Cost 

      If the Part Source is a BUY, the last five purchases expressed as a weighted average will appear here.

      The completed Item Master screen will appear:

      Click on the Quantity Info tab and the following screen will appear. This screen is split. You must enter in the manufacturer information and click save. Then the system will allow you to add the warehouse and location information.

      If the Inventory Material Type is set to "Auto" (within the Material Type Setup), everytime the user modifies the AVL material type, the program will update the Inventory Material Type automatically, if the control is set to "Manual", then the user will be able to modify the Inventory Material Type from the Material Type pulldown.  Keep in mind that the program will NOT validate if the material type in Inventory and AVL levels are in sync. 

      The AVL Material Type is carried forward for the consign part when the consign part is first added to the system or when new AVL was added to the internal part and the user elects to add this AVL to the existing consign parts.  If the user later changes the Material Type on the internal part, the change is NOT carried over to the consigned.

       

      Enter Manufacturers Part Number: Type in the manufacturers part number.

      Enter Manufacturer: Choose a mfgr from the pull down.  If no Manufacturer is specified use GENR (Generic). If no information is entered in the Quantity Info screen, GENR will be added by the system automatically when saving the item.

      System will not allow users to have duplicate AVL/MPN combinations.  If user has same mfgr and mfgr PN but different material types, we suggest that the user create a new AVL with a dash (or any other symbol) and use that designation to transfer to the UNK material type parts or create a different location for the same part, but have it be non-nettable, making it ineligible as a source for MRP.

       

      Enter Pref: Type in the Preference. (Whether this is a preferred manufacturer and if so the ranking or preference).  If no preference code is added, 99 will be assigned automatically.  All items will be at the bottom of the preference list unless the user assigns another number to it. See Article 943 for more information. The Pref Code is carried forward for the consign part when the consign part is first added to the system or when new AVL was added to the internal part and the user elects to add this AVL to the existing consign parts. If the user later changes the preference code on the internal part, the change is not carried over to the consigned part. 
       
      Enter Safety StockEnter in a qty that you want kept on hand for this specific AVL.  (User may have safety stock for more than one AVL in a given part number).  This qty is in addition to the MRP demands. (NoteSafety stock is calculated at the AVL level not part # level).     ManEx will ensure that there is always the safety stock qty on hand regardless of the MRP demands.  Please see Article  #2331  for more detail.  

      If this option is check marked then the users will be able to automatically create any new Location for this part within the PO Receiving module.  Note:  Users MUST have special access within the Inventory Control Security setup module to modify this checkbox.  There is also a similar check box within System Setup, Warehouse Setup, this will also have to be marked for the warehouse in order for this option to be applied.  

      Depress the save button located at the bottom of the screen. You now have the option of entering an AVL Material Type (as described below) for the existing mfg., enter in another manufacturer part number or creating a warehouse for the existing manufacturer. 

      AVL Material Type: Choose from the pull down, Unk, LF-P/N, LF-Date, LF-Mark, RoHS-P/N, RoHS-Date, RoHS-Mark. See Article 2267 for definitions. These choices have been defaulted in.  Customers may establish the logic by which the material type for the parts are established by the material types at the AVL level in System setup/Material Type Setup

      The AVL Material Type is carried forward for the consign part when the consign part is first added to the system or when new AVL was added to the internal part and the user elects to add this AVL to the existing consign parts.  If the user later changes the Material Type on the internal part, the change is NOT carried over to the consigned part. 
       
      If the Inventory Material Type is set to "Auto" (within the Material Type Setup), everytime the user modifies the AVL material type, the program will update the Inventory Material Type automatically, if the control is set to "Manual", then the user will be able to modify the Inventory Material Type from the Material Type pulldown.  Keep in mind that the program will NOT validate if the material type in Inventory and AVL levels are in sync.
       

      AVL Material Value This is a text field for a given material type.  For example:  if the material type was "LF-Date" user could enter the date code in this field.  The Value could be different of various AVL's with the same material code.  This fields is a reference only field and is optional.

        If the users add new AVL's to the Internal part number, they can add it to a Consigned part number by depressing this button.  A screen will appear and within that screen they can select which AVL they want to add to a Customer consigned part number.   

       

      There are situations where the Users customers will allow them to use up non-conforming inventory, but cannot replace the same AVLs. So, at the AVL level, we added two logic fields that would signify that the AVL is NOT to be purchased and/or kitted.   In such a circumstance, it is NOT appropriate to delete the parts, but neither can they be purchased for future requirements.  Likewise, they may want to avoid kitting  so you would check these boxes to "Disallow this part from Purchase and/or Kitting".  For special circumstances,  the user can override the block from kitting if their customer permits it.  For further information on how to use these fields effectively refer to Article #2329 For information on how these fields affect MRP refer to Article #3211 .  (See the non-nettable function for the warehouse level described below).  

      When the "Disallow Purchase" is checked ON - ManEx will check if any Safety Stock (SS) is entered, if so the following prompt will be displayed and will un-check the checkbox upon depressing the OK button.



      When the "Disallow Purchase" is checked OFF - ManEx will check and if "Disallow Kit" is ON the following prompt will be displayed and will revert the change to leave "Disallow Purchase" ON and leave "Disallow Kit" ON.



      When the "Disallow Kit" is checked ON - ManEx will check if any SS is entered,  if so the following prompt will be displayed and will un-check the checkbox upon dpressing the OK button.  If SS is zero, no message will be displayed and ManEx will auto check "Disallow Purchase"



      When the "Disallow Kit" is checked OFF - ManEx will check and if "Disallow Purchase" is still checked ON the following message will be displayed giving the user the option to uncheck the "Disallow Purchase" but is not required. 





      To create a warehouse, depress the Add button (located under the right hand section of the screen)

      Choose Internal (For In-Store refer to In-Plant Store Manual)  

      Enter Warehouse: Select the Warehouse from the pulldown. In ManEx, the default warehouse is Main 1. If the User has accounting, this would equate to the Raw Materials Inventory. Many Users want to separate their Raw Materials and Finished Goods Inventories. So, if this is a Make part, the User may want to select the finished goods inventory warehouse. Some Users also set up separate warehouses and general ledger account numbers for In-Stores and Consigned.  If no warehouse is selected upon saving the record the system will deafult in the default warehouse setup in System Setup Warehouse Setup

       

      Enter Location The location entered is where the parts will be stocked and/or located within the warehouse.   System will NOT allow users to add same locations with leading spaces.  This field is flagged as “Read Only” for an MRB whse item. (Meaning you can not create new locations for MRB whse). Due to the fact that the MRB location is usually generated from a PO rejection – and if so, it needs to retain that link back to the original PO information and that is populated into the location field and is not editable.   If you move into MRB via Inventory Handling then no location information is populated, but you are still unable to edit it.
      Netable box 

      Remove the check mark from Netable only if the item entered is NOT to be considered as Supply when running Material Requirements Planning.  If the MRB whse is being added the Netable field is disabled and unchecked. 

      Validated box 

      This is for reference only and does not affect any other modules in Manex. This is simply for the users to check that the part being added has been verified as appropriate. 

      Depress the Save button at the bottom of the screen.

      The completed Quantity Info screen looks like this:

      Material Requirements Planning Information:  Depress the MRP tab and the following screen will appear. Enter the Material Requirements Planning information for the item.

      Order Policy: This field is used to select the method used by the Material Requirements Planning module to combine requirements for this item in creating Planned Purchase Orders (POs). For instance if the choice is (Lot for Lot), the Material Requirements Planning module will plan one PO for the total requirements on a daily basis. If the choice were (Weekly), the Material Requirements Planning module would combine all the requirements each week and plan one PO on the first requirement day for the entire weeks needs.

       

      Min Order Qty

      This is the smallest number of the item that can be ordered from the vendor in one PO. For instance, Surface Mount components on a reel usually have a minimum order of 1000 items or more. 

      Order Multiple  

      This field defines the even multiples of the Unit of Measure in which an item must be purchased. For example, 16AWG Wire might be only available in even hundreds of feet on a spool in which case the Material Requirements Planning module would plan a PO for the next higher even hundred above the requirement. 

      Purchase Lead Time: Purchase of all items other than In-Store items requires that the PO be placed a minimum number of days before the actual requirement. This Lead Time requirement is what tells the Material Requirements Planning module how many days before a requirement to plan a PO.  Changing the leadtime of a Buy part will NOT change the due date in MRP, only the date to take action. 

       

      Kitting Lead Time:  This field will be displayed only if it is a Make or Phantom part.  This Lead Time requirement is what tells the Material Requirements Planning module how many days to allow for kitting. Changing the kitting leadtime of a Make or Phantom part will change the due date in MRP.  A TRUE phantom does NOT require any lead times and should be left blank.  BUT . . . if for some reason you need to add a lead time for a TRUE phantom ManEx does have the capability.

      Production Lead Time:  This field will be displayed only if it is a Make or Phantom part.  This Lead Time requirement is what tells the Material Requirements Planning module how many days to allow for production. Changing the production leadtime of a Make or Phantom part will change the due date in MRP.  A TRUE phantom does NOT require any lead times and should be left blank.  BUT . . . if for some reason you need to add a lead time for a TRUE phantom ManEx does have the capability.

       

      Pull In Days

      When PO due date is more than this number of days too late for an Material Requirements Planning module requirement, a PO Due Date change Action Notice will be generated.   Note: These parameters may be thought of as filters for MRP Order Actions when the requirement dates for the parts changes.    See attached Document <<pullin-pushout discussion.docx>>.

      Push Out Days When PO due date is more than this number of days too early for an Material Requirements Planning module requirement, a PO Due Date change Action Notice will be generated.  Note: These parameters may be thought of as filters for MRP Order Actions when the requirement dates for the parts changes.    See attached Document <<pullin-pushout discussion.docx>>.
      Re-Order Qty

      This is the number of the item to order at time of order. 

      Re-Order Point

      To use a Min/Max system rather than Material Requirements Planning for reordering this item, enter the quantity at or below which the item should be replenished. Print the Inventory Material Reorder List report to show items which have dropped below re-order point minimums. 

      The completed MRP screen would appear as follows:

      Notes Tab

      Depress the Notes tab. Add Notes by clicking the Edit Action Button and typing in manually. Use Utility/ Copy or Ctrl+C and Utility/ Paste Ctrl+V to copy and paste from the existing Item Notes to new Item Notes. 

      Depress the Customer tab.  Depress the Edit button and the following screen will appear:

       

      Depress the Add button (under to the Customer Field) to select a Customer.  A customer list will appear.  Select the customer desired. For every Customer that requires an Approved Vendor List, selection of these items Manufacturer Part Numbers list (in the Quantity Info Screen), a Customer Part Number must be entered in the Customer Screen.  Enter a Customer Part Number and Save.  When you create a Customer Part number (Consigned) within the system, user has the option to Add Default Warehouse, Copy Warehouse Location from Internal Part, or Do not add any Warehouse Location upon creation.   Note:  System does not allow you to enter more than one part number per customer to the same internal part, (for more detail see Article #2389).

       

      Depress the Supplier tab, depress the Edit button and then the Add button (under the Supplier Field) to select a Supplier, enter a Supplier Part Number and Save.

       

       

      The completed Supplier screen would appear as follows:

      Manufacturer Part Specifications

      Depress the Mfgr Part Spec tab. Add the Marking and Package, Body and Pitch, if desired. Add Manufacturer Part Spec drawings, images or .pdf file by clicking on Load Document and linking to the desired image or pdf file. The completed screen will appear: 




      Once all information for new record has been entered, depress the
      Save button to save the record, or the Abandon record button to abandon record.
       
       
       
      1.5.1.4.4. Copy or Edit an Inventory Record

      Copy a Part Number

      To copy an existing part, Find the part you want to copy, using Find an Inventory Control Record. Highlight that part number and then depress the Item Master tab. Depress the Copy icon at the top of the screen. The following message will appear.

      The following message will appear. Depress the "Yes"  button. Enter your password. 

       

      The following selection menu will appear:

      Selecting Copy & Autonumber will create a copy, and open the  Item Master Screen.  The fields which may be edited are highlighted.

       

       

      Selecting Copy & Edit Number/Revision will bring up a reminder message:

      Depress the Ok button.

      The Item Master Screen will open.  All of the fields which can be edited, including the part number and the revision number, will be available for editing.

       

      Selecting Copy & Increment Revision, will cause the system to assign the same part number and the revision number will automatically increment by 1.  In the Item Master all the fields which may be edited are highlighted, as illustrated below:

      Edit an Inventory Item

      Find an Inventory Control Record   Note:  How to remove or inactive an Inventory record see Article #924 Status defintion.

      Depress the appropriate tab which needs to be modified. Depress the Edit button. Enter your Password. The items displayed in Black may be edited:

      ITEM MASTER TAB

      Item Master tab
      The following fields are all editable:  Part Class, Part Type, Description, Material Type, Serialize box, Status (for status defintions see Article #924), ABC code, Stock / BOM UOM, Purchase UOM, Package, Buyer,  Mgmt Lock, Configuration Charge, Run Scrap %, Setup Scrap Qty, Costs (see NOTE below), Inspection box, Certs Required box, First Article box, NC NR, box, MRC, PPM, Length, Depth, Width, & Weight.
       
      ManEx DOES NOT recommend users to change the Unit of Measure while there is qty on hand within the system.   For further detail see Article #3414.

      If the part souce on a product is originally setup as a MAKE the user WILL be allowed to edit the record and change the part souce to Make/Buy and/or Phantom/Make.  For further details see Article #3289 .

       After all these criterias are passed, if the part has quantity on hand, the user has to enter the serial numbers to match the quantity on hand.

      Note re Editing Standard Cost: You will need a Supervisors Password to change the Standard Cost. The best procedure is to use the Standard Cost Adjustment module.  The Standard Cost Adjustment module will update the Inventory records AND will create the appropriate accounting entry. If you edit the cost in this screen, a manual accounting entry will be required.

      Changing a non-serialized part to a serialized part

      BUY - If a user changes a non-serialized BUY part to a Serialize part the system will check. *If the part has allocated qty, (user has to un-allocate parts before the system will allow user to check the "Serialize" box). *If  the part has any OPEN kit (kit in process), (user has to de-kit or close kit before system will allow user to check the "Serialize" box).   *If the part has un-reconciled PO (user has to reconcile all receipts before system will allow user to check the "Serialize" box).

      MAKE - If a user changes a non-serialized MAKE part to a Serialize part and the part has quantity in FGI the following message will appear:
       
      NOTE:  User is NOT allowed to change a Make/BUY part from a non-serialized part to a serialized part if there is qty on hand.

      Depress the Yes button and the following screen will appear, which is the Serial number entry screen: The WH Qty is displayed in upper right hand corner.  This is the number of serial numbers that need to be assigned.  

      If user does not know the available work orders which have FGI quantity, they can double click the work order number field (displayed in Red), and a list with work order numbers and FGI qty for that part number will pop up and the user can select one for entering serial numbers.

      When user returns to the SN Entry screen they can leave the SN option at "Range".  The system will default in the full Qty on Hand amount for the Serial Numbers, but if the user manually edits the ending serial number before entering the system appears to work okay, then when the user adds the remaining serial number for the last work order the system will default the correct amount of remaining serial number to be assigned. 

       
      Changing a Lot Coded Part to a Non-Lot Coded Part or Vis-Versa  - ManEx does NOT recommend users changing parts from Lot Coded to Non Lot Coded or vis-versa unless it is absolutely necessary. 
       
      If a user is changing a Non Lot Coded part to a Lot Coded part they will receive the following message informing the user that "Dummy" lot codes will be setup for existing oh hand quantities and asking the user if they would like to continue. 
       
       
      If a user is changing a Lot Coded part to a Non Lot Coded part they will receive the following message informing them that any existing Lot Code information for this part will be deleted from the system if these changes are saved and asking the user if they would like to continue.
       
       
       
      If a user is changing a Lot Coded part to a Non Lot Coded part or vis-versa and the part is also serialized and if there is qty on hand, user will receive the following message and will be unable to save the change.  
       
       
       
       
       
       

      QUANTITY INFO TAB

      Material Type

      Select from the pull down, Unk, LF-P/N, LF-Date, LF-Mark, RoHS-P/N, RoHS-Date, RoHS-Mark. See Article 2267 for definitions. These choices have been defaulted in.  Customers may establish the logic by which the material type for the parts are established by the material types at the AVL level in System setup/Material Type Setup

      The AVL Material Type is carried forward for the consign part when the consign part is first added to the system or when new AVL was added to the internal part and the user elects to add this AVL to the existing consign parts.  If the user later changes the Material Type on the internal part, the change is NOT carried over to the consigned.
       
      If the inventory material type update is set to "Auto" (within the Material Type Setup), everytime the user modifies a part or AVL, the program will update the inventory material type automatically, if the control is set to "Manual" then user will be able to modify inventory material type on "Quantity Info" page via a Material Type pulldown, the program will not validate if the material type in inventory and AVL levels are in sync. 
      AVL Info

      User can edit the Pref Code, Safety Stock, AVL Material Type, Enter AVL Material Value info, check the Allow Auto Creating Location at Receiving (selected AVL) and/or Disallow this part from Purchasing and/or Kitting (if applicable).   Depress the ADD button to enter a new mfgr and mfgr PN.  Highlight an existing mfgr and mfgr PN in the box and depress the DELETE button to delete an existing mfgr and mfgr PN (if there is no qty on hand). Note:  When deleting an MPN - keep in mind that the MPN will be deleted from the screen but NOT from the tables. The MPN's that have been deleted are retained in the tables for history tracking purposes.   

      NOTE:  If the user changes the preference code or material type these changes are NOT carried forward to the existing consigned parts.

      System will not allow users to have duplicate AVL/MPN combinations.  If user has same mfgr and mfgr PN but different material types, we suggest that the user create a new AVL with a dash (or any other symbol) and use that designation to transfer to the UNK material type parts or create a different location for the same part, but have it be non-nettable, making it ineligible as a source for MRP.

      Warehouse Info User can edit a location to an existing Warehouse, check or uncheck the Netable and Validated boxes.  Depress the ADD button to add a new Warehouse.  Highlight an existing warehouse in the box depress the DELETE button to delete an existing warehouse (if there are no qty on hand).  Caution on deleting warehouses:  Please remember if you delete a warehouse for a given part number, that you are ALSO deleting some of the history for that part at that location.  If you think that such history will be required in the future, then DO NOT delete the warehouse. NOTE:  When removing/changing WH/Location system will prompt the user if any POs are open, which are using the modified location. This prompt will allow the user to abort or continue with the change. 
      If the user adds new AVL's to the Internal part number, they may click on this button and it will bring up the following screen.     

      Check the radial for the Warehouse to be added.Choose the mfg. from the pull down you want added to the consigned AVL. Highlight the Customer(s) Consigned Part number you want to update.  

      Depress on "Add Selected AVL to the Highlighted Parts"

      The following warning will appear.
       
       

      If "yes" is depressed you will receive the following screen: 

      If "No" is depressed the action will be deleted.
       
      Depress "OK" and the transaction is completed
        

       

      MRP INFO TAB

      MRP Info Tab    Order Policy, Min Order Qty, Order Multiple,  Purchase Lead Time, Pull In Days,Push Out Days, Re-Order Qty, Re-Order Point

      CUSTOMER TAB

       Customer Tab Add or Delete a Customer and Customer PN.  

      SUPPLIER TAB

      Supplier Tab  Add or Delete a Supplier and Supplier PN.

      MFGR PART SPEC

      Mfgr Part Spec Load/change picture or .pdf file. 

       Depress the Save Action button at the completion of each edit.

      1.5.1.4.5. Delete an Inventory Control Record
      Find an Inventory Record
       
       
      Depress the Delete button and the following message will appear for a BUY part:
       
       
      Depress the Delete button and the following message will appear for a MAKE part:   NOTE:  Any ECO's created against this part will NOT be available for selection. 
       
       
       
      The System will allow the users to delete an Inventory Part from the system if: 

      there is no Quantity on Hand
      it is not used on a BOM
      there is no shortages or allocations
      there is no open Purchase Orders and if the receipt has been reconciled and posted to the General Ledger 
       
      Note:  When deleting an MPN - keep in mind that the MPN will be deleted from the screen but NOT from the tables. The MPN's that have been deleted are retained in the tables for history tracking purposes.   




      If BUY or MAKE part has qty on hand the following message will appear and user will NOT be allowed to delete the inventory part:
      If BUY Part is associated with consigned part(s) the following message will appear and user will NOT be allowed to delete inventory part:
      If BUY part is used on a BOM the following message will appear and user will NOT be allowed to delete the ivnentory part:
      If BUY part has shortages or allocations the following message will appear an XL spreadsheet will be created with detailed information and user will NOT be allowed to delete the inventory part:
      If BUY part has open PO(s)  the following message will appear and user will NOT be allowed to delete the inventory part:
      If BUY part has NOT been reconciled the following message will appear and user will NOT be allowed to delete the inventory part:
      If BUY part has NOT been Posted to GL the following message will appear and user will NOT be allowed to delete the inventory part:
      If MAKE part has NOT been Posted to GL the following message will appear and user will NOT be allowed to delete the inventory part:
       
       
       
      If you do not want to loose the History, the other option you have is to change the Status of the Part from Active to Inactive rather than deleting the ICM part.  To see further detail on change the status of a part see Article #931 .
       
       
       
       
       
      1.5.1.4.6. Attach a Related Document

      Find an existing Inventory item Record, or Add a new Inventory item record.

      Depress the   button, and enter password.

      The following screen will appear:

      Depress the Add record icon, enter in a Document Number, REV, Doc Description, Doc Date, Doc Note; 

        

      To load a document double click in the PDF File field and the following screen will appear:

      Depress the Load Document button and the following screen will appear:  The PDF screen will allow you to load almost any type of document; (Word, Excel, pdf, Images, etc .... )  It will NOT let you load a document with symbols in the file name.  Example "Int ' l".  (Symbol in Red).  If you are receiving a system error when attempting to load a document check the file name to make sure there are no symbols within that file name. 

      Locate the document and double click on it and the document will populate screen.

      Depress the Save record icon to save or depress the Abandon changes icon to abandon changes.  The following screen will appear:

      Depress the Save record icon to save or depress the Abandon changes icon to abandon changes.  

      Once documents are saved the "Related Documentation" button will display in Red.  This Document will be available to view in the PO Module and PO Receiving Module also.

       

      1.5.1.5. Reports - ICM Mgmt
      1.5.1.5.1. Inventory Control Reports
      To obtain the Inventory 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. 




       
       

      Inventory Material Re-order List Report  - The Material Re-order Report lists all inventory on hand that has less quantities available than the minimum stocking level prescribed for that part.

      Select the Inventory Type, either Internal, In Store, Internal & In Store or Consign by clicking on the appropriate radio button. Depress the OK button.

      This report uses the "Re-order Point" to decide if the part need to be re-ordered, not the "Re-order Qty" . 
       
       

      The Following is printed:   This report displays all inventory on hand that has less quantities available than the minimum stocking level prescribed for that part.

      Inventory On Hand Report - This report lists material on hand in inventory locations, including WIP.  There are several ways to select the information so that the report is specific to chosen areas.  The report shows the amount of inventory in each location, including identification of the manufacturer and allocated inventory.

      To select class, highlight the Class and depress the > button.  If you want all classes, depress the >> button.

      To select warehouse, highlight the warehouse and depress the > button.  To select all warehouses, depress the >> button.

      Enter Part Number range, if desired.  If left blank it will check all records. 

      Select to sort by, either Part Number or Warehouse by clicking on the appropriate radio button.

      If you want to suppress records with a zero, check the box.

      Depress the OK button.

       

      The following is printed:  This report displays the amount of inventory on hand in each location, including WIP, and identification of the manufacturer, Lot Code information, and allocated inventory.  There are several ways to select the information so that the report is specific to chosen areas. 



      Transaction Detail Log
      Report
        - This Report lists all inventory movement transactions for the selected criteria for the report. 

      Highlighting the Transaction Detail Log report brings up a further selection:

      Highlight the desired selection, either All, Receipt, Issue or Trans/Exp.

      Depress the Options tab will bring up the following screen:

       

      To select class, highlight the Class and depress the > button.  If you want all classes, depress the >> button.

      To select warehouse, highlight the warehouse and depress the > button. To select all warehouses, depress the >> button.

      Enter Part Number range, if desired.  If left blank it will check all records. 
       
      To clear the part range, check the Clear Range Entries box.

      Enter the desired date range From and To.   To clear the date, check the Clear Selection box.

      If you want the reason to appear on the report, check the With Reason? box.
       
      If you want the Serial numbers to appear on the report, check the box.  (Note:  Leading Zero's will not be displayed on report).

      Select the Inventory Type, either Internal, Internal & In Store, In Store or Consign by clicking on the appropriate radio button.

      Depress the OK button.

       

      The following is printed: This report displays all inventory movement transactions for the selected criteria for the report.  Issued qty's are displayed as negative, and Received qty's are displayed as postive. 
       
       

      Note: The reference field as entered in the Inventory Handling module will display on the Transaction Detail report.

      Part Transaction Log With Balance Report - Lists all transactions for a specific part from date selected.

      Select the Inventory Type, either Internal, Internal & In Store, In Store or Consign by clicking on the appropriate radio button.

      Enter the Internal Part Number/Revision.

      Enter the From Date, (the To Date is todays), Part Number/Revision.

      If you want the reason to appear on the report, check the  With Reason? box.
       
      If you want the Serial numbers to appear on the report, check the box.  (Note:  Leading Zero's will not be displayed on report).

      Depress the OK button.

      Note:  The beginning balance is a calculation based on transactions. It is not associated with the GL, nor has any effect on it.    If the beginning balance is being displayed as anthing other than "0" it may be caused by the UOM being changed with qty on hand.  See Article #3414 for further detail.
       

      The following is printed: This report displays all transactions for a specific part from date selected.   Issued qty's are displayed as negative, and Received qty's are displayed as postive. 
       
      To read this report you need to start from the bottom and work your way up.
      We use the current qty OH, then get all the receiving, issue, transfer... records, and go backwards to create the transaction with balance report. For example, I have a new part like this: 

      Starts with a 0.00 balance:
      01/05/09      receiving  230
      01/08/09      issue        15
      01/15/09      receiving   75

      The Qty OH now is 290, the report gets all the receiving, issue, transfer records and sorts the data by date from latest to oldest to get the beginning balance.

      Qty OH:     290
      +75   balance:                215 (by -75 from the 290)
      -15   balance                  230 (by adding 15)
      +230 beginning balance:    0 (by -230 to get the balance)
       




      Inventory Valuation Report - This Report lists all inventory by part class and summerizes the inventory value of the parts selected.

      To select class, highlight the Class and depress the > button.  If you want all classes, depress the >> button.

      To select warehouse, highlight the warehouse and depress the > button.  To select all warehouses, depress the >> button.

      Enter Part Number range, if desired.  If left blank it will check all records. 

      To clear the part range, check the Clear Range Entries box.

      Select the type of Cost you want to appear on the report: Standard, Purchase or User Define by depressing the appropriate radio button.
       
      Select status of parts:  All or Active Only by depressing the appropriate radio button.
       
      Depress the OK button.
       
      NOTE:  The Last Paid information is calculated from the Last Change date not necessarily the PO Date that is displayed in the Purchase History box. If a user happens to edit an older PO (that does not match the Purchase Order History screen) and saves the changes the Last Paid will be updated based on the last change order recorded and the PO History screen will still remain as is.  (Example: If a PO was originally created in 2002 , but edited and saved today, it would then be included into the Last Paid record from the date it was modified). 
       

      The following is printed: This report displays all inventory by part class and summerizes the inventory value of the parts selected.
       
       

      Inventory and WIP Valuation Report 

      Check the box if you want to suppress 0 quantity on hand.

      Check the box if you want to round quantities to Integer.

      Select the part class by highlighting the one you wish and depressing the > button.  If you want all classes, depress the >> button.

      Enter Part Number range, if desired.  If left blank it will check all records. 

      To clear the part range, check the Clear Range Entries box.

      Select the type of Cost you want to appear on the report: Standard, Purchase or User Define by depressing the appropriate radio button.
       
      Select status of parts:  All or Active Only by depressing the appropriate radio button.

      Depress the OK button.
       

      The following is printed:

      See Article #1777  "How WIP Qty and WIP Value is Calculated".  
      See Article #913    "How Manex tracks and values the dollars in WIP".  
      See Article #3068  "Why the Accounting Values do not always match the Inventory reports".

      Inventory WIP Valuation Report by Work Order

      Check the box if you want to round quantities to Integer.

      Select the Part Class by highlighting the one you wish and depressing the > button.  If you want all classes, depress the >> button.

      Select the Work Order by highlighting the one you wish and depressing the > button.  If you want all classes, depress the >> button.

      Enter Part Number range, if desired.  If left blank it will check all records. 

      To clear the part range, check the Clear Range Entries box.

      Select the type of Cost you want to appear on the report: Standard, Purchase or User Define by depressing the appropriate radio button.


      Depress the OK button.
       

      The following is printed:  Every new WO will start on the new page.
       
       
      Inventory List With No Assigned BOM Report - All material on hand with no parent assembly associated with it. 
         

      This report displays all material on hand with no parent assembly associated with it.

      Select the Part Type to Display:  All, Internal, or Consigned Only by depressing the appropriate radio button.

       
      The following is Printed:  Note:  The first letter of the Status is displayed to the left of the "Part Number" column (A for Active and I for In-active).  
       
       

      Unused Inventory List Report - All inventory for which no transactions have occured since a selected date.

      Select Inventory Type: Internal, In-Store, Internal & In-Store, or consign by depressing the appropriate radio button .

      Select the part class by highlighting the one you wish and depressing the > button.  If you want all classes, depress the >> button.

      To select warehouse, highlight the warehouse and depress the > button. To select all warehouses, depress the >> button.

      Enter Part Number range, if desired.  If left blank it will check all records. 

      To clear the part range, check the Clear Range Entries box.

      Enter the desired date.

      To Clear selection, check the Clear Selection box.

      If you want to suppress records with a zero, check the box.

      Depress the OK button.   Note:  The search for the un-used parts will be based on the MFGR/ MPN level.

       

      The following is printed:  This report displays all inventory for which no transactions have occured since the selected date based on the MFGR/MPN level.   

       

      Part Cross Reference Report 

      Highlighting the Part Cross Reference report brings up a further selection:  

      Select the type of Cross Reference desired. 

      This will display the
      relation between Mfgr part number and Internal part number.

       

      Choose Sort By selection, either Manufacturer Part Number or Manufacturer by clicking on the radial.

      Depress the OK button.

       

      The following is printed:  This will display the relation between Mfgr part number and Internal part number.

      Part List by Manufacturer and Manufacturer Part Number Report - Lists by manufacturers, all part numbers by manufacturers part number, user type, class, description and part number, along with quantity in stores.

      Highlight the manufacturer of preference and depress the > button.  If you want all manufacturers depress the >> button.

       

      Depress the OK button.

       

      The following is printed:  This report displays all part numbers by manufacturers part number, user type, class, description and part number, along with quantity in stores.

       

      Physical Inventory Work Sheets Report - Work sheets to be used to take physical inventory.

      Select Inventory Type: Internal, In-Store, Internal & In-Store, or consign by depressing the appropriate radio button .

      Select the part type:  Make, Buy or Both by depressing the appropriate radio button.
       
      Select either With Book Quantity or Without Book Quantity by depressing the appropriate radio button.
       
      Select to sort by:  Warehouse/Location or Part Number by depressing the appropriate radio button.
       
      Enter Part Number range, if desired.  If left blank it will check all records.   
       
      To clear the part range, check the Clear Range Entries box.

      Depress the OK button. 

       

      The following is printed:  This is the Worksheets to be used to take physical inventory.
       
       
      List of Duplicate Descriptions - This report displays all part numbers with duplicate descriptions


      In Store Items Without Contract Report -   This report displays all part numbers from Invt mfgr Instore without contract 
       
       

      In Store Issued Items Without Contract Report - This report displays a list of items issued from in-stores without contract  
       

      Customer Reference Report - This report lists by customers, all customers part number along with quantity in stores
       

      Part Class and Type List - This report is a listing of Part Classes & Types
       

      Print Inventory Labels 

      The Print Inventory labels report requires that the Barcode Font be installed.

      Highlighting the Print Inventory Labels brings up a selection of printers to be used:
       
      Laser Printer (sheet):  Avery Label # 5163, 4" x 2", 2 accross, 5 down, printed portrait
      Portable Printer (roll):  Redline Solutions, Zebra QL DT Labels 4x3 PN 81475
      Portable Printer (roll):  Zebra Printer (roll):  Label size 2" x 3"  (for Zebra printers Part #10000286 (or equivalent) 
       

      Select Inventory Type: Internal, In-Store, Internal & In-Store, or consign by depressing the appropriate radio button .

      Enter number of Labels to Print (1-99).

      Enter Part Number range.  (This field is required).   
       
      To clear the part range, check the Clear Range Entries box.
       
      Enter the Warehouse and location, if desired. 
       
      Depress the OK button. 

       
       

      The following is printed.

       

      Allocated Report for Closed and Cancelled WO - This report displays a listing of Part Classes & Types
       

       

       

      Allocated Report by Part Number Report - This report displays a listing of Allocated Part Numbers
       

       

       

      Allocated Report by Work Order Report - This report displays a listing of Allocated Part Numbers by Work Order
       

       

      Material Type Change Report - Listing of the parts that have their material type changed since given date.

      Enter the From Date, (the To Date is todays).

      To clear date check the clear box.

      Depress the OK button.

       

      The following is printed: - Listing of the parts that have their material type changed since given date.
       

      Material Type Change Log Detail Report - Listing of the parts that have their old and current material types changed since given date.  

      Enter the From Date, (the To Date is todays).

      To clear date check the clear box.

      Enter in a Part Range, if desired.  If left blank it will check all records.
       
      To clear the part range, check the Clear Range Entries box.

      Depress the OK button.

       

      The following is printed:  This report displays the history of the Inventory Material Type Changes. 

      Inventory and AVL Material Type Validation - This report goes through the inventory part numbers to check and lists if the Inventory and AVL material types are not in sycn.  It does not update the inventory material types.

      Depress the OK button.  User will receive the following popup to warn them that the report could take a while to run.  So at this point you have the option of continuing or aborting the procedure.

      Depress Yes and the following report will appear:   This report compares inventory material type with AVL calculated material type and lists those part numbers which have different material types in inventory and AVL levels.

       

       

       

      1.5.1.6. FAQs - ICM Mgmt
      Facts and Questions for the Inventory Control Module
      1.5.1.7. ManEx Minutes (ICM)
      1.5.2. Inventory Handling
      1.5.2.1. Prerequisites for Inventory Handling

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

      Inventory Master Each part to be received, issued or transferred must be set up in  Inventory Control Mgmt .
      GL Defaults The Inventory Handling GL Defaults must be setup. 
      Reason Codes The Inventory Handling Reason Codes must be setup. 
      MRB Warehouse

      A MRB (Material Review Board) Warehouse must be setup in Warehouse Setup

      1.5.2.2. Introduction for Inventory Handling

      The Inventory Handling module is for receiving without a purchase order, issuing without a packing list, transferring inventory items from one warehouse location to another and to transfer discrepant materials into the MRB (Material Review Board) Warehouse.

       

      Receiving is particularly useful in setting up the initial inventory when first launching ManEx. 

       

      Issuing is useful to expense Inventory Items.

       

      This module can also be used to adjust the Inventory Master to the actual count after taking a physical inventory, if the user does NOT have the ManEx Physical Inventory module.

      If the user has in-store items, which they want to return to Vendor without any impact on accounting or PO (like obsolete parts), within the Issue page users will see a check box "Return In-store 2 Vendor".  This field will only be visible if the In-Store warehouse is selected, and if check-marked no purchase order will be created and there will also be no impact on the GL values.

      Buy Part Serialization Feature:  The users will be able to properly assign Serial numbers to Buy parts through the Receiving screen.  Within the other remaining Inventory Handling screens (Issue, Transfer, & MRB) Serial number selection boxes will appear.

      When receiving a part with no Warehouse or location setup within the Inventory Control AVL, and that specific part/warehouse has been marked as "Allow Auto Creation", users will be able to set warehouse and location directly from the Inventory Handling Receipt.
       
      These transactions are recorded and tracked in the "Transaction Detail Log Report" and "Part Transaction Log with Balance Report" located in the Inventory Control Mgmt module.

       

      1.5.2.3. Fields & Definitions for Inventory Handling
      1.5.2.3.1. Receiving Tab

      The main screen

      Receiving tab field definitions

      Part Source The source of the part, Buy, Make, Consigned or Phantom
      Part Number The internally assigned number of the part.
      (Rev) The revision number assigned to the part.
       

      Depressing this button will reveal any notes about the part that have been entered in the item master.

      Received Qty The quantity received. 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.
      UOM

      The Unit of Measure for the part.

      Receiving Account Description

      The description (and its related General Ledger account) pertaining to the receipt.

      Manufacturer The name of the manufacturer of the part.
      Manufacturer’s Part Number

      The number the Manufacturer has assigned to the part.

      Warehouse The name of the Warehouse.
      Location

      The location within the warehouse where the part received will be placed.

      This button will ONLY be displayed if the "Allow Auto Creating Location at Receiving" box is checked in the Mfgr/AVL  Quantity Info tab within the ICM module.
      Part Class

      The classification to which the part number belongs.

      Part Type The type within the classification to which the part number belongs.
      Description

      The description of the part number.

      Reason

      The reason for the receipt.

      Reference

      The reference for the receipt.

      1.5.2.3.2. Issue Tab



      Issue tab field definitions

       Part Source

      The source of the part, Buy, Make, Consigned or Phantom.

       Part Number

      The internally assigned number of the part.

       (Rev) The revision number assigned to the part.
       

      If this button is shown in RED, depressing this button will reveal any notes about the part that have been entered in the item master.

       Issued Qty

      The quantity issued. 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.

       UOM The Unit of Measure for the part.
       Issue Account Description

      The description (and its related General Ledger account) pertaining to the issue.

       Issued To The name of the project, etc.
       Manufacturer

      The name of the manufacturer of the part.

      Manufacturer’s Part Number The number the Manufacturer has assigned to the part.
       Warehouse

      The name of the Warehouse.

       Location The location within the warehouse where the part issued will be pulled from.
       Qty Available

      The on hand quantity.

       Part Number

      The internal number assigned to the part.

       Quantity

      The quantity issued.

       Part Class

      The classification to which the part number belongs.

       Part Type

      The type within the classification to which the part number belongs.

       Description

      The description of the part number.

       Reference

      The user defined reference for this issue.

       

      1.5.2.3.3. Transfer Tab

      Transfer tab field definitions

      Part Source

      The source of the part, Buy, Make, Consigned or Phantom.

      Part Number

      The internally assigned number of the part.

      (Rev) The revision number assigned to the part.

      If this button is displayed in RED depressing this button will reveal any notes about the part that have been entered in the item master.

      Part Class The classification to which the part number belongs.
      Part Type The type within the classification to which the part number belongs.
      Description The description of the part number.
      Manufacturer The name of the manufacturer of the part.
      Manufacturer’s Part Number

      The number the Manufacturer has assigned to the part.

      From Warehouse

      The name of the Warehouse.

      From Location The location within the warehouse where the part transferred will be pulled from.
       In-Store Supplier

      The name of the In-Store supplier.

       To Warehouse

      The name of the Warehouse.

       To Location The location within the warehouse where the part transferred will be placed.
       Qty Available

      The on hand quantity.

       Quantity to Transfer

      The quantity transferred.  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.

       UOM

      The Unit of Measure for the part.

       Reason

      The reason for the Transfer.

       Reference

      The reference for the Transfer.

       

       

      1.5.2.3.4. MRB Tab

      MRB (Material Review Board) tab field definitions

       Part Source

      The source of the part, Buy, Make, Consigned or Phantom.

       Part Number

      The internally assigned number of the part.

       (Rev)

      The revision number assigned to the part.

       Part Class

      The classification to which the part number belongs.

       Part Type

      The type within the classification to which the part number belongs.

       Description

      The description of the part number.

       Manufacturer

      The name of the manufacturer of the part.

      Manufacturer’s Part Number

      The number the Manufacturer has assigned to the part.

       Part Number The internal number assigned to the part.
       Quantity The quantity transferred.
       From Warehouse

      The name of the Warehouse.

       From Location

      The location within the warehouse where the part transferred will be pulled from.

       To Warehouse

      The name of the Warehouse.

       To Location

      The location within the warehouse where the part transferred will be placed.

       Qty Available The on hand quantity.
       Quantity to Transfer

      The quantity transferred. 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.

       UOM

      The Unit of Measure for the part.

       Reason The reason for the Transfer.
       Reference

      The reference pertaining to the Transfer.

       

      1.5.2.4. How To ..... for Inventory Handling
      1.5.2.4.1. Receiving Tab

      Depress Inventory Mgmt/Inventory Control Management/Inventory Handling 

       

      The main screen will appear

      Inventory Handling is used for receipt of non-purchase order receipts.

      To add inventory, depress the Receiving tab.

      1. Depress the Add button.
      2. Type in your password.
      3. Select the Part Source from the pull down menu (BUY, MAKE, CONSG, or PHANTOM).
      4. Type in the Part Number, if Part Source is "CONSG" you will need to enter Customer Name from pull down, then you will have a choice to enter in customer PN or Internal PN.
      5. Part type, class, and description will default in.
      6. Type in the Received quantity.
      7. Select the Receiving Account Description from the pull down menu.
      8. Select the Manufacturer & manufacturer part number from the pull down list.
      9. The warehouse will default in. If the default is not the warehouse you want you may choose from the pull down list.
      10. Select the reason for the receipt from the pull down list.
      11. Type in the Reference.
      12. Depress the Save button.

      This message is a general message user gets when the program can not find any warehouse/location for this part number. This message will appear if the part is locked in cycle count or physical inventory.  User must reconcile and post the physical inventory for this part and then you will be able to process the records within Inventory Handling.  
       

      The completed screen will look like this for a Buy, Make or Phantom part.



      The completed screen will look like this for a Consigned part.

      The completed screen will look like this for a Serialized part.  Note:  Users are allowed to receive in once issued out SN(s) back into stock, if  the SN is for the same part number, and was issued out through inventory handling, then the system will re-link it to its old history.  If the SN has been shipped out of the system via a packing list, the following message will be displayed



      and the user will be required to receive it back in through the RMA Process.   
       

      The completed screen will look like this for a Lot Coded part.


       
      If the "Allow Auto Creating Location at Receiving" box has been selected for a specific AVL in the ICM module the "New Location" button will appear on the Receiving screen as shown below.  
       
       
      Depress the New Location button and the following screen will appear, giving the user the option to create a new Warehouse/Location for this part: 
       
       
      Depress "Yes" and the following screen will appear, listing the Warehouse(s) that have the "Allow to Auto Create Location at Receiving" box selected in the Warehouse Setup module.  
       
       
      If user selects InStore a Supplier selection will appear in the screen:
       
       
      When all the information has been entered the New Warehouse/Location will appear in the Quantity Info screen with the ICM module.

      1.5.2.4.2. Issue Tab

      Issuing or Expensing Inventory Items with no Work Order

      The following types of items would be covered in the Issue screen:

      1.  Issuing to Cost of Goods Sold (Usually Non-taxable)

      Such as: Tems with no Bills of Material; Prototypes and Pilot Products for Resale; Items not classified as “Used in Kit”

      2. Expensing for In-House Consumption (Usually Taxable)

      Such as: Items consumed in the production process but not shipped as a part of product for resale; Items used for calibration or testing of the production process; Items used for samples or prototypes which are not resold.

      3.  Return In-store 2 Vendor

      If the user has in-store items, which they want to return to the Vendor without any impact on accounting or PO (like obsolete parts) there is a check box available within the issue page  "Return In-store 2 Vendor". (This field will only be visible if the In-store warehouse is selected).  If check-marked no purchase order will be created and there will also be no impact on the Gl values. 
      NOTE:   Any Return to Vendor will NOT be counted as inventory used in the EAU calculation.

      To access this screen, depress the Issue tab and the following screen will appear:


      To issue inventory items follow these steps.
      1. Depress the Add button.
      2. Type in your password.
      3. Select the Part Source from the pull down menu. (BUY, MAKE, CONSG, or PHANTOM).
      4. Type in the Part Number, if Part Source is "CONSG" you will need to enter Customer Name from pull down, then you will have a choice to enter in customer PN or Internal PN.
      5. Part type, class, and description will default in.
      6. Type in the Issued quantity.
      7. Select the Issue Account Description from the pull down menu.
      8. Type in Issued To.
      9. Select the Manufacturer & manufacturer part number from the pull down list.
      10. The warehouse will default in. If the default is not the warehouse you want you may choose from the pull down list.
      11. Type in the Reference.
      12. Depress the Save button.

      This message is a general message user gets when the program can not find any warehouse/location for this part number. This message will appear if the part is locked in cycle count or physical inventory.  User must reconcile and post the physical inventory for this part and then you will be able to process the records within Inventory Handling.  

       

      The completed screen will look like this.
       
       
       
       
      If issuing parts with Serial Numbers once user has entered the Part number info, etc. 
       
       
      Users have the option of selecting the Serial Numbers to be issued two different ways:
       
      1.  By highlighting and using the arrows         or
       
      2.  Depressing the Enter Serial Numbers button and the following screen will appear:
       
       
       
      Select the proper radial "Single Entry" or "Range" and enter in the From and To SN's:
       
       
      Depress the Save button and the SN's will transfer over into the Inventory Handling issue screen.  The number of Serial numbers selected will be displayed, as shown below:
       
       
      Depress the Save button to save changes, or the Abandon changes button the abandon changes.
       
      1.5.2.4.3. Transfer Tab
       
      Depress the Transfer tab and the following Transfer screen will appear:
       

      To transfer inventory from one warehouse to another follow these steps.

      1. Depress the Add button.
      2. Type in your password.
      3. Select the Part Source from the pull down menu. (BUY, MAKE, CONSG, or PHANTOM).
      4. Type in the Part Number, if Part Source is "CONSG" you will need to enter Customer Name from pull down, then you will have a choice to enter in customer PN or Internal PN.
      5. Part type, class, and description will default in.
      6. Select the Manufacturer & manufacturer part number from the pull down list.
      7. Select the ‘From’warehouse from the pull down list.
      8. Then select the ‘To’ warehouse from the pull down list.
      9. Type in quantity to transfer.
      10. Select the reason from the pull down list.
      11. Type in the reference.
      12. Depress the Save button. 

       

      Note For this feature to work properly, the Inventory Part Number must have two warehouse locations assigned to it in the Inventory master.  The From Location must have an inventory balance.   If user attempts to transfer parts that do not have two warehouse locations, or from regular inventory location to MRB  (Note:  System will NOT allow users to transfer parts out of MRB location to regular inventory if parts were transfered into the MRB warehouse through PO Receiving).  You will receive the following message.  This screen is used to move parts from a regular warehouse to another regular warehouse.  Or to move parts that are already located in MRB back into regular stock.  To move parts from stock to MRB you will need to use the Inventory Handling MRB screen

       

      This message is a general message user gets when the program can not find any warehouse/location for this part number. This message will appear if the part is locked in cycle count or physical inventory.  User must reconcile and post the physical inventory for this part and then you will be able to process the records within Inventory Handling.  

       

      The completed screen will look like this.


       
      If transfering qty from an In-Store warehouse to an Internal warehouse an accounting transaction will be created in Inventory Transfer upon saving the transfer.  Then user will then need to create the In-Store PO within the PO module. 

       

      1.5.2.4.4. MRB Tab
      MRB (Material Review Board) Warehouse Overview

      The MRB (Material Review Board) Warehouse is where the board members determine whether to return discrepant material to the Supplier.

      Depress the MRB tab.  The following screen will appear.

      To Transfer Inventory Items from Inventory to MRB follow these steps.

      1. Depress the Add button.
      2. Type in your password.
      3. Select the Part Source from the pull down menu. (BUY, MAKE, CONSG, or PHANTOM).
      4. Type in the Part Number, if Part Source is "CONSG" you will need to enter Customer Name from pull down, then you will have a choice to enter in customer PN or Internal PN.
      5. Part type, class, and description will default in.
      6. Select the manufacturer & manufacturer part number from the pull down list.
      7. Select the From Warehouse from the pull down list:
      8. The To Warehouse automatically defaults to MRB (Material Review Board).
      9. Type in the Quantity to Transfer.
      10. Select the Reason for transfer from the pull down list:
      11. Type in the Reference.
      12. Depress the Save button.

       

      This message is a general message user gets when the program can not find any warehouse/location for this part number. This message will appear if the part is locked in cycle count or physical inventory.  User must reconcile and post the physical inventory for this part and then you will be able to process the records within Inventory Handling.  

       

      The completed screen will appear as follows:



      Once the preceding steps have been completed, the user may Add to PO DMR (Discrepant Material Return) module, 
      or you may transfer it back into Inventory using the Transfer tab .

      Once the DMR (discrepant material return) has been added and saved, a Debit Memo will be created in the Accounting System.  Additionally, the corresponding entry will be created and the balance in the Accounts Payable Aging will adjust.   

       

      1.5.2.5. Reports - Inventory Handling

      To obtain the Inventory Handling module transactions, enter the Inventory Control Management Module.

       

       

      The main screen will appear. 




      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 Transaction Detail Log report or the Part Transaction Log With Balance report   

       
       

      The following option screen will appear at the bottom of the screen, Select the type of Detail Report desired by highlighting it:  All, Receipt, Issue, or Trans/Exp.


      Depress the Options tab.  
       
       
      The following option screen will appear:

      Highlight the Part Class you desire and depress the > button.  If you want All, depress the >> button.

      Highlight the Warehouse you want and depress the > button.  If you want All, depress the >> button.

      If you want a specific part number or range of part numbers, enter the first number and the last number in the Part Number Range fields.
       
      Depress the Clear Range Entries to clear the Part Number Range fields.

      Enter the date selection From and To.  To clear selection check the Clear Selection box.
       
      Check the With Reason box if you want the reason displayed on the report.

      Check the Show Serial Number box if you want the serial numbers displayed onthe report.

      Select the Inventory Type by depressing the appropriate radio button: Internal, Internal & In Store, In Store or Consign.

      Depress the OK button.

       

      The one of the following reports will print depending on the report selected:   Notice that the Issued qty's will be displayed as a negative and the Received qty's will be displayed as a postive. 
       
       
       
      1.5.2.6. FAQs - Inventory Handling
      Facts and Definitions for the Inventory Handling Module
      1.5.3. IPS Upload
      1.5.3.1. Prerequisites for the IPS Upload
      1. User must have the In-Store optional module.
      2. After activation, "IPS Upload" access for each user must be setup in the ManEx System Security module.  Users with “Supervisor Rights” will automatically have access. 
      3. User has to complete the required fields in the IPSimport.xlt located in the xlfiles directory to import to a In-Store PO.   
      4. The part must exist in the Inventory Control Mgmt module and must have the Supplier and In-Store warehouse setup within the Inventory Control Mgmt module.  
      1.5.3.2. Introduction for the IPS Upload
      This upload is designed to add quantities to the existing part number and MPN into the in-Store location.  If the MPN has "auto location" checked the upload will allow the user to auto add a location that does not exist.  The quantity will update if the contract does not exist and will be created for the price entered in the "price" column.  If the price is omitted the system will use the material price for the part as entered in the inventory module and Inventory receiving transactions will be populated, but there will be no affect on accounting upon receipt/import.

       
       
      1.5.3.3. Fields & Defintions for the IPS Upload
      1.5.3.3.1. In-Store XL Spreadsheet
       
       
      SupName
      (Required) Existing In-Store Supplier Name for In-Store Warehouse
      Contr_no
      (Required) Contract Number (If contract already exists the contract number entered must match existing)  
      qty_oh
      (Required) Quantity On-Hand
      part_no
      (Required) Existing Internal Part Number with exsiting In-Store Warehouse Setup
      revision
      (Required) Existing Revision (if applicable)
      partmfgr
      (Required) Existing Part Manufacturer with existing In-Store Warehouse Setup
      mfgr_pt_no
      (Required) Existing Manufacturer Part Number with existing In-Store Warehouse Setup
      Warehouse
      (Required) Existing In-Store Warehouse
      location
      (Required) Existing In-Store Warehouse Location
      price
      (Option) Contract Price (If price is omitted it will use material price for the part as entered in the inventory module).
      LotCode
      (Required if Lot Coded Part)  Lot Code
      ExpDate
      (Required if Lot Code Part) Expiration Date
      Reference
      (Required if Lot Coded Part) Reference
      SerialNoM
      (Required if Part is Serialized)  If the part is serialized the users can enter all serial numbers into the “SerialNoM” column of the spreadsheet separated by one of the following; coma, semicolon, space, tab.  If the user wants to enter range of the serial numbers they have to separate starting and beginning of the range with the dash surrounded by spaces like “ – “. The reason for that is that serial number itself might have “-“ as a part of the serial numbers. For example serial numbers entered as
      “C123 - C125” will translate as C123, C124, C125    

      but serial number entered as “C123-C125” will translate as “C123-C125” (notice no space surrounded the “-“). The following example will show other combinations that could be treated as ranges in the upload;

      Z1000002 - Z100005 (Z1000002, Z1000003. Z1000004, Z1000005)
      FU12 – 15  (FU12, FU13, FU14, FU15)
      98 – 103 (98, 99, 100, 101, 102, 103)
      z150-0009 - z150-0013 (z150-0009, z150-0010, z15-0011, z15-0012, z15-0013)

      Here is an example of the entered serial numbers that will not translate into the range;

      H890129292 K87827327 (H890129292, K87827327)
      V5678888X - V32787382S (V5678888X, V32787382S)
      540 - c670 (540, c670)

       
       
       
      1.5.3.4. How To ..... for the IPS Upload
      1.5.3.4.1. Add - Upload to IPS
      Enter Inventory Mgt/Inventory Control Management/IPS Upload
      User will get a prompt to find the file which they want to upload and then the system will import the data and proceed with validation and saving.
       

      Locate XL File to Upload

       
      The following Warning will appear This message is for user to verify the number of records being loaded from the import sheet.  User may depress "YES" to continue the upload or "NO" to abort the upload.

       
        
      If you depress No to Abort Upload the user will be prompted the following message that the Inventory Upload was not complete
      If you depress Yes to Continue the user will be prompted the following message that the Inventory Upload complete.
       
       

      If the system finds any problems with template the user will be prompted the following message and exception XL file will be created in the Inv Exception XL Sub Directory on the server.

      Depress OK and user will receive the message (shown above) that the "Inventory Upload was not complete" and system will abort.
       

      During the upload if user has a contract already setup the following message will appear.  If user selects "Yes"  Upload will continue, if user selects "No" Upload will abort.  

      During the upload if the pricing on the xl spreadsheet is different than the existing contract prices the following message will appear, giving you the option to overwrite the existing price.  If price is omitted from xl spreadsheet system will use the material price from the Inventory Control screen.  If user has contract pricing already setup for example: Up to qty of  5 = $1.00, Up to qty of  100 = $0.94, Up to qty of 101 = $0.95. When the in-store PO is created it will find the correct price break.   Also if there are multiple records for the same part, which will end up on the same PO, (like multiple serial numbers or lot codes), the qty will be combined in determining the correct price break.
      During the upload if the contract number listed on the xl spreadsheet is different than the existing contract number, user will receive the following message and system will abort. 
       
      Once the upload is complete the "Transaction Detail Log" report is updated for In-Store location, as displayed below:
       
       
      Since these items are being received into a In-Store location there will be no affect on accounting upon receipt/import.
       
       
       
       
       
       
       
       
       
       
       
      1.5.4. Lookup Manufacturer Part Number from XL List
      1.5.4.1. Prerequisites for Lookup Mfgr PN from XL List

      Excel file must Exist

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

      1.5.4.2. Introduction for Lookup Mfgr PN from XL List

      Use this function to find existing Manufacturer part numbers in the Invntory Control module.

      1.5.4.3. Fields & Definitions for Lookup Mfgr PN from XL List

      Fields & Definitions

        Depress this button to find the Excel spreadsheet you created listing the Mfgr Part Numbers and Mfgr you are searching for 
      Manufacturer Part Number Mfgr Part Number listed on the Excel spreadsheet
      Manufacturer Mfgr listed on the Excel spreadsheet
      Internal Part Number Internal Part Number attached to the Mfgr part number or Mfgr found in system
      Revision Revision (if applicable) attached to Internal Part Number
      Description Description of part attached to the Internal Part Number

       

       

      1.5.4.4. How To ...... for Lookup Mfgr PN from XL List
      1.5.4.4.1. Create Excel File for Lookup

      Excel file must have single column of MPN, and data must be in a range named MFGRLIST

       

       

      1.5.4.4.2. How to Lookup Mfgr Part Number from XL List

      Enter Inventory Mgt/Inventory Control Management/Lookup Manufacturer Part Number from XL List Module

       

       

      The following screen will appear:

       

       

      Depress the "Browse for Excel File" to locate the file name created

       

       

      Double Click on the File name and the following results appear.  Two XL files are created, one XL file lists the Mfgr Part Numbers found in system, (which is the ones that appear on screen)and the other XL file lists the Mfgr Part Numbers not found.

       

       

       

       

       

       

       

      1.5.5. Inventory Cycle Count
      1.5.5.1. Prerequisites for Inventory Cycle Count
      Prerequisites Required for Using CYCLE COUNT:

      After activation, "Inventory Cycle Count" access for each user must be setup in the ManEx
      System Security module.  Users with “Supervisor Rights” will automatically have access.
        

      Part Number Part numbers must exist in the Item Master .
      ABC Codes

      The ABC codes must be assigned to each part (within the Item Master) to be counted. 

      Optional Prerequisites for Modifying ABC Codes:

      ABC Setup

      The ABC codes must be established for percentages of value in the ABC Types setup module.

      Inventory Issues

      There must be a history of inventory issues to establish Estimated Annual Usages.

       

      1.5.5.2. Introduction for Inventory Cycle Count
      The CYCLE COUNT Module is provided for the user to establish a daily routine for counting INTERNAL inventory.   Note:  Only user owned inventory will be considered – NOT “consigned” (Customer owned), and/or WO-WIP or WIP locations.  If the user needs to count “consigned”, or a smaller range of internal parts outside the ABC Code setup, ManEx suggests to use the Physical Inventory module.   Records that have been allocated will display in red within the Inventory Cycle count module.  If the users attempt to edit the record that is allocated lower than the allocated qty it will display a message.  In-Store inventory will be considered unless the "Ignore In'Store" box is checked within the ABC Types Setup module, if this box is checked then In-Store warehouses will NOT be considered in the Cycle Count.

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

      The three steps to completing Cycle counting activities in ManEx are:
       
      1)   Create a New List - User generate a list of inventory items to count by clicking the "Run Cycle Count Setup" button (Add button). 
      2)   Count and Record Results -  Then the stores keepers physically count the items listed and enter the quantity counted for each item into the cycle count screen.
      3)   Reconcile Differences - At the conclusion of the data entry, the data is reconciled with the inventory records. If the count is different than the record, then the user is prompted whether to accept the difference or to recount and re-enter. Count adjustments are logged to the GL adjustment account, if accounting is used.

       

      A report is available summarizing and itemizing the results of the cycle count activities. If the user has established cycle count tolerances in the  ABC Types setup, then a report will delineate the number of times that the cycle count exceeded the permissible tolerance.

       

      The frequency of counting for each part is defined in the ABC Type  setup, and based on the ABC Type assigned to each part.

       

      There is provision to automatically assign ABC Types after the user has been operating the ManEx system for some time. The user has the option to base the assigned ABC Type on either the current dollar value of the inventory, or the Estimated Annual Usage dollar amount of inventory.  If the user chooses to reassign ABC Types automatically, the ABC Type setup must have established the amount (by percentage) of inventory value to be attributed to each ABC Type.

       

      There is also a provision for establishing the EAU (estimated annual usage) for each inventory item. The EAU  is based on inventory issues in the last 30 days, weighted by another factor to account for historical issues. In order to create the EAU, there must have a minimum of 30 days activity in issues from stores.
       
       
      Cycle Counting is the practice of counting a small subset of inventory on a given day.  It can be an effective and efficient method for maintaining current on-hand inventory counts.  It allows for greater flexibility, greater accuracy, and less interruption to production than an annual physical inventory
       

      The first step in establishing a cycle counting program, is to determine component groups and group count frequency.  Groups are typically designated by their ABC code with A parts counted more often than B parts and B parts counted more often than C parts, and so forth.  Some common parameters, in this industry, for determining the correct ABC code are: Value, Lead Time, Usage, EAU Value, and Hybrid.

      Value
       
      -
      This method groups components according to their on-hand value.  The components with the highest on-hand value are counted more frequently than those with a smaller on-hand value.  This method is ideal from an accounting perspective as it typically results in a much smaller variance in inventory value, but may not be ideal from a supply chain management perspective since even inexpensive components can cause expensive production delays and missed shipments.  This is relatively easy to calculate and can be assigned manually if needed.
       
      Lead Time -  This method groups components according to their lead time.  Components with long lead times will receive more frequent counts and thus have higher inventory accuracy.  While this makes sense from a supply chain management perspective, it can lead to high inventory value variances since expensive components don't always have long lead times.  This is relatively easy to calculate and can be assigned manually if needed.

      Usage
      - This method groups components by their annual usage (EAU) regardless of their value or lead time.  The argument for this method is that the more frequently accessed components have a greater likelihood for inventory variances and should therefore be counted more often.  This method tries to reduce the impact of human error in inventory transactions.  However, it may not minimize variance in inventory value, or prevent long lead parts from stopping production if those parts are not used as often.  This may be a little more difficult to calculate manually, but can be done if needed.

      EAU Value
      - This method groups components by the value of the annual usage (EAU).  This method attempts to rectify the inventory value variance issue with the Usage method, by including component costs.  It is likely to have a lower inventory value variance, but may not fully adjust for inexpensive or low usage parts with long lead times.  This may be a little more difficult to calculate manually, but can be done if needed.

      Hybrid
      - This method combines any or all of the methods listed above.  This method assigns components with high on-hand value, high usage, and/or long lead times to group A.  This ensures that parts with the greatest potential for causing production delays or inventory value variances are counted most often.  While this can be done manually, it is better to allow the ERP system to assign and adjust the ABC code according to current conditions.

      The second step is to determine how often each ABC code should be counted.  Higher count frequencies lead to more accurate inventory records, but also increased handling costs.  Management needs to find a balance between cost and benefit.  One common frequency is to count A parts every 30 days, B parts every 120 days, and C parts every 180 days.


      The third step is to determine the best time of day for cycle counting activities.  Ideally this will occur either before production begins, or at a time when production and inventory movement will be at the lowest level of the day.  This can be early in the morning before production starts or during the standard lunch break.

      The fourth step is to determine who should be responsible for performing cycle counting activities.  Because cycle counting reduces the daily time required, the focus can shift from speed to accuracy and process improvement.  A shift that requires knowledgeable and experienced employees to conduct the cycle counting activities.  This is typically limited to employees in inventory.

      The final step is to start counting and discovering the sources of each significant discrepancy.  As part of the counting process, it is imperative to identify why discrepancies exist and work to eliminate the sources.  Initially, it is far more important to identify and eliminate sources of discrepancy than to get through the full cycle each period.  Not only will eliminating sources of count discrepancies reduce costs and production delays, but it will speed the cycle counting process as well.

      A well designed and executed cycle counting program should achieve an accuracy of 97% or more.
      1.5.5.3. Fields & Definitions for Inventory Cycle Count
      1.5.5.3.1. Main Screen

      Main Screen field definitions

      Warehouse 

      The name of the warehouse for the part highlighted.If the warehouse button is depressed, the grid will sort by warehouse.

      Source

      The source of the part number, Make or Buy. If the source button is depressed, the grid will sort by source.

      Class The classification of the part.If the Class button is depressed, the grid will sort by class.
      Type

      The type within the classification of the part number.

      Description

      The description of the part number.

      UoM

      The unit of measure of the part number.

      This will allow user to select only the un-reconciled parts or all parts.   Selecting "All" will display parts that are un-reconciled and reconciled but not yet posted.  
      Location

      The warehouse location for the part to be counted.

      Part Mfgr

      The Manufacturer for the part to be counted.

      MPN (Manufacturer’s Part Number) 

      If the source is a buy, the number that the manufacturer has assigned to the part.

      Part Number

      The Internal Part Number for the item to be counted.Depressing the Part Number button will sort the grid by part number.

      Rev

      The Part Number Revision for the item. An item may exist under multiple revisions.

      Count The physical count quantity of the item observed during cycle counting
      Init

      The initials of the individual who performed the cycle count.

      Date

      The date that the inventory was counted. The date will default to the current date, but may be over-written.

      Allocated

      If an inventory part number has allocated inventory, the line will show in red and the Allocated box will have a check mark.This field is a reference field which indicates to the user that there is allocated inventory against this item and the system will not allow you to adjust the qty below the allocated amount.

      Lot Code

      If the part type has been designated as requiring lot tracking, then the lot tracking reference number appears.

      Reference Lot Code tracking reference number.  
      Exp Date  Expiration date of Lot Code 
      PO # Customer PO number
      Serial Number  If the part has been designated as requiring serial numbers, then the serial numbers appear in this screen.

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

       

      1.5.5.3.2. ABC Types

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

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

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

      In ManEx, the ABC codes have a slightly different meaning. In addition to identifying the most or least expensive part numbers, a Dock to Stock period may be included in each ABC code. Dock to Stock is the number of days a part is expected to take to be delivered to the stock room after the part is received on the user’s dock. This duration may include the amount of time it takes to organize the shipment, count the parts, log the receipt into the inventory system, perform incoming inspection, and physically move the parts to stores. Intuitively, the higher dollar parts may have longer dock to stock times because of increased inspection. And the lesser valued parts may not require inspection.

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

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

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

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

       

      1.5.5.4. How To ..... for Inventory Cycle Count
      1.5.5.4.1. Generate Cycle Count List
      The following screen will appear:   When the screen first opens, the user is limited to only five of the seven action buttons shown: Add button (Run a cycle count setup), Edit button (Enter cycle count results), Copy button (Reconcile cycle count data), Print reports, and Exit.  This is the first screen to be used in the module. In this screen, a CYCLE COUNT is created (ADD) for viewing, printing and editing.
       
       
      Depress the "Run Cycle Count" button (Add button)
       
       
       
      Records for cycle count will be pulled forward.    Note:  The user may not ADD a cycle count on a non-working calendar day. However, open cycle count records may be counted, entered and reconciled.  Records that have allocations made within the system will be pulled forward for count, these records will be highlighted in RED.   Parts in WO-WIP and/or WIP locations will NOT be pulled forward for count.
       
      User may select to Display only the "Unreconciled" parts or "All" parts. Selecting "All" will display parts that are un-reconciled and reconciled but not yet posted.  
       

      Note:  The cycle count module will allow multi-user access to enter and/or reconcile.  The users must exit and re-enter to screen to refresh if an action was done on another work station.  Only one user may Post.

       

      1.5.5.4.2. Entering Cycle Count Data

      Enter Inventory Mgt/Inventory Control Management/Inventory Cycle Count Module

       

      The following screen will appear displaying the records pulled forward for cycle count. Note:  The user may not ADD a cycle count on a non-working calendar day. However, open cycle count records may be counted, entered and reconciled.  Records that have allocations made within the system will be pulled forward for count, these records will be highlighted in RED. Parts in WO-WIP and/or WIP locations will NOT be pulled forward for count.

       
       
      Depress the Edit Record action button (Enter Cycle Count Results).  User will be prompt for password. 
       
       
       
      The user then enters the recorded counts in the COUNT column.  The counter’s initials and the date counted will update automatically. If the users attempt to edit the record that is allocated lower than the allocated qty it will display a message.  If you need to apply the count into the system you must first unallocate some of the inventory via the Inventory Allocation module to free up the amount you are attempting to adjust then return to the count and it will then allow you to post to inventory.

      Depress the Save changes action button to save changes, or depress the Abandon changes button to abandon changes. 

      Note:  The cycle count module will allow multi-user access to enter and/or reconcile.  The users must exit and re-enter to screen to refresh if an action was done on another work station.  Only one user may Post.

       

      1.5.5.4.3. Reconciling Cycle Counts and Post Inventory Adjustments

      Enter Inventory Mgt/Inventory Control Management/Inventory Cycle Count Module   

      The following screen will appear:

      Depressing the Copy action button (Reconcile Count Records) 



      Enter password.

      Then system checks the counted quantities entered into the Cycle Count screen and verifies that the count matches the inventory records.  If the count matches the inventory record the item drops from the list.

      If it does not match the inventory record, the following screen appears and the user is asked whether to accept the entered count as the new count, by depressing the "YES" button and entering a reason for the change (cycle count, missing parts, etc) or to wait until the user has had the opportunity to recheck the number and reconcile it at a later time by depress the "Next Item" button..

      Items not reconciled will remain on the list until reconciled.

      Note: 
      The user should not post the Inventory Adjustments until all of the reconciliation is completed.
       
      To record the adjustments in the count into the Inventory Master and to create the applicable accounting entry, depress the "Post Inventory Adjustments" button. You will be prompted for your password.   The "Allow Updating Inventory" option button (for Physical Inventory) within the Security module MUST be checked in order to Post Inventory Adjustments.  If user does NOT have these special rights they will receive the following message.






      Note
      , if the inventory item has changed in quantity (due to kitting or an issue via Inventory Handling between the beginning of the cycle count and the reconciliation), the system will alert the user and will print out a report detailing the part number and the discrepancy.  The user must change the data entry for the count, and then re-reconcile.

      Once the system has made the transfer, the following message will appear:

      Depress the OK button and all Inventory Adjustments are completed.

      1.5.5.5. Reports - Inventory Cycle Count

      Enter Inventory Mgt/Inventory Control Management/Inventory Cycle Count Module   

      The following screen will appear:

      To obtain the Inventory Cycle Count 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. 

      Cycle Count Worksheet Report

       

      Select between printing the Manufacturer and Manufacturer’s Part Number or Description by clicking on the applicable radial.

      Depress the OK button.

       
       

      The following report is available:

      The items are counted and recorded on the sheet, and then data is entered into the xERP System.

      Cycle Count Summary Report

      Select the date range of interest and the warehouse and part classes to be included.

      Highlight the Warehouse of interest and depress the > button.If you want all warehouses, depress the >> button.

      Highlight the Part Class of interest and depress the > button.If you want all of the classes, depress the >> button.

      Depress the OK button

       

      The following report will be displayed.

      Cycle Count Detail Report - Sorted by Division

      Select the date range of interest and the warehouse and part classes to be included.

      Highlight the Warehouse of interest and depress the > button.If you want all warehouses, depress the >> button.

      Highlight the Part Class of interest and depress the > button.If you want all of the classes, depress the >> button.

      Depress the OK button

       

      The following report will be displayed.

      Cycle Count Detail Report - Sorted by Class

      Select the date range of interest and the warehouse and part classes to be included.

      Highlight the Warehouse of interest and depress the > button.If you want all warehouses, depress the >> button.

      Highlight the Part Class of interest and depress the > button.If you want all of the classes, depress the >> button.

      Depress the OK button.

       

      The following report will be displayed.

      1.5.5.6. FAQ - Inventory Cycle Count
      1.5.5.6.1. How can I clear out a Cycle Count that was started in error?

      For Example, a user has begun the Cycle Count process by pulling items fwd into the module for counting by accident, but for what ever reason, you do not wish to continue on with the reconciliation process of the count.  But now those parts are locked in a count and will not be editable throughout the system (Kitting, PO Receiving, Inventory Handling, etc. . . )  If the part is locked in a count you will see messages similar to the below throughout the system.

      If you wish to Purge the Cycle Count out of the system you can run the below procedure and any record that has not had a count entered into the Cycle Count module will be cleared.


      SQL Manex Only

      Within SQL Manager run the following:

      exec sp_ClearAllCC



      VFP Instructions Only

      Please be sure to follow the procedure below to install this program.  It is highly recommended that you follow this procedure on your TEST system first before applying it against your Live ManEx System.

      1.)                 Create a Backup of your Live ManEx System

      2.)                 Extract << purgecc9.exe>> into the ManEx Root Directory

      3.)                 Run the Executable

      4.)                 Verify the Results

      5.)                 Remove << purgecc9.exe>> from the ManEx Root Directory

      Once satisfied with the results in your test system, you may proceed with your Live ManEx System.  Please let me know if you have any questions.

       

      1.5.5.6.2. Why are some ABC type parts no longer being included in the Cycle Count?
      QWhy are some ABC type parts no longer being included in the Cycle Count?
       
      A.   Check your calendar date to be sure it is extended out far enough for the program to find the date in the calendar.
       
      For ExampleIf the System Admin Calendar setup ends 12/31/2008, and the Cycle count day for "B" type is 180 days, and the cycle count is ran on 10/25/2008 the date would be 1/25/2009, the program will not find 1/25/2009 in calendar, so the "B" type parts are not included in the cycle count.  Once the System Admin Calendar is reset to end 12/31/2009 and the Cycle Count is re-ran then the "B" items are included in the Cycle Count. 

       
       
      1.5.6. Physical Inventory

      1.5.6.1. Prerequisties for Physical Inventory
      Before entering transactions, the following must be setup in Manex.

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

       

      Warehouse Setup Each warehouse must be setup in Warehouse Setup .
      Inventory Part Classes  Each Part Class must be set up in Inventory Part Class setup.
      Inventory Handling  Inventory Handling G/L Defaults must be setup in the Inventory Handling GL Defaults setup and Reason Codes must be set up in the Inventory Handling Reason Codes  setup. 
      Inventory Defaults  The accounting defaults for Inventory must be set up in Accounting Setup .
      Inventory Master Each part to be counted must be set up in the Inventory Control Management module. 
      Inventory Setup     The Inventory Adjustment Account default must be setup in Accounting Setup .

       

                        

      1.5.6.2. Introduction for Physical Inventory

       

      The Physical Inventory module is to manage the physical inventory count.  The user has the choice of using count tags or a count worksheet. The inventory is physically counted and then input into the system. More than one user may input into the system at a time.  Note:  The users must exit and re-enter the screen to refresh if an action was done on another work station.  Only one user may post.   IMPORTANT NOTE:  DO NOT MOVE ANY MATERIAL WHILE THE COUNT IS TAKING PLACE.  Once the count is input into the system, the system provides for a reconciliation between the Inventory Master and the physical count.  If the count is different than the record, the user is prompted whether to accept the difference or to recount and re-enter. If the count equals the Inventory Master, there is no adjustment required and the number counted will drop off of the reconciliation list.  Once the reconciliation is completed, the user may print out a reconciliation report.  Then, after reviewing, the user may update the quantity on hand in the Inventory Master.  Note:  This takes a high level password or special rights as assigned in Security.  Once this is done, the accounting journal entries will update automatically, if the MANEX accounting module is used.

      1.5.6.3. Fields & Definitions for Physical Inventory
      1.5.6.3.1. The Setup Tab

      Setup tab field definitions

      Inventory Type

      The type of Inventory, either Internal, Consigned or Instores.

      Customer

      If the Inventory Type is Consigned, the Customer name will display in this field.

       
      Supplier

      If the Inventory Type is Instore, the Supplier name will display in this field 

       

      Date/Time Started

      The date and time (24 hour clock) when the Inventory was originally started. 

      Status

      The status of the physical inventory, either In Process, Completed or Cancelled. 

      Inventory Type

      The radial selected will display either Internal, Consigned or Instores only. 

      Part Number Range The range or internal part numbers selected for counting.

      Warehouses

      Available

      The name of any available warehouses selected for counting.

      Selected

      The name of the warehouses that were actually selected for counting.

      Part Classes

      Available

      The part classifications which were available for counting.

      Selected

      The part classifications that were actually selected for counting.

       

      Depressing this button will start a new Physical Inventory.

       

      1.5.6.3.2. The Count Tab

      Depressing on the Count Tab brings up the following screen:

       

      Count Screen Fields

      Inventory Type

      The type of Inventory, either Internal, Consigned or Instores.

      Supplier/Customer

      If the Inventory Type is Instore, the Supplier name will display in this field.If the Inventory Type is Consigned, the Customer name will display in this field.

      Date/Time Started

      The date and time (24 hour clock) when the Inventory was originally started.

      Status

      The status of the physical inventory, either In Process, Completed or Cancelled.

      For the part number highlighted:

      Warehouse

      The warehouse location for the part to be counted.

      Location

      The warehouse location for the part to be counted.

      Part Source

      The Make/Buy/Consigned/In Store type for the part to be counted.

      UOM The Unit of Measure to be counted.  Same as stocking unit.
      Class

      The classification of the part.

      Type

      The type within the classification to which the part belongs.

      Description

      The description of the part.

      Manufacturer’s Part No

      The number used by the manufacturer to identify the part.

      Tag No. If you have already printed Physical Inventory Tags, the Tag Number will appear in the Tag Number column. (Unless you numbered them manually, as described above.)I  f you have not printed tags, the Tag Number column will be blank.
      Part Mfgr The Manufacturer for the part to be counted.
      Part Number

      The Internal Part Number that has been assigned to the item to be counted.

      Lot Reference

      If the part type has been designated as requiring lot tracking, then the lot tracking reference number appears.

      Rev

      The part number revision for the item.  An item may exist under multiple revisions.

      Count The physical count quantity of the item observed during Physical Inventorying.
      Init

      The initials of the individual who performed the Physical Inventory.

      Date

      The date that the inventory was counted.The date will default to the current date, but may be over-written.

        This button is used to post the Inventory Adjustments.This is used after the inventory has been reconciled and the Physical Inventory Detail Report has been printed and reviewed.  This button will update the Inventory Master for the quantity on hand.  Note:   this action requires a supervisor’s password or specific "Post Inventory Adjustments" authorization in the Security module. 

      1.5.6.4. How To ..... for Physical Inventory
      1.5.6.4.1. Setup a Physical Inventory

      Enter Inventory Mgt/Inventory Control Management/Physical Inventory Module  

      The following screen will appear:

      Depress the Add record action button. Type in your password. The following warning will appear:

      Depress Ok and the following options screen will appear:

      Selecting “Yes” will allow the user to manually number the inventory tags, item by item.

      Selecting “No” causes the system to automatically number the tags.

      Please refer to the Tags and Work Sheets instructions.

      The following screen will appear:

      Select the Inventory type by clicking on the appropriate radial.  Select from Internal, Consigned or In StoresInventory. Internal inventory represents user-owned inventory.  Consigned inventory is owned by the user’s Customer.  In Stores inventory is owned by the Supplier.

      In-Store purchasing overview:  In-Store is the situation where the Supplier has placed raw materials in the user’s warehouse.  The raw materials still are owned by the Supplier.  When the user is ready to use the Supplier’s raw materials, he/she issues an In-Store Purchase Order.  For In-Store POs, the user may select by Supplier or by Part Number.  Then the user may find records according to the selection.  Once found, the user may create a PO for the In-Store Consumption.  In-Store Purchasing also includes receiving.

      If you select the Inventory Type to be Consigned, a list of customers will appear:

      Select the Customer.

      If you select In stores Inventory, a list of Suppliers will appear:

      Select the supplier.

      Select the warehouses to be counted by highlighting a warehouse and depressing the > button.  If you want to count all warehouses, depress the >> button.

      To select part number range, enter the starting part number and the ending part number.

      To select the part classes, highlight the class desired and depress the > button.  For all of the part classes, depress the >> button.

      A view of the screen would be as follows:

      Depress the button to Start New Physical Inventory. A message will appear on the screen:

      Depress the OK button.  Information is transfered to the Count Tab.

      Important Caution:  The user must finish the Physical Inventory completely before the system is enhanced.

      1.5.6.4.2. Finding a Physical Inventory

      Enter Inventory Mgt/Inventory Control Management/Physical Inventory Module  

      The following screen will appear:

      Depress the Find action button. The following screen will appear:

      Decide upon the Inventory Type that you want to find.  Select from Internal Only, Consigned Only or Instores Only by clicking on the appropriate radial.

      Then choose the appropriate filter, either In Process, Completed, Cancelled or All by clicking on the appropriate radial.  Depress the Display List button once the selections are made.  The information at the bottom of the screen will display Date/Time Started, Inventory Type and Status.

      If you select Consigned, you’ll be prompted for the Customer name.  If you select Instores, you will be prompted for the Supplier name.

      Once you’ve found the Inventory you’re seeking, the information will populate the Count tab screen, as follows:

      1.5.6.4.3. Record a Physical Count

      Find an In-Process Physical Inventory.  The following information will appear in the Count tab screen.

      Depress the Edit action button.  Type in your password.

      To sort by warehouse, depress the Warehouse button.  To sort by Class, depress the Class button.  To sort by part source, depress the Part Source button.  You will also be able to sort by tag number or part number by depressing on the heading.

      Enter the final count from the tag or the worksheet.  The system will capture the initials from your password.  The system will enter the date.
       
      All warehouses and location will be listed for the internal part pulled forward for a count, with the exception of quantities that are in WO-WIP, these quantities are not included in the Physical Inventory.  At this time user may move parts from one warehouse/location to another if needed by entering the count that resides in that location/warehouse.   User are not allowed to add new items to the PI inventory listing, due to the fact that the count could phycially already be in process. If we allow you to keep adding and deleteing records from the count it might cause issues for what is already in process.
       
      Also, ManEx does not allow user to edit a lot code for inventory items once they have been accepted into the system. ManEx does not allow you to change the Lot Code information anywhere within the system once received. Once in the system we have to maintain that lot code with those records through out the system, to have good Lot Control.
       
      Depress the Save action button.

      The screen would appear as follows:

      1.5.6.4.4. Reconcile the Physical Count

      When the recording is complete, depress the  Reconcile button (as highlighted below).  Enter your password. This will reconcile the inventory.

      If the inventory count does not match the system on hand quantity, the following screen will appear:

      If you want to update the records for the counted quantity, depress the Yes button.  Type in the reason in the Reason box.

      If you want to skip over the record, depress the Next Item button.  Note, however, that you can’t update the quantity on hand until all of the inventory items are reconciled.

      Once all of the counts are reconciled, the detail will disappear from the screen.

      1.5.6.4.5. Update the Inventory Master for Inventory on Hand

      Once you’ve reconciled the inventory and printed and reviewed the Physical Inventory Detail Report, you may update the Inventory Master for the Inventory on hand.

      Depress the Count tab.  Depress the Post Inventory Adjustments button.  Note:  this action requires a supervisor’s password or specific "Post Inventory Adjustments" authorization in the Security  module.

      All of the reconciled count numbers will update the quantity on hand in the Inventory Master.  The status will change to Posted.  The following message will appear:

      Additionally, the requisite GL Transaction for any variances will forward into the accounting module.

      Note that GL Transactions will not be created in the following circumstances:  Consigned stock or In Store additions.

      1.5.6.5. Reports - Physical Inventory
      To obtain the Inventory 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. 
       
       

      NOTE: Users MUST have special rights within the Security module to "Enable Printing On-Hand Quantities on the PI Reports"  

       
       
       
       

      TAGS:

      If you selected Manual Inventory Tags from this screen:

       

      Depress the Count tab.  The following screen will appear:

       


      Depress the Edit button. Type in your password.  Manually type in the Tag No. for each item. The system will automatically re-order the tags in numerical order.

      Physical Inventory Tags

      When you have finished, depress the Print button. The following screen will appear:

       

      Select Physical Inventory Tags.  Depress the Options tab.  The following screen will appear:

      Choose between All Locations and Only Locations with Quantities > 0.Choose the sort options, either Warehouse + Location + Part Number + Rev + Lot Code or Part No + Rev + Lot Code.

      Depress the OK button. An Inventory Tag will be printed for each mfgr per item.

      The tags will print 3 each on 8 ½ X 11 paper.  If the Inventory type is consigned, the Customer’s part number will print.

      If you did not select manual inventory tag numbering:

      A box will appear on the screen to Enter Starting Tag No:  

       

       The Printed tags will appear as follows:

        

       

      Below we have attached blank Inventory Tags   <<blank IT.doc>>  and   <<blank IT.pdf>>   that may be used if for some reason NO tags were printed for parts that may have inventory but are NOT being displayed in the Physical Inventory listing, etc. NOTE: These are only intended to be used if user happens to find product that was not on the physical Inventory list for some reason.

       

      Reprint Physical Inventory Tags 

      Select the Reprint Physical Inventory Tags, depress the Options tab and the following screen will appear:

      Enter Tag Number Range to Print.

      Depress the OK button

      The tags will print 3 each on 8 ½ X 11 paper.  If the Inventory type is consigned, the Customer’s part number will print.

       

       

      Physical Inventory Worksheet

      Select the Physical Inventory Worksheet, and depress the Options tab.  Note that this report requires Legal size paper.  Selecting this report will bring up the following screen:

      Click on the appropriate radial selection criteria. Choose one of the following: All Records, Internal (excluding In stores), In Stores or Consigned. If the Inventory type is consigned, the Customer’s part number will print. 

      Click on the appropriate radial for Locations selection. Choose between All Locations or only Locations with Quantities greater than zero.

      Click on the desired radial to select whether to print On Hand quantity. Select between Not printing or printing the on hand quantities.   

      Click on the appropriate radial for Sort Options.Choose between (Warehouse, Location, Part Number, Revision number and Lot Code), (Part Number, Revision Number and Lot Code) or by (Tag Number).

       

       

      The report will appear as follows:

      Physical Inventory Detail Report  

      Select Physical Inventory Detail Report, depress the Option tab, and the following screen will appear: 

      Click on the appropriate radial selection criteria. Choose one of the following: All Records, Internal (excluding In stores), In Stores or Consigned. If the Inventory type is consigned, the Customer’s part number will print. 

      Click on the appropriate radial for Locations selection. Choose between All Locations or only Locations with Quantities greater than zero.

      Click on the appropriate radial for Sort Options.Choose between (Warehouse, Location, Part Number, Revision number and Lot Code), (Part Number, Revision Number and Lot Code) or by (Tag Number).

      Depress the OK button

      Note that this report is designed to be printed after the count has taken place and been reconciled.

       

       

       The report will appear as follows:

       

      PI Detail w/Part Mfgr Report

      Select the PI Detail w/Part Mfgr Report, and depress the Options tab.  Note that this report requires Legal size paper.  Selecting this report will bring up the following screen:

      Click on the appropriate radial selection criteria. Choose one of the following: All Records, Internal (excluding In stores), In Stores or Consigned. If the Inventory type is consigned, the Customer’s part number will print. 

      Click on the appropriate radial for Locations selection. Choose between All Locations or only Locations with Quantities greater than zero.

      Click on the appropriate radial for Sort Options.Choose between (Warehouse, Location, Part Number, Revision number and Lot Code), (Part Number, Revision Number and Lot Code) or by (Tag Number).

      Depress the OK button

      Note that this report is designed to be printed after the count has taken place and been reconciled.

       

      The report will appear as follows:

       

      1.5.7. Standard Cost Adjustment
      1.5.7.1. Prerequisites

      After activation, "Standard Cost Rollups" access for each user must be setup in the ManEx System Security module.  Users with “Supervisor Rights” will automatically have access.    

      Note: Users MUST have special access for the "Roll Costs" button to be activated.  This access is assigned through Security/User Rights. 

       

      Part Number

      The Part numbers for at least one of the following must have been entered in the Inventory Control module: Customer, Manufacturer or Supplier.

      1.5.7.2. Introduction
      This module allows the user to change the Standard Cost, labor cost, overhead cost, other costs, and user defined costs.  This screen also allows a roll up of standard costs into the appropriate Bill of Materials.  The user has the ability to start a new cost roll up.  The roll ups go to another screen where the user can select or modify the rollup. 

      (This module will consider Make/Buy inventory part numbers as BUY parts and will be rolled into the Buy portion of the Std Cost Adjustment module.   

      Phantom parts are not rolled up and calculated costs assigned.  The components will remain rolled up to the next higher assembly.  The system will reset all the Phantom parts to 0.00 before saving it to the inventory.  The standard cost adjustment module will just use their cost to calculate Top assembly costs.  When the last rollup is reached, the system will reset all phantom standard costs to zero (since they should not have a cost), and also make sure that any phantoms at the lower level has the "Use calculated cost" checked so that it gets updated in order to roll into the next level up.  Because users may have numerous phantom (not make/phantom) assemblies in the system, the module will automatically check the "Use calculated cost" for every phantom assembly at each cost roll level.    

      Once satisfied, the user can roll the costs into the inventory tables and the General Ledger journal entries will be created.  The user also has the ability to level make parts.  All Make parts will be leveled.  After the leveling has been completed, the user has the ability to roll up Make parts.  All Make parts will be rolled up.  If the same part appears more than once (used at different levels of BOM's throughout the system), the BOM will be leveled and considered at the lowest level that exists within the system. 

      The user then go to the Modifications tab where he/she can evaluate the changes, accepting or modifying them. Once the user is satisfied, the Roll Costs button can be used.  All inventory tables will be updated and records will be created for the General Ledger Journal entry.  Note:  A high level Accounting password is required to generate the Roll up.
       
      When standard cost adjustments are created against an inventory part number that contain both regular stock and In-store stock the module will only show the delta for the regular stock on hand.  The Std Cost Adjustment module will filter out the in-store warehouse qty's when updating the costs within the Cost Adjustment Release to GL screen.  
      1.5.7.3. Fields & Definitions
      1.5.7.3.1. Selection Tab

      Enter the percentage to use if the part material cost is different from the Weighted Average Price Value by Greater than or Equal to or if the assembly material cost is different from the Sum of the parts standard value by Greater than or Equal to     Or   Difference between Calculated and Current Greater or Equal to $ 
      Example:  if there is a $2000.00 assembly in stock, and users apply the 1% criteria, a $19.00 difference won't be brought into the matrix to be checked.  On the other users enter 0%, then every single part will be included.  A Minimum dollar value has been added to the Standard Cost Adjustment screen that will be used to determine whether or not an item is included in the matrix.  If left blank then the percentage rules.  If value entered then it becomes the criteria for inclusion in the matrix.     

      Check box if you "Do not want items listed with 0 inventory and no purchase history for the current year", then the standard cost will remain unchanged

      Check this box if you want to  "Allow user to enter in the Weighted Average Variable".  Once this has been checked the users can then enter in the number of the most recent Purchase Orders they wish to have included in the Weighted Average Calculation. This give the user the option to eliminate the Quick Turn buys that may throw the calculations off.  

      User also has the option to select the part number range , class, or type, on which part(s) to process.  This will complete the adjustment process faster and user will be able to maintain more accurate records and also allow the users the ability to narrow the resulting filter of the Buy parts.  NOTE:  The Part Number range selection is available for only BUY parts. ManEx does not offer it for MAKE parts, because the system needs to roll ALL sub assemblies up to determine the top level costs. However, in the modifications tab, it is possible to sort by part number or class, to make it easier for the user to find specific items of interest.
       
      To roll up the Buy Parts, depress the Roll up BUY Parts button.  To roll up Make Parts, depress the Roll up MAKE Parts button.  To Level Make Parts depress the Level MAKE Parts button.
       
      1.5.7.3.2. Modification Tab

      Modifications tab field definitions

       
      Check All - Use calc cost for all records  If this box is checked - the system only checks the record if the calcualted cost > 0.  If this box is checked at one level, this option will carry forward as checked when users move to the next levels.
      Check All - Use calc cost for calc cost not zero if this box is checked - the system will check all records to use calculated cost no matter it's zero or not.  If this box is checked at one level, this option will carry forward as checked when users move to the next levels.

      Part Number

      The number the user has assigned to the part within the  ICM  module. 

      Rev

      The revision number assigned to the Part Number within the  ICM  module.

      Class

      The classification to which the part belongs. 

      Type

      The type within the classification to which the part number belongs.

      Description

      The description assigned to the Part Number within the  ICM  module.

      Quantity

      The quantity is the number of units currently owned. This excludes all un-purchased In-Stores Inventory. ( for explanation on In-Store Inventory See Purchasing Manual)  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.

      Material Cost

      This cost is defaulted in from the cost currently assigned to the part number through ICM or PO .

      ·Important Note - If accounting is installed: For all buy parts, the standard cost field must have data entered.  If this data is missing (or wrong), the Raw Materials Inventory and the Work In Process (WIP) will be incorrect for the accounting records.  All make parts which are not labor only (the customer brings you the kit and all you do is apply the labor), must have data entered in the standard cost field.  Additionally, the data entered in the standard cost field for the make part must equal the sum of the Bill of Materials components.(Please refer to Bill of Materials Reports – Bill of Material With Standard Cost.)   If the data is missing or wrong on a Make Part, the Work In Process, Cost of Goods Sold and Finished Goods Inventory will be wrong for the accounting records.  If the sum of the Bill of Materials components does not equal the standard cost per the Item Master, a configuration variance will generate.

      New Material Cost

      This represents the revised or up-dated Standard Cost.  This column is colored so users can easily differentiate between the old cost and new cost.

      Use Calc

      If this box is checked, the calculations determined in the Selection tab were applied to the cost.  This box will be automatically checked for phantom (not Make/Phantom) assemblies in the system at each cost roll up.

      Calculated Cost

      This column is the result of the calculations determined in the Selection tab as applied to the original Standard Cost.

      Use Manual

      If this box is checked, the new Standard Cost was manually typed in and was not determined by any thing in the Selection tab.

      Manual Cost

      This column is the result of the new standard cost being entered manually and the Use Manual box being checked.

      By moving the arrows (at the bottom of the screen) to the right the following fields are also available

      Labor 

      The labor cost currently assigned to the part number.

      New Labor

      This represents the revised or up-dated Labor cost.  This column is colored so users can easily differentiate between the old cost and new cost.

      Overhead  The overhead cost currently assigned to the part number. 
      New Overhead  This represents the revised or up-dated Overhead cost. This column is colored so users can easily differentiate between the old cost and new cost.
      Other Costs  The other costs currently assigned to the part number. 
      New Other Costs  This represents the revised or up-dated other costs. This column is colored so users can easily differentiate between the old cost and new cost.
      User Defined The user definded costs currently assigned to the part number. 
      New User Defined This represents the revised or up-dated user defined costs. This column is colored so users can easily differentiate between the old cost and new cost.
       Delta

      The column is the net change between the original Standard Cost and the New Standard Cost multiplied by the Quantity.

      If this button is depressed the costs will roll up to all of the Inventory Tables plus the records required for accounting will be created for posting to the General Ledger. 

      Note
      : Users have to have special access in order for this button to be enabled.  This access is assigned through Security/User Rights. 
      Date Run

      This is the date of the run.

      This button is used to recalculate the total change (Delta) column.

      Total

      This is the total of the column “Delta” (change).

      1.5.7.4. How To ....
      1.5.7.4.1. Find a Standard Cost Adjustment

      Enter Inventory Mgmt/Inventory Control Management/Standard Cost Adjustment Module  

      The following screen will appear:

      To find a Previously created Standard Cost Adjustment where the roll costs has not yet been performed, depress the Find action button.  The following selection screen will appear:

      If you select to find by Buy Parts, the following screen will appear:

       

      1.5.7.4.2. Start New Roll Cost

      Enter Inventory Mgt/Inventory Control Management/Standard Cost Adjustment Module   

      The following screen will appear:

      Depress the Add action button (Start New Cost Roll) and the folloiwng items will become enabled:

      Type in the percentage to use if the part material cost is different from the Weighted Average Price Value by Greater than or Equal to or if the assembly material cost is different from the Sum of the parts standard value by Greater than or Equal to   Or   Difference between Calculated and Current Greater or Equal to $ 

      Example:  if there is a $2000.00 assembly in stock, and users apply the 1% criteria, a $19.00 difference won't be brought into the matrix to be checked.  On the other users enter 0%, then every single part will be included.  A Minimum dollar value has been added to the Standard Cost Adjustment screen that will be used to determine whether or not an item is included in the matrix.  If left blank then the percentage rules.  If value entered then it becomes the criteria for inclusion in the matrix.   

      Check box if you "Do not want items listed with 0 inventory and no purchase history for the current year", then the standard cost will remain unchanged

      Check this box if you want to  "Allow user to enter in the Weighted Average Variable" or you can type in the number of  PO(s) to include in the calculated weighted cost.

      User also has the option to select the part number range , class, or type, on which part(s) to process.  This will complete the adjustment process faster and user will be able to maintain more accurate records and also allow the users the ability to narrow the resulting filter of the Buy parts.  NOTE:   The Part Number range selection is offered only for BUY parts. ManEx does not offer it for MAKE parts, because the system needs to roll ALL sub assemblies up to determine the top level costs. However, in the modifications tab, it is possible to sort by part number or class, to make it easier for the user to find specific items of interest. 

      NOTE:  Due to the fact that inventory records flagged as MAKE/BUY can not have Work Orders generated for them.  The Standard Cost Adjustment module will consider MAKE/BUY inventory part numbers as BUY parts and will be rolled into the Buy portion of the Std Cost Adjustment module.

      To roll up the Buy Parts, depress the Roll up BUY Parts button.  Upon rolling the records the system will now consider all of the Costs, and not just the material cost.

      After the calculation is complete, the following message will appear:

      Depress the OK button.  Depressing on the Modifications tab reveals the following:

      Depress the Edit button.  To effect a change, click on either the Use Calc column or the Use Manual column.

      If you choose Use Manual column, you must also enter a new manual, labor, overhead, other, or user defined cost: 

      Note that the Delta column updates automatically.  This is the difference between the old Standard Cost and the New Standard Cost multiplied by the Quantity.  (Note:  The quantity may include setup scrap and/or run scrap if the box to exclude scrap from Cost Rollup is not checked in the  Kit Default Setup screen).

      To Re-calculate the total change (Delta), depress Recalculate Total button.The Total will update, as illustrated:

      Depress the Save record action button.

      To Post the changes to the Standard Cost and generate the General Ledger entries, depress the Roll Costs button.  The system will update the "Last Change" field (within the ICM screen) for part numbers that actually had pricing information changed within the Std Cost Adjustment. 

      Enter your password.   Note:  This requires a high level accounting password.

      The following message will appear once the update has been completed.

      Depress the OK Button.

       

      1.5.7.4.3. Level and Roll Up Make Parts

      The Level Make Parts button causes the system to find all Indented Bills of Materials.  Then the system “tags” the lowest indenture.    Users will NOT be able to add or edit any BOM during this process.  If a user is already in the process of modifying a BOM and this process is started the user will NOT be allowed to save the changes until the leveling process is complete.

       

      Enter Inventory Mgt/Inventory Control Management/Standard Cost Adjustment Module   

      The following screen will appear:

      Depress the Add Record (Start New Cost Roll) action button, enter password, then depress the Level MAKE Parts button. The following message will appear once the update has been completed.



      Depress the OK Button. The following screen will appear:  
       
       
      The Level of Levels information automatically updated to the next level that needs to be Rolled up.
       
      Then depress the Roll up Make Part button. The following message will appear:


      Depress "Yes" to continue.  If a rollup already exists the following option screen will appear:

      Depress "Yes" to continue. The following message will appear:

      Enter into the Modification screen, only the Level 1 of 2 Levels assemblies will be displayed (sub-assemblies, etc).  Depress the Edit Record action button and select the Use Calculated or Use manual to make any changes.   If Use Manual is selected then you have to enter in the Manual Cost.

      Save the changes and depress the “Roll Costs” button. The following message will appear:

      Depress the OK Button, then return to the Selection screen. 
       
       
       The Level of Levels information automatically updated to the next level that needs to be Rolled up.
       
      Depress the Add Record (Start New Cost Roll) action button, enter password, then depress the Roll up MAKE Parts button to roll up Level 2 of 2 Levels.  Continue this process to level all indents starting with the lowest to the highest.
       
      Once the highest level has been reached the Modufications screen will be poplulated with all the Finished Goods Inevntory parts. 
       
       
       
      a)  For the PHANTOM parts the standard cost calculated is based on their components (SUM of component's qty * component standard cost).  Once the standard cost is calculated for the PHANTOM part, the cost roll up will treat the PHANTOM part as a single entity on the top assembly BOM and proceed as it was a BUY part with the std cost already entered.

      b)
        If one of the component parts on the top level is a MAKE (not MAKE_BUY) and HAVE components assigned to it, the cost roll up will NOT include the std cost of the parts itself, it will only include the std cost of its subcomponents.


      c)
       
      If one of the component parts on the top level is a MAKE (not MAKE_BUY) and does NOT HAVE parts assigned to it the cost roll up will include the std cost of the part itself.

      d)  If one of the component parts on the top level is a MAKE and MAKE_BUY the cost roll up will included the std price for the part itself and will NOT include the std costs for the subcomponents.  For an example see the Word attachment <<The Std Cost of the MAKE_BUY_081211.docx>>).

      e)  If one of the component parts on the top level is a MAKE and a Phantom/Make the cost roll up will NOT include the std price for this part because the cost roll up will include the cost of this parts components.

      Note:  The calculated cost will only include the costs for ACTIVE parts and subassemblies as of the date of the roll up and will NOT include any parts that may have been identified as inactive either in the item master or in the obsolete date of the part on the BOM.


      The values displayed should be in sync with the
      BOM with Std Cost Report  values.  
      The following may be why the Standard Cost Roll is different from the Cost BOM Reports.
       
      a)    On the costed BOM Report for a Make/Buy assembly we display the value of the BOM in the costed report, but that total is NOT used in subsequent rollups to higher levels only the standard cost is.  

      b)   
      In Kit Default Setup , user can exclude scrap and setup scrap in Kitting, MRP, and Cost Rollup, this will overwrite what user check in the BOMTherefore, if user checks "Setup Scrap" checkbox in BOM, but checks to exclude in cost roll, the costroll will not calculate setup scrap cost, but BOM will always calculate setup scrap cost if the Setup Scrap checkbox in check in BOM. 
      1.5.7.5. Std Cost Adjustment Reports
      To obtain the Standard Cost Adjustment report, 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 OK button. 



      Standard Cost Rollup Report will print:

       
       
      Note:  The calculated cost will only include the costs for ACTIVE parts and subassemblies as of the date of the roll up and will NOT include any parts that may have been identified as inactive either in the item master or in the obsolete date of the part on the BOM.  
       
       
      ManEx strives to make the Std Cost Rollup values be in sync with the "BOM with Std Cost" "Top Assembly Costed BOM" report and the  "Indented Costed BOM" report. The following may be why the Standard Cost Roll is different from the Cost BOM Reports.

      a)    On the costed BOM Report for a Make/Buy assembly we display the value of the BOM in the costed report, but that total is NOT used in subsequent rollups to higher levels only the standard cost is.  

      b)    In Kit Default Setup , user can exclude scrap and setup scrap in Kitting, MRP, and Cost Rollup, this will overwrite what user check in the BOMTherefore, if user checks "Setup Scrap" checkbox in BOM, but checks to exclude in cost roll, the costroll will not calculate setup scrap cost, but BOM will always calculate setup scrap cost if the Setup Scrap checkbox in check in BOM.

      1.5.7.6. FAQs - Standard Cost Adjustment
      Facts and Questions for the Standard Cost Adjustment Module
      1.5.7.7. ManEx Minutes-Std Cost Adjustment
      1.5.8. Part Manufacturer Setup

      Enter Inventory Mgt/Inventory Control Management/Part Manufacturer Setup Module
       
      Note:   After activation, "Part Manufacturer Setup" access for each user must be setup in the ManEx System Security module.  Users with “Supervisor Rights” will automatically have access.
       
      Each Item Master Quantity Info Screen with a Buy Source refers to a Manufacturer to be selected from a pull-down list of Approved Manufacturers and a Manufacturer’s part number to be entered.  Note:  If no manufacturer is selected, it will default to GENR, for generic.

       

       

      The following screen will appear:

      Depress the Add Record action button, to add a New record. Depress the Edit action button to edit an existing record.  Enter the password.

      Enter the Manufacturer’s Code in the box shown. (A code of up to 8 characters must be entered)  The system will not allow the Mfgr Code to contain any spaces. 

      Enter in the full Part Manufacturer Name. 

      Depress the Save record action button to save changes, depress the Abandon changes action button to abandon changes.