Summary

The Usage report displays a filtered range of transactions that had an effect on an item’s quantity.

When printing Inventory Control module reports, be aware that inventory counts and the transactions that affect those counts are date and time specific. In order to generate an accurate inventory report, confirm that both the date and time specified are correct.

Step by Step

1     Open the Usage Report window (IC> Report> Usage).

2     Configure the report. 

• Check the Action toggle for each inventory process or action you would like to add to the report.
  • Check the toggle in the header to select all.
  • At least one action must be specified in order to run the report.
• Check the Location toggle for each location that you would like to add to the report.
  • Check the toggle in the header to select all.
  • At least one location must be specified in order to run the report.
  • Locations are created and maintained on the Location Maintenance window (IC> Maintenance> Location).
• Enter an Item ID or click the field search button to select on from a list.
  • Inventory Items are created and maintained on the Item Maintenance window (IC> Maintenance> Item).
• Enter a Description to filter the items included in the report to those items that contain the specified terms in their description fields.
• Use the Transaction Date From and To fields to specify a transaction date range for the report.
• The Time field is used to filter the transactions included in the report to those transactions that were committed before the specified time.
  • In order to filter the report by a specified time, you must select a date in the Transaction Date To field.
  • This field will default to the current time.
• Use the Commit Status drop-down menu to determine if the report will include committed, uncommitted, or all transactions.
• Enter a Max Issued value to limit the inventory items included in the report to those that have a total issued amount for the specified transaction range that falls below the max issued value.
• The six fields to the right are miscellaneous character fields. The displayed labels for these fields are set up on the Miscellaneous Field Label Maintenance window (SS> Utilities> Miscellaneous Field Labels).
• Check the Print Archived Only toggle to limit the transactions included in the report to transactions that have been archived through the Archive Transactions process (IC> Utilities> Archive Transactions). 
• Check the Print Reorder Points toggle to include a Reorder Point column in the report.
• Check the Print Reversals toggle to include reversal transactions in the Action Type column.
• The report will display the Transaction Date and Time, Action Type, Transaction Description, and Quantity for each usage transaction sorted by inventory item and location. The report will also provide item and report totals for Initial Quantity, End Quantity, and Ending Value.

3     Print the report.

• Once the required report settings have been specified, click the Print button to print your report.
• Click the options arrow on the right side of the Print button to see other print options.
  • Select PDF to print the report in the default Springbrook PDF format.
  • Select Excel to export the report data to an Excel spreadsheet as unformatted data.
  • Select Excel (Formatted) to export the report data to an Excel spreadsheet that includes much of the Springbrook formatting found on the printed version of the report.
  • Once a print option is selected, that option will automatically be selected the next time you access the report. For example, if you select Excel from the drop-down menu, the next time you access the report the Excel button   will be displayed by default.
• Click the Schedule icon next to the Print button in order to schedule the report to generate at a later date and time.
  • Enter a Date and Time to generate the report and click SUBMIT.
• Users can also regenerate a report with the same configuration as a prior report via the report history section. This can help improve efficiency when an identical report is frequently generated.
  • Once a report has been generated, the date and time it was generated will display in the report history accessed via the Expand Arrow button   on the right side of the window.
  • Expand the report history and click on a previous report record to automatically populate the report criteria with the criteria specified on the previously generated report. Hover over the Info icon to view the parameters on the previous report.
  • This section will display the last ten times the report was generated.