The Commissary Order History by Item report lists the items that were ordered and the amount that was received within the selected time range for the selected locations. This report can be drilled into from the Commissary Order History by Category report and can further drill into the Commissary Order History by Location report in order to view which locations purchased and/or received an item.
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 |
|---|---|
Commissary Locations | A listing of all commissary locations. |
Locations | A listing of all locations that ordered from the selected commissary location. |
From Date | The beginning date for the report. |
To Date | The end date for the report. |
Categories | A listing of all commissary categories. |
Subtotal By Category | This will either subtotal the items ordered and fulfilled by category or not. |
Fulfilled Only | This will either show all commissary orders or only those that have been fulfilled. |
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 action. |
Report Columns
Field/Column | Description |
|---|---|
Item # | The number associated with the purchased item. |
Item Name | The name of the item, which is hyperlinked to the commissary order history by location report where details about the ordering of this item can be seen by location. |
U of M | The selling unit of measure from the item location record of the commissary location. |
Qty Ordered | The amount of the item that was ordered. |
Qty Fulfilled | The amount of the item that was fulfilled. |
Qty Var | The variance between the amount of the item that was ordered and the amount that was fulfilled. |
$ Ordered | The total cost of the item ordered. |
$ Fulfilled | The total cost of the item fulfilled. |
$ Var | The variance between the cost of the item ordered and fulfilled. |
% Fulfilled | The percentage of the item's cost that was fulfilled ($ fulfilled / $ ordered). |
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.
