Difference between revisions of "How do I find Stock History?"
From Catalyst
(→See Also) |
Katy Kitchen (talk | contribs) |
||
| (9 intermediate revisions by 4 users not shown) | |||
| Line 3: | Line 3: | ||
== More Information == | == 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 {{Menu|{{ST}}|Stock Reports|History Reports|Stock History}}. | Go to {{Menu|{{ST}}|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. | + | * 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. |
| − | {{Note | + | {{Note|text=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 {{DataPrompt|Movement Type:}}. This can be switched between the following options | There is also a drop down box at the top of the report headed {{DataPrompt|Movement Type:}}. This can be switched between the following options | ||
| − | *All | + | * {{DataValue|All}} |
| − | *Sales | + | * {{DataValue|Sales}} |
| − | *Purchases | + | * {{DataValue|Purchases}} |
| − | *Adjustments | + | * {{DataValue|Adjustments}} |
| − | These can be used in conjunction with the filters to make this a very flexible report. | + | These can be used in conjunction with the filters to make this a very flexible report. |
| − | {{Example | + | {{Example|text=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 {{DataValue|Purchases}} and this will give the required result.}} |
Once the relevant fields have been entered, press {{KeyPress|F2}} or left click {{Button|Start}}. | Once the relevant fields have been entered, press {{KeyPress|F2}} or left click {{Button|Start}}. | ||
| − | == | + | === View/Print Information === |
| − | + | Prior to clicking {{Button|Start}} you may choose {{DataValue|Screen}} or {{DataValue|Printer}} from the {{DataPrompt|Print/display report}} drop down. | |
| − | + | ||
| − | * | + | * Alternatively, view the report on screen then click the {{Button|Print Selection}} button. |
| − | * | + | * Choose {{Button|Print}}, {{Button|Excel}} or {{Button|CSV}}. |
| − | + | ||
| + | == See also == | ||
* [[How do I find a stock code?]] | * [[How do I find a stock code?]] | ||
| − | * [[ | + | * [[What is the Stock Period?]] |
| − | * [[How do I | + | * [[How do I View Who Dealt with a Stock Item?]] |
| − | {{KB_Tags| | + | {{KB_Tags|stock, history, sales, who bought, who purchased, previous purchase, stock take, previous sales, stock level, purchases, adjustments}} |
| − | {{FAQ}} {{KB_ST}} | + | {{FAQ}}{{How}}{{KB_ST}} |
Latest revision as of 14:09, 15 March 2023
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
