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 transactions and updating the appropriate inventory files.

The user may choose to record transactions on-line.  This means that inventory quantity levels will be immediately adjusted when a transaction is entered; providing the most up to the minute picture of the actual status of inventory.  To select this option, set the Online Update Inventory Trx flag (#24) in I/M Setup to Y.

The second option is to place entered transactions in a transaction file; to be posted later via the Post Inventory Transactions application.  This offers the flexibility of verifying the accuracy of transactions before they effect inventory levels.  For issue, adjustment, and receiving transactions, it also allows the user to distribute the value of the inventory to one or more G/L accounts.  To select this option, set the Online Update Inventory Trx flag (#24) in I/M Setup to N.

 Note:  Switching back and forth between on-line and batch processing can corrupt inventory data files.  It is recommended to choose one of the above methods and stay with it.

 If it is necessary to change from on-line to batch processing, first re-initialize the Inventory Transaction Process File, Inventory Transaction Distribution File, and Inventory Transaction Serial File using the File Utilities application under the Util_setup window of the Elliott main menu. 

Warning: Initializing these files will erase any transactions recorded in them.  Changing from batch processing to on-line is not recommended.

 For more information on the two types of inventory transaction processing, see the On-line Processing and Batch Processing chapters that follow.


On-Line Processing

If on-line processing is selected, the application will record receivings, transfers, issues of inventory.  As entry of a transaction is completed, the application immediately updates the appropriate item's quantity fields in the Item File.  It also creates a record in the Inventory Transaction Audit File.

If a transaction is changed or deleted, the program actually creates a change transaction, which makes the necessary adjustments to the original transaction.  This change transaction is also recorded in the Audit File.  When searching for transactions in change or delete mode, the transaction which appears on the screen is actually the latest change to the transaction.

 If a transaction has been deleted, it will not be displayed in change or delete mode.  It will however, along with all changes, be printed on the Inventory Transaction Audit Trail Report.

 

Adjusting Average Cost

Very commonly, the situation will arise that receivings are entered from the packing slip before the actual invoice arrives.  Since the packing slip does not usually provide the unit cost, some method must be used to make sure the unit cost does ultimately get entered cor­rectly, since this will affect the average cost for the item.

If the new unit cost is unknown at the time of receiving, simply press RETURN for that field, which will cause the item's last cost to be accepted.  If an on-line receipt was used when the invoice arrives with the unit cost, you may bring up that transaction in change mode and re‑enter the correct unit cost.

If your company uses the Elliott Purchase Order and Receiving package, it is strongly recommended that you use that package wherever possible to enter re­ceivings transactions.  This is because certain quantities pertaining to an item, which have importance to the Purchase Order and Receiving package, are not processed using the Inventory Management package.  Receivings processed by the Inventory Management package will not tell the whole story for the Purchase Order and Receiving package.

NOTE:           Depending on your I/M Setup, Average Cost will display as FOB Cost or Landed cost. 


LIFO And FIFO Cost Method

A layer is a single record in the LIFO/FIFO File that records for each item each receipt or purchase and associated cost and quantity.  Receivings from both the Inventory Management or Purchase Order and Receiving packages will create LIFO/FIFO layers.  Posted credit memos from the Customer Order Processing package will also create a layer.  Layers are removed in the appropriate order as inventory is relieved.  Issues from the Inventory Management or posted invoices from the Customer Order Processing package will either remove layers or reduce layer quantities based on needed quantities.

Each receipt relates directly to a record or layer in the LIFO/FIFO File.  Deleting an on-line receipt transaction will remove the associated layer record.  Also, changing an on-line receipt transaction's quantity will adjust the quantity remaining in the layer record.  Since the layer may be partially issued, the layer quantity may not match the receipt transaction quantity.

The system will not allow an on-line receipt with a partially issued layer to be deleted.  In addition, the quantity received of a receipt with a partially issued layer may not be reduced to a point that would create a negative layer quantity.

The LIFO/FIFO cost method does not allow stocked items to have a negative quantity on hand or allow layers with negative quantities.

Transactions cannot be purged from the Transaction Audit Trail File until their associated layers have been deleted from the LIFO/FIFO layer file. Only transactions, whose layers have been completely issued and deleted, will be purged.

Detailed layer information by item may be obtained through a report option on the Stock Status Report application.

 

Serial Transactions

If the Serialized/Lot Items flag is S in I/M Setup, then serialized items and transactions are allowed.  All items are not automatically assumed to be serialized.  The second screen of Item File Maintenance has both a serialized item question and length of warranty question.  These fields are used to selectively create serialized inventory.

Each on-line receipt or issue of a serial item creates a record in the Serial/Lot File.  These records may be inquired or printed through the Serial/Lot Stock Status Inquiry, Serial/Lot Stock Status Report, and Issue History Report.

Serial stock records are created by receivings from the Inventory Management, Purchase Order And Receiving, and Manufacturing packages.  Production reporting may be performed in Bill Of Material Processor to produce serialized stock.  Posted credit memos from the Customer Order Processing package may be used to return serialized items to stock. Serial stock records are relieved and serial issue records are subsequently created by issue transactions from the Inventory Management package and posted invoices from the Customer Order Processing package.  Unposted invoice type orders and selected orders from Customer Order Processing will allocate serialized inventory. 

Each inventory receipt, issue and adjusting transaction relates directly to a record in the Serial/Lot File.  Transaction quantities may be larger than one but the system will prompt for an equal number of unique serial numbers.  A separate transaction will be created for each serial number.  Deleting an on-line receipt will remove the associated serial stock record.  If an on-line issue is deleted, the system will return the serialized item to stock.  An on-line receipt that has had its associated serial number issued may not be deleted.

On-line transactions for serialized items may not be changed.  Changes to issued warranty dates may be accomplished through the Serial/Lot Processing application.

Entry of serial numbers on receipts is not mandated.  Also, serial numbers issued or sold do not have to be in stock.  This flexibility allows serial items and warranty dates to be tracked after the sale only.  Serial numbers may be entered on the picking ticket generated by the Customer Order Processing package.

 

Lot Transactions

If the Serialized/Lot Items flag is L in I/M Setup, then lot items and transactions are allowed.  All items are not automatically assumed to be tracked by lot.  The second screen of Item File Maintenance has a lot number question to allow selective creation of inventory items requiring lot tracking.

Each on-line receipt or issue of a lot item creates a record in the Serial/Lot File.  These history records may be inquired or printed through the Serial/Lot Issue History Report and Serial/Lot Processing application.

Lot records are created by receivings from both the Inventory Management or Purchase Order And Receiving packages.  The Production Transaction Processing application may also be used in Bill Of Material Processor to produce lots.  Posted credit memos from the Customer Order Processing package may be used to return stock to its original lot.  Lot quantities are reduced and lot issue records are subsequently created by issue transactions from the Inventory Management package and posted invoices from the Customer Order Processing package.  Unposted invoice type orders and selected orders from Customer Order Processing will allocate lot quantities.

Each receipt relates directly to a stocked lot record in the Serial/Lot File.  Deleting a receipt transaction will delete the associated lot and remove the transaction from the I/M Transaction File.  Deleting an issue transaction will remove the transaction from the I/M Transaction File and update the inventory and lot quantity fields.

The system will not allow an on-line receipt with a partially issued lot to be deleted.  In addition, the quantity received of an on-line receipt with partially issued lot may not be reduced to a point that would create a negative lot quantity. 

Items with lot tracking are not allowed to have a negative quantity on hand or allow lots with negative quantities.

The total quantity on hand from the Serial/Lot File must match the item quantity on hand.  However, allocated quantities may not match since Customer Order Processing only allocates lots after line items are selected.  This allows orders to be placed for out of stock items with no lots available.

After a lot is completely issued or sold, it remains in stock with a quantity of zero.  The lot must remain in stock if returns are anticipated so that original expiration dates may be tracked.  These zero lots may be purged from the Purge Zero Quantity Lots in the Serial/Lot Processing application through a selected cut off date.


Run Instructions - On-Line Processing

 Select Inventory Transaction Processing from the pull down I/M Processing window.  The following screen will then be displayed:

 


Inventory Transaction Processing Entry Screen

 The following options are available:

                  *     Select the desired mode from the Inventory Transaction Processing 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.

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
  156. Feature - Inventory Transfer Management Batches Using CSV Import
  157. Limitations for Inventory Aging Report
  158. Feature - ATP Inquiry Number of Days from Today
  159. Feature - Added Report to "Set TRX Audit File Beginning Balances"
  160. Feature - Added Product Category Selection Range to ABC Analysis Reports
  161. Feature - Added Days Out of Stock (DOS) Column to the Location History Information, Sales Desk Info - Screen
  162. Feature - Show Turn Over Ratio (TOR) in Stock Status Inquiry
  163. Feature - Added Browse Through Items When in the Stock Status Inquiry

Feedback and Knowledge Base