Inventory Management
IM1000 Inventory Management Physical Count Processing
Physical Count Processing Application Overview In just about any Inventory Management package, it is necessary to physically count inventory items periodically to ensure that the theoretical quantity on‑hand figures being used in the package are ...
Feature - Utility to Reset Item PTD/YTD Fields from Location History
Release Date - 5/26/16 The Rest Item PTD from Location History now has the option to also reset the Year-To-Date and Last Year accumulators in addition to the Period-To-Date accumulators. These fields are also reset from the I/M Location History file ...
IM1100 Inventory Management Utilities Setup
Utilities Setup I/M Setup Application Overview I/M Setup, like Company Setup is not an application that you will need to run frequently. Through this application you will answer some questions, the answers to which will be placed in the I/M Control ...
IM1201 Inventory Management Location File Maintenance
Location File Maintenance Application Overview The Location File Maintenance application maintains a convenient table of inventory locations, i.e., places where inventory is stored, such as warehouses or stockrooms. All receivings, issues, and ...
IM1300 Inventory Management Recalculate Reorder Fields
Recalculate Reorder Fields Application Overview The Recalculate Reorder Fields application should be run once every forecasting period. Each time it is run it recalculates the average periodic usage for each item. It also recalculates what the ...
IM1400 Inventory Management Clear Item Accumulators
Clear Item Accumulators Application Overview The Inventory Item File contains eight running totals (accumulators), which need to be cleared, from time to time, such as at the start of a new period or a new year, and this application performs that ...
IM1501 Inventory Management Product Category File Maintenance
Product Category File Maintenance Application Overview The Product Category File Maintenance application maintains a convenient table of inventory item product categories, i.e. grouping similar items together. The category is used on reports, or on ...
IM1601 Inventory Management Material Cost Type File Maintenance
Material Cost Type File Maintenance Application Overview The Material Cost Type File Maintenance application maintains a convenient table of inventory item material cost classifications, i.e. raw materials or finished goods. The material cost type is ...
IMAGESCN Inventory Management Inventory Aging Report
Inventory Aging Report Application Overview The inventory aging report can provide the current inventory data breakdown into multiple aging buckets, like 30, 60, 90, or over 90 days. The period is user definable in Global Setup and can be overridden ...
IMATPGSN Inventory Management Generate ATP File
Generate ATP File Application Overview This process is a feature of the Available To Promise (ATP) enhancement. Generating the ATP file can combine the COP Order Line Item File, PO Order Line Item File, and BOMP Production Order file to generate the ...
IMATPRSN Inventory Management Available to Promise Report
Available To Promise Report Application Overview Information for this report comes from the ATP Open Item file, which merges order information from COP, IM, PO, BOMP, and SFC. Order entry and sales people can use this report to determine future item ...
IMBININV Inventory Management Bin Inventory File Maintenance
Bin Inventory File Maintenance Application Overview This file is updated by the Multi Bin Vertical package. It stores stock and transaction information for each item and bin. If you are not using the vertical package, you disregard this file. Run ...
IMBINMNT Inventory Management Bin File Maintenance
Bin File Maintenance Application Overview This maintenance program defines warehouse bin numbers used by the Multi-Bin Vertical package. All possible bin numbers, including location default bin numbers, that exist at all warehouses must be defined in ...
IMBINTRN Inventory Management Inventory Transfer Processing
Inventory Transfer Processing Application Overview The Inventory Transfer Processing is used to transfer product from one location to another, but can also be used with Multi-bin to transfer product from one bin to another. This is an integral part ...
IMCHGBIN Inventory Management Change Bin No/Pick Seq
Change Bin No/Pick Seq Application Overview The Change Bin No/Pick Seq application allows the user to quickly and easily change the Bin Number/Picking Sequence field in the Item File. This corresponds to field 19 in Item Maintenance. Run Instructions ...
IMEXPTSN Inventory Management Export Item for Take an Order
Export Item For Take An Order Application Overview This process will create or append an ASCII file with item information to be used with Elliott’s Take An Order function. The Take An Order function must be turned on before this feature can be run. ...
IMFRMMNT Inventory Management Item Label Form Setup
Item Label Form Setup Application Overview This allows maintenance to the label form file, which is similar to the invoice form file. You can specify up to 99 forms and set the parameters for each form to your liking. Run Instructions From Inventory ...
IMGENMNU Inventory Management Generate Location History
Generate Location History Application Overview This process will generate history records for all items for each location. Run Instructions From Inventory Menu à Util-Setup à Generate Location History à Generate This will prompt you for a starting ...
IMIMSITM Inventory Management Item Import Utility
Item Import Utility Application Overview The purpose of this utility is to provide an easy way for a third party application to add items into Elliott. It can also be used for transferring the item master records added in a different company or ...
IMITMUDS Inventory Management Item User-Defined Fields Import Utility
Item User Defined Fields Import Utility Application Overview This utility is used to update the Item User Defined fields and descriptions. This includes Item Note 1 – 5, User Amount, User Date and Item Description 1 and 2. The utility can also be ...
IMSUBMNT Inventory Management Substitute Item Class File Maintenance
Substitute Item Class File Maintenance Application Overview This feature allows you to define multiple substitute items in a class instead of one substitute item only. During order entry, if there is insufficient quantity for an item, the system will ...
IMUSRMNT Inventory Management User-Defined Code File Maintenance
User Defined Code File Maintenance Application Overview The User Defined File controls the information printed on the bill of lading forms. The records created in this file will be used in the Item File so that each individual item has clear ...
IMVESMNT Inventory Management Vessel File Maintenance
Vessel File Maintenance Application Overview The Vessel File is part of the Landed Cost process and contains the vessels (boats, ships, transportation modes, etc.) which are used to transport your goods. Each record in the vessel file will hold ...
IMVLSMNT Inventory Management I/M Serial/Lot History File Maintenance
I/M Serial/Lot History File Maintenance Application Overview This is a utility function that lets you correct erroneously posted serial numbers from any of the following Transaction Types: 1. Customer Order Invoice 2. Inventory Trx Issue 3. Inventory ...
Feature - Expanded Selection Parameters for Reorder Advice User Defined CSV Export
Release Date: 6/8/2016 We have expanded selection parameters for the Reorder Advice User Defined export CSV process. We added Include/Exclude Categories, Item Has Attribute, Item Vendor Number, Activity Code, Show Item Qty OH >0, Show Item Qty ...
Change - Update Both Kit Parent and Components Usage
'Release Date: 5/17/2016 Issue with Update Kit Parent Item Usage Before the Elliott 7.56.602 or 8.06.602 release, when a kit was posted in COP sales journal, it was possible the usage of the parent item was not updated. This behavior was based on the ...
Feature - Create Price Code 1 from Item Minimum Price Utility
Release Date: 6/15/2016 This feature gives the user the ability to generate and update price code 1 based on the minimum price field in the Item Master file. The new utility is accessed thru I/M -> Maintenance -> Product Category File. The purpose ...
Change - Available to Promise by Item Report - Add Item Description 2
Release Date: 6/24/16 IM --> Reports, --> Available to Promise reports, -->Print, --> report by Items Added item description 2 to report. Modified Program: IMATPRPT DLM
Feature - Support AR (Attribute) Type in Reorder Advice User Defined CSV Export
Release Date: 6/29/2016 In this enhancement, we added support for a new Type AR (Attribute) to the Reorder Advice User-Defined CSV export. Any Attribute attached to the Item Master can now be included on the exported CSV file. In I/M -> Reports -> ...
Can System Default Item User-Defined Code?
Q - When I add an item, can the system automatically default field "4. User Def Code" to "1"? See sample screen below: A - Yes, you can do so by first defining an item "DEFAULT-ITEM." Set the field "4. User Def Code" to "1." See sample screen below: ...
Feature - Item Label Printing Enhancements
Release Date: 7/12/16 The following are enhancements to the Item Label printing function: 1) If Barcode Printing Setup, Line "23. Allow Entering COP SO# With Item by Item Label" is "N" the only change will be the addition of Category and User-Defined ...
Feature - Ability to Initialize Character Fields During Change Existing Item Import
Release Date 7/18/16 This feature allows the user to initialize certain character fields in the Item Master file when running Inventory Management-> Util-Setup-> Change Existing Item Import. These fields include: Note 1 Note 2 Note 3 Note 4 Note 5 ...
Understanding Status Code at Inventory Transfer Dispatch Screen
Q: Can you explain the Status Code at Inventory Transfer Dispatch Screen? A: The purpose of the "St" (Status) column is a 2 positions codes that indicate the real time status of the batch so user can easily see the current condition without needing ...
IM0101 Inventory Management Item File Maintenance 7
Item Base Data (Screen #1) Item Maintenance Data (Screen #2) Item Manufacturing Data (Screen #3) Item Notes Numeric Item List Alphabetic Item List
How to Run Inventory Stock Status Report for a Certain Date
Release Date: 8/1/2017 Q - I am trying to run an inventory report by location as of 10/31/16. I know that the Stock Status is a live report generally, so I am not sure how I would do this. Is there a way? A - Generally speaking, there are three ...
Feature - Transition to Obsolete
Release Date: 9/13/17 Currently, if an item is marked as obsolete, then Order Entry will not allow the item to be sold. This is controlled through Global Setup -> Cop-Func -> Order Line Item Screen, flag "7. Allow Entry For Obsolete Item in COP Line ...
Item Last Received Date Not Updated When Received from I/M Transaction Processing
Release Date: 09/28/2017 Q - Based on my observation, if we receive item from Inventory Transaction Processing as an "R" (Receiving) type, then the item last received date will not be updated. See sample screen below for the field. Why is that? A - ...
Feature - Zero Item Weight When Using F3 to Copy Item
Release Date: 10/27/2017 In Item File Maintenance, Change mode, at the Item Number field, the user can press the F3 key to copy an item. See sample screen below. Currently, the Copy Item function will copy most of the fields from the original item to ...
Feature - Initialize User-Defined Note, Date and Amount Fields When Using F3 to Copy Item
Release Date: 10/27/2017 In Item File Maintenance, Change mode, at the Item Number field, users can press F3 key to copy an item. See sample screen below. Currently, the Copy Item function will copy most of the fields from the original item to the ...
What Information Is Stored in the Location History (IMLOCHST) Table?
Release Date: 11/27/2017 Many users have noticed the existence of the IMLOCHST (I/M Location History) table and would like to know what information is stored there and how to access it. This document is an attempt to explain what information is ...
Next page