Difference between revisions of "How do I find Stock History?"
From Catalyst
Katy Kitchen (talk | contribs) |
|||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
== Summary == | == Summary == | ||
This article explains how to get the detailed history of any items of stock in the system. | This article explains how to get the detailed history of any items of stock in the system. | ||
| Line 9: | Line 7: | ||
** 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 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 which customer bought a particular item or items. | ||
| − | ** To find out | + | ** To find out from whom an item/items were purchased. |
** To find out which items were sold under a specific invoice number. | ** To find out which items were sold under a specific invoice number. | ||
| Line 16: | Line 14: | ||
* 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|text=These filters are optional, not | + | {{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|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 | + | {{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}}. | ||
== See also == | == See also == | ||
| − | |||
* [[How do I find a stock code?]] | * [[How do I find a stock code?]] | ||
| − | |||
| − | |||
* [[What is the Stock Period?]] | * [[What is the Stock Period?]] | ||
* [[How do I View Who Dealt with a Stock Item?]] | * [[How do I View Who Dealt with a Stock Item?]] | ||
Revision as of 21:52, 1 July 2015
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].
See also
