How do I find Stock History?
From Catalyst
Summary
This article explains how to get the detailed history of any items of stock in the system.
More Information
This report can be used in several different ways, for example:
- To find out how the current stock quantity has been calculated i.e. show all sales, purchases and adjustments for an item.
- To find out which customer bought a particular item or items.
- To find out from whom an item/items were purchased.
- To find out which items were sold under a specific invoice number.
Go to " Stock Control Stock Reports History Reports Stock History".
- There are a number of filters on the report that can be used to restrict the report to a particular stock code, group or supplier etc.
 | These filters are optional, not mandatory and as such you do not have to fill in all of them, only the ones you need. |
There is also a drop down box at the top of the report headed "Movement Type:". This can be switched between the following options
- 'All'
- 'Sales'
- 'Purchases'
- 'Adjustments'
These can be used in conjunction with the filters to make this a very flexible report.
 | If you want to see all the parts you have purchased from a particular supplier in a date range, fill in the dates, the supplier account code and set the movement type to 'Purchases' and this will give the required result. |
Once the relevant fields have been entered, press <F2> or left click [Start].
View/Print Information
Prior to clicking [Start] you may choose 'Screen' or 'Printer' from the "Print/display report" drop down.
- Alternatively, view the report on screen then click the [Print Selection] button.
- Choose [Print], [Excel] or [CSV].
See also
