Inventory Movement Details Report

The report shows a summary of stock movements in a specified timeframe. Use this report to see inventory movement details for specific transactions including transaction reference, date, quantity in and out and cost in and out.


Only users with the Inventory Reporting permission can access this report.


Prerequisite:


Table of Contents:


Data from this report can be exported in Excel, PDF or RTF format. 


Input:

Reporting PeriodAllow user to select the reporting period from a list of options or set a custom date range.
Filter ByAllow user to filter by Stock Movement Date or by Transaction Effective Date
LayoutSet to the Default layout. Allows selection of saved layouts, if any. 
Save Layout AsAllows saving of a layout for potential future use.
Reset LayoutResets 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. 


Output:

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. 


Fields
SKUProduct SKU.
ProductThe name of the product.
UnitProduct unit of measure.
LocationLocation name.
Batch #Batch number of product.
Expiry DateExpiry date of product.
BinBin where stock is located within Location.
TypeType of movement. In or Out of the location.
ReferenceTask Reference responsible for stock movement.
DateEffective date of stock movement
YearYear of effective date of stock movement.
QuarterQuarter of effective date of stock movement.
MonthMonth of effective date of stock movement.
TagsComma-separated product tags.
CategoryProduct category.
BrandProduct brand.
FamilyProduct family name.
Stock LocatorLocation in the warehouse.
Product Additional Attribute 1-10Values of product additional attributes.
BarcodeProduct barcode.
Data Headers
Quantity InQuantity of stock moved into the location
Quantity OutQuantity of stock moved out of the location
Cost InCost of the stock moved into the warehouse in base currency.
Cost OutCost of the stock moved out of the warehouse in base currency.


NOTE: If you have added an Additional Attribute set to your sale or purchase processes, the attributes will appear as additional report fields. 


FAQs

[back to top]



The report has a report generation filter called filter by either stock movement date or transaction effective date. Can you advise what precisely do these dates constitute? e.g. is the transaction effective date the date of the SO? or invoice date? is 'stock movement date' effectively the date by which the order is marked as fulfilled?

Stock Movement date is the card movement date ("stock movement" is the change of an order's status from unfulfilled to fulfilled). Transaction effective date is based on the effective date of the transaction associated with the movement. And for Transaction Effective Date we will filter by transaction date, not movement date.


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. 


I have exported an inventory movement details report. Upon exporting it I realised that a few sales invoices which should have had "cost out" figures within the report weren't there. On the Inventory movement details report I am unable to find this COGS amount from this invoice although it appears in Xero. Could you please provide reasoning as to why? and how I can have ALL COGS movements shown on the Inventory Movement Details Report. 
COGS is is usually reflected in DEAR upon authorization of the Ship tab using the Ship date as the effective date of the COGS manual journal. It is never based on Invoice. If the stocks didn't have any cost at such time (e.g. Stock Received tab was completed but Invoice tab has not been completed yet, so stocks didn't have any value), then the entry will be reflected at 0 amount initially, but once the Purchase Invoice tab to which those stocks came from is authorised, then the COGS will be automatically updated with the correct value. The effective date will then no longer be the Ship date but will use the date of the transaction which triggered the update.


Looking for a report that will allow me to view inventory by sku, production date/ expiry date, and location.

"Inventory Movement detail" 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.


What does the Transfer Out column represent vs Transfer In? 

Transfer out could mean anything from sales order, stock adjustment, stock transfer, to unstocks. It's basically any transaction that creates a product movement to go out of the location, while transfer in could also be from stock receives from PO, to stock adjustment, transfers and restocking, and any product movement comes in the locationThe reference field should tell you what transaction the movement is involved in.


I need to know how I can apply a filter so I can just see the totals of each of the items we have in inventory. Just the totals nothing else. Is this possible?

For the totals only per item, you can try the Inventory Movements Summary Report instead.


Still no answer to your question? Please do not hesitate to get in touch with DEAR support.







Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.