Chapter 84: Printing the Stock Aging Report (STAG)

Purpose: The Stock Aging report lists all items (by vendor and/or warehouse) that are older than a given number of days.

How the system ages stock: The system places stock in 6 aging buckets. In order to determine which items it should place in each bucket, the system looks at the stock's inventory transaction history records. The search starts with the most recent positive increase for that item/location, and then works its way to the last positive increase on file.

The system does the following if it finds an inventory transaction record:

• looks for the most recent positive increase, and checks the date of the transaction

• checks the number of units involved in the transaction.

• puts the stock into the appropriate aging bucket

• provides a cost for the transaction

If the system does not find an inventory transaction record, it puts the stock into the over 120 days aging bucket.

In this chapter:

• Stock Aging Report Screen

• Stock Aging Report

Stock Aging Report Screen

How to display this screen: Enter STAG in the Fast path field at the top of any menu or select Stock Aging Report from a menu.

INR1098 ENTER Stock Aging Report 7/17/97 12:12:44 The Mail Order Company Select vendor# . (leave blank for all vendors) Selected warehouse . (leave blank for all warehouses) Show stock older than days F3=Exit F12=Cancel

Field	Description
Select vendor #	The Vendor # representing the vendor who supplied you with the items you want listed on this report. Alphanumeric, 7 positions; optional.
Selected warehouse	A code representing the Warehouse that holds the items you want listed on this report. Alphanumeric, 3 positions; optional.
Show stock older than _______ days	The specification of how old you want the items listed on this report to be. Numeric, 5 positions; required.

How to print this report: Complete this screen to generate the Stock Aging Report according to your selections. A message similar to the following displays at the bottom of the screen informing you that the report has been printed:

 

Job 355892/LIZ_P/STOCK_AGE submitted to job queue QBATCH in library.