This report itemizes inventory and value per warehouse by product as of a specified date and time (based on the time the service runs, which is once per night, and shown in the Timestamp column of the report when it is exported to Excel).
The report displays a separate row for each product for each warehouse. If a product has inventory in three warehouses, there will be three rows for the product.
- Value is based on the Item Cost of the product on the specified date.
- While there are 3 item costs available to use – Average, Last, and Site – the cost saved to the report is what the Client Setting Order Profit & Loss Calculated Using:________ was set to on the date specified.
- By default, when the Warehouse filter is set to “All Warehouses,” the report will include dropship warehouses. To exclude those warehouses from the report and total, click the Do not Include Dropship Warehouses setting.