0% found this document useful (0 votes)
27 views86 pages

Inventory Management

Download as pdf or txt
Download as pdf or txt
Download as pdf or txt
You are on page 1/ 86

Epicor ERP

Inventory Management Course


10.2.600
Disclaimer
This document is for informational purposes only and is subject to change without notice. This document and its
contents, including the viewpoints, dates and functional content expressed herein are believed to be accurate as of its
date of publication. However, Epicor Software Corporation makes no guarantee, representations or warranties with
regard to the enclosed information and specifically disclaims any applicable implied warranties, such as fitness for a
particular purpose, merchantability, satisfactory quality or reasonable skill and care. As each user of Epicor software is
likely to be unique in their requirements in the use of such software and their business processes, users of this document
are always advised to discuss the content of this document with their Epicor account manager. All information contained
herein is subject to change without notice and changes to this document since printing and other important information
about the software product are made or published in release notes, and you are urged to obtain the current release
notes for the software product. We welcome user comments and reserve the right to revise this publication and/or
make improvements or changes to the products or programs described in this publication at any time, without notice.
The usage of any Epicor software shall be pursuant to an Epicor end user license agreement and the performance of
any consulting services by Epicor personnel shall be pursuant to Epicor's standard services terms and conditions. Usage
of the solution(s) described in this document with other Epicor software or third party products may require the purchase
of licenses for such other products. Where any software is expressed to be compliant with local laws or requirements
in this document, such compliance is not a warranty and is based solely on Epicor's current understanding of such laws
and requirements. All laws and requirements are subject to varying interpretations as well as to change and accordingly
Epicor cannot guarantee that the software will be compliant and up to date with such changes. All statements of
platform and product compatibility in this document shall be considered individually in relation to the products referred
to in the relevant statement, i.e., where any Epicor software is stated to be compatible with one product and also
stated to be compatible with another product, it should not be interpreted that such Epicor software is compatible
with both of the products running at the same time on the same platform or environment. Additionally platform or
product compatibility may require the application of Epicor or third-party updates, patches and/or service packs and
Epicor has no responsibility for compatibility issues which may be caused by updates, patches and/or service packs
released by third parties after the date of publication of this document. Epicor® is a registered trademark and/or
trademark of Epicor Software Corporation in the United States, certain other countries and/or the EU. All other
trademarks mentioned are the property of their respective owners. Copyright © Epicor Software Corporation 2020.
All rights reserved. Not for distribution or republication. Information in this document is subject to Epicor license
agreement(s).

ED824905
90521-10-9257-583101001
10.2.600
Revision: March 23, 2020 9:02 p.m.
Total pages: 86
course.ditaval
Inventory Management Course Contents

Contents
Inventory Management Course.............................................................................................6
Before You Begin....................................................................................................................7
Modules Licensing...........................................................................................................................................7
Audience.........................................................................................................................................................7
Prerequisites....................................................................................................................................................7
Environment Setup..........................................................................................................................................8
Overview...............................................................................................................................10
Application Setup.................................................................................................................11
Company Configuration................................................................................................................................11
Site Configuration Control.............................................................................................................................12
Site Maintenance...........................................................................................................................................13
Maintenance Programs..................................................................................................................................13
Warehouse Maintenance........................................................................................................................13
Additional Warehouse Programs......................................................................................................14
Warehouse Zone Maintenance.................................................................................................14
Warehouse Team Maintenance................................................................................................14
Warehouse Team Attribute Maintenance..................................................................................15
Warehouse Bin Maintenance..................................................................................................................16
Additional Warehouse Bin Programs................................................................................................16
Warehouse Bin Size Group Maintenance..................................................................................16
Warehouse Bin Attributes Maintenance....................................................................................16
Workshop - Create a Warehouse and Bin........................................................................................17
Bin Setup Wizard....................................................................................................................................18
Workshop - Bin Setup Wizard..........................................................................................................18
UOM Maintenance.................................................................................................................................19
Workshop - Define Unit of Measure Codes (English Measurements).................................................20
Workshop - Define Unit of Measure Codes (Metric Measurements)..................................................22
UOM Class Maintenance........................................................................................................................23
How UOM Classes Determine Allowable UOM Code Selections for Transaction Quantity Entries......24
Workshop - UOM Class Code..........................................................................................................26
Create a UOM Class Code........................................................................................................26
Add UOM Conversions (English Measurements)........................................................................26
Add UOM Conversions (Metric Measurements).........................................................................27
Part Class Maintenance...........................................................................................................................28
Workshop - Create a Part Class.......................................................................................................28
Product Group Maintenance...................................................................................................................29
Part Maintenance...................................................................................................................................29
Part Maintenance Sheets.................................................................................................................30
Workshop - Create Part Records......................................................................................................31
Create a Purchased Part...........................................................................................................31

Epicor ERP | 10.2.600 3


Contents Inventory Management Course

Add Site Details for the Part.....................................................................................................33


Approved Supplier Maintenance......................................................................................................35
Workshop - Designate Approved Suppliers...............................................................................35
Workshop - Create a Multiple UOM Part..........................................................................................35
Part Tracker............................................................................................................................................37
Daily Inventory Processing...................................................................................................38
Quantity Adjustments....................................................................................................................................39
Workshop - Quantity Adjustments..........................................................................................................39
Enter Initial Inventory Quantities......................................................................................................39
Adjust Miscellaneous Quantity.........................................................................................................40
Verify Quantity Adjustments in Part Transaction History Tracker.......................................................40
UOM Split/Merge...........................................................................................................................................41
Workshop - Split Inventory......................................................................................................................41
Issue Miscellaneous Material..........................................................................................................................42
Workshop - Issue Miscellaneous Material................................................................................................42
Backflushing..................................................................................................................................................44
Workshop - Complete the Operation with Backflushed Materials............................................................46
Workshop - Review Backflushing Activity................................................................................................48
Receipt and Shipment Processing...................................................................................................................48
Receipt Processing..................................................................................................................................48
Workshop - Receive a Purchase Order..............................................................................................49
Workshop - Create a Mass Receipt..................................................................................................50
Shipment Processing...............................................................................................................................51
Sales Order Pick List.........................................................................................................................51
Workshop - Ship a Sales Order........................................................................................................52
Create a Pack ID.......................................................................................................................52
Create a Pack Line....................................................................................................................52
Print a Packing Slip...................................................................................................................53
Issuing Materials to Jobs................................................................................................................................53
Cut Lists Report......................................................................................................................................53
Pick List for Jobs.....................................................................................................................................54
Workshop - Create a Job Picklist......................................................................................................55
Issue Material.........................................................................................................................................56
Workshop - Issue Job Material.........................................................................................................56
Mass Issues to Manufacturing.................................................................................................................57
Workshop - Release Job for Mass Issue............................................................................................57
Mass Issue Materials to Job......................................................................................................58
Issue Assembly........................................................................................................................................58
Receiving Completed Jobs..............................................................................................................................59
Job Receipt to Inventory..........................................................................................................................59
Workshop - Receive Completed Job Quantities to Inventory.............................................................59
Job Receipt to Job...................................................................................................................................62
Job Receipt to Salvage............................................................................................................................62
Job Tracker.............................................................................................................................................63
Inventory Returns...........................................................................................................................................64

4 Epicor ERP | 10.2.600


Inventory Management Course Contents

Return Material.......................................................................................................................................65
Workshop - Return Items to Stock...................................................................................................65
Mass Return from Manufacturing...........................................................................................................66
Workshop - Mass Return Material from Job.....................................................................................67
Return Miscellaneous Material................................................................................................................68
Return Assembly.....................................................................................................................................68
Inventory Transfer..........................................................................................................................................69
Workshop - Transfer Parts.......................................................................................................................69
Min Max Safety Mass Update.........................................................................................................................69
Workshop - Create Sales Usage History...................................................................................................71
Ship the Sales Order........................................................................................................................72
Part Class and Part Maintenance Settings................................................................................................73
Workshop - Update Part Class Min/Max/Safety Mass Update Settings..............................................74
Workshop - Exclude a Part from Min Max Safety Mass Update Processing........................................75
Workshop - Add Min/Max Settings for a Part...................................................................................76
Workshop - Run Min Max Safety Mass Update.......................................................................................76
Enter Manual Updates and Complete Copying to Part Records........................................................79
Inventory Reporting.......................................................................................................................................79
Time Phased Material Requirements Report.............................................................................................80
Inventory Usage Report...........................................................................................................................80
Material Transaction Detail Report..........................................................................................................80
Stock Status Report................................................................................................................................81
In Transit Stock Reporting.......................................................................................................................81
Conclusion.............................................................................................................................82
Appendix...............................................................................................................................83
Transaction Types..........................................................................................................................................83

Epicor ERP | 10.2.600 5


Inventory Management Course Inventory Management Course

Inventory Management Course

This course provides an overview of the entire inventory management process. Use this module to update and
maintain raw materials, work in process (WIP) as well as finished goods inventory quantities and costs.
Upon successful completion of this course, you will be able to:
• Define user-definable company and site parameters that govern Inventory Management processing.
• Create new warehouses and warehouse bins using Warehouse Maintenance and Warehouse Bin Maintenance.
• Generate warehouse bins using the Bin Setup Wizard.
• Define Unit of Measure (UOM), UOM Class, part class and product group codes for assignment on part records.
• Create new parts using Part Maintenance and identify important inventory data fields.
• Perform inventory transactions such as quantity adjustments, order shipments, receipts, job material issuance,
returns and transfers.
• Configure and process a cycle count to maintain accurate inventory counts.
• Describe what inventory reporting options are available in Epicor ERP.

6 Epicor ERP | 10.2.600


Inventory Management Course Before You Begin

Before You Begin

Read this topic for information you should know in order to successfully complete this course.

Modules Licensing
The following modules must be licensed to complete all the workshops in this course:
• Inventory Management
• Job Management
• Multiple Warehouse
• Shipping Receiving

Audience

Specific audiences will benefit from this course.


• Cost Accountant
• Shipping and Receiving
• Material Handler
• Production Manager

Prerequisites

To complete the workshops in this course, the necessary modules must be licensed and operating in your training
environment. For more information on the modules available, contact your Epicor Customer Account Manager.
It is also important you understand the prerequisite knowledge contained in other valuable courses.
• Foundations Agenda Courses on Epicor Learning Center - These courses describe logging in to Epicor
ERP, using menus and toolbars, working with Tree view and sheets. They give you a quick overview how to
enter data in Epicor ERP, use searches to find data and work with grids. The courses in this agenda teach you
to personalize your application, print forms and reports and use trackers to view information.
• Recommended Knowledge Camp Course - This course provides a high level overview of the quote to cash
flow through the Epicor application. You begin with how to create a quote, process it as an order, and fill
the order across production planning and purchasing. The course also covers the manufacturing plan and
shipment of parts to a customer, as well as how to process invoices, enter cash receipts, and generate supplier
payments.

Epicor ERP | 10.2.600 7


Before You Begin Inventory Management Course

Environment Setup

The environment setup steps and potential workshop constraints must be reviewed in order to successfully
complete the workshops in this course.
Your Epicor training environment, in which the Epicor demonstration database is found, enables you to experience
Epicor functionality in action but does not affect data in your live, production environment.
The following steps must be taken to successfully complete the workshops in this course.

1. Verify the following or ask your system administrator to verify for you:
• Your Epicor training icon (or web address if you are using Epicor Web Access) points to your
Epicor training environment with the Epicor demonstration database installed. Do not complete
the course workshops in your live, production environment.
Note It is recommended that multiple Epicor demonstration databases are installed. Contact
Support or Systems Consulting for billable assistance.

• The Epicor demonstration database is at the same version as the Epicor application. The
demonstration database is installed from the Epicor Administration Console using the "Add Demo
Database" command under Database Server. See Epicor ERP installation guides for details. If you are an
Epicor Cloud ERP customer (and have licensed embedded education), the demonstration database is
installed for you.
• Your system administrator restored (refreshed) the Epicor demonstration database prior to
starting this course. The Epicor demonstration database comes standard with parts, customers, sales
orders, and so on, already defined. If the Epicor demonstration database is shared with multiple users
(that is, the database is located on a server and users access the same data, much like your live, production
environment) and is not periodically refreshed, unexpected results can occur. For example, if a course
workshop requires you to ship a sales order that came standard in the Epicor demonstration database,
but a different user already completed this workshop and the Epicor demonstration database was not
restored (refreshed), then you will not be able to ship the sales order. If you are an Epicor Cloud ERP
customer see section below.

2. Log in to the training environment using the credentials epicor/epicor. If you are logged into your training
environment as a different user, from the Options menu, select Change User.
Note You must have Security Manager credentials to access system administration programs such
as Company Configuration or Site Configuration. The epicor user ID has the required security
credentials.

3. From the Main menu, select the company Epicor Education (EPIC06).

4. From the Main menu, select the Main site.

Epicor Cloud ERP Specific Information


Note If you are an Epicor Cloud ERP customer, then note the following about your Epicor-hosted education
company. All logins referenced in the course (such as manager, or epicor) should be changed to be the
<site ID>-. For example, if your site ID is 98315, then wherever you are instructed to use the login epicor,
instead use 98315-epicor. The password is 'Train18!'.

8 Epicor ERP | 10.2.600


Inventory Management Course Before You Begin

Note To refresh your Epicor training data, enter a support ticket in EpicCare and include your site ID.

Epicor Cloud ERP Specific Information


Note If you are an Epicor Cloud ERP customer, then note the following about your Epicor-hosted education
company. All logins referenced in the course (such as manager, or epicor) should be changed to be the
<site ID>-. For example, if your site ID is 98315, then wherever you are instructed to use the login epicor,
instead use 98315-epicor. The password is 'Train18!'.

Note To refresh your Epicor training data, enter a support ticket in EpicCare and include your site ID.

Epicor ERP | 10.2.600 9


Overview Inventory Management Course

Overview

The Inventory Management module contains detailed information related to an item, including costs, quantities,
and on-hand requirements.
The primary function of this module is to manage the flow of materials from incoming purchase orders (POs)
through manufacturing and shipping to the customer. You can ship materials from stock or inventory, received
to stock, or receive them directly to a job. Inventory transactions are made in the same manner regardless of the
manufacturing environment, make-to-order (MTO) or make-to-stock (MTS). Ultimately, these transactions result
in revenue and are posted to the general ledger (GL).

Inventory Management Features


• Unit of measure (UOM) quantity conversions and tracking
• Material, labor, subcontract and burden cost tracking
• Inventory transfer
• Job material issuance
• Cycle and physical counting
• Detailed transaction tracking and reporting
• Internal, supplier, customer, manufacturer and product code part cross-referencing
• Serial control, custom serial formatting, and serial number tracking
• Lot control and tracking
Note The cross-referencing, serial number and lot tracking topics are covered in the Inventory
Management - Specialized Processing course, and are not included in the basic Inventory Management
course. Some of these features are covered in other Epicor courses.

Inventory Management Terminology


• Assembly
Assembly defines all the manufactured components or parts required to make each part for the customer.
Assemblies are identified separately from the raw materials in Job Entry and Opportunity/Quote Entry. In
the bill of materials (BOM), assemblies are identified as materials that must be pulled as an assembly.
• Parent Assembly
This is an assembly that consist of two sub-assemblies.
• Sub Assembly
This is a manufactured part needed in a parent assembly.
• Material
Material identifies all the raw materials required to make each part produced. Material information includes
the part number, quantity required, and estimated cost. If the part number exists in Part Maintenance, an
allocation is created when you enter a job material requirement.
• Finished Good
This is a complete part ready for shipment.
• Expense Items
These are ordered items consumed in the manufacturing process and are not considered inventory.

10 Epicor ERP | 10.2.600


Inventory Management Course Application Setup

Application Setup

This section of the course reviews common company configuration and maintenance program factors that apply
to the general inventory user.

Company Configuration

Company Configuration defines the available options for companies in the Epicor application. When you install
the Epicor application, one company record is created by default. You use this program to define how each
company interacts with the various modules you have licensed. These options customize the application to best
fit each company within your organization.

Modules > All Modules > General


Use the Modules > All Modules > General sheet to define basic system-wide company settings.
• This includes the Quantity Decimal Display field, which specifies the number of decimals to use for displaying
numbers in Quantity fields in grids throughout the application.
• For example, if this field is set to 4, quantities display in grids as 12.3426; if this field is set to 2, quantities
display in grids as 12.34.
Note For quantities displayed in non-grid fields, you use the Allow Decimals, Decimals, and Rounding
settings in the UOM Maintenance > Detail sheet to designate, for each defined UOM code, the
number of decimals that should display throughout the Epicor application.

Modules > Materials > Inventory > General


Use the sheets under the Materials tab to define system options for the following Materials modules or functions:
• Inventory
• Purchase
• Shipping / Receiving
• Serial Mask Formats
The Modules > Materials > Inventory > General sheet includes user-definable parameters related to bar code
printing, inventory adjustment reasons, UOM rounding, ECO processing, transfer orders and stock provision
reports.

Modules > Materials > Inventory > Lot


Use the Modules > Materials > Inventory > Lot sheet to define lot attribute defaults at the company level.
Note Lot Tracking is covered in detail in the Inventory Management - Specialized Processing course.

Menu Path
Navigate to this program from the Main Menu:
• System Setup > Company/Site Maintenance > Company Configuration

Epicor ERP | 10.2.600 11


Application Setup Inventory Management Course

Site Configuration Control

Use Site Configuration Control to define how each plant site interacts with various functions in the Epicor
application such as the Inventory Management, Production Management, Shipping/Receiving, Time Management,
and Expense Management modules.
When you create a company record in the Epicor application, one site record is automatically created by default.
This site record is the default site selected for each part you create within Part Maintenance for the current
company. You then use Site Configuration Control to define parameters for several application functions. You
can create addition site records as needed in Site Maintenance; once you do this, you use Site Configuration
Control to define operational parameters specific to that site.
Important Before you can open a site record in Site Configuration Control, you may need to have your
System Administrator give you security rights to that site in your user account.

The Modules > Inventory Management tab contains the following sheets you use to define the warehouses,
transfer order definitions/resources, serial tracking default values and cycle count parameters for each site:
• General - Contains settings for definition of the warehouses the site uses for shipping, receiving, DMR
Processing, and so on. You also indicate which warehouses are shared with other warehouses. You also
identify transfer orders by setting up the definitions for transferring part quantities and the resources involved
in transfer orders. Lastly, you define the serial tracking and cycling counting used for parts manufactured
through each site.
• Shared Warehouses - Contains settings for definition of the warehouses the site uses for shipping, receiving,
DMR Processing, and so on. You also indicate which warehouses are shared with other warehouses.
• Transfer Definition - Contains settings for definition of how the site handles transfer orders it requests from
other sites.
• Transfer Resources - Contains settings for definition of the resources involved in transfer orders.
• Serial Tracking - Contains settings for definition of how the site handles serial number tracking.
Note Serial Tracking is covered in detail in the Inventory Management - Specialized Processing
course.

• Cycle Count - Contains settings for definition of physical and cycle counting parameters used with this site
configuration. Use the Detail sheet to indicate the Cycle Count Select Method to run for the site, and also
indicate that this site uses the method selected on warehouse records. Use the ABC Codes > Detail sheet
to select and update the ABC codes used for cycle counting for the site.

Menu Path
Navigate to this program from the Main Menu:
• System Setup > Company/Site Maintenance > Site Configuration
Important This program is not available in Epicor Web Access.

12 Epicor ERP | 10.2.600


Inventory Management Course Application Setup

Site Maintenance

Use Site Maintenance as needed to add additional sites for the current company. To add more than one site
record through this program, you must license the Multi-Site module. You can then set up as many sites as you
need for each company within your organization.
• In the Detail > Detail sheet, you define the cost set, which determines the costing method used for the parts
manufactured at the site. Lastly, setup the transfer order parameters the site follows when fulfilling internal
sales orders.
• In the Detail > Detail sheet, you define planning parameters such as Production Preparation Time, Rough
Cut Horizon, and the Production Calendar.
Once you do this, you use Site Configuration Control to define operational parameters specific to the site;
these designates how the site interacts with various modules in the Epicor application.

Menu Path
Navigate to this program from the Main Menu:
• Financial Management > Multi-Site > Setup > Site Maintenance
• Material Management > Inventory Management > Setup > Site Maintenance
• Production Management > Job Management > Setup > Site Maintenance
• System Setup > Company/Site Maintenance > Site Maintenance

Maintenance Programs

This section of the course discusses common maintenance programs that influence the inventory process.
In most cases, not all of the fields within the following master files are discussed in this course. For a full description
of all available fields, refer to the Application Help.

Warehouse Maintenance

Use Warehouse Maintenance to set up warehouses. You can group items in your inventory in each warehouse.
You must set up at least one warehouse before you can enter parts in Part Maintenance.
When you set up a warehouse, it is automatically placed in the site into which you are currently logged. You can
also share the warehouse with other sites. You can do this on the System Setup > Company/Site Maintenance
> Site Configuration Control > Modules > Inventory Management > Shared Warehouses sheet.
A shared warehouse is a warehouse that belongs to one site in particular, but when you share it with one or
more other sites, you can directly issue parts from or receive parts into the warehouse from the sites with which
it has been shared. In order to set up more than one warehouse in this program, you must license the Advanced
Material Management (AMM) module.
Note Even if you do not physically have separate warehouses with multiple bins, you should still set up
logical warehouses and bins that can help you keep track of inventory within the same location.

Epicor ERP | 10.2.600 13


Application Setup Inventory Management Course

Menu Path
Navigate to this program from the Main Menu:
• Material Management > Inventory Management > Setup > Warehouse
• Production Management > Quality Assurance > Setup > Warehouse

Additional Warehouse Programs

The following are additional warehouse maintenance programs that exist to support the Fulfillment Workbench
feature in the Inventory Management module.
For a full description of all available fields, refer to the Application Help.

Warehouse Zone Maintenance

Use Warehouse Zone Maintenance to create bin zones within a specified warehouse. A zone is a group of
bins within a warehouse.
The Epicor application allows you to group bins together into a zone, regardless of their type or other attributes.
Warehouse zones can be established, usually based on similarly sized bins / products. Zone codes are then assigned
to specified warehouse bins in the Zone field in Warehouse Bin Maintenance. The Epicor application uses bin
zones primarily in the Fulfillment Workbench.

Menu Path
Navigate to this program from the Main Menu:
• Material Management > Inventory Management > Setup > Warehouse Zone

Warehouse Team Maintenance

Use Warehouse Team Maintenance to create and define warehouse teams based on attribute/skill, transaction,
and location. Warehouse teams can be assigned to allocation templates defined in Allocation Template Entry, or
used to process transactions after inventory is allocated in the Fulfillment Workbench.
For example, you can create warehouse teams that process put-away transactions, while others process pick
transactions. Use Warehouse Team Maintenance to perform the following tasks:
• Assign specific shop floor or warehouse employees to the warehouse team.
• Assign bin attributes.
• Identify the transaction types the warehouse team can process and assign a priority code that denotes the
sequence in which they must be processed.
• Identify specific warehouses in which the warehouse team can work.
• Identify specific bins, zones, and optionally, items (parts, classes, or groups) for which the warehouse team
is responsible for each assigned warehouse.
You must be assigned to a warehouse team in order to receive transactions to process when using the Auto-Select
feature from the Handheld menu. The warehouse manager can assign transaction types to warehouse teams
and assign priorities to those transactions. Transaction types include sales order picks, job order picks, transfer
order picks, Planner Workbench bin-to-bin moves, and put-aways for purchase receipts, job production, or transfer
receipts. Warehouse team members can only process selected transactions for selected items in their assigned
warehouses, bins, and zones.

14 Epicor ERP | 10.2.600


Inventory Management Course Application Setup

Warehouse Team Attribute Maintenance

Use Warehouse Team Attribute Maintenance to define attributes assigned to warehouse teams. These
attributes detail specific aspects of each warehouse team, like Picker, Receiving Qualified, Hand Held Expert, and
so on.
You later assign these attributes to a team using Warehouse Team Maintenance. You select these items on the
Attributes sheet.
For example, define an attribute in Warehouse Team Attributes Maintenance that denotes a forklift is required.
Define another attribute that denotes the forklift driver must be certified. When work is assigned on the queue,
you can assign an inventory move transaction from (or to) a bin that requires a forklift based on this forklift
attribute.

Menu Path
Navigate to this program from the Main Menu:
• Material Management > Inventory Management > Setup > Warehouse Team Attribute

Epicor ERP | 10.2.600 15


Application Setup Inventory Management Course

Warehouse Bin Maintenance

Use Warehouse Bin Maintenance to identify the specific bins where inventory is stored in a warehouse. You
use the Detail sheet to define operating characteristics (such as the description, zone, size, sequence, type, location
and fulfillment parameters) for each bin, and use the Attributes sheet to assign user-defined warehouse bin
attributes (previously defined in Warehouse Bin Attributes Setup) as needed.
Important At least one bin location is required for a warehouse.

The Type field in the Warehouse Bin Maintenance > Detail sheet designates if a particular warehouse bin is
a Standard type bin or a non-standard Customer Managed or Supplier Managed type bin. Non-standard customer
and supplier-owned inventories provide you with the ability to hold, control, and record inventory items owned
by a specific customer or supplier.
Note Refer to Customer and Supplier Managed Inventories section in the Inventory Management
- Specialized Processing course for more details.

Menu Path
Navigate to this program from the Main Menu:
• Material Management > Inventory Management > Setup > Warehouse Bin
• Service Management > Field Service Automation > Setup > Warehouse Bin

Additional Warehouse Bin Programs

The Fulfilment Workbench feature provides inventory management across bins, warehouses, and zones.
For a full description of all available fields, refer to the Application Help.

Warehouse Bin Size Group Maintenance

Use Warehouse Bin Size Group Maintenance to define bin size code groups that contain height, length,
width, and volume sizing information for bins. The bin size group codes defined into the program are assigned
to specific warehouse bins in Warehouse Bin Maintenance.

Menu Path
You can launch this program using the Main Menu from
Menu Path: Material Management > Inventory Management > Setup > Warehouse Bin Size Group

Warehouse Bin Attributes Maintenance

Use Warehouse Bin Attributes Maintenance to create user-defined attributes for bins.
These attributes can be assigned to specific warehouse bins on the Attributes sheet in Warehouse Bin
Maintenance. These attributes can detail specific aspects of each bin, like Large Bin, Receiving Bin, Mobile Bin,
and so on.
For example, a user-defined attribute can be defined in Warehouse Bin Attributes Maintenance that denotes that
a forklift is required. When work is assigned on the queue, an inventory move transaction from (or to) a bin that
requires a forklift could be assigned to a user based on this forklift attribute.

16 Epicor ERP | 10.2.600


Inventory Management Course Application Setup

Menu Path
Navigate to this program from the Main Menu:
• Material Management > Inventory Management > Setup > Warehouse Bin Attribute

Workshop - Create a Warehouse and Bin

In this workshop, create new warehouses and link new warehouse bins.
Navigate to Warehouse Maintenance.
Menu Path: Material Management > Inventory Management > Setup > Warehouse

1. From the New menu, select New Warehouse.

2. Enter the following information:.

Field Data
Warehouse XXX-Whs (where XXX are your initials)
Description XXX Warehouse (where XXX are your initials)

3. Click Save.

4. From the Actions menu, select Bins.


Warehouse Bin Maintenance displays.

5. Click New.

6. Enter the following information:

Field Data
Bin XXX-Bin (where XXX are your initials)
Description XXX Bin (where XXX are your initials)

7. In the Type section, verify the Standard option is selected.

8. Click Save.

9. Exit Warehouse Bin Maintenance and Warehouse Maintenance.

Epicor ERP | 10.2.600 17


Application Setup Inventory Management Course

Bin Setup Wizard

Use the Bin Setup Wizard to mass-generate and create bin numbers for a specified set of criteria.
The Bin Setup Wizard performs the following processing:
• For the warehouse number, bin numbering format, and maximum bin number generation limit specified in
the Configure sheet, the utility configures the numbering sequence. After clicking the Generate button on
the Configure sheet, it then generates the proposed bin numbers based on the specified parameters.
• Displays the proposed bin numbers in the Verify sheet. Use the Selected check box and the Clear or Select
All buttons to select the specific bin numbers committed to the Epicor application files.
• When you click Commit on the Commit sheet, or the Save button on the Standard toolbar, the program
applies the user-specified bin definition parameters against all generated bin records and formally commits
them to the Epicor application files.

Menu Path
Navigate to this program from the Main Menu:
• Material Management > Inventory Management > Setup > Warehouse Bin Setup Wizard

Workshop - Bin Setup Wizard

In this workshop, generate a block of five bin numbers for the XXX-Whs (where XXX are your initials) warehouse
created in the Workshop - Create a Warehouse and Bin.
Note You must define warehouses and link them to a site before you use Bin Setup Wizard to establish
the bins. You can also create warehouse bins in Warehouse Bin Maintenance.

Navigate to Bin Setup Wizard.


Menu Path: Material Management > Inventory Management > Setup > Warehouse Bin Setup Wizard

1. Click New.

2. In the Warehouse field, select XXX Warehouse (where XXX are your initials).

3. In the Bin Number Segments grid, in the Segment column, verify String defaults and click Tab.

4. In the Length column, enter 3 and press Tab.

5. In the Minimum and Maximum columns, enter CLS and press Tab after each field.
In the Bin Number Segments grid, a second segment line displays.

6. In the second line, in the Segment column, select Separator and press Tab throughout the remaining
fields to add a third segment line.

7. In the third line, in the Segment column, select Number and press Tab.

8. In the Length column, enter 3 and press Tab.

9. In the Minimum column, enter 001 and press Tab.

10. In the Maximum column, enter 005.

18 Epicor ERP | 10.2.600


Inventory Management Course Application Setup

11. Click Generate.


The Verify sheet displays.

12. Review the bin numbers proposed.

13. Navigate to the Commit sheet.

14. Click the Commit button.


The Do you want to proceed creating the Bins? message displays.

15. To the message, click Yes.

16. Exit Bin Setup Wizard.

UOM Maintenance

Use UOM Maintenance to define UOM (Unit of Measure) codes stored in the UOM master file. These represent
the units of measure in which transaction quantities are expressed in the Epicor application. Examples of UOM
codes include weights and measures such as Cubic Centimeters, Each, Feet, Box and Case.
The Epicor application provides extensive unit of measure support, and also provides you with the ability to
(optionally) track inventory balances for parts in multiple units of measure. This gives the Epicor application the
ability to display transaction quantities per unit of measure.
• All inventory, job, quotation, sales order and purchase order transactions created for a given part require entry
of a UOM code.
• For example, when you enter a weight for transaction, you also enter a UOM code representing the weight
measurement (for example, LBS, KG, TONS).
Before processing transactions for an item, all UOM codes must first be defined in UOM Maintenance and then
assigned to UOM Class codes in UOM Class Maintenance. Once they have been assigned to a UOM Class code,
you assign primary inventory, sales and purchase UOM codes to specific part records using the Part Maintenance
> Part > Detail sheet.
• These represent the base unit of measure in which inventory balances are normally stored for the item, and
the default UOM codes that display when entering quotations, sales orders and purchase orders for the item.
Example You might inventory and produce an item by single unit (Each), sell it by the Box but purchase
it by the Case. You would define UOM codes for each of three units of measure, associate it with a
UOM Class code (in UOM Class Maintenance) and then assign it to the part record.

• When processing transactions for the item, the Epicor application would then use the UOM code presenting
Each as the default unit of measure for inventory quantity balances and production quantities.
When selling or quoting the same item, it would display the UOM code representing a Box as the default unit
of measure.
When you purchase the item from a supplier, it would display the UOM code presenting a Case as the default
unit of measure; these default UOM codes can be overridden as needed for specific transactions.
• Once a UOM code has been assigned in Part Maintenance, it cannot be changed once inventory balances
exists for the part, or used in any way.
• Once a UOM code has been created it cannot be deleted, but can marked as Inactive to prevent further use
in the Epicor application.

Epicor ERP | 10.2.600 19


Application Setup Inventory Management Course

Note You designate, for each defined UOM code, the number of decimals that should display for quantities
in non-grid fields through use of the Allow Decimals, Decimals, Rounding field settings in the UOM
Maintenance > Detail sheet.
Use the Quantity Display Decimal field in the Company Configuration > Modules > All Modules >
General sheet to designate, by company, how quantities should display in grid fields throughout the Epicor
application.

Note Electronic Data Interchange (EDI) only supports two character UOM codes. If you plan on using the
EDI Import or EDI Export programs, you should limit the length of the UOM codes you create in this program
to a maximum of two characters. Creation of UOM codes in excess of two characters in length would
require customization of the EDI Import and EDI Export programs to handle processing of the longer UOM
codes.

Menu Path
Navigate to this program from the Main Menu:
• Financial Management > Accounts Payable > Setup > UOM
• Financial Management > Accounts Receivable > Setup > UOM
• Material Management > Inventory Management > Setup > UOM
• Material Management > Purchase Management > Setup > UOM
• Production Management > Engineering > Setup > UOM
• Sales Management > Order Management > Setup > UOM

Workshop - Define Unit of Measure Codes (English Measurements)


If you use metric measurements, skip this workshop and perform Workshop - Define Unit of Measure Codes
(Metric Measurements) in its place.
Navigate to UOM Maintenance.
Menu Path: Material Management > Inventory Management > Setup > UOM

1. Click New.

2. In the UOM field, enter XXX-PN (where XXX are your initials).

3. In the Description field, enter XXX Pint (where XXX are your initials).

4. In the Symbol field, enter PN.


This identifies how the UOM code should print on reports and documents throughout the Epicor application.

5. In the Rounding field, accept the default of Round Up.


This specifies how or if the Epicor application should round transactional quantities for the associated UOM
code.

6. Verify the Allow Decimals check box is selected.


This designates if the Epicor application should allow entry of fractional transaction quantities for parts that
use this UOM code

7. In the Decimals field, verify the value of 2 defaults.


If the Allow Decimals check box has been selected, this identifies the maximum number of decimals you
can enter for quantities when you use this UOM code on a transaction.

8. Click Save.

20 Epicor ERP | 10.2.600


Inventory Management Course Application Setup

9. Repeat steps 1-7 to add the following units of measure (where XXX are your initials):

UOM UOM Description Symbol


XXX-QT XXX Quart QT
XXX-GL XXX Gallon GL

10. Exit UOM Maintenance.

Epicor ERP | 10.2.600 21


Application Setup Inventory Management Course

Workshop - Define Unit of Measure Codes (Metric Measurements)


If you use English measurements, skip this workshop and perform the previous Workshop - Define Unit of
Measure Codes (English Measurements) in its place.
Navigate to UOM Maintenance.
Menu Path: Material Management > Inventory Management > Setup > UOM

1. Click New.

2. In the UOM field, enter XXX-ML (where XXX are your initials).

3. In the Description field, enter XXX Milliliters (where XXX are your initials).

4. In the Symbol field, enter ML.


This identifies how the UOM code should print on reports and documents throughout the Epicor application.

5. In the Rounding field, accept the default of Round Up.


This specifies how or if the Epicor application should round transactional quantities for the associated UOM
code.

6. Verify the Allow Decimals check box is selected.


This designates if the Epicor application should allow entry of fractional transaction quantities for parts that
use this UOM code

7. In the Decimals field, enter 4.


If the Allow Decimals check box has been selected, this identifies the maximum number of decimals you
can enter for quantities when you use this UOM code on a transaction.

8. Click Save.

9. Repeat steps 1-7 to add the following unit of measure (where XXX are your initials):

UOM UOM Description Symbol


XXX-LT XXX Litre L

10. Exit UOM Maintenance.

22 Epicor ERP | 10.2.600


Inventory Management Course Application Setup

UOM Class Maintenance

Use UOM Class Maintenance to define Unit of Measure (UOM) Classes that are assigned to parts in the Part
Maintenance > Part > Detail sheet, or are used for parts created on-the-fly. A UOM Class consists of a defined
set or bundle of alternate UOM codes (for example, Bag, Box, Case, Pallet) that convert to a single base UOM
(for example, Each). You must first define all UOM codes entered using UOM Maintenance.
The graphic below shows the UOM structure.

The only required element for a UOM Class is assignment of a base UOM code. You assign a base UOM code to
each UOM Class to designate how the Epicor application performs conversion from each of the assigned alternate
units of measure to the base UOM. The purpose of this program is to make UOM code assignment in Part
Maintenance easier in cases where the same UOM conversion factors apply to multiple parts.
UOM Class Maintenance eliminates the need to define the same individual UOM conversions multiple times when
you create parts in Part Maintenance that require the same UOM conversions as other parts.
• For example, if you stock and sell multiple parts by weight, you can define a single weight UOM Class that
contains all possible weight UOM codes you wish to use.
• You then assign that UOM Class to each part that requires weight UOMs.
• If you ever need to add additional UOM conversions, you can add the new UOM conversions to the UOM
Class, making the new conversions immediately available to all parts configured to use that UOM Class.

Menu Path
Navigate to this program from the Main Menu:
• Financial Management > Accounts Payable > Setup > UOM Class
• Financial Management > Accounts Receivable > Setup > UOM Class
• Material Management > Inventory Management > Setup > UOM Class
• Material Management > Purchase Management > Setup > UOM Class
• Production Management > Engineering > Setup > UOM Class
• Sales Management > Order Management > Setup > UOM Class

Epicor ERP | 10.2.600 23


Application Setup Inventory Management Course

How UOM Classes Determine Allowable UOM Code Selections for Transaction Quantity Entries

A UOM Class consists of a defined set or bundle of alternate UOM codes (for example, Bag, Box, Case, Pallet)
that convert to a single base UOM code (for example, Each). When entering transactional quantities (sales order
lines, quote lines or jobs), the Epicor application determines the allowable Unit of Measure (UOM) codes you can
select that denote the unit of measure. The processing that occurs is dependent on whether you enter a standard
or on-the-fly part number for the transaction.

Standard Parts versus On-the-Fly Parts


What is the difference between standard parts and on-the-fly parts?
Standard parts are those for which you create part records using Part Maintenance.
• Part records include a UOM Class, Inventory Unit of Measure (IUM), default Sales Unit of Measure (SUM) and
default Purchase Unit of Measure (PUM) you designate for the item in the UOM Class and Primary UOMs
fields in Part Maintenance > Part > Detail sheet.
• For example, if you have defined a UOM Class called Count and assigned it to a part record, you can assign
any of the UOM codes associated with that UOM Class as the IUM, SUM and PUM defaults for the part record.
On the Fly parts are those that do not have a standard part record. As the name suggests, you use On the Fly
parts for items you sell, quote or produce, typically for a single instance, and for which you do not want to create
standard part records.
• These might include items for which you wish calculate dimensions (for example, Linear feet) on a case-by-case
basis for specific orders or quotes, or you configure per customer specification using functions in the
Configuration module.
• Typically, they are items you manufacture on a one time basis (usually per customer request) and do not
regularly stock.
When you enter an order line into the Sales Order Entry > Lines > Detail sheet:
• You enter a standard or on-the-fly part number for the ordered item into the Part field.
• Enter the order quantity into the Order Quantity field in the Sales Order Entry > Lines > Detail sheet.
• In the drop-down list to the right of the Order Quantity field, you select the UOM code that designates the
unit of measure in which the order quantity is being expressed.
When you enter a quote line into the Opportunity/Quote Entry > Lines > Detail sheet:
• You enter a standard or on-the-fly part number for the quoted item into the Part field.
• Enter the quote quantity into the Order Quantity field.
• In the drop-down list to the right of the Order Quantity field, you select the UOM code that designates the
unit of measure in which the quote quantity is being expressed.
When you enter a job into Job Entry:
• You enter a standard or on-the-fly part number for the item being produced into the Part field.
• Enter the production quantity into the Production Quantity field.
• In the drop-down list to the right of the Production Quantity field, you select the UOM code that designates
the unit of measure in which the production quantity is expressed.

How UOM Classes Determine Allowable UOM Code Selections for Standard Parts
The logic the Epicor application uses to determine the default UOM code, and allowable UOM code selections
for transaction quantities, is the same whether you enter a quote line, order line or job. This default displays in
the unlabeled field to the immediate right of the transaction quantity fields. It is primarily dependent on whether
you have entered a standard or On the Fly part into the Part field.

24 Epicor ERP | 10.2.600


Inventory Management Course Application Setup

If you enter a standard part, the following logic applies:


• For order or quote lines, the displayed default is the UOM code you assign to the part in the Primary UOMs
- Sales field.
• For a job, the default is the UOM code you assign to the part in the Primary UOMs - Inventory field.
• For a purchase order, the default is the UOM code you assign to the part in the Primary UOMs - Purchase
field.
The Epicor application determines the allowable UOM code selections based on the UOM Class assigned to the
standard part in the UOM Class field in the Part Maintenance > Part > Detail sheet.
• If the UOM class assigned to the part record has been defined in the UOM Class Maintenance > Detail sheet
with one of the system-assigned standard class types (Area, Count, Time, Weight or Volume) or an Other
class type, the default UOM code can be overridden with any of the UOM codes you have assigned to that
UOM Class in the UOM Class Maintenance > UOMs sheet.
Example If you assigned the system-assigned Count UOM Class to the part record, you can select any
of the associated UOM codes (for example, Each, Box, Case) that are associated with that UOM Class.

• These are the only selections that appear in the drop-down list.

How UOM Classes Determine Allowable UOM Code Selections for On the Fly Parts
If you have entered an On the Fly part, the default UOM code (that displays in the unlabeled field to the
immediate right of the transaction quantity fields) is dependent on the setting of the System Default check box
in the UOM Class Maintenance > Detail sheet:
• If the System Default check box has been selected for one of your defined UOM classes, the displayed default
is the UOM code (assigned to that UOM class) that has been designated as the default UOM code (the Default
UOM check box has been selected for it in the UOM Class Maintenance > UOMs sheet). In effect, the default
UOM code assigned to the system default UOM class appears but can be overridden.
Example If the Count UOM class is designated as the system default, EA (Each) would display if has
been designated as the default UOM code for the Count UOM class.

• If this check box has not been selected for any of your defined UOM classes, no default UOM code displays
in this field.
You can select one of the following as the unit of measure:
• Any UOM code that is associated with any of the On The Fly type UOM Classes or
• Any of the UOM codes for which a system-assigned standard type (Area, Count, Time, Weight or Volume)
has been defined in the UOM Class Maintenance > Detail sheet.
Note These are the only selections that appear in the drop-down lists to the right of the transaction
quantity fields. UOM codes that are associated with UOM Classes with a type of Other do not appear
in the drop-down lists and cannot be selected as the transaction quantity units of measure.

Unit of Measure Conversions


The unit of measure conversions (if any) the Epicor application performs for a transactional quantity entry are
dependent on whether you select a UOM code associated with an On The Fly type UOM Class, system-assigned
standard type (Area, Count, Time, Weight or Volume), or a user-assigned type of Other).
• If you select a UOM code assigned to an On The Fly UOM Class, the Epicor application performs conversions
from the selected unit of measure to the base unit of measure defined for the UOM Class in the UOM Class
Maintenance > Detail sheet.

Epicor ERP | 10.2.600 25


Application Setup Inventory Management Course

Note Refer to the On The Fly Classes - Rules and Setup Example Application help topic for a
detailed example of how this works.

• If you select a UOM code assigned to a UOM Class with a system-assigned standard type, the Epicor application
uses that particular unit of measure as the unit of measure for all related transactions.
Example You select the UOM code for Feet (which is part of the system-assigned standard type Length
UOM Class) as the unit of measure for a quote or order line. The Epicor application uses that unit of
measure for related inventory, job and purchasing transactions (all are expressed in Feet). No conversions
to a base UOM are performed in this case.

Note When you ship the item, you can specify the shipping quantity in an alternate unit of measure,
as long as it is associated with the same UOM Class. In this example, you can express the shipment
quantity in Yards, if it is a valid unit of measure for the Length UOM class.

Workshop - UOM Class Code

In this workshop, create a UOM Class and add the UOM codes you defined in the previous workshop.
Important All UOM codes must first be defined in UOM Maintenance before they are used in other
programs such as UOM Class Maintenance and Part Maintenance. The Epicor application allows a part to
have multiple UOMs.

Create a UOM Class Code


Navigate to UOM Class Maintenance.
Menu Path: Material Management > Inventory Management > Setup > UOM Class

1. From the New menu, select New UOM Class.

2. In the Class ID field, enter XXX-Fluid (where XXX are your initials).

3. In the Description field, enter XXX Fluid Volume (where XXX are your initials).

4. In the Class Type field, select Other.


When you select Other, it allows for creation of user-defined UOM class codes.

5. Click Save.

Add UOM Conversions (English Measurements)


If you use metric measurements, skip this workshop and perform Workshop - Add UOM Conversions (Metric
Measurements) in its place.

1. From the New menu, select New UOM Conversion.

2. In the UOM Code field, select XXX-PN (where XXX are your initials).

3. Verify that the Base UOM and Default UOM check boxes are selected.
When you enter the first UOM code for a given UOM class, the Epicor application automatically selects these
check boxes. The Base UOM check box specifies if this UOM code is the base unit of measure for this UOM
Class; it is normally assigned to the first UOM code entered for a UOM Class. The Default UOM check box
identifies this UOM code as the default unit of measure for this UOM Class.

26 Epicor ERP | 10.2.600


Inventory Management Course Application Setup

4. Click Save.

5. From the New menu, select New UOM Conversion.

6. From the UOM Code field, select XXX-QT (where XXX are your initials).

7. In the Conversion Factor field, select Divide, and then enter .5 in the next field.
This field identifies the factor used to calculate the quantity conversion between the UOM code and the
base UOM. In this case, 1 Quart equals 2 Pints.

8. Click Save.

9. From the New menu, select New UOM Conversion.

10. In the UOM Code field, select XXX-GL (where XXX are your initials).

11. In the Conversion Factor field, select Divide, and then enter .125 in the next field. In this case, 1 gallon
equals 8 Pints (for example, 3 gallons divided by .125 equals 24 pints).

12. Click Save and exit UOM Class Maintenance.

Add UOM Conversions (Metric Measurements)


If you use English measurements, skip this workshop and perform the previous Workshop - Add UOM
Conversions (English Measurements) in its place.

1. From the New menu, select New UOM Conversion.

2. In the UOM Code field, select XXX-ML (where XXX are your initials).

3. Verify that the Base UOM and Default UOM check boxes are selected.
When you enter the first UOM code for a given UOM class, the Epicor application automatically selects these
check boxes. The Base UOM check box specifies if this UOM code is the base unit of measure for this UOM
Class. The Default UOM check box identifies this UOM code as the default unit of measure for this UOM
Class.

4. Click Save.

5. From the New menu, select New UOM Conversion.

6. In the UOM Code field, select XXX-LT (where XXX are your initials).

7. In the Conversion Factor field, select Divide, and then enter .001 in the next field.
This field identifies the factor used to calculate the quantity conversion between the UOM code and the
base UOM. In this case, 1 Litre equals base units of 1000 Militres (for example, 1.25 Litres divided by .001
equals 1,250 Militres).

8. Click Save and exit UOM Class Maintenance.

Epicor ERP | 10.2.600 27


Application Setup Inventory Management Course

Part Class Maintenance

Use Part Class Maintenance to establish part classes for inventory parts. Part classes are not required in the
Epicor application; but use them when it is important to classify inventory materials for reporting purposes. Part
classes are assigned to each part in Part Maintenance.
Example If you have three distinct types of raw materials, establish three part classes to review the stock
status and other inventory reports for the different types.

Menu Path
Navigate to this program from the Main Menu:
• Financial Management > Accounts Payable > Setup > Part Class
• Material Management > Inventory Management > Setup > Part Class
• Material Management > Purchase Management > Setup > Part Class
• Production Management > Engineering > Setup > Part Class
• Production Management > Job Management > Setup > Part Class
• Production Management > Material Requirements Planning > Setup > Part Class
• Production Management > Quality Assurance > Setup > Part Class
• Sales Management > Configurator Management > Setup > Part Class
• Sales Management > Order Management > Setup > Part Class

Workshop - Create a Part Class

In this workshop, create a part class.


Navigate to Part Class Maintenance.
Menu Path: Material Management > Inventory Management > Setup > Part Class

1. From the New menu, select New Part Class.

2. In the Part Class field, enter XXX-F (where XXX are your initials).
You can only add two letters in your name initials. For example, John Smith would enter JS-F.

3. In the Description field, enter XXX Fluid Inventory (where XXX are your initials).

4. In the Buyer field, select Brian Howard and click Save.

5. Click the Approved Suppliers button.


The Approved Supplier Maintenance window displays.

6. From the New menu, select New Approved Supplier.

7. In the Supplier field, search for and select Gecco Steel.

8. Click Save and close the Approved Supplier Maintenance window.

9. In the Negative Quantity Action pane, select Warn.

28 Epicor ERP | 10.2.600


Inventory Management Course Application Setup

This specifies the action the Epicor application should take if transactions against parts in this part class
cause the on-hand quantity of any of the parts to go negative. None denotes that no messages should be
displayed. Stop denotes that an error message should display and processing cannot continue. Warn denotes
that an error message should display, but processing can continue.

10. Click Save and exit Part Class Maintenance.

Product Group Maintenance

Use Product Group Maintenance to set up product groups, which classify the different types of parts you store
in inventory and sell to customers. These classifications are used for General Ledger (GL) and sales analysis
purposes.
Product groups are not required by the Epicor application; however, you may want to use them to help organize
financial and sales analysis reports. For example, if you manufacture two different product lines, you can assign
parts within each line to a specific group. You assign product groups to specific parts using the Group field in
the Part Maintenance > Part > Detail sheet. Product group definition examples include:
• Customer ID (Edwards International)
• Product Line (Televisions)
• Product Type (Configured Parts)
• Any combination of each (Edwards International - Configured Parts)
Product groups define the general ledger account numbers used during Accounts Receivable (AR) invoicing. The
account numbers for Sales, Discounts, and Returns can be defined within each group. You can also use product
groups to define the General Ledger (GL) controls used to capture work-in-process (WIP) and cost-of-sales (COS)
information. If you do not define these GL controls on the product group, however, the GL controls defined
within Company Configuration are used instead.
You can also define an overall planner for each product group. You can also link sites to each product group;
each site detail can specify a planner. Thus, you can define multiple planners for each product group.

Menu Path
Navigate to this program from the Main Menu:
• Financial Management > Accounts Receivable > Setup > Product Group
• Financial Management > Deferred Revenue Accounting > Setup > Product Group
• Material Management > Inventory Management > Setup > Product Group
• Production Management > Engineering > Setup > Product Group
• Production Management > Job Management > Setup > Product Group
• Production Management > Material Requirements Planning > Setup > Product Group
• Sales Management > Configurator Management > Setup > Product Group
• Sales Management > Order Management > Setup > Product Group
• Service Management > Field Service > Setup > Product Group

Part Maintenance

Use Part Maintenance to enter or update part information. Parts are either purchased items you use for raw
materials or subassemblies, or manufactured items you use to fill sales orders.
Each part record contains crucial data you may need for purchase or production needs. A part record contains
general information such as part number, description, and search criteria. Also, a part record defines inventory

Epicor ERP | 10.2.600 29


Application Setup Inventory Management Course

information, which includes unit of measure (UOM) options for sales, purchases, inventory, non-stock classifications,
serial number tracking, and weight values. You also define warehouse and bin information for each part, including
Minimum, Maximum, and Safety Stock quantities. If this part is included in a sales kit, define these parameters
as well.
When you set up a part, all sites within the company can access the part and use it on jobs. You can also select
parts as materials on quote, job, or part methods of manufacturing. If you use the Engineering module, purchased
or manufactured parts on a bill of material must have a record set up in Part Maintenance.
Tip Most modules do not require parts to exist in Part Maintenance, but it is recommended that you enter
parts in this program, as each record requires little data and can save you data entry time later.

Note When you are setting up part records and realize you've made a mistake assigning a UOM Class or
primary inventory UOM code (in the Primary UOMs - Inventory field), you can make manual updates in
Part Maintenance up until the time you enter a transaction for a part. For example, you inadvertently
assigned a primary Inventory UOM code of BX (Box), but intended to assign a UOM code of EA (Each), or
entered an incorrect UOM Class and associated UOM codes.
However, once you have enter a transaction, you can no longer manually change these fields; you must
instead use Part UOM Class Conversion Maintenance, located on the System Maintenance > Utilities
menu. Part UOM Class Conversion Maintenance is intended for use on parts that have had little to no
transactional usage in Epicor ERP. Refer to the Inventory Management - Specialized Processing section
of the course for more details.

Menu Path
Navigate to this program from the Main Menu:
• Material Management > Inventory Management > Setup > Part
• Material Management > Purchase Contracts Management > Setup > Part
• Material Management > Purchase Management > Setup > Part
• Material Management > Supplier Relationship Management > Setup > Part
• Production Management > Engineering > Setup > Part
• Production Management > Job Management > Setup > Part
• Production Management > Material Requirements Planning > Setup > Part
• Production Management > Quality Assurance > Setup > Part
• Sales Management > Configurator Management > Setup > Part
• Sales Management > Demand Management > Setup > Part
• Sales Management > Order Management > Setup > Part
• Service Management > Field Service > Setup > Part
• Service Management > Field Service Automation > Setup > Part

Part Maintenance Sheets

The following are some of the more important sheets in Part Maintenance that directly impact inventory processing
in the Epicor application.

Part > Detail


Use the Part > Detail sheet to set up new part records and to modify the main details of existing part records.

30 Epicor ERP | 10.2.600


Inventory Management Course Application Setup

Part > Revisions > Detail


Use the Part > Revisions > Detail sheet to establish revisions for the current part. You must set up part revisions
if you implement the Engineering module.

Part > UOMs > Detail


Use the UOMs > Detail sheet to view unit of measure (UOM) information and to enter UOM conversion, net
volume. You can also establish Global Trade Item Number (GTIN-14), European Article Number (EAN-8, EAN-13
and EAN-14), and Universal Product Code (UPC-12) product codes for a specific part and UOM. When you enter
or scan these product codes in any Part field, the application replaces it with the associated part number.

Part > Sites > Detail


Use the Part > Sites > Detail sheet to specify site information about the part. This information includes the site
name, associated primary warehouse, ordering information, transfer information, manufacturing information,
and purchasing information.
Parts can be unique by company and site. A part can be labeled as a stocked item in one site and a non-stock
item in another.

Part > Sites > Warehouses


Use the sheets under the Warehouses tab to enter and update warehouse information associated with the
current site. This includes:
• Specifying parameters that designate how material requirements for the part should be replenished in a
specified warehouse, or warehouse bin, using the Kanban or Replenishment Workbench (distribution
replenishment) functions in the Epicor application.
• Designating the default bin that should appear for inventory transactions entered for a part and warehouse.
This becomes the default bin number displayed in the Bin field in Inventory Management programs, and can
be overridden as needed.
• Reviewing on-hand inventory bin quantities for a part in a selected warehouse.
• Entering count parameters for specific parts in specific warehouses. These include setting ABC codes, specifying
cycle count intervals, and quantity, percent, and value tolerances.

Workshop - Create Part Records

In this workshop, create two new purchased parts and add related purchasing details.

Create a Purchased Part


Navigate to Part Maintenance.
Menu Path: Material Management > Inventory Management > Setup > Part

1. From the New menu, select New Part.

2. In the Part field, enter BR-XXX (where XXX are your initials).
The part number contains a series of characters that uniquely identifies this part. If creating a new part,
enter a meaningful identifier for the part number, such as type or measurements.

3. In the Description field, enter XXX Oil Machine (where XXX are your initials).

4. In the Type field, select Purchased.


This indicates if you normally purchase or manufacture this part, or sell it as a sales kit. Type can be used as
a selection criteria on various reports and searches. It does not restrict the use of the part in any way. You

Epicor ERP | 10.2.600 31


Application Setup Inventory Management Course

can select to manufacture any part marked as purchased or manufactured. When a part is flagged as a sales
kit item, the sales kit parameters become available.
• Purchased - These are parts you normally purchase from external suppliers and use as raw materials.
• Manufactured - These are parts you normally manufacture and sell to your customers.
• Sales Kit - These are sales kit parts that are sold together as a sales kit.

5. In the UOM Class field, select XXX Fluid Volume (where XXX are your initials).
This is the active UOM Class you assign to this part number. You can change the assigned UOM Class for
a new part until the time it is used in a transaction of any type (for example, inventory, sales or purchasing).
However, once the part is used in a transaction, this field is disabled; the associated UOM class code can
only be changed using the Part UOM Class Conversion Maintenance program.

6. In the Primary UOMs - Inventory field, select XXX-PN (where XXX are your initials) if you set up English
measurements in the previous Unit of Measure workshops. If you set up UOM codes using Metric
measurements, select XXX-ML (where XXX are your initials).
This is the unit of measure in which this item is normally issued. This becomes the default UOM codes for
this item but you can override it for specific inventory transactions. You can assign any of the UOM codes
associated with the UOM Class specified in the UOM Class field.

7. In the Primary UOMs - Sales field, select XXX-QT (where XXX are your initials) if you set up English
measurements in the previous Unit of Measure workshops. If you set up UOM codes using Metric
measurements, select XXX-LT (where XXX are your initials).
This is the unit of measure in which this item is normally sold or quoted; you can override it for specific sales
or quote transactions.

8. In the Primary UOMs - Purchasing field, select XXX-QT (where XXX are your initials) if you set up English
measurements in the previous Unit of Measure workshops. If you set up UOM codes using Metric
measurements, select XXX-LT (where XXX are your initials).
This is the unit of measure in which this item is normally purchased; you can override it for specific purchase
transactions.

9. In the Sales Unit Price field, enter 5.00.


This identifies the price at which you ordinarily sell this part. You do not need to enter a sales unit price;
you should only enter it if this is a part you sell on a routine basis.

10. In the Group field, select Component Parts.


This identifies the product group to which this part is assigned. A product group classifies groups of finished
goods inventory parts. Product groups are not required in the Epicor application, but you can use them to
classify groups of inventory parts for reporting purposes. Product groups are important because they provide
the following functions:
• Categorizes sold items
• Sorts reports by what is sold
• Directs a revenue stream in the general ledger (GL)

11. In the Class field, select XXX Fluid Inventory (where XXX are your initials).
This identifies the part class to which this part is assigned. The Epicor application uses the part class to
identify various types of inventory parts. Part classes are not required in the Epicor application, but you can
use them to classify inventory materials for reporting purposes.

32 Epicor ERP | 10.2.600


Inventory Management Course Application Setup

12. Verify that the Non-Stock Item check box is cleared.


This check box determines how requirements are satisfied for the part. When you select this check box, it
indicates that this part is not normally stocked within your inventory. Both purchased and manufactured
parts can be either stocked or non-stocked. If you enter a non-stocked part in the Part Master file, its default
description displays (just like stocked items) when you enter the associated part number on an order or a
job.
• If a manufactured part is marked as a non-stock item, this means the part is not normally stocked;
therefore, all requirements are satisfied by jobs. If the requirement is from a sales order, that sales order
is linked to a job that satisfies the demand. If the requirement is from another part (for example, the
current part is a sub-assembly), the demand is satisfied by creating a sub-assembly level on the same job.
• If a manufactured part is marked as a stock item, this indicates all requirements are satisfied from inventory
and creates allocations to pull the material on the date needed. Requirements include any minimum,
maximum, and safety stock levels, as well as requirements from sales orders or other jobs.
• If a purchased part is marked as a non-stock item, this means the part is not normally stocked; therefore,
all requirements are satisfied by purchase orders linked to the job that created the requirement. This
creates a purchasing suggestion for the part.
• If a purchased part is marked as a stock item, this indicates all requirements are satisfied from inventory
and creates allocations to pull the material on the date needed. Requirements include any minimum,
maximum, and safety stock levels, as well as requirements from sales orders or jobs.
• If a sales kit is marked as a non-stock item, this means the part is not normally stocked; therefore, all
requirements are satisfied by jobs. If the requirement is from a sales order, that sales order is linked to
a job which satisfies the demand.
• If a sales kit is marked as a stock item, this indicates all requirements are satisfied from inventory and
creates allocations to pull the sales kit on the date needed. Requirements include any minimum, maximum,
and safety stock levels, as well as requirements from sales orders or other jobs.

13. Select the Quantity Bearing check box.


When you select this check box, it indicates that the Epicor application supports full inventory functionality
for the part. Inventory transactions to and from stock change the inventory balance of the part. Clear the
check box if the Epicor application should not maintain on-hand inventory balance information for the part.
• You can use a non-quantity bearing part in a BOM, and also purchase, sell, or transfer it. The related
transactions, however, will never update on-hand quantity for the part.
• You would typically clear the check box if you were setting up a miscellaneous part that is expensed
upon receipt and so it is not practical to keep accurate inventory levels. Since the part is expensed at
receipt, it does not need to be issued to a job or generate demand.

14. Click Save.

15. Remain in Part Maintenance.

Add Site Details for the Part

1. Navigate to the Part > Sites > Warehouses > Detail sheet.

2. From the New menu, select New Warehouse.

3. In the Warehouse field, select XXX Warehouse (where XXX are your initials).

4. Click Save.

Epicor ERP | 10.2.600 33


Application Setup Inventory Management Course

5. In the Part Maintenance tree view, select the XXX Warehouse warehouse you just added.

6. Navigate to the Part > Sites > Warehouses > Primary Bin sheet.

7. In the Bin field, search for and select bin XXX-Bin (where XXX are your initials).
This designates the default bin that should appear for various inventory transactions entered for this part
and warehouse. This becomes the default bin number that displays in the Bin field in Inventory Management
programs such as Inventory Transfer, and can be overridden as needed.

8. Click Save.

9. Navigate to the Part > Sites > Detail sheet.

10. In the Primary Warehouse field, search for and select XXX Warehouse.
Identifies the primary warehouse for the part in this site. This is the warehouse where the part is typically
manufactured or stocked. The Epicor application uses the primary warehouse as the default in many programs,
such as entry of sales order line items, purchase order line items, and material requirements on jobs. This is
a required field.

11. In the Min On-Hand field, enter 5.


Specifies the minimum amount of inventory that should be on hand for this part.

12. In the Max On-Hand field, enter 20.


Specifies the maximum quantity of inventory that should be on hand for this part. This value is used to alert
you the inventory quantity is too high.

13. In the Safety Stock field, enter 2.


Identifies the part stock quantity that provides some safety against unforeseen problems. You can use the
Time Phased Material Requirements report to review which parts are under their Min On-Hand quantity,
over their Max On-Hand quantity, or are forecasted to drop below their safety stock quantities.
MRP uses this value to generate additional inventory demands when the On-Hand Quantity is less than the
Safety Stock value. It will generate a job suggestion, purchase suggestion, or unfirm job to satisfy this
inventory demand.

14. Select the Re-Order to Max check box.


This indicates that the Epicor application should bring the inventory level for the part up to the Max On-Hand
quantity, or re-order it if the inventory falls below the Safety Stock quantity plus the Min On-Hand quantity.

15. In the Purchasing section, in the Lead Time field, enter 5.


This defines the number of days that pass between the day the purchased parts are ordered from a supplier
and the day the parts arrive at the site. This value is used by MRP to calculate the Order By Date on a purchase
order suggestion. The Epicor application does this by pulling the Need By Date from a demand record, like
a job material, and then subtracting this Lead Time value from it.

16. In the Purchasing section, in the Supplier field, search for and select Gecco Steel.
Use this field to enter the supplier you wish to use on most PO suggestions. You can select the default
supplier and purchase point used on generated PO suggestions on purchased part records. Each part-site
detail record can have two default suppliers. This allows you to set up one supplier for normal purchases
and another supplier for urgent planning.

17. Click Save.

18. Remain in Part Maintenance.

34 Epicor ERP | 10.2.600


Inventory Management Course Application Setup

Approved Supplier Maintenance

Use the Approved Suppliers option on the Part Maintenance Actions menu to establish approved suppliers
for a part, and, if applicable, the customer associated with this supplier. This customer is only linked to the selected
part within this approved supplier entry.

Workshop - Designate Approved Suppliers


Designate A-Z Metals and ABC Metals as approved suppliers for the part you created in the Create a Purchased
Part workshop.

1. From the Actions menu. select Approved Suppliers.

2. From the New menu, select New Approved Supplier.

3. In the Supplier field, search for and select A-Z Metals.

4. In the Part field, verify that BR-XXX (where XXX are your initials) appears as the default.

5. Click Save.

6. From the New menu, select New Approved Supplier.

7. In the Supplier field, search for and select ABC Metals.


ABC Metals appears in the Name field.

8. In the Part field, verify that BR-XXX (where XXX are your initials) appears as the default.

9. Click Save.

10. Close Approved Supplier Maintenance.

11. Remain in Part Maintenance.

Workshop - Create a Multiple UOM Part

In this workshop, create a new part for machine shop oil that is purchased in box increments and used by a single
can.

1. From the New menu, select New Part.

2. Enter the following information (where XXX are your initials):

Field Data
Part XXX-Case
Description XXX Machine Shop Oil
Type Purchased
UOM Class Counted Units
Inventory UOM EA
Sales UOM EA

Epicor ERP | 10.2.600 35


Application Setup Inventory Management Course

Field Data
Purchasing UOM BX
Sales Unit Price 7.50
Class Shop Supplies
Track Multiple UOMs Select

The Track Multiple UOMs check box specifies if inventory balances for this part should be stored in a single
base unit of measure (for example, Each), or if the Epicor application should store and track inventory
balances for the part in multiple units of measure (for example, Each, Feet, Inches). The default value for
this check box is cleared.
Important Do not skip the Track Multiple UOMs check box selection. It is important you select the
Track Multiple UOMs check box as this will impact how the Epicor application stores inventory for this
part. This allows you to store inventory in multiple units of measure, instead of just one. You can
select the check box for any part at any time. Once you select the check box, you can clear it only if
no inventory balances exist on the part. This check box is not available for use for parts flagged as
serial tracked.

3. Click Save.

4. From the New menu, select New Warehouse.

5. Navigate to the Part > Sites > Warehouses > Detail sheet.

6. In the Warehouse field, select XXX Warehouse (where XXX are your initials).

7. Click Save.

8. In the Part Maintenance tree view, select the XXX Warehouse warehouse you just added.

9. Navigate to the Part > Sites > Warehouses > Primary Bin sheet.

10. In the Bin field, search for and select bin XXX-Bin (where XXX are your initials).

11. Click Save.

12. Navigate to the Part > Sites > Detail sheet.

13. In the Primary Warehouse field, search for and select XXX Warehouse.

14. In the Min On-Hand field, enter 5.

15. In the Max On-Hand field, enter 20.

16. In the Safety Stock field, enter 2.

17. Select the Re-Order to Max check box.

18. In the Purchasing section, in the Lead Time field, enter 5.

19. In the Purchasing section, in the Supplier field, search for and select Gecco Steel.

20. Click Save.

36 Epicor ERP | 10.2.600


Inventory Management Course Application Setup

21. Exit Part Maintenance.

Part Tracker

Use the Part Tracker to access current information on parts in the database. This includes information such as
revisions, on-hand quantities, costs, locations, inspection, and planning data.
You can use the Part Search feature to pull multiple part records into the Part Tracker. The tracker displays only
one part at a time. You cannot add or edit records in this tracker.
Numerous sheets are available in the Part Tracker. Many of them are read-only versions of sheets that display in
Part Maintenance. The Part Tracker also pulls in Quality Assurance information for the part.

Menu Path
Navigate to this program from the Main Menu:
• Executive Analysis > Trackers > Part Tracker
• Material Management > Inventory Management > General Operations > Part Tracker
• Material Management > Purchase Contracts Management > General Operations > Part Tracker
• Material Management > Purchase Management > General Operations > Part Tracker
• Material Management > Shipping / Receiving > General Operations > Part Tracker
• Material Management > Supplier Relationship Management > General Operations > Part Tracker
• Production Management > Engineering > General Operations > Part Tracker
• Production Management > Job Management > General Operations > Part Tracker
• Production Management > Material Requirements Planning > General Operations > Part Tracker
• Production Management > Quality Assurance > General Operations > Part Tracker
• Production Management > Scheduling > General Operations > Part Tracker
• Sales Management > Configurator Management > General Operations > Part Tracker
• Sales Management > Customer Relationship Management > General Operations > Part Tracker
• Sales Management > Order Management > General Operations > Part Tracker
• Sales Management > Quote Management > General Operations > Part Tracker
• Service Management > Field Service > General Operations > Part Tracker
• Service Management > Field Service Automation > General Operations > Part Tracker

Epicor ERP | 10.2.600 37


Daily Inventory Processing Inventory Management Course

Daily Inventory Processing

This section of the course reviews inventory transaction processing that takes place during a typical work day.
These transactions include adding and removing items from inventory using processes in the Epicor application.
Quantity Adjustments
You may have to adjust on-hand inventory quantities for part master records either up or down to account for
certain inventory discrepancies or to establish initial inventory balances.
UOM Split/Merge
Inventory quantities expressed in a specific unit of measure (UOM) for a part can be split into one or more alternate
units. Conversely, inventory quantities expressed in several alternate UOMs can be merged into a single UOM
quantity for parts for which the Track Multiple UOMs check box is selected in Part Maintenance
Issue Miscellaneous Material
Miscellaneous parts can be issued from inventory for non-production purposes (for example, for use as a sample
in a trade show).
Issue Materials to Jobs
Stocked material has to be issued to the job that requires it for production. This process is handled on a part-by-part
basis for an assembly or through a mass issue process for multi-level assemblies.
Inventory Returns
Material or assemblies issued from inventory may need to be returned to stock for whatever reason. The return
transaction adjusts on hand quantities as well as inventory values based.
Inventory Transfer
Materials can be moved (transferred) from one bin and to another within the same site.

38 Epicor ERP | 10.2.600


Inventory Management Course Daily Inventory Processing

Quantity Adjustments

Use Quantity Adjustments to adjust on-hand inventory quantities in part master record. You would use this
program on an exception basis to manually adjust inventory quantities to account for certain inventory discrepancies
or to establish initial inventory balances.
Quantity adjustments can be performed only for parts for which the Quantity Bearing check box has been
selected in Part Maintenance. . Adjustment transactions are generated to provide a full audit trail of all quantity
changes made in this program. Select Transaction Log from the Actions menu to review adjustment transactions.

Menu Path
Navigate to this program from the Main Menu:
• Material Management > Inventory Management > General Operations > Quantity Adjustment

Workshop - Quantity Adjustments

In this workshop, create initial inventory balances for the parts you created in the Workshop - Create Part Records,
and adjust the inventory quantity for an existing part.

Enter Initial Inventory Quantities

In this workshop, establish initial inventory balance quantities for each of the parts you created in Workshop -
Create Part Records.
Navigate to Quantity Adjustments.
Menu Path: Material Management > Inventory Management > General Operations > Quantity Adjustment

1. In the Part field, enter BR-XXX (where XXX are your initials) and press Tab.

2. In the Warehouse field, verify XXX Warehouse (where XXX are your initials) defaults.

3. in the Bin field, accept the default of XXX-Bin (where XXX are your initials).

4. In the Quantity field, enter 100.

5. If you set up English measurements in the previous Unit of Measure workshops, verify that XXX-PN (where
XXX are your initials) displays in the UOM drop-down to the right of the Quantity field. If you set up UOM
codes using Metric measurements, select XXX-LT (where XXX are your initials).

6. In the Reason field, select Add New Part.

7. Click the Adjust button.

8. In the Part field, enter XXX-Case (where XXX are your initials) and press Tab.

9. In the Warehouse field, verify XXX Warehouse (where XXX are your initials) defaults.

10. in the Bin field, accept the default of XXX-Bin (where XXX are your initials).

11. In the Quantity field, enter 100 and select a unit of measure of BX (Box) in the drop-down to the right.

Epicor ERP | 10.2.600 39


Daily Inventory Processing Inventory Management Course

12. In the Reason field, select Add New Part.

13. Click the Adjust button.

14. Remain in Quantity Adjustments.

Adjust Miscellaneous Quantity

In this workshop, adjust a quantity for five pieces of the DIAMOND 8907 part, as they are scratched and unable
to be used.

1. In the Part field, enter DIAMOND 8907 and press Tab.

2. In the Quantity field, enter -5 (negative).


A decreased quantity is entered as a negative number to adjust the current on-hand quantity.

3. In the Reason field, select Scratches, Blemishes.

4. Click the Adjust button.


The on-hand quantity has decreased by five.

5. Remain in Quantity Adjustments.

Verify Quantity Adjustments in Part Transaction History Tracker


Using the Part Transaction History Tracker, verify the inventory balance transactions affected by your entries in
Quantity Adjustments.

1. Right click the Part field, then select Open With > Part Transaction History Tracker.
Part Transaction History Tracker displays.

2. In the Part field, enter BR-XXX (where XXX are your initials) and press Tab.

3. Click Retrieve to retrieve and display transaction history for the part.
In the Transaction History grid, verify that ADJ-QTY displays in the Type column and 100 displays in the
Quantity column. This indicates an adjustment to quantity type transaction of 100. If you are using Metric
measurements in the workshops, note that the Epicor application converted the 100 Litres you entered in
Quantity Adjustments to an on hand balance of 10,000, expressed in the base of unit of measure of Militres.

4. Remain in the Part Transaction History Tracker.

5. Repeat steps 1-3, but enter XXX-Case (where XXX are your initials) and press Tab.
In the Transaction History grid, verify that ADJ-QTY in the Type column to indicate an adjustment to
quantity type transaction. In the Quantity column, verify 2,400 displays. This is the 100BX at the base unit
of EA (100BX x 24EA).

6. Repeat steps 1-3, but enter DIAMOND 8907 and press Tab.
In the Transaction History grid, verify that an ADJ-QTY displays in the Type column and -5 displays in the
Quantity column. This indicates an adjustment to quantity type transaction of -5. Note that the quantity
in the Running Total column decreases from 50 to 45.

7. Exit Part Transaction History Tracker and Quantity Adjustments.

40 Epicor ERP | 10.2.600


Inventory Management Course Daily Inventory Processing

UOM Split/Merge

Use Split Merge UOM to split an inventory quantity expressed in a specific unit of measure (UOM) into one or
more alternate units. You can also use this program to merge inventory quantities expressed in several alternate
UOMs into a single UOM quantity. It can only be used for parts for which the Track Multiple UOMs check box
is selected in Part Maintenance.
• For example, for a Split UOM transaction, 100 units on a pallet be broken into one bag (two base units), one
box (four base units), or nine cases (10 base units each or 90 total).
• Conversely, if your inventory is stored in bags and boxes, you can use the Merge option to merge them into
a single pallet of 100 base units.

When you save the transaction, the Epicor application uses the conversion factors defined in UOM Class
Maintenance to determine if the quantities selected for merging or splitting add up to the resulting UOM merge
or split quantity. Entering split or merge transactions has the net effect of zero on the total physical on-hand
inventory quantity for the part. The program updates two or more on-hand tracking part records and creates
STK-ADJ PartTran records to reflect the changes.

Menu Path
Navigate to this program from the Main Menu:
• Material Management > Inventory Management > General Operations > UOM Split / Merge

Workshop - Split Inventory

In this workshop, split a portion of the initial inventory balance quantity you created for the multiple UOM part
XXX-Case (where XXX are your initials) in Quantity Adjustments into multiple alternate units of measure (UOM).
You will split four boxes into a combination of Cases, Dozen packs and individual units.
Navigate to UOM Split/Merge.
Menu Path: Material Management > Inventory Management > General Operations > UOM Split / Merge

1. In the Part field, enter XXX-Case (where XXX are your initials) and press Tab.

2. In the Warehouse field, verify XXX Warehouse (where XXX are your initials) defaults.

3. In the Bin field, verify XXX-Bin (where XXX are your initials) defaults.

4. In the drop-down to the right of the Split field, select a unit of measure of BX (Box).

5. In the Split field, enter 4.


A quantity of 96 displays in the This Transaction field. This is the 4 boxes expressed in the EA unit of
measure (1BX = 24EA). As you select the split quantities and units of measure, the quantity remaining to
be split displays in the Remaining Qty field.

6. In the On Hand Qty grid, in the Quantity column, enter 1 for CS (UOM).

7. In the On Hand Qty grid, in the Quantity column, enter 3 for DZ (UOM).

8. In the On Hand Qty grid, in the Quantity column, enter 12 for EA (UOM).

Epicor ERP | 10.2.600 41


Daily Inventory Processing Inventory Management Course

Note that a quantity of zero displays in the Remaining Qty field. You have successfully split four boxes into
quantities of Cases, Dozen packs and individual units. You cannot save split or merge transactions unless a
quantity of zero displays.

9. Click OK.

10. Remain in Split/Merge UOM.

11. Right click the Part field, then select Open With > Part Transaction History Tracker.
The Part Transaction History Tracker displays.

12. Click Retrieve to retrieve and display transaction history for the part.
In the Transaction History grid, verify the STK-ADJ (stock adjustment) type transactions that were generated
for the UOM split transactions you entered.

13. Exit the Part Transaction History Tracker and UOM Split/Merge.

Issue Miscellaneous Material

Use Issue Miscellaneous Material to enter a miscellaneous issue of parts from inventory.
A transaction history record is created for the part. The transaction type is STK-UKN. For more information on
inventory transaction types, refer to the Inventory Transaction Types List within the Inventory Transactions
Technical Reference Guide.

Menu Path
Navigate to this program from the Main Menu:
• Material Management > Inventory Management > General Operations > Issue Miscellaneous Material

Workshop - Issue Miscellaneous Material

The Vice President of the Sales department needs a sample to take to a trade show he will attend this week.
After a quick check in the Part Tracker, he notes there is a sufficient quantity to take care of this request. In this
workshop, issue miscellaneous material.
Navigate to Issue Miscellaneous Material.
Menu Path: Material Management > Inventory Management > General Operations > Issue Miscellaneous
Material

1. In the Part field, enter BR-XXX (where XXX are your initials) and press Tab.

2. In the Warehouse field, select XXX-Warehouse (where XXX are your initials).

3. In the Warehouse Bins grid, select the XXX-Bin (where XXX are your initials).

4. In the Quantity field, enter 1.

5. In the Reason field, select Marketing Trade Show Samples.

6. In the Date field, verify today's date defaults.

42 Epicor ERP | 10.2.600


Inventory Management Course Daily Inventory Processing

7. Click Issue.

8. Exit Issue Miscellaneous Material.

Epicor ERP | 10.2.600 43


Daily Inventory Processing Inventory Management Course

Backflushing

Backflushing is a process where the Epicor application issues materials on your behalf. Backflushing is very
dependent on labor reporting. When labor is reported against a related operation, material is then added as
detail to the operation.
Backflushing can occur at two different points:

1. When a quantity is reported against an operation and all the prerequisites listed below are in order.

2. At job completion - Job Complete/Close Code Parameters Maintenance allows any unissued material
to be backflushed.

Consider the following when deciding if backflushing can be used in the Epicor application:

Prerequisites
• The Backflush check box must be selected on the Part > Sites > Detail sheet in Part Maintenance.
• A primary warehouse and bin must be defined for the part in the Part Maintenance > Sites > Warehouses
> Detail sheet, and a primary bin must be defined in the Part Maintenance > Sites > Warehouses >
Primary Bins sheet.
• The material requirement must be attached to the job operation.
• A labor quantity must be reported against the job operation.
• Time and Expense Entry must be accurate and timely.
• Serial number and lot controlled inventory items cannot be backflushed.

Backflush Location Logic


In addition to defining primary warehouse and bin locations in Part Maintenance, you can also establish input
and backflush warehouse and bin locations in the Resource Group Maintenance > Detail and Resource Group
Maintenance > Resources > Detail sheets. When backflushing occurs, the Epicor application uses the following
logic to the locations from which inventory is being pulled:

1. The Input Warehouse and In Bin locations in Resource Group Maintenance > Resources > Detail, if
the on-hand quantity is greater than zero.

2. The Input Warehouse and In Bin locations in Resource Group Maintenance > Detail, if the on-hand
quantity is greater than zero.

3. The Backflush Warehouse and Backflush Bin locations in Resource Group Maintenance > Resources
> Detail, if defined.

4. The Backflush Warehouse and Backflush locations in Resource Group Maintenance > Detail, if defined.

5. The primary bin of the job material warehouse, if defined.

6. The first bin of the job material warehouse that has a quantity expressed in the Inventory unit of measure
defined in the Part Maintenance > Part > Detail sheet for the backflushed part.

7. The first bin of the job material warehouse that has a quantity, regardless of unit of measure.

8. The first bin of the warehouse.

44 Epicor ERP | 10.2.600


Inventory Management Course Daily Inventory Processing

Advantages
• Eliminates the need to manually issue material to each job operation where the material is needed. Backflushing
happens, automatically eliminating manual efforts.
• Takes the scrap factor into account when computing the quantity used. The quantity required plus the scrap
factor is backflushed.

Common Mistakes
• Clearing the Backflush check box on a part while transactions are in process. This causes errors in removing
material from inventory.
• Issuing material and then selecting the Backflush check box causes the material to be issued twice.
• Clearing the Backflush check box on a part without running the Time Phased Material Requirements
Report to determine the impact on other assemblies. You will not know the extent of the manual effort
required to issue these parts to jobs.
• Using substitute materials without telling the Epicor application about the substitution. The material called
for on the job decreases while the substitute part is not decreased causing inventory to be incorrect on both
parts.
• Running re-work and not reporting it as re-work. Inventory is reduced by the amount of pieces reported,
while no parts are consumed.
• Labor reporting is not timely; parts are shown in inventory when they have already been consumed.

Backflushing at Job Completion or Closing


Backflushing at job completion or closing is an unconditional backflush. The material does not need to be attached
to an operation and does not need to have the Backflush check box selected in the Part Maintenance > Sites
> Detail sheet.
Job completion is a task performed when all of the parts on a job are produced and the operations are complete.
Job completion should not be confused with job closing. Job completion removes the job from manufacturing
and places it in a queue for accounting as a candidate for closing. The accounting department closes a job once
all the costs are received and recorded.
Job completion performs two important tasks:
• Any unused capacity on the job is removed. The job is no longer displayed on the job scheduling board.
• Any unused material is removed.

Assumptions
There is an unstated assumption regarding backflushing that assumes the amount of material used equals the
standard quantity called for on the job. This assumption is a result of the actual process the backflush follows.
The Epicor application relieves inventory for the quantity per called for on the operation. After the operation is
complete and the quantity produced is recorded, the application processes the backflush.
Business Scenario
Your customer, Addison Inc., placed an order for a quantity of 10 of part DCD-100-SP (Frame Rail). Job 2385
was created for the assembly and final inspection of these parts.
Your employee, Linda Carter, worked on Operation 10 (Assembly) of the job and is now ready to enter her time
in Time and Expense Entry. Backflushing will occur when this operation is marked complete.

Epicor ERP | 10.2.600 45


Daily Inventory Processing Inventory Management Course

Workshop - Complete the Operation with Backflushed Materials

A production employee has completed job operation so she enters time against operation 10 of the below created
job. Materials marked for backflushing must be related to a job operation. Backflushing occurs when the related
operation completes.
Before you test this workshop, let's create a new job and adjust its bill of materials (BOM). You will also create
a new employee record. It is always better to work with fresh set of data.

1. Navigate to Quick Job Entry.


Menu Path: Production Management > Job Management > General Operations > Quick Job Entry.

2. Select the Next Job button.

3. In the Part field, enter DCD-100-SP and press Tab.

4. In the Quantity field, enter 250.

5. Do not select the Engineered, Scheduled, and Released check boxes.

6. Select Save.
A message displays with a new job number.

7. Record the job number_________.

8. To the job message, select OK.

9. Exit Quick Job Entry.

10. Navigate to Job Entry.


Menu Path: Production Management > Job Management > General Operations > Job Entry.

11. In the Job field, enter the recorded job number and press Tab.

12. In the tree view, expand the Materials node.


A single material should display, material SS-125.

13. In the tree view, click on material SS-125.

14. On the standard toolbar, select the Delete icon (X).

15. To the Delete this record? message, select Yes.

16. In the tree view, right-click the Materials node and select Add Material.
The Job Details > Materials > Detail sheet displays.

17. In the Part/Rev field, enter part 516X075B and press Tab.

18. Verify the Backflush check box is selected.

19. In the Qty/Parent field, enter 1 and press Tab.

46 Epicor ERP | 10.2.600


Inventory Management Course Daily Inventory Processing

20. Select Save.

21. In the tree view, right-click the Materials node and select Add Material.

22. In the Part/Rev field, enter part 516LN and press Tab.

23. Verify the Backflush check box is selected.

24. In the Qty/Parent field, enter 1 and press Tab.

25. Select Save.

26. Navigate to the Job sheet.

27. Select the Engineered check box.

28. In the Req By field, select a date two weeks from today.

29. Select the Released check box.


The Schedule Job window displays.

30. Accept the defaults and select OK.

31. Select Save and exit Job Entry.

32. Navigate to Employee Maintenance.


Menu Path: Material Management Inventory Management > Setup > Employee

33. Select New > New ID.

34. In the ID field, enter your name initials.

35. In the Name fields, enter your first, middle (not required), and last names.

36. Select the Shop Supervisor check box.

37. Navigate to the Production Info sheet.

38. In the Shift field, select Morning.

39. In the Expense field, select Assembly.

40. In the Department field, select Assembly Department.

41. Select Save and exit Employee Maintenance.

Navigate to Time and Expense Entry.


Menu Path: Production Management > Job Management > General Operations > Time and Expense Entry

1. In the Employee field, search for and select yourself as the employee.

2. From the New menu, select New Time Detail.


The Time > Daily Time > Detail > Detail sheet displays.

Epicor ERP | 10.2.600 47


Daily Inventory Processing Inventory Management Course

3. In the Job field, enter the above recorded job and press Tab.

4. In the Operation field, select 10.

5. In the Labor Qty field, enter 250 and press Tab.

6. In the Clock In field, enter 8:00 AM.

7. In the Clock Out field, enter 9:00 AM.

8. Click Submit and exit Time and Expense Entry.

Workshop - Review Backflushing Activity

In Epicor ERP, material marked for backflushing are automatically issued to a job once the operation they are
assigned to completes. Use the Job Tracker to review created material transactions.
Navigate to the Job Tracker.
Menu Path: Material Management > Inventory Management > General Operations > Job Tracker

1. In the Job field, enter the job recorded in the last workshop and press Tab.

2. In the tree view, expand the Materials node.


Both materials are marked with a green check. This indicates that they have been backflushed.

3. Navigate to the Job Details > Materials > Material Transactions sheet.

4. In the tree view, select material 516X075B and select the Retrieve button.
The Transaction Quantity column field displays the value of 250. This is the issued quantity.

5. In the tree view, select material 516LN and select the Retrieve button.
The Transaction Quantity column field displays the value of 250. This is the issued quantity.

6. Exit the Job Tracker.

Receipt and Shipment Processing

The receiving process enables you to receive stock goods, manufacturing materials, or subcontract work back to
your location. The shipping process allows you to take existing inventory or manufactured products and distribute
them to customers or other facilities within your organization.

Receipt Processing

Use Receipt Entry to enter the receipt of all inventory and non-inventory materials, and subcontract parts.
• Receipt line items are either purchase order receipts (recorded against a purchase order) or miscellaneous
receipts (material received that is not associated with a purchase order).
• Receipt information updates the purchase order, if any, and creates transactions to update inventory or job
quantities and costs. Receipt entries also generate accounts payable invoice entries.

48 Epicor ERP | 10.2.600


Inventory Management Course Daily Inventory Processing

You use RMA Processing in place of Receipt Entry to receive parts returned by the customer.
Note This section of the Inventory Management course briefly covers receipt processing and its impact
on inventory processing. Shipment and receipt processing is covered in greater detail in the Shipping and
Receiving course.

Menu Path
Navigate to this program from the Main Menu:
• Material Management > Shipping / Receiving > General Operations > Receipt Entry
• System Management > Compliance Management > General Operations > Receipt Entry

Workshop - Receive a Purchase Order

Penn Hardware has shipped a large quantity of part 1032FW (Washer Flat 10/32"), which arrived at the shipping
dock. The remaining three items have been back ordered by the supplier. It is time to create a receipt for the first
portion of the purchase order.
Before we test this workshop, let's create a new purchase order. It is always better to work with fresh set of data.

1. Navigate to Purchase Order Entry.


Menu Path: Material Management > Purchase Management > General Operations > Purchase Order Entry

2. In the PO Number field, enter 4132 and press Tab.

3. Select Actions > Duplicate PO.


The Duplicate PO window displays.

4. Accept the defaults and select OK.

5. Select the Unapproved check box to approve the purchase order.

6. Select Save.

7. Record the purchase order number_________.

8. Exit Purchase Order Entry.

Navigate to Receipt Entry.


Menu Path: Material Management > Shipping / Receiving > General Operations > Receipt Entry

1. From the New menu, select New Receipt.

2. In the PO field, enter the previously recorded purchase order and press Tab.

3. In the Packing Slip field, enter the same purchase order number and press Tab.

4. From the New menu, select New Receipt Line.


The Lines > Detail sheet displays.

5. Click the Line/Rel button and search for and select Line 1 for the purchase order.
Verify the Part field displays 1032FW and the Quantity field displays 98,100.

Epicor ERP | 10.2.600 49


Daily Inventory Processing Inventory Management Course

6. Select the Received check box and select Save.


The green Received indicator displays.

7. Remain in Receipt Entry.


Do not receive the other purchase order lines. These are used in the following workshop.

Workshop - Create a Mass Receipt

Penn Hardware just sent the remaining material for the previously recorded purchase order. It consists of three
different types of small hardware, shipped in quantities of 10,000 each. These materials have just arrived at the
shipping dock. It is time to create a receipt for the remaining portion of the purchase order.
The Mass Receipt option allows you to receive multiple lines on a purchase order at one time and assumes the
lines are received complete. If some of the lines are not received complete, the listing allows changes to the
quantity.
Navigate to Receipt Entry.
Menu Path: Material Management > Shipping / Receiving > General Operations > Receipt Entry

1. From the New menu, select New Receipt.

2. In the PO field, enter the previously recorded purchase order.


This is the same purchase order used in the last workshop.

3. In the Packing Slip field, enter XXXX (where XXXX are the last four digits of your phone number) and press
Tab.

4. Select Save.

5. From the Actions menu, select Mass Receipt.


The Mass Receipts window displays.

6. Select the Select All button.

7. Select the Get All button.

8. Select Process.

9. Select the Received All check box.


The green All Received indicator displays.

10. Select Save.

11. To the Receipt is Compliant message, select OK.

12. Exit Receipt Entry.

50 Epicor ERP | 10.2.600


Inventory Management Course Daily Inventory Processing

Shipment Processing

The shipping process allows you to take existing inventory or manufactured products and distribute them to
customers or other facilities within your organization. This process is structured to be a seamless method that
enables your product to reach customers and other facilities.
You use the following programs to ship inventory to your customers:
• Customer Shipment Entry
• Master Pack Shipment Entry
• Miscellaneous Shipment Entry
Use Customer Shipment Entry to process customer shipments and update sales orders. You can either relieve
inventory or ship directly from a job. To do this, you create pack records. A pack record can contain one or more
detail lines that define the shipping quantities sent out with each pack record.
• If a part ships from a sales order using Customer Shipment Entry, it is standard costed. The Epicor application
creates an STK-CUS type transaction and relieves inventory quantities in the designated ship location.
• If shipped from the work-in-process (WIP) transaction (MFG-CUS), the Epicor application captures the standard
unit cost for the part rather than actual costs from the job. If there are variances between the standard cost
of the part and the actual costs of the job, a MFG-VAR transaction is also created for the remaining WIP
balances.
Note This section of the Inventory Management course briefly covers shipment processing and its impact
on inventory processing. Shipment and receipt processing is covered in greater detail in the Shipping and
Receiving course.

Menu Path
Navigate to this program from the Main Menu:
• Material Management > Shipping / Receiving > General Operations > Customer Shipment Entry
• Service Management > Field Service Automation > General Operations > Customer Shipment Entry

Sales Order Pick List


Use the Sales Order Pick List to display open sales order releases that are due within the date range you select.
This report works much the same as the Job Pick List report for companies which are shipping from stock. It
provides a listing of parts to pull to fill a specific sales order.
The order information displays in a format you can use to pick the quantities to ship. This report also includes all
Pick List comments. The Sales Order Pick List only displays the quantities that have not been shipped yet. The
printed Release Qty is the open quantity; this is equal to the original release quantity less any quantity shipped
to-date. It includes Buy-to-Order parts but does not include drop shipment items.
Tip Release Quantity = Original Release Quantity - Quantity Shipped to Date

The Quantity on-Hand value also displays for your information.

Menu Path
Navigate to this program from the Main Menu:
• Material Management > Inventory Management > Reports > Sales Order Pick List
• Material Management > Shipping / Receiving > Reports > Sales Order Pick List

Epicor ERP | 10.2.600 51


Daily Inventory Processing Inventory Management Course

• Sales Management > Order Management > Reports > Sales Order Pick List

Workshop - Ship a Sales Order

You need to ship 100 units of DCD-300-OR (Steel O-Ring) to Dalton Manufacturing. In this workshop, record
the shipment quantity and create a packing slip record.
Before we test this workshop, let's create a new sales order. It is always better to work with fresh set of data.

1. Navigate to Sales Order Entry.


Menu Path: Sales Management > Order Management > General Operations > Order Entry

2. In the Sales Order field, enter 5186 and press Tab.

3. Select Actions > Order > Copy Order.


The Copy Order window displays.

4. Accept the defaults and select OK.

5. In Sales Order Entry, select Save.

6. Record the sales order number_________.

7. Exit Sales Order Entry.

Create a Pack ID
Navigate to Customer Shipment Entry.
Menu Path: Material Management > Shipping / Receiving > General Operations > Customer Shipment Entry

1. From the New menu, select New Pack.

2. Click Save.
The Pack ID number displays.

Create a Pack Line

1. From the New menu, select New Line.


The Lines > Customer Shipment Entry > Detail sheet displays.

2. In the Order Number field, enter the previously recorded sales order.

3. Click the Line/Rel button, search for and select Line 1 and Release 1 of the sales order, and select OK.

4. In the Our Ship Qty field, enter 10 displays.


If the Our Ship Qty field does not default with 10, enter 10 and press Tab.

5. Verify the Shipped Complete check box is selected.

52 Epicor ERP | 10.2.600


Inventory Management Course Daily Inventory Processing

The line status displays as Complete because enough on-hand quantity exists to ship the full line quantity.
Selecting the check box denotes that the shipment has fully shipped, the parts are no longer considered in
inventory and the shipment is available for invoicing.

6. In the first Warehouse field, verify Main displays.

7. Click the Bin button, then search for and select 01-02-02.
This is the warehouse bin in which the item you are shipping is stored.

8. Select Save.

9. Navigate to the Summary sheet.

10. Select the Shipped check box.


This designates that the pack has been shipped.

11. Select Save.

12. Remain in Customer Shipment Entry.

Print a Packing Slip

1. From the Actions menu, select Print.


The Print Package Slip/Labels window displays.

2. Click Print Preview to preview the packing slip.


The Packing Slip Print window displays.

3. Review the packing slip and exit the Packing Slip Print and Print Packing Slip/Label windows.
The confirmation window displays.

4. Exit Customer Shipment Entry.

Issuing Materials to Jobs

Issuing Inventory Material is the process of moving inventory items from stock to the job.
Once a job is created you must satisfy the demand for material requirements. You order purchased materials and
receive either to the job or to stock - or as a miscellaneous item. Once received, all materials (purchased or
manufactured) are issued to the demand source individually (by part number) or through a mass issue based on
the job pick list.

Cut Lists Report


Use the Cut Lists Report to list the materials that are related to operations within a particular date range.
This report is used to inquire about the material required in a resource or resource group and can help in staging
similar material for manufacturing efficiency.

Epicor ERP | 10.2.600 53


Daily Inventory Processing Inventory Management Course

Menu Path
Navigate to this program from the Main Menu:
• Production Management > Job Management > Reports > Cut List

Pick List for Jobs

Use the Pick List for Jobs to list material requirements for the jobs selected. You can include both inventory and
purchased materials. Inventory materials are listed in a format useful for entering issue quantities directly on the
report.
The Pick List for Jobs is a shopping list of the materials that need to be issued to the job. The pick list assists
warehouse personnel in locating and physically pulling the parts job assemblies require. The efficient use of pick
lists can maximize the speed with which parts are selected to complete a job or job assembly.
Use the Selection sheet to select the report parameters. Use the Filter sheet(s) to select the specific records to
include on the report. For more information, refer to the Filters Overview topic in the Application Help.
Important For more information on how to review any report status you print, preview, or generate, refer
to the System Monitor Overview topic in the Application Help.

Menu Path
Navigate to this program from the Main Menu:
• Material Management > Inventory Management > Reports > Job Pick List
• Material Management > Shipping / Receiving > Reports > Job Pick List
• Production Management > Job Management > Reports > Job Pick List

54 Epicor ERP | 10.2.600


Inventory Management Course Daily Inventory Processing

Workshop - Create a Job Picklist

You create and review the Job Pick List Report to quickly identify the required materials. You include the purchased
materials in the list of material requirements for this job.
Before you test this workshop, let's create a new job. It is always better to work with fresh set of data.

1. Navigate to Quick Job Entry.


Menu Path: Production Management > Job Management > General Operations > Quick Job Entry.

2. Select the Next Job button.

3. In the Part field, enter DCD-100-SP and press Tab.

4. In the Quantity field, enter 500.

5. Select the Engineered, Scheduled, and Released check boxes.

6. Select Save.
A message displays with a new job number.

7. Record the job number_________.

8. To the job message, select OK.

9. Exit Quick Job Entry.

Navigate to Job Picklist.


Menu Path: Material Management > Inventory Management > Reports > Job Pick List

1. Navigate to the Filter > Job sheet.

2. Click the Job button and search for and select the previously recorded job number.

3. Navigate to the Selection sheet and select the Include Purchased Materials check box.

4. From the Standard toolbar, select Print Preview.


The Job Pick List report displays.

5. Review the Job Pick List Report for the job.

6. Close the Job Pick List Report and exit Job Pick List for Jobs.

Epicor ERP | 10.2.600 55


Daily Inventory Processing Inventory Management Course

Issue Material

Use Issue Material to issue material from inventory to a job. This program issues material to a job one part at
a time. To issue all required parts to a job at the same time, use Mass Issues to Manufacturing.
When you issue material to a job, several events occur:
• The IssuedQty and TotalCost values on the job material or assembly record update with the quantity issued
and the extended cost. Extended Cost is calculated as the issue quantity multiplied by the current inventory
Average, Standard, or Last unit cost (depending on the inventory costing method).
• The On Hand quantity and the Allocated quantity for the part in the part master file are reduced by the
quantity issued.
• A transaction history record is created for the part. The transaction type is STK-MTL (job material issue).

Important To use the Manufacturing Execution System (MES) to issue job material, the Advanced Material
Management (AMM) license must be installed in the Epicor application. Once you install this license, you
can define shop employees as Material Handlers in Shop Employee Maintenance; these users can then
issue or move material on the manufacturing center.

Menu Path
Navigate to this program from the Main Menu:
• Material Management > Inventory Management > General Operations > Issue Material
• Service Management > Maintenance Management > General Operations > Issue Material

Workshop - Issue Job Material

The Job Pick List Report showed demand for part DCD-100-SP. In this workshop, issue material to the job by
individual material requirements.
Important An Advanced Material Management (AMM) license must be installed for proper access to the
To Warehouse and To Bin fields in Issue Material. If it is not, warehouse and warehouse bin numbers
appear in each respective field, but the fields themselves are disabled and cannot be accessed. When this
occurs, an Issue Material error appears when you attempt to save the transaction. The Application help for
Issue Material contains a published workaround to use if this occurs.

Navigate to Issue Material.


Menu Path: Material Management > Inventory Management > General Operations > Issue Material

1. In the Job field, enter the previously recorded job and press Tab.

2. In the Assembly field, accept the default value of 0.

3. In the Mtl field, select 10.

4. In the Quantity field, enter 200 and press Tab.

5. Select OK.

6. Exit Issue Material.

56 Epicor ERP | 10.2.600


Inventory Management Course Daily Inventory Processing

Mass Issues to Manufacturing

Use Mass Issues to Manufacturing to quickly issue all planned materials to a job, rather than enter each
transaction individually.
The main advantage of Mass Issue to Manufacturing is that it issues material to all subassemblies at the same
time. Part transactions generated through this program reduce inventory quantities and post material costs to
jobs. This program is useful if your material estimates are accurate.
After you select the parts listed in the Pick List for Jobs report, they can be issued from inventory to the job or
assembly that requires the material. You can do this line by line or with the mass issue function.
When jobs have several raw material requirements, you can use the mass issue function to expedite the issuing
process. The mass issue function works well with job materials not controlled by serial numbers. If the job calls
for lot-tracked or dimension-tracked material, select the appropriate lot number or dimension code when you
process the mass issue. You will receive prompt messages when you save the transaction.

Menu Path
Navigate to this program from the Main Menu:
• Material Management > Inventory Management > General Operations > Mass Issue to Mfg
• Service Management > Field Service > General Operations > Mass Issue to Mfg.

Workshop - Release Job for Mass Issue

You want to mass issue material for part DCD-200-ML, which is a multi-level frame assembly. Most inventory
items are issued from stock one assembly at a time. If the finished good is a multi-level assembly, you can issue
materials to all sub-assemblies at once.
Note For the purpose of the course you will over-issue materials used to manufacture the job's
sub-assemblies. You will returned the over-issued quantities back to stock later in the course.

Before we test this workshop, let's create a new job. It is always better to work with fresh set of data.

1. Navigate to Quick Job Entry.


Menu Path: Production Management > Job Management > General Operations > Quick Job Entry.

2. Select the Next Job button.

3. In the Part field, enter DCD-200-ML and press Tab.

4. In the Quantity field, enter 500.

5. Select the Engineered, Scheduled, and Released check boxes.

6. Select Save.
A message displays with a new job number.

7. Record the job number_________.

8. To the job message, select OK.

9. Exit Quick Job Entry.

Epicor ERP | 10.2.600 57


Daily Inventory Processing Inventory Management Course

Mass Issue Materials to Job


Navigate to Mass Issue to Manufacturing.
Menu Path: Material Management > Inventory Management > General Operations > Mass Issue to Mfg

1. In the Job field, the previously recorded job and press Tab.

2. In the Assemblies grid, in the Assembly column, select assembly 0.


This assembly refers to the DCD-200-ML part. You have to highlight the line in the grid.

3. Select the Include Subassemblies check box.

4. Select the Issue button.


The Issue > List sheet displays.

5. Select the Issue All button.

6. In the Material grid, in the Qty Issued column field, double the quantities for the following materials:

Material From To
SS-125 20 40
SS-179 65 130
BS-CR-RD-150 250 500

7. Select OK.

8. Exit Mass Issue to Manufacturing.

Issue Assembly

Use Issue Assembly to issue an assembly from inventory to a job.


Assemblies can be issued when the job assembly has specified a pull quantity from stock. Because the demand
is for a sub-assembly part, it is different than a typical material requirement. Some of the quantity will be
manufactured through a job, while the rest of the quantity will be pulled from stock. This stock quantity may be
the result of overproduction on another job.
When you issue an assembly to a job, these events occur:
• The IssuedQty and TotalCost values on the job assembly record are updated with the quantity issued and
extended cost. Extended Cost is calculated as the issue quantity times the current inventory Average, Standard
or Last unit cost (depending on the inventory costing method).
• The Onhand quantity and Allocated quantity for the part in the part master file are reduced by the quantity
issued.
• Also, a transaction history record is created for the part. The inventory transaction type is STK-ASM (job
assembly issue). For more information on inventory transaction types, refer to the Inventory Transaction Types
List within the Inventory Transactions Technical Reference Guide.

58 Epicor ERP | 10.2.600


Inventory Management Course Daily Inventory Processing

Menu Path
Navigate to this program from the Main Menu:
• Material Management > Inventory Management > General Operations > Issue Assembly

Receiving Completed Jobs

Once you issue materials to a job, shop employees work on the operations, and you record labor against these
operations, you then finish the production cycle by indicating when production is complete and when the job is
finally finished, or closed.
After you complete the manufacture of items on the job, you can move the completed part quantities to inventory,
or optionally, to another job. You can also move salvaged materials from a job. Salvaged materials are entered
as inventory receipt transactions and reduce the material cost against specific jobs, or to salvage.
Note Refer to the Job Management course for detailed information about creating jobs, reporting
operations completions, labor and other aspects of job management.

Job Receipt to Inventory

Use Job Receipt to Inventory to enter the receipt of manufactured parts into inventory.
After you complete the receipt, the Job Tracker view of the parent job displays a transaction code of MFG-STK
(Manufacturing Receipt to Stock).
When you receive manufactured parts to inventory, several events occur. The on-hand quantity for the part in
the part master file is updated, and the costs are updated. Also, a transaction history record with the job reference
is created for the part.
You do not have to receive parts to inventory before you ship them; you can ship directly out of Work in Process
(WIP). Only receive items to inventory if you are building standard products, or if you have overruns or spares
that you are not able to ship right away.

Menu Path
Navigate to this program from the Main Menu:
• Material Management > Data Collection > Handheld > Material Handling > Job Receipt to Inventory
• Production Management > Data Collection > Handheld > Material Handling > Job Receipt to Inventory
Important This program is not available in Epicor Web Access.

Workshop - Receive Completed Job Quantities to Inventory


100 units of IBM-200-D have been completed on the job that you are about to create and complete. You will
then move the completed units from production floor to inventory.
To move the produced items from production floor to inventory, in this case 100 units, you have to complete a
job first. As it is always better to work with fresh set of data, you will not only create a job, but you also issue
material, report labor, and finally complete it.

1. Navigate to Quick Job Entry.


Menu Path: Production Management > Job Management > General Operations > Quick Job Entry.

Epicor ERP | 10.2.600 59


Daily Inventory Processing Inventory Management Course

2. Select the Next Job button.

3. In the Part field, enter IBM-200-D and press Tab.

4. In the Quantity field, enter 100.


Important Do not select the Engineered, Scheduled, and Released check boxes.

5. Select Save.
A message displays with a new job number.

6. Record the job number_________.

7. To the job message, select OK.

8. Exit Quick Job Entry.

9. Navigate to Job Entry.


Menu Path: Production Management > Job Management > General Operations > Job Entry.

10. In the Job field, enter the above recorded job number and press Tab.

11. In the tree view, expand the Operation node.

12. In the tree view, select Opr:50 OP INSPE and on the standard toolbar select the Delete (X) icon.

13. Do the same for operations 40, 30, and 20.


This is to reduce the number of operations to minimum to manufacture the job quicker.

14. Navigate to the Job sheet.

15. Select the Released check box.


The Schedule Job window display.

16. Accept the default values and select OK.

17. Exit Job Entry.

18. Navigate to Issue Material.


Menu Path: Material Management > Inventory Management > General Operations > Issue Material

19. In the Job field, enter the above recorded job and press Tab.

20. In the Mtl field, select 10.

21. In the Quantity field, enter 2 and press Tab.

22. Select OK.

23. Exit Issue Material.

60 Epicor ERP | 10.2.600


Inventory Management Course Daily Inventory Processing

24. Navigate to Time and Expense Entry.


Menu Path: Production Management > Job Management > General Operations > Time and Expense Entry.

25. Use the Employee ID button to search for and select yourself as the employee.

26. Select New > New Time Detail.


This opens the Time > Daily Time > Detail > Detail sheet.

27. In the Job field, enter the above recorded job number and press Tab.

28. In the Operation field, select 10.

29. In the Labor Qty field, enter 100 and press Tab.
The Opr Complete and Complete check boxes automatically select. This is because you entered the full
job quantity of 100.

30. Select the Submit button.

31. Select Save and exit Time and Expense Entry.

32. Navigate to Job Completion/Closing Maintenance.


Menu Path: Production Management > Job Management > General Operations > Job Closing.

33. In the Job field, enter the above recorded job number and press Tab.

34. Select the Complete check box.


Important DO NOT select the Closed check box.

35. Select Save and exit Job Completion/Closing Maintenance.

Navigate to Job Receipt to Inventory.


Menu Path: Material Management > Inventory Management > General Operations > Job Receipt to Inventory

1. In the From Job field, enter the above recorded job number and press Tab.

2. In the Quantity field, enter 100.

3. Review the From Warehouse and To Warehouse sections defaults.

4. Select OK.

5. Right click the Part field, then select Open With > Part Transaction History Tracker.
The Part Transaction History Tracker displays.

6. Select Retrieve to retrieve and display transaction history for the part.
In the Transaction History grid, verify that a MFG-STK type transaction for a quantity of 100 displays. This
indicates a manufactured receipt to stock transaction type.

7. Exit the Part Transaction History Tracker.

Epicor ERP | 10.2.600 61


Daily Inventory Processing Inventory Management Course

8. Exit Job Receipt to Inventory.

Job Receipt to Job

Use Job Receipt to Job to enter the receipt of manufactured parts to another job.
After the receipt is completed, the Job Tracker view of the parent job displays a transaction code of MFG-WIP
(Manufacturing Receipt to Job).

Menu Path
Navigate to this program from the Main Menu:
• Material Management > Inventory Management > General Operations > Job Receipt to Job

Job Receipt to Salvage

Use the Job Receipt to Salvage program to report receipt of salvaged materials from a job. Salvaged materials
are entered as inventory receipt transactions and reduce the material cost against specific jobs.

Menu Path
Navigate to this program from the Main Menu:
• Material Management > Data Collection > Handheld > Material Handling > Job Receipt to Salvage
• Production Management > Data Collection > Handheld > Material Handling > Job Receipt to Salvage
Important This program is not available in Epicor Web Access.

62 Epicor ERP | 10.2.600


Inventory Management Course Daily Inventory Processing

Job Tracker
Use the Job Tracker to review current information about a selected record. The Job Tracker displays only version
of the primary entry program.

Menu Path
Navigate to this program from the Main Menu:
• Executive Analysis > Trackers > Job Tracker
• Material Management > Inventory Management > General Operations > Job Tracker
• Material Management > Purchase Contracts Management > General Operations > Job Tracker
• Material Management > Purchase Management > General Operations > Job Tracker
• Material Management > Shipping / Receiving > General Operations > Job Tracker
• Material Management > Supplier Relationship Management > General Operations > Job Tracker
• Production Management > Job Management > General Operations > Job Tracker
• Production Management > Material Requirements Planning > General Operations > Job Tracker
• Production Management > Quality Assurance > General Operations > Job Tracker
• Production Management > Scheduling > General Operations > Job Tracker
• Sales Management > Customer Relationship Management > General Operations > Job Tracker
• Sales Management > Order Management > General Operations > Job Tracker
• Sales Management > Quote Management > General Operations > Job Tracker
• Service Management > Field Service > General Operations > Job Tracker

Epicor ERP | 10.2.600 63


Daily Inventory Processing Inventory Management Course

Inventory Returns

Material or assemblies issued from inventory may need to be returned to stock for several reasons. The return
transaction adjusts on-hand quantities as well as inventory values based.
Note Returns are not the same as quantity adjustments. A return is the reverse transaction for something
that was issued out of inventory. A quantity adjustment is made to correct an inventory count.

64 Epicor ERP | 10.2.600


Inventory Management Course Daily Inventory Processing

Return Material

Use Return Material to return material from a job to inventory.


When you return material from a job, several events occur:
• The IssuedQty and TotalCost values on the job material or assembly record are updated with the quantity
returned and extended cost.
• Extended Cost is calculated as the returned quantity times the current inventory Average, Standard or Last
unit cost (depending on the inventory costing method).
• The Onhand quantity and Allocated quantity for the part in the part master file are increased by the quantity
returned.
• A part transaction record is created for the part. The transaction type is MTL-STK (job material return). For
more information on transaction types, refer to the Inventory Transaction Types List within the Inventory
Transactions Technical Reference Guide.

Menu Path
Navigate to this program from the Main Menu:
• Material Management > Inventory Management > General Operations > Return Material

Workshop - Return Items to Stock

Material 516X075B was over-issued so it needs to be returned to stock.


Before you test this workshop, let's create a new job and over issue material. It is always better to work with
fresh set of data.

1. Navigate to Quick Job Entry.


Menu Path: Production Management > Job Management > General Operations > Quick Job Entry.

2. Select the Next Job button.

3. In the Part field, enter DSS-1000 and press Tab.

4. In the Quantity field, enter 2.

5. Select the Engineered, Scheduled, and Released check boxes.

6. Select Save.
A message displays with a new job number.

7. Record the job number_________.

8. To the job message, select OK.

9. Exit Quick Job Entry.

10. Navigate to Issue Material.


Menu Path: Material Management > Inventory Management > General Operations > Issue Material

11. In the Job field, enter the above recorded job and press Tab.

Epicor ERP | 10.2.600 65


Daily Inventory Processing Inventory Management Course

12. In the Mtl field, select 10.

13. In the Quantity field, enter 4 and press Tab.


This the double the required quantity.

14. Select OK.

15. Exit Issue Material.

Navigate to Return Material.


Menu Path: Material Management > Inventory Management > General Operations > Return Material

1. In the Job field, the recorded job above and press Tab.

2. In the Assembly field, accept the default value of 0.

3. In the Mtl field, select 10.

4. Review the Required Quantity and Previously Issued values. As you can see, you've issued two more
units of material DSS-1010 (Mtl 10).

5. In the Quantity field, enter 2.

6. In the Warehouse field, accept the default warehouse.

7. In the Bin field, accept the default bin.

8. Select OK.
You've returned two items back to stock.

9. In the Job field, the recorded job above and press Tab.

10. Review the Required Quantity and Previously Issued values. Both values are now equal (2 and 2).

11. Exit Return Material.

12. To the Save changes before closing? message, select N o.

Mass Return from Manufacturing

Use Mass Return from Manufacturing to return the already issued job material from the job (Production Floor)
back to stock.
When jobs have several raw materials requirements, you can use the Mass Return functionality to expedite the
return process. The mass return function works well with job materials not controlled by serial numbers. If the
job calls for lot-tracked material, select the appropriate lot number when you process the mass return.

Menu Path
Navigate to this program from the Main Menu:
• Material Management > Inventory Management > General Operations > Mass Return from Mfg

66 Epicor ERP | 10.2.600


Inventory Management Course Daily Inventory Processing

Workshop - Mass Return Material from Job

In this workshop, mass return the previously over-issued materials. You over-issued materials in the Workshop
- Release Job for Mass Issue as follows.

Material Should have issued Issued


SS-125 20 40
SS-179 65 130
BS-CR-RD-150 250 500

Navigate to Mass Return from Manufacturing.


Menu Path: Material Management > Inventory Management > General Operations > Mass Return from Mfg

1. In the Job field, enter the job previously recorded in the Workshop - Release Job for Mass Issue.

2. In the Assemblies grid, in the Assembly column, select assembly 0.


This assembly refers to the DCD-200-ML part. You have to highlight the line in the grid.

3. Select the Include Subassemblies check box.

4. Select the Return button.


The Return > List sheet displays.

5. In the Material grid, in the Qty Returned column field, reduce the quantities for the following materials:

Material Previously Issued Qty Returned


SS-125 40 20
SS-179 130 65
BS-CR-RD-150 500 250

6. Select Save.

7. In the Assemblies grid, in the Assembly column, select assembly 0 again.

8. Select the Return button again.


The Return > List sheet displays.

9. Review the Previously Issued column fields.


The quantities are now correct.

Material Previously Issued


SS-125 20.00
SS-179 65.00
BS-CR-RD-150 250.00

10. Exit Mass Return from Manufacturing.

Epicor ERP | 10.2.600 67


Daily Inventory Processing Inventory Management Course

Return Miscellaneous Material

Use Return Miscellaneous Material when you need to return previously issued miscellaneous parts to inventory.
To begin, enter the part number and then select the bin to which you returned the part from the Warehouse
Bins grid.
A transaction history record is created for the part. The transaction type is STK-UKN, which indicates the transaction
is a miscellaneous issue of stock. For more information on inventory transaction types, refer to the Inventory
Transaction Types List within the Inventory Transactions Technical Reference Guide.

Menu Path
Navigate to this program from the Main Menu:
• Material Management > Inventory Management > General Operations > Return Miscellaneous Material

Return Assembly

Use Return Assembly to return an assembly from a job to inventory.


When you return an assembly from a job, several events occur:
• The IssuedQty and TotalCost values on the job assembly record are updated with the quantity returned and
extended cost.
• Extended Cost is calculated as the return quantity times the current inventory Average, Standard or Last unit
cost (depending on the inventory costing method).
• The Onhand quantity and Allocated quantity for the part in the part master file are increased by the quantity
returned.
• A part transaction record is created for the part. The transaction type is ASM-STK (Job Assembly Return). For
more information on inventory transaction types, refer to the Inventory Transaction Types List within the
Inventory Transactions Technical Reference Guide.

Menu Path
Navigate to this program from the Main Menu:
• Material Management > Inventory Management > General Operations > Return Assembly

68 Epicor ERP | 10.2.600


Inventory Management Course Daily Inventory Processing

Inventory Transfer

Use Inventory Transfer to enter inventory transfer transactions within the same site. These transactions track
the movement of inventory parts from one bin and to another.
Important If you need to transfer inventory between sites, you must use Transfer Order Entry.

Menu Path
Navigate to this program from the Main Menu:
• Material Management > Inventory Management > General Operations > Inventory Transfer

Workshop - Transfer Parts

In storing the EAD-400-RED part, the bin cannot hold more pieces. Since you need to store all the parts together,
you select another bin. In this workshop, transfer 10 pieces from one bin to another.
Navigate to Inventory Transfer.
Menu Path: Material Management > Inventory Management > General Operations > Inventory Transfer

1. In the Part field, enter EAD-400-RED and press Tab.

2. In the Quantity field, enter 10 and press Tab.

3. In the From Location pane, in the Bin field, verify 01-01-01 defaults.

4. In the To Location pane, in the Bin field, search for and select bin 01-01-02.

5. Select the Transfer button.

6. Exit Inventory Transfer.

Min Max Safety Mass Update

As an inventory planner, you can use the Time Phased Material Requirements Report to manage minimum,
maximum and safety stock levels for parts in specified sites.
The report selection contains an Exceptions Only section with Below Minimum, Below Safety and Over
Maximum check boxes; when you select these, the report compares the on-hand balance for each selected part
against the quantities contained in the following fields in the Part Maintenance > Part > Sites > Detail sheet:
• Min On-Hand - Specifies the minimum amount of inventory that should be on hand for a part in a designated
site and warehouse.
• Safety On-Hand - Specifies the minimum amount of inventory that should be on hand for a part in a
designated site. It is a "purchasing cushion" limit; the amount you would need to have to cover your
requirements until a shipment arrives from the supplier. If your on-hand quantity falls below this limit, it means
that there is a good chance that you may run out of material before the next shipment arrives.

Epicor ERP | 10.2.600 69


Daily Inventory Processing Inventory Management Course

• Max On-Hand - Specifies the maximum quantity of inventory that should be on hand for this part in this
site. This value is used to alert you that the inventory quantity is too high.
Use Min Max Safety Mass Update to perform regular mass updates to the Min On-Hand, Max On-Hand and
Safety Stock fields for selected parts in the current site in which you are logged. Using this program, you can
perform two types of mass updates to part/site records:
• Recalculation and mass copying of updated Minimum, Maximum and Safety Stock quantities based on usage
history (Sales, WIP or both) in a designated transaction history window.
• Manual update and mass copying of Minimum, Maximum and Safety Stock quantities to selected part/site
records. Using this method, you do not use the available recalculation functions; you simply manually enter
these quantities into Min Max Safety Mass Update, select the parts you wish to copy and then perform the
actual mass copying.
Menu Path: Material Management > Inventory Management > General Operations > Min Max Safety Mass
Update

70 Epicor ERP | 10.2.600


Inventory Management Course Daily Inventory Processing

Workshop - Create Sales Usage History

In this workshop, create and ship a sales order for part XXX-AS-036 (where XXX are your initials) to create sales
usage history when you run the Min Max Safety Mass Update process in an upcoming workshop. This will
help you to better understand how the Min Max Safety Mass Update process utilizes period usage history to
calculate Daily Usage and suggested Minimum On-Hand, Maximum On-Hand, and Safety Stock quantities.
Before you start this workshop, complete the steps below. Using the steps you will create your own part class,
part, and finally you increase the on hand quantities for the created part, so it is in line with the Min On Hand
value. It is always better to work with newly created records.

1. Navigate to Part Class Maintenance.


Menu Path: Material Management > Inventory Management > Setup > Part Class

2. Select New > New Part Class.

3. In the Part Class field, enter XXX (where XXX are your initials).

4. In the Description field, enter XXX Part Class (where XXX are your initials).

5. Select the Inspection Required check box.

6. Select Save.

7. Navigate to the Site > Detail sheet.

8. Select New > New Site.

9. In the Owner Site field, select Main.

10. Select Save and exit Part Class Maintenance.

11. Navigate to Part Maintenance.


Menu Path: Material Management > Inventory Management > Setup > Part

12. In the Part field, enter AS-036 and press Tab.

13. Select Actions > Duplicate.


The Duplicate Part window displays.

14. In the Part field, enter XXX-AS-036 (where XXX are your initials).

15. In the Description field, enter XXX 6061-T6 ALS .036" x 48" x 144" (where XXX are your initials).

16. Select OK.

17. In the Class field, select XXX Part Class (where XXX are your initials).

18. Select Save and exit Part Maintenance.

19. Navigate to Quantity Adjustment.


Menu Path: Material Management > Inventory Management > General Operations > Quantity Adjustment

Epicor ERP | 10.2.600 71


Daily Inventory Processing Inventory Management Course

20. In the Part field, search for and select part XXX-AS-036 (where XXX are your initials).

21. In the Bin field, verify bin 02-01-02 defaults. If it does not, search for and select it.

22. In the Quantity field, enter 300 and press Tab.


This is the minimum on hand quantity for part XXX-AS-036.

23. In the Reason Code field, select Add New Part.

24. Select the Adjust button.

25. Exit Quantity Adjustment.

Navigate to Sales Order Entry.


Menu Path: Sales Management > Order Management > General Operations > Order Entry

1. From the New menu, select New Order.

2. In the Customer field, enter Dalton and press Tab.

3. In the PO field, enter the last four digits of your telephone number.

4. In the Order Date field, enter a date three weeks ago.

5. In the Need By field, enter a date one week ago.

6. In the Ship By field, enter the date one week before the Need By date.

7. Select Save.

8. From the Sales Order field, record the sales order number __________.

9. Navigate to the Lines > Detail sheet.

10. From the New menu, select New Line.

11. In the Part/Rev field, search for and select part XXX-AS-036 (where XXX are your initials).

12. In the Order Quantity field, enter 180.

13. In the Unit Price field, enter 2.00.

14. Select Save.

15. Exit Sales Order Entry.

Ship the Sales Order


Navigate to Customer Shipment Entry.
Menu Path: Material Management > Shipping / Receiving > General Operations > Customer Shipment Entry

1. From the New menu, select New Pack.

2. Verify you are on the Summary sheet.

72 Epicor ERP | 10.2.600


Inventory Management Course Daily Inventory Processing

3. In the Ship Date field, enter a date two weeks before today's date.

4. Select Save.
The Pack ID number displays.

5. Click the Mass Shipment button.


The Sales Order Search window displays.

6. Search for and select the sales order created in the previous workshop (Workshop - Create Sales Usage
History).
The sales order line displays in the Shipment Lines grid.

7. Select the Ship All button.

8. Select the Update button.

9. Select the Shipped check box.

10. Select Save.

Part Class and Part Maintenance Settings

The following fields in the Part Class Maintenance > Detail and Part Maintenance > Part > Site > Detail
sheets support automated calculation and update, by the Min Max Safety Mass Update process, of the Min
On-Hand, Max On-Hand and Safety Stock fields (in the Part Maintenance > Part > Site > Detail sheet) for
selected parts in the current site in which you are logged.
• Include in Calculation (Part Class Maintenance only) - Specifies if the part class, and the part records
assigned this part class, should be included in Min/Max/Safety Stock calculations.
• Exclude Calculation (Part Maintenance only) - Specifies if this part/site record should be excluded from
Min/Max/Safety Stock calculations performed on its assigned part class.
• Include Sales History - Specifies if sales history should be included in calculations for the part class or part/site
record.
• Include Job Materials - Specifies if job material usage history should be included in calculations for the part
class or part/site record.
• History Window - Specifies, in number of days, how far back from the current date the Min Max Safety
Mass Update process should include sales usage in calculations for the part class or part/site record. For
example, if you enter 180, the calculation process includes sales history for the last 180 days before the date
on which it is being run.
• Safety Factor - Specifies the safety stock factor used in the calculations for the part class or part/site record.
This is the percentage of the Min Stock Qty calculated as the safety stock quantity for the part. For example,
if the Min Stock Qty calculated for the part is 30, and you specify 80 in this field, the calculated Safety Stock
quantity is 24 (30 x 80%).
• Max Factor - Specifies the safety stock factor used in the calculations for the part class or part/site record.
This is the multiplier that should be used when calculating a new Max On-Hand quantity for the part, based
on its Min On-Hand and Safety Stock quantities.
• Max Factor: 2
• Minimum On-Hand: 75
• Safety Stock: 90

Epicor ERP | 10.2.600 73


Daily Inventory Processing Inventory Management Course

New Max: ((Minimum On-Hand (75) x Max Factor (2)) + New Safety (90) = 240
• Default Part Lead Time (Part Class Maintenance only) - Default part lead time for the part class if none
exists at the part/site level for the current warehouse. This is the number of days that pass between the day
this part is ordered from a supplier and the day it arrives at the site.
Note When you run the Min Max Safety Mass Update process, the settings, if any, you enter into the Part
Maintenance > Part > Site > Detail sheet for an individual part/site and current warehouse take precedence
over the corresponding settings defined in the Part Class Maintenance > Detail sheet for the part class
assigned to the part record.

Workshop - Update Part Class Min/Max/Safety Mass Update Settings

In this workshop, update part class parameters used by Min Max Safety Mass Update.
Navigate to Part Class Maintenance.
Menu Path: Material Management > Inventory Management > Setup > Part Class

1. In the Part Class field, enter XXX and press Tab (where XXX are your initials).

2. In the Calculate Min/Max/Safety Values pane, select the Include in Calculation check box.
This designates that parts assigned this part class should be included in Min Max Safety Mass Update unless
you designate, in Part Maintenance, that individual parts assigned to this part class should be excluded.

3. Select the Include Sales History check box.


This designates that sales usage history for parts assigned this part class should be included in Min/Max/Safety
calculations.

4. Select the Include Job Materials check box.


This designates that job material usage history for parts assigned this part class should be included in inventory
Min/Max/Safety calculations.

5. In the History Window field, enter 180.


This is number of days Min Max Safety Mass Update should include sales history for when performing
inventory Min/Max/Safety calculations for parts assigned this part class. In this case, it includes sales and job
material usage history for the last 180 days before the date on which it is being run.

6. In the Safety Factor field, enter 75.


This is the percentage of the Minimum quantity that should be used to calculate the safety factor for a part
in this part class.
Example If the Minimum On-Hand quantity for a part is 100, Min Max Safety Mass Update would
calculate a Safety Stock quantity of 75 (100 x 75%).

7. In the Max Factor field, enter 2.


This is a multiplier used to calculate a Max On-Hand quantity based on the Min On-Hand quantity.
Example If the Min On-Hand quantity for a part assigned to this part class is 100, a quantity 200
(Min On-Hand Quantity of 100 x 2) is calculated.

8. In the Default Part Lead Time field, enter 15.

74 Epicor ERP | 10.2.600


Inventory Management Course Daily Inventory Processing

This is the default part lead time used in Min/Max/Safety calculations for parts assigned this part class if the
lead time is not defined for a given part in the Part Maintenance > Part > Sites > Detail sheet.

9. Select Save and exit Part Class Maintenance.

Workshop - Exclude a Part from Min Max Safety Mass Update Processing

Part XXX-CM700 is assigned to the XXX Part Class (where XXX are your initials). You want to exclude it so it
won't display when selecting the XXX Part Class using the Min Max Safety Mass Update process.
Again, you will work with unique and newly created records. Before you test this workshop, you will create a
new part and adjust its inventory quantities.

1. Navigate to Part Maintenance.


Menu Path: Material Management > Inventory Management > Setup > Part

2. In the Part field, enter CM700 and press Tab.

3. Select Actions > Duplicate.


The Duplicate Part window displays.

4. In the Part field, enter XXX-CM700 (where XXX are your initials).

5. In the Description field, enter XXX Aluminum Plate, constrained (where XXX are your initials).

6. Select OK.

7. In the Class field, select XXX Part Class (where XXX are your initials).

8. Select Save and exit Part Maintenance.

9. Navigate to Quantity Adjustment.


Menu Path: Material Management > Inventory Management > General Operations > Quantity Adjustment

10. In the Part field, search for and select part XXX-CM700 (where XXX are your initials).

11. In the Bin field, verify bin 02-01-02 defaults. If it does not, search for and select it.

12. In the Quantity field, enter 100 and press Tab.


This is the minimum on hand quantity for part XXX-CM700.

13. In the Reason Code field, select Add New Part.

14. Select the Adjust button.

15. Exit Quantity Adjustment.

Navigate to Part Maintenance


Menu Path: Material Management > Inventory Management > Setup > Part

1. In the Part field, enter XXX-CM700 (where XXX are your initials) and press Tab.

Epicor ERP | 10.2.600 75


Daily Inventory Processing Inventory Management Course

2. In the Class field, select XXX Part Class (where XXX are your initials).

3. Navigate to the Part > Sites > Detail sheet.

4. Select the Exclude Calculation check box.

5. Select Save and remain in Part Maintenance.

Workshop - Add Min/Max Settings for a Part

In this workshop, define Min/Max/Safety calculation parameters for one of the parts assigned to the XXX Part
Class (where XXX are your initials). These override the settings (if any) you defined in Part Class Maintenance for
this part class.

1. In Part Maintenance, navigate to the Part > Detail sheet.


If you accidently exited Part Maintenance in the previous workshop, launch Part Maintenance and search
for and select the XXX-AS-036 part (where XXX are your initials). If you remained in Part Maintenance as
instructed, do the step two below.

2. In the Part field, enter XXX-AS-036.


The field is located on the Part > Detail sheet.

3. Navigate to the Part > Sites > Detail sheet.

4. In the Calculate Min/Max/Safety Values pane, in the History Window field, enter 90.
This overrides the History Window setting of 180 you defined for the part class assigned to this part.

5. In the Safety Factor field, enter 80.


This overrides the Safety Factor of 75 you defined for the part class assigned to this part.

6. In the Max Factor field, enter 3.


This overrides the Max Factor of 2 you defined for the part class assigned to this part.

7. Verify the Exclude Calculation check box is cleared.

8. Select the Include Sales History check box.

9. Select the Include Job Materials check box.

10. Select Save and exit Part Maintenance.

Workshop - Run Min Max Safety Mass Update

In this workshop, use Min Max Safety Mass Update to recalculate and copy updated Minimum, Maximum and
Safety Stock quantities to selected part/site records assigned to the XXX Part Class (where XXX are your initials).
Again, as to work with new database entries, you will duplicate part AS-048 and increase on hand quantities for
the new part.

1. Navigate to Part Maintenance.


Menu Path: Material Management > Inventory Management > Setup > Part

76 Epicor ERP | 10.2.600


Inventory Management Course Daily Inventory Processing

2. In the Part field, enter AS-048 and press Tab.

3. Select Actions > Duplicate.


The Duplicate Part window displays.

4. In the Part field, enter XXX-AS-048 (where XXX are your initials).

5. In the Description field, enter XXX 6061-T6 ALS .048" x 48" x 144" (where XXX are your initials).

6. Select OK.

7. In the Class field, select XXX Part Class (where XXX are your initials).

8. Select Save and exit Part Maintenance.

9. Navigate to Quantity Adjustment.


Menu Path: Material Management > Inventory Management > General Operations > Quantity Adjustment

10. In the Part field, search for and select part XXX-AS-048 (where XXX are your initials).

11. In the Bin field, verify bin 02-01-02 defaults. If it does not, search for and select it.

12. In the Quantity field, enter 150 and press Tab.


This is the minimum on hand quantity for part XXX-AS-048.

13. In the Reason Code field, select Add New Part.

14. Select the Adjust button.

15. Exit Quantity Adjustment.

Navigate to Min Max Safety Mass Update.


Menu Path: Material Management > Inventory Management > General Operations > Min Max Safety Mass
Update

1. In the As Of Date field, verify today's date defaults.

2. Select the Search (binoculars) icon on the Standard toolbar to launch the Part Class Search window
and search for and select part class XXX Part Class (where XXX are your initials).
• All parts to which the selected part classes are assigned in the Class field in the Part Maintenance >
Part > Detail sheet display in the Parts sheet.
• It excludes any parts in the selected part class for which you cleared the Exclude Calculations check
box in the Part Maintenance > Part > Sites > Detail sheet.
• Alternately, you can search by part number by selecting Search By Part on the Actions menu.

3. In the Parts grid, select part XXX-AS-048 and select the Part Detail sheet (where XXX are your initials).
The Parameters pane displays the previously defined calculation parameters for the XXX Part Class in Part
Class Maintenance (where XXX are your initials).

4. Navigate back to the Parts sheet.

Epicor ERP | 10.2.600 77


Daily Inventory Processing Inventory Management Course

5. In the Parts grid, select part XXX-AS-036 (where XXX are your initials).

6. Select the Part Detail sheet.


The Parameters pane displays the previously defined calculation parameters for this part using Part
Maintenance.

7. Select the Parts sheet again and verify that parts XXX-AS-048 and XXX-AS-036 are selected (where XXX
are your initials).

8. Select Calculate Selected button to perform usage (Sales, WIP, Total and Daily) and proposed Minimum,
Maximum, and Safety Stock quantity calculations for the selected parts.
The This process may update existing values for Proposed Min/Max/Safety. Do you want to
continue? message displays.

9. To the message, select Yes.


The process may take several minutes to complete and the completion cannot be verified in the System
Monitor.

10. On the Parts sheet, select part XXX-AS-036 and select the Part Detail sheet (where XXX are your initials).

11. In the Calculated Usage pane, review the Sales, WIP, Total, and Daily Usage calculations.
You should see the following values:

Field Value
Sales Usage 3.75
WIP Usage 0.00
Total Usage 3.75
Daily Usage 0.06

12. In the Proposed Values pane, review the New Min, New Max, New Safety, and Calculated Usage
calculations.
You should see the following values:

Field Value
New Min 1
New Max 4
New Safety 1
Calculated Usage 3.75

Note The Calculated Usage pane displays values from the Part Maintenance > Part > Sites >
Detail sheet.

13. Remain in Min Max Safety Mass Update for the next workshop task.

78 Epicor ERP | 10.2.600


Inventory Management Course Daily Inventory Processing

Enter Manual Updates and Complete Copying to Part Records


Continue to use the Min Max Safety Mass Update process, but enter manual updates for a part and then
complete copying of the new Minimum On-Hand, Maximum On-Hand, and Safety Stock quantities to
part/site records.

1. Return to the Parts sheet and select part XXX-AS-048 (where XXX are your initials).

2. Return to the Parts Detail sheet.


Notice the Proposed Values pane does not display quantities because there was no usage in that period.
In such situation, you can also use the Min Max Safety Update process to manually update these quantities.

3. In the Current Part Settings pane, in the Minimum field, enter 15.

4. In the Maximum field, enter 30.

5. In the Safety field, enter 10.

6. In the Part Lead Time field, enter 5.

7. Select Save.

8. Return to the Parts sheet

9. In the tree view, select (highlight) the XXX-AS-048 part (where XXX are your initials).

10. Select the Copy All Proposed button.

11. In the Parts grid, right-click part XXX-AS-048 and select Open With > Part Entry (where XXX are your
initials).
Part Maintenance displays.

12. Navigate to the Part > Sites > Detail sheet.

13. Note the updated quantities that display in the Min-On Hand, Max On-Hand, Safety Stock and Lead
Time fields.

14. Exit Part Maintenance.

15. Exit Min Max Safety Mass Update.

Inventory Reporting
The following are key reports in the Inventory Management module:

Epicor ERP | 10.2.600 79


Daily Inventory Processing Inventory Management Course

Time Phased Material Requirements Report

Use the Time Phased Material Requirements Report to link data in the Purchase Management, Job
Management, Order Management, and Inventory Management modules. This report analyzes planned receipts
and requirements for each part to project future inventory balances.
You may find this to be a useful tool in comparing supply against demand. Time-phase can be run for manufactured
or purchased parts. An exception listing can be used to filter the information displayed to parts where supply
and demand are not equal.

Menu Path
Navigate to this program from the Main Menu:
• Material Management > Inventory Management > Reports > Time Phased Mtl. Requirements
• Production Management > Material Requirements Planning > Reports > Time Phased Mtl. Requirements

Inventory Usage Report

Use the Inventory Usage Report to track inventory turns and monthly usage of stock.

Menu Path
Navigate to this program from the Main Menu:
• Material Management > Inventory Management > Reports > Inventory Usage

Material Transaction Detail Report


Use the Material Transaction Detail Report to produce an inventory transaction list created through receipt,
issue, shipping, and adjustment processing. Each inventory transaction is assigned a transaction type you can use
when you filter the report. Refer to the Field topic in the Application Help for a complete transaction type list.
This report includes corresponding legal numbers for part transactions. The legal number is a tracking number
that some countries require.
Note This report includes corresponding legal numbers for part transactions. The legal number is a tracking
number required by some countries.

Use the Selection sheet to select the report parameters. Use the Filter sheet(s) to select the specific records to
include on the report. For more information, refer to the Application Help topic: Filters Overview.

Menu Path
Navigate to this program from the Main Menu:
• Material Management > Inventory Management > Reports > Material Transaction Detail

80 Epicor ERP | 10.2.600


Inventory Management Course Daily Inventory Processing

Stock Status Report


Use the Stock Status Report to review a list of the current quantities and extended costs of all parts in Part
Maintenance. This report is one of the most important inventory reports. It can be run and filtered by warehouse,
part class or part number to list all parts by quantity, unit cost, and extended amounts.

Menu Path
Navigate to this program from the Main Menu:
• Material Management > Inventory Management > Reports > Stock Status

In Transit Stock
Use the In Transit Stock Report to review transfer orders that are in transit between the specified outbound
and inbound locations. It reports the quantity and total cost value of in transit materials for audit purposes; you
can easily view detailed information about materials moving between sites on transfer orders.
When running the report, you can specify "as-of" shipped and received date ranges to limit the amount of
transfer order data. Using these date ranges, you can filter transfer order information to match up with specific
fiscal period date ranges for auditing the cost of in transit materials for reconciliation of inventory values in the
general ledger.
Menu Path: Material Management > Inventory Management > Reports > In Transit Stock

In Transit Stock Reporting


Use the In Transit Stock Report to review transfer orders that are in transit between the specified outbound
and inbound locations. It reports the quantity and total cost value of in transit materials for audit purposes; you
can easily view detailed information about materials moving between sites on transfer orders.
When running the report, you can specify "as-of" shipped and received date ranges to limit the amount of
transfer order data. Using these date ranges, you can filter transfer order information to match up with specific
fiscal period date ranges for auditing the cost of in transit materials for reconciliation of inventory values in the
general ledger.
Menu Path: Material Management > Inventory Management > Reports > In Transit Stock

Epicor ERP | 10.2.600 81


Conclusion Inventory Management Course

Conclusion

Congratulations! You have completed the Inventory Management course.

82 Epicor ERP | 10.2.600


Inventory Management Course Appendix

Appendix

This section consists of documents used during this course, as well as when using the system. Documents included
are:
• Transaction types

Transaction Types

Each time an action occurs that affects inventory, the system makes a transaction to the PartTran file using the
following transaction types. The Material Transaction Details report found in the Inventory Management module
uses these and can be filtered by them.

Adjustments
• ADJ-MTL - Adjustment to job cost material
• ADJ-SUB - Adjustment to job cost subcontract
• ADJ-PUR - Adjustment to purchase cost variance
• ADJ-CST - Adjustment to stock cost
• ADJ-QTY - Adjustment to stock quantity

Discrepant Material Reporting


• DMR-MTL - DMR to job material
• DMR-REJ - DMR to reject
• DMR-SUB - DMR to subcontract
• STK-DMR - Stock to DMR
• SUB-DMR - Subcontract to DMR
• DMR-STK - DMR to stock

Inspection Processing
• ASM-INS - Assembly to inspection
• INS-ASM - Inspection to assembly
• INS-DMR - Inspection to DMR
• INS-MTL - Inspection to job material
• INS-STK - Inspection to stock
• INS-REJ - Inspection to reject
• INS-SUB - Inspection to subcontract
• STK-INS - Stock to inspection
• SUB-INS - Subcontract to inspection

Manufacturing
• MFG-WIP - Manufacturing receipt to job

Epicor ERP | 10.2.600 83


Appendix Inventory Management Course

• MFG-PLT - Manufacturing receipt to site


• MFG-STK - Manufacturing receipt to stock
• MFG-VAR - Manufacturing receipt to variance
• MTL-DMR - Job material to DMR
• MTL-INS - Job material to inspection

Purchasing
• PUR-INS - Purchase receipt to inspection
• PUR-MTL - Purchase receipt to job material
• PUR-STK - Purchase receipt to stock
• PUR-SUB - Purchase receipt to subcontract
• PUR-UNK - Purchase receipt to unknown

Return Material Processing


• RMA-INS - RMA receipt to inspection

Salvage Material Processing


• SVG-STK - Salvage material receipt to stock

Shipments
• MFG-CUS - Shipment of manufacturing job to customer
• MFG-VEN - Shipment of manufacturing job to supplier
• STK-CUS - Shipment of stock to customer

Site
• PLT-ASM - Site to assembly
• PLT-MTL - Site to job material
• PLT-STK - Site to stock

Stock Transactions
• STK-ASM - Stock to job assembly
• STK-MTL - Stock to job material
• STK-PLT - Stock to site
• STK-SRV - Stock to service
• STK-STK - Stock to stock transfer
• STK-UNK - Stock to unknown

84 Epicor ERP | 10.2.600


Inventory Management Course Index

Index
I R
issue assembly 58 return assembly 68
issue material 56 return material 65
issue miscellaneous material 42 return miscellaneous material 68

M
mass issues to manufacturing 57

Epicor ERP | 10.2.600 85


Additional information is available at the Education and
Documentation areas of the EPICweb Customer Portal. To access
this site, you need a Site ID and an EPICweb account. To create an
account, go to http://support.epicor.com.

You might also like