The Inventory reports page contains reporting information about Inventory Categories and components (Stock items and recipes).
- Transfer Summary - A breakdown of stock item quantity and cost associated with inventory transfers by stock item and store
- Waste/Gratis Cost - Count and cost of all waste and gratis from standsheets used during an event
- Supplier Purchase Summary - stock items received cost and quantity over time
- Inventory Detail Report - On-hand counts, average cost, and inventory value sorted by location and inventory category
- Outstanding Purchase Orders - All purchase orders that have been submitted but not received
- Receiving Log - Breakdown of the actual cost of purchase orders versus the expected cost of purchase orders by inventory category
- Recipe Cost - Breakdown of recipe cost by ingredient
Transfer Summary
A breakdown of stock item quantity and cost associated with inventory transfers by stock item and store.
The Cost of Transfer column is a weighted average of the cost of the item every time you purchased it.
This is weighted average calculation for the example above:
(244×1.5+480×1.5+96×1.5+48×1.5+240×1.5+5×1.4+480×1.25) / (244+480+96+48+240+5+480) = 1.42435656
Average cost of 1 unit x # of units transferred = cost of transfer
1.42435656 x 24 = $34.18
Waste/Gratis Cost
This report is generated through the use of standsheets during Events and filling out the waste and gratis columns in the standsheet.
You may filter by Event to see the waste and gratis cost of all items during the event.
Additionally, you can hone in on any one Stock Item by using the stock item filter.
Supplier Purchase Summary
The Supplier Purchase Summary shows the total quantity of stock items received (displayed in the base unit of the stock item), the total received cost (calculated from the purchase orders), and organized by supplier and inventory category.
Inventory Detail Report
This report contains on-hand counts, average costs of inventory, and your inventory value grouped by Location, Inventory Category, or both.
The Count on Hand will reflect the quantity that is at your Inventory Status page for that location.
Outstanding Purchase Orders
Receiving Log
A list of all Purchase Orders where goods have been received. The Expected Total Cost column displays the cost of one unit. The Total Received Cost displays the total cost of goods received once you close and receive a purchase order.
Note: The Total Received Cost can be negative if you make a P.O. just for a return.
Example of a P.O. used to make a return: