Inventory Report: Most Used Material

This article supports Legacy Inventory, previously known as Systemize Inventory Edition, which is supported but no longer available for purchase.

Click here to access the new Moraware Inventory Knowledge Base.

Sometimes our customers want to see which material they have used the most for a given period. This Report can show you how much of a Product you have allocated over the date range you set.

  1. Go to Reports > + Create.
  2. Choose a Time Selection that matches your needs. To include everything, choose Custom with a starting date far in the past.
  3. Click the ... to the right of Measure and choose:
    Subject Area: Job Activity
    Measure: Total Allocated Product Quantity
    by Time Field: Activity Date
  4. Click Save.
  5. Click the + to the right of Display Fields. Choose the material Fields that you want to measure.
    Allocated Product Variant is most specific, Allocated Product Family is least specific.

Your Report will look like. You can click the column header for Total Allocated Product Quantity by Activity Date to sort by the materials most used.