Inventory Management ← Knowledge Base Long-Term vs. Short-Term Inventory Quantity Available and Inventory with Time Line Introduction to Available to Promise (ATP) Inventory Aging Report by Location Sequence Produces Different Result Than by Other Sequence Inventory Aging Report Shows Different Age Between Single and All Locations Multiple Users Entering Physical Count Tag at the Same Time Issue Expand Item Description 1 and 2 Character Limit How Different is an IM Kit from a BOMP Kit? Explanation on Component Availability Inquiry How Is Shortcut Item Different from Kit Item? No Privilege to View Location History How to Calculate EOQ (Economic Order Quantity) Item Quantity Allocation Is Incorrect Reorder Advice Custom CSV Export Shows Zero Items Elliott Physical Count Processing Feature - Add-On Item Drill Down From Item Search Feature - Utility to Reset Item PTD Fields from Location History Feature - Inventory Snapshot Feature - ATP Regen to Consider Order Multiple and Economic Order Qty Feature - Item Master Activity Sub-Code Feature - Add Support for the Update of “Mostly Mfg Flag” in Change Existing Item Import Feature - Auto Delete BOMP Product Structure When Item Obsolete Feature - Item Linkage Report/Processing Feature - Added the Ability to Organize Product Categories by a New Product Category Group Procedure to Correct Bad Serial Number with Special Symbol Feature - Additional SY12MONS Updates Feature - Additional Activity Codes for Item Linkage CSV Report and Item Linkage Processing Feature - Item Number Wild Card Support for Starting Item Number Feature - Obsolete Kit Parent When First Component is Obsolete Feature - Show Items with Qty Variance on Tag Variance Reports IM01S3 Inventory Management Iten Audit Trail Report IM04S2 Inventory Management Inventory Transaction Audit Report IM02S2 Inventory Management Inventory Location Audit Trail Report IM03S1 Inventory Management Usage Exception Reports IM06SCN Inventory Management Stock Status Report IM08S1 Inventory Management Print Cycle Count Worksheet IM14S1 Inventory Management Item History Report IM19S1 Inventory Management Serial/Lot Stock Status Report IM19S2 Inventory Management Serial/Lot Issue History Report IM20S1 Inventory Management I/M Distribution to G/L Report IM26SCN Inventory Management Frozen Stock Status Report IM30S1 Inventory Management Kit Where-Used Report IM31S1 Create Unreleased POs by Vendor IM32S1 Inventory Management Kit Gross Requirements Report IM0201 Inventory Management Location Control File Maintenance IM0405 Inventory Management Available To Promise Inquiry IM0500 Inventory Management Stock Status Inquiry IM0500Q Inventory Management Stock Status Inquiry IM0700 Inventory Management ABC Analysis Reports IM0900 Inventory Management Reordering Advice Reports IM1000 Inventory Management Physical Count Processing Feature - Utility to Reset Item PTD/YTD Fields from Location History IM1100 Inventory Management Utilities Setup IM1201 Inventory Management Location File Maintenance IM1300 Inventory Management Recalculate Reorder Fields IM1400 Inventory Management Clear Item Accumulators IM1501 Inventory Management Product Category File Maintenance IM1601 Inventory Management Material Cost Type File Maintenance IM1701 Inventory Management Material Cost Type/Loc File Maintenance IM1801 Inventory Management Buyer/Analyst Code File Maintenance IM1901 Inventory Management Initialize Lifo/Fifo File IM1902 Inventory Management Adjust Item File to Lifo/Fifo IM1903 Inventory Management Serial/Lot Processing/Multi-bin Utilities IM1904 Inventory Management Serial/Lot Stock Status Inquiry Feature - Add Additional Record Types to Reorder Advise User-Defined CSV Export IM2500 Inventory Management Reset Allocated Quantities IM2700 Inventory Management Set Trx Audit File Beginning Balances IM2800 Inventory Management Freeze Inventory IM2900 Inventory Management Kit File Maintenance IM3301 Inventory Management Job Code File Maintenance IM3400 Inventory Management Job Analysis Report IMACTMNT Inventory Management I/M Account File Maintenance IMAGESCN Inventory Management Inventory Aging Report IMATPGSN Inventory Management Generate ATP File IMATPRSN Inventory Management Available to Promise Report IMBININV Inventory Management Bin Inventory File Maintenance IMBINMNT Inventory Management Bin File Maintenance IMBINTRN Inventory Management Inventory Transfer Processing IMCHGBIN Inventory Management Change Bin No/Pick Seq IMEXPTSN Inventory Management Export Item for Take an Order IMFRMMNT Inventory Management Item Label Form Setup IMGENMNU Inventory Management Generate Location History IMIMSITM Inventory Management Item Import Utility IMITMUDS Inventory Management Item User-Defined Fields Import Utility IMSUBMNT Inventory Management Substitute Item Class File Maintenance IMUSRMNT Inventory Management User-Defined Code File Maintenance IMVESMNT Inventory Management Vessel File Maintenance IMVLSMNT Inventory Management I/M Serial/Lot History File Maintenance Feature - Expanded Selection Parameters for Reorder Advise User Defined CSV Export Change - Update Both Kit Parent and Components Usage Feature - Create Price Code 1 from Item Minimum Price Utility Change - Available to Promise by Item Report - Add Item Description 2 Feature - Support AR (Attribute) Type in Reorder Advise User Defined CSV Export Can System Default Item User-Defined Code? Feature - Item Label Printing Enhancements Feature - Ability to Initialize Character Fields During Change Existing Item Import Understanding Status Code at Inventory Transfer Dispatch Screen Feature - Support GTIN Based on Two Different UPC Codes Feature - Update Estimated Date/Time When Printing Transfer Tickets Feature - Allow Physical Count Tag Import Without Serial Number Feature - Delete Kit Components When Item Activity Code is Set to 'O' Feature - New QTYAVAILBYCOMP Attribute Fields Feature - Allow GTIN Maintenance in I/M Change Bin No/Pick Seq Processing Feature - Improvements to Reorder Advise Reports What Is the Difference Between INV_TRX_UN_COST and INV_TRX_NEW_AVG_COST in IMINVTRX Table? Feature - Added a Function "Create Inventory Trx CSV Import" Feature - Added Support to “Create I/M Trx CSV Import” for Kit Items Feature - Improvements to QTYAVAILBYCOMP and QTYAVAILBYCOMP2 Attributes Feature - Add Desc2 Column to Item Linkage CSV Report Feature - Numeric Item List Changes Feature - Added 1C and LD Column Types to Reordering Advise User Defined CSV Export What's the Difference Between Lead Time & Planning Lead Time? Explanation of ATP LP Type - Negative Sign (-) vs (*) Symbols IM0000 Inventory Management Package Overview 7 IM0000 Inventory Management Package Overview 1 IM0000 Inventory Management Package Overview 2 IM0000 Inventory Management Package Overview 3 IM0000 Inventory Management Package Overview 4 IM0000 Inventory Management Package Overview 6 IM0000 Inventory Management Package Overview 5 IM0000 Inventory Management Package Overview 8 IM0000 Inventory Management Package Overview: Index IM0101 Inventory Management Item File Maintenance 1 IM0101 Inventory Management Item File Maintenance 2 IM0101 Inventory Management Item File Maintenance 3 IM0101 Inventory Management Item File Maintenance 4 IM0101 Inventory Management Item File Maintenance 5 IM0101 Inventory Management Item File Maintenance 6 IM0101 Inventory Management Item File Maintenance 7 IM0101 Inventory Management Item File Maintenance 8 IM0101 Inventory Management Item File Maintenance: Index IM2400 Inventory Management Inventory Transaction Processing 1 IM2400 Inventory Management Inventory Transaction Processing 2 IM2400 Inventory Management Inventory Transaction Processing 3 IM2400 Inventory Management Inventory Transaction Processing 4 IM2400 Inventory Management Inventory Transaction Processing 5 IM2400 Inventory Management Inventory Transaction Processing 6 IM2400 Inventory Management Inventory Transaction Processing 7 IM2400 Inventory Management Inventory Transaction Processing: Index How to Run Inventory Stock Status Report for a Certain Date Feature - Transition to Obsolete Item Last Received Date Not Updated When Received from I/M Transaction Processing Feature - Zero Item Weight When Using F3 to Copy Item Feature - Initialize User-Defined Note, Date and Amount Fields When Using F3 to Copy Item What Information Is Stored in the Location History (IMLOCHST) Table? Feature - Prevent Excel from Dropping Leading Zeroes in CSV Item Number Field Feature - Add User ID to User Defined CSV Export Feature - User Defined CSV Export Item Batch Support Feature - Export Inventory TRX Audit Trail to CSV Feature - Add User-Defined Code Table Support in IM User-Defined CSV Export Feature - Added “Item 1st Received Date Range” Criteria to Item User Defined CSV Export How to Get a List of Items That Does Not Have GTIN Code Defined Feature - User Defined CSV Export Quantity Sold by Customer#, Customer Type or Customer Group Feature - Added inKit (IK) and inBOMP (IB) Column Types to the User-Defined CSV Report Feature - Added Phantom Locking to Item File Maintenance Feature - Added CSV Support to the Physical Count Posting Update Edit List and the Variance Report By Item/Warehouse Feature - Inventory Transfer Management Batches Using CSV Import Limitations for Inventory Aging Report Feature - ATP Inquiry Number of Days from Today Feature - Added Report to "Set TRX Audit File Beginning Balances" Feature - Added Product Category Selection Range to ABC Analysis Reports Feature - Added Days Out of Stock (DOS) Column to the Location History Information, Sales Desk Info - Screen Feature - Show Turn Over Ratio (TOR) in Stock Status Inquiry Feature - Added Browse Through Items When in the Stock Status Inquiry Why Isn't Planning Lead Time Based on Work Days? Feature - Add to New Item Import the Ability to Enter 3 Line Item Taxable Flags Feature - Prevent Item Record Deletion if BOMP Cost Master Record Exists Feature - Change Existing Item Import to Import Line Item Tax Flags Feature - Added the Ability to Control Access to the Prompt "Zero Quantity On Hand For Missing Tag Items ?" Feature - Added CSV Support to the Item Audit Trail Report Feature - Item Generic Search to Show Item Quantity Greater than Zero Only Feature - Move Successful Inventory Transaction Processing Import Blanket POs Not Displaying on Stock Status ATP Screen Feature - Allow L+ and L- for Source in ATP Inquiry Feature - Add Item Age, Cost, and Extended Cost to Cycle Count Worksheet CSV Export Inventory Stock Status Report of a Certain Date Item Quantity Allocated Is Not Updated What Are The Definitions of Various Item End Item Codes? Feature - Add Multiple Planning Types to Show in ATP Process Criteria In Location History, What Does the Asterisk Symbol Beside the Month Mean? Feature - Print Transfer Ticket Event Feature - Post Transfer Ticket Event Feature - Stock Status Inquiry Store Location in Registry Change - Change Definition of Usage Type's in User Def CSV How to Mass Update Item Master's Bin No/Pick Sequence Feature - Reorder Advise/User Defined CSV Export Example 1 - Item Quantity & History Feature - Reorder Advise/User Defined CSV Export Introduction Feature - Reorder Advise/User Defined CSV Export Example 2 - ATP (Available to Promise) Feature - New Item Import Through CSV File Feature - Addition of TOR, QtyOH, OHValue to Stock Status Inquiry Feature - Addition of Kit and BOMP Component Counts in QTYAVAILBYCOMP2 Attribute Feature - Add Stocking UOM Variable to ADDITEM Event in Item File Maintenance Feature - Added an Est End (Estimated End) to the BOMP Operator File Inquiry Screen Elliott Automatically Adds Destination Location for Transfer If Item Is Not Stocked Common Issues Raise Questions about QTYAVAILBYCOMP Stock Qty Avail Feature - Added QI (Qty Sold in Invoice History) Data Type to the User Defined CSV Export Feature - Added ^TRANSFERBATCHS Attribute to Track Transfer Batches from Sales Orders Feature - Add User-Defined Literals to Transfer Ticket How Is Scheduled Qty Avail Calculated in QTYAVAILBYCOMP Attribute for a Purchase Item? How Is Scheduled Qty Avail Calculated in QTYAVAILBYCOMP Attribute for a Manufacture Item?