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
To navigate to the Commissary Order History by Item report, click 'My Reports' under 'Reports' in the left pane and select 'Commissary' in the top header of the reporting window. Once opened, a listing of reports will be shown.
Find 'Commissary Order History by Item' and select 'Customize' next to the report. This will open up a listing of all Report Parameters that can be used to define your report.
Report Parameters
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 desired action. Click here to learn more about this functionality
Click here to learn more about Report Views and their added functionality.
Report Columns
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 (#4) and the amount that was fulfilled (#5)
$ 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 (#7) and fulfilled (#8)
% 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.