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

    • Feature - Added Browse Through Items When in the Stock Status Inquiry

      Release date: 9/28/2018 Added the ability to browse through items when in the Stock Status Inquiry. The first time in the application the user must provide the item number and the location. Once the user escapes back to the Item Number field, they ...

    • Feature - Add Age Days and Last Calculated Date to Stock Status Inquiry

      Release date 1/9/2021 Version 8.5 & Up This feature adds "age days" and "last calculated date" to the Stock Status inquiry screen. These fields come from Item File Maintenance field 27: Age days is a good way to indicate what your inventory turnover ...

    • Blanket POs Not Displaying on Stock Status ATP Screen

      Release Date: 3/20/2019 Q - How can I get Blanket POs to display on the Stock Status ATP screen? You show it on the legend as code "PB" but it doesn’t appear on the screen. See sample screen below: We use the blanket PO for estimated dates for ...