Stock Aging Report

How to print: Complete the Stock Aging Report Screen.

For more information: See the sample report in PDF format.

Contents:

• vendor number

• item

• SKU

• warehouse where the item is kept

• location where the item is kept

• on-hand quantity (the number of units at the location)

• reserved quantity for the item in the warehouse (appears for the first location listing for the item in the warehouse)

• quantity of the item on printed pick slips for the item location

• pending transaction quantity

• date of the last physical inventory for this item location

• date when the item was first placed in this location

• aged units and cost associated with inventory from inventory transactions (the extended cost appears below the number of units) broken out into the following aging buckets:

• 1-30 days old

• 31-60 days old

• 61-90 days old

• 91-120 days old

• 120 days old or more

• average, standard, or FIFO cost from the SKU table, depending on your Costing Method (A25). If the system does not find a cost in the related field, it uses the Default cost from the Item table, even if the item has SKU’s.

• extended cost (cost multiplied by units on-hand)

• Buyer assigned to the item