Inventory Management
Feature - Reorder Advice/User Defined CSV Export Example 2 - ATP (Available to Promise)
Release Date: 08/07/2020 Version: 8.0 & Up Example 2 - ATP (Available to Promise) ATP is a major feature in Elliott that is used to project future inventory balance. The idea of ATP is that the Qty Allocated (or what we call requirement) is a lump ...
Feature - New Item Import Through CSV File
Program Original Release Date: 05/15/2007 Document Release Date: 08/21/2020 Version: 7.5 & Up The feature can be accessed in I/M, Utility, and New Item Import. It allows you to import new items from either an ASCII or CSV file. This document only ...
Feature - Addition of TOR, QtyOH, OHValue to Stock Status Inquiry
Release date 9/3/2020 Version 8.5 & Up The purpose of this feature is to evaluate how planners manage the inventory in the past and the foreseeable future. For this reason, we added the following new columns to Stock Status Inquiry -> Location ...
Feature - Addition of Kit and BOMP Component Counts in QTYAVAILBYCOMP2 Attribute
Release date: 9/9/2020 Version: 8.5 and Up In Global Setup -> Utilities -> I/M utilities -> Generate Statistic Info -> Generate -> Update Qty Avail. by Comp Attribute, we have added new values for: # in Kit as Component (number of times an item ...
Feature - Add Stocking UOM Variable to ADDITEM Event in Item File Maintenance
Release Date: 09/15/2020 Version: 8.5 & up The purpose of this feature is to add support of the Item Stocking Unit of Measure variable in ADDITEM event when the user adds an item through Item File Maintenance, or copies an item. The ADDITEM event is ...
Feature - Added an Est End (Estimated End) to the BOMP Operator File Inquiry Screen
Release date: 9/17/2020 In BOMP--> Inquiry --> Operator Inquiry, we have added an Est End (Estimated End) field to the BOMP Operator file inquiry screen. This field will be displayed in military time or text descriptions if the time does not occur in ...
Elliott Automatically Adds Destination Location for Transfer If Item Is Not Stocked
Release Date: 09/22/2020 Version: 7.x & Up Q - I noticed that if an item on transfer order is not stocked at the destination location, Elliott allows the user to enter the line. I think that this should not be allowed. Elliott of course checks that ...
Common Issues Raise Questions about QTYAVAILBYCOMP Stock Qty Avail
Released Date: 10/01/20 Version: 8.5 & up For those users who use the QTYAVAILBYCOMP attribute, they may frequently have questions on how the value of "Stock Qty Avail" in QTYAVAILBYCOMP is calculated. See sample screen below: Well, it is ...
Feature - Added QI (Qty Sold in Invoice History) Data Type to the User Defined CSV Export
Release date: 10/8/2020 Version: 8.5 & Up 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 -> Maintenance -> User Defined CSV Layout for the ...
Feature - Added ^TRANSFERBATCHS Attribute to Track Transfer Batches from Sales Orders
Release date: 10/20/2020 Version 8.5 and Up This new feature adds an attribute "^TRANSFERBATCHS" to allow tracking of transfer batches from sales orders. Define the attribute in System Utilities -> System Files Setup -> Maintenance -> Attribute File ...
Feature - Add User-Defined Literals to Transfer Ticket
Release date: 11/4/2020 Version 8.5 & Up We have added the ability to include user-defined literals to the transfer ticket on the lines just above the weight and volume line. Setup for the literals is in Global Setup -> Dist -> Inventory Transfer ...
How Is Scheduled Qty Avail Calculated in QTYAVAILBYCOMP Attribute for a Purchase Item?
Release Date: 11/18/2020 Version: 8.5 & Up Q - Can you explain how the 'Scheduled Qty Avail' in QTYAVAILBYCOMP attribute is calculated? Below is the Stock Status Inquiry screen: The attribute QTYAVAILBYCOMP shows: How is the Scheduled Qty Available ...
How Is Scheduled Qty Avail Calculated in QTYAVAILBYCOMP Attribute for a Manufacture Item?
Release Date: 11/18/20 Version: 8.5 & Up A - How is "Scheduled Qty Avail" calculated for a manufacturing item? See example below: In the above example, since we didn't purchase this parent item directly, does it means we can promise customers that we ...
Feature - Create Hold Trx when Posting Inventory Trx
Release Date: 12/21/2020 Version 8.5 & Up In PO Warehouse Receiving File Maintenance, a "Create Alloc ?" flag exists to signify that during posting of the transactions a record will be created in the Hold Transaction file. That is to say that even ...
Feature - Item Generic Search to Show Items with QtyOH <> Zero
Release date 12/31/2020 Version 8.5 & Up This feature builds on a previous project that added limiting the item search to items with QtyOH > zero. See the following Knowledge Base article: ...
Feature - Add Age Days and Last Calculated Date to Stock Status Inquiry
Release date 1/9/2021 Version 8.5 & Up This feature adds "age days" and "last calculated date" to the Stock Status inquiry screen. These fields come from Item File Maintenance field 27: Age days is a good way to indicate what your inventory turnover ...
Feature - Next UPC Code Assignment Enhancement
Release Date: 02/02/2021 Version: 8.5 & Up This feature improves the Next UPC Code Assignment in Item File Maintenance -> Extra Item Data Screen, where you can press F1 = Automatically Assign Next UPC Code. See sample screen below: In the past, if ...
Feature - Change QTYAVAILBYCOMP “Stock Qty Avail” Calculation Logic
Release date: 2/4/2021 The current calculation logic for the QTYAVAILBYCOMP attribute field "Stock Qty Avail" is: Qty On Hand - Qty Allocated + Qty Back Ordered This is the same definition as Excess Qty, which means "Short Term Qty Available." It ...
Feature - Allow Web Item Flag = Space to Use Product Category's Web Flag
Release Date: 2/16/2021 Version: 8.5 & Up In the past, the flag "Web Item Flag" in Item Master needed to have a value of "Y" or "N." It is now changed to allow a space, which means use the value of the web category flag in the product category. See ...
Feature - Allow to Select by Include Web Items Only Flag in User Defined CSV Export
Release Date: 02/16/2012 Version: 8.5 & Up In I/M -> Reports -> Reorder Advice/User Def CSV -> Print -> User Defined CSV Export, a new flag has been added to allow users to select by web item. See sample screen below: You can indicate whether an item ...
Feature - Add Multi-bin Support to Hold Trx Edit List
Release Date: 02/21/2021 Version: 8.5 This is an extension to the following feature: https://support.netcellent.com/portal/en/kb/articles/feature-add-new-selection-parameters-to-hold-trx-edit-list In I/M -> Maintenance -> Hold Transaction File -> ...
Feature - Allow Original Entering User to Access Transfer Batch After Assigning to Another User
Release Date: 02/24/2021 Version: 8.5 & Up In I/M -> Processing -> Inventory Transfer Management, after the batch is created, the original user who created the batch may not be able to access the batch once it is re-assigned to another user. This ...
Change - Do Not Prompt Non-Multi-Bin Users to Complete Transfer Batch
Release Date: 02/24/2021 Version: 8.5 & Up In I/M -> Processing -> Inventory Transfer Processing, the program was originally designed for multi-bin processing. Users can also use it in a non-multi-bin processing environment. When a user brings up a ...
If I Override the Value in QTYAVAILBYCOMP* Attribute to Zero, Will that Zero Value Stay?
Release Date: 3/4/21 Version: 8.5 & Up Q - The following item is a kit parent item. Our user would like to make the Stock Qty Avail and Scheduled Qty Avail zero because they have determined the kit structure is too complicated and they have concerns ...
Feature - Support P/M/MM/MP Value in QTYAVAILBYCOMP Attribute from the First Kit Mfg Item
Release date: 4/6/2021 Version 8.5 & Up This project adds support for a new field in the QTYAVAILBYCOMP attribute that will show the value in the "Purch or Mfg?" and "Mostly" fields on the Item Inquiry or Maintenance screen. If the item is a Kit ...
Feature - Inventory Transfer Management Edit List Enhancement
Release Date: 04/08/2021 Version: 8.5 & Up In I/M -> Processing -> Inventory Transfer Management -> List, the system used to prompt for the following parameters: Starting Batch ID Ending Batch ID Seq Sort By It is now changed to allow for the ...
"The Price Check Digit of the Number You Entered Is Incorrect" with UPC Code
Release Date: 04/12/2021 Version: 7.5 & Higher Q - We received a new item from a vendor with the UPC code 284672190114. When we entered this item into the Elliott UPC Code field, we received the message "The Price Check Digit of the Number You ...
Using Special Characters in Elliott Item Numbers
Release Date: 4/27/2021 Version: 7.5 & Higher Q - Are there any special characters I should avoid when creating a new item number? For example, which one of the following are preferred item numbers: HCC451-30 HCC451_30 HCC451/30 HCC451*30 HCC451 30 ...
Feature - Inventory Transfer Edit List Add More Parameters
Release Date: 05/11/2021 Version: 8.5 & Up In I/M -> Processing -> Inventory Transfer Management -> List, the system used to prompt for the following parameters: Starting/Ending Batch ID Starting/Ending Trx Date Starting/Ending Complete Date Seq Sort ...
Inventory Transfer Batch Number Repeating
Release Date: 05/13/2021 Version: 8.0 & Up Q - We have an issue with the Transfer Batch Number repeating and, at times, the control number is not incrementing. This does not happen always, but often enough to be concerning. For example, when batch #s ...
Feature - Inventory Transfer Edit List to Filter by User ID
Release Date: 05/11/2021 Version: 8.5 & Up In I/M -> Processing -> Inventory Transfer Management -> List, the system used to prompt for the following parameters: Starting/Ending Batch ID Starting/Ending Trx Date Starting/Ending Complete Date Transfer ...
Change - Modify Transfer Transaction List to Include New Fields
Release date: 6/29/2021 Version: 8.5 & Up In I/M --> Processing --> Inventory Transfer Management --> List, new fields highlighted below have been added: An extended weight column has been added. New fields associated with the Batch have been added: ...
Feature - Extra Item Data Last Access Update
Release date: 8/10/2021 Version: 8.5 & Up The purpose of these changes is related to the update of the following two fields in the Item Master file: ITEM-DATE-LAST-ACCESS and ITEM-USER-LAST-ACCESS. These two fields are updated when a user adds or ...
Feature - Enhanced 13-Digit UPC (EAU-13) Code Support
Release Date: 9/30/21 Version: 8.5 and Above This feature allows the user to specify that they are using 13-digit UPC numbers (EAU-13) instead of the standard 12-digit UPC code. This will allow for the support of UPC vendor numbers (prefix) greater ...
Feature - Disallow GTIN in UPC Code Field in Item Extra Data
Release Date: 10/25/21 Version: 8.5 and Above EDI partners may not accept a GTIN (14-digit UPC code) as a valid UPC code. A new Global Setup option has been added to prevent a GTIN from being added to the item extra data field designated as the UPC ...
How to Enable Add-on Sales Items Feature
Release Date: 12/07/2021 Version: 7.5 & Up Q - Can you advise where this "add-on" list is accessed in Elliott by Sales Order Entry personnel? I can't find any flags or anywhere in Sales Entry where an "add-on box" pops up to select items. We've never ...
Feature - Prod Cat and UDC F7 Search from Within Item User Search
Release Date: 3/7/22 Version: 8.5 and Above When the item user-defined search by product category or user-defined code is enabled, the user can search for an item by its product category or user-defined code. However, some users may have hundreds of ...
Elliott Is Moving Away from Real-Time Inventory Update Method
Release Date: 04/07/222 Version: 7.5 & Up Q - I would like to be able to auto-create an item at a location when it doesn't already exist, but it is not working. I changed the flag in Global Setup and it still does not work. Am I missing something? ...
Store Dimension Data in Elliott Item with _DIMENSION Attribute
Release Date: 04/14/2022 Version: 7.5 & Higher Q - Is there any field in the Item file where we can enter correct info about dimensions? I found field "49.weight " in Item file maintenance. Now we enter weight information there. We enter dimensions ...
Feature - Transfer History Inquiry & Drill Down from BOMP Work Order Inquiry
Release date: 4/22/2022 Version: 8.5 and Up Elliott Inventory Transfer Processing was added for multi-bin processing purposes. Since the very beginning of this function, when a transfer batch is completed and posted, the data is moved to the history. ...
Next page