IM0101 Inventory Management Item File Maintenance 5

Management Data ‑ Second Screen

 

Name

Type and Description

37.    Commsn Method

1 alphabetic character.

If calculate commission type is by item in Customer Order Processing then this field determines how the commission is calculated for each item.  The commission method must be one of the following:

A      =   Amount

C      =   % of Cost

M      =   % of Margin

P      =   % of Price  

This field defaults to P.

38.    Commsn Pct/Amt

7 digit numeric file with 2 decimal places (99,999.99) 

This is the commission percent or amount for this item.  If the commission method is C, M, or P, enter the commission percent given for this item. The commission percent can not be greater than 100%.  If the commission method is A, enter the commission amount given for this item.

39.    Target Margin

3 numeric digits (999).

This is the targeted profit margin for the item, calculated by comparing the profit made by selling the item to the item's cost.  For example, if the cost of an item is $5.00 and its selling price is $8.00, the percent of profit would be: (8 ‑ 5) / 5 = 60%.  You should enter the profit margin you wish to obtain for the item.

This field is printed on the Sales Comparison Reports in the Customer Order Processing package.

40.    Matl Cost Type

1 alphanumeric character.

Enter the item's material cost type.  It is up to you to define valid material cost types using Material Cost Type File Maintenance.  This field will be used to define this item's inventory asset account.  This field defaults to the default material cost type in I/M Setup

Press the F7 key to search for Material Cost Type.

41.    Reorder Level

A standard quantity format 

When the quantity of the item on‑hand falls below the reorder level, an order should be placed for the item.

This could be performed via the Create Unreleased Purchase Order's By Vendor application, if you wish.

The reorder level is calculated by adding the amount of stock you want to keep on hand for sudden emergency demands (safety stock) to the amount of stock you expect to use during the time it takes to receive a new supply from the vendor or from the manufacturing facility.

This reorder level is recalculated by the package whenever the Recalculate Reorder Fields application is run.

If this field is left at zero, it will be calculated on the first run of the Recalculate Reorder Fields application.

42.    Order Up To

A standard quantity format.

This is the maximum quantity of the item that it is desirable to have in stock.  This quantity would be equal to the reorder point plus the order quantity. The order up to level is usually used in a periodic review system in which the quantity on‑hand is inspected visually, and if it is low, enough is ordered to bring the on‑hand back to the order up to level.

43.    Recom Min Order

A standard quantity format.

This is the absolute minimum, which should be ordered at one time.  It is equal to the amount of stock that will be consumed during the time it takes to obtain new supplies from the vendor or from the manufacturing facility.  If only this amount were ordered, you would usually find yourself having to place a new order for the item as soon as the new supply arrived.  Thus, you would normally order more than this recommended minimum order.  The amount of the recommended minimum order is recalculated every time the Recalculate Reorder Fields application is run.  If this field is left at zero, it will be calculated on the first run of the Recalculate Reorder Fields application.

44.    Lead Time

3 numeric digits (999).

This is the number of calendar days, which pass between the ordering of a new supply of the item and the actual receipt of the item into stock.

If this field is left at zero, the Recommended Minimum Order field will always be set to zero by the Recalculate Reorder Fields application.

45.    Def Vendor No

6 alphanumeric characters 

The default or main vendor from which the item is purchased.  It is important to enter a vendor number here if the I/M Create Unreleased PO's By Vendor application will be used to automatically generate purchase orders.

Press the F7 key to search by vendor number or the F8 key to search by vendor name.

46.    Order Minimum

A standard quantity format.

In many cases, there is a minimum quantity of the item, which can be purchased from the vendor.  For example, if the item only comes in cases, at least one case must be purchased.  If a case consisted of 50 of the items, then this field would have the value of 50.

47.    Order Multiple

4 numeric digits (9999).

The item should be ordered in multiples of this quantity.  For example, this order multiple might be the quantity per case. 

This field defaults to 1.

48.    Commodity Code

4 alphanumeric characters.

This is a user‑defined code, which identifies a category of items, which you purchase from some vendor.  For example, you might assign the code ST to steel products. 

The Purchase Order and Receiving package allows you to specify which vendors supply which Commodity Codes, and provides various reports based on this Commodity Code.

49.    Weight

8 numeric digits with 3 decimal places (99,999.999).

Enter the unit weight of the item.  This helps to determine the best method of shipping the item.

50.    Inventory Class

1 alphanumeric character.

A, B, or C may be entered here for the ABC Analysis code

A more detailed explanation of the ABC Analysis concept is contained in the  for Item File Maintenance.

51.    Cycle Count Code

1 alphanumeric character.

The purpose of the cycle count code is to allow you to print a Cycle Count Worksheet for those items with selected cycle count codes.  Only these items will be cycle counted.

You may define the cycle count codes to be used in your inventory system in any way you choose.

52.    Date Last Cntd

A standard date format.

This is the date a cycle count was last done for the item.

53.    Buyer Or Analyst

2 alphanumeric characters.

This is a user‑defined field designating who the main buyer or analyst for the item is. Buyers or analyst codes may be defined using the Buyer/Analyst Code File Maintenance application.

Press the F7 key to search for Buyer/Analyst.

54.    Usage Ptd

A standard quantity accumulator format with an optional minus sign.

The quantity of the item, which has been used so far this period.  This usage would have come about either as the result of shipping a quantity of the item to a customer, or by consuming the item as a component of some manufactu­ring process.  The field is updated either after the invoicing of orders in the Customer Order Processing package, by Inventory Transaction Processing, or by producing work orders in Bill Of Material Processor.

55.    Usage Ytd

A standard quantity accumulator format with an optional minus sign.

The quantity of the item, which has been used so far this year.  Refer also to the above field, Usage PTD.

56.    Usage Last Yr

A standard quantity accumulator format with an optional minus sign.

The quantity of the item, which was used last year. Refer also to the above field, Usage PTD.

57.    Average Usage

This is your projected average usage of the item in one period.  The length of the period is defined in I/M Setup.

The value of this field is recalculated every time the Recalculate Reorder Fields application is run, based on a comparison between the actual usage for the previous period and the previous value of this field.

It is important that a reasonable estimate of the average usage be entered in this field.  If this is not done, it may take several periods of recalculation before it corrects itself.  Exactly how long the self-correction will take is determined by the usage weight factor.  For example, if the usage weight factor is .29, it will take six periods before this figure is accurate.

58.    Usage Wght Fctr

3 numeric digits with 2 decimal places (9.99).

This is the alpha factor used in forecasting the next period's usage of the item, based on the actual usage for the previous period, and the forecast for that period.  It determines the number of periods of sales history to use in forecasting next period's usage.  Based on experience in the manufacturing industry, a table of alpha factors for periods of dif­ferent lengths has been drawn up for your use.

 Periods of      Usage Weighing

Sales History        Factor

     3                  .50

     6                  .29

     9                  .20

    12                 .15

    18                 .11

Usage Wght Fctr (continued)

In the calculation of a new forecast, as you use more periods of sales history, the importance placed on the previous period's actual usage decreases.  Thus a sudden change upward or downward will not produce a widely out of line forecast for next period.

If this field is left at zero, the forecast for the next period will never change, regardless of how high or low the actual usage goes.

59.    Safety Stock

A standard quantity format.

The demand for an item may vary over a period of time.  A frequently used way of ensuring that there is enough stock on hand to meet this variable demand is to always keep a supply of extra stock.  This extra stock is called safety stock.  You may enter the initial value of the safety stock field.  It will then be recalculated to reflect changes in actual usage each time the Recalculate Reorder Fields application is run.

If this field is left at zero, it will be calculated on the first run of the Recalculate Reorder Fields application.

60.    Safety Factor

2 numeric digits with 1 decimal place (9.9).

This safety factor is used in recalculating the safety stock when the Recalculate Reorder Fields application is run.  In general, the higher the safety factor is set, the higher the safety stock will be.  Thus the number of out‑of‑stock situations will decrease.

The following table of safety factors has been drawn up from experience in the manufacturing industry.  It is based on the customer service level you want to maintain.  For example, if you want to provide a customer service level of 85%, meaning that 85 out of 100 times a customer orders the item it will be in stock, you would specify the safety factor at 1.3.

Customer Service          Safety

        Level                   Factor

        50%                       0.0

        75%                       0.8

        80%                       1.1

        85%                       1.3

        90%                       1.6

Safety Factor (continued)

Customer Service          Safety

        Level                   Factor

        95%                     2.1

        97%                     2.4

        99%                     2.9

        99.5%                  3.2

        99.8%                  3.6

        99.9%                  3.9

        99.99%                   5.0

If this field is left at zero, there will not be any safety stock, so about half the time you will be out of stock.

61.    Usage Filter

2 numeric digits with 1 decimal place (9.9).

The usage filter is used during the calculation of a new forecast for the item.

If a period's actual usage is suddenly very high in comparison with the forecast, it can cause the new forecast to appear higher than it should be.  For this reason, you may want to dampen the effect of these sudden usage increases.

When calculating the new forecast, the usage figure used for the calculation is never allowed to be greater than the usage filter times the earlier forecast.  For example, if the prior forecast for an item were 1,000, this month's actual usage was 8,000 and the usage filter was 5, the usage figure used in the calculation of the new forecast would not be allowed to exceed 5,000 (5 x 1,000).  In this example, 5,000 would be the figure used for actual usage period to date in the calculation.

If this field is left at zero, no dampening will occur. If it is less than one it will force the forecasted average usage to decrease regardless of actual usage.

When initially setting up your package, if you are not certain that the Average Usage field is accurate, use a fairly high usage filter.

62.    Start Sale Date

A standard date format.

When the item is on sale, enter here the starting date of the sale, and in the next field the ending date of the sale.  If the date of the order is between these dates, the sale price will be used for the item, instead of the regular item price.  The Price Code File Maintenance application in the Customer Order Processing package allows you to enter additional pricing data for inventory items.

63.    End Sale Date

A standard date format.

Refer to the above field, the Start Sale Date.    

64.    Sale Price

10 numeric digits with 4 decimal places and an optional minus sign (999,999.9999‑).

This sale price will be used instead of the regular item price during the dates defined above.

65.    Economic Ord Qty

A standard quantity format. 

It may be beneficial to purchase this item in large enough quantities that the cost of repeatedly ordering is minimized.  At the same time, you will want to keep the dollar value of inventory as low as possible in order to minimize carrying costs.  The quantity of the item to order which best balances these factors is called the Economic Order Quantity.  This value is not calculated by the package.  You should determine, based on your experience, what this quantity should be and enter it here.

The equation is :                                                       

      

 


Where Q is the quantity to be ordered, A is the annual sales, S is the setup or ordering cost r is the carrying cost rate, and v is the item's unit cost.

66.    Serialized Item

Y or N.

If using serialized items in I/M Setup.

Enter yes here if this item will have serial numbers. 

The default answer is N.

This field cannot be changed if the quantity on order is greater than zero.

A more detailed explanation of serialized processing is contained in the  for this application.

66.    Lot Numbers ?

Y or N.

If using lot items in I/M Setup.

Enter yes here if this item will have either serial numbers or lot numbers.

The default answer is N.

This field cannot be changed if the quantity on order is greater than zero.

A more detailed explanation of serialized or lot processing is contained in the  for this application.

67.    Length Of Wrnty

3 numeric digits (999).

This field is used for serialized inventory only.  Enter the number of days the item will be under warranty after it has been sold.

68.    Do Price Breaks Apply ?

Y or N.

If this flag is set to Y, and the pricing basis (see COP Price Code File Maintenance) is D or M, the percentage set in the price code file will be applied against the specified Item sale price.  If this flag is set to Y, and the pricing basis is P, the straight Item sale price will be used.

If this flag is set to N, no price breaks will be calculated.

The default answer to this question is N.

69.    Do Discounts Apply ?

Y or N.

During the sale, do other discounts apply?

The default answer to this questions is N.

 

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

Feedback and Knowledge Base