1. Inventory Management
1.1. Packing List Management
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.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.3. Fields & Definitions for Packing List Mgmt
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.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.3.3. Ship Instruction Tab

 

Shipping Instructions Tab Detail

This tab is used for special instructions regarding the shipment.  This note will be displayed on all Packing Lists created for the same Sales Order.

 

 

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.3.5. Notes Tab



Notes tab field definitions

Sales Order Note

This section will display any note pertaining to the Sales Order. This note will be displayed on all Packing Lists created for the same Sales Order.

Packing List Footnote

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

1.1.4. How To ..... for Packing List Mgmt
1.1.4.1. Find an Existing Packing List

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

The following screen will be displayed, enter Inventory Management/Packing List Management/Packing List Management


The following screen will be displayed.  

Depress the Find action button. The following selection screen will be displayed

Select the desired Filter: by selecting the appropriate radio button - Unposted, Posted,  or All.

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

Enter the information into the red box, depress the Enter key and the information will populate the screen.    If you do not know the exact number, Customer, etc you may enter in a partial number, letter, etc, then once you depress the enter key the system will pull up the matching record onto the screen or a list of all Packing Lists that contain the partial number, letter, etc. entered, to select from.
 
The user may exit the selection screen without a selection by selecting the X button.
 

If user selects ANY of the Filters and Find by All - a screen will appear listing all the Packing List filtered by the selection,  in numberical order, along with the Customer name.   


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

 

 

Once you have made your choice, the information will be displayed as follows
 
 
1.1.4.2. Add a New Packing List

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

The following screen will be displayed, enter Inventory Management/Packing List Management/Packing List Management


The following screen will be displayed. 

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 a "T" under the RMA coulmn. The user selects the Sales Order number by either entering it into the 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.  

Select Active or Inactive Customers by checking the appropriate box.

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 Sales orders are shown in numerical order, along with the Customer Name, Customer PO, and a "T" for an RMA (If applicable).  The user selects the Sales Order by either entering it into the 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 all Customers.  The user selects the customer by scrolling down the list and clicking on the selected Customer.

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 this message when creating the PL.




If the user has selected the Add Sales Order Item(s) option, the following screen will appear:  Note:  Each item defined on the Sales Order will be displayed on this list for user to select from.  The user can highlight and add one item at a time, or highlight and add more than one at a time.  If the sales order has many lines and only a few are NOT being shipped, the user can add them all, and delete the lines that do not apply. 



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 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.  These notes will appear on all Packing Lists created for the same Sales Order.


Tabbing on the History tab will bring up the following:

This will give you the Shipping History of 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 will be displayed on all the Packing Lists created for the same Sales Order, 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 AAccounting Setup/Accounts Receivable Defaults,  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 it is released to Invoice.   Once the Packing List has been "Released to Invoice" no edits are allowed.
 
1.1.4.3. Edit an Existing Packing List

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

The following screen will be displayed, enter Inventory Management/Packing List Management/Packing List Management




The following screen will be displayed:
 


Find  a Packing List.  (Note:  The Packing List will be editable if the Invoice has NOT been Released to A/R, once the Invoice has been Released to A/R the Packing List is no longer available).  Depress the Edit Action button.  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 change the qty, delete the line item, add a manual item or add an Item Note.
 
 
Ship Instructions The user may add/edit shipping instructions.  These shipping instructions will be displayed on all the Packing Lists created for the same Sales Order.
 
 
History tab - This screen is not editable
 
 
Notes tab  - The user may add/edit Sales Order notes and/or Packing List Footnotes.  The Sales Order notes will be displayed on all the Packing Lists created for the same Sales order.   
 

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 then re-print the Packing List.
 
 
1.1.4.4. Link User Defined Fields to a Packing List
The User Defined fields MUST be setup within Web ManEx.  For further detail see Article #5454.

To link a UDF to a Packing List select a record in the ManEx Desktop, and select the UD action button (as displayed below).



The UDF for that section will then be displayed, and user can make changes (if applicable), Save & Exit or Cancel. 




1.1.5. Reports - Packing List Mgmt

To obtain the Packing List Reports within the Web, select the WEB Print button from the ManEx action buttons at the top of the screen. For further detail on How the Reports work within the Web refer to Article #5477.
 
Note: In order to access the Reports within the Web the Company Root URL must be setup within the System Appearance module and user must be linked to web within the System Security Module.
 

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





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



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


 
 

Highlight the desired report and then depress the OK button  

PACKING LIST REPORT

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

Select the radio button  to Print using internal part numbers or customer part numbers.


Select the radio button 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.

Select the radio button  to sort by, either Packing List, Sales Order, Customer, or Ship Via.


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.




 'C of C Required' will be displayed on the Packing List Report, only if the "Certificate Required" box is checked in Packing List
 
 
 

The number of copies for packing list and invoices on desktop version is controlled by Crystal Report.  User can see the different copies of PK/INVOICE and decide which one(s) they want to print.

 

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:

 
 

Enter Sales Order #

Enter Date Range

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:

 

Enter Packing List Number

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, and Line 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.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 the SQLMANEX.EXE (within the ManEx root directory)
This action will then prompt the user for a password

The following screen will be displayed, enter Inventory Management/RMA Receiver Module

 

The following screen will be displayed:

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

Select the desired Find: by selecting the appropriate radio button -  RMA Receiver Number, Customer, RMA Number, or All.
 

Enter the information into the red box, depress the Enter key and the information will populate the screen.   If you do not know the exact number, Customer, etc you may enter in a partial number, letter, etc, then once you depress the enter key the system will pull up the matching record onto the screen or a list of all RMA Receivers that contain the partial number, letter, etc. entered, to select from. 
 
The user may exit the selection screen without a selection by selecting the X button.
 

If user selects All - a screen will appear listing all the RMA Receivers in numberical order, along with the Customer name, RMA Order number and RMA Receiver Date.    


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

 

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 the SQLMANEX.EXE (within the ManEx root directory)
This action will then prompt the user for a password

The following screen will be displayed, enter Inventory Management/RMA Receiver Module

 

The following screen will be displayed:

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

Enter the RMA Order Number into the red box or highlight your choice and double click.  Information from the RMA Management module will be displayed 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 be displayed:

 

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

Enter the Serial Number to be received into the Receiver Serial No box. 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.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 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.
Clicking on this button will bring up a screen listing any shortages for the part number highlighted.  If there are no shortages for this part a message will appear informing user that there are no shortages for this part.
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 the SQLMANEX.EXE (within the ManEx root directory)
This action will then prompt the user for a password

The following screen will be displayed, enter Inventory Management/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  the following screen will be displayed:

 

To Find an existing PO Dock Receiver, depress the Find record action button.  The following selection screen will be displayed
 

Select the desired Filter: by selecting the appropriate radio button - Open Receivers, Closed Receivers, or All.

Select the desired
Find: by selecting the appropriate radio button -  PO No., Supplier, Receiver No., Inventory Part No., Inventory Mfgr Part No., All, MRO Part No., MRO Mfgr Part No., or MRO Description 

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

The user may exit the selection screen without a selection by selecting the Cancel button.

 

If user selects ANY of the Filters and Find by All - a screen will appear listing all the PO Dock Receivers filtered by the PO Number in numerical order, along with the Supplier name, Receiver Number, date PO Dock Receiver was created and Status of PO.   


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

 
 

Once you have made your choice, the information will be displayed as follows:


 

1.3.1.4.2. Add a Dock Receiver

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

The following screen will be displayed, enter Inventory Management/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 be displayed:

 

 To add a new receiving record, depress the Add action button.  User will be prompted for their password.  The following selection screen will be displayed. 

Select the desired Find: by selecting the appropriate radio button -  PO No., Supplier, All, Inventory Part No., Inventory Mfgr Part No., MRO Part No., MRO Mfgr Part No., MRO Description.  

Enter the information into the red box, depress the Enter key and the information will populate the screen. 

The user may exit the selection screen without a selection by selecting the Cancel button.

 

If user selects  ALL, the following screen will appear:

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

 

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

Enter 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.
 
 
If the "Shortage" button is RED that reminds the user that there are shortages for this part.  Depress the "Shortage" button and a screen will be displayed listing the shortage's for this specific part. 
 
 
 
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.


The Complete PO Dock Receiving Screen will look like this:
 
 
 
1.3.1.4.3. Editing a Dock Receiver

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

The following screen will be displayed, enter Inventory Management/Purchase Order Receiving & DMR/Purchase Order Dock Receiving


 
The Following screen will be displayed:
 




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 AP Aging Reports within the Web, select the WEB Print button from the ManEx action buttons at the top of the screen. For further detail on How the Reports work within the Web refer to Article #5477.


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


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



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



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

Highlight the desired report and then depress the OK button.


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 OK button. 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

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

The following screen will be displayed, enter Inventory Management/Purchase Order Receiving & DMR/Purchase & Receiving Management module

 

The following screen will be displayed:

 

1. To Find an existing PO Dock Receivier, depress the Find action button at the top of the main screen and the following selection screen will be displayed. 
 
Select the desired Filter: by selecting the appropriate radio button - Open Receivers, Closed Receivers, or All.

Select the desired
Find: by selecting the appropriate radio button - PO No., Supplier, Receiver No., Inventory Part No., Inventory Mfgr Part No., All, MRO Part No., MRO Mfgr Part No., or MRO Description.

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

The user may exit the selection screen without a selection by selecting the Cancel button.

 
2.  If the user selects to find by ALL, the screen displayed will be shown listing all the PO Number's in numerical order, along with the Supplier name, and Receiver Number. 
 

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

 

 

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

1.3.2.4.2. Add a PO Receiving Inspection Record

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

The following screen will be displayed, enter Inventory Management, Purchase Order Receiving & DMR, Purchase Receiving Management


The following screen will be displayed:
 



If system is setup for Dock Receiving a PO Dock receiver MUST be created before the PO will be available. 
  1. Add a record.
  2. The user will be prompted for the password. 
  3. Find  a Purchase Order 
  4. If Supplier Packing List Number is NOT already entered, enter it now.
  5. Select the part to receive.
  6. 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.

     

     

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

     

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

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

  10. Issue parts directly to Work Order Shortages.

  11. 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 Type 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 AP Aging Reports within the Web, select the WEB Print button from the ManEx action buttons at the top of the screen. For further detail on How the Reports work within the Web refer to Article #5477.


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


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


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





    The following reports screen will display a list of reports that are available on the ManEx Desktop:  
     
     
     
    Highlight the desired report and then depress the OK button.

     

    MATERIAL RECEIPT LABELS  - Prints labels for receipt by part no, desc, whse locn, qty     

    For the PO Receiving Material Receipt Labels, you can choose between the Avery label #5163 (laser Sheet 4x2) or the Zebra Printer
     
    Depress the OK button.
     
       
    Enter in a Purchase Order number. 
     
    Depress the OK button.
     
    The information will automatically fill in. All labels will be displayed on screen, if users desire they can then determine which labels they want and using the printing dialog box select the label to print and/or the number of labels.
     
    Note: The Mfgr and Mfgr PN info is being pulled from the PO Module and not the Receiving Module.
     

     

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

    MATERIAL RECEIPT TRAVELER REPORT - This report will display requestor, par no, PO #, accept qty, receiver #                                                                                                                                                                                                        

    For the Material Receipt Traveler report, highlight that report.

    Depress the OK button and the following report will be displayed. 
     
    Note:  This report will now display ALL receipt records that have been created and not yet printed on this report.  Records will only display once, as soon as you run this report the field IS_PRINTED will be flagged within the tables and the records will no longer display on this report again.
     
     

    MATERIAL RECEIPT HISTORY FOR ONE PART REPORT - This report will display PO#, Supplier, requestor, date,  recd qty, rej qty      

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

    Depress the OK button

    Enter the part number and revison (if applicable) within the Single Quotes.

    Enter the desired date range.  
     
    Select 'Yes' or 'No' to Suppress leading "0" when printing serial numbers.

    Depress the OK button.

     

    The following is printed:


    MATERIAL RECEIPT HISTORY REPORT FOR ALL PARTS - This report will display PO#, supplier, requestor, date, recd qty, location, mfg pn                                                                                                                                                                                             

    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.

    Depress the OK button.

     
    The following screen will be displayed.

    Enter the desired date range. 
     
    Select 'Yes' or 'No' to Suppress leading "0" when printing serial numbers.

    Depress the OK button.
     
     
    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
    .
     
    If a Serial Number has been rejected "Rejected" will be displayed on the report to the right of the serial number.  If a Lot Coded part has a reject qty it will display the Lot Code information on the receipt that had the items rejected. 
     

    The following is printed:


     
    PURCHASE ORDER RECEIPT INSPECTION WORKSHEET - Purchase Order Receipt Inspection Work Sheet  for the items had been received in PO DOCK module    
    PURCHASE ORDER RECEIPT INSPECTION WORKSHEET with REQUESTER - Purchase Order Receipt Inspection Work Sheet  for the items had been received in PO DOCK module with Requester Information 

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

    Depress the OK button.

    Select a Purchase Order from the list by highlighting it then 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 -  This report displays the Item #, type, date, qty rec'd,. price, total $   

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

    Depress the OK button.
     
    Enter a Purchase Order number.
    Enter a Date Range.
     
    Enter 'Yes' or 'No' to Suppress leading "0" when printing serial numbers.
     
    Depress the OK button.
     
    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.
     
    If a Serial Number has been rejected "Rejected" will be displayed on the report to the right of the serial number. If a Lot Coded part has a reject qty it will display the Lot Code information on the receipt that had the items rejected.
     
     
     

    The following will print:

    1.3.2.6. FAQs - Purchase & Receiving Mgmt
    Facts and Questions for the PO Receiving & DMR Module
    1.3.3. PO DMR
    1.3.3.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.3.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.3.3. Fields & Definitions for PO DMR
    1.3.3.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.3.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.3.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.3.4. How To ..... for PO DMR
    1.3.3.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.
     

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

    The following screen will be displayed, enter Inventory Management / Purchase Order Receiving & DMR (discrepant material return) / PO DMR (discrepant material return).

     
    The following screen will be displayed:
     
     
    Depress the  Add button and user will be prompt for a password.

    The following screen will be displayed:


     
    Select the "From Inventory" radio and the following screen will be displayed. 

       
       
    Enter 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)     



    Highlight the Purchase Order of Choice, Depress the 
    OK button. Information regarding that part number for the Purchase Order selected will display:
     
    Enter in the returned qty in the "Return Qty" field, enter in the RMA number in the "RMA # field" and enter in your name, initials, etc in the "Confirm By" field.


     
     
    Depress the Packing List tab, and enter in a DMR Packing List number (if set to manual) for the return, and a Waybill number if applicable.
      
     


    Depress the Save button.  The following screen will be displayed:
     

     
     
    Once the DMR (discrepant material return) has been added and saved, a Debit Memo will be created, if an AP invoice exists (in order for a AP Invoice to exist you have to have reconciled the PO and transferred it to AP).   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 a PO DMR is created for parts "From Inventory" and the PO has NOT been reconciled and Transferred to AP the qty rejected will be put back on the PO. 
     
     
    The following message will be displayed and the system will NOT be able to create a DMR from Inventory for a part that has been changed from being a Lot-Coded part to a Non-Lot Coded part or visa-versa after PO Receipt has been created.  
     
     
     
    User should change lot code tracking status with caution.  If a part has lot code history and the lot code tracking is de-activated the entire lot code history is wiped out.

    1.         

     
    If accounting HAS reconciled the PO but HAS NOT transferred the reconciled invoice into AP Aging, the following message will appear:
     
     
    If the invoice happens to be in a Saved Check batch the following warning will be displayed:
     
     

     

    1.3.3.4.2. Add a DMR from a PO Inspection/Acceptance Receiving Rejection

     

    Enter the SQLMANEX.EXE (within the ManEx root directory)
    This action will then prompt the user for a password
    The following screen will be displayed, enter Inventory Management / Purchase Order Receiving & DMR (discrepant material return) / PO DMR (discrepant material return).


    The following screen will be displayed:


    Depress the Add button and user will be prompt for a password, enter their password and the following screen will be displayed:
     
     
    The defaults for this screen are "From PO Receiving" and "Purchase Order #" 
     
    If you chose the default (Purchase Order #), you will need to enter in the number of the PO on which the material was rejected.  If you chose Supplier, you must then enter in the name of the Supplier.
     
     
    Enter in the number of the PO which the material was rejected and the PO and related information will populate on screen.
     
     
     
     
    Highlight the PO and depress the OK button. 
    Note:  Ther are additional fields displayed on screen if there are Serial Numbers and Lot Codes involved. 
     
     
     
     
    Enter in the DMR number (if set-up for manual numbering) you are assigning to this return.  Enter in the RMA number as provided by the supplier. Then enter your name in the Confirm By space.
     
    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).
     
     
    Depress the Packing List Tab, enter in a Packing List number you wish to assign to the return (if set to manually numbering).  (Note that this number is NOT tied to regular shipping Packing Lists.  This field 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#).  Enter in the Waybill.
     
     
    Depress the Save button. The View DMR screen will appear:  

     

    1.3.3.4.3. Find an Existing Discrepant Material Record (DMR)

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

    The following screen will be displayed, enter Inventory Mgt / Purchase Order Receiving & DMR (discrepant material return) / PO DMR (discrepant material return).

     

    The following screen will be displayed:

     
     
    Depress the Find icon, the following screen will be displayed.  User can select to find an existing DMR by entering the DMR Number or entering the Receiver Number in the Rd box and depressing the OK button:
     
     
    If the system cannot find any information about the DMR # entered the following message will be displayed giving the user the option to select from a list of existing DMR's:
     
     
    If User Selects "YES" the following screen will be displayed listing all of the existing DMR's
     
     
    Enter the DMR# in the Red box or double click on the DMR# and the following information will be displayed:
     
     
     
    1.3.3.5. Reports - PO DMR

    To obtain the DMR (Discrepant Material Return) Packing List Report within the Web, select the WEB Print button from the ManEx action buttons at the top of the screen. For further detail on How the Reports work within the Web refer to Article #5477.

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

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


     

    To obtain the DMR Reports within the desktop, select the Print button from the ManEx action buttons at the top of the screen.





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

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

    Depress the OK  button
     

    The following screen will be displayed:

    Enter the DMR Number you wish to view.

    Depress the OK button.

     

     

    The following will print:

    1.3.3.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 User ID of person who made last change to this Work Order/Kit
    Kit Status

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

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

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

    Component Section

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

    DIRECTIVE BUTTONS

    The following buttons are displayed on the Kitting Main screen

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

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




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

         
     
     
     
    1.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 the SQLMANEX.EXE (within the ManEx root directory)
    This action will then prompt the user for a password

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

     

    The following screen will be displayed:

     

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

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

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

     

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


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

    .

     

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

     

     

    1.4.1.4.2. Issue Parts to Kit

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

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




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

    Press the Edit action button. This selection will appear:

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


    MANUAL KIT

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





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

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

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

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

     

     

    This screen is divided into four operational sections.

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

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

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



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

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

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

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

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

    REAL TIME KITTING FEATURE

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

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

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

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

    ENTER SERIAL NUMBERS

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

     


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

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

    The completed Main tab screen appears as below:

     

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

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




     

    AUTO KIT

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

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

     

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

    Kitting Preference Hierarchy

    When Kitting

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

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

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


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

    1.4.1.4.3. Add a Line Item Shortage

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

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

    The following screen will be displayed:



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



    Pressing the Add Button displays the following selection choices:
     
     




     
     

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

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

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

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

     

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

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

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

     

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



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

    Add a Miscellaneous Shortage

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

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

     

    Issue or Edit a Line Item Shortage

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

     

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

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

    Depress the Save button when changes are completed.

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

     

    Add a Line Shortage to a Rework Work Order

    Overview of a Rework Order

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

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

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

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

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

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

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

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

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



     

    The following message will appear:  Depress the OK button. 

     

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

     

     

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

    Depress the Update Kit button. Type in your password.

    You will receive a confirmation message.

     

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

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

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

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

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

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

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

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

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

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

     

    1.4.1.4.5. De-Kit

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

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


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

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



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


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



    .
    1.4.1.4.6. Return Over-Issue

    There are two methods of returning an over issue:

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

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


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

     

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

     

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

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

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

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

      

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



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

    1.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, it defaults all items to have the over-issue qty returned to stock.  If the user choose to return all inventory to stock they just have to click the "OK" button.   If they choose to assign all the over-issued qty to the Work Order (kit) they can do so by depressing the "Issue All to Kit" button, and the pick qty will increase to include the overissued qty.  So, if the users decide to re-open the kit, they have the option to return the material back to inventory if they choose.

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

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

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

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

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


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

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

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

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

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

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

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

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

    It is good practice to have someone in accounting and/or inventory review the Kit to Close report and clear them out. 
     
    1.4.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 within the Web, select the WEB Print button from the ManEx action buttons at the top of the screen. For further detail on How the Reports work within the Web refer to Article #5477.

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


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



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



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

    Highlight the desired report and then depress the OK button  

     
     

    Kit Material Availability W/AVL Detail report

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

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

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

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


    Depress the OK button.

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


    Kit Pick List Work Sheet report
     

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

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


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



    and the options will be displayed.

    Depress the OK button.

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

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



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



     

    The following report will be displayed:



    Part Labels 

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

    Depress the OK button. 


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

    The labels printed will appear like this:

    Box Labels (Not Completed in SQL)

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

     

    The following screen will appear:

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

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

    Type in the qty of labels required and depress OK.

     

     

     The labels printed will appear like this  

    Kit Traveler by WC report (Not Completed in SQL)

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

     

    The following report will be displayed:

     



    Over Issued Material report

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

    Depress the OK button.

     

    The following report will be displayed:

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

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

    The following report will be displayed:

     

    Customer Consigned Shortage Summary report (Not Completed in SQL)

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

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

     

    The following screen will appear:

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

    Depress the OK button. 

     

     

     

     

    The following report will be displayed:

     

    Purchased Part Shortage Summary report -

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

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

    Highlight By Part No. or By Work Order Due Date

     

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

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

     

     

    The following report will be displayed:

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

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

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

    ·        

     

    The following report will be displayed:

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

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

    Depress the OK button.

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

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

     

    The following report will be displayed:

     

    Kits to be Closed 

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

    Depress the OK button.

     

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


    The following report will be displayed:
     

     

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


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

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

    As Built Kit History form (Not Completed in SQL)

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

    Depress the OK button.

     

     

    The following report will be displayed:

     

    1.4.1.6. FAQs - Kitting & Shortage
    Facts and Questions for the Kitting & Shortage Module
    1.4.2. Inventory Allocation
    1.4.2.1. Prerequisites for Inventory Allocation
    Prerequisites Required for Entering a New Work Order Allocation:

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

    A Work Order must exist and  be released.

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


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


    The manufacturer allocated must be approved on the product BOM.


    1.4.2.2. Introduction for Inventory Allocation

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

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

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

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

    1.4.2.3. Fields & Definitions for Inventory Allocation
    1.4.2.3.1. Inventory Allocation Screen

     

     

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

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

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

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

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







     

    1.4.2.4. How To ..... for Inventory Allocation
    1.4.2.4.1. Find an Inventory Allocation

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

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

     

     

    The following screen will be displayed:


    Find an Inventory Allocation

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

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

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

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

    1.4.2.4.2. Add a New Inventory Allocation

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

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

     

    The following screen will be displayed:

    Depress the Add record action button and the following selection.

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

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



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





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

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

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

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



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

    Find a Record



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





    Depress the Save record action button. 



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

     

     

     

    1.4.2.4.4. Un-Allocate an Allocation

    Find a record




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



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




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


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

     

    1.5. Inventory Control Management
    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 #4766 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 sub assembly 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.  NOTE:  When creating a phantom part user will NOT be required to enter any physical parameters for it, because it is just a pointer to a group of parts that are used together on the BOM.  In kitting we explode the group as an individual item so this is also another reason why user is NOT required to enter any physical parameters when creating a phantom part.   

     

    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%, Lot-Coded, etc.)
     
    If the Part Type selected is Lot-Coded, the user will be required to enter a lot number, date code, expiration date (optional) and internal lot number information whenever performing a transaction for the part. If the user wishes to maintain inventory to this level, then they MUST enter information each time a part is moved. This will allow complete traceability by date and lot code for products assembled. The user will be able to determine all work orders or sales orders in which a certain date code was used.  Users should use caution when changing the lot code tracking status.  When lot code tracking status is change the entire history of the lot code is removed from system.    


    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

    Manex uses the Part Class and Type as an extension to the description of the part.  Therefore Class and type will be displayed throughout the system on screen and in reports as an extension of the description.

    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 User ID 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 User ID 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

    Mgmnt Lock/Blocked by Mgmnt

    Users MUST have special access in order to modify this checkbox, this access is assigned through Security/User Rights. 

    If locked caption will change to "Blocked by Mgmnt" and ALL users will have access to the screen, but only those with complete access to inventory can make changes to the item master.  Other users will NOT be able to edit the record until the Approved users remove the lock.  Fields changed when adding a PO, such as purchase lead time and min/mult orders are back written to the item master.  The item master notes are only back written to the item master if the user has edit rights to inventory.  The internal and consigned parts have seperate controls.
     
    Note:  If locked the caption will be displayed as "Blocked to Mgmnt", if unlocked the caption will be displayed as "Mgmnt Lock".
    Lock Date This displays the date and time the Approved user implemented the Mgmt lock.
    By

    This is the users ID 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 bring up a screen listing Clause (s) from the Clause Setup module.  User may select the desired clause (s) they would like added at the Inventory Part level.  When this part is added to a PO any Clause(s) assigned will be defaulted into the PO Item Clauses. This button will be displayed in RED when clauses have been added.  By design this button is ONLY editable in the view mode (See Article #3432 for further detail).   If user trys to use this button in the add or edit mode the system will display one of the following warnings.
     

     
    .    
      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 this part cannot be cancelled or returned.  NOTE: This field is for reference only.    

    Taxable Checking this box, will then default the Make Part as taxable when added to new Sales Order and/or Buy parts will default as taxable when added to a purchase order. 
    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 the Value of Labor will then be rolled into the Std Cost for the Make Part
    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.

    Note:  for Labor Cost, Overhead Cost, Other Cost and User Defined . . . BUY Parts: Transactions will hit the GL for this value upon reconciling the Receipt for AP  MAKE Parts:  The user may include these extra Costs with building the assembly the Value of extra cost fields will then be rolled into the Std Cost for the Make Part, but there will be no break outs of these as far as GL Transactions are concerned (all Transactions will be for the Std Cost Value). 
    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. Please note Standard cost is based on Stock UOM.

    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. 

    If the Part Source is a BUY,  the weighted cost is calculated by dividing the extended total cost(s) by the total qty(s) from the total number of non-cancelled PO line items setup in the General Inventory Setup module or the total number of non-cancelled PO line items entered in theWeighted Cost -  Last ( ) field). The Purchase Orders used are with a status of Open or Closed only, and goes by Order Date or Edit Date. You can choose what option it uses on the Inventory screen. You can also select the default use (Order Date or Edit Date) under General Inventory Setup 

    Order Date: Order date on Purchase Order

    Edit Date: Also known as 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).   

       
     
     
    NOTE:  The User has the option of changing the number of (Weighted Cost - Last ( )) purchase orders within the Inventory screen.  Changing this number  within the Inventory screen will change the Weighted Cost and also change the number of Purchase Orders displayed in the view screen.   User cannot filter out non-received parts.  Depress the (down arrow) to display the view screen.  This screen allows user to Sort, Search and Drill Down to Selected Records.
     
     
     
     
    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.  
    Purchase History By:
    This field allows the users to select which date "Order Date" or "Edit Date"  on the PO to use when displaying the PO's in the Purchase History. The default is setup within the General Inventory Setup module. 

    NOTE:  User has the option of changing the selection within this screen for a one time view and will reset back to the default once user exits the ICM module.        
    Include PO with Status:
    This field allows the user to select the status of the Purchase Orders they would like to have displayed in the Purchase History. "Open and Closed (Approved)" or "New and Editing (Waiting for Appr.)" or "All".  The default is setup within the General Inventory Setup module.  PO;s with a status of Cancelled will only display when "All" is selected. 

    NOTE:  User has the option of changing the selection within this screen for a one time view and will reset back to the default once user exits the ICM module.  
    Show Last __ Purchase Order(s)
    This field allows the users to setup the number of Purchase Orders they would like displayed in the Purchase History.  The default is setup within the General Inventory Setup module.
     
    NOTE:  User has the option of changing the selection within this screen for a one time view and will reset back to the default once user exits the ICM module.  
    Once all the selections have been made, depress the "Purchase History" button and the following view screen will be displayed.  This screen allows user to Sort, Search and Drill Down to Selected Records.
     

    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.   This screen allows user to Sort, Search and Drill Down to Selected Records.

    Where Part Used field Definitions

    Product Number Is the number assigned to the assembly for which the internal Part Number is a component
    Revision Is the revision number of the assembly
    Description Is the description of the assembly
    Item Is the item number on the Bom
    Quantity Pertains to the amount of the component used for 1 unit of the completed assembly
    Bom Status Is status of the Bom (Active, Inactive,etc.)
    Item Status Is status of the assembly (Active, Inactive, etc.)
    Effective Date Pertain to any effective dates regarding the assembly
    Termination Date Pertain to any obsolete dates regarding the assembly
    BOM Parent 

     

    Clicking on this button will display Inventory Allocations and Shortages for this item by Work Order number, as displayed:   This screen allows user to Sort, and Search for Selected Records.



    Part Shortage and Allocation Field definitions

    Work Order Is the number assigned to the Work Order for which the component part is short
    Project Number Is the number assigned to a work order for a special project
    Dept Name Is the name of the Work Center where the Part Number is short
    Manufacturer Is the name of the manufacturer of this part.
    Warehouse 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 Allocated Displays the quantity allocated to a specific Work Order or Project
    Shortage Qty 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)   This screen allows user to Sort, Search and Drill Down to Selected Records.



    On Order Field definitions

    Schedule Date Represents the calendar date of the Purchase Order
    Request Date
    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
    Manufacturer Is the name of the Manufacturer specified in the Purchase Order
    Mfgr Part Number Is the Manufacturer Part Number on order. 
    Cost Each Is the amount of money to be paid for one unit in the Purchase Order line item
    Balance 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.   This screen allows user to Sort, and Search for Selected Records.

     
     
    Serial Number Field definitions
     
    Serial Number Is the number assigned to that part
    Manufacturer Is the name of the mfg. specified
    Manufacturers Part Number Is the mfg. part number on order
    Warehouse Is the name of the warehouse the parts are being stored in
    Location Displays where the parts can be found
    Lotcode Lot Code number if part is lot coded
    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.
    Reserved

     

      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.    This screen allows user to Sort, and Search for Selected Records

    Lot Detail Field Definitions

    LotCode Is the number of the Lot/Date Code
    ExpDate

    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 identify the Lot
    PO Number Is the internal number assigned when order is placed
    Lot Qty Displays the qty available in Inventory
    Reserved Qty Displays the quantity allocated to a specific Work Order or Project

    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 #4010  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.  Note:  This button is disabled when in Add or Edit mode.

    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, 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 #4010  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 per requirement or if you select Daily then it 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 demands. See 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.  

    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.    

     

    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 Associate a customer and customer part number with the displayed internal part. 
    Delete

    Delete customer/customer part number/revision combination and the link with the displayed internal part. 

    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 to the same internal part number, we would NOT be able to process MRP AVL selection, nor reports that currently show customer part numbers.  For further detail see Article #2489.
     
    ManEx does allow users to link same customer same customer part numbers/revisions to different internal 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 want this Supplier to be the default when Auto Creating PO within MRP or for reports. 

    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 selected in the Quantity Info screen. User may enter the Marking, Body and Pitch, and may select the Package configuration from the pull down.  The Package Configuration selections are defaulted in from the Package Configuration module. Package configuration setup is provided so that the user may define a machine’s Units Per Hour.  This definition can then be accessed in the Production Work Centers & Activities setup/Activities Setup & Run tab.

    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

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

    The following screen will be displayed, select Inventory Management/Inventory Control Managment/Inventory Control Management. 

     

     

     

     

    The following screen will be displayed:
     

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

    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 Active 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 characters to 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 Contract be entered in order to select a Supplier. (Please refer to Manex / Material Planning / Purchase Setup / Supplier Contract Management and the Supplier Management manual).
    • 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 "Little Electronics" 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.
     
     

    If user selects to find  "Internal Inventory" "All Records" they will get the following message "You must enter a search criteria in addition to "All Records" selected in the "Record Status" radio button.   This is because the inventory file may be very large so the user is encouraged to narrow down their selection.  If they want all they will need to narrow it down by another criteria, or the system will take way too long to to bring the screen up and put a burden on the network and the SQL server.


     

    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

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

    The following screen will be displayed, enter Inventory Management

     
    The following Screen will be displayed:
     
     

     

      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 be displayed: 

     



    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

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

    The following screen will be displayed, select Inventory Management/Inventory Control Management/Inventory Control Management


    The following screen will be displayed:
     




    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, Lot-Coded, etc.)
     
    See Article #214 for further detail.
     
    If the Part Type selected is Lot-Coded, the user will be required to enter a lot number, date code, expiration date (optional) and internal lot number information whenever performing a transaction for the part. If the user wishes to maintain inventory to this level, then they MUST enter information each time a part is moved. This will allow complete traceability by date and lot code for products assembled. The user will be able to determine all work orders or sales orders in which a certain date code was used. Users should use caution when changing the lot code tracking status. When lot code tracking status is change the entire history of the lot code is removed from system.

    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.

    Material TypeIf 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. 
     

    Serialized:  Check this box if the new part being entered is a serialized part.

     

    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.  The user has the option to have the Make and Phantom Parts auto number within the System Setup/Material/General Inventory Setup

    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. 
     
    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. 
     
     
     
    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:  If locked, all users can access the screen, but will not be able to edit the record until Approved users remove the lock.

    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. 

    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 this part cannot be cancelled or returned.  NOTE: This field is for reference only.

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

    Target Price  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 weighted cost is calculated by dividing the extended total cost from number of purchase orders (setup in the General Inventory Setup module) by the total qty. 
     
    NOTE:  The User has the option of changing the number of (Weighted Cost - Last ( )) purchase orders within the Inventory screen, but, changing this number  within the Inventory screen will NOT change the Weighted Cost it will only change the number of Purchase Orders displayed in the view screen. 
    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
    Purchase History By: This field allows the users to select which date "Order Date" or "Edit Date"  on the PO to use when displaying the PO's in the Purchase History. The default is setup within the General Inventory Setup module. 
    Include PO with Status: This field allows the user to select the status of the Purchase Orders they would like to have displayed in the Purchase History. "Open and Closed (Approved)" or "New and Editing (Waiting for Appr.)" or "All".  The default is setup within the General Inventory Setup module.  PO;s with a status of Cancelled will NOT be displayed
    Show Last __ Purchase Order(s)

    This field allows the users to setup the number of Purchase Orders they would like displayed in the Purchase History.  The default is setup within the General Inventory Setup module.

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

      User would check these boxes if there is a situation where the Users customers will allow them to use up non-conforming inventory (might be leaded), but cannot replace the same AVLs.  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 except by special circumstances where the user can override the block from kitting if their customer permits it.  So at the AVL level, we have added these two logic fields that would signify that the AVL is NOT to be purchased and/or kitted. If the disallow kitting checkbox is checked, the disallow purchasing checkbox will be checked as well.   For more information on how this affects MRP see Article #2329.

    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 (To Create an In-Store Warehouse refer to Article #5583)  

    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.  Enter the Marking, Body, and/or Pitch, or select the Packaging Configuration (from the pull down), 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:   NOTE:  Package configuration setup is provided so that the user may define a machine's Units per Hour.  This definition can then be accessed in the Production Work Centers & Activities setup/Activities Setup & Run tab.




    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. Create an In-Store Warehouse
    Find or Add an Inventory Record.



    Go to the Quantity Info Tab, select the Edit button, then enter your password

     

    Highlight a Mfgr then depress the Add button (under the warehouse section as displayed below) 



    Select In-Store and Select a Supplier from the Pull Down 



    Select an In-Store Warehouse and Enter a location (if applicable) 



    Select the Save button to Save or Select the Cancel button to abandon changes.






    1.5.1.4.5. 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 along with the "Select Copy Options" at the top of the screen.
     
     

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

     

    Selecting Edit Part # Rev. 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 Increment Rev, 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.
     
    Users should use caution when changing the lot code tracking status. When lot code tracking status is change the entire history of the lot code for this specific part is removed from system.
     
    We do 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.
     
    User can select how they would like to view the Purchase History either by Order Date or Edit Date, also which PO's to include by status and the number of Purchase Orders viewed on screen.   NOTE:  These changes will NOT change the Standard Cost.  These changes will only affect how the PO's will be viewed on screen when the Purchase History button is selected.

    Changing a non-serialize 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 or a Make/Phantom Part - 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:

     



     
    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 4002 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 theMaterial 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.   

      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.     


     
    Highlight the Consigned part number (s) you want to add AVL to.  Select the radio button for the Warehouse you want to add to the AVL.  Select the Part Mfgr  from the pull down you want added to the consigned part number (s) highlighted.  As shown in the screen above.
     

    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.6. Delete an Inventory Control Record
    Find an Inventory Record
     
     
    Depress the Delete button and the following message will appear:
     
     
    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 part has qty on hand the following message will appear and user will NOT be allowed to delete the inventory part:
    If Part is associated with consigned part(s) the following message will appear and user will NOT be allowed to delete inventory part:
    If part is used on a BOM the following message will appear and user will NOT be allowed to delete the inventory part:
    If 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 part has open PO(s)  the following message will appear and user will NOT be allowed to delete the inventory part:
    If part has NOT been reconciled the following message will appear and user will NOT be allowed to delete the inventory part:
    If part has NOT been Posted to GL the following message will appear and user will NOT be allowed to delete the inventory part:
    After receiving any of the above warnings the user then will receive this warning
     
     
     
    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.7. 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 "Double Click to Open/Run Selected file" and the following screen will appear:  (User may load almost any type of document "PDF File" and/or an "Exec File", (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 "Inventory Item 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.4.8. Link User Defined Fields to an Inventory Record
    The User Defined fields MUST be setup within Web ManEx.  For further detail see Article #5454.

    The User Defined Fields can then be linked to Inventory records by selecting a record in the ManEx Desktop, and selecting the UD action button (as displayed below).




    The UDF for that section will then be displayed, and user can make changes (if applicable), Save & Exit or Cancel. 





    1.5.1.5. Reports - ICM Mgmt
    1.5.1.5.1. Inventory Control Reports
     
    To obtain the Inventory Reports within the Web, select the WEB Print button from the ManEx action buttons at the top of the screenFor further detail on How the Reports work within the Web refer to Article #5477.
     
    Note:  In order to access the Reports within the Web the Company Root URL must be setup within the System Appearance module and user must be linked to web within the System Security Module.
     
     

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



     

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


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

    Highlight the desired report and the Detail of the Report "Internal and/or In-store" or "Consign" and depress the OK button:
    Inventory Material Re-order List Report  - This report uses the "Re-order Point" to decide if the part needs to be re-ordered, NOT the "Re-order Qty"

    If user selects "Internal and/or In-Store" this Value screen will appear: 

     
     
    If user selects "Consign" this Value screen will appear:
    The Following is printed:   This report displays all inventory on hand that has less quantities available than the minimum Reorder Point prescribed for that part.

    Inventory On Hand Report

    User must first select Type:  'Internal', 'Internal & In-Store', 'In-Store', or 'Consigned'

    User then may enter Customer (only if consigned type is selected), Class, Warehouse, Part Range Start, Part Range End.  Entry must be within Single Quotes.  Leave '*' defaulted and all will be displayed.

    Select to suppress 0.00 records, then select 
    to sort by, either Part Number or Warehouse. 

    Once all Values have been entered 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
      

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

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

    Depress the OK button will bring up the Values screen:

     

    Enter Starting Date Range, and Ending Date Range.

    If desired enter Starting PN and Ending PN.  If left blank all PN will be displayed on report.

    Select Type:  'Internal', 'Internal & In-Store', 'In-Store', or 'Consigned'

    Enter Customer only if type 'Consigned' was selected

    If desired select Part Class.  If left blank all Part Classes will be displayed on report.

    Select 'Yes' or 'No' to show Serial numbers on report, (Note:  Leading Zero's will NOT be displayed on report), and if you want the reason to be displayed or not.
     
    Once all the Values have beeen selected, depress the OK button.
     


    Note:
    The reference field as entered in the Inventory Handling module will display on the Transaction Detail report.
     
    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. 
     
     

    Part Transaction Log With Balance Report

    Select Type: 'Internal', 'Internal & In-Store', 'In-Store', or 'Consigned'

    If desired enter Part Number and Revision if applicable.  If these fields are left blank all part numbers and revisions will be displayed on report.

    Enter a Start Date (this field is required)

    Enter Customer only if type 'Consigned' was selected

    Once all the Values have beeen selected, 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:
    09/01/2011      receiving  230
    10/12/2011      issue        15
    10/28/2011      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

    Enter Part Class (if applicable)

    Enter Warehouse (if applicable)

    Enter Starting Part Number (if applicable)

    Entering Ending Part Number (if applicable)

    Select how you wish to have the report costed by: Standard Cost, Weighted Cost, or User Defined Cost.

    Note:  The reason the report was not calculating value when using weighted cost is because in General  Inventory Setup (within system setup) I had zero in the "Number of Purchase Orders used in the calculation of the weighted costs" field.  For this report to work user must have a number greater than zero within this field.

     
    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 <st1:place w:st="on">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 <st1:place w:st="on">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). 

     

    For further details on Possible Reasons why the Inventory Valuation Report is not matching the GL Balance for the Inventory GL Acct # see Article 5712.

     
    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
     

    Enter Part Class within Single Quotes (if applicable)

    Enter Starting Part Number within Single Quotes (if applicable)

    Enter Ending Part Number within Single Quotes (if applicable)

    Select How you wish to have the report Costed by:  Standard Cost, Weighted Cost, or User Defined Cost.
     
    Select to Round WIP Qty to Interger or Not


    Depress the OK button.
     
    The following is printed:




    **Inventory and WIP Valuation report is not intended to be used as a validation to the GL WIP Balance

    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 #5712  "Why doesn't the Inventory Valuation Report Match the GL Balance for the Inventory GL Account Number?".

    Inventory WIP Valuation Report by Work Order

    Enter Work Order Number within the Single Quotes (if applicable)

    Enter Part Class within the Single Quotes (if applicable)

    Enter a Starting Part Number within the Single Quotes (if applicable)

    Enter a Ending Part Number within the Singel Quotes (if applicable)

    Select How you wish to have the report Costed by:  Standard Cost, Weighted Cost, or User Defined Cost

    Select if you wnat to Round WIP qty to Interger or not


    Depress the OK button.
     
    The following is printed:  Every new WO will start on the new page.
     
     
    Inventory List With No Assigned BOM Report  
       

    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

     
    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

    User must first select Type: 'Internal', 'Internal & In-Store', 'In-Store', or 'Consigned'

    User then may enter Customer (only if consigned type is selected), Part Class, Starting Part Number, and/or Ending Part Number.  Entry must be within Single Quotes. Leave '*' defaulted and all will be displayed.

    User MUST enter a Date

    Select to suppress 0.00 records, then select
    to sort by, either Part Number or Warehouse.

    Once all Values have been entered 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.

     

    User MUST first select Part Source:  'BUY', 'CONSG', 'MAKE', or 'PHANTOM'

    Then select sort Order:  Manufacturer Part Number or Manufacturer 

    Once the values have been selected 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

    Enter the Manufacturer desired within the single quotes, if all Mfgr's are desired leave '*' defaulted.  Partial entry is allowed. 

    Once the values have been selected, depress the OK button to print report

     

    The following is printed:  This report displays all part numbers by Manufacturer, Manufacturer Part Number, Class, Type, Description, Internal Part Number, Matl Type and Qty on Hand. 

     

    Physical Inventory Work Sheets Report

    Select Inventory Type: 'Internal',  'Internal & In-Store',  'In-Store'  or 'Consigned'  

    Select the Desired Part Source: 'All',  'Buy',  or 'Make' 
     
    Enter Customer:  (this field only applies if Consigned is selected) 
     
    Enter Part number Start Range within the single quotes.  If left blank it will check all records
     
    Enter Part number End Range within the single quotes.  If left blank it will check all records
     
    Enter specific Warehouse within the single quotes (if desired)
     
    Select to sort by:  Warehouse/Location or Part Number/Rev 
     
    Select to display With Book Quantity or Without Book Quantity 
     
    Once all the values have been selected, depress the OK button to print report. 

     

    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 'Consigned'
     
    Enter Part number Start Range within the single quotes 
     
    Enter Starting Rev Range within the single quotes
     
    Enter Part number End Range within the single quotes 
     
    Emter Ending Rev Range within the single quotes
     
    Enter Customer within the single quotes: (this field only applies if Consigned is selected)
     
    Enter specific Warehouse within the single quotes (if desired)
     
    Enter Specific Location within the Single Quotes.  If you do not wish to filter on Location leave '*' as default
     
    Enter Specific Whse within the Single Quotes. If you do not wish to filter on warehouse leave '*' as default
     
    Once all the values have been selected, depress the OK button to print labels





    . 

     
     

    The following is printed.

     
    Allocated Report for Closed and Cancelled WO - This report displays a listing of Part Classes & Types
     

     

     

    Material Type Change Report 

    Enter the From Date in format "yyy-mm-dd"  (the To Date is todays)

    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   

    Enter the From Date in format "yyyy-mm-dd" (the To Date is todays).

    Depress the OK button.

    <st1:place w:st="on"><st1:placetype w:st="on">
     
    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.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, or Consigned
    Part Number The internally assigned number of the part.
    (Rev) The revision assigned to the part.
    Customer's Part Number The customers number of the part.  This field will only be displayed if the Part Source selected is (Consigned)
    (Rev) The customers revision assigned to the part. This field will only be displayed if the Part Source selected is (Consigned)
    Customer Name The Name of the Customer.  This field will only be displayed if the Part Source selected is (Consigned)
     

    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, or Consigned 

     Part Number

    The internally assigned number of the part.

     (Rev) The revision number assigned to the part.
    Customer's Part Number The customer's number of the part.  This field will only be displayed if the Part Source selected is (Consigned)
    (Rev) The customer's revision assigned to the part. This field will only be displayed if the Part Source selected is (Consigned)
    Customer Name The Name of the Customer.  This field will only be displayed if the Part Source selected is (Consigned)
     

    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.

    In-Store Supplier If an In-Store warehouse is selected the In-Store Supplier will be displayed within this field. 
    In-Store Return 2 Vendor Check this box 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). (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.
     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, or Consigned 

    Part Number

    The internally assigned number of the part.

    (Rev) The revision number assigned to the part.
    Customer's Part Number The customer's number of the part.  This field will only be displayed if the Part Source selected is (Consigned)
    (Rev) The customer's revision assigned to the part. This field will only be displayed if the Part Source selected is (Consigned)
    Customer The Name of the Customer.  This field will only be displayed if the Part Source selected is (Consigned)

    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.  (this field will only be displayed if the warehouse selected is an In-Store warehouse)

     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, or Consigned 

     Part Number

    The internally assigned number of the part.

     (Rev)

    The revision number assigned to the part.

    Customer's Part Number The customer's number of the part.  This field will only be displayed if the Part Source selected is (Consigned)
    (Rev) The customer's revision assigned to the part. This field will only be displayed if the Part Source selected is (Consigned)

    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.

    Customer The Name of the Customer.  This field will only be displayed if the Part Source selected is (Consigned)
     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

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

    The following screen will be displayed, select Inventory Management/Inventory Control Management/Inventory Handling 

     

    The main screen will be displayed:

    Inventory Handling is used for receipt of non-purchase order receipts.

    To add inventory, depress the Receiving tab.

    1. Depress the Add button.
    2. Enter your password.
    3. Select the Part Source from the pull down menu (BUY, MAKE, or CONSG).
    4. Enter a 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. Enter 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 select a dffferent warehouse from the pull down list.
    10. Select the reason for the receipt from the pull down list.
    11. Enter in a Reference (Optional).
    12. Depress the Save button.

    This message is a general message that is displayed in Inventory Handling if all locations/AVL's for a part are flagged in a Cycle Count or Physical Inventory and the part has ONLY one WHSE and AVL setup. 
     
    User must reconcile and post the cycle count or physical inventory for this part and then you will be able to process the records within Inventory Handling.  
     
     
     
     
    If the part has more than one WHSE and/or AVL setup and the part number is flagged in a Cycle Count or Physical Inventory the warning is NOT displayed,  but the warehouse drop down is not available for selection within the issuing, receiving, transferring, and MRB screens after you select the AVL.   As shown in the screen below.  
     
     
    If there are multiple revisions for the same part number a screen will appear for user to select the correct part number from:





    The completed screen will look like this for a Buy, or Make 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, then the user will be required to receive it back in through the RMA Process.   


    If user enters a SN that already exists for this PN they will recevie the following message:
     
     
    Depress OK, then delete or remove the SN(s) being displayed in Red by depressing the Delete button and the following confirmation message will be displayed  
     

    Depress Yes to continue, then user must re-enter new serial numbers and save changes.
     
     
    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 within 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.
     

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

    The following screen will be displayed, select Inventory Management/Inventory Control Management/Inventory Control Management

     
    The following screen will be displayed:
     
     
     

    Depress the Issue tab and the following screen will be displayed:




    To issue inventory items follow these steps.
    1. Depress the Add button.
    2. Enter your password.
    3. Select the Part Source from the pull down menu. (BUY, MAKE, or CONSG).
    4. Enter a 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. Enter the Issued quantity.
    7. Select the Issue Account Description from the pull down menu.
    8. Enter the 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 select a different warehouse from the pull down list.
    11. Enter the Reference if applicable.
    12. Depress the Save button.

    This message is a general message that is displayed in Inventory Handling if all locations/AVL's for a part are flagged in a Cycle Count or Physical Inventory and the part has one WHSE and AVL setup. 

    User must reconcile and post the cycle count or physical inventory for this part and then you will be able to process the records within Inventory Handling.  

     

    If the part has more than one WHSE and/or AVL setup and the part number is flagged in a Cycle Count or Physical Inventory the warning is NOT displayed,  but the warehouse drop down is not avaiable for selection within the issuing, receiving, transferring, and MRB screens after you select the AVL.   As shown in the screen below.  





    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:
     
    By highlighting and using the arrows. 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. 
     
     
    Below is how the screen will appear If issuing Lot Coded parts: 
     
     
     
     
     
    Depress the Save button to save changes, or the Abandon changes button the abandon changes.
     
     
     
    1.5.2.4.3. Transfer Tab
     

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

    The following screen will be displayed, select Inventory Management/Inventory Control Management/Inventory Handling

     
    The following screen will be displayed:
     
     
     
     
    Depress the Transfer tab and the following screen will be displayed:
     

    To transfer inventory from one warehouse to another follow these steps.

    1. Depress the Add button.
    2. Enter your password.
    3. Select the Part Source from the pull down menu. (BUY, MAKE, or CONSG)
    4. Enter 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. Enter quantity to transfer.
    10. Select the reason from the pull down list.
    11. Enter the reference if applicable
    12. Depress the Save button. 

     

    For this feature to work properly, the Inventory Part Number MUST have two warehouse locations assigned to it within the ICM module.  The  "From"   Location MUST have quantity on hand..   If user attempts to transfer parts that do NOT have two warehouse locations, or from regular inventory location to MRB, the following message will be displayed.   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.    (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). To move parts from stock to MRB you will need to use the Inventory Handling MRB screen

     

    This message is a general message that is displayed in Inventory Handling if all locations/AVL's for a part are flagged in a Cycle Count or Physical Inventory and the part has ONLY one WHSE and AVL setup. 

    User must reconcile and post the cycle count or physical inventory for this part and then you will be able to process the records within Inventory Handling.   

     NOT displayed,  but the warehouse drop down is not avaiable for selection within the issuing, receiving, transferring, and MRB screens after you select the AVL.   As shown in the screen below. 

     

    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 rejected material found at time of PO receiving or in production is transferred through inventory handling into the WHSE so management has time to determine whether to return discrepant material to the Supplier. It is a non-netable account meaning qty's residing in this WHSE are not consider as available inventory for MRP demands or production needs.
     

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

    The following screen will be displayed, select Inventory Management/Inventory Control Management/Inventory Handling

     
    The following screen will be displayed:
     
     
     

    Depress the MRB tab.  The following screen will be displayed.

    To Transfer Inventory Items from Inventory to MRB follow these steps.

    1. Depress the Add button.
    2. Enter in your password.
    3. Select the Part Source from the pull down menu. (BUY, MAKE, or CONSG)
    4. Enter 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. Enter the Quantity to Transfer.
    10. Select the Reason for transfer from the pull down list:
    11. Enter in the Reference if applicable.
    12. Depress the Save button.

     

    This message is a general message that is displayed in Inventory Handling if all locations/AVL's for a part are flagged in a Cycle Count or Physical Inventory and the part has ONLY one WHSE and AVL setup. 

    User must reconcile and post the cycle count or physical inventory for this part and then you will be able to process the records within Inventory Handling.  

     

     

    If the part has more than one WHSE and/or AVL setup and the part number is flagged in a Cycle Count or Physical Inventory the warning is NOT displayed,  but the warehouse drop down is not avaiable for selection within the issuing, receiving, transferring, and MRB screens after you select the AVL.   As shown in the screen below.  




    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. 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 the SQLMANEX.EXE (within the ManEx root directory) 
    This action will then prompt the user for a password


    The following screen will be displayed, select Inventory Management/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. 


    This is a message to remind users that the contract number already exists for suppliers and creates an XL file, so user can check to be sure they didn't accidentally enter in the incorrect contract number.  Because the system does allow the same contract number to be used multiple times for same supplier for different parts,  but does NOT allow the same contract to be used multiple times for the same supplier and same part.    



    During the upload if the Contract Number/Part Number/Mfgr already exists in system, and user has it again in the template:

    1.  Find same qty and same price, only qty OH will be changed.
    2.  Find same qty but different price, the following message will be displayed, giving you the option to overwrite the existing price.  
    3.  If only less qty with same price is found, system will use the contract price break qty instead of creating a new qty break.
    4.  If only larger qty with same price is found, system will use the contract price break qty instead of creating a new qty break.
    5.  Otherwise the system will create a new price break with new price/qty.




     If price is omitted from xl spreadsheet system will use the material price from the Inventory Control screen. 

    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. Inventory Cycle Count
    1.5.4.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.4.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.4.3. Fields & Definitions for Inventory Cycle Count
    1.5.4.3.1. Main Screen

     

    Main Screen field definitions

    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
    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
    Warehouse The name of the warehouse for the part.  Depressing the Warehouse button will sort the grid by warehouse
    Source

    The source of the part number, Make or Buy.  Depressing the Source button will sort the grid by source.

    Part Class The classification of the part.   Depressing the Part Class button will sort the grid by part class.
    Part Type

    The part type within the classification of the part number.

    Description

    The description of the part number.

    UoM

    The unit of measure of the part number.

    Serial Number  If the part has been designated as requiring serial numbers, then the serial numbers must be entered in this screen.

     

    1.5.4.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.4.4. How To ..... for Inventory Cycle Count
    1.5.4.4.1. Generate Cycle Count List
     

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

    The following screen will be displayed, select Inventory Management/Inventory Control Management/Inventory Cycle Count

     
     
    The following screen will appear:   When the screen first opens, the user is limited to only six of the eight action buttons shown: Add button (Run a cycle count setup), Edit button (Enter cycle count results), Copy button (Reconcile cycle count data), Print reports, Help 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.
     
     
    A cycle count may NOT be added on a non-working calendar day, however, open cycle count records may be counted, entered and reconciled.  If trying to add a cycle count on a non-working calendar day this message will popup.
     
     
    Depress okay and no cycle count will be ran.
     
     
    Depress the "Run Cycle Count" button (Add button)
     
     
     
    Records for cycle count will be pulled forward.    Records that have allocations made within the system will be pulled forward for count, these records will be highlighted in RED (as displayed below).   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.4.4.2. Entering Cycle Count Data

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

    The following screen will be displayed, select Inventory Management/Inventory Control Management/Inventory Cycle Count

     

    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.
     
     
     
     
    Depress the Save changes action button to save changes, or depress the Abandon changes button to abandon changes.
     
    If the number of serial numbers entered does not match the count number entered for a part that is marked as Serialized, user will receive the following message.  
     
     
     
    Depress OK and these descrepancies must be fixed before the records can be saved.  

    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.4.4.3. Reconciling Cycle Counts and Post Inventory Adjustments

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

    The following screen will be displayed, select Inventory Management/Inventory Control Management/Inventory Cycle Count  

     

    The following screen will be displayed:

    Depressing the Copy action button (Reconcile Count Records) 



    Enter password.

    The system checks the counted quantities entered into the Cycle Count screen and verifies that the count matches the inventory records.  

    If the users attempt to edit the record that is allocated lower than the allocated qty it will display the following message and those records will be eliminated for reconciliation.  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.






    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.4.5. Reports - Inventory Cycle Count


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

     

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


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



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




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




     
    Cycle Count Worksheet Report

     

    Select between printing the Manufacturer and Manufacturer’s Part Number or Description. 

    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 ManEx System.

    Cycle Count Summary Report (NOT Complete in SQL)

    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 (NOT Complete in SQL)

    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 (NOT Complete in SQL)

    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.4.6. FAQ - Inventory Cycle Count
    1.5.4.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.

     

    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.4.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.5. Physical Inventory

    1.5.5.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.5.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.5.3. Fields & Definitions for Physical Inventory
    1.5.5.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.5.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.5.4. How To ..... for Physical Inventory
    1.5.5.4.1. Setup a Physical Inventory

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

    The following screen will be displayed, select Inventory Management/Inventory Control Management/Physical Inventory Module

     

    The following screen will be displayed:

    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 Store Inventory. 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 store 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.5.4.2. Finding a Physical Inventory

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

    The following screen will be displayed, select Inventory Management/Inventory Control Management/Physical Inventory Module

     

    The following screen will be displayed:

    Depress the Find action button. The following screen will be displayed:

    Decide upon the Inventory Type that you want to find.  Select from Internal Only, Consigned Only or Instores Only by clicking on the appropriate radio.

    Then choose the appropriate filter, either In Process, Completed, Cancelled or All by clicking on the appropriate radio.  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.5.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.5.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.5.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 journal entries for any variances will forward into the accounting module.

    Note that journal entries will not be created in the following circumstances:  Consigned stock or In Store additions.

    1.5.5.5. Physical Inventory - FAQ
    1.5.5.5.1. When Processing Physical Inventory is there one large GL Transaction or many individual ones?

    Q5:  Physical inventory:  What GL #’s will be used and will it hit as one huge Transaction or individual Transactions?

    A5:  Below you can see the Inventory Default Account Setup Screen.  And I have highlighted the GL account for Inventory Adjustments.


    Then I had the following parts in the system as follows:

                                        Before the Physical Inventory       Adjusted To via Physical Inventory         

    101-0001688            100 On Hand @ 0.67                      120

    101-0001689            200 @1.321                                      150

    101-0001690            0 @ 0.47                                            100

    101-0001691            0 @ 0.874                                          100

    101-0001692            0 @ 2.11                                            100

    Since the 1st, 3rd, 4th and 5th records were actually increasing the qty on hand they all were included into the Transaction # 2124 shown below.  So yes they are grouped into one larger transaction #, but they are displayed in sub categories within the Individual Transaction Inquiry reports as shown below for easier reference.

    Since the 2nd records was reducing qty out of stock it generated an inventory issue transaction # 2125 shown below.


    1.5.6. Standard Cost Adjustment
    1.5.6.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.6.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.6.3. Fields & Definitions
    1.5.6.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.6.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.6.4. How To ....
    1.5.6.4.1. Find a Standard Cost Adjustment

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

    The following screen will be displayed, select Inventory Management/Inventory Control Management/Standard Cost Adjustment Module

     

    The following screen will be displayed:

    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 be displayed:

    If you select to find by Buy Parts, the following screen will be displayed:

     

    1.5.6.4.2. Start New Roll Cost

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

    The following screen will be displayed, select Inventory Management/Inventory Control Management/Standard Cost Adjustment Module 

     

    The following screen will be displayed:

    Depress the Add action button (Start New Cost Roll) and the folloiwng items will become enabled:

    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" 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 be displayed:

    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.6.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 the SQLMANEX.EXE (within the ManEx root directory)
    This action will then prompt the user for a password

    The following screen will be displayed, select Inventory Management/Inventory Control Management/Standard Cost Adjustment 

     

    The following screen will be displayed:

    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 be displayed:  
     
     
    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 be displayed:


    Depress "Yes" to continue.  If a rollup already exists the following option screen will be displayed:

    Depress "Yes" to continue. The following message will be displayed:

    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 be displayed:

    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.6.5. Std Cost Adjustment Reports

    To obtain the Standard Cost Adjustment Report within the Web, select the WEB Print button from the ManEx action buttons at the top of the screen. For further detail on How the Reports work within the Web refer to Article #5477.
     
    Note: In order to access the Reports within the Web the Company Root URL must be setup within the System Appearance module and user must be linked to web within the System Security Module.
     

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


    To obtain the Standard Cost Adjustment report, select the Print button from the ManEx action buttons at the top of the screen.  




     

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

    Highlight the desired report and then depress the OK button. 

    Select the Cost Roll Type:  BUY or MAKE


    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.6.6. FAQs - Standard Cost Adjustment
    Facts and Questions for the Standard Cost Adjustment Module
    1.5.7. Part Manufacturer Setup

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

    The following screen will be displayed, select Inventory Management/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 be displayed:

    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.
     
    1.5.7.1. Why are the Part Mfgr Codes not numeric?
    Q:  Why the Customer Codes and Supplier Codes are numeric but the Manufacturer Codes are not?

    A:  the reason that we have the code user assigned, and not numbers, because through out the system we are using the code to display the manufacturer, rarely we show the actual name  (or description as we call it). If the user decided to upload the code as numbers, that is all they will see on all our screens and reports. For the changing the names of the manufacturer including the code, I believe, we have a utility. All the user has to do is to add new manufacturer and replace the old with the new , then they can remove the old.   This would be found under the <<SQLSYSUTILITY.EXE>>