How it works: This report displays a single item’s current on hand valuation based on on-hand adjustments from receipts/invoices and physical inventories. When generating this report, you must select one item; and select either a physical inventory or a store. Select a store if you want to see the item’s current on hand valuation. Select a physical inventory to see the item’s on hand valuation as of the time of the physical (in that store). For best results select 1 store or 1 physical.
Generating the Report:
Go to the Reports section in Yellow Dog
- Select Standard Reports
- Open the folder titled Troubleshooting
- Select “Item On-Hand Calculated Cost”
- Select Store
- Select SKU by selecting the 3 dots on the far right.
- Select Physical Inventory
- Generate report
Reading the Report
- Shows the filters used to produce the report’s data, including the date selected for the report.
- Change columns, sorting, and grouping: This allows users to add or remove data columns to this report as well as organize and group the data. Line: Line number
- Line: line number within the report
- Explanation: Information explaining on-hand adjustment that has contributed to the calculated cost.
- Date and Time: Adjustment time stamp
- Quantity: Quantity adjusted
- Cost: Cost of single adjustment
- Total Cost: Cost x Quantity
- This row allows you to save, export, print, or close the current report