Inventory Management
Feature - Prevent Excel from Dropping Leading Zeroes in CSV Item Number Field
Release Date - 1/4/18 When exporting Elliott's item numbers to CSV through Elliott-provided reports with a CSV export option, the leading zeroes will be dropped when the file is opened with Excel. For example, when opening the CSV in Excel, item ...
Feature - Added User ID to User Defined CSV Export
Release Date - 01/29/18 The User-Defined CSV Export option has been added to I/M-> Reports. Users can now grant/deny access to this application from Password Setup. When running the application from this location in the menu system, the User-ID ...
Feature - Support GTIN Based on Two Different UPC Codes
Date Released - 7/27/16 The purpose of this feature is to allow the user more flexibility when setting up GTIN codes. GTIN (Global Trading Item Number) is a 14-digit UPC code with the package code as the first digit + a 13-digit UPC code. For a ...
Feature - Update Estimated Date/Time When Printing Transfer Tickets
Release Date - 8/4/16 This feature gives the user the ability to review and change the estimated date and time on Inventory Management transfer batches when transfer tickets are printed. This feature is enabled through Util-Setup-> Global Setup-> ...
Feature - Allow Physical Count Tag Import Without Serial Number
Released Date: 10/25/2010 In I/M -> Processing -> Physical Count Processing -> Utility -> Import Physical Count Tag, we will require the user to provide a CSV file with the following columns: (A) Location (Can Be Blank) (B) Bin Number (Required If ...
Feature - Delete Kit Components When Item Activity Code is Set to 'O'
Release Date: 8/12/16 A new feature has been added to allow the user the option of deleting kit components when a kit item activity code is changed to"'O" through: 1. Item maintenance IM --> Maintenance --> Item file 2. Obsolete Item update IM --> ...
Feature - New QTYAVAILBYCOMP Attribute Fields
Release Date - 9/2/16 The QTYAVAILBYCOMP, QTYAVAILBYCOM2, and QTYAVAILBYCOMP3 attributes can be used to decide whether or not there is enough stock to ship or produce a parent item. If not, the attribute fields contain information on when the parent ...
Feature - Allow GTIN Maintenance in I/M Change Bin No/Pick Seq Processing
Released Date: 09/13/2016 Global Trading Item Number (GTIN) is a 14-digit UPC code that consists of a 1-digit package code + 12-digit UPC code + 1-digit checksum. Elliott supports GTIN maintenance through Item File Maintenance. Some users have said ...
Feature - Improvements to Reorder Advice Reports
Release Date: 12/6/16 Multiple changes to the User Defined CSV Export and the Standard Reordering Advice CSV Export. Added Item User Amount and Item User Date fields to the User Defined CSV Maintenance. Added Kit item as selection item to the ...
What Is the Difference Between INV_TRX_UN_COST and INV_TRX_NEW_AVG_COST in IMINVTRX Table?
Q - What is the difference between these two fields in the IMINVTRX table? INV_TRX_NEW_UN_COST INV_TRX_NEW_AVG_COST Periodically, we lower the average cost for closeouts and make a G/L entry for the loss in value. I am trying to find the historical ...
Feature - Added a Function "Create Inventory Trx CSV Import"
Release date: 12/29/2016 Updated: 2/21/2017 Updated: 4/25/2017 Updated: 5/2/17 Added a function to IM / Maintenance / Item file / Create / Create Inventory Trx CSV Import to automate the receipt of inventory items thru returned inventory. This ...
Feature - Added Support to “Create I/M Trx CSV Import” for Kit Items
Release Date: 3/29/17 Added a new feature to “Create I/M Trx CSV Import” for Kit items. If the following flag in Global Setup-> Dist -> I/M Global Control, Screen 3: 16. Use Kit Components in Create I/M Trx CSV Import is set to "Y" as follows: the ...
Feature - Improvements to QTYAVAILBYCOMP and QTYAVAILBYCOMP2 Attributes
Release Date: 3/29/2017 Two improvements have been made to Atrribues. 1) For attribute QTYAVAILBYCOMP, the BOM Active Group will show if it has a value; even if the BOM Qty Avail is 0. 2) For attribute QTYAVAILBYCOMP2, a new field has been added -- ...
Feature - Add Desc2 Column to Item Linkage CSV Report
Release Date: 4/19/2017 In I/M -> Reports -> Item Linkage CSV Report, the Desc2 column is now added to the exported CSV file. See sample screen below. The following columns are supported in the CSV file: Item# - Item number Desc - Item description 1 ...
Feature - Added 1C and LD Column Types to Reordering Advice User Defined CSV Export
Release Date: 5/3/2017 Multiple changes have been made to the Reordering Advice User Defined CSV Export programs. You can access this feature from I/M -> Reports -> Reordering Advice Reports -> User Defined CSV Export / Maintenance. The system now ...
What's the Difference Between Lead Time & Planning Lead Time?
Q - We're in the process of using ATP and noticed on the Item File that there are two fields: one is Lead Time and the other is Planning Lead Time. We checked the documentation and it looks like Planning Lead Time is used in any MRP generation, but ...
Explanation of ATP LP Type - Negative Sign (-) vs (*) Symbols
Release Date: 5/17/17 Q - For the ATP (Available to Promise) processing screen, can you advise what the “ * “ (asterisk) symbol means next to the 792*? Also, why do some LPs have the ” - “ (negative sign) and some are blank. See sample screen below: ...
Introduction to Available to Promise (ATP)
Release Date - 6/12/17 What is ATP? ATP (Available to Promise) is an Elliott database that merges all future transactions like sales orders, purchase orders and production orders. It expands the simple quantity allocated and quantity on order ...
IM0000 Inventory Management Package Overview 1
Overview Package Overview How To Use This Manual When most people receive a new product, they want to use it right away. Unfortunately, this is not quite possible when dealing with computer hardware and software. This manual is intended to serve as a ...
IM0000 Inventory Management Package Overview 2
Changing Inventory Cost Methods If you wish to change the method by which you value your inventory you must use one the following procedures depending on what method you are using now and which method you want to change to. Use the following ...
IM0000 Inventory Management Package Overview 3
Reports Usage Exceptions Report Allows you to choose a particular inventory class (A, B, or C), which is defined and entered in Item File Maintenance, and to have a report printed for that class showing all items which have varied from the forecast ...
IM0000 Inventory Management Package Overview 4
Startup Setup Procedure In order to begin using the Inventory Management system, the following steps must be completed after Company Setup and the Inventory Files have been initialized through the File Utilities application. For extensive ...
IM0000 Inventory Management Package Overview 5
Allocation Examples EXAMPLE 1: In this example, both COP and BOMP are set to "Y" in the Company File. The "Process Non-Stk Parents in BOMP" flag is set to "N" in the I/M Setup File. The product structure below shows quantities prior to entering a COP ...
IM0000 Inventory Management Package Overview 6
Global Setup Application Overview The Inventory Management module has many features and options that not all companies may need. Rather than set these up by default, we give you the option of “Pick & Choose” that which can increase your functionality ...
IM0000 Inventory Management Package Overview 8
Multi-Bin Concept One Step vs. Two Step Processing Before Elliott 7.3, the system only supported One Step processing for Multi-Bin. In Elliott 7.3, we support either one step or two step processing. Two Step means we will utilize Receiving, Shipping ...
IM0000 Inventory Management Package Overview: Index
Due to the size of the document entitled "IM0000 Inventory Management Package Overview," we have separated it into several sections within the Knowledge Base. Listed below is an index listing topics contained in each section, as well as a link to ...
IM0101 Inventory Management Item File Maintenance 1
Maintenance Item File Maintenance Application Overview Any inventory system, whether it is manual or computerized, must have some way of recording what parts are in inventory, and in what quantity. In fact, this record of what is in inventory is the ...
IM0101 Inventory Management Item File Maintenance 2
Forecasting Forecasting accurately how much of an item you are going to need at some point in the future can be very important to a company's profits. If the forecast for an item is too high, too much of it may be produced and then have to be kept in ...
IM0101 Inventory Management Item File Maintenance 3
Physical Inventory And Cycle Counting A physical inventory is the process of getting an actual count of how many of every inventory item is currently in stock. For some companies, the process of taking a physical inventory entails closing down the ...
IM0101 Inventory Management Item File Maintenance 4
Entry Field Descriptions Base Data - First Screen Name Type and Description 1. Item No 15 alphanumeric characters. Enter the item number, which will be used to identify the item. This item number can contain alphanumeric characters, and/or numeric ...
IM0101 Inventory Management Item File Maintenance 5
Management Data ‑ Second Screen Name Type and Description 37. Commsn Method 1 alphabetic character. If calculate commission type is by item in Customer Order Processing then this field determines how the commission is calculated for each item. The ...
IM0101 Inventory Management Item File Maintenance 6
Manufacturing Data - Third Screen This information will only be displayed if the I/M Setup manufacturing flag is set to Y. Name Type and Description 70. Average Error A standard quantity format. This is the average deviation between the forecasted ...
IM0101 Inventory Management Item File Maintenance 8
Inquiry Item File Inquiry Application Overview Many occasions may arise where you will want to quickly inquire into the Inventory Item File. Item File Inquiry gives you a rapid procedure to display on the screen all or a portion of an Inventory Item. ...
IM0101 Inventory Management Item File Maintenance: Index
Due to the size of the document entitled "IM0101 Inventory Management Item File Maintenance," we have separated it into several different files within the Knowledge Base. What follows in an index listing the contents of each file, along with a link ...
IM2400 Inventory Management Inventory Transaction Processing 1
Processing Inventory Transaction Processing Application Overview The Inventory Transaction Processing application records several types of transactions that effect inventory. The I/M package offers the flexibility of two ways of recording those ...
IM2400 Inventory Management Inventory Transaction Processing 2
Entry Field Descriptions Top Screen Entries The first three fields entered determine what further data will appear on the screen. Name Type and Description 1. Trx Type 1 alphabetic character. Only the letters R, T, or I are allowed. R stands for ...
IM2400 Inventory Management Inventory Transaction Processing 3
Batch Processing If batch processing is selected, the application will record receivings, transfers, issues, and adjustments of inventory. When transactions are entered, they are stored in the Inventory Transaction File. Distributions to G/L are ...
IM2400 Inventory Management Inventory Transaction Processing 4
Entry Field Descriptions Top Screen Entries The first three fields entered determine what further data will appear on the screen. Name Type and Description 1. Item No 15 alphanumeric characters. Enter the item number of the item to be effected by the ...
IM2400 Inventory Management Inventory Transaction Processing 5
Issue Screen If you have entered I for Issue Type, the following fields will appear. Name Type and Description 5. Location 2 alphanumeric characters. This is the location, as listed in the Location File, from which items are being issued. Press the ...
IM2400 Inventory Management Inventory Transaction Processing 6
Layer Adjustments For Lot Items If the item has lot numbers, the following fields will appear: Name Type and Description 6. Lot No 15 alphanumeric characters. Enter the lot number of the item being adjusted. Press the F7 key to search for lot numbers ...
Next page