The Stock Usage report displays the inventory usage for a particular account and Inventory Count. This can be beneficial in comparing Inventory Counts to see a trend and help forecast future item orders.
Navigation
The My Reports search bar can be used to search R365's entire catalog of reports.
- Open the Reports app.
- Navigate to My Reports.
- Enter all or part of the report name in the search bar.
- The Results tab will open with the list of search results.
- From beneath the report name, click Run to run the report with the selected report view.
-OR-
Click Customize to adjust the report parameters and run the report.
Report Parameters
Field/Column | Description |
|---|---|
Stock Count | A listing of all inventory counts. |
Run Button | Runs the report. Users can also send, export, or print the report directly from this button by clicking the down arrow portion and selecting the desired action. |
Report Columns
Field/Column | Description |
|---|---|
Operational Reports Categories | The categories that were connected to the items counted in the inventory count. |
Beg Inv | The end inventory count from the last inventory count for each category. The beginning inventory count references the end inventory count from the last inventory count performed with the same inventory count template and may not be the most recent count for the listed categories. When a location has multiple inventory count templates in use, Beg Inv will frequently not match the beginning inventory values on other reports and inventory count features. |
Purchases | The cost of purchased items since the last inventory count. |
Total | The total cost of items in each category (Beg Inv + Purchases). |
End Inv | The actual cost of inventory counted for each category in the inventory count. |
Use $ | The cost of items in each category that were used (Total - End Inv). |
Sales | The cost of items in each category that were sold since the last inventory count. |
% Sls | The item category's use divided by the sales. |
Inv Change | The change in inventory from the beginning count to the end count. |
Avg Inv | The average of the beginning inventory and end inventory. |
Turns | The Use $ divided by the average inventory. |
Email, Export, or Print the Report
This report can be emailed, exported, or printed in custom formatting directly from the reporting window. Click here to learn how to send, export, or print this report.
