Inventory Reports
      Back to home
      1. Craftable Learning Center
      2. Reports
      3. Inventory Reports

      AVERAGE PRICE DETAILS REPORT

      Average Price Details Report

      The Average Price Details Report allows you to see the Average Price of your Items alongside their current Inventory over a selected Period or Date Range. Refer to the steps below on how to view the Average Price Details Report.

      Viewing Average Price Details Report

      1. Click Reports > Reports List from the navigation.

        mceclip1.png

      2. Click Average Price Details under the Inventory heading.

        mceclip0.png

      3. Filter by Period/Date.

      4. Click Go to view the results.

        mceclip2.png

       

      Some things to keep in mind

      • Each column in the report can be clicked on to reorganize the data. 
        For example, you can click on Inventory Average to see in descending order which Items are currently the most valuable. 

      • Export the data in this report to Excel by clicking the download button in the upper right.

      • The report will default to pulling data by Period (time between audits). 
        If you do not see the desired results initially, try filtering By Date.

      Column Key

      ID: Item ID (optional)

      Item: Name of Item

      Received: Total quantity of Items received through vendor invoices 

      Amount: Total $ value of Item received through vendor invoices 

      Avg Price: Amount / Received (or Inventory Average if Received is zero).

      Inv Qty: Total quantity of Items counted in inventory 

      Inv Amt: Total $ value of Item counted in inventory 

      Inv Avg: Inv Amt / Inv Qty