Difference between revisions of "What Stock Reports should I run?"

From Catalyst
Jump to: navigation, search
Line 34: Line 34:
 
=== Order History Reports ===
 
=== Order History Reports ===
 
:This report shows the history of Sales and Purchase Orders that have been received into stock and subsequently been invoiced received and the order has purged. It will detail everything you need to track the order back to the Goods Received Note and the Stock History.
 
:This report shows the history of Sales and Purchase Orders that have been received into stock and subsequently been invoiced received and the order has purged. It will detail everything you need to track the order back to the Goods Received Note and the Stock History.
 +
 +
For more help running this report click [[How do I View Order History?|HERE}}
  
 
== See Also ==
 
== See Also ==
 
* [[How do I find Stock History?]]
 
* [[How do I find Stock History?]]
 
+
* [[How do I View Order History?]]
  
 
{{KB_Tags|stock reports, stock, reports, stk, rep, hist, history, profit, summary, order}}
 
{{KB_Tags|stock reports, stock, reports, stk, rep, hist, history, profit, summary, order}}
 
{{FAQ}} {{KB_ST}}
 
{{FAQ}} {{KB_ST}}

Revision as of 09:09, 8 October 2013

Summary

This article explains which stock reports are useful to most of our customers and where to find them.

More Information

Using our experience we have grouped together a list of useful reports that are widely used throughout our customer base. This selection of reports is designed to meet most of your needs.

Go into " Counter Operations Stock Control Reports".

Invoiced Stock Profit-Summary

This report shows the sales of parts between a date range broken down by Depot, Type (Retail|Internal|Warranty) and Stock Group, detailing the part number and description, Quantity sold, Total price, Average Price Sales Price, FIFO Cost, Profit and Profit Margin as a percentage.

Employee Profit Summary-Summary

This report shows the sales of parts between a date range broken down by Depot, Employee, Type (Retail|Internal|Warranty) and Stock Group, detailing the part number and description, Quantity sold, Total price, Average Price Sales Price, FIFO Cost, Profit and Profit Margin as a percentage.

Profit Summary (By Stock Group)

This report shows the sales of parts between a date range broken down by Stock Group, detailing the Quantity Sold, Retail, FIFO Cost, Profit.

Profit Summary (By Employee)

This report shows the sales of parts between a date range broken down by Employee, detailing the Quantity, Retail, FIFO Cost, Profit and Profit Margin as a percentage.
Valuation at a date - Summary
This report shows the valuation of stock broken down into stock group, detailing Stock Group and FIFO Cost Value.

History Reports

This is a very useful report/tool and is widely used. It is designed to interrogate the Stock History and give you detail of the three types of stock movements:-
  • Sales
  • Purchase
  • Adjustments
This report can be very useful to find out when an item was booked into stock or trace the sale of an item if you do not have a copy receipt. It is also be very useful to find out how the system is calculating the quantity in stock by looking at all movements.

For more help running this report click HERE

Order History Reports

This report shows the history of Sales and Purchase Orders that have been received into stock and subsequently been invoiced received and the order has purged. It will detail everything you need to track the order back to the Goods Received Note and the Stock History.

For more help running this report click [[How do I View Order History?|HERE}}

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 reports, stock, reports, stk, rep, hist, history, profit, summary, order