Feature - Show Turn Over Ratio (TOR) in Stock Status Inquiry

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 & Replace UDC. These options are enabled through Global Setup-> COP-Ctl-> Stock Status Inquiry-> fields 9 an 11.



The turn over ratio information is displayed to the left of the usage information.




YTD Usage TOR

TOR = Usage YTD /Current Location Quantity On Hand - Usage YTD and Qty-OH refer to the current highlighted location. 

YTD Usage + ATP

TOR = (Usage YTD + Scheduled ATP Usage By End of Year) / ATP Qty Balance By End of Year - All amounts are based on the highlighted location.

This is the same value that is shown on the ATP Inquiry screen if you use F3=ATP Inquiry to drill down to ATP screen. In the ATP Inquiry screen, you just need to cursor down to highlight the last ATP transaction of the year to see the turn over ratio.


One thing to remember: the ATP drill down by default will show ATP for all locations. The  planning type will default to the last planning type entered. The values shown on the Stock Status Inquiry screen are based on a planning type of P and the location that is highlighted.

Last Year Usage

TOR = Usage Last Year / Qty OH End of Last Year - All amounts are based on the highlighted location.

Programs Modified: IM0500, IMGQTYSD

CLS

 




    • Related Articles

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

    • Avalara - Stock Status Inquiry

      Release Date: 4/28/23 Version: 8.6 and Above When the Avalara Integration is enabled, the Stock Status Inquiry that is launched from Customer Order Processing-> Inquiry-> Stock Status Inquiry will show the estimated tax percentages for a customer ...

    • IM0500Q Inventory Management Stock Status Inquiry

      Stock Status Inquiry Application Overview This function provides you with a wealth of customer service information available by using Function Keys. For maximum benefit, the users should thoroughly familiarize themselves with the many item inquiry ...

    • Feature - Drill Down to Where Used from Stock Status Inquiry Screen

      Release Date: 9/27/16 The purpose of this project is to allow users to drill down to BOMP Single Level Where Used Inquiry. The current Single Level Where Used Inquiry application cannot be called from another application. Also, the list that is shown ...

    • Feature - Stock Status Inquiry Store Location in Registry

      Release date: 6/18/2020 Version 8.5 & Up The stock status inquiry program has various logic to determine location. If the particular user already has a way to determine default location, this project will not override it. If the default location is ...