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

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 is and thus to evaluate a buyer's performance. You can also see the same information in I/M -> Reports > Inventory Aging Report.

Note that field "27. Age Days" in Item Master is not updated automatically. If you'd like to keep age days up-to-date, you should run the following application by going to Global Setup -> Utilities -> I/M Utilities -> Generate Statistic Information -> Recalculate Item Inventory Age Days. You can add this to your Deferred Processing and let it run every night.

The new Stock Status Inquiry screen will look like the following sample screen:

Note the "Weight" field was also moved to the left and the "Class" (Inventory class, A, B, C...etc.) field was moved down one line to make space for "Age Days" and "Last Calculated Date." 

If your Global Setup -> COP-Ctl -> Stock Status Inquiry -> "11. Display Next Year ATP Usage & replace UDC ?" is set to "Y," then your Stock Status screen will look something like the following:


Modified program: IM0500

DLM






    • Related Articles

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

    • Customer Account Summary Inquiry Age Days Calculation Logic

      Release Date: 07/07/2021 Version: 8.5 Q - In A/R Customer Account Summary Inquiry, what is the logic on a partially paid invoice? See example below: In the above example, invoice number AXI990 was partially paid on 6/18/21. That is 49 days after the ...

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

    • Feature - From Newly Received Items Inquiry to Drill Down to Stock Status Inquiry

      Released Date: 02/11/2025 Version: 8.5 & Up In COP -> Inquiry -> Newly Received Items Inquiry, an F5=StkSts option is added to support drilling down highlighted items to the Stock Status Inquiry screen. See sample screen below: Modified Programs: ...

    • ARAGEBAL Accounts Receivable Age Customer Accounts

      Age Customer Accounts Application Overview In the Customer file there are four fields that store the age amounts for period‑1, period‑2, period‑3, and period‑4 for each customer as of the last age date. The primary use of these fields is for display ...