Difference between revisions of "How do I find Stock History?"

From Catalyst
Jump to: navigation, search
m (New page: == Summary == This article explains how to get the detailed history of any items of stock in the system. == More Information == Go to "Stock Control" -> "Stock Reports" -> "History Repor...)
 
 
(12 intermediate revisions by 5 users not shown)
Line 3: Line 3:
  
 
== More Information ==
 
== More Information ==
 +
This report can be used in several different ways, for example:
  
Go to "Stock Control" -> "Stock Reports" -> "History Reports" -> "Stock History".
+
** To find out how the current stock quantity has been calculated i.e. show all sales, purchases and adjustments for an item.
* 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.  
+
** 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.
  
{{Note|text=These filters are optional, not "Mandatory" fields and as such you do not have to fill in all of them, only the ones you need.}}
+
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 is also a drop down box at the top of the report headed '''"Movement Type"'''. This can be switched between the following options
+
{{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.}}
  
*All
+
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
*Sales
 
*Purchases
 
*Adjustments
 
  
These can be used in conjunction with the filters to make this a very flexible report.
+
* {{DataValue|All}}
 +
* {{DataValue|Sales}}
 +
* {{DataValue|Purchases}}
 +
* {{DataValue|Adjustments}}
  
{{Example|title=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 ''Purchases'' and this will give the required result.}}
+
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 {{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}}.
  
{{FAQ}}{{KB_Tags|Stock, History}}{{KB_ST}}
+
=== 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?]]
 +
* [[What is the Stock Period?]]
 +
* [[How do I View Who Dealt with a Stock Item?]]
 +
 
 +
{{KB_Tags|stock, history, sales, who bought, who purchased, previous purchase, stock take, previous sales, stock level, purchases, adjustments}}
 +
{{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


Feedback
Thank you for using our Knowledge Base, we value your feedback. Did you find this article useful? 'Yes' or 'No'
Keywords AND Misspellings
stock, history, sales, who bought, who purchased, previous purchase, stock take, previous sales, stock level, purchases, adjustments