Stock Movement Enquiry
Follow
George Sutton
Updated : Created :
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.
NOTE: For month-end reporting, it is best to wait a day or two before running this report for the previous month.
Column Headers
Based on the filters you enter at the top, you can see several different figures in the grid:
Date From and Date To: Set the date period (start date and end date) for the enquiry
Note: most transactions included in the date range are based on transaction completion dates, however purchases will be based on the receipted date.
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 the only hidden column by default. It will show the change in Average Landed Costs (ALC) 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
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 Costs3Where:
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)
Example:
StartingSOH = 100000.00
ClosingSOH = 300000.00
Change of SOH value over period = 300000.00 – 100000.00 = 200000.00
Transactions:
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 and CSV using the Export button on the banner.
Using the toolbar above the grid, you can do several other things to the information shown in the grid.
These are described as follows:
- 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.
With the Shared tick box ticked this new view will be available to all users who have permission to view the Stock Movement Enquiry.
- 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 tick or untick a field from the Column Chooser.
Then you can move your columns on the grid, click on the headings and drag and drop the columns in the order you prefer. When you are done click on Hide Toolbar.