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. See Related Articles below for help saving your Report.

  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.time selection and measure for report on allocated material
  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.adding allocated product display fields

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.

sample report most used material