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

 Select Change Bin No/Pick Seq from the pull down I/M Processing window.  The following screen will then be displayed:

      

 

Change Bin No/Pick Seq Entry Screen


 The following fields are prompted:

    • Item No – Enter the item number you wish to change.
    • Location – Enter a valid location for this item.
    • Bin No/Pick Seq - Enter the bin number or picking sequence you wish to assign to this at this location.  An alphanumeric up to 8 characters can be entered.

     To return to the menu bar, press the ESC or F10 key.  To leave this application, press X for EXIT when positioned at the menu bar.


    Reports

    Usage Exception Reports

    Application Overview

     It is often valuable to know which items in an inventory are experi­eSncing exceptional usage, either much greater, or much less than the forecast usage.

     The Usage Exceptions Report application allows you to choose a particular inventory class (A, B, or C) and to have a report printed for that class showing all items which have varied from the forecast usage by whatever percent you choose.

     For additional information on ABC Analysis, please see the in the Item File Maintenance section.

     The items are selected for the report by calculating the ratio of the sum of errors to the average error for that item and comparing that figure to the one you enter.

     

    Run Instructions

     Select Usage Exceptions Report from the pull down I/M Reports window.  The following screen will then be displayed:

     

     

    Usage Exceptions Report Entry Screen

     The following options are available:

      • Select the desired mode from the Usage Exceptions menu bar
      • Enter the data requested on the screen

       To return to the menu bar, press the ESC or F10 key. To leave this application, press X for EXIT when positioned at the menu bar.

       

      Entry Field Descriptions

       

      Name

      Type and Description

      1.      Inventory Class

      1 alphabetic character.

      Enter A, B, or C to indicate which in­ventory class is to be included on the report.

      2.      Include Items Whose Ratio Of Sum Of Errors To Average Error Is Over What Percent

      3 numeric digits. 

      All items greater than this percent will be printed on the report.     

      For example, if 200% is entered, any items which have a sum of errors twice as large as the average error would appear on the report.  The items that appear would be items, which have been consistently over or under the forecasted.

       

      ScreensREPORTS

       

       

      Usage Exceptions Report

       

       

       

       

       

       

       

       

       

      Inventory Management

      1. Long-Term vs. Short-Term Inventory Quantity Available and Inventory with Time Line
      2. Introduction to Available to Promise (ATP)
      3. Inventory Aging Report by Location Sequence Produces Different Result Than by Other Sequence
      4. Inventory Aging Report Shows Different Age Between Single and All Locations
      5. Multiple Users Entering Physical Count Tag at the Same Time Issue
      6. Expand Item Description 1 and 2 Character Limit
      7. How Different is an IM Kit from a BOMP Kit?
      8. Explanation on Component Availability Inquiry
      9. How Is Shortcut Item Different from Kit Item?
      10. No Privilege to View Location History
      11. How to Calculate EOQ (Economic Order Quantity)
      12. Item Quantity Allocation Is Incorrect
      13. Reorder Advice Custom CSV Export Shows Zero Items
      14. Elliott Physical Count Processing
      15. Feature - Add-On Item Drill Down From Item Search
      16. Feature - Utility to Reset Item PTD Fields from Location History
      17. Feature - Inventory Snapshot
      18. Feature - ATP Regen to Consider Order Multiple and Economic Order Qty
      19. Feature - Item Master Activity Sub-Code
      20. Feature - Add Support for the Update of “Mostly Mfg Flag” in Change Existing Item Import
      21. Feature - Auto Delete BOMP Product Structure When Item Obsolete
      22. Feature - Item Linkage Report/Processing
      23. Feature - Added the Ability to Organize Product Categories by a New Product Category Group
      24. Procedure to Correct Bad Serial Number with Special Symbol
      25. Feature - Additional SY12MONS Updates
      26. Feature - Additional Activity Codes for Item Linkage CSV Report and Item Linkage Processing
      27. Feature - Item Number Wild Card Support for Starting Item Number
      28. Feature - Obsolete Kit Parent When First Component is Obsolete
      29. Feature - Show Items with Qty Variance on Tag Variance Reports
      30. IM01S3 Inventory Management Iten Audit Trail Report
      31. IM04S2 Inventory Management Inventory Transaction Audit Report
      32. IM02S2 Inventory Management Inventory Location Audit Trail Report
      33. IM03S1 Inventory Management Usage Exception Reports
      34. IM06SCN Inventory Management Stock Status Report
      35. IM08S1 Inventory Management Print Cycle Count Worksheet
      36. IM14S1 Inventory Management Item History Report
      37. IM19S1 Inventory Management Serial/Lot Stock Status Report
      38. IM19S2 Inventory Management Serial/Lot Issue History Report
      39. IM20S1 Inventory Management I/M Distribution to G/L Report
      40. IM26SCN Inventory Management Frozen Stock Status Report
      41. IM30S1 Inventory Management Kit Where-Used Report
      42. IM31S1 Create Unreleased POs by Vendor
      43. IM32S1 Inventory Management Kit Gross Requirements Report
      44. IM0201 Inventory Management Location Control File Maintenance
      45. IM0405 Inventory Management Available To Promise Inquiry
      46. IM0500 Inventory Management Stock Status Inquiry
      47. IM0500Q Inventory Management Stock Status Inquiry
      48. IM0700 Inventory Management ABC Analysis Reports
      49. IM0900 Inventory Management Reordering Advice Reports
      50. IM1000 Inventory Management Physical Count Processing
      51. Feature - Utility to Reset Item PTD/YTD Fields from Location History
      52. IM1100 Inventory Management Utilities Setup
      53. IM1201 Inventory Management Location File Maintenance
      54. IM1300 Inventory Management Recalculate Reorder Fields
      55. IM1400 Inventory Management Clear Item Accumulators
      56. IM1501 Inventory Management Product Category File Maintenance
      57. IM1601 Inventory Management Material Cost Type File Maintenance
      58. IM1701 Inventory Management Material Cost Type/Loc File Maintenance
      59. IM1801 Inventory Management Buyer/Analyst Code File Maintenance
      60. IM1901 Inventory Management Initialize Lifo/Fifo File
      61. IM1902 Inventory Management Adjust Item File to Lifo/Fifo
      62. IM1903 Inventory Management Serial/Lot Processing/Multi-bin Utilities
      63. IM1904 Inventory Management Serial/Lot Stock Status Inquiry
      64. Feature - Add Additional Record Types to Reorder Advise User-Defined CSV Export
      65. IM2500 Inventory Management Reset Allocated Quantities
      66. IM2700 Inventory Management Set Trx Audit File Beginning Balances
      67. IM2800 Inventory Management Freeze Inventory
      68. IM2900 Inventory Management Kit File Maintenance
      69. IM3301 Inventory Management Job Code File Maintenance
      70. IM3400 Inventory Management Job Analysis Report
      71. IMACTMNT Inventory Management I/M Account File Maintenance
      72. IMAGESCN Inventory Management Inventory Aging Report
      73. IMATPGSN Inventory Management Generate ATP File
      74. IMATPRSN Inventory Management Available to Promise Report
      75. IMBININV Inventory Management Bin Inventory File Maintenance
      76. IMBINMNT Inventory Management Bin File Maintenance
      77. IMBINTRN Inventory Management Inventory Transfer Processing
      78. IMCHGBIN Inventory Management Change Bin No/Pick Seq
      79. IMEXPTSN Inventory Management Export Item for Take an Order
      80. IMFRMMNT Inventory Management Item Label Form Setup
      81. IMGENMNU Inventory Management Generate Location History
      82. IMIMSITM Inventory Management Item Import Utility
      83. IMITMUDS Inventory Management Item User-Defined Fields Import Utility
      84. IMSUBMNT Inventory Management Substitute Item Class File Maintenance
      85. IMUSRMNT Inventory Management User-Defined Code File Maintenance
      86. IMVESMNT Inventory Management Vessel File Maintenance
      87. IMVLSMNT Inventory Management I/M Serial/Lot History File Maintenance
      88. Feature - Expanded Selection Parameters for Reorder Advise User Defined CSV Export
      89. Change - Update Both Kit Parent and Components Usage
      90. Feature - Create Price Code 1 from Item Minimum Price Utility
      91. Change - Available to Promise by Item Report - Add Item Description 2
      92. Feature - Support AR (Attribute) Type in Reorder Advise User Defined CSV Export
      93. Can System Default Item User-Defined Code?
      94. Feature - Item Label Printing Enhancements
      95. Feature - Ability to Initialize Character Fields During Change Existing Item Import
      96. Understanding Status Code at Inventory Transfer Dispatch Screen
      97. Feature - Support GTIN Based on Two Different UPC Codes
      98. Feature - Update Estimated Date/Time When Printing Transfer Tickets
      99. Feature - Allow Physical Count Tag Import Without Serial Number
      100. Feature - Delete Kit Components When Item Activity Code is Set to 'O'
      101. Feature - New QTYAVAILBYCOMP Attribute Fields
      102. Feature - Allow GTIN Maintenance in I/M Change Bin No/Pick Seq Processing
      103. Feature - Improvements to Reorder Advise Reports
      104. What Is the Difference Between INV_TRX_UN_COST and INV_TRX_NEW_AVG_COST in IMINVTRX Table?
      105. Feature - Added a Function "Create Inventory Trx CSV Import"
      106. Feature - Added Support to “Create I/M Trx CSV Import” for Kit Items
      107. Feature - Improvements to QTYAVAILBYCOMP and QTYAVAILBYCOMP2 Attributes
      108. Feature - Add Desc2 Column to Item Linkage CSV Report
      109. Feature - Numeric Item List Changes
      110. Feature - Added 1C and LD Column Types to Reordering Advise User Defined CSV Export
      111. What's the Difference Between Lead Time & Planning Lead Time?
      112. Explanation of ATP LP Type - Negative Sign (-) vs (*) Symbols
      113. IM0000 Inventory Management Package Overview 7
      114. IM0000 Inventory Management Package Overview 1
      115. IM0000 Inventory Management Package Overview 2
      116. IM0000 Inventory Management Package Overview 3
      117. IM0000 Inventory Management Package Overview 4
      118. IM0000 Inventory Management Package Overview 6
      119. IM0000 Inventory Management Package Overview 5
      120. IM0000 Inventory Management Package Overview 8
      121. IM0000 Inventory Management Package Overview: Index
      122. IM0101 Inventory Management Item File Maintenance 1
      123. IM0101 Inventory Management Item File Maintenance 2
      124. IM0101 Inventory Management Item File Maintenance 3
      125. IM0101 Inventory Management Item File Maintenance 4
      126. IM0101 Inventory Management Item File Maintenance 5
      127. IM0101 Inventory Management Item File Maintenance 6
      128. IM0101 Inventory Management Item File Maintenance 7
      129. IM0101 Inventory Management Item File Maintenance 8
      130. IM0101 Inventory Management Item File Maintenance: Index
      131. IM2400 Inventory Management Inventory Transaction Processing 1
      132. IM2400 Inventory Management Inventory Transaction Processing 2
      133. IM2400 Inventory Management Inventory Transaction Processing 3
      134. IM2400 Inventory Management Inventory Transaction Processing 4
      135. IM2400 Inventory Management Inventory Transaction Processing 5
      136. IM2400 Inventory Management Inventory Transaction Processing 6
      137. IM2400 Inventory Management Inventory Transaction Processing 7
      138. IM2400 Inventory Management Inventory Transaction Processing: Index
      139. How to Run Inventory Stock Status Report for a Certain Date
      140. Feature - Transition to Obsolete
      141. Item Last Received Date Not Updated When Received from I/M Transaction Processing
      142. Feature - Zero Item Weight When Using F3 to Copy Item
      143. Feature - Initialize User-Defined Note, Date and Amount Fields When Using F3 to Copy Item
      144. What Information Is Stored in the Location History (IMLOCHST) Table?
      145. Feature - Prevent Excel from Dropping Leading Zeroes in CSV Item Number Field
      146. Feature - Add User ID to User Defined CSV Export
      147. Feature - User Defined CSV Export Item Batch Support
      148. Feature - Export Inventory TRX Audit Trail to CSV
      149. Feature - Add User-Defined Code Table Support in IM User-Defined CSV Export
      150. Feature - Added “Item 1st Received Date Range” Criteria to Item User Defined CSV Export
      151. How to Get a List of Items That Does Not Have GTIN Code Defined
      152. Feature - User Defined CSV Export Quantity Sold by Customer#, Customer Type or Customer Group
      153. Feature - Added inKit (IK) and inBOMP (IB) Column Types to the User-Defined CSV Report
      154. Feature - Added Phantom Locking to Item File Maintenance
      155. Feature - Added CSV Support to the Physical Count Posting Update Edit List and the Variance Report By Item/Warehouse

      Feedback and Knowledge Base