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.

Prerequisites

Managing Cin7 Core Reports

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

Input:

Reporting Period	Allow user to select the reporting period from a list of options or set a custom date range.
Filter By	Allow user to filter by Stock Movement Date or by Transaction Effective Date
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 Cin7 Core 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 Configure Layout menu to add some of them to your report.

Fields
SKU	Product SKU.
Product	The name of the product.
Unit	Product unit of measure.
Location	Location name.
Batch #	Batch number of product.
Expiry Date	Expiry date of product.
Bin	Bin where stock is located within location.
Type	Type of movement. In or Out of the location.
Reference	Task reference responsible for stock movement.
Date	Effective date of stock movement
Year	Year of effective date of stock movement.
Quarter	Quarter of effective date of stock movement.
Month	Month of effective date of stock movement.
Tags	Comma-separated product tags.
Category	Product category.
Brand	Product brand.
Family	Product family name.
Stock Locator	Location in the warehouse.
Product Additional Attribute 1-10	Values of product additional attributes.
Barcode	Product barcode.
Data Headers
Quantity In	Quantity of stock moved into the location
Quantity Out	Quantity of stock moved out of the location
Cost In	Cost of the stock moved into the warehouse in base currency.
Cost Out	Cost 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

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 Cin7 Core 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 authorized, 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 Cin7 Core 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 location. The 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.

What do the transaction type acronyms stand for?

PO - Purchase order

SO - Sale order

ST - Stock adjustment/stocktake

TR - Transfer order

FG - Assembly order

FO - Fulfillment order

MO - Production order

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

Inventory Movement Details Report

Prerequisites

Input:

Output:

FAQs

Was this article helpful?