As you create and receive your inventory over time you will likely have a range of costs associated with that inventory. While Beacon is not an ERP with advanced MRP functions, we can still help you understand the total cost valuation of your inventory and your weighted average unit cost.
The Weighted Average Cost Report provides a view of your inventory valuation. This report presents a concise table that focuses on the weighted average cost of goods, organized by catalog item.
Available Filters:
Manufacturer
Custodian
Inventory Type
Product Line
Catalog #
Lot #
Expiration Date
Is Active? (Yes/No)
Is Kitted? (Kitted/Loose)
Created Date
Location Name
Facility
Event Inventory Status
The Report
The Weighted Average Cost Report will provide you with catalog #, Count of inventory, total cost of goods, and the weighted average cost (WAC).
To Export this data:
Click Refresh on the report table to apply filters
Click on the vertical ellipse or Kabob menu that appears when you hover over the upper right corner (Tile Actions)
Select Download Data
Choose your File Type
Change your download settings. The most common download for a .CSV or Excel file should use the following settings. It is critical to use these settings to ensure all of the data is able to export.
In Results, select "With visualization options applied"
In Data Values, select "Unformatted (no rounding, special characters, etc.)
In Number of Rows to Include, select "All Results"
This is very important as your data set may extend farther than Looker is able to display visually in Beacon, but you want to make sure to export all data.
Click Download
