Inventory Reports - Ageing

Overview

This report shows how long inventory has been kept in stock. It will pinpoint inventory that is just sitting on the shelves.

Navigation: Main Menu > Procurement > Inventory > Menu (button) > Ageing.

Table of Contents

Buttons Explained

  • View: Generates an Inventory Ageing Report based on the selected filters.
  • Output: Available upon request.
  • Menu

Filters Explained

  • Category: A dropdown list of categories allowing users to view All or a specific Category.

Fields Explained

  • Field Chooser (*): Allows users to add or remove columns.
  • Stock ID: A system-generated number for the inventory item.
  • Category: The inventory item's Category.
  • Sub-category: The inventory item's Subcategory.
  • Description: A Description of the inventory item.
  • Reference: The inventory item's Reference.
  • Code: The inventory item's Code.
  • Location: The Location of the inventory item.
  • Columns showing how long the inventory item has been held are available for:
    • 4+ years: Inventory held for longer than 4 years.
    • 4 years: Inventory held for 3 - 4 years.
    • 3 years: Inventory held for 2 - 3 years.
    • 2 years: Inventory held for 1 - 2 years.
    • 1 year: Inventory held for 181 days - 1 year.
    • 180 days: Inventory held for 121 - 180 days.
    • 120 days: Inventory held for 91 - 120 days.
    • 90 days: Inventory held for 61 - 90 days.
    • 60 days: Inventory held for 31 - 60 days.
    • 30 days: Inventory held for less than 30 days.
    • Total: The total of all the columns and Total Inventory held.
  • Menu (...): A submenu that can also be accessed by right-clicking an item:
    • Open Item: Opens the item's setup page.
    • Open Item Dashboard: Displays a Summary of the item's activity.

Inventory Ageing Chart

  • A graphical representation of the inventory ageing data.

Related Topics