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.
|
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.
- Depress the Add button.
- Type in your password.
- Select the Part Source from the pull down menu (BUY, MAKE, CONSG, or PHANTOM).
- 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.
- Part type, class, and description will default in.
- Type in the Received quantity.
- Select the Receiving Account Description from the pull down menu.
- Select the Manufacturer & manufacturer part number from the pull down list.
- The warehouse will default in. If the default is not the warehouse you want you may choose from the pull down list.
Select the reason for the receipt from the pull down list.
- Type in the Reference.
- 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.
- Depress the Add button.
- Type in your password.
- Select the Part Source from the pull down menu. (BUY, MAKE, CONSG, or PHANTOM).
- 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.
- Part type, class, and description will default in.
- Type in the Issued quantity.
- Select the Issue Account Description from the pull down menu.
- Type in Issued To.
- Select the Manufacturer & manufacturer part number from the pull down list.
- The warehouse will default in. If the default is not the warehouse you want you may choose from the pull down list.
- Type in the Reference.
- 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.
- Depress the Add button.
- Type in your password.
- Select the Part Source from the pull down menu. (BUY, MAKE, CONSG, or PHANTOM).
- 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.
- Part type, class, and description will default in.
- Select the Manufacturer & manufacturer part number from the pull down list.
- Select the ‘From’warehouse from the pull down list.
- Then select the ‘To’ warehouse from the pull down list.
- Type in quantity to transfer.
- Select the reason from the pull down list.
- Type in the reference.
- 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.
- Depress the Add button.
- Type in your password.
- Select the Part Source from the pull down menu. (BUY, MAKE, CONSG, or PHANTOM).
- 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.
- Part type, class, and description will default in.
- Select the manufacturer & manufacturer part number from the pull down list.
- Select the From Warehouse from the pull down list:
- The To Warehouse automatically defaults to MRB (Material Review Board).
- Type in the Quantity to Transfer.
- Select the Reason for transfer from the pull down list:
- Type in the Reference.
- 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.
|
|