Feature - Addition of TOR, QtyOH, OHValue to Stock Status Inquiry

Feature - Addition of TOR, QtyOH, OHValue to Stock Status Inquiry

Release date 9/3/2020

Version 8.5 & Up

The purpose of this feature is to evaluate how planners manage the inventory in the past and the foreseeable future. For this reason, we added the following new columns to Stock Status Inquiry -> Location History Information screen:
  • TOR = Turnover Ratio (Yearly Usage / Qty OH.) Generally speaking, the higher this value, the better.
  • Qty OH = Quantity on Hand at End of Month (or Year)
  • OH-Value = QtyOH * Unit Cost
In Location History Information, you will need to press the F7 key twice to reach the Quote/OH screen, as shown below.


  
Notice an "*" (asterisk) may appear next to a value on any of the Location History Information screens where the value is "estimated." This includes the YTD or LastYr (if you are in the future year) values if they are estimated or calculated.  

In the above example, this KB article is written as of September 2020. so the quantity on hand and the values for Sep., Oct., Nov., and Dec. 2020 are estimated based on ATP (Available To Promise). We put an "*" beside the numbers to remind you accordingly.  Keep in mind that we will only display estimated future quantities on hand if the following flag is turned on in Global Setup (Global Setup-->Cop-Ctl-->Stock Status Inquiry):
    12. Show ATP Data When Drill Down to Loc History ?



The TOR (Turnover Ratio) values has an "*" beside it because it is calculated based on the estimated "Yearly Usage Qty" / "Month End Qty on Hand." The "Yearly Usage Qty" for the current year can be calculated in two ways: (1) If the above Global Setup flag is turned on, the system calculates the Year End Usage Qty based on the actual usage in the past and the future usage from ATP, including planning and forecast ATP records; (2) If the above Global Setup flag is turned off (or blank - the default is off), the system calculates the Yearly Usage Qty based on the current year usage rate. This number may be off at the beginning of a new year when there's not a lot of history to make this projection reliable.

  

The following is an example of what appears if the above flag is set to "N." The future months will not have values in any of the columns.



Again, due to the global setup flag is "N", both yearly usage and current, as well as future monthly QtyOH values will not be determined based on data in the ATP. Instead, the yearly usage value is calculated by projecting the current YTD usage as it would be at the end of the year at that same rate of usage. The TOR column is then calculated by dividing the prorated yearly usage by each month's Qty OH. The OH-Value column is computed by multiplying the monthly Qty OH by item unit cost (average, last or standard based on your cost method in I/M Global Setup.)

The other two screens in Location History Information can also have an "*" next to any field that is estimated or calculated if the Global Setup flag is "Y":




Starting with this revision, by default, we display the zero value as blank so if there are any non-zero values, they will stand out on the Location History screen.

Modified program: IMLOCHST

DLM


    • Related Articles

    • Create PO Receiving Event to Trap Negative Qty on Hand Problem

      Q - Sometimes our receiving department is behind with their tasks in updating received quantities in the Elliott inventory. As a result, it creates a negative quantity on hand in Elliott. The items sold during the period use the old average cost. ...

    • Common Issues Raise Questions about QTYAVAILBYCOMP Stock Qty Avail

      Released Date: 10/01/20 Version: 8.5 & up For those users who use the QTYAVAILBYCOMP attribute, they may frequently have questions on how the value of "Stock Qty Avail" in QTYAVAILBYCOMP is calculated. See sample screen below: Well, it is ...

    • 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 & ...

    • Explanation on Component Availability Inquiry

      Revised Date: 01/07/2021 Version: 7.5 & up Q. In I/M -> Inquiry -> Stock Status Inquiry, you can press F2=Comp Avail. Then the Component Availability Inquiry Screen will show up. In this window, it displays three numbers under the "New Cost/EA" ...

    • Feature - Add Prevent Entry for Unit Price When Below Minimum Price or Cost

      Release date:3/5/2018 Currently when entering a line item in Order Entry, the application will warn the user if the price is below the item minimum price or unit cost. This new feature will allow users to prevent the entry in Order Entry, Sales Desk, ...