Inventory Management
IM2400 Inventory Management Inventory Transaction Processing 7
Post Inventory Transactions Application Overview The Post Inventory Transactions application updates asset and distribution accounts, Item File quantity fields, and creates lot records with information entered in the Inventory Transaction Processing ...
Feature - Allow L+ and L- for Source in ATP Inquiry
Release date: 3/20/2019 Version: 8.2 and Up During ATP Inquiry, when entering the source for a Planning Type of "P," you may enter "L" to see all planning ATP records. In many situations, you may see both the positive and negative quantity for ...
Feature - Add Item Age, Cost, and Extended Cost to Cycle Count Worksheet CSV Export
Release Date: 4/15/19 Version: 8.2 and Up This feature adds three new columns to the CSV file exported from the Cycle Count Worksheet. The item age will be provided if option 6. Show Computed Qty On-Hand is set to Y. The item cost and extended cost ...
Inventory Stock Status Report of a Certain Date
Release Date: 12/6/19 Version: All Q - If I need an inventory report, do I need to run that at month end or can I run that at any point in the future for a date in the past? A - An inventory status report for a date in the past is a very complicated ...
Item Quantity Allocated Is Not Updated
Release Date: 12/6/2019 Version: All Q - Dear Netcellent Support -- Upon entering an order the item file is not updating (in some instances) the quantity allocated field. We have run a reset but this does not resolve the issue. Can you advise? A - ...
What Are The Definitions of Various Item End Item Codes?
Release Date: 02/17/2020 Version: 7.5 & Up Q - In Item Master File Maintenance, field "74. End Item Code", I see the possible following values: F = Feature K = Kit S = Style D = Desc-Item C = Shortcut A = Adjust Other=Usr-Defined See sample screen ...
Feature - Add Multiple Planning Types to Show in ATP Process Criteria
Release date: 5/8/2020 Version 8.5 & up Currently in I/M -> Utility -> ATP Regen And Process -> ATP Processing, the following screen is displayed: In the field “5. Planning Type to Show?” the user can enter one of the following values: P = Plan Order ...
In Location History, What Does the Asterisk Symbol Beside the Month Mean?
Release: 5/28/2020 Version: 8.2 & Up Q - In Stock Status Inquiry, when you drill down to Location History, I see an "*" asterisk symbol beside the current and future months. What does that mean? Especially, in the following example, I notice the ...
Feature - User Defined CSV Export Item Batch Support
Release Date - 2/5/18 This feature gives the user the ability to define a batch that can be used when running the User Defined CSV Export. The batch can be defined from I/M-> Reports-> User Defined CSV Report-> Maintenance-> User Defined CSV Batch. ...
Feature - Export Inventory TRX Audit Trail to CSV
Release date: 2/26/2018 Added the option to export the inventory transaction audit trail report data to a CSV file. We will only export the base data from the transaction audit trail file. We will not be exporting any bin or serial/lot data at this ...
Feature - Add User-Defined Code Table Support in IM User-Defined CSV Export
Release date: 4/12/2018 User-defined code table support has been added to the IM user-defined CSV export. The following new column types are now supported: UD: User Defined Code Description UE: User Defined Code ERG# UH: User Defined Code Hazardous ...
Feature - Added “Item 1st Received Date Range” Criteria to Item User Defined CSV Export
Release date: 4/17/2018 Added “Item 1st Received Date Range” criteria to Item User Defined CSV Export. Go to IM --> Reports --> Reorder Advice / User Defined CSV --> Print --> User Defined CSV Export Enter date range or press Enter for "All." ...
How to Get a List of Items That Does Not Have GTIN Code Defined
Release Date: 04/27/2018 Q - How do I get a list of items that does not have the GTIN code defined? A - You can do so by using PSQL relational engine. If you have an application that can access the Elliott database through SQL statement, then you can ...
Feature - User Defined CSV Export Quantity Sold by Customer#, Customer Type or Customer Group
Release Date: 5/2/2018 This feature adds the ability to add Quantity Sold (QS) columns to the IM User Defined CSV Export. Go to IM --> Reports --> Reordering Advice Reports --> Maintenance --> User Defined CSV Layout. Enter QS in the Type column, ...
Feature - Added inKit (IK) and inBOMP (IB) Column Types to the User-Defined CSV Report
Release date: 5/24/18 Added inKit (IK) and inBOMP (IB) column types to the user-defined CSV report. To set up the new fields, go to: IM -> Reports -> Reorder Advice/User Defined CSV -> Maintenance -> User Defined CSV Layout. Enter specification ...
Feature - Added Phantom Locking to Item File Maintenance
Release date: 6/4/2018 In the past, when a user brought up an item master record in Item File Maintenance Change mode, the item record would be locked. Any other users who tried to update that item record -- including quantity on hand, on order, or ...
Feature - Added CSV Support to the Physical Count Posting Update Edit List and the Variance Report By Item/Warehouse
Release date: 6/26/2018 CSV support has been added to the Physical Count Posting Update Edit List and the Variance Report By Item/Warehouse. Physical Count Posting Update Edit List Enter "Y" in Export to CSV File?, enter CSV File Name & Path. The ...
Limitations for Inventory Aging Report
Release Date: 08/15/2018 The Inventory Aging Report is a very valuable tool. It is primarily used to determine the aging of the inventory for all locations for the current date, but you could use it for a specific location or use it to determine the ...
Feature - ATP Inquiry Number of Days from Today
Release Date: 8/25/18 This feature is a change to the Available to Promise Inquiry. A new field has been added to the left of the order multiple that shows the number of days from today. This number can be a positive or a negative number. If the date ...
Feature - Added Report to "Set TRX Audit File Beginning Balances"
Release date: 8/27/2018 We have added a report to the "Set TRX Audit File Beginning Balances" application under I/M -> Processing. This function used to be a processing-only application. By making this process also a report, users now have the ...
Feature - Added Product Category Selection Range to ABC Analysis Reports
Release date: 9/14/18 Added product category selection criteria range to I/M -> Reports -> ABC Analysis Reports. Reports affected: by YTD Usage by YTD Sales by YTD Cost by YTD Margin See sample screen below: The purpose of this enhancement is to ...
Feature - Added Days Out of Stock (DOS) Column to the Location History Information, Sales Desk Info - Screen
Release date: 9/19/2018 In Stock Status Inquiry Screen, we added a Days Out of Stock (DOS) column to the Location History Information, in the Sales Desk Info - screen. To access this information, first bring up the stock status of a particular item, ...
Feature - Show Turn Over Ratio (TOR) in Stock Status Inquiry
Release Date - 9/20/18 This feature adds turn over ratio information for YTD Usage, YTD Usage + ATP, and Last Year Usage. This information is only shown if Elliott is configured to show Usage Percent Information and to Display Next Year ATP Usage & ...
Feature - Added Browse Through Items When in the Stock Status Inquiry
Release date: 9/28/2018 Added the ability to browse through items when in the Stock Status Inquiry. The first time in the application the user must provide the item number and the location. Once the user escapes back to the Item Number field, they ...
Why Isn't Planning Lead Time Based on Work Days?
Release Date: 11/8/2018 Q - I saw your Knowledge Base article that explains how the planning lead time is based on calendar days: https://support.netcellent.com/portal/en/kb/articles/planning-lead-time-by-calendar-days-or-work-days But since you have ...
Feature - Add to New Item Import the Ability to Enter 3 Line Item Taxable Flags
Release date: 12/18/2018 The New Item CSV Import is run from I/M-> Util-Setup-> New item import-> CSV. In Global Setup->COP Func->Order Line item screen, if the user has set the following field to "Y," the "Taxable" field in the New Item Import, ...
Feature - Prevent Item Record Deletion if BOMP Cost Master Record Exists
Release date: 12/19/2018 When deleting an item in I/M--> Maintenance --> Item file and using BOMP, if the item is on file in the BOMP Cost Master File, the user is presented with an error message and deletion of the item is prevented. Also, in I/M ...
Feature - Change Existing Item Import to Import Line Item Tax Flags
Release date: 12/18/2018 The I/M-> Util-Setup-> Change Existing Item Import has been changed to allow update of the item tax code default flags. In Global Setup->COP Func->Order Line Item screen, if the user has set the following field to "Y," the ...
Feature - Added the Ability to Control Access to the Prompt "Zero Quantity On Hand For Missing Tag Items ?"
Release date: 1/8/2019 Added the ability to control access to the prompt "Zero Quantity On Hand For Missing Tag Items?" when printing the update edit list or posting physical count tags. Some users consider this flag to be dangerous. If the person ...
Feature - Added CSV Support to the Item Audit Trail Report
Release Date: 01/29/2019 Added CSV support to the Item Audit Trail Report. Enter "Y" in field "6. Export to CSV File." Enter the path and file name in field "7. CSV File Name & Path." The default for field 6 is N. Values for both fields will be ...
Feature - Item Generic Search to Show Item Quantity Greater than Zero Only
Release date: 2/15/2019 Added to Item Generic Search the option to Show Items with Quantity Greater than Zero Only. This new option will only appear if IM Global Control, screen 1, field "4. Item Generic Search With Avail/Excess Qty" is set to "Y" ...
Feature - Move Successful Inventory Transaction Processing Import
Release date: 3/5/2019 Version: 8.2 and Up Added the ability to move successful inventory transaction import files to a separate directory. This feature is useful to create "Auditing" of the interfaced files if issues should arise later. First go to ...
Blanket POs Not Displaying on Stock Status ATP Screen
Release Date: 3/20/2019 Q - How can I get Blanket POs to display on the Stock Status ATP screen? You show it on the legend as code "PB" but it doesn’t appear on the screen. See sample screen below: We use the blanket PO for estimated dates for ...
Feature - Print Transfer Ticket Event
Release date: 6/4/2020 Version 8.5 & Up A new Print Transfer Ticket event has been added: I/M -> Processing -> Inventory Transfer Management,-> Dispatch. You can subscribe to the new event by going to I/M -> Processing -> Inventory Transfer ...
Feature - Post Transfer Ticket Event
Release date: 6/4/2020 Version 8.5 & Up A new Post Transfer Ticket Event has been added I/M -> Processing -> Inventory Transfer Management,-> Dispatch. You can subscribe to the new event by going to I/M -> Processing -> Inventory Transfer Management ...
Feature - Stock Status Inquiry Store Location in Registry
Release date: 6/18/2020 Version 8.5 & Up The stock status inquiry program has various logic to determine location. If the particular user already has a way to determine default location, this project will not override it. If the default location is ...
Change - Change Definition of Usage Type's in User Def CSV
Release date: 6/19/20 Version 8.5 & Up In IM --> Report --> Reorder Advice/User Def CSV --> Maintenance --> User Defined CSV Layout, we changed the definition of UA, U1, U2, U3, U6, and UA type column values so they do not include usage from the ...
How to Mass Update Item Master's Bin No/Pick Sequence
Release Date: 08/06/2020 Version: 8.0 & up Q - I need to change bin#/pick sequence on all inventory items. What is the best method to export, then import back in after changes are made in Excel. A - The best way to accomplish it is to go to I/M -> ...
Feature - Reorder Advice/User Defined CSV Export Example 1 - Item Quantity & History
Release Date: 08/07/2020 Version: 8.0 & Up Example 1 - Item Quantity & History We think the best way for you to understand this feature is to give you examples so you can follow our concept step by step. Let's say we have a need to develop a report ...
Feature - Reorder Advice/User Defined CSV Export Introduction
Release Date: 08/07/2020 Version: 8.0 & Up Introduction The User-Defined CSV Export is a specialized report writing tool and CSV creator for inventory information to allow you to analyze an Excel spreadsheet. This program allows access to ...
Next page