Stock Movement EnquiryFollow
About Stock Movement
The Stock Movement page enables you to view several important figures. These can range from the opening stock, purchases and closing stock for a defined period. You can access the Stock Movement report via Reports | Inventory | Stock Movement.
Based on the filters you enter at the top, you can see several different figures in the grid:
Date from: & Date To: Set the date period (start date and end date) for the enquiry
Opening SOH: This is the value of your stock at the beginning of the period
plus Purchases: This is the total purchases less any supplier returns for the period
Less Cost of Goods Sold: This is the value of the goods you sold during the period
plus Credits: This is the total of any credits you issued during the period
plus Stock Adjustments: This is the total of Stock Adjustments and Stock-take Adjustment transactions
plus Other Costs: This is the total of any other changes that impact your stock value, this includes (but is not limited to) costs related to importing stock for new products, costs created during the assembly process and costs differences between warehouses when doing transfers.
ALC Change: This is only shown when you run the report filtered by a warehouse. It will show the change in Average Landed Costs that occurred in other warehouses but will have impacted your Closing SOH value.
Closing SOH: This is the value of your stock at the end of the period
You can run a transaction enquiry for the related period and group by the "Transaction Type" column. Each transaction type should reconcile as per the descriptions.
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 Starting and Closing stock values. This difference is attributed to “Other Costs”, even though it’s not directly applicable to any specific transaction like the other displayed costs are.
Other Costs for the period are calculated as follows:Closing SOH1 – Starting SOH2 – Displayed Costs3
1 = the sum of all product’s SOH quantity * ALC at end of period
2 = the sum of all product’s SOH quantity * ALC at start of period
3 = (+ Purchases – Sales + Credits + Adjustments)
StartingSOH = 100000.00
ClosingSOH = 300000.00
Change of SOH value over period = 300000.00 – 100000.00 = 200000.00
Sum of all Purchases for period = 200100.00
Sum of all Sales for period = 500.00
Sum of all Credits for period = 0.00
Sum of all Stock Adjustments for period = 0.00
Sum of all transactions = 200100.00 – 500.00 + 0.00 + 0.00 = 199600.00
Difference between 'SOH Value Change' and 'Transaction Value'
200000.00 – 199600.00 = 400.00
This 400.00 is attributable to multiple transactions for the same products across the period that change the ALC of these products with each transaction using a different ALC which does not match the ALC used for the starting and closing SOH values.
In some cases, there are no actual costs to be considered for the Other Costs value, and this value is down to the changes in ALC over multiple transactions during the date range.
In some cases, a more recent purchase of a product at a higher price compared to the first purchase will result in a Closing SOH value using the higher ALC compared to earlier transaction’s values calculated using a lower ALC.
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 banner. You can also export what you see to several different formats such as pdf, xls and .xlsx using the Export button on the banner.
Using the tool bar above the grid, you can do several other things to the information shown in the grid.
These are described as follows:
- Group By Column(s):
To group by a desired column you simply need to drag and drop it into toolbar above the grid. As soon as you drop it the grid will group everything based on that column. You can group by as many columns as you like and expand all or collapse all the groups under the More menu.
- Create Multiple Views:
To set up multiple views of this report you just need to click New on the toolbar and give it a name after making any customizations. You can create as many views as you like and also choose a default which will be displayed when you first click on the report.
- Customize Columns Shown:
Using the Hidden Columns button you can choose what columns are shown on the grid and where. To add or remove a column, simply drag and drop the columns you like to and from the Hidden columns box.