The report shows a summary of stock movements in a specified timeframe. Use this report to see financial information such as stock on hand value, volume on hand (if dimensions are specified), unit cost and average cost for all active products on a specific date. The summary report does not show transaction references.
The report may show negative On Hand quantity in case stock is received after the To Date and some sale movements that used that stock occurred before the To Date.
Only users with the Inventory Reporting permission can access this report.
Table of Contents:
Data from this report can be exported in Excel, PDF or RTF format.
|Reporting Period||Allow user to select the reporting period from a list of options or set a custom date range.|
|Layout||Set to the Default layout. Allows selection of saved layouts, if any.|
|Save Layout As||Allows saving of a layout for potential future use.|
|Reset Layout||Resets layout to the default layout or selected saved layout.|
Select Apply Filter to set filter fields for the report and Update to refresh the output with any new changes. See Managing DEAR Reports - Filtering Reports for more detailed information about using filters.
The following output fields are available for this report. You may have to open the More Fields dropdown menu to add some of them to your report.
|Name of the product|
|Unit||The product's unit of measure|
|Location of the warehouse where stock is kept|
|Product Batch or Serial number|
|Tags||Comma-separated product tags|
|Product family name|
|Stock Locator||Location in the warehouse|
Product Additional Attribute 1-10
|Additional product attributes and their values|
|Quantity On Hand||Quantity on hand as of the end date of the selected time period|
|In||Quantity of stock moved into the location within the selected time period|
|Out||Quantity of stock moved out of the location within the selected time period|
|Unit Cost||Stock on Hand / Quantity on Hand as of the end date of the selected time period, in base currency.|
|Average Cost||Average Cost in DEAR is calculated as Value on Hand/Quantity on Hand for every given product. It is calculated from the average purchase price paid for the products including any landed costs. All historical costs of an item are used by the system to compute the Average Cost. Average Cost in DEAR is used for informational and estimating purposes only and does not affect your P&L statement.|
|Stock on Hand||Value of stock on hand as of the end date of the selected time period.|
|Volume on Hand||Volume on hand = Product Height * Product Width * Product Length * Quantity On Hand. This value will be incorrect if dimensions have not been entered in your inventory product details.|
Common sources of discrepancies:
- Stock received date is later than sale date can cause negative stock on hand values.
- Goods invoiced but not yet received. Stock in transit is not included in the report if Inventory Accruall is not enabled.
- Manual Journals that don't have any reflection in stock movements but do affect the balance sheet report.
The Transactions vs Stock on Hand report is the first place to check when encountering discrepancies between Balance Sheet and Inventory Movement Summary.
Can you please tell me why an inventory movement is missing from this report?
Usually this is an issue with the date filters. By default the date filter is set to "Last Month", however if you are part-way through the next month this may miss some recent inventory movements. Try setting the reporting period to "Last 30 days" or setting a custom date range instead. Missing entries can also be caused by cache problems. Try clearing your cache and refreshing to see if the issue persists.
Looking for a report that will allow me to view inventory by sku, production date/ expiry date, and location.
"Inventory Movement Details" and "Inventory Movement Summary" allows you to extract all of the details SKU, expiry date and location. If in the default view the headings are not available you can add the headings by clicking on the "More fields" add drag the required heading to the report. As per the current design of the DEAR the production date is only available in the Finished Goods Analysis report. As a workaround, you can add the headings PO date and Invoice date both in the Inventory movement Detail report.
There is a big discrepancy between Average Cost and Unit Cost, what is happening?
Unit Cost is calculated according to your actual Costing Method for the reporting period including landed costs. Average Cost is an estimated value calculated from the all historical purchase prices paid for the products including any landed costs. Average Cost is used for reference only and does not affect your P&L statement. Average Cost is affected by Stock Adjustments/Stock Revaluation, and stops updating if On Hand Quantity drops to 0, which can cause discrepancies in the system. See Average Cost for more information.
We are experiencing a high level of stock discrepancy between Dear and warehouse counts. To resolve these discrepancies we are starting with Inventory Movement Summary report as recommended by you. We want to compare with our warehouse count dated 31 Jan 2019. However Inventory Movement Summary is showing some negative stock levels on 31 Jan 2019. Why is this?
The Inventory movement summary shows on hand as per To report date. It can have a negative amount in case if stock received date is later than sale date for instance. Negative values can happen if you have backdated the adjustment or have future dated the stock received. Stock received date should always have date prior the stock be taken out of inventory. The Movments tab of a product is useful for determining if such an error has occurred.
The stock value as per the Balance Sheet does not agree with the stock value on the inventory movement report ending on the same date. Also the movement in stock on hand between months does not agree with the differences in stock values as per the inventory movement summary report. Why does it differ from the stock on hand figure shown on the balance sheet?
Stock in transit is not included in this report. Some of the discrepancies may be caused by Goods invoiced but not received. Please Transactions vs Stock on Hand Difference report for specific purchases that can contribute to the difference: You may want to enable accrual accounting in General Settings for purchases to properly attribute costs and generate valid transactions.
I'm seeing inaccurate values on my report. Stock on Hand is not matching Unit Cost x Quantity. Why?
Cost in this report is calculated for every batch/ serial number (client has serialised stock). But since batch field is hidden in report, Cost field is recalculated using Average function, which results in this discrepancy. If the Stock On Hand figure still doesn't match the result of Quantity on Hand * Unit Cost even after adding batch/SN information in the report, it just means that there were other succeeding transactions which were processed, and report is showing Quantity and Stock On Hand figures as of To Date of the Report, while the Average Cost shown is the calculation up to current date.
I want to get a year end inventory number for [Company]. The reporting seems to conflict in the information they present. What am I missing?
Please use the Inventory Movement Summary report. This shows the summary of stock movements in specified From-To time frame together with the stock on hand value on to date. Just filter the date you want to generate and you can also add and remove data/columns in the report.
Inventory movement summary shows on hand as per To report date. It can have negative amount in case if stock received date is later than sale date for instance, which is possible.
Inventory movement details shows details between report dates.
Discrepancies can also be caused by the fact that Product Stock Level Report only shows stock products with active status, while Inventory movement summary shows all.
Still no answer to your question? Please do not hesitate to get in touch with DEAR support.