1. Inventory Handling
1.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.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.3. Fields & Definitions for Inventory Handling
1.3.1. Receiving Tab

The main screen

Receiving tab field definitions

Part Source The source of the part, Buy, Make, Consigned or Phantom
Part Number The internally assigned number of the part.
(Rev) The revision number assigned to the part.
 

Depressing this button will reveal any notes about the part that have been entered in the item master.

Received Qty The quantity received. See Article #1240 for more detail on why the system will not allow user to enter in a fraction of a number, and an alternative.
UOM

The Unit of Measure for the part.

Receiving Account Description

The description (and its related General Ledger account) pertaining to the receipt.

Manufacturer The name of the manufacturer of the part.
Manufacturer’s Part Number

The number the Manufacturer has assigned to the part.

Warehouse The name of the Warehouse.
Location

The location within the warehouse where the part received will be placed.

This button will ONLY be displayed if the "Allow Auto Creating Location at Receiving" box is checked in the Mfgr/AVL  Quantity Info tab within the ICM module.
Part Class

The classification to which the part number belongs.

Part Type The type within the classification to which the part number belongs.
Description

The description of the part number.

Reason

The reason for the receipt.

Reference

The reference for the receipt.

1.3.2. Issue Tab



Issue tab field definitions

 Part Source

The source of the part, Buy, Make, Consigned or Phantom.

 Part Number

The internally assigned number of the part.

 (Rev) The revision number assigned to the part.
 

If this button is shown in RED, depressing this button will reveal any notes about the part that have been entered in the item master.

 Issued Qty

The quantity issued. See Article #1240 for more detail on why the system will not allow user to enter in a fraction of a number, and an alternative.

 UOM The Unit of Measure for the part.
 Issue Account Description

The description (and its related General Ledger account) pertaining to the issue.

 Issued To The name of the project, etc.
 Manufacturer

The name of the manufacturer of the part.

Manufacturer’s Part Number The number the Manufacturer has assigned to the part.
 Warehouse

The name of the Warehouse.

 Location The location within the warehouse where the part issued will be pulled from.
 Qty Available

The on hand quantity.

 Part Number

The internal number assigned to the part.

 Quantity

The quantity issued.

 Part Class

The classification to which the part number belongs.

 Part Type

The type within the classification to which the part number belongs.

 Description

The description of the part number.

 Reference

The user defined reference for this issue.

 

1.3.3. Transfer Tab

Transfer tab field definitions

Part Source

The source of the part, Buy, Make, Consigned or Phantom.

Part Number

The internally assigned number of the part.

(Rev) The revision number assigned to the part.

If this button is displayed in RED depressing this button will reveal any notes about the part that have been entered in the item master.

Part Class The classification to which the part number belongs.
Part Type The type within the classification to which the part number belongs.
Description The description of the part number.
Manufacturer The name of the manufacturer of the part.
Manufacturer’s Part Number

The number the Manufacturer has assigned to the part.

From Warehouse

The name of the Warehouse.

From Location The location within the warehouse where the part transferred will be pulled from.
 In-Store Supplier

The name of the In-Store supplier.

 To Warehouse

The name of the Warehouse.

 To Location The location within the warehouse where the part transferred will be placed.
 Qty Available

The on hand quantity.

 Quantity to Transfer

The quantity transferred.  See Article #1240 for more detail on why the system will not allow user to enter in a fraction of a number, and an alternative.

 UOM

The Unit of Measure for the part.

 Reason

The reason for the Transfer.

 Reference

The reference for the Transfer.

 

 

1.3.4. MRB Tab

MRB (Material Review Board) tab field definitions

 Part Source

The source of the part, Buy, Make, Consigned or Phantom.

 Part Number

The internally assigned number of the part.

 (Rev)

The revision number assigned to the part.

 Part Class

The classification to which the part number belongs.

 Part Type

The type within the classification to which the part number belongs.

 Description

The description of the part number.

 Manufacturer

The name of the manufacturer of the part.

Manufacturer’s Part Number

The number the Manufacturer has assigned to the part.

 Part Number The internal number assigned to the part.
 Quantity The quantity transferred.
 From Warehouse

The name of the Warehouse.

 From Location

The location within the warehouse where the part transferred will be pulled from.

 To Warehouse

The name of the Warehouse.

 To Location

The location within the warehouse where the part transferred will be placed.

 Qty Available The on hand quantity.
 Quantity to Transfer

The quantity transferred. See Article #1240 for more detail on why the system will not allow user to enter in a fraction of a number, and an alternative.

 UOM

The Unit of Measure for the part.

 Reason The reason for the Transfer.
 Reference

The reference pertaining to the Transfer.

 

1.4. How To ..... for Inventory Handling
1.4.1. Receiving Tab

Depress Inventory Mgmt/Inventory Control Management/Inventory Handling 

 

The main screen will appear

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

To add inventory, depress the Receiving tab.

  1. Depress the Add button.
  2. Type in your password.
  3. Select the Part Source from the pull down menu (BUY, MAKE, CONSG, or PHANTOM).
  4. Type in the Part Number, if Part Source is "CONSG" you will need to enter Customer Name from pull down, then you will have a choice to enter in customer PN or Internal PN.
  5. Part type, class, and description will default in.
  6. Type in the Received quantity.
  7. Select the Receiving Account Description from the pull down menu.
  8. Select the Manufacturer & manufacturer part number from the pull down list.
  9. The warehouse will default in. If the default is not the warehouse you want you may choose from the pull down list.
  10. Select the reason for the receipt from the pull down list.
  11. Type in the Reference.
  12. Depress the Save button.

This message is a general message user gets when the program can not find any warehouse/location for this part number. This message will appear if the part is locked in cycle count or physical inventory.  User must reconcile and post the physical inventory for this part and then you will be able to process the records within Inventory Handling.  
 

The completed screen will look like this for a Buy, Make or Phantom part.



The completed screen will look like this for a Consigned part.

The completed screen will look like this for a Serialized part.  Note:  Users are allowed to receive in once issued out SN(s) back into stock, if  the SN is for the same part number, and was issued out through inventory handling, then the system will re-link it to its old history.  If the SN has been shipped out of the system via a packing list, the following message will be displayed



and the user will be required to receive it back in through the RMA Process.   
 

The completed screen will look like this for a Lot Coded part.


 
If the "Allow Auto Creating Location at Receiving" box has been selected for a specific AVL in the ICM module the "New Location" button will appear on the Receiving screen as shown below.  
 
 
Depress the New Location button and the following screen will appear, giving the user the option to create a new Warehouse/Location for this part: 
 
 
Depress "Yes" and the following screen will appear, listing the Warehouse(s) that have the "Allow to Auto Create Location at Receiving" box selected in the Warehouse Setup module.  
 
 
If user selects InStore a Supplier selection will appear in the screen:
 
 
When all the information has been entered the New Warehouse/Location will appear in the Quantity Info screen with the ICM module.

1.4.2. Issue Tab

Issuing or Expensing Inventory Items with no Work Order

The following types of items would be covered in the Issue screen:

1.  Issuing to Cost of Goods Sold (Usually Non-taxable)

Such as: Tems with no Bills of Material; Prototypes and Pilot Products for Resale; Items not classified as “Used in Kit”

2. Expensing for In-House Consumption (Usually Taxable)

Such as: Items consumed in the production process but not shipped as a part of product for resale; Items used for calibration or testing of the production process; Items used for samples or prototypes which are not resold.

3.  Return In-store 2 Vendor

If the user has in-store items, which they want to return to the Vendor without any impact on accounting or PO (like obsolete parts) there is a check box available within the issue page  "Return In-store 2 Vendor". (This field will only be visible if the In-store warehouse is selected).  If check-marked no purchase order will be created and there will also be no impact on the Gl values. 
NOTE:   Any Return to Vendor will NOT be counted as inventory used in the EAU calculation.

To access this screen, depress the Issue tab and the following screen will appear:


To issue inventory items follow these steps.
  1. Depress the Add button.
  2. Type in your password.
  3. Select the Part Source from the pull down menu. (BUY, MAKE, CONSG, or PHANTOM).
  4. Type in the Part Number, if Part Source is "CONSG" you will need to enter Customer Name from pull down, then you will have a choice to enter in customer PN or Internal PN.
  5. Part type, class, and description will default in.
  6. Type in the Issued quantity.
  7. Select the Issue Account Description from the pull down menu.
  8. Type in Issued To.
  9. Select the Manufacturer & manufacturer part number from the pull down list.
  10. The warehouse will default in. If the default is not the warehouse you want you may choose from the pull down list.
  11. Type in the Reference.
  12. Depress the Save button.

This message is a general message user gets when the program can not find any warehouse/location for this part number. This message will appear if the part is locked in cycle count or physical inventory.  User must reconcile and post the physical inventory for this part and then you will be able to process the records within Inventory Handling.  

 

The completed screen will look like this.
 
 
 
 
If issuing parts with Serial Numbers once user has entered the Part number info, etc. 
 
 
Users have the option of selecting the Serial Numbers to be issued two different ways:
 
1.  By highlighting and using the arrows         or
 
2.  Depressing the Enter Serial Numbers button and the following screen will appear:
 
 
 
Select the proper radial "Single Entry" or "Range" and enter in the From and To SN's:
 
 
Depress the Save button and the SN's will transfer over into the Inventory Handling issue screen.  The number of Serial numbers selected will be displayed, as shown below:
 
 
Depress the Save button to save changes, or the Abandon changes button the abandon changes.
 
1.4.3. Transfer Tab
 
Depress the Transfer tab and the following Transfer screen will appear:
 

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

  1. Depress the Add button.
  2. Type in your password.
  3. Select the Part Source from the pull down menu. (BUY, MAKE, CONSG, or PHANTOM).
  4. Type in the Part Number, if Part Source is "CONSG" you will need to enter Customer Name from pull down, then you will have a choice to enter in customer PN or Internal PN.
  5. Part type, class, and description will default in.
  6. Select the Manufacturer & manufacturer part number from the pull down list.
  7. Select the ‘From’warehouse from the pull down list.
  8. Then select the ‘To’ warehouse from the pull down list.
  9. Type in quantity to transfer.
  10. Select the reason from the pull down list.
  11. Type in the reference.
  12. Depress the Save button. 

 

Note For this feature to work properly, the Inventory Part Number must have two warehouse locations assigned to it in the Inventory master.  The From Location must have an inventory balance.   If user attempts to transfer parts that do not have two warehouse locations, or from regular inventory location to MRB  (Note:  System will NOT allow users to transfer parts out of MRB location to regular inventory if parts were transfered into the MRB warehouse through PO Receiving).  You will receive the following message.  This screen is used to move parts from a regular warehouse to another regular warehouse.  Or to move parts that are already located in MRB back into regular stock.  To move parts from stock to MRB you will need to use the Inventory Handling MRB screen

 

This message is a general message user gets when the program can not find any warehouse/location for this part number. This message will appear if the part is locked in cycle count or physical inventory.  User must reconcile and post the physical inventory for this part and then you will be able to process the records within Inventory Handling.  

 

The completed screen will look like this.


 
If transfering qty from an In-Store warehouse to an Internal warehouse an accounting transaction will be created in Inventory Transfer upon saving the transfer.  Then user will then need to create the In-Store PO within the PO module. 

 

1.4.4. MRB Tab
MRB (Material Review Board) Warehouse Overview

The MRB (Material Review Board) Warehouse is where the board members determine whether to return discrepant material to the Supplier.

Depress the MRB tab.  The following screen will appear.

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

  1. Depress the Add button.
  2. Type in your password.
  3. Select the Part Source from the pull down menu. (BUY, MAKE, CONSG, or PHANTOM).
  4. Type in the Part Number, if Part Source is "CONSG" you will need to enter Customer Name from pull down, then you will have a choice to enter in customer PN or Internal PN.
  5. Part type, class, and description will default in.
  6. Select the manufacturer & manufacturer part number from the pull down list.
  7. Select the From Warehouse from the pull down list:
  8. The To Warehouse automatically defaults to MRB (Material Review Board).
  9. Type in the Quantity to Transfer.
  10. Select the Reason for transfer from the pull down list:
  11. Type in the Reference.
  12. Depress the Save button.

 

This message is a general message user gets when the program can not find any warehouse/location for this part number. This message will appear if the part is locked in cycle count or physical inventory.  User must reconcile and post the physical inventory for this part and then you will be able to process the records within Inventory Handling.  

 

The completed screen will appear as follows:



Once the preceding steps have been completed, the user may Add to PO DMR (Discrepant Material Return) module, 
or you may transfer it back into Inventory using the Transfer tab .

Once the DMR (discrepant material return) has been added and saved, a Debit Memo will be created in the Accounting System.  Additionally, the corresponding entry will be created and the balance in the Accounts Payable Aging will adjust.   

 

1.5. Reports - Inventory Handling

To obtain the Inventory Handling module transactions, enter the Inventory Control Management Module.

 

 

The main screen will appear. 




Select the Print button from the ManEx action buttons at the top of the screen. 


The following screen will appear.
 

Select the appropriate radio for the output format you desire: Screen, Printer, XL File, TXT File, or PDF.

Highlight the Transaction Detail Log report or the Part Transaction Log With Balance report   

 
 

The following option screen will appear at the bottom of the screen, Select the type of Detail Report desired by highlighting it:  All, Receipt, Issue, or Trans/Exp.


Depress the Options tab.  
 
 
The following option screen will appear:

Highlight the Part Class you desire and depress the > button.  If you want All, depress the >> button.

Highlight the Warehouse you want and depress the > button.  If you want All, depress the >> button.

If you want a specific part number or range of part numbers, enter the first number and the last number in the Part Number Range fields.
 
Depress the Clear Range Entries to clear the Part Number Range fields.

Enter the date selection From and To.  To clear selection check the Clear Selection box.
 
Check the With Reason box if you want the reason displayed on the report.

Check the Show Serial Number box if you want the serial numbers displayed onthe report.

Select the Inventory Type by depressing the appropriate radio button: Internal, Internal & In Store, In Store or Consign.

Depress the OK button.

 

The one of the following reports will print depending on the report selected:   Notice that the Issued qty's will be displayed as a negative and the Received qty's will be displayed as a postive. 
 
 
 
1.6. FAQs - Inventory Handling
Facts and Definitions for the Inventory Handling Module