Sage 200 Reports: Stock Control
Report 116 Price £POA
Aged Stock Balances – 7 columns – Custom
This ‘must have’ report allows you to monitor your stock levels and valuation by aged columns to quickly identify the slower moving items and if your money is tied up in stock that has not moved off the shelf for many months or years.
Each user will have different break points for the reported columns so the first five columns can be fixed by pre-set criteria and the sixth column can be set at run time so as to mark the start point (in days) for the final seventh column.
With this ‘moveable’ break point for column 7 the items captured in this column can be easily noted to have been in stock for at least the number of days entered.
Note: this report has the criteria for the warehouse fully functional – The standard Sage 200 Stock Valuation report only allows for the warehouse to be set as ALL or IS
This report has been formatted to ensure that when exported to Excel it is immediately available to be analysed further without the need to manipulate the output.
Search Values 1,2 and 3
Column 6 (Default = 210)
The pre-set columns are; 60, 90, 120, 150 and 180
Designed to output to
Printer (& PDF) – Y
Excel – Y
CSV – N
To purchase this report please contact your Sage 200 Business Partner or email email@example.com to send in your inquiry or purchase order.