Stock Movement Enquiry
Follow
Heather
Updated : Created :
The Stock Movement Enquiry provides an overview of how your inventory has changed over a set period of time. Using the costs attributed to your goods upon receipt, production and their current value upon holding and dispatch the Stock Movement Enquiry calculates the Opening, Closing and current Stock On Hand (SOH) values for the period.
Tip: For month-end reporting, it is best to wait a day or two before running this report to ensure all results are accurate.
Functional descriptions
To use the Stock Movement Enquiry, go to Unleashed's main menu and select Reports, Inventory, Stock Movement Enquiry.
Header button descriptions
In the top right corner of the Stock Movement Enquiry there are two action buttons available, Export and Run:
- Export: Use the dropdown option on the Export button to download the current Stock Movement Enquiry view as either a PDF or CSV file.
- Run: Click on Run to populate the Stock Movement Enquiry report, using the parameters set in the filter fields available.
Header field descriptions
Use the filter fields available at the top of the Stock Movement Enquiry to refine the report based on the parameters selected. The filter options available to the Stock Movement Enquiry are:
- Date From: Use the date selector to set a starting date for the results to populate from.
- Date To: Use the date selector to set an end date for the results to populate to.
- Warehouse: Use the dropdown menu to filter by warehouse.
- Product Code: Use the free text field to search and select a product by it's code.
- Product Description: Use the free text field to search and select a product by it's description.
- Product Group: Use the dropdown menu to filter by Product Group.
- Supplier Code: Use the free text field to search and select a Supplier by it's unique code.
- Supplier Name: Use the free text field to search and select a Supplier by it's unique code.
The Supplier Code and Name filters are designed to filter the Stock Movement Enquiry based on the products that have the selected Supplier set as a default Supplier in product's Purchase tab. For more details, see Create Products: Purchase tab.
NOTE: Most transactions included in the date range are based on transaction completion dates, however purchases will be based on the receipted date.
Grid column descriptions
By default, the grid columns listed in the following table will populate for the Stock Movement Enquiry. A breakdown for how all but the "plus Other Costs" figures have been calculated can be found using reports that exist in Unleashed, each of which has been described against their description.
| Grid column | Description | Report in Unleashed |
|---|---|---|
| Year | Displays the year the results have populated for. | N/A |
| Month | Displays the month the results have populated for. | N/A |
| Opening SOH | Displays the total value of your SOH at the beginning of the period selected. |
Use the Stock on Hand Enquiry to review the opening SOH value per product per warehouse, see Stock On Hand Enquiry Tip: Use the Stock Movement Enquiry's "Date From" value as the "Date To" filter in the SOH Enquiry. |
| plus Purchases | Displays the total value receipted for Purchase Orders minus any Supplier Returns. |
Use the Transaction Enquiry to review the products that have been receipted and recosted or returned per Purchase Order for the given period, see Transaction Enquiry. Tip: Use the Transaction Type filter for Purchase Order, Purchase Order Recost and Supplier Return. |
| less Cost of Goods Sold | Displays the total value of the stock dispatched on Sales Shipments during the period. |
Use the Transaction Enquiry to review the products that have been dispatched on Shipments for the given period, see Transaction Enquiry. Tip: Use the Transaction Type filter for Sales Shipment. |
|
plus Credits |
Displays the the total value of stock returned from Credit Notes. |
Use the Transaction Enquiry to review the products that have been dispatched on Shipments for the given period, see Transaction Enquiry. Tip: Use the Transaction Type filter for Sales Shipment. |
| plus Stock Adjustments | Displays the total value adjusted from Stock Adjustments or Stock Counts (Stock Takes). |
Use the Transaction Enquiry to review the products that have been returned to stock on a Credit Note for the given period, see Transaction Enquiry. Tip: Use the Transaction Type filter for Stock Adjustment and Stock Take Adjustment. |
| plus Other Costs |
Displays the total value of any other changes that impact your stock value, this includes but is not limited to costs related to importing stock for new products, assemblies and warehouses transfers. |
The is not a single report in Unleashed that lists the values used to calculate "plus Other Costs". For a breakdown of how the plus Other Costs is calculated see plus Other Costs. |
| Closing SOH | Displays the total value of your SOH at the end of the period. |
Use the Stock on Hand Enquiry to review the closing SOH value per product per warehouse, see Stock On Hand Enquiry Tip: Use the Stock Movement Enquiry's "Date To" value as the "Date To" filter in the SOH Enquiry. |
plus Other Costs
SOH values are calculated using the exact ALC at that time, whereas the value of each transaction is calculated using the ALC at the time of that transaction. This means that the sum of the transaction values may not equal the difference between Opening and Closing stock values. This difference is identified as “Other Costs”, as they are not directly applicable to any specific transaction.
Other Costs are calculated as follows for any given period;
Closing SOH – Opening SOH – Displayed Costs = Other Costs
- Opening SOH = SOH quantity * ALC at the start of the period.
- Closing SOH = SOH quantity * ALC at the end of the period.
- Displayed Costs = Purchases - Cost of Goods Sold + Credits + Stock Adjustments
Other Costs example:
Over a one month period, the following values have been calculated and populated for the Stock Movement Enquiry:
Opening SOH = 100000.00
Closing SOH = 300000.00
Purchases for period = 200100.00
Cost of Goods Sold for period = 500.00
Credits for period = 0.00
Stock Adjustments for period = 0.00
Displayed Costs = 200100.00 – 500.00 + 0.00 + 0.00 = 199600.00
As such, the plus Other Costs value has been calculated; Other Costs = 300000.00 - 100000.00 - 199600.00 = 400.00
The 400.00 Other Cost is linked to various transactions involving the same products over the period. Each of these transactions alters the Average Lost Cost (ALC) for the products, with each transaction applying a different ALC. This variation means that the ALC used does not correspond to the ALC applied for the initial and final Stock On Hand (SOH) values. As a result, there is a discrepancy in the cost calculations related to these products.
Hidden Columns
Customize the Stock Movement Enquiry's grid view by adding or removing columns from the Hidden Columns list. To add or remove a column, click on Show Toolbar above the grid then select Hidden Columns. Use the checkboxes available in the "Column Chooser" to either include or remove the column from the grid's view.
The additional columns available in the Columns Chooser is:
- ALC Change: Displays the total change in Average Landed Costs (ALC) that occurred in other warehouses but will have impacted your Closing SOH value.
Using the custom grid
Depending on what sort of information you require, you can enter the relevant criteria and then click Run at the top on the report's page. Using the toolbar above the grid, you can manipulate how the filtered information is displayed in the grid as follows:
- Customize Columns Shown: Using the Hidden Columns button you can choose what columns are shown on the grid and where.
- Sort by column: Click on a column's header to sort the report by that field. Click the header once to sort into descending order and click again to sort into ascending.
For more details on using custom grid views in Unleashed, see How to create and share default grid layouts.