...
Epicor ERP Inventory Management Specialized Processing Course
...
Transaction Types..........................................................................................................................................72
Inventory Management - Specialized Processing Course
This course builds on the basic inventory concepts introduced in the Inventory Management course. It provides detailed information on the use of specialized inventory processing, including part cross referencing, material backflushing, lot / serial number tracking and management of customer and supplier owned inventories.
...
Define the difference between part, supply side, demand side and internal cross referencing.
Create product code, internal, manufacturer, supplier and customer part cross-references.
Understand how material blackflushing operates.
Create and generate lot numbers for inventory tracking purposes.
Establish serial number parameters and masking to standardize the serialization of parts.
Perform Customer Managed Inventory (CMI), Supplier Managed Inventory (SMI) and consignment inventory processing.
Set up and use the Min Max Safety Mass Update.
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:
Customer Managed Inventory
Inventory Management
Job Management
Multiple Warehouse
Order Management
Purchase Management
Shipping Receiving
Supplier Managed Inventory
Supplier Relationship Management
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.
Inventory Management - 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.
Environment Setup
The environment setup steps and potential workshop constraints must be reviewed in order to successfully complete the workshops in this course.
...
Note To refresh your Epicor training data, enter a support ticket in EpicCare and include your site ID.
...
Workshop Constraints
Below is a list of workshops in this course that can be performed only once in each instance of a restored (refreshed) shared database. Where applicable, a detailed explanation of the workshop constraints is documented in the workshop itself.
...
• Workshop - Receive Serialized Materials
Overview
The Inventory Management module contains all information related to an item including costs, quantities, and on-hand requirements.
...
Note Many of the Inventory functions not covered in this course are covered in detail in the basic Inventory Management course. Some of these features are also covered in other Epicor courses.
...
Specialized Inventory Processing
This section of the course discusses specialized inventory management functions the Epicor application.
Part Product Coding and Cross Referencing
You can use Part Maintenance > Part > UOMs > Detail sheet to (optionally) enter product code information for a part and for specific UOM codes. You can also use other part cross referencing functions in Epicor ERP to create relationships between different part numbers defined for the same product. Customers, suppliers, and internal users may use different part numbers to identify the same part; you define as many types of part cross references as needed for all of these situations.
...
For example, UPC bar codes are found on most consumer items purchased in the USA and Canada.
Other product codes are used in various circumstances in different regions but are all similar to the UPC bar code.
Part Product Coding
In the Epicor application, you use the Part Maintenance > Part > UOMs > Detail sheet to (optionally) enter UPC, EAN, GTIN and HIBC product codes for a part and for the inventory UOM (Unit of Measure) code assigned to the part.
...
In the Part field, enter the product code you recorded in the previous workshop, then press Tab. The Epicor application replaces the product code with the cross referenced part number. Likewise, if you had scanned the product code printed on a bar code label, the same processing would take place.
In the Warehouse field, verify Main defaults.
In the Bin field, enter 01-01-01.
In the Quantity field, enter 100.
In the Reason field, select Add New Part.
Click the Adjust button.
Exit Quantity Adjustments.
Part Cross References
Use the part cross referencing functionality in Epicor ERP to create relationships between different part numbers defined for the same product. Customers, suppliers, and internal users may use different part numbers to identify the same part. You can define part cross references as you need for all of these situations.
...
• Demand Side Cross References - Customers often use different part numbers for the same parts you sell to them. Your customers may also have specific serial format requirements for these parts. To accommodate this business need, you can control parts by linking together unique part numbers for customers, with the option to assign an alternate serial mask for serial tracked parts. You can also specify how and on what customer-facing documents these cross references display and print.
Internal Part Cross References
Use Internal Part Cross Reference to create internal cross references for an internal part number. These cross references are used in Part fields throughout the Epicor application. The usability shortcuts of this feature are designed to simplify data entry.
...
In the Part Number field, enter EP-XXX (where XXX are your initials) and press Tab. This is the part you created in Workshop - Create a Part with Product Code References.
Click New. The Internal Cross Reference and Description fields activate for entry.
In the Internal Cross Reference field, enter XXX (where XXX are your initials).
In the Description field, enter Cross Reference for EP-XXX (where XXX are your initials).
Click Save and exit Internal Part Cross Reference.
Manufacturers and Lifecycle Statuses
You also create two types of records that are later used to define qualified manufacturers. These records are manufacturers and lifecycle statuses.
...
Click New.
In the Manufacturer field, enter XXX-IND (where XXX are your initials).
In the Name field, enter XXX Industries (where XXX are your initials).
Click Save.
Exit Manufacturer Maintenance.
Qualified Manufacturer Maintenance
Use Qualified Manufacturer Maintenance to link a manufacturer with a specific internal part. You can indicate that multiple manufacturers are qualified for a part. You can also define one or more cross-reference part numbers for each manufacturer.
...
19. Close the RFQ form and exit the RFQ Print Form window.
20. Exit RFQ Entry.
Supplier Part Cross References
Suppliers, particularly in the electronics industry, often use different part numbers for the parts you purchase. These parts may also be produced through another manufacturer who then provides the supplier (usually a distributor) with these materials; these parts can also use different part numbers.
...
19. Exit Purchase Order Entry.
Customer Part Cross Reference
Use Customer Part Cross Reference as required to create customer part cross references for an internal part number.
...
From the New menu, click New Order.
Click the Customer button, then search for and select International Products.
From the New Menu, click New Line.
Navigate to the Lines > Detail sheet.
In the Part/Rev field, enter EP-XXX (where XXX are your initials)
Verify that INTPR-540 displays in the Customer Part Number field. The customer part number prints on all order forms linked to this sales order, including the Sales Order Acknowledgment and packing slips. You can also enter a new customer part number in this field. When you create a new customer part number on an order line, this number is automatically cross-referenced between both the customer and part records. The next time you create an order line for this customer and part, you can click the Customer Part button to find and select this new number.
Exit Sales Order Entry without saving the order line.
Lot Tracking
The Epicor application tracks lot numbers for incoming raw materials through all stages of production and shipment to a customer. A lot number is a subset of the item definition which is established in Part Maintenance.
...
Use the Part > Lots > Detail sheet to view existing lot numbers for the part or generate new lot numbers on-the-fly.
Workshop - Create a Lot-Tracked Part
In this workshop, create a lot tracked part. Navigate to Part Maintenance. Menu Path: Material Management > Inventory Management > Setup > Part
From the New menu, select New Part.
Enter or verify the following information (where XXX are your initials):
Field
Part Description Type UOM Class Inventory UOM Sales UOM Purchasing UOM
...
XXX-Deburr XXX Deburr Lubricant Purchased Liquid Volume Conversion GAL GAL GAL
Click Save.
Remain in Part Maintenance.
Workshop - Create Lot Attributes
In this workshop, define the lot part attributes.
...
Batch - Select Mandatory to indicate that a batch number is required.
MFG Lot - Select Mandatory to indicate that a manufacturing batch number is required.
Original Mfg Date - Select Mandatory to indicate that an original manufacturing date is required.
3. Navigate to the Part > Lots > Generate sheet. This sheet contains the format for the lot numbers to be generated.
4. In the Prefix field, enter XXX (where XXX are your initials). XXX (where XXX are your initials) are the leading characters for the lot numbers.
5. In the Trailing Date String field, select MMDDYYYY as the date structure.
6. In the Number of Digits field, enter 5.
7. Select the Leading Zeros check box.
Select this check box to indicate that additional zeros are to be added in front of the trailing date string. In the The next generated lot will be field, the next lot number displays.
8. Click Save.
9. Exit Part Maintenance.
Workshop - Create a Purchase Order for a Lot-Tracked Part
In this workshop, create a purchase order for the lot-tracked part created in the Workshop - Create a Lot-Tracked Part. Navigate to Purchase Order Entry. Menu Path: Material Management > Purchase Management > General Operations > Purchase Order Entry
From the New menu, select New PO.
In the Supplier field, search for and select Gecco Steel.
In the Buyer field, select Brian Howard.
Navigate to the Lines > Detail sheet.
From the New menu, select New Line.
In the Part/Rev field, enter XXX-Deburr (where XXX are your initials) and press Tab.
In the Our Quantity field, enter 10.
In the Unit Price field, enter 5 and click Save.
Navigate to the Summary sheet and select the Unapproved check box. The purchase order status changes to Approved.
Click Save and record the purchase order number_____________.
Exit Purchase Order Entry.
Workshop - Receive a Lot-Tracked Part
In this workshop, receive a lot-tracked part created in the Workshop - Create a Lot-Tracked Part. Navigate to Receipt Entry. Menu Path: Material Management > Shipping / Receiving > General Operations > Receipt Entry
...
From the New menu, select New Receipt Line. The Lines > Detail sheet displays.
In the Line field, enter 1 and press Tab.
In the Warehouse field, verify the default of Receiving Area.
In the Bin field, verify the default of RCV-1.
Click the Next Lot button. This generates the next lot number.
Click Save. The Part Lot Attribute Entry window displays.
In the Batch field, enter 27.
In the MFG Lot field, enter Lot 001.
In the Original Mfg Date field, enter today's date and click OK.
In the Lines > Detail sheet, select the Received check box.
Click Save and exit Receipt Entry.
Lot Tracker
The Lot Tracker displays lot information about part records.
...
In Part field, search for and select XXX-Deburr (where XXX are your initials). The Lot Tracker displays.
In Lot field, search for and select the lot number generated in Workshop - Receive a Lot-Tracked Part.
In the Detail sheet, review the Batch, MFG Lot, Original Mfg Date and Lot Costing information associated with the selected lot number.
Navigate to the On Hand sheet.
In the On Hand sheet, review the on hand quantity information associated with the selected lot number.
Navigate to the Transactions sheet.
Click Retrieve to retrieve and display transaction history for selected lot number.
Exit the Lot Tracker.
Part/Lot Where Used Report
Use the Part/Lot Where Used Report to produce a list of all job bills of material that use the specific part and lot.
...
Material Management > Inventory Management > Reports > Part/Lot Where Used
Production Management > Job Management > Reports > Part/Lot Where Used
Serial Number Tracking
Serial number tracking allows for unique identification for each item you use in manufacturing or receive into inventory from manufacturing or purchasing. Serial number tracking meets a very strict standard for product identification. Information captured for each serial number aids in specifying products for recall and help identify defect sources.
...
Serial number tracking is done through the Serial Number Tracker. There you can find such information as which job or order the part belongs to or whether the part was returned. If you find discrepancies in the serial number information, you can modify the tracked information in Serial Number Maintenance.
Application Setup
This section reviews site configurations, company configurations, and maintenance programs related to Serial Number Tracking.
...
Use the Modules > Inventory Management > Serial Tracking sheet in Site Configuration Control to define how the current site, or multiple sites, handles serial number tracking.
Note You should define serial tracking parameters when you create a site. When you turn on serial number tracking, the Epicor application expects serial numbers to be linked or created based on the following controls set at the Site Configuration.
Menu Path: System Setup > Company/Site Maintenance > Site Configuration
Important This program is not available in Epicor Web Access.
You can set the following parameters in Site Configuration Control:
Serial Tracking Options
Record Serial Numbers on Inventory Move
...
Serial Matching Warning - Options include:
Workshop - Select Serial Tracking Site Parameters
Define serial number masking at the site configuration level. Each site in the company can have its own serial number parameters. This workshop provides the opportunity to verify the Main Site settings for Epicor Education. Navigate to Site Configuration Control. Menu Path: System Setup > Company/Site Maintenance > Site Configuration
Important This program is not available in Epicor Web Access.
...
The following are characters are used for mask definition.
Mask Description
^ This represents a mandatory variable that can be any alphanumeric character. For example, if you enter 2^ in a mask, when you create a serial number, the ^ must be replaced by a character (not allowed for generation masks).
<M> This represents the month of the year. The default is the letter M (<M>). The mask character replaces two characters of the serial number (only allowed for auto generation masks).
Serial number masking provides the ability to establish default guidelines for your company's serialization. There are two types of serial number masking:
...
Select the Modules > Materials > Serial Mask Formats sheet.
Verify the following values are entered in the Serial Masks fields:
Exit Company Maintenance.
Maintenance Programs
...
Primary UOMs - Purchasing EA
Click the S/N Format button. Use Serial Number Format to define serial numbers.
In the Base Number Structure pane, select Serial Mask.
In the Serial Mask Options pane, click the Serial Mask button.
Search for and select XXX Class Serial Mask (where XXX are your initials) created in the Workshop - Define the Serial Mask.
Click OK to exit Serial Number Format.
Click Save.
Exit Part Maintenance.
Serialization Processing
This section of the course discusses the serial number tracking processes that take place based on the selections made in the Site Configuration Control > Modules > Inventory Management > Serial Tracking sheet.
...
Adjusted - Serialized item was adjusted out of inventory using Quantity Adjustments or Post Cycle Counts, located on the Actions menu in Count Cycle Maintenance.
• Consumed - Serial number was assigned to a parent serial number using Serial Matching or issued to a WIP job using Mass Issues to Manufacturing, Issue Material or Issue Assembly as a material requirement. In the latter case, no serial matching takes place because lower level serial matching is not enabled for the site.
DMR - Serialized item is currently assigned to a DMR in DMR Processing.
Inspection - Serialized item is currently in Inspection, but not yet processed using Inspection Processing.
Inventory - Serialized item is currently in live Inventory and can be consumed by a work order or picked to a sales or transfer order.
Inreceipt - Serialized item is currently assigned to a purchase receipt line that has arrived at your facilities but has not been flagged as Received (it is currently in the process of being received).
Misc-Issue - Serialized item has been issued using Miscellaneous Material Issue.
Packed - Serialized item is packed for shipment to a customer, but not yet shipped.
Rejected - Assigned when one of the following occurs:
Serialized item is rejected in DMR Processing.
Set to Scrapped in the DMR Processing when serial number updates related to transactions entered into Labor Entry or Kanban Receipt are processed (this sets the Status of the DMR to Rejected and the SerialNo.Scrapped flag in the SNTran table to True).
When a DMR is not being used for the serialized item and it is rejected in RMA Disposition.
Picked - Serialized item is picked for a customer order but not yet packed for a shipment.
RMA - Serialized item was entered as an expected serial number in an RMA, but not yet received.
Shipped - Serialized item was shipped to a customer.
Subshipped - Shipped to a supplier via subcontractor shipment and not yet received back.
Unassign - Serialized item was created for a WIP job but was unassigned from the job after some job activity had already taken place against the serial number.
WIP - Serialized item was assigned to a WIP job currently in process.
Important The values in the fields in the Serial Number Maintenance > Detail sheet depend on the current status of the serialized item. This means that some fields may be blank because they are not applicable to the current status. The status of the serialized item also affects which of these fields can be filled or modified in Serial Number Maintenance.
Tip To update the Status field when it is not enabled, while correctly maintaining traceability, follow these recommended methods:
...
In Serial Number Assignment, enter the job that has the part for which you need to reassign the serial.
Click the Serial Numbers button to access the Select Serial Numbers program.
In the Serial Number field, manually enter the serial number and click Select. This moves the serial number to the Selected Serial Numbers list.
Customer and Supplier Managed Inventories
The Customer and Supplier Managed Inventory provide you the ability to hold, control, and record inventory items owned by a customer or a supplier.
...
This functionality creates new transactions within the Epicor application. The value of the customer inventory items do not display in your general ledger (GL), but they are visible as quantities currently in stock. When you consume supplier stock and effectively receive these items, the items display in your GL. When you stock these types of items, both the supplier managed inventory and the customer managed inventory bin types can be set up for operational purposes.
Non-Standard Bin Types
You use the Type field in the Warehouse Bin Maintenance > Detail sheet to designate 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.
...
8. Close Warehouse Bin Maintenance and exit Warehouse Maintenance.
Supplier Managed Inventories
When you designate a warehouse bin as Supplier Managed, you also indicate the specific supplier for which inventory stored in that bin is being held and controlled. This provides your supplier with the ability to store their product in a host facility.
...
From the New menu, select New Receipt Line. The Lines > Detail sheet displays.
In the Line field, enter 1.
In the Rel field, enter 1.
In the Warehouse field, verify Supplier Managed Inventory displays.
Click Bin, then search for and select NOR-RECV.
In the General sub-sheet at the bottom of the window, verify 0.00 displays in the Unit Cost field.
Note Even though you entered a unit price on the purchase order line, the receipts for the line item into a Supplier Managed bin are costed at zero and do not impact the General Ledger (GL). The
...
In the PO Number field, enter the purchase order number you created in Workshop - Create a Supplier Managed Purchase Order.
Navigate to the Receipts sheet.
Click Retrieve to retrieve and display receipt history for the purchase order. In the PO Receipts grid, verify the original receipt of 10 units on the supplier managed purchase order.
Exit the Purchase Order Tracker.
Customer Managed Inventories
When you designate a warehouse bin as Customer Managed, you also indicate the specific customer for which inventory stored in that bin is being held and controlled. Use of customer managed inventory is intended for use by supply chain or distribution users that store inventory on behalf of a specific customer, and then performs the required logistics processing to distribute these stored items to the customers of their customer.
...
15. Exit Customer Shipment Entry.
Consignment Inventory
A Consignment Inventory system gives you the ability to manufacture stock for a customer prior to a sales order being created. You are then able to hold ship the stock and hold it at another location. This is done only after a consignment agreement between you and your customer is created.
...
Note Throughout the entire consignment process, the consignment part is still an asset of the manufacturer/distributor. Upon invoice of the sales order for the consignment part, the part becomes a customer's asset.
...
Application Setup
This section reviews site configurations and maintenance programs related to Consignment Inventory.
...
After you set up your part in your consignment site and verify that is correctly identified as a transfer item from the main manufacturing site, you then create MRP forecasts for the customer consignment part. The forecasts are for inventory that is intended to be consumed from the consignment site, not the main manufacturing site.
Consignment Inventory Processing
After the creation of the consignment site, warehouse, and bins, the application is ready to process consignment inventory. You use Material Requirements Planning, transfer orders, and sales orders to create the consignment process. The process flows through MRP, to the creation of the product, shipment and receipt of the product, and finally the consumption. The manufacturer/distributor is the party responsible for ensuring the count of the consignment inventory.
...
After the MRP process completes, and the consignment stock is made, a it displays a Suggested Transfer Order displays in Time Phase Iquiry. You then shipment the consignment stock to the consignment location as a transfer within inventory locations. The manufacturer and distributor is still fiscally responsible for the consignment stock. Once the customer acknowledges the new stock for their consignment site through an informal confirmation, you receive the transfer order in Receive Transfer Order. The consignment part moves out of transit and into the site
Important This is neither a customer shipment nor a transfer of ownership. This is a transfer within the manufacturer's sites.
...
In order to be able to either cycle count, or physically count the consignment stock, it is essential that you still have access to the consignment stock.
Conclusion
Congratulations! You have completed the Inventory Management - Specialized Processing course.
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.
...
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
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.